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 ) ENGINE=InnoDB, CHARSET=utf8;
  11
  12 -- vim:set syntax=mysql: