From 336a577f2809c9760e7a1a15f10f523b2cf20c8d Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Tue, 01 Nov 2005 17:59:29 -0500
Subject: [PATCH] Added Server table

---
 interface/sql/ispconfig3db.sql |  436 ++++++++++++++++++++++++++++++++----------------------
 1 files changed, 257 insertions(+), 179 deletions(-)

diff --git a/interface/sql/ispconfig3db.sql b/interface/sql/ispconfig3db.sql
index 33dd406..887ce2e 100644
--- a/interface/sql/ispconfig3db.sql
+++ b/interface/sql/ispconfig3db.sql
@@ -3,10 +3,264 @@
 # http://www.phpmyadmin.net/ (download page)
 #
 # Host: localhost
-# Erstellungszeit: 18. Oktober 2005 um 16:00
-# Server Version: 4.0.22
-# PHP-Version: 5.0.2
+# Erstellungszeit: 01. November 2005 um 23:57
+# Server Version: 4.0.23
+# PHP-Version: 5.0.3
 # Datenbank: `ispconfig3`
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_blacklist`
+#
+
+DROP TABLE IF EXISTS mail_blacklist;
+CREATE TABLE mail_blacklist (
+  blacklist_id int(11) NOT NULL auto_increment,
+  server_id int(11) NOT NULL default '0',
+  address varchar(255) NOT NULL default '',
+  PRIMARY KEY  (blacklist_id),
+  KEY server_id (server_id,address)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_blacklist`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_domain`
+#
+
+DROP TABLE IF EXISTS mail_domain;
+CREATE TABLE mail_domain (
+  domain_id int(11) NOT NULL auto_increment,
+  server_id int(11) NOT NULL default '0',
+  domain varchar(255) NOT NULL default '',
+  type enum('local','relay','manual_relay') NOT NULL default 'local',
+  relay_host varchar(255) NOT NULL default '',
+  PRIMARY KEY  (domain_id),
+  KEY server_id (server_id,domain,type)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_domain`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_domain_alias`
+#
+
+DROP TABLE IF EXISTS mail_domain_alias;
+CREATE TABLE mail_domain_alias (
+  domain_alias_id int(11) NOT NULL auto_increment,
+  server_id int(11) NOT NULL default '0',
+  domain varchar(255) NOT NULL default '',
+  destination varchar(255) NOT NULL default '',
+  PRIMARY KEY  (domain_alias_id),
+  KEY server_id (server_id,domain)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_domain_alias`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_domain_catchall`
+#
+
+DROP TABLE IF EXISTS mail_domain_catchall;
+CREATE TABLE mail_domain_catchall (
+  virtual_default_id int(11) NOT NULL auto_increment,
+  server_id int(11) NOT NULL default '0',
+  domain varchar(255) NOT NULL default '',
+  dest varchar(255) NOT NULL default '',
+  PRIMARY KEY  (virtual_default_id),
+  KEY server_id (server_id,domain)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_domain_catchall`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_email`
+#
+
+DROP TABLE IF EXISTS mail_email;
+CREATE TABLE mail_email (
+  mailbox_id int(11) NOT NULL auto_increment,
+  server_id int(11) NOT NULL default '0',
+  email varchar(255) NOT NULL default '',
+  type enum('mailbox','alias') NOT NULL default 'mailbox',
+  cryptpwd varchar(128) NOT NULL default '',
+  clearpwd varchar(128) NOT NULL default '',
+  name varchar(128) NOT NULL default '',
+  uid int(10) unsigned NOT NULL default '0',
+  gid int(10) unsigned NOT NULL default '0',
+  maildir varchar(255) NOT NULL default '',
+  quota varchar(255) NOT NULL default '',
+  cc varchar(50) NOT NULL default '',
+  forward varchar(50) NOT NULL default '',
+  autoresponder enum('yes','no') NOT NULL default 'no',
+  autoresponder_text tinytext NOT NULL,
+  enabled enum('yes','no') NOT NULL default 'yes',
+  antivirus enum('yes','no') NOT NULL default 'no',
+  spamscan enum('yes','no') NOT NULL default 'no',
+  spamdelete enum('yes','no') NOT NULL default 'no',
+  PRIMARY KEY  (mailbox_id),
+  KEY server_id (server_id,email)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_email`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_greylist`
+#
+
+DROP TABLE IF EXISTS mail_greylist;
+CREATE TABLE mail_greylist (
+  greylist_id int(11) NOT NULL auto_increment,
+  relay_ip varchar(64) default NULL,
+  from_domain varchar(255) default NULL,
+  block_expires datetime NOT NULL default '0000-00-00 00:00:00',
+  record_expires datetime NOT NULL default '0000-00-00 00:00:00',
+  origin_type enum('MANUAL','AUTO') NOT NULL default 'AUTO',
+  create_time datetime NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY  (greylist_id)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_greylist`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_mailman_domain`
+#
+
+DROP TABLE IF EXISTS mail_mailman_domain;
+CREATE TABLE mail_mailman_domain (
+  mailman_id int(11) NOT NULL auto_increment,
+  server_id int(11) NOT NULL default '0',
+  domain varchar(255) NOT NULL default '',
+  mm_home varchar(255) NOT NULL default '',
+  mm_wrap varchar(255) NOT NULL default '',
+  mm_user varchar(50) NOT NULL default '',
+  mm_group varchar(50) NOT NULL default '',
+  PRIMARY KEY  (mailman_id,server_id,domain)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_mailman_domain`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_whitelist`
+#
+
+DROP TABLE IF EXISTS mail_whitelist;
+CREATE TABLE mail_whitelist (
+  whitelist_id int(11) NOT NULL auto_increment,
+  server_id int(11) NOT NULL default '0',
+  address varchar(255) NOT NULL default '',
+  PRIMARY KEY  (whitelist_id),
+  KEY server_id (server_id,address)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_whitelist`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `reseller`
+#
+
+DROP TABLE IF EXISTS reseller;
+CREATE TABLE reseller (
+  reseller_id bigint(20) NOT NULL auto_increment,
+  sys_userid int(11) NOT NULL default '0',
+  sys_groupid int(11) NOT NULL default '0',
+  sys_perm_user varchar(5) NOT NULL default '',
+  sys_perm_group varchar(5) NOT NULL default '',
+  sys_perm_other varchar(5) NOT NULL default '',
+  company varchar(255) NOT NULL default '',
+  title varchar(255) NOT NULL default '',
+  firstname varchar(255) NOT NULL default '',
+  surname varchar(255) NOT NULL default '',
+  street varchar(255) NOT NULL default '',
+  zip varchar(255) NOT NULL default '',
+  city varchar(255) NOT NULL default '',
+  country varchar(255) NOT NULL default '',
+  telephone varchar(255) NOT NULL default '',
+  mobile varchar(255) NOT NULL default '',
+  fax varchar(255) NOT NULL default '',
+  email varchar(255) NOT NULL default '',
+  internet varchar(255) NOT NULL default '',
+  icq varchar(255) NOT NULL default '',
+  notes text NOT NULL,
+  limit_client int(11) NOT NULL default '-1',
+  limit_domain int(11) NOT NULL default '-1',
+  limit_subdomain int(11) NOT NULL default '-1',
+  limit_mailbox int(11) NOT NULL default '-1',
+  limit_mailalias int(11) NOT NULL default '-1',
+  limit_webquota int(11) NOT NULL default '-1',
+  limit_mailquota int(11) NOT NULL default '-1',
+  limit_database int(11) NOT NULL default '-1',
+  ip_address text NOT NULL,
+  PRIMARY KEY  (reseller_id)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `reseller`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `server`
+#
+
+DROP TABLE IF EXISTS server;
+CREATE TABLE server (
+  server_id bigint(20) NOT NULL auto_increment,
+  sys_userid int(11) NOT NULL default '0',
+  sys_groupid int(11) NOT NULL default '0',
+  sys_perm_user varchar(5) NOT NULL default '',
+  sys_perm_group varchar(5) NOT NULL default '',
+  sys_perm_other varchar(5) NOT NULL default '',
+  server_name varchar(255) NOT NULL default '',
+  mail_server int(11) NOT NULL default '0',
+  web_server int(11) NOT NULL default '0',
+  dns_server int(11) NOT NULL default '0',
+  file_server int(11) NOT NULL default '0',
+  mysql_server int(11) NOT NULL default '0',
+  postgresql_server int(11) NOT NULL default '0',
+  firebird_server int(11) NOT NULL default '0',
+  active int(11) NOT NULL default '1',
+  PRIMARY KEY  (server_id)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `server`
+#
+
+INSERT INTO server VALUES (1, 1, 1, 'riud', 'riud', '', 'Server 1', 1, 0, 0, 0, 0, 0, 0, 1);
 # --------------------------------------------------------
 
 #
@@ -147,179 +401,3 @@
 
 INSERT INTO sys_user VALUES (1, 1, 0, 'riud', 'riud', '', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin,clients,designer,resellers,sites', 'admin', 'default', 'admin', 1, '', 'Administrator', '', '', '', '', '', '', '', '', '', 'en', '1,2', 0);
 
-
-#
-# Tabellenstruktur f�r Tabelle `mail_blacklist`
-#
-
-DROP TABLE IF EXISTS mail_blacklist;
-CREATE TABLE mail_blacklist (
-  blacklist_id int(11) NOT NULL auto_increment,
-  server_id int(11) NOT NULL default '0',
-  address varchar(255) NOT NULL default '',
-  PRIMARY KEY  (blacklist_id),
-  KEY server_id (server_id,address)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Tabellenstruktur f�r Tabelle `mail_domain`
-#
-
-DROP TABLE IF EXISTS mail_domain;
-CREATE TABLE mail_domain (
-  domain_id int(11) NOT NULL auto_increment,
-  server_id int(11) NOT NULL default '0',
-  domain varchar(255) NOT NULL default '',
-  type enum('local','relay','manual_relay') NOT NULL default 'local',
-  relay_host varchar(255) NOT NULL default '',
-  PRIMARY KEY  (domain_id),
-  KEY server_id (server_id,domain,type)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Tabellenstruktur f�r Tabelle `mail_domain_alias`
-#
-
-DROP TABLE IF EXISTS mail_domain_alias;
-CREATE TABLE mail_domain_alias (
-  domain_alias_id int(11) NOT NULL auto_increment,
-  server_id int(11) NOT NULL default '0',
-  domain varchar(255) NOT NULL default '',
-  destination varchar(255) NOT NULL default '',
-  PRIMARY KEY  (domain_alias_id),
-  KEY server_id (server_id,domain)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Tabellenstruktur f�r Tabelle `mail_domain_catchall`
-#
-
-DROP TABLE IF EXISTS mail_domain_catchall;
-CREATE TABLE mail_domain_catchall (
-  virtual_default_id int(11) NOT NULL auto_increment,
-  server_id int(11) NOT NULL default '0',
-  domain varchar(255) NOT NULL default '',
-  dest varchar(255) NOT NULL default '',
-  PRIMARY KEY  (virtual_default_id),
-  KEY server_id (server_id,domain)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Tabellenstruktur f�r Tabelle `mail_email`
-#
-
-DROP TABLE IF EXISTS mail_email;
-CREATE TABLE mail_email (
-  mailbox_id int(11) NOT NULL auto_increment,
-  server_id int(11) NOT NULL default '0',
-  email varchar(255) NOT NULL default '',
-  type enum('mailbox','alias') NOT NULL default 'mailbox',
-  cryptpwd varchar(128) NOT NULL default '',
-  clearpwd varchar(128) NOT NULL default '',
-  name varchar(128) NOT NULL default '',
-  uid int(10) unsigned NOT NULL default '0',
-  gid int(10) unsigned NOT NULL default '0',
-  maildir varchar(255) NOT NULL default '',
-  quota varchar(255) NOT NULL default '',
-  cc varchar(50) NOT NULL default '',
-  forward varchar(50) NOT NULL default '',
-  autoresponder enum('yes','no') NOT NULL default 'no',
-  autoresponder_text tinytext NOT NULL,
-  enabled enum('yes','no') NOT NULL default 'yes',
-  antivirus enum('yes','no') NOT NULL default 'no',
-  spamscan enum('yes','no') NOT NULL default 'no',
-  spamdelete enum('yes','no') NOT NULL default 'no',
-  PRIMARY KEY  (mailbox_id),
-  KEY server_id (server_id,email)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Tabellenstruktur f�r Tabelle `mail_greylist`
-#
-
-DROP TABLE IF EXISTS mail_greylist;
-CREATE TABLE mail_greylist (
-  greylist_id int(11) NOT NULL auto_increment,
-  relay_ip varchar(64) default NULL,
-  from_domain varchar(255) default NULL,
-  block_expires datetime NOT NULL default '0000-00-00 00:00:00',
-  record_expires datetime NOT NULL default '0000-00-00 00:00:00',
-  origin_type enum('MANUAL','AUTO') NOT NULL default 'AUTO',
-  create_time datetime NOT NULL default '0000-00-00 00:00:00',
-  PRIMARY KEY  (greylist_id)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Tabellenstruktur f�r Tabelle `mail_mailman_domain`
-#
-
-DROP TABLE IF EXISTS mail_mailman_domain;
-CREATE TABLE mail_mailman_domain (
-  mailman_id int(11) NOT NULL auto_increment,
-  server_id int(11) NOT NULL default '0',
-  domain varchar(255) NOT NULL default '',
-  mm_home varchar(255) NOT NULL default '',
-  mm_wrap varchar(255) NOT NULL default '',
-  mm_user varchar(50) NOT NULL default '',
-  mm_group varchar(50) NOT NULL default '',
-  PRIMARY KEY  (mailman_id,server_id,domain)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Tabellenstruktur f�r Tabelle `mail_whitelist`
-#
-
-DROP TABLE IF EXISTS mail_whitelist;
-CREATE TABLE mail_whitelist (
-  whitelist_id int(11) NOT NULL auto_increment,
-  server_id int(11) NOT NULL default '0',
-  address varchar(255) NOT NULL default '',
-  PRIMARY KEY  (whitelist_id),
-  KEY server_id (server_id,address)
-) TYPE=MyISAM;
-
-#
-# Tabellenstruktur f�r Tabelle `reseller`
-#
-
-CREATE TABLE reseller (
-  reseller_id bigint(20) NOT NULL auto_increment,
-  sys_userid int(11) NOT NULL default '0',
-  sys_groupid int(11) NOT NULL default '0',
-  sys_perm_user varchar(5) NOT NULL default '',
-  sys_perm_group varchar(5) NOT NULL default '',
-  sys_perm_other varchar(5) NOT NULL default '',
-  company varchar(255) NOT NULL default '',
-  title varchar(255) NOT NULL default '',
-  firstname varchar(255) NOT NULL default '',
-  surname varchar(255) NOT NULL default '',
-  street varchar(255) NOT NULL default '',
-  zip varchar(255) NOT NULL default '',
-  city varchar(255) NOT NULL default '',
-  country varchar(255) NOT NULL default '',
-  telephone varchar(255) NOT NULL default '',
-  mobile varchar(255) NOT NULL default '',
-  fax varchar(255) NOT NULL default '',
-  email varchar(255) NOT NULL default '',
-  internet varchar(255) NOT NULL default '',
-  icq varchar(255) NOT NULL default '',
-  notes text NOT NULL,
-  limit_client int(11) NOT NULL default '-1',
-  limit_domain int(11) NOT NULL default '-1',
-  limit_subdomain int(11) NOT NULL default '-1',
-  limit_mailbox int(11) NOT NULL default '-1',
-  limit_mailalias int(11) NOT NULL default '-1',
-  limit_webquota int(11) NOT NULL default '-1',
-  limit_mailquota int(11) NOT NULL default '-1',
-  limit_database int(11) NOT NULL default '-1',
-  ip_address text NOT NULL,
-  PRIMARY KEY  (reseller_id)
-) TYPE=MyISAM;
-# --------------------------------------------------------
\ No newline at end of file

--
Gitblit v1.9.1