[platal.git] / upgrade / 0.10.0 / 01_nat.sql

alter table geoloc_pays change column nat nat varchar(100);
update geoloc_pays
   set nat = NULL
 where a2 = 'MQ' or a2 = 'RE' or a2 = 'GP' or a2 = 'YT' or a2 = 'TF' or a2 = 'PF' or a2 = 'NC' or a2 = 'GF'
       or a2 = 'UM';
update auth_user_md5 set nationalite = 'FR' where nationalite = 'MQ' or nationalite = 'RE' or nationalite = 'GP' or nationalite = 'YT' or nationalite = 'TF' or nationalite = 'PF' or nationalite = 'NC' or nationalite = 'GF';

# vim:set syntax=mysql:
Commit	Line	Data
cc343083 FB	1	alter table geoloc_pays change column nat nat varchar(100);
	2	update geoloc_pays
	3	set nat = NULL
	4	where a2 = 'MQ' or a2 = 'RE' or a2 = 'GP' or a2 = 'YT' or a2 = 'TF' or a2 = 'PF' or a2 = 'NC' or a2 = 'GF'
	5	or a2 = 'UM';
	6	update auth_user_md5 set nationalite = 'FR' where nationalite = 'MQ' or nationalite = 'RE' or nationalite = 'GP' or nationalite = 'YT' or nationalite = 'TF' or nationalite = 'PF' or nationalite = 'NC' or nationalite = 'GF';
	7
	8	# vim:set syntax=mysql: