| 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: |