| 1 | DROP TABLE IF EXISTS tmp_profile_medals; |
| 2 | CREATE TEMPORARY TABLE tmp_profile_medals LIKE profile_medals; |
| 3 | INSERT INTO tmp_profile_medals SELECT * FROM profile_medals; |
| 4 | DROP TABLE profile_medals; |
| 5 | CREATE TABLE profile_medals ( |
| 6 | pid INT(11) UNSIGNED NOT NULL DEFAULT 0, |
| 7 | mid INT(11) NOT NULL DEFAULT 0, |
| 8 | gid INT(11) NOT NULL DEFAULT 0, |
| 9 | PRIMARY KEY (pid, mid, gid), |
| 10 | CONSTRAINT profile_medals_ibfk_1 FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE |
| 11 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 12 | INSERT INTO profile_medals (pid, mid, gid) |
| 13 | SELECT pid, mid, gid |
| 14 | FROM tmp_profile_medals; |
| 15 | DROP TABLE IF EXISTS tmp_profile_medals; |
| 16 | |
| 17 | -- vim:set syntax=mysql: |