mailpiler/util/db-upgrade-1.1.0-vs-1.2.0.sql at 30a4b8d7821168ea923b0a91a53e377a4fbe786f

Fork: 0

mpolo.team / mailpiler

Find file

Newer

Older

mailpiler / util / db-upgrade-1.1.0-vs-1.2.0.sql

SJ on 11 Mar 2015 526 bytes added body option for the rules check

Raw Blame History

-- 2015.03.10

alter table archiving_rule add column `body` varchar(128) default null;
alter table retention_rule add column `body` varchar(128) default null;

create unique index `entry` on archiving_rule (`domain`,`from`,`to`,`subject`,`body`,`_size`,`size`,`attachment_name`,`attachment_type`,`_attachment_size`,`attachment_size`,`spam`);
create unique index `entry` on retention_rule (`domain`,`from`,`to`,`subject`,`body`,`_size`,`size`,`attachment_name`,`attachment_type`,`_attachment_size`,`attachment_size`,`spam`);