upgrade/newdirectory-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 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
  15 # vim:set syntax=mysql: