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
)
14 FROM tmp_profile_medals
;
15 DROP TABLE IF EXISTS tmp_profile_medals
;
17 -- vim:set syntax=mysql: