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

# 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:
Commit	Line	Data
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
0be07aa6	16	# vim:set syntax=mysql: