Fix ids_from_emails to ignore case in submitted emails

[platal.git] / upgrade / newdirectory-0.0.1 / 12_secteurs.sql

diff --git a/upgrade/newdirectory-0.0.1/12_secteurs.sql b/upgrade/newdirectory-0.0.1/12_secteurs.sql
index 799870c..77ecf36 100644 (file)
--- a/upgrade/newdirectory-0.0.1/12_secteurs.sql
+++ b/upgrade/newdirectory-0.0.1/12_secteurs.sql
@@ -1,42 +1,42 @@
 DROP TABLE IF EXISTS profile_job_sector_enum;
 
-CREATE TABLE IF NOT EXISTS profile_job_sector_enum (
+CREATE TABLE profile_job_sector_enum (
   id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT,
   name VARCHAR(256) NOT NULL DEFAULT '',
   PRIMARY KEY(id),
-  UNIQUE KEY(name)
-) CHARSET=utf8;
+  UNIQUE INDEX(name(128))
+) ENGINE=InnoDB, CHARSET=utf8;
 
 DROP TABLE IF EXISTS profile_job_subsector_enum;
 
-CREATE TABLE IF NOT EXISTS profile_job_subsector_enum (
+CREATE TABLE profile_job_subsector_enum (
   id TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
   sectorid TINYINT(2) UNSIGNED NOT NULL,
   flags SET('optgroup') DEFAULT '' NOT NULL,
   name VARCHAR(256) NOT NULL DEFAULT '',
   PRIMARY KEY(id)
-) CHARSET=utf8;
+) ENGINE=InnoDB, CHARSET=utf8;
 
 DROP TABLE IF EXISTS profile_job_subsubsector_enum;
 
-CREATE TABLE IF NOT EXISTS profile_job_subsubsector_enum (
+CREATE TABLE profile_job_subsubsector_enum (
   id SMALLINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
   sectorid TINYINT(2) UNSIGNED NOT NULL,
   subsectorid TINYINT(3) UNSIGNED NOT NULL,
   name VARCHAR(256) NOT NULL DEFAULT '',
   flags SET('display') NOT NULL DEFAULT 'display',
   PRIMARY KEY(id)
-) CHARSET=utf8;
+) ENGINE=InnoDB, CHARSET=utf8;
 
 DROP TABLE IF EXISTS profile_job_alternates;
 
-CREATE TABLE IF NOT EXISTS profile_job_alternates (
+CREATE TABLE profile_job_alternates (
   id TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   subsubsectorid SMALLINT(3) UNSIGNED NOT NULL,
   name VARCHAR(256) NOT NULL DEFAULT '',
   PRIMARY KEY(id, subsubsectorid),
-  UNIQUE KEY(name)
-) CHARSET=utf8;
+  UNIQUE INDEX(name(128))
+) ENGINE=InnoDB, CHARSET=utf8;
 
 
 ALTER TABLE profile_phones CHANGE COLUMN link_type link_type ENUM('address','pro','user', 'hq') NOT NULL DEFAULT 'user';