1 INSERT IGNORE INTO profile_corps (uid
, original_corpsid
, current_corpsid
, rankid
, corps_pub
)
2 SELECT u.user_id
, c.
id, c.
id, r.
id, 'ax'
3 FROM auth_user_md5
AS u
4 INNER JOIN fusionax_anciens
AS f
ON (u.matricule_ax
= f.id_ancien
)
5 INNER JOIN profile_corps_enum
AS c
ON (f.corps_sortie
= c.abbreviation
)
6 INNER JOIN profile_corps_rank_enum
AS r
ON (f.grade
= r.abbreviation
);
8 UPDATE profile_corps
AS c
9 INNER JOIN profile_corps_enum
AS e
ON (c.original_corpsid
= e.
id)
10 LEFT JOIN profile_corps_enum
AS a
ON (a.
name = "Aucun (anc. démissionnaire)")
11 SET c.original_corpsid
= a.
id
12 WHERE e.
name = "Ancien élève étranger";
14 UPDATE profile_corps_enum
16 WHERE name = "Aucun (anc. démissionnaire)";
18 DELETE FROM profile_corps_enum
19 WHERE name = "Ancien élève étranger";
21 -- vim:set syntax=mysql: