From 87a4a65f40ef4ad5a00483671e83ef31b9af85e2 Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Fri, 24 Feb 2006 04:32:30 -0500
Subject: [PATCH] server base system

---
 interface/sql/ispconfig3db.sql | 1082 ++++++++++++++++++++++++++++++--------------------------
 1 files changed, 571 insertions(+), 511 deletions(-)

diff --git a/interface/sql/ispconfig3db.sql b/interface/sql/ispconfig3db.sql
index 984a53c..7d2fe6e 100644
--- a/interface/sql/ispconfig3db.sql
+++ b/interface/sql/ispconfig3db.sql
@@ -1,511 +1,571 @@
-# phpMyAdmin MySQL-Dump
-# version 2.4.0-rc1
-# http://www.phpmyadmin.net/ (download page)
-#
-# Host: localhost
-# Erstellungszeit: 16. Februar 2006 um 22:34
-# 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,
-  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_id int(11) NOT NULL default '0',
-  address varchar(200) NOT NULL default '',
-  recipient varchar(200) NOT NULL default '',
-  active enum('0','1') NOT NULL default '1',
-  PRIMARY KEY  (blacklist_id),
-  KEY server_id (server_id,address,recipient)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Tabellenstruktur f�r Tabelle `mail_box`
-#
-
-DROP TABLE IF EXISTS mail_box;
-CREATE TABLE mail_box (
-  mailbox_id int(11) 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_id int(11) NOT NULL default '0',
-  email varchar(255) NOT NULL default '',
-  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 '',
-  autoresponder enum('0','1') NOT NULL default '0',
-  autoresponder_text tinytext NOT NULL,
-  active enum('0','1') NOT NULL default '1',
-  PRIMARY KEY  (mailbox_id),
-  KEY server_id (server_id,email)
-) 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,
-  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_id int(11) NOT NULL default '0',
-  domain varchar(255) NOT NULL default '',
-  type enum('local','relay','alias') NOT NULL default 'local',
-  destination varchar(255) NOT NULL default '',
-  active tinyint(4) NOT NULL default '1',
-  PRIMARY KEY  (domain_id),
-  KEY server_id (server_id,domain,type)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Tabellenstruktur f�r Tabelle `mail_domain_catchall`
-#
-
-DROP TABLE IF EXISTS mail_domain_catchall;
-CREATE TABLE mail_domain_catchall (
-  domain_catchall_id int(11) 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_id int(11) NOT NULL default '0',
-  domain varchar(255) NOT NULL default '',
-  destination varchar(255) NOT NULL default '',
-  active enum('0','1') NOT NULL default '1',
-  PRIMARY KEY  (domain_catchall_id),
-  KEY server_id (server_id,domain)
-) 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_redirect`
-#
-
-DROP TABLE IF EXISTS mail_redirect;
-CREATE TABLE mail_redirect (
-  redirect_id int(11) 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_id int(11) NOT NULL default '0',
-  email varchar(255) NOT NULL default '',
-  destination varchar(255) NOT NULL default '',
-  type enum('alias','forward') NOT NULL default 'alias',
-  active enum('0','1') NOT NULL default '1',
-  PRIMARY KEY  (redirect_id),
-  KEY server_id (server_id,email)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Tabellenstruktur f�r Tabelle `mail_spamfilter`
-#
-
-DROP TABLE IF EXISTS mail_spamfilter;
-CREATE TABLE mail_spamfilter (
-  spamfilter_id int(11) 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_id int(11) NOT NULL default '0',
-  email varchar(255) NOT NULL default '',
-  spam_rewrite_score_int int(11) NOT NULL default '0',
-  spam_delete_score_int int(11) NOT NULL default '0',
-  spam_redirect_score_int int(11) NOT NULL default '0',
-  spam_rewrite_subject varchar(50) NOT NULL default '***SPAM***',
-  spam_redirect_maildir varchar(255) NOT NULL default '',
-  spam_redirect_maildir_purge int(11) NOT NULL default '7',
-  active enum('0','1') NOT NULL default '1',
-  PRIMARY KEY  (spamfilter_id),
-  KEY server_id (server_id,email)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Tabellenstruktur f�r Tabelle `mail_transport`
-#
-
-DROP TABLE IF EXISTS mail_transport;
-CREATE TABLE mail_transport (
-  whitelist_id int(11) 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_id int(11) NOT NULL default '0',
-  domain varchar(255) NOT NULL default '',
-  destination varchar(255) NOT NULL default '',
-  active enum('0','1') NOT NULL default '1',
-  PRIMARY KEY  (whitelist_id),
-  KEY server_id (server_id,destination),
-  KEY server_id_2 (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,
-  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_id int(11) NOT NULL default '0',
-  address varchar(255) NOT NULL default '',
-  recipient varchar(255) NOT NULL default '',
-  active enum('0','1') NOT NULL default '1',
-  PRIMARY KEY  (whitelist_id),
-  KEY server_id (server_id,address)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
---
--- 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 AUTO_INCREMENT=1 ;
-
---
--- 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',
-  config text NOT NULL,
-  active int(11) NOT NULL default '1',
-  PRIMARY KEY  (server_id)
-) TYPE=MyISAM;
-
---
--- Daten f�r Tabelle `server`
---
-
-INSERT INTO `server` (`server_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_name`, `mail_server`, `web_server`, `dns_server`, `file_server`, `mysql_server`, `postgresql_server`, `firebird_server`, `active`) VALUES (1, 1, 1, 'riud', 'riud', '', 'Server 1', 1, 0, 0, 0, 0, 0, 0, 1);
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur f�r Tabelle `sys_datalog`
---
-
-DROP TABLE IF EXISTS `sys_datalog`;
-CREATE TABLE `sys_datalog` (
-  `datalog_id` bigint(20) NOT NULL auto_increment,
-  `dbtable` varchar(255) NOT NULL default '',
-  `dbidx` varchar(255) NOT NULL default '',
-  `action` char(1) NOT NULL default '',
-  `tstamp` bigint(20) NOT NULL default '0',
-  `user` varchar(255) NOT NULL default '',
-  `data` text NOT NULL,
-  PRIMARY KEY  (`datalog_id`)
-) TYPE=MyISAM AUTO_INCREMENT=48 ;
-
---
--- Daten f�r Tabelle `sys_datalog`
---
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur f�r Tabelle `sys_dbsync`
---
-
-DROP TABLE IF EXISTS `sys_dbsync`;
-CREATE TABLE `sys_dbsync` (
-  `id` bigint(20) NOT NULL auto_increment,
-  `jobname` varchar(255) NOT NULL default '',
-  `sync_interval_minutes` int(11) NOT NULL default '0',
-  `db_type` varchar(255) NOT NULL default '',
-  `db_host` varchar(255) NOT NULL default '',
-  `db_name` varchar(255) NOT NULL default '',
-  `db_username` varchar(255) NOT NULL default '',
-  `db_password` varchar(255) NOT NULL default '',
-  `db_tables` varchar(255) NOT NULL default 'admin,forms',
-  `empty_datalog` int(11) NOT NULL default '0',
-  `sync_datalog_external` int(11) NOT NULL default '0',
-  `active` int(11) NOT NULL default '1',
-  `last_datalog_id` bigint(20) NOT NULL default '0',
-  PRIMARY KEY  (`id`),
-  KEY `last_datalog_id` (`last_datalog_id`)
-) TYPE=MyISAM AUTO_INCREMENT=1 ;
-
---
--- Daten f�r Tabelle `sys_dbsync`
---
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur f�r Tabelle `sys_filesync`
---
-
-DROP TABLE IF EXISTS `sys_filesync`;
-CREATE TABLE `sys_filesync` (
-  `id` bigint(20) NOT NULL auto_increment,
-  `jobname` varchar(255) NOT NULL default '',
-  `sync_interval_minutes` int(11) NOT NULL default '0',
-  `ftp_host` varchar(255) NOT NULL default '',
-  `ftp_path` varchar(255) NOT NULL default '',
-  `ftp_username` varchar(255) NOT NULL default '',
-  `ftp_password` varchar(255) NOT NULL default '',
-  `local_path` varchar(255) NOT NULL default '',
-  `wput_options` varchar(255) NOT NULL default '--timestamping --reupload --dont-continue',
-  `active` int(11) NOT NULL default '1',
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM AUTO_INCREMENT=1 ;
-
---
--- Daten f�r Tabelle `sys_filesync`
---
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur f�r Tabelle `sys_group`
---
-
-DROP TABLE IF EXISTS `sys_group`;
-CREATE TABLE `sys_group` (
-  `groupid` int(11) NOT NULL auto_increment,
-  `name` varchar(255) NOT NULL default '',
-  `description` text NOT NULL,
-  PRIMARY KEY  (`groupid`)
-) TYPE=MyISAM AUTO_INCREMENT=3 ;
-
---
--- Daten f�r Tabelle `sys_group`
---
-
-INSERT INTO `sys_group` (`groupid`, `name`, `description`) VALUES (1, 'admin', 'Administrators group');
-INSERT INTO `sys_group` (`groupid`, `name`, `description`) VALUES (2, 'user', 'Users Group');
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur f�r Tabelle `sys_user`
---
-
-DROP TABLE IF EXISTS `sys_user`;
-CREATE TABLE `sys_user` (
-  `userid` int(11) 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 '',
-  `username` varchar(100) NOT NULL default '',
-  `passwort` varchar(100) NOT NULL default '',
-  `modules` varchar(255) NOT NULL default '',
-  `startmodule` varchar(255) NOT NULL default '',
-  `app_theme` varchar(100) NOT NULL default 'default',
-  `typ` varchar(20) NOT NULL default 'user',
-  `active` tinyint(4) NOT NULL default '1',
-  `name` varchar(100) NOT NULL default '',
-  `vorname` varchar(100) NOT NULL default '',
-  `unternehmen` varchar(100) NOT NULL default '',
-  `strasse` varchar(100) NOT NULL default '',
-  `ort` varchar(100) NOT NULL default '',
-  `plz` varchar(10) NOT NULL default '',
-  `land` varchar(50) NOT NULL default '',
-  `email` varchar(100) NOT NULL default '',
-  `url` varchar(255) NOT NULL default '',
-  `telefon` varchar(100) NOT NULL default '',
-  `fax` varchar(100) NOT NULL default '',
-  `language` varchar(10) NOT NULL default 'de',
-  `groups` varchar(255) NOT NULL default '',
-  `default_group` int(11) NOT NULL default '0',
-  PRIMARY KEY  (`userid`)
-) TYPE=MyISAM AUTO_INCREMENT=2 ;
-
---
--- Daten f�r Tabelle `sys_user`
---
-
-INSERT INTO `sys_user` (`userid`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `username`, `passwort`, `modules`, `startmodule`, `app_theme`, `typ`, `active`, `name`, `vorname`, `unternehmen`, `strasse`, `ort`, `plz`, `land`, `email`, `url`, `telefon`, `fax`, `language`, `groups`, `default_group`) VALUES (1, 1, 0, 'riud', 'riud', '', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin,designer,sites,dns', 'admin', 'default', 'admin', 1, '', 'Administrator', '', '', '', '', '', '', '', '', '', 'en', '1,2', 0);
-
---
--- Table structure for table `rr`
---
-
-DROP TABLE IF EXISTS `rr`;
-CREATE TABLE `rr` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `zone` int(10) unsigned NOT NULL default '0',
-  `name` varchar(64) NOT NULL default '',
-  `type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NS','PTR','RP','SRV','TXT') default NULL,
-  `data` varchar(128) NOT NULL default '',
-  `aux` int(10) unsigned NOT NULL default '0',
-  `ttl` int(10) unsigned NOT NULL default '86400',
-  `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 '',
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `rr` (`zone`,`name`,`type`,`data`)
-) TYPE=MyISAM;
-
---
--- Dumping data for table `rr`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `soa`
---
-
-DROP TABLE IF EXISTS `soa`;
-CREATE TABLE `soa` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `origin` varchar(255) NOT NULL default '',
-  `ns` varchar(255) NOT NULL default '',
-  `mbox` varchar(255) NOT NULL default '',
-  `serial` int(10) unsigned NOT NULL default '1',
-  `refresh` int(10) unsigned NOT NULL default '28800',
-  `retry` int(10) unsigned NOT NULL default '7200',
-  `expire` int(10) unsigned NOT NULL default '604800',
-  `minimum` int(10) unsigned NOT NULL default '86400',
-  `ttl` int(10) unsigned NOT NULL default '86400',
-  `active` enum('Y','N') NOT NULL default 'Y',
-  `xfer` varchar(255) NOT NULL default '',
-  `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 '',
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `origin` (`origin`),
-  KEY `active` (`active`)
-) TYPE=MyISAM;
-
---
--- Dumping data for table `soa`
---
-
--- --------------------------------------------------------
\ No newline at end of file
+# phpMyAdmin MySQL-Dump
+# version 2.4.0-rc1
+# http://www.phpmyadmin.net/ (download page)
+#
+# Host: localhost
+# Erstellungszeit: 24. Februar 2006 um 10:32
+# 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,
+  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_id int(11) NOT NULL default '0',
+  address varchar(200) NOT NULL default '',
+  recipient varchar(200) NOT NULL default '',
+  active enum('0','1') NOT NULL default '1',
+  PRIMARY KEY  (blacklist_id),
+  KEY server_id (server_id,address,recipient)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_blacklist`
+#
+
+INSERT INTO mail_blacklist VALUES (2, 1, 0, 'riud', 'riud', '', 1, 'till@test.int', 'till@test.int', '0');
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_box`
+#
+
+DROP TABLE IF EXISTS mail_box;
+CREATE TABLE mail_box (
+  mailbox_id int(11) 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_id int(11) NOT NULL default '0',
+  email varchar(255) NOT NULL default '',
+  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 '',
+  autoresponder enum('0','1') NOT NULL default '0',
+  autoresponder_text tinytext NOT NULL,
+  active enum('0','1') NOT NULL default '1',
+  PRIMARY KEY  (mailbox_id),
+  KEY server_id (server_id,email)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_box`
+#
+
+INSERT INTO mail_box VALUES (1, 1, 0, 'riud', 'riud', '', 1, 'tt@test.int', '$1$tRlfKeOB$iHJgCn8mH8x/dh/XWy6v0/', '', '', 0, 0, '/var/spool/mail/till', '100', '0', '', '1');
+INSERT INTO mail_box VALUES (2, 1, 0, 'riud', 'riud', '', 1, 'moin@test.int', '$1$Ee/.7y3.$wZ4BLXs/Pa80ka9X4ikN8.', '', '', 0, 0, '/var/spool/mail/test.int/moin', '10', '0', '', '1');
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_domain`
+#
+
+DROP TABLE IF EXISTS mail_domain;
+CREATE TABLE mail_domain (
+  domain_id int(11) 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_id int(11) NOT NULL default '0',
+  domain varchar(255) NOT NULL default '',
+  type enum('local','relay','alias') NOT NULL default 'local',
+  destination varchar(255) NOT NULL default '',
+  active tinyint(4) NOT NULL default '1',
+  PRIMARY KEY  (domain_id),
+  KEY server_id (server_id,domain,type)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_domain`
+#
+
+INSERT INTO mail_domain VALUES (1, 1, 0, 'riud', 'riud', '', 1, 'test.int', 'local', '', 1);
+INSERT INTO mail_domain VALUES (2, 1, 0, 'riud', 'riud', '', 1, 'test2.int', 'alias', 'test.int', 1);
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_domain_catchall`
+#
+
+DROP TABLE IF EXISTS mail_domain_catchall;
+CREATE TABLE mail_domain_catchall (
+  domain_catchall_id int(11) 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_id int(11) NOT NULL default '0',
+  domain varchar(255) NOT NULL default '',
+  destination varchar(255) NOT NULL default '',
+  active enum('0','1') NOT NULL default '1',
+  PRIMARY KEY  (domain_catchall_id),
+  KEY server_id (server_id,domain)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_domain_catchall`
+#
+
+INSERT INTO mail_domain_catchall VALUES (1, 1, 1, 'riud', 'riud', '', 1, 'test.int', 'till@test.int', '1');
+# --------------------------------------------------------
+
+#
+# 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_redirect`
+#
+
+DROP TABLE IF EXISTS mail_redirect;
+CREATE TABLE mail_redirect (
+  redirect_id int(11) 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_id int(11) NOT NULL default '0',
+  email varchar(255) NOT NULL default '',
+  destination varchar(255) NOT NULL default '',
+  type enum('alias','forward') NOT NULL default 'alias',
+  active enum('0','1') NOT NULL default '1',
+  PRIMARY KEY  (redirect_id),
+  KEY server_id (server_id,email)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_redirect`
+#
+
+INSERT INTO mail_redirect VALUES (1, 1, 0, 'riud', 'riud', '', 1, 'tom@test.int', 'tt@test.int', 'alias', '1');
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_spamfilter`
+#
+
+DROP TABLE IF EXISTS mail_spamfilter;
+CREATE TABLE mail_spamfilter (
+  spamfilter_id int(11) 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_id int(11) NOT NULL default '0',
+  email varchar(255) NOT NULL default '',
+  spam_rewrite_score_int int(11) NOT NULL default '0',
+  spam_delete_score_int int(11) NOT NULL default '0',
+  spam_redirect_score_int int(11) NOT NULL default '0',
+  spam_rewrite_subject varchar(50) NOT NULL default '***SPAM***',
+  spam_redirect_maildir varchar(255) NOT NULL default '',
+  spam_redirect_maildir_purge int(11) NOT NULL default '7',
+  active enum('0','1') NOT NULL default '1',
+  PRIMARY KEY  (spamfilter_id),
+  KEY server_id (server_id,email)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_spamfilter`
+#
+
+INSERT INTO mail_spamfilter VALUES (1, 0, 0, '', '', '', 1, 'till@test.int', 100, 100, 1, '***SPAM mag ich nicht***', '/var/spool/mail/spam', 0, '1');
+INSERT INTO mail_spamfilter VALUES (2, 1, 0, 'riud', 'riud', '', 1, 'till2@test.int', 500, 1500, 700, '***SPAM***', '/var/spool/mail/till', 14, '1');
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_transport`
+#
+
+DROP TABLE IF EXISTS mail_transport;
+CREATE TABLE mail_transport (
+  whitelist_id int(11) 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_id int(11) NOT NULL default '0',
+  domain varchar(255) NOT NULL default '',
+  destination varchar(255) NOT NULL default '',
+  active enum('0','1') NOT NULL default '1',
+  PRIMARY KEY  (whitelist_id),
+  KEY server_id (server_id,destination),
+  KEY server_id_2 (server_id,domain)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `mail_transport`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `mail_whitelist`
+#
+
+DROP TABLE IF EXISTS mail_whitelist;
+CREATE TABLE mail_whitelist (
+  whitelist_id int(11) 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_id int(11) NOT NULL default '0',
+  address varchar(255) NOT NULL default '',
+  recipient varchar(255) NOT NULL default '',
+  active enum('0','1') NOT NULL default '1',
+  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 `rr`
+#
+
+DROP TABLE IF EXISTS rr;
+CREATE TABLE rr (
+  id int(10) unsigned NOT NULL auto_increment,
+  zone int(10) unsigned NOT NULL default '0',
+  name varchar(64) NOT NULL default '',
+  type enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NS','PTR','RP','SRV','TXT') default NULL,
+  data varchar(128) NOT NULL default '',
+  aux int(10) unsigned NOT NULL default '0',
+  ttl int(10) unsigned NOT NULL default '86400',
+  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 '',
+  PRIMARY KEY  (id),
+  UNIQUE KEY rr (zone,name,type,data)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `rr`
+#
+
+INSERT INTO rr VALUES (1, 2, '1', 'PTR', 'www.ensign.de.', 0, 86400, 1, 0, 'riud', 'riud', '');
+INSERT INTO rr VALUES (2, 1, 'www', 'A', '192.168.0.1', 0, 86400, 1, 0, 'riud', 'riud', '');
+INSERT INTO rr VALUES (3, 1, 'ensign.de', 'A', '192.168.0.1', 0, 86400, 1, 0, 'riud', 'riud', '');
+# --------------------------------------------------------
+
+#
+# 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 tinyint(4) NOT NULL default '0',
+  web_server tinyint(4) NOT NULL default '0',
+  dns_server tinyint(4) NOT NULL default '0',
+  file_server tinyint(4) NOT NULL default '0',
+  db_server tinyint(4) NOT NULL default '0',
+  vserver_server tinyint(4) NOT NULL default '0',
+  config text NOT NULL,
+  update tinyint(4) NOT NULL default '0',
+  active tinyint(4) 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, '[global]\r\nwebserver=apache\r\nmailserver=exim\r\ndnsserver=mydns\r\n\r\n[mail]\r\nmodule=exim_mysql\r\nmaildir_path=/var/spool/mail/[domain]/[localpart]\r\nmailuser_uid=0\r\nmailuser_gid=0', 0, 1);
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `soa`
+#
+
+DROP TABLE IF EXISTS soa;
+CREATE TABLE soa (
+  id int(10) unsigned NOT NULL auto_increment,
+  origin varchar(255) NOT NULL default '',
+  ns varchar(255) NOT NULL default '',
+  mbox varchar(255) NOT NULL default '',
+  serial int(10) unsigned NOT NULL default '1',
+  refresh int(10) unsigned NOT NULL default '28800',
+  retry int(10) unsigned NOT NULL default '7200',
+  expire int(10) unsigned NOT NULL default '604800',
+  minimum int(10) unsigned NOT NULL default '86400',
+  ttl int(10) unsigned NOT NULL default '86400',
+  active enum('Y','N') NOT NULL default 'Y',
+  xfer varchar(255) NOT NULL default '',
+  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 '',
+  PRIMARY KEY  (id),
+  UNIQUE KEY origin (origin),
+  KEY active (active)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `soa`
+#
+
+INSERT INTO soa VALUES (1, 'ensign.de.', 'ns1.example.com.', 'admin.example.com.', 2006012103, 28800, 7200, 604800, 86400, 86400, 'Y', '', 1, 0, 'riud', 'riud', '');
+INSERT INTO soa VALUES (2, '0.168.192.in-addr.arpa.', 'ns1.example.com.', 'admin.example.com.', 2006012101, 28800, 7200, 604800, 86400, 86400, 'Y', '', 1, 0, 'riud', 'riud', '');
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `sys_datalog`
+#
+
+DROP TABLE IF EXISTS sys_datalog;
+CREATE TABLE sys_datalog (
+  datalog_id bigint(20) NOT NULL auto_increment,
+  dbtable varchar(255) NOT NULL default '',
+  dbidx varchar(255) NOT NULL default '',
+  server_id int(11) NOT NULL default '0',
+  action char(1) NOT NULL default '',
+  tstamp bigint(20) NOT NULL default '0',
+  user varchar(255) NOT NULL default '',
+  data text NOT NULL,
+  PRIMARY KEY  (datalog_id)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `sys_datalog`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `sys_dbsync`
+#
+
+DROP TABLE IF EXISTS sys_dbsync;
+CREATE TABLE sys_dbsync (
+  id bigint(20) NOT NULL auto_increment,
+  jobname varchar(255) NOT NULL default '',
+  sync_interval_minutes int(11) NOT NULL default '0',
+  db_type varchar(255) NOT NULL default '',
+  db_host varchar(255) NOT NULL default '',
+  db_name varchar(255) NOT NULL default '',
+  db_username varchar(255) NOT NULL default '',
+  db_password varchar(255) NOT NULL default '',
+  db_tables varchar(255) NOT NULL default 'admin,forms',
+  empty_datalog int(11) NOT NULL default '0',
+  sync_datalog_external int(11) NOT NULL default '0',
+  active int(11) NOT NULL default '1',
+  last_datalog_id bigint(20) NOT NULL default '0',
+  PRIMARY KEY  (id),
+  KEY last_datalog_id (last_datalog_id)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `sys_dbsync`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `sys_filesync`
+#
+
+DROP TABLE IF EXISTS sys_filesync;
+CREATE TABLE sys_filesync (
+  id bigint(20) NOT NULL auto_increment,
+  jobname varchar(255) NOT NULL default '',
+  sync_interval_minutes int(11) NOT NULL default '0',
+  ftp_host varchar(255) NOT NULL default '',
+  ftp_path varchar(255) NOT NULL default '',
+  ftp_username varchar(255) NOT NULL default '',
+  ftp_password varchar(255) NOT NULL default '',
+  local_path varchar(255) NOT NULL default '',
+  wput_options varchar(255) NOT NULL default '--timestamping --reupload --dont-continue',
+  active int(11) NOT NULL default '1',
+  PRIMARY KEY  (id)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `sys_filesync`
+#
+
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `sys_group`
+#
+
+DROP TABLE IF EXISTS sys_group;
+CREATE TABLE sys_group (
+  groupid int(11) NOT NULL auto_increment,
+  name varchar(255) NOT NULL default '',
+  description text NOT NULL,
+  PRIMARY KEY  (groupid)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `sys_group`
+#
+
+INSERT INTO sys_group VALUES (1, 'admin', 'Administrators group');
+INSERT INTO sys_group VALUES (2, 'user', 'Users Group');
+# --------------------------------------------------------
+
+#
+# Tabellenstruktur f�r Tabelle `sys_user`
+#
+
+DROP TABLE IF EXISTS sys_user;
+CREATE TABLE sys_user (
+  userid int(11) 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 '',
+  username varchar(100) NOT NULL default '',
+  passwort varchar(100) NOT NULL default '',
+  modules varchar(255) NOT NULL default '',
+  startmodule varchar(255) NOT NULL default '',
+  app_theme varchar(100) NOT NULL default 'default',
+  typ varchar(20) NOT NULL default 'user',
+  active tinyint(4) NOT NULL default '1',
+  name varchar(100) NOT NULL default '',
+  vorname varchar(100) NOT NULL default '',
+  unternehmen varchar(100) NOT NULL default '',
+  strasse varchar(100) NOT NULL default '',
+  ort varchar(100) NOT NULL default '',
+  plz varchar(10) NOT NULL default '',
+  land varchar(50) NOT NULL default '',
+  email varchar(100) NOT NULL default '',
+  url varchar(255) NOT NULL default '',
+  telefon varchar(100) NOT NULL default '',
+  fax varchar(100) NOT NULL default '',
+  language varchar(10) NOT NULL default 'de',
+  groups varchar(255) NOT NULL default '',
+  default_group int(11) NOT NULL default '0',
+  PRIMARY KEY  (userid)
+) TYPE=MyISAM;
+
+#
+# Daten f�r Tabelle `sys_user`
+#
+
+INSERT INTO sys_user VALUES (1, 1, 0, 'riud', 'riud', '', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin,designer,mail,dns', 'admin', 'default', 'admin', 1, '', 'Administrator', '', '', '', '', '', '', '', '', '', 'en', '1,2', 0);
+

--
Gitblit v1.9.1