X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.14%2F01_auth_user_md5.sql;h=4037e64c6f98cc9a1bcfebc3a9c46a3aaa8e1b24;hb=2079bd05a1f8ac0f204ba04c1776c25e78ac78d3;hp=ab99ab210462864729fb1e4051b0a8c5afec91e0;hpb=b536b5ae1e894669fb43d17d467ab1f0da4b75a1;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 ab99ab2..4037e64 100644
--- a/upgrade/0.9.14/01_auth_user_md5.sql
+++ b/upgrade/0.9.14/01_auth_user_md5.sql
@@ -1,4 +1,14 @@
+# 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);