1 DROP TABLE IF EXISTS profile_job_sector_enum
;
3 CREATE TABLE profile_job_sector_enum (
4 id TINYINT(2) UNSIGNED
NOT NULL AUTO_INCREMENT
,
5 name VARCHAR(256) NOT NULL DEFAULT '',
7 UNIQUE INDEX(name(128))
8 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
10 DROP TABLE IF EXISTS profile_job_subsector_enum
;
12 CREATE TABLE 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 '',
18 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
20 DROP TABLE IF EXISTS profile_job_subsubsector_enum
;
22 CREATE TABLE 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 '',
27 flags
SET('display') NOT NULL DEFAULT 'display',
29 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
31 DROP TABLE IF EXISTS profile_job_alternates
;
33 CREATE TABLE 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 INDEX(name(128))
39 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
42 ALTER TABLE profile_phones CHANGE
COLUMN link_type link_type
ENUM('address','pro','user', 'hq') NOT NULL DEFAULT 'user';
44 -- vim:set syntax=mysql: