Commit | Line | Data |
---|---|---|
72e96bc0 SJ |
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); | |
7 | ||
6920f8a6 SJ |
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"; | |
13 | ||
14 | UPDATE profile_corps_enum | |
15 | SET name = "Aucun" | |
16 | WHERE name = "Aucun (anc. démissionnaire)"; | |
17 | ||
18 | DELETE FROM profile_corps_enum | |
19 | WHERE name = "Ancien élève étranger"; | |
72e96bc0 SJ |
20 | |
21 | -- vim:set syntax=mysql: |