[platal.git] / upgrade / 1.1.0 / 10_deco.sql

DROP TABLE IF EXISTS tmp_profile_medals;
CREATE TEMPORARY TABLE tmp_profile_medals LIKE profile_medals;
INSERT INTO tmp_profile_medals SELECT * FROM profile_medals;
DROP TABLE profile_medals;
CREATE TABLE profile_medals (
  pid INT(11) UNSIGNED NOT NULL DEFAULT 0,
  mid INT(11) NOT NULL DEFAULT 0,
  gid INT(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (pid, mid, gid),
  CONSTRAINT profile_medals_ibfk_1 FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO  profile_medals (pid, mid, gid)
     SELECT  pid, mid, gid
       FROM  tmp_profile_medals;
DROP TABLE IF EXISTS tmp_profile_medals;

-- vim:set syntax=mysql:
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: