upgrade/1.1.0/06_language.sql

   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: