Merge branch 'fusionax' into account

[platal.git] / upgrade / newdirectory-0.0.1 / 07_corps

diff --git a/upgrade/newdirectory-0.0.1/07_corps b/upgrade/newdirectory-0.0.1/07_corps
index 50ed7d5..f0b52d9 100644 (file)
--- a/upgrade/newdirectory-0.0.1/07_corps
+++ b/upgrade/newdirectory-0.0.1/07_corps
@@ -28,4 +28,22 @@ CREATE TABLE IF NOT EXISTS profile_corps_rank_enum (
   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: