From 55438f6d3b74913a289cf9a1ac6e99293f749092 Mon Sep 17 00:00:00 2001
From: pedro_morgan <pedro_morgan@ispconfig3>
Date: Sun, 19 Aug 2007 19:27:29 -0400
Subject: [PATCH] Table definition files, WIP

---
 interface/sql/db_installer_sandbox/defs.mail_spam.php |  111 -------------------------------------------------------
 1 files changed, 0 insertions(+), 111 deletions(-)

diff --git a/interface/sql/db_installer_sandbox/table_definitions.php b/interface/sql/db_installer_sandbox/defs.mail_spam.php
similarity index 64%
rename from interface/sql/db_installer_sandbox/table_definitions.php
rename to interface/sql/db_installer_sandbox/defs.mail_spam.php
index 2db6f3e..d463a92 100644
--- a/interface/sql/db_installer_sandbox/table_definitions.php
+++ b/interface/sql/db_installer_sandbox/defs.mail_spam.php
@@ -152,39 +152,6 @@
 active enum('0','1') NOTNULL DEFAULT '1'
 ";
 
-$tables['reseller'] = "
-reseller_id bigint(20) 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 '',
-company C(255) NOTNULL DEFAULT '',
-title C(255) NOTNULL DEFAULT '',
-firstname C(255) NOTNULL DEFAULT '',
-surname C(255) NOTNULL DEFAULT '',
-street C(255) NOTNULL DEFAULT '',
-zip C(255) NOTNULL DEFAULT '',
-city C(255) NOTNULL DEFAULT '',
-country C(255) NOTNULL DEFAULT '',
-telephone C(255) NOTNULL DEFAULT '',
-mobile C(255) NOTNULL DEFAULT '',
-fax C(255) NOTNULL DEFAULT '',
-email C(255) NOTNULL DEFAULT '',
-internet C(255) NOTNULL DEFAULT '',
-icq C(255) NOTNULL DEFAULT '',
-notes text NOTNULL,
-limit_client I NOTNULL DEFAULT '-1',
-limit_domain I NOTNULL DEFAULT '-1',
-limit_subdomain I NOTNULL DEFAULT '-1',
-limit_mailbox I NOTNULL DEFAULT '-1',
-limit_mailalias I NOTNULL DEFAULT '-1',
-limit_webquota I NOTNULL DEFAULT '-1',
-limit_mailquota I NOTNULL DEFAULT '-1',
-limit_database I NOTNULL DEFAULT '-1',
-ip_address text NOTNULL
-";
-
 $tables['rr'] = "
 id int(10) unsigned NOTNULL AUTO PRIMARY,
 zone int(10) unsigned NOTNULL DEFAULT '0',
@@ -239,84 +206,6 @@
 sys_perm_other C(5) NOTNULL DEFAULT ''
 ";
 
-//*************************************************************************************
-// System Related
-//*************************************************************************************
-$tables['sys_datalog'] = "
-datalog_id bigint(20) NOTNULL AUTO PRIMARY,
-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',
-user C(255) NOTNULL DEFAULT '',
-data text NOTNULL
-";
 
-$tables['sys_dbsync'] = "
-id bigint(20) NOTNULL AUTO PRIMARY,
-jobname C(255) NOTNULL DEFAULT '',
-sync_interval_minutes I NOTNULL DEFAULT '0',
-db_type C(255) NOTNULL DEFAULT '',
-db_host C(255) NOTNULL DEFAULT '',
-db_name C(255) NOTNULL DEFAULT '',
-db_username C(255) NOTNULL DEFAULT '',
-db_password C(255) NOTNULL DEFAULT '',
-db_tables C(255) NOTNULL DEFAULT 'admin,forms',
-empty_datalog I NOTNULL DEFAULT '0',
-sync_datalog_external I NOTNULL DEFAULT '0',
-active I NOTNULL DEFAULT '1',
-last_datalog_id bigint(20) NOTNULL DEFAULT '0'
-";
-
-
-$tables['sys_filesync'] = "
-id bigint(20) NOTNULL AUTO PRIMARY,
-jobname C(255) NOTNULL DEFAULT '',
-sync_interval_minutes I NOTNULL DEFAULT '0',
-ftp_host C(255) NOTNULL DEFAULT '',
-ftp_path C(255) NOTNULL DEFAULT '',
-ftp_username C(255) NOTNULL DEFAULT '',
-ftp_password C(255) NOTNULL DEFAULT '',
-local_path C(255) NOTNULL DEFAULT '',
-wput_options C(255) NOTNULL DEFAULT '--timestamping --reupload --dont-continue',
-active I NOTNULL DEFAULT '1'
-";
-
-$tables['sys_group'] = "
-groupid I NOTNULL AUTO PRIMARY,
-name C(255) NOTNULL DEFAULT '',
-description text NOTNULL
-";
-
-$tables['sys_user'] = "
-userid 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 '',
-username C(100) NOTNULL DEFAULT '',
-passwort C(100) NOTNULL DEFAULT '',
-modules C(255) NOTNULL DEFAULT '',
-startmodule C(255) NOTNULL DEFAULT '',
-app_theme C(100) NOTNULL DEFAULT 'DEFAULT',
-typ C(20) NOTNULL DEFAULT 'user',
-active tinyint(4) NOTNULL DEFAULT '1',
-name C(100) NOTNULL DEFAULT '',
-vorname C(100) NOTNULL DEFAULT '',
-unternehmen C(100) NOTNULL DEFAULT '',
-strasse C(100) NOTNULL DEFAULT '',
-ort C(100) NOTNULL DEFAULT '',
-plz C(10) NOTNULL DEFAULT '',
-land C(50) NOTNULL DEFAULT '',
-email C(100) NOTNULL DEFAULT '',
-url C(255) NOTNULL DEFAULT '',
-telefon C(100) NOTNULL DEFAULT '',
-fax C(100) NOTNULL DEFAULT '',
-language C(10) NOTNULL DEFAULT 'de',
-groups C(255) NOTNULL DEFAULT '',
-DEFAULT_group I NOTNULL DEFAULT '0'
-";
 
 ?>
\ No newline at end of file

--
Gitblit v1.9.1