CREATE TABLE `product_texts1` (
  `ProductID` int(10) UNSIGNED NOT NULL,
  `Language` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'bg',
  `Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `URLLabel` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) 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 `ProductID` IN (SELECT `ID` FROM `products1`);