Commit | Line | Data |
---|---|---|
43c653a1 SJ |
1 | UPDATE profile_langskill_enum SET id = SUBSTRING(id, 1, 3); |
2 | ALTER TABLE profile_langskills DROP FOREIGN KEY profile_langskills_ibfk_2; | |
3 | ALTER TABLE profile_langskill_enum CHANGE COLUMN id iso_639_2b CHAR(3) NOT NULL DEFAULT ''; | |
4 | ALTER TABLE profile_langskills ADD FOREIGN KEY (lid) REFERENCES profile_langskill_enum (iso_639_2b) ON DELETE CASCADE ON UPDATE CASCADE; | |
5 | ALTER TABLE profile_langskill_enum ADD COLUMN iso_639_2t CHAR(3) NOT NULL DEFAULT ''; | |
6 | ALTER TABLE profile_langskill_enum ADD COLUMN iso_639_1 CHAR(2) DEFAULT NULL; | |
7 | ALTER TABLE profile_langskill_enum CHANGE COLUMN langue_en language_en VARCHAR(255) NOT NULL DEFAULT ''; | |
8 | ALTER TABLE profile_langskill_enum CHANGE COLUMN langue_fr language VARCHAR(255) NOT NULL DEFAULT ''; | |
9 | ALTER TABLE profile_langskill_enum ADD KEY (iso_639_2t); | |
10 | ALTER TABLE profile_langskill_enum ADD KEY (iso_639_1); | |
11 | ||
12 | -- vim:set syntax=mysql: |