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.system.php                    |    8 
 interface/sql/db_installer_sandbox/defs.ftp_servers_sites_domains.php |   32 ++++++
 interface/sql/db_installer_sandbox/defs.mail_spam.php                 |  191 +++++++++++++++++++++++++++++++++++++-
 interface/sql/db_installer_sandbox/defs.resellers_clients.php         |   42 ++++++++
 4 files changed, 264 insertions(+), 9 deletions(-)

diff --git a/interface/sql/db_installer_sandbox/defs.ftp_servers_sites_domains.php b/interface/sql/db_installer_sandbox/defs.ftp_servers_sites_domains.php
new file mode 100644
index 0000000..f84b3f1
--- /dev/null
+++ b/interface/sql/db_installer_sandbox/defs.ftp_servers_sites_domains.php
@@ -0,0 +1,32 @@
+<?php
+
+
+
+$tables['web_domain'] = "
+  `domain_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` I NOTNULL DEFAULT '0',
+  `ip_address` C(15) ,
+  `domain` C(255) ,
+  `type` C(255) NOTNULL DEFAULT 'y',
+  `parent_domain_id` I NOTNULL DEFAULT '0',
+  `vhost_type` C(255) ,
+  `document_root` C(255) ,
+  `system_user` C(255) ,
+  `system_group` C(255) ,
+  `hd_quota` I NOTNULL DEFAULT '0',
+  `traffic_quota` I NOTNULL DEFAULT '0',
+  `cgi` C(255) NOTNULL DEFAULT 'y',
+  `ssi` C(255) NOTNULL DEFAULT 'y',
+  `suexec` C(255) NOTNULL DEFAULT 'y',
+  `php` C(255) NOTNULL DEFAULT 'y',
+  `redirect_type` C(255) ,
+  `redirect_path` C(255) ,
+  `active` C(255) NOTNULL DEFAULT 'y',
+  PRIMARY KEY  (`domain_id`)
+)  ;
+?>
\ No newline at end of file
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 '',
diff --git a/interface/sql/db_installer_sandbox/defs.resellers_clients.php b/interface/sql/db_installer_sandbox/defs.resellers_clients.php
index 80dae84..d96247d 100644
--- a/interface/sql/db_installer_sandbox/defs.resellers_clients.php
+++ b/interface/sql/db_installer_sandbox/defs.resellers_clients.php
@@ -4,6 +4,48 @@
 //*************************************************************************************
 // Resellers, clients etc
 //*************************************************************************************
+$tables['client'] = "
+`client_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),
+`company_name` C(255),
+`contact_name` C(255),
+`street` C(255),
+`zip` C(255),
+`city` C(255),
+`state` C(255),
+`country` C(255),
+`telephone` C(255),
+`mobile` C(255),
+`fax` C(255),
+`email` C(255),
+`internet` C(255) NOTNULL DEFAULT 'http://',
+`icq` C(255),
+`notes` text,
+`default_mailserver` int(11) NOTNULL DEFAULT '1',
+`limit_maildomain` int(11) NOTNULL DEFAULT '-1',
+`limit_mailbox` int(11) NOTNULL DEFAULT '-1',
+`limit_mailalias` int(11) NOTNULL DEFAULT '-1',
+`limit_mailforward` int(11) NOTNULL DEFAULT '-1',
+`limit_mailcatchall` int(11) NOTNULL DEFAULT '-1',
+`limit_mailrouting` int(11) NOTNULL DEFAULT '0',
+`limit_mailfilter` int(11) NOTNULL DEFAULT '-1',
+`limit_fetchmail` int(11) NOTNULL DEFAULT '-1',
+`limit_mailquota` int(11) NOTNULL DEFAULT '-1',
+`limit_spamfilter_wblist` int(11) NOTNULL DEFAULT '0',
+`limit_spamfilter_user` int(11) NOTNULL DEFAULT '0',
+`limit_spamfilter_policy` int(11) NOTNULL DEFAULT '0',
+`default_webserver` int(11) NOT NULL,
+`limit_web_ip` text NOT NULL,
+`username` C(255) ,
+`password` C(255) ,
+`language` C(255) NOTNULL DEFAULT 'en',
+`usertheme` C(255) NOTNULL DEFAULT 'default'
+"; 
+
 
 $tables['reseller'] = "
 reseller_id bigint(20) NOTNULL AUTO PRIMARY,
diff --git a/interface/sql/db_installer_sandbox/defs.system.php b/interface/sql/db_installer_sandbox/defs.system.php
index c1e9406..f07401a 100644
--- a/interface/sql/db_installer_sandbox/defs.system.php
+++ b/interface/sql/db_installer_sandbox/defs.system.php
@@ -5,14 +5,14 @@
 //*************************************************************************************
 
 $tables['sys_datalog'] = "
-datalog_id bigint(20) NOTNULL AUTO PRIMARY,
+datalog_id I8 NOTNULL AUTO PRIMARY,
+server_id I NOTNULL,
 dbtable C(255) NOTNULL DEFAULT '',
 dbidx C(255) NOTNULL DEFAULT '',
-server_id I NOTNULL DEFAULT '0',
 action char(1) NOTNULL DEFAULT '',
-tstamp bigint(20) NOTNULL DEFAULT '0',
+tstamp I8 NOTNULL DEFAULT '0',
 user C(255) NOTNULL DEFAULT '',
-data text NOTNULL
+data X NOTNULL
 ";
 
 $tables['sys_dbsync'] = "

--
Gitblit v1.9.1