1CREATE TEMPORARY TABLE ratingtemp ( 2 page, 3 rater, 4 lang, 5 date, 6 value, 7 PRIMARY KEY(page, rater) 8); 9 10INSERT INTO ratingtemp (page, rater, lang, date, value) SELECT page, rater, '', '', value FROM ratings; 11 12DROP TABLE ratings; 13 14CREATE TABLE ratings ( 15 page, 16 rater, 17 lang, 18 date, 19 value, 20 PRIMARY KEY(page, rater) 21); 22 23INSERT INTO ratings (page, rater, lang, date, value) SELECT page, rater, lang, date, value FROM ratingtemp; 24 25DROP TABLE ratingtemp; 26