upgrade/0.10.0/01_nat.sql

   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: