Commit | Line | Data |
---|---|---|
e18807a8 SJ |
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: |