Creates profile_display before modifying it.

[platal.git] / upgrade / newdirectory-0.0.1 / 10_promotion.sql

diff --git a/upgrade/newdirectory-0.0.1/10_promotion.sql b/upgrade/newdirectory-0.0.1/10_promotion.sql
index 9eaaf28..785ce31 100644 (file)
--- a/upgrade/newdirectory-0.0.1/10_promotion.sql
+++ b/upgrade/newdirectory-0.0.1/10_promotion.sql
@@ -4,15 +4,9 @@ INSERT INTO  profile_education (id, uid, grad_year, entry_year, eduid, degreeid,
   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);
+REPLACE IGNORE INTO  profile_display (pid, promo)
+             SELECT  uid, CONCAT("X", entry_year)
+               FROM  profile_education
+              WHERE  FIND_IN_SET('primary', flags);
 
 -- vim:set syntax=mysql: