| | |
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `mail_blacklist`
|
| | | # Tabellenstruktur f�r Tabelle `mail_blacklist`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS mail_blacklist;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `mail_blacklist`
|
| | | # 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`
|
| | | # Tabellenstruktur f�r Tabelle `mail_box`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS mail_box;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `mail_box`
|
| | | # 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');
|
| | |
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `mail_domain`
|
| | | # Tabellenstruktur f�r Tabelle `mail_domain`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS mail_domain;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `mail_domain`
|
| | | # Daten f�r Tabelle `mail_domain`
|
| | | #
|
| | |
|
| | | INSERT INTO mail_domain VALUES (1, 1, 0, 'riud', 'riud', '', 1, 'test.int', 'local', '', 1);
|
| | |
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `mail_domain_catchall`
|
| | | # Tabellenstruktur f�r Tabelle `mail_domain_catchall`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS mail_domain_catchall;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `mail_domain_catchall`
|
| | | # 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`
|
| | | # Tabellenstruktur f�r Tabelle `mail_greylist`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS mail_greylist;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `mail_greylist`
|
| | | # Daten f�r Tabelle `mail_greylist`
|
| | | #
|
| | |
|
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `mail_mailman_domain`
|
| | | # Tabellenstruktur f�r Tabelle `mail_mailman_domain`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS mail_mailman_domain;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `mail_mailman_domain`
|
| | | # Daten f�r Tabelle `mail_mailman_domain`
|
| | | #
|
| | |
|
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `mail_redirect`
|
| | | # Tabellenstruktur f�r Tabelle `mail_redirect`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS mail_redirect;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `mail_redirect`
|
| | | # 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`
|
| | | # Tabellenstruktur f�r Tabelle `mail_spamfilter`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS mail_spamfilter;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `mail_spamfilter`
|
| | | # 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');
|
| | |
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `mail_transport`
|
| | | # Tabellenstruktur f�r Tabelle `mail_transport`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS mail_transport;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `mail_transport`
|
| | | # Daten f�r Tabelle `mail_transport`
|
| | | #
|
| | |
|
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `mail_whitelist`
|
| | | # Tabellenstruktur f�r Tabelle `mail_whitelist`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS mail_whitelist;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `mail_whitelist`
|
| | | # Daten f�r Tabelle `mail_whitelist`
|
| | | #
|
| | |
|
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `reseller`
|
| | | # Tabellenstruktur f�r Tabelle `reseller`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS reseller;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `reseller`
|
| | | # Daten f�r Tabelle `reseller`
|
| | | #
|
| | |
|
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `rr`
|
| | | # Tabellenstruktur f�r Tabelle `rr`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS rr;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `rr`
|
| | | # Daten f�r Tabelle `rr`
|
| | | #
|
| | |
|
| | | INSERT INTO rr VALUES (1, 2, '1', 'PTR', 'www.ensign.de.', 0, 86400, 1, 0, 'riud', 'riud', '');
|
| | |
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `server`
|
| | | # Tabellenstruktur f�r Tabelle `server`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS server;
|
| | |
| | | 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',
|
| | | `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`
|
| | | # 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`
|
| | | # Tabellenstruktur f�r Tabelle `soa`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS soa;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `soa`
|
| | | # 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', '');
|
| | |
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `sys_datalog`
|
| | | # Tabellenstruktur f�r Tabelle `sys_datalog`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS sys_datalog;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `sys_datalog`
|
| | | # Daten f�r Tabelle `sys_datalog`
|
| | | #
|
| | |
|
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `sys_dbsync`
|
| | | # Tabellenstruktur f�r Tabelle `sys_dbsync`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS sys_dbsync;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `sys_dbsync`
|
| | | # Daten f�r Tabelle `sys_dbsync`
|
| | | #
|
| | |
|
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `sys_filesync`
|
| | | # Tabellenstruktur f�r Tabelle `sys_filesync`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS sys_filesync;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `sys_filesync`
|
| | | # Daten f�r Tabelle `sys_filesync`
|
| | | #
|
| | |
|
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `sys_group`
|
| | | # Tabellenstruktur f�r Tabelle `sys_group`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS sys_group;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `sys_group`
|
| | | # Daten f�r Tabelle `sys_group`
|
| | | #
|
| | |
|
| | | INSERT INTO sys_group VALUES (1, 'admin', 'Administrators group');
|
| | |
| | | # --------------------------------------------------------
|
| | |
|
| | | #
|
| | | # Tabellenstruktur für Tabelle `sys_user`
|
| | | # Tabellenstruktur f�r Tabelle `sys_user`
|
| | | #
|
| | |
|
| | | DROP TABLE IF EXISTS sys_user;
|
| | |
| | | ) TYPE=MyISAM;
|
| | |
|
| | | #
|
| | | # Daten für Tabelle `sys_user`
|
| | | # 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);
|