| 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 | |
| 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"; |
| 20 | |
| 21 | -- vim:set syntax=mysql: |