UNIQUE KEY(abbreviation)
) CHARSET=utf8;
+ UPDATE profile_corps AS c
+INNER JOIN profile_corps_enum AS e ON (c.original_corpsid = e.id)
+ LEFT JOIN profile_corps_enum AS a ON (a.name = "Aucun (anc. démissionnaire)")
+ SET c.original_corpsid = a.id
+ WHERE e.name = "Ancien élève étranger";
+
+UPDATE profile_corps_enum
+ SET name = "Aucun"
+ WHERE name = "Aucun (anc. démissionnaire)";
+
+DELETE FROM profile_corps_enum
+ WHERE name = "Ancien élève étranger";
+
+
+ALTER TABLE watch_profile MODIFY field enum('nom', 'freetext', 'mobile', 'nationalite', 'nationalite2',
+ 'nationalite3', 'nick', 'web', 'networking', 'edus', 'addresses',
+ 'section', 'binets', 'medals', 'cv', 'jobs', 'photo', 'corps');
+
-- vim:set syntax=mysql: