CREATE TABLE `reviews1` (
  `ID` int UNSIGNED NOT NULL,
  `Language` char(2) NOT NULL DEFAULT 'bg',
  `PostDate` datetime NOT NULL,
  `LastUpdate` datetime NOT NULL,
  `UploadID` bigint UNSIGNED NOT NULL DEFAULT '0',
  `Rate` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `Image` varchar(64) DEFAULT NULL,
  `FullName` varchar(64) DEFAULT NULL,
  `JobTitle` varchar(64) DEFAULT NULL,
  `Review` varchar(255) DEFAULT NULL,
  `Media` varchar(32) DEFAULT NULL,
  `MediaURL` text,
  `FirstPage` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `Visible` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

ALTER TABLE `reviews1`
  ADD PRIMARY KEY (`ID`,`Language`) USING BTREE;

INSERT INTO `reviews1`
SELECT * FROM `reviews` WHERE `Language` = 'en';


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

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

INSERT INTO `reviews`
SELECT * FROM `reviews1`;

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

INSERT INTO `reviews`
SELECT * FROM `reviews1`;

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

INSERT INTO `reviews`
SELECT * FROM `reviews1`;

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

INSERT INTO `reviews`
SELECT * FROM `reviews1`;

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

INSERT INTO `reviews`
SELECT * FROM `reviews1`;

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

INSERT INTO `reviews`
SELECT * FROM `reviews1`;


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


DROP TABLE `reviews1`;