[platal.git] / upgrade / newdirectory-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";

ALTER TABLE watch_profile MODIFY field enum('nom', 'freetext', 'mobile', 'nationalite', 'nationalite2', 'nationalite3',
                                            'nick', 'web', 'networking', 'appli1', 'appli2', 'addresses',
                                            'section', 'binets', 'medals', 'cv', 'jobs', 'photo');

# 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
3a703848 SJ	11	ALTER TABLE watch_profile MODIFY field enum('nom', 'freetext', 'mobile', 'nationalite', 'nationalite2', 'nationalite3',
	12	'nick', 'web', 'networking', 'appli1', 'appli2', 'addresses',
	13	'section', 'binets', 'medals', 'cv', 'jobs', 'photo');
	14
8450c2aa	15	# vim:set syntax=mysql: