From dcff5718f345f55f7ea81f18d1f086facde4eacf Mon Sep 17 00:00:00 2001
From: pedro_morgan <pedro_morgan@ispconfig3>
Date: Mon, 20 Aug 2007 23:14:51 -0400
Subject: [PATCH] * Using new ISPC_*_PATH constants * Adding new data schema (to be moved shortly * no more $conf['classpath']

---
 interface/sql/db_installer_sandbox/defs.ftp_servers_sites_domains.php |  125 +++++++++++++++++++++++++++++++++--------
 1 files changed, 99 insertions(+), 26 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
index f84b3f1..4ee5913 100644
--- a/interface/sql/db_installer_sandbox/defs.ftp_servers_sites_domains.php
+++ b/interface/sql/db_installer_sandbox/defs.ftp_servers_sites_domains.php
@@ -1,32 +1,105 @@
 <?php
 
+//*************************************************************************************
+// DNS
+//*************************************************************************************
 
+//TODO - Enum
+$tables['dns_rr'] = "
+`id` I unsigned 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` I NOTNULL DEFAULT '1',
+`zone` I unsigned NOTNULL,
+`name` C(64) NOTNULL,
+`type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT') ,
+`data` char(128) NOTNULL,
+`aux` I unsigned NOTNULL DEFAULT '0',
+`ttl` I unsigned NOTNULL DEFAULT '86400',
+`active` enum('N','Y') NOTNULL DEFAULT 'Y'
+";
+ 
+//TODO char(255)
+$tables['dns_soa'] = "
+`id` I unsigned 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` I NOTNULL DEFAULT '1',
+`origin` char(255) NOTNULL,
+`ns` char(255) NOTNULL,
+`mbox` char(255) NOTNULL,
+`serial` I NOTNULL DEFAULT '1',
+`refresh` I NOTNULL DEFAULT '28800',
+`retry` I NOTNULL DEFAULT '7200',
+`expire` I NOTNULL DEFAULT '604800',
+`minimum` I NOTNULL DEFAULT '86400',
+`ttl` I unsigned NOTNULL DEFAULT '86400',
+`active` enum('Y','N') NOTNULL,
+`xfer` char(255) NOTNULL
+";
+
+
+//*************************************************************************************
+// Ftp Related
+//*************************************************************************************
+
+$tables['ftp_user'] = "
+`ftp_user_id` I8 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',
+`parent_domain_id` I NOTNULL DEFAULT '0',
+`username` C(255),
+`password` C(255),
+`quota_size` I NOTNULL DEFAULT '-1',
+`active` C(255) NOTNULL DEFAULT 'y',
+`uid` C(255),
+`gid` C(255),
+`dir` C(255),
+`quota_files` I NOTNULL DEFAULT '-1',
+`ul_ratio` I NOTNULL DEFAULT '-1',
+`dl_ratio` I NOTNULL DEFAULT '-1',
+`ul_bandwidth` I NOTNULL DEFAULT '-1',
+`dl_bandwidth` I NOTNULL DEFAULT '-1'
+";
+
+//*************************************************************************************
+// Web Domain
+//*************************************************************************************
 
 $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`)
-)  ;
+`domain_id` I8 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'
+";
 ?>
\ No newline at end of file

--
Gitblit v1.9.1