CREATE TABLE `product_texts1` (
  `ProductID` int UNSIGNED NOT NULL,
  `Language` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'bg',
  `MetaTitle` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `MetaDescription` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `FooterLabel` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Colour` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `URLLabel` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Annotation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `Content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `Price` float(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
  `RadiationSensorPrice` float(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
  `PromoPrice` float(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
  `StartFrom` date DEFAULT NULL,
  `EndTo` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `product_texts1`
  ADD PRIMARY KEY (`ProductID`,`Language`),
  ADD KEY `PartID` (`ProductID`),
  ADD KEY `Language` (`Language`);


--------------------


INSERT INTO `product_texts1`
SELECT * FROM `product_texts` WHERE `Language` = 'en';


--------------------
-- de|dk|es|fr|it|pl

UPDATE `product_texts1` SET `Language` = 'de';

INSERT INTO `product_texts`
SELECT * FROM `product_texts1`;

UPDATE `product_texts1` SET `Language` = 'dk';

INSERT INTO `product_texts`
SELECT * FROM `product_texts1`;

UPDATE `product_texts1` SET `Language` = 'es';

INSERT INTO `product_texts`
SELECT * FROM `product_texts1`;

UPDATE `product_texts1` SET `Language` = 'fr';

INSERT INTO `product_texts`
SELECT * FROM `product_texts1`;

UPDATE `product_texts1` SET `Language` = 'it';

INSERT INTO `product_texts`
SELECT * FROM `product_texts1`;

UPDATE `product_texts1` SET `Language` = 'pl';

INSERT INTO `product_texts`
SELECT * FROM `product_texts1`;


--------------------


DROP TABLE `product_texts1`;