X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F10_promotion.sql;h=7dec54d9461c9a9d32037f89340a56838d70d62a;hb=304cdf32d7c38afbd381909545021fc44c8a0e05;hp=de629b4654ce4198f0abb8532bed7dc039efc8f7;hpb=d66464d5ea0a69c47f2f49ace9de2f4b7b8c4d62;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/10_promotion.sql b/upgrade/newdirectory-0.0.1/10_promotion.sql
index de629b4..7dec54d 100644
--- a/upgrade/newdirectory-0.0.1/10_promotion.sql
+++ b/upgrade/newdirectory-0.0.1/10_promotion.sql
@@ -1,11 +1,11 @@
-INSERT INTO  profile_education (id, uid, grad_year, entry_year, eduid, degreeid, flags)
+INSERT INTO  profile_education (id, pid, grad_year, entry_year, eduid, degreeid, flags)
      SELECT  100, u.user_id, u.promo_sortie, u.promo, e.id, d.id, 'primary'
-       FROM  auth_user_md5                 AS u
+       FROM  #x4dat#.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");
 
     UPDATE  profile_display   AS d
-INNER JOIN  profile_education AS e ON (d.pid = e.uid)
+INNER JOIN  profile_education AS e ON (d.pid = e.pid)
        SET  d.promo = CONCAT("X", entry_year)
      WHERE  FIND_IN_SET('primary', e.flags);