Commit | Line | Data |
---|---|---|
b8ed94e9 SJ |
1 | ALTER TABLE geoloc_pays ADD INDEX (license_plate); |
2 | ||
3 | UPDATE auth_user_md5 AS u | |
4 | LEFT JOIN fusionax_anciens AS f ON (u.matricule_ax = f.id_ancien) | |
5 | LEFT JOIN geoloc_pays AS g ON (g.license_plate = f.Code_nationalite) | |
6 | SET u.nationalite = g.a2 | |
7 | WHERE u.nationalite IS NULL; | |
8 | ||
9 | UPDATE auth_user_md5 AS u | |
10 | LEFT JOIN fusionax_anciens AS f ON (u.matricule_ax = f.id_ancien) | |
11 | LEFT JOIN geoloc_pays AS g ON (g.license_plate = f.Code_nationalite) | |
12 | SET u.nationalite2 = g.a2 | |
13 | WHERE u.nationalite != g.a2 AND u.nationalite2 IS NULL; | |
14 | ||
15 | UPDATE auth_user_md5 AS u | |
16 | LEFT JOIN fusionax_anciens AS f ON (u.matricule_ax = f.id_ancien) | |
17 | LEFT JOIN geoloc_pays AS g ON (g.license_plate = f.Code_nationalite) | |
18 | SET u.nationalite3 = g.a2 | |
19 | WHERE u.nationalite != g.a2 AND u.nationalite2 != g.a2 AND u.nationalite3 IS NULL; | |
20 | ||
21 | ALTER TABLE geoloc_pays DROP INDEX (license_plate); | |
22 | ||
23 | -- vim:set syntax=mysql: |