Added columns for policyd in spamfilter_policy table.
| | |
| | | `message` text, |
| | | PRIMARY KEY (`client_message_template_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | ALTER TABLE `spamfilter_policy` ADD `policyd_quota_in` int(11) NOT NULL DEFAULT '-1', |
| | | ADD `policyd_quota_in_period` int(11) NOT NULL DEFAULT '24', |
| | | ADD `policyd_quota_out` int(11) NOT NULL DEFAULT '-1', |
| | | ADD `policyd_quota_out_period` int(11) NOT NULL DEFAULT '24', |
| | | ADD `policyd_greylist` ENUM( 'Y', 'N' ) NOT NULL DEFAULT 'N'; |
| | |
| | | `spam_subject_tag2` varchar(64) default NULL, |
| | | `message_size_limit` int(11) unsigned default NULL, |
| | | `banned_rulenames` varchar(64) default NULL, |
| | | `policyd_quota_in` int(11) NOT NULL DEFAULT '-1', |
| | | `policyd_quota_in_period` int(11) NOT NULL DEFAULT '24', |
| | | `policyd_quota_out` int(11) NOT NULL DEFAULT '-1', |
| | | `policyd_quota_out_period` int(11) NOT NULL DEFAULT '24', |
| | | `policyd_greylist` ENUM( 'Y', 'N' ) NOT NULL DEFAULT 'N', |
| | | PRIMARY KEY (`id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |