1 INSERT INTO profile_education (id, uid
, grad_year
, entry_year
, eduid
, degreeid
, flags
)
2 SELECT 100, u.user_id
, u.promo_sortie
, u.promo
, e.
id, d.
id, 'primary'
3 FROM auth_user_md5
AS u
4 LEFT JOIN profile_education_enum
AS e
ON (e.abbreviation
= "X")
5 LEFT JOIN profile_education_degree_enum
AS d
ON (d.
degree = "Ingénieur");
7 CREATE TABLE profile_display (
8 uid
INT(11) NOT NULL DEFAULT 0,
9 promo_display
VARCHAR(255) DEFAULT '' NOT NULL,
13 INSERT IGNORE INTO profile_display (uid
, promo_display
)
14 SELECT uid
, CONCAT("X", entry_year
)
15 FROM profile_education
16 WHERE FIND_IN_SET('primary', flags
);
18 -- vim:set syntax=mysql: