ecc734a5 |
1 | # Security stuff |
0be07aa6 |
2 | alter table auth_user_md5 change flags flags set('femme', 'watch') not null; |
ecc734a5 |
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 |
b536b5ae |
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); |
0be07aa6 |
15 | |
16 | # vim:set syntax=mysql: |