upgrade/fusionax-0.0.1/05_nationalities.sql

   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: