admin/emails/broken: remove trailing spaces after email addresses

[platal.git] / upgrade / 0.9.14 / 01_auth_user_md5.sql

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 (file)
--- 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: