1 DROP TABLE IF EXISTS profile_job_sector_enum
;
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 '',
10 DROP TABLE IF EXISTS profile_job_subsector_enum
;
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 '',
20 DROP TABLE IF EXISTS profile_job_subsubsector_enum
;
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 '',
27 flags
SET('display') NOT NULL DEFAULT 'display',
31 DROP TABLE IF EXISTS profile_job_alternates
;
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
),
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: