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