| | |
|---|
| | | # http://www.phpmyadmin.net/ (download page)
|
|---|
| | | #
|
|---|
| | | # Host: localhost
|
|---|
| | | # Erstellungszeit: 09. November 2005 um 23:22
|
|---|
| | | # Erstellungszeit: 24. November 2005 um 23:49
|
|---|
| | | # Server Version: 4.0.23
|
|---|
| | | # PHP-Version: 5.0.3
|
|---|
| | | # Datenbank: `ispconfig3`
|
|---|
| | |
|---|
| | | # --------------------------------------------------------
|
|---|
| | |
|
|---|
| | | #
|
|---|
| | | # 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 '',
|
|---|
| | | cc varchar(50) NOT NULL default '',
|
|---|
| | | forward varchar(50) NOT NULL default '',
|
|---|
| | | autoresponder enum('0','1') NOT NULL default '0',
|
|---|
| | | autoresponder_text tinytext NOT NULL,
|
|---|
| | | active enum('0','1') NOT NULL default '1',
|
|---|
| | | 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_box`
|
|---|
| | | #
|
|---|
| | |
|
|---|
| | | INSERT INTO mail_box VALUES (1, 1, 0, 'riud', 'riud', '', 1, 'till@test.de', '$1$ye3.TQ1.$v/RvqbuU.Gh7UrLlA6HqX/', '', '', 0, 0, '', '', '', '', '0', '', '1', 'no', 'no', 'no');
|
|---|
| | | # --------------------------------------------------------
|
|---|
| | |
|
|---|
| | | #
|
|---|
| | | # Tabellenstruktur für Tabelle `mail_domain`
|
|---|
| | | #
|
|---|
| | |
|
|---|
| | |
|---|
| | | 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','manual_relay','alias') NOT NULL default 'local',
|
|---|
| | | type enum('local','relay','alias') NOT NULL default 'local',
|
|---|
| | | relay_host varchar(255) NOT NULL default '',
|
|---|
| | | destination varchar(255) NOT NULL default '',
|
|---|
| | | active tinyint(4) NOT NULL default '1',
|
|---|
| | |
|---|
| | | #
|
|---|
| | |
|
|---|
| | | INSERT INTO mail_domain VALUES (1, 1, 0, 'riud', 'riud', '', 1, 'test.de', 'local', '', '', 1);
|
|---|
| | | # --------------------------------------------------------
|
|---|
| | |
|
|---|
| | | #
|
|---|
| | | # 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`
|
|---|
| | | #
|
|---|
| | |
|
|---|
| | | INSERT INTO mail_domain VALUES (2, 1, 0, 'riud', 'riud', '', 1, 'test2.de', 'alias', '', 'test.de', 1);
|
|---|
| | | # --------------------------------------------------------
|
|---|
| | |
|
|---|
| | | #
|
|---|
| | |
|---|
| | |
|
|---|
| | | DROP TABLE IF EXISTS mail_domain_catchall;
|
|---|
| | | CREATE TABLE mail_domain_catchall (
|
|---|
| | | virtual_default_id int(11) NOT NULL auto_increment,
|
|---|
| | | 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 '',
|
|---|
| | | dest varchar(255) NOT NULL default '',
|
|---|
| | | PRIMARY KEY (virtual_default_id),
|
|---|
| | | destination varchar(255) NOT NULL default '',
|
|---|
| | | PRIMARY KEY (domain_catchall_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`
|
|---|
| | | #
|
|---|
| | |
|
|---|
| | | # --------------------------------------------------------
|
|---|
| | |
|---|
| | | # 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.de', 'till@test.de', 'alias', '1');
|
|---|
| | | INSERT INTO mail_redirect VALUES (2, 1, 0, 'riud', 'riud', '', 1, 'hallo@test.de', 't.brehm@ensign.de', 'forward', '1');
|
|---|
| | | # --------------------------------------------------------
|
|---|
| | |
|
|---|
| | | #
|
|---|
| | |
|---|
| | | # Daten für Tabelle `sys_datalog`
|
|---|
| | | #
|
|---|
| | |
|
|---|
| | | INSERT INTO sys_datalog VALUES (1, 'mail_domain', 'domain_id:0', 'i', 1132758298, 'admin', 'a:5:{s:9:"server_id";a:2:{s:3:"old";N;s:3:"new";i:1;}s:6:"domain";a:2:{s:3:"old";N;s:3:"new";s:7:"test.de";}s:11:"destination";a:2:{s:3:"old";N;s:3:"new";s:8:"hallo.de";}s:4:"type";a:2:{s:3:"old";N;s:3:"new";s:5:"alias";}s:6:"active";a:2:{s:3:"old";N;s:3:"new";i:1;}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (2, 'mail_domain', 'domain_id:2', 'u', 1132759303, 'admin', 'a:1:{s:6:"domain";a:2:{s:3:"old";s:7:"test.de";s:3:"new";s:8:"test2.de";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (3, 'mail_domain', 'domain_id:2', 'u', 1132759328, 'admin', 'a:1:{s:11:"destination";a:2:{s:3:"old";s:8:"hallo.de";s:3:"new";s:7:"test.de";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (4, 'mail_box', 'mailbox_id:0', 'i', 1132775402, 'admin', 'a:3:{s:5:"email";a:2:{s:3:"old";N;s:3:"new";s:12:"till@test.de";}s:8:"cryptpwd";a:2:{s:3:"old";N;s:3:"new";s:5:"hallo";}s:6:"active";a:2:{s:3:"old";N;s:3:"new";i:1;}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (5, 'mail_box', 'mailbox_id:1', 'u', 1132775575, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (6, 'mail_box', 'mailbox_id:1', 'u', 1132775587, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (7, 'mail_box', 'mailbox_id:1', 'u', 1132775898, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (8, 'mail_box', 'mailbox_id:1', 'u', 1132775901, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (9, 'mail_box', 'mailbox_id:1', 'u', 1132777011, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (10, 'mail_box', 'mailbox_id:1', 'u', 1132777757, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (11, 'mail_box', 'mailbox_id:1', 'u', 1132777760, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (12, 'mail_box', 'mailbox_id:1', 'u', 1132777764, 'admin', 'a:2:{s:5:"email";a:2:{s:3:"old";s:12:"till@test.de";s:3:"new";s:13:"till2@test.de";}s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (13, 'mail_box', 'mailbox_id:1', 'u', 1132777768, 'admin', 'a:2:{s:5:"email";a:2:{s:3:"old";s:13:"till2@test.de";s:3:"new";s:12:"till@test.de";}s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (14, 'mail_box', 'mailbox_id:1', 'u', 1132778380, 'admin', 'a:2:{s:9:"server_id";a:2:{s:3:"old";s:1:"0";s:3:"new";i:1;}s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (15, 'mail_box', 'mailbox_id:1', 'u', 1132784990, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (16, 'mail_box', 'mailbox_id:0', 'i', 1132785424, 'admin', 'a:3:{s:9:"server_id";a:2:{s:3:"old";N;s:3:"new";i:1;}s:5:"email";a:2:{s:3:"old";N;s:3:"new";s:8:"@test.de";}s:6:"active";a:2:{s:3:"old";N;s:3:"new";i:1;}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (17, 'mail_box', 'mailbox_id:1', 'u', 1132786068, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (18, 'mail_box', 'mailbox_id:1', 'u', 1132786083, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (19, 'mail_box', 'mailbox_id:1', 'u', 1132786772, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (20, 'mail_box', 'mailbox_id:1', 'u', 1132786777, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:32:"598d4c200461b81522a3328565c25f7c";s:3:"new";s:4:"test";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (21, 'mail_box', 'mailbox_id:1', 'u', 1132786796, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:0:"";s:3:"new";s:4:"test";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (22, 'mail_box', 'mailbox_id:1', 'u', 1132786860, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:0:"";s:3:"new";s:4:"test";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (23, 'mail_box', 'mailbox_id:1', 'u', 1132787252, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:0:"";s:3:"new";s:4:"test";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (24, 'mail_box', 'mailbox_id:1', 'u', 1132787548, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:34:"$1$ye3.TQ1.$v/RvqbuU.Gh7UrLlA6HqX/";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (25, 'mail_box', 'mailbox_id:1', 'u', 1132787761, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:34:"$1$ye3.TQ1.$v/RvqbuU.Gh7UrLlA6HqX/";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (26, 'mail_box', 'mailbox_id:0', 'i', 1132787775, 'admin', 'a:3:{s:9:"server_id";a:2:{s:3:"old";N;s:3:"new";i:1;}s:5:"email";a:2:{s:3:"old";N;s:3:"new";s:12:"test@test.de";}s:6:"active";a:2:{s:3:"old";N;s:3:"new";i:1;}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (27, 'mail_box', 'mailbox_id:1', 'u', 1132788121, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:34:"$1$ye3.TQ1.$v/RvqbuU.Gh7UrLlA6HqX/";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (28, 'mail_box', 'mailbox_id:1', 'u', 1132788482, 'admin', 'a:1:{s:8:"cryptpwd";a:2:{s:3:"old";s:34:"$1$ye3.TQ1.$v/RvqbuU.Gh7UrLlA6HqX/";s:3:"new";s:0:"";}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (29, 'mail_redirect', 'redirect_id:0', 'i', 1132859789, 'admin', 'a:5:{s:9:"server_id";a:2:{s:3:"old";N;s:3:"new";i:1;}s:5:"email";a:2:{s:3:"old";N;s:3:"new";s:11:"tom@test.de";}s:11:"destination";a:2:{s:3:"old";N;s:3:"new";s:12:"till@test.de";}s:4:"type";a:2:{s:3:"old";N;s:3:"new";s:5:"alias";}s:6:"active";a:2:{s:3:"old";N;s:3:"new";i:1;}}');
|
|---|
| | | INSERT INTO sys_datalog VALUES (30, 'mail_redirect', 'redirect_id:0', 'i', 1132868928, 'admin', 'a:5:{s:9:"server_id";a:2:{s:3:"old";N;s:3:"new";i:1;}s:5:"email";a:2:{s:3:"old";N;s:3:"new";s:13:"hallo@test.de";}s:11:"destination";a:2:{s:3:"old";N;s:3:"new";s:17:"t.brehm@ensign.de";}s:4:"type";a:2:{s:3:"old";N;s:3:"new";s:7:"forward";}s:6:"active";a:2:{s:3:"old";N;s:3:"new";i:1;}}');
|
|---|
| | | # --------------------------------------------------------
|
|---|
| | |
|
|---|
| | | #
|
|---|
