Merge branch 'fusionax' into account
[platal.git] / upgrade / newdirectory-0.0.1 / 12_secteurs.sql
... / ...
CommitLineData
1DROP TABLE IF EXISTS profile_job_sector_enum;
2
3CREATE TABLE IF NOT EXISTS profile_job_sector_enum (
4 id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT,
5 name VARCHAR(256) NOT NULL DEFAULT '',
6 PRIMARY KEY(id),
7 UNIQUE KEY(name)
8) CHARSET=utf8;
9
10DROP TABLE IF EXISTS profile_job_subsector_enum;
11
12CREATE 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 '',
17 PRIMARY KEY(id)
18) CHARSET=utf8;
19
20DROP TABLE IF EXISTS profile_job_subsubsector_enum;
21
22CREATE 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',
28 PRIMARY KEY(id)
29) CHARSET=utf8;
30
31DROP TABLE IF EXISTS profile_job_alternates;
32
33CREATE 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;
40
41
42ALTER TABLE profile_phones CHANGE COLUMN link_type link_type ENUM('address','pro','user', 'hq') NOT NULL DEFAULT 'user';
43
44-- vim:set syntax=mysql: