[platal.git] / upgrade / fusionax-0.0.1 / 05_nationalities.sql

ALTER TABLE auth_user_md5 ADD COLUMN nationalite2 CHAR(2) DEFAULT NULL,
                          ADD COLUMN nationalite3 CHAR(2) DEFAULT NULL,
                          ADD KEY nationalite2 (nationalite2),
                          ADD KEY nationalite3 (nationalite3),
                          MODIFY nationalite CHAR(2) DEFAULT NULL;

UPDATE auth_user_md5 SET nationalite=NULL WHERE nationalite="00" OR nationalite='';

DELETE FROM geoloc_pays WHERE a2="00";

# vim:set syntax=mysql:
Commit	Line	Data
8450c2aa SJ	1	ALTER TABLE auth_user_md5 ADD COLUMN nationalite2 CHAR(2) DEFAULT NULL,
	2	ADD COLUMN nationalite3 CHAR(2) DEFAULT NULL,
	3	ADD KEY nationalite2 (nationalite2),
	4	ADD KEY nationalite3 (nationalite3),
	5	MODIFY nationalite CHAR(2) DEFAULT NULL;
	6
	7	UPDATE auth_user_md5 SET nationalite=NULL WHERE nationalite="00" OR nationalite='';
	8
	9	DELETE FROM geoloc_pays WHERE a2="00";
	10
	11	# vim:set syntax=mysql: