From 08462d0f49737d258ecd9d1010c2e510534a62d8 Mon Sep 17 00:00:00 2001 From: Till Brehm <tbrehm@ispconfig.org> Date: Wed, 22 Jan 2014 15:12:38 -0500 Subject: [PATCH] Added columns for policyd in spamfilter_policy table. --- install/sql/incremental/upd_0063.sql | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git a/install/sql/incremental/upd_0063.sql b/install/sql/incremental/upd_0063.sql index 77baa0e..04e1daa 100644 --- a/install/sql/incremental/upd_0063.sql +++ b/install/sql/incremental/upd_0063.sql @@ -12,4 +12,9 @@ `subject` varchar(255) DEFAULT NULL, `message` text, PRIMARY KEY (`client_message_template_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; \ No newline at end of file +) 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'; \ No newline at end of file -- Gitblit v1.9.1