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

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  #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.pid)
       SET  d.promo = CONCAT("X", entry_year)
     WHERE  FIND_IN_SET('primary', e.flags);

-- vim:set syntax=mysql:
Commit	Line	Data
ce0b2c6f	1	INSERT INTO profile_education (id, pid, grad_year, entry_year, eduid, degreeid, flags)
aafd3025	2	SELECT 100, u.user_id, u.promo_sortie, u.promo, e.id, d.id, 'primary'
d0293d9b	3	FROM #x4dat#.auth_user_md5 AS u
aafd3025 SJ	4	LEFT JOIN profile_education_enum AS e ON (e.abbreviation = "X")
aafd3025 SJ	5	LEFT JOIN profile_education_degree_enum AS d ON (d.degree = "Ingénieur");
fb2c09c9	6
75036b0f	7	UPDATE profile_display AS d
ce0b2c6f	8	INNER JOIN profile_education AS e ON (d.pid = e.pid)
75036b0f SJ	9	SET d.promo = CONCAT("X", entry_year)
75036b0f SJ	10	WHERE FIND_IN_SET('primary', e.flags);
fb2c09c9 SJ	11
fb2c09c9 SJ	12	-- vim:set syntax=mysql: