upgrade/newdirectory-0.0.1/12_secteurs.sql

   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 '',
   6   PRIMARY KEY(id),
   7   UNIQUE KEY(name)
   8 ) CHARSET=utf8;
   9
  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 '',
  17   PRIMARY KEY(id)
  18 ) CHARSET=utf8;
  19
  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 '',
  27   flags SET('display') NOT NULL DEFAULT 'display',
  28   PRIMARY KEY(id)
  29 ) CHARSET=utf8;
  30
  31 DROP TABLE IF EXISTS profile_job_alternates;
  32
  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;
  40
  41
  42 ALTER TABLE profile_phones CHANGE COLUMN link_type link_type ENUM('address','pro','user', 'hq') NOT NULL DEFAULT 'user';
  43
  44 -- vim:set syntax=mysql: