[platal.git] / upgrade / 0.10.0 / 02_emails.sql

# Rewrite protection

alter table emails add column hash varchar(32) default NULL;
alter table emails add column allow_rewrite boolean default false;
update emails set allow_rewrite = true where rewrite != '' and flags != 'filter';


# vim:set syntax=mysql:
Commit	Line	Data
3d17e48f FB	1	# Rewrite protection
	2
	3	alter table emails add column hash varchar(32) default NULL;
	4	alter table emails add column allow_rewrite boolean default false;
	5	update emails set allow_rewrite = true where rewrite != '' and flags != 'filter';
	6
	7
	8	# vim:set syntax=mysql: