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.resellers_clients.php |   42 ++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 42 insertions(+), 0 deletions(-)

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,

--
Gitblit v1.9.1