[platal.git] / upgrade / merge-0.0.1 / 06_merge_nationalities.sql

ALTER TABLE geoloc_pays ADD INDEX (license_plate);

   UPDATE  auth_user_md5    AS u
LEFT JOIN  fusionax_anciens AS f ON (u.matricule_ax = f.id_ancien)
LEFT JOIN  geoloc_pays      AS g ON (g.license_plate = f.Code_nationalite)
      SET  u.nationalite = g.a2
    WHERE  u.nationalite IS NULL;

   UPDATE  auth_user_md5    AS u
LEFT JOIN  fusionax_anciens AS f ON (u.matricule_ax = f.id_ancien)
LEFT JOIN  geoloc_pays      AS g ON (g.license_plate = f.Code_nationalite)
      SET  u.nationalite2 = g.a2
    WHERE  u.nationalite != g.a2 AND u.nationalite2 IS NULL;

   UPDATE  auth_user_md5    AS u
LEFT JOIN  fusionax_anciens AS f ON (u.matricule_ax = f.id_ancien)
LEFT JOIN  geoloc_pays      AS g ON (g.license_plate = f.Code_nationalite)
      SET  u.nationalite3 = g.a2
    WHERE  u.nationalite != g.a2 AND u.nationalite2 != g.a2 AND u.nationalite3 IS NULL;

ALTER TABLE geoloc_pays DROP INDEX (license_plate);

-- vim:set syntax=mysql:
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: