# 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`
|
--
|
|
-- --------------------------------------------------------
|
