[platal.git] / upgrade / 1.0.1 / 15_merge_issues.sql

DROP TABLE IF EXISTS profile_merge_issues;
CREATE TABLE IF NOT EXISTS profile_merge_issues (
  pid INT(11) UNSIGNED DEFAULT NULL,
  issues SET('name', 'job', 'address', 'promo', 'deathdate', 'phone', 'education') DEFAULT NULL,
  entry_year_ax INT(4) DEFAULT NULL,
  deathdate_ax DATE DEFAULT NULL,
  name VARCHAR(255) DEFAULT NULL,
  name_type TINYINT(2) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (pid),
  FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB, CHARSET=utf8;

-- vim:set syntax=mysql:
Commit	Line	Data
e7a48239 SJ	1	DROP TABLE IF EXISTS profile_merge_issues;
	2	CREATE TABLE IF NOT EXISTS profile_merge_issues (
	3	pid INT(11) UNSIGNED DEFAULT NULL,
	4	issues SET('name', 'job', 'address', 'promo', 'deathdate', 'phone', 'education') DEFAULT NULL,
	5	entry_year_ax INT(4) DEFAULT NULL,
	6	deathdate_ax DATE DEFAULT NULL,
	7	name VARCHAR(255) DEFAULT NULL,
	8	name_type TINYINT(2) UNSIGNED DEFAULT NULL,
ee120a76 SJ	9	PRIMARY KEY (pid),
ee120a76 SJ	10	FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE
e7a48239 SJ	11	) ENGINE=InnoDB, CHARSET=utf8;
	12
	13	-- vim:set syntax=mysql: