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/ispconfig3.sql | 5 +++++ install/sql/incremental/upd_0063.sql | 7 ++++++- 2 files changed, 11 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 diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index 5dcd4bb..e6e99ba 100644 --- a/install/sql/ispconfig3.sql +++ b/install/sql/ispconfig3.sql @@ -1377,6 +1377,11 @@ `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 ; -- Gitblit v1.9.1