upgrade/0.9.14/01_auth_user_md5.sql

   1 # Security stuff
   2 alter table auth_user_md5 change flags flags set('femme', 'watch') not null;
   3 alter table auth_user_md5 add column naissance_ini date not null default '0000-00-00' after smtppass;
   4
   5 # Deprecated stuff
   6 alter table auth_user_md5 drop column nom_ini_soundex;
   7 alter table auth_user_md5 drop column prenom_ini_soundex;
   8 alter table auth_user_md5 drop column appli;
   9 alter table auth_user_md5 drop column bits;
  10
  11 # Advance search
  12 alter table auth_user_md5 add key nationalite(nationalite);
  13 alter table adresses add key country(country);
  14 alter table adresses add key region(region);
  15
  16 # vim:set syntax=mysql: