upgrade/1.1.0/10_deco.sql

   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: