| 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: |