Commit | Line | Data |
---|---|---|
c7139c07 SJ |
1 | DROP TABLE IF EXISTS profile_job_sector_enum; |
2 | ||
d0293d9b | 3 | CREATE TABLE profile_job_sector_enum ( |
c7139c07 SJ |
4 | id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT, |
5 | name VARCHAR(256) NOT NULL DEFAULT '', | |
c7139c07 | 6 | PRIMARY KEY(id), |
d0293d9b | 7 | UNIQUE INDEX(name(128)) |
950bf4f6 | 8 | ) ENGINE=InnoDB, CHARSET=utf8; |
c7139c07 | 9 | |
c7139c07 SJ |
10 | DROP TABLE IF EXISTS profile_job_subsector_enum; |
11 | ||
d0293d9b | 12 | CREATE TABLE profile_job_subsector_enum ( |
c7139c07 SJ |
13 | id TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT, |
14 | sectorid TINYINT(2) UNSIGNED NOT NULL, | |
15 | flags SET('optgroup') DEFAULT '' NOT NULL, | |
16 | name VARCHAR(256) NOT NULL DEFAULT '', | |
c7139c07 | 17 | PRIMARY KEY(id) |
950bf4f6 | 18 | ) ENGINE=InnoDB, CHARSET=utf8; |
c7139c07 | 19 | |
c7139c07 SJ |
20 | DROP TABLE IF EXISTS profile_job_subsubsector_enum; |
21 | ||
d0293d9b | 22 | CREATE TABLE profile_job_subsubsector_enum ( |
c7139c07 SJ |
23 | id SMALLINT(3) UNSIGNED NOT NULL AUTO_INCREMENT, |
24 | sectorid TINYINT(2) UNSIGNED NOT NULL, | |
25 | subsectorid TINYINT(3) UNSIGNED NOT NULL, | |
26 | name VARCHAR(256) NOT NULL DEFAULT '', | |
53390175 | 27 | flags SET('display') NOT NULL DEFAULT 'display', |
761f1bcb | 28 | PRIMARY KEY(id) |
950bf4f6 | 29 | ) ENGINE=InnoDB, CHARSET=utf8; |
c7139c07 | 30 | |
761f1bcb | 31 | DROP TABLE IF EXISTS profile_job_alternates; |
c7139c07 | 32 | |
d0293d9b | 33 | CREATE TABLE profile_job_alternates ( |
761f1bcb SJ |
34 | id TINYINT(2) UNSIGNED NOT NULL DEFAULT 0, |
35 | subsubsectorid SMALLINT(3) UNSIGNED NOT NULL, | |
36 | name VARCHAR(256) NOT NULL DEFAULT '', | |
37 | PRIMARY KEY(id, subsubsectorid), | |
d0293d9b | 38 | UNIQUE INDEX(name(128)) |
950bf4f6 | 39 | ) ENGINE=InnoDB, CHARSET=utf8; |
c7139c07 | 40 | |
b814a8b8 SJ |
41 | |
42 | ALTER TABLE profile_phones CHANGE COLUMN link_type link_type ENUM('address','pro','user', 'hq') NOT NULL DEFAULT 'user'; | |
43 | ||
c7139c07 | 44 | -- vim:set syntax=mysql: |