| 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: |