upgrade/1.0.1/15_merge_issues.sql

   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,
   9   PRIMARY KEY (pid),
  10   FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE
  11 ) ENGINE=InnoDB, CHARSET=utf8;
  12
  13 -- vim:set syntax=mysql: