From c9dfe47f1d5198e607728842124f06c89e869887 Mon Sep 17 00:00:00 2001
From: pedro_morgan <pedro_morgan@ispconfig3>
Date: Sun, 19 Aug 2007 19:47:35 -0400
Subject: [PATCH] WIP

---
 interface/sql/db_installer_sandbox/defs.mail_spam.php |  191 ++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 186 insertions(+), 5 deletions(-)

diff --git a/interface/sql/db_installer_sandbox/defs.mail_spam.php b/interface/sql/db_installer_sandbox/defs.mail_spam.php
index d463a92..fd7d08d 100644
--- a/interface/sql/db_installer_sandbox/defs.mail_spam.php
+++ b/interface/sql/db_installer_sandbox/defs.mail_spam.php
@@ -1,13 +1,23 @@
 <?php
 
-/* Down the page
-   * Mail related
-   * System related
-*/
-
 //*************************************************************************************
 // Mail Related
 //*************************************************************************************
+
+$tables['mail_access'] = "
+`access_id` int(11) NOT NULL AUTO PRIMARY,
+`sys_userid` int(11) NOTNULL DEFAULT '0',
+`sys_groupid` int(11) NOTNULL DEFAULT '0',
+`sys_perm_user` C(5) NOTNULL DEFAULT '',
+`sys_perm_group` C(5) NOTNULL DEFAULT '',
+`sys_perm_other` C(5) NOTNULL DEFAULT '',
+`server_id` I INDEX NOTNULL DEFAULT '0',
+`source` C(255) INDEX NOT NULL,
+`access` C(255) NOT NULL,
+`type` set('recipient','sender','client') NOT NULL,
+`active` enum('n','y') NOTNULL DEFAULT 'y'
+";
+
 
 $tables['mail_blacklist'] = "
 blacklist_id I NOTNULL AUTO PRIMARY,
@@ -43,6 +53,21 @@
 active enum('0','1') NOTNULL DEFAULT '1'
 ";
 
+$tables['mail_content_filter'] = "
+`content_filter_id` bigint(20) NOTNULL AUTO PRIMARY,
+`sys_userid` int(11) NOTNULL DEFAULT '0',
+`sys_groupid` int(11) NOTNULL DEFAULT '0',
+`sys_perm_user` C(5),
+`sys_perm_group` C(5),
+`sys_perm_other` C(5),
+`server_id` int(11) NOTNULL DEFAULT '0',
+`type` C(255),
+`pattern` C(255),
+`data` C(255),
+`action` C(255) ,
+`active` C(255) NOTNULL DEFAULT 'y'
+";
+
 $tables['mail_domain'] = "
 domain_id I NOTNULL AUTO PRIMARY,
 sys_userid I NOTNULL DEFAULT '0',
@@ -70,6 +95,36 @@
 active enum('0','1') NOTNULL DEFAULT '1'
 ";
 
+$tables['mail_forwarding'] = "
+`forwarding_id` int(11) NOTNULL AUTO PRIMARY,
+`sys_userid` int(11) NOTNULL DEFAULT '0',
+`sys_groupid` int(11) NOTNULL DEFAULT '0',
+`sys_perm_user` C(5) NOTNULL DEFAULT '',
+`sys_perm_group` C(5) NOTNULL DEFAULT '',
+`sys_perm_other` C(5) NOTNULL DEFAULT '',
+`server_id` I INDEX NOTNULL DEFAULT '0',
+`source` C(255) INDEX NOTNULL,
+`destination` C(255) NOTNULL DEFAULT '',
+`type` enum('alias','forward','catchall') NOTNULL DEFAULT 'alias',
+`active` enum('y','n') NOTNULL
+";
+ 
+$tables['mail_get'] = "
+`mailget_id` bigint(20) NOT NULL AUTO PRIMARY,
+`sys_userid` int(11) NOTNULL DEFAULT '0',
+`sys_groupid` int(11) NOTNULL DEFAULT '0',
+`sys_perm_user` C(5) ,
+`sys_perm_group` C(5) ,
+`sys_perm_other` C(5) ,
+`server_id` int(11) NOTNULL DEFAULT '0',
+`type` C(255) ,
+`source_server` C(255) ,
+`source_username` C(255) ,
+`source_password` C(255) ,
+`source_delete` C(255) NOTNULL DEFAULT 'y',
+`destination` C(255) ,
+`active` C(255) NOTNULL DEFAULT 'y'
+"
 
 $tables['mail_greylist'] = "
 greylist_id I NOTNULL AUTO PRIMARY,
@@ -123,6 +178,12 @@
 active enum('0','1') NOTNULL DEFAULT '1'
 ";
 
+$tables['mail_traffic'] = "
+`traffic_id` I NOTNULL AUTO PRIMARY,
+`mailuser_id` I NOTNULL,
+`month` C(7) INDEX NOTNULL,
+`traffic` bigint(20) unsigned NOT NULL
+";
 
 $tables['mail_transport'] = "
 transport_id I NOTNULL AUTO PRIMARY,
@@ -139,6 +200,29 @@
 active enum('0','1') NOTNULL DEFAULT '1'
 ";
 
+$tables['mail_user'] = "
+`mailuser_id` I NOTNULL AUTO PRIMARY,
+`sys_userid` I NOTNULL DEFAULT '0',
+`sys_groupid` I NOTNULL DEFAULT '0',
+`sys_perm_user` C(5) NOTNULL DEFAULT '',
+`sys_perm_group` C(5) NOTNULL DEFAULT '',
+`sys_perm_other` C(5) NOTNULL DEFAULT '',
+`server_id` I INDEX NOTNULL DEFAULT '0',
+`email` C(255) INDEX NOTNULL DEFAULT '',
+`password` C(255) NOTNULL,
+`name` C(128) NOTNULL DEFAULT '',
+`uid` int(10) unsigned NOTNULL DEFAULT '5000',
+`gid` int(10) unsigned NOTNULL DEFAULT '5000',
+`maildir` C(255) NOTNULL DEFAULT '',
+`quota` I NOTNULL,
+`homedir` C(255) NOTNULL,
+`autoresponder` enum('n','y') NOTNULL DEFAULT 'n',
+`autoresponder_text` tinytext NOTNULL,
+`custom_mailfilter` text,
+`postfix` enum('y','n') NOTNULL,
+`access` enum('y','n') NOTNULL
+";
+
 $tables['mail_whitelist'] = "
 whitelist_id I NOTNULL AUTO PRIMARY,
 sys_userid I NOTNULL DEFAULT '0',
@@ -150,6 +234,89 @@
 address C(255) NOTNULL DEFAULT '',
 recipient C(255) NOTNULL DEFAULT '',
 active enum('0','1') NOTNULL DEFAULT '1'
+";
+
+
+//*************************************************************************************
+// Spam spam spam spam, sing along..
+//*************************************************************************************
+
+$tables['spamfilter_policy'] = "
+`id` I NOTNULL AUTO PRIMARY,
+`sys_userid` I NOTNULL,
+`sys_groupid` I NOTNULL,
+`sys_perm_user` C(5) NOTNULL,
+`sys_perm_group` C(5) NOTNULL,
+`sys_perm_other` C(5) NOTNULL,
+`policy_name` C(32) ,
+`virus_lover` C(1) ,
+`spam_lover` C(1) ,
+`banned_files_lover` C(1) ,
+`bad_header_lover` C(1) ,
+`bypass_virus_checks` C(1) ,
+`bypass_spam_checks` C(1) ,
+`bypass_banned_checks` C(1) ,
+`bypass_header_checks` C(1) ,
+`spam_modifies_subj` C(1) ,
+`virus_quarantine_to` C(64) ,
+`spam_quarantine_to` C(64) ,
+`banned_quarantine_to` C(64) ,
+`bad_header_quarantine_to` C(64) ,
+`clean_quarantine_to` C(64) ,
+`other_quarantine_to` C(64) ,
+`spam_tag_level` F,
+`spam_tag2_level` F,
+`spam_kill_level` F,
+`spam_dsn_cutoff_level` F,
+`spam_quarantine_cutoff_level` F,
+`addr_extension_virus` C(64) ,
+`addr_extension_spam` C(64) ,
+`addr_extension_banned` C(64) ,
+`addr_extension_bad_header` C(64) ,
+`warnvirusrecip` C(1) ,
+`warnbannedrecip` C(1) ,
+`warnbadhrecip` C(1) ,
+`newvirus_admin` C(64) ,
+`virus_admin` C(64) ,
+`banned_admin` C(64) ,
+`bad_header_admin` C(64) ,
+`spam_admin` C(64) ,
+`spam_subject_tag` C(64) ,
+`spam_subject_tag2` C(64) ,
+`message_size_limit` I ,
+`banned_rulenames` C(64)
+";
+
+//TODO Unique index on email
+$tables['spamfilter_users'] = "
+`id` int(10) NOTNULL AUTO PRIMARY,
+`sys_userid` I NOTNULL,
+`sys_groupid` I NOTNULL,
+`sys_perm_user` C(5) NOTNULL,
+`sys_perm_group` C(5) NOTNULL,
+`sys_perm_other` C(5) NOTNULL,
+`server_id` int(10) unsigned NOTNULL,
+`priority` I NOTNULL DEFAULT '7',
+`policy_id` int(10) unsigned NOTNULL DEFAULT '1',
+`email` C(255) INDEX NOTNULL,
+`fullname` C(255) ,
+`local` char(1)
+";
+
+//TODO Enum
+$tables['spamfilter_wblist'] = "
+`wblist_id` I NOTNULL AUTO PRIMARY,
+`sys_userid` I NOTNULL,
+`sys_groupid` I NOTNULL,
+`sys_perm_user` C(5) NOTNULL,
+`sys_perm_group` C(5) NOTNULL,
+`sys_perm_other` C(5) NOTNULL,
+`server_id` int(10) unsigned NOTNULL,
+`wb` enum('W','B') NOTNULL DEFAULT 'W',
+`rid` int(10) unsigned NOTNULL,
+`email` C(255) NOTNULL,
+`priority` I NOTNULL,
+`active` enum('y','n') NOTNULL DEFAULT 'y'
 ";
 
 $tables['rr'] = "
@@ -186,6 +353,20 @@
 active tinyint(4) NOTNULL DEFAULT '1',
 ";
 
+
+$tables['server_ip'] = "
+`server_ip_id` bigint(20) NOTNULL AUTO PRIMARY,
+`sys_userid` I NOTNULL DEFAULT '0',
+`sys_groupid` I NOTNULL DEFAULT '0',
+`sys_perm_user` C(5) ,
+`sys_perm_group` C(5) ,
+`sys_perm_other` C(5) ,
+`server_id` int(10) unsigned NOTNULL DEFAULT '0',
+`ip_address` C(15) ,
+`virtualhost` C(1) NOTNULL DEFAULT 'y'
+";
+
+
 $tables['soa'] = "
 id int(10) unsigned NOTNULL AUTO PRIMARY,
 origin C(255) NOTNULL DEFAULT '',

--
Gitblit v1.9.1