abbreviation VARCHAR(255) DEFAULT '' NOT NULL,
level TINYINT (1) UNSIGNED DEFAULT 0 NOT NULL,
PRIMARY KEY(id),
- UNIQUE KEY(degree),
- UNIQUE KEY(abbreviation)
+ UNIQUE KEY(degree)
) CHARSET=utf8;
CREATE TABLE IF NOT EXISTS profile_education_degree (
url VARCHAR(255) DEFAULT NULL,
country CHAR(2) NOT NULL DEFAULT 'FR',
PRIMARY KEY(id),
- UNIQUE KEY(name),
- UNIQUE KEY(IF(abbreviation = '', name, abbreviation))
+ UNIQUE KEY(name)
) CHARSET=utf8;
CREATE TABLE IF NOT EXISTS profile_education (
grad_year INT(4) DEFAULT NULL,
program VARCHAR(255) DEFAULT NULL,
flags SET('primary') DEFAULT '' NOT NULL,
- PRIMARY KEY(id, uid)
+ PRIMARY KEY(id, uid),
+ INDEX uid (uid)
) CHARSET=utf8;
INSERT INTO profile_education_field_enum (field)