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