Commit | Line | Data |
---|---|---|
c7139c07 SJ |
1 | DROP TABLE IF EXISTS profile_job_sector_enum; |
2 | ||
3 | CREATE TABLE IF NOT EXISTS profile_job_sector_enum ( | |
4 | id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT, | |
5 | name VARCHAR(256) NOT NULL DEFAULT '', | |
c7139c07 SJ |
6 | PRIMARY KEY(id), |
7 | UNIQUE KEY(name) | |
8 | ) CHARSET=utf8; | |
9 | ||
c7139c07 SJ |
10 | DROP TABLE IF EXISTS profile_job_subsector_enum; |
11 | ||
12 | CREATE TABLE IF NOT EXISTS profile_job_subsector_enum ( | |
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 SJ |
17 | PRIMARY KEY(id) |
18 | ) CHARSET=utf8; | |
19 | ||
c7139c07 SJ |
20 | DROP TABLE IF EXISTS profile_job_subsubsector_enum; |
21 | ||
22 | CREATE TABLE IF NOT EXISTS profile_job_subsubsector_enum ( | |
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) |
c7139c07 SJ |
29 | ) CHARSET=utf8; |
30 | ||
761f1bcb | 31 | DROP TABLE IF EXISTS profile_job_alternates; |
c7139c07 | 32 | |
761f1bcb SJ |
33 | CREATE TABLE IF NOT EXISTS profile_job_alternates ( |
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), | |
38 | UNIQUE KEY(name) | |
39 | ) 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: |