projects / platal.git / blame
| 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: |