From dcff5718f345f55f7ea81f18d1f086facde4eacf Mon Sep 17 00:00:00 2001 From: pedro_morgan <pedro_morgan@ispconfig3> Date: Mon, 20 Aug 2007 23:14:51 -0400 Subject: [PATCH] * Using new ISPC_*_PATH constants * Adding new data schema (to be moved shortly * no more $conf['classpath'] --- interface/sql/ispconfig3db.sql | 78 +++++++++++++++++++------------------- 1 files changed, 39 insertions(+), 39 deletions(-) diff --git a/interface/sql/ispconfig3db.sql b/interface/sql/ispconfig3db.sql index 7d2fe6e..1b79ac7 100644 --- a/interface/sql/ispconfig3db.sql +++ b/interface/sql/ispconfig3db.sql @@ -10,7 +10,7 @@ # -------------------------------------------------------- # -# Tabellenstruktur f�r Tabelle `mail_blacklist` +# Tabellenstruktur f�r Tabelle `mail_blacklist` # DROP TABLE IF EXISTS mail_blacklist; @@ -30,14 +30,14 @@ ) 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; @@ -65,7 +65,7 @@ ) 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'); @@ -73,7 +73,7 @@ # -------------------------------------------------------- # -# Tabellenstruktur f�r Tabelle `mail_domain` +# Tabellenstruktur f�r Tabelle `mail_domain` # DROP TABLE IF EXISTS mail_domain; @@ -94,7 +94,7 @@ ) 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); @@ -102,7 +102,7 @@ # -------------------------------------------------------- # -# Tabellenstruktur f�r Tabelle `mail_domain_catchall` +# Tabellenstruktur f�r Tabelle `mail_domain_catchall` # DROP TABLE IF EXISTS mail_domain_catchall; @@ -122,14 +122,14 @@ ) 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; @@ -145,13 +145,13 @@ ) 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; @@ -167,13 +167,13 @@ ) 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; @@ -194,14 +194,14 @@ ) 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; @@ -226,7 +226,7 @@ ) 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'); @@ -234,7 +234,7 @@ # -------------------------------------------------------- # -# Tabellenstruktur f�r Tabelle `mail_transport` +# Tabellenstruktur f�r Tabelle `mail_transport` # DROP TABLE IF EXISTS mail_transport; @@ -255,13 +255,13 @@ ) 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; @@ -281,13 +281,13 @@ ) 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; @@ -326,13 +326,13 @@ ) 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; @@ -354,7 +354,7 @@ ) 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', ''); @@ -363,7 +363,7 @@ # -------------------------------------------------------- # -# Tabellenstruktur f�r Tabelle `server` +# Tabellenstruktur f�r Tabelle `server` # DROP TABLE IF EXISTS server; @@ -382,20 +382,20 @@ 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; @@ -423,7 +423,7 @@ ) 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', ''); @@ -431,7 +431,7 @@ # -------------------------------------------------------- # -# Tabellenstruktur f�r Tabelle `sys_datalog` +# Tabellenstruktur f�r Tabelle `sys_datalog` # DROP TABLE IF EXISTS sys_datalog; @@ -448,13 +448,13 @@ ) 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; @@ -477,13 +477,13 @@ ) 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; @@ -502,13 +502,13 @@ ) 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; @@ -520,7 +520,7 @@ ) TYPE=MyISAM; # -# Daten f�r Tabelle `sys_group` +# Daten f�r Tabelle `sys_group` # INSERT INTO sys_group VALUES (1, 'admin', 'Administrators group'); @@ -528,7 +528,7 @@ # -------------------------------------------------------- # -# Tabellenstruktur f�r Tabelle `sys_user` +# Tabellenstruktur f�r Tabelle `sys_user` # DROP TABLE IF EXISTS sys_user; @@ -564,7 +564,7 @@ ) 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); -- Gitblit v1.9.1