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, | |
9 | PRIMARY KEY (pid) | |
10 | ) ENGINE=InnoDB, CHARSET=utf8; | |
11 | ||
12 | -- vim:set syntax=mysql: |