[platal.git] / upgrade / merge-0.0.1 / 04_nationalities.sql

CREATE TEMPORARY TABLE IF NOT EXISTS tmp_update_fusionax_anciens (
  good CHAR(4) DEFAULT NULL,
  bad CHAR(4) DEFAULT NULL,
  PRIMARY KEY(bad),
  UNIQUE KEY(good)
) CHARSET=utf8;

INSERT IGNORE INTO  tmp_update_fusionax_anciens (bad, good)
            VALUES  ('TC', 'CAM'),
                    ('SH', 'CN'),
                    ('R', 'RO'),
                    ('TW', 'RC'),
                    ('TG', 'RT'),
                    ('U', 'ROU'),
                    ('KP', 'ROK'),
                    ('CRO', 'HR'),
                    ('UKR', 'UA'),
                    ('AM', 'ARM'),
                    ('CS', 'CZ'),
                    ('SU', 'RUS'),
                    ('LET', 'LV'),
                    ('MDA', 'MD');

    UPDATE  fusionax_anciens            AS f
INNER JOIN  tmp_update_fusionax_anciens AS t ON (f.Code_nationalite = t.bad)
       SET  f.Code_nationalite = t.good;

-- vim:set syntax=mysql:
Commit	Line	Data
	1	CREATE TEMPORARY TABLE IF NOT EXISTS tmp_update_fusionax_anciens (
	2	good CHAR(4) DEFAULT NULL,
	3	bad CHAR(4) DEFAULT NULL,
	4	PRIMARY KEY(bad),
	5	UNIQUE KEY(good)
	6	) CHARSET=utf8;
	7
	8	INSERT IGNORE INTO tmp_update_fusionax_anciens (bad, good)
	9	VALUES ('TC', 'CAM'),
	10	('SH', 'CN'),
	11	('R', 'RO'),
	12	('TW', 'RC'),
	13	('TG', 'RT'),
	14	('U', 'ROU'),
	15	('KP', 'ROK'),
	16	('CRO', 'HR'),
	17	('UKR', 'UA'),
	18	('AM', 'ARM'),
	19	('CS', 'CZ'),
	20	('SU', 'RUS'),
	21	('LET', 'LV'),
	22	('MDA', 'MD');
	23
	24	UPDATE fusionax_anciens AS f
	25	INNER JOIN tmp_update_fusionax_anciens AS t ON (f.Code_nationalite = t.bad)
	26	SET f.Code_nationalite = t.good;
	27
	28	-- vim:set syntax=mysql: