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)
+ 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,
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,
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)
+ UNIQUE INDEX(name(128))
) ENGINE=InnoDB, CHARSET=utf8;