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