X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.14%2F01_auth_user_md5.sql;h=4037e64c6f98cc9a1bcfebc3a9c46a3aaa8e1b24;hb=6e7849b36ad6c0f8c39496ba92d96bc4937835ea;hp=41f068bcb10589fa5d4bf2379e5675474b9d0ef8;hpb=0be07aa610451e9c9e6f45425cae68eac31dbd7e;p=platal.git

diff --git a/upgrade/0.9.14/01_auth_user_md5.sql b/upgrade/0.9.14/01_auth_user_md5.sql
index 41f068b..4037e64 100644
--- a/upgrade/0.9.14/01_auth_user_md5.sql
+++ b/upgrade/0.9.14/01_auth_user_md5.sql
@@ -1,3 +1,16 @@
+# Security stuff
 alter table auth_user_md5 change flags flags set('femme', 'watch') not null;
+alter table auth_user_md5 add column naissance_ini date not null default '0000-00-00' after smtppass;
+
+# Deprecated stuff
+alter table auth_user_md5 drop column nom_ini_soundex;
+alter table auth_user_md5 drop column prenom_ini_soundex;
+alter table auth_user_md5 drop column appli;
+alter table auth_user_md5 drop column bits;
+
+# Advance search
+alter table auth_user_md5 add key nationalite(nationalite);
+alter table adresses add key country(country);
+alter table adresses add key region(region);
 
 # vim:set syntax=mysql: