X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F07_corps;h=f0b52d97f4a56080ffc09444e43d02ba7756643a;hb=429e4a4b8eb428e9631513fc6bb053b4635c7729;hp=50ed7d5f76f097f11eadc771ec42451f29d9b2c2;hpb=e8a898662eeafa5201082067a7aac46573884ebb;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/07_corps b/upgrade/newdirectory-0.0.1/07_corps
index 50ed7d5..f0b52d9 100644
--- 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: