X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F10_promotion.sql;h=de629b4654ce4198f0abb8532bed7dc039efc8f7;hb=96d80a35f4abef2b94d2f2b8f5442230141398d1;hp=fb3b7b5ff1dcf9c2ac7f3eff8cadd6f1ad6e1446;hpb=cf81c359b80ad4280a0b3719e0a32c8adba2549d;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/10_promotion.sql b/upgrade/newdirectory-0.0.1/10_promotion.sql
index fb3b7b5..de629b4 100644
--- a/upgrade/newdirectory-0.0.1/10_promotion.sql
+++ b/upgrade/newdirectory-0.0.1/10_promotion.sql
@@ -1,16 +1,12 @@
 INSERT INTO  profile_education (id, uid, grad_year, entry_year, eduid, degreeid, flags)
-     SELECT  100, user_id, promo_sortie, promo, 20, 2, 'primary'
-       FROM  auth_user_md5;
+     SELECT  100, u.user_id, u.promo_sortie, u.promo, e.id, d.id, 'primary'
+       FROM  auth_user_md5                 AS u
+  LEFT JOIN  profile_education_enum        AS e ON (e.abbreviation = "X")
+  LEFT JOIN  profile_education_degree_enum AS d ON (d.degree = "Ingénieur");
 
-CREATE TABLE  profile_display (
-  uid INT(11) NOT NULL DEFAULT 0,
-  promo_display VARCHAR(255) DEFAULT '' NOT NULL,
-  PRIMARY KEY(uid)
-) CHARSET=utf8;
-
-INSERT IGNORE INTO  profile_display (uid, promo_display)
-            SELECT  uid, CONCAT("X", entry_year)
-              FROM  profile_education
-             WHERE  FIND_IN_SET('primary', flags);
+    UPDATE  profile_display   AS d
+INNER JOIN  profile_education AS e ON (d.pid = e.uid)
+       SET  d.promo = CONCAT("X", entry_year)
+     WHERE  FIND_IN_SET('primary', e.flags);
 
 -- vim:set syntax=mysql: