upgrade/merge-0.0.1/06_merge_nationalities.sql

   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: