gitlabFork/ISPConfig3.git - Solinfo Gitblit

Added support for mongodb. Many thanks to MaddinXx for the patch. http://ww...

tbrehm

2013-08-02 2332b2279d8a8599b4f041370315edc9544b1560

commit \| author \| age
d82984	1	/*
02bf99	2	Copyright (c) 2007-2012, Till Brehm, projektfarm Gmbh
d82984	3	All rights reserved.
T	4
	5	Redistribution and use in source and binary forms, with or without modification,
	6	are permitted provided that the following conditions are met:
	7
	8	* Redistributions of source code must retain the above copyright notice,
	9	this list of conditions and the following disclaimer.
	10	* Redistributions in binary form must reproduce the above copyright notice,
	11	this list of conditions and the following disclaimer in the documentation
	12	and/or other materials provided with the distribution.
	13	* Neither the name of ISPConfig nor the names of its contributors
	14	may be used to endorse or promote products derived from this software without
	15	specific prior written permission.
	16
	17	THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
	18	ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
	19	WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
	20	IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
	21	INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
	22	BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
	23	DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
	24	OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
	25	NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
	26	EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
	27	*/
	28
2332b2	29	-- Includes
T	30	--
32f943	31	-- iso_country_list.sql
2332b2	32	--
32f943	33	-- This will create and then populate a MySQL table with a list of the names and
L	34	-- ISO 3166 codes for countries in existence as of the date below.
2332b2	35	--
32f943	36	-- For updates to this file, see http://27.org/isocountrylist/
L	37	-- For more about ISO 3166, see http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html
2332b2	38	--
32f943	39	-- Created by getisocountrylist.pl on Sun Nov 2 14:59:20 2003.
L	40	-- Wm. Rhodes <iso_country_list@27.org>
2332b2	41	--
32f943	42
2332b2	43	--
d82984	44	-- ISPConfig 3
T	45	-- DB-Version: 3.0.0.9
2332b2	46	--
d82984	47
T	48	SET FOREIGN_KEY_CHECKS = 0;
	49
	50	-- --------------------------------------------------------
	51	-- --------------------------------------------------------
	52	-- DB-STRUCTURE
	53	-- --------------------------------------------------------
	54	-- --------------------------------------------------------
	55
32f943	56	--
477d4e	57	-- Table structure for table `aps_instances`
T	58	--
	59
	60	CREATE TABLE IF NOT EXISTS `aps_instances` (
	61	`id` int(4) NOT NULL AUTO_INCREMENT,
0e33dd	62	`sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
T	63	`sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
	64	`sys_perm_user` varchar(5) DEFAULT NULL,
	65	`sys_perm_group` varchar(5) DEFAULT NULL,
	66	`sys_perm_other` varchar(5) DEFAULT NULL,
477d4e	67	`server_id` int(11) NOT NULL DEFAULT '0',
T	68	`customer_id` int(4) NOT NULL,
	69	`package_id` int(4) NOT NULL,
	70	`instance_status` int(4) NOT NULL,
	71	PRIMARY KEY (`id`)
	72	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
	73
	74	-- --------------------------------------------------------
	75
	76	--
	77	-- Table structure for table `aps_instances_settings`
	78	--
	79
	80	CREATE TABLE IF NOT EXISTS `aps_instances_settings` (
	81	`id` int(4) NOT NULL AUTO_INCREMENT,
	82	`server_id` int(11) NOT NULL DEFAULT '0',
	83	`instance_id` int(4) NOT NULL,
	84	`name` varchar(255) NOT NULL,
	85	`value` text NOT NULL,
	86	PRIMARY KEY (`id`)
	87	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
	88
	89	-- --------------------------------------------------------
	90
	91	--
	92	-- Table structure for table `aps_packages`
	93	--
	94
	95	CREATE TABLE IF NOT EXISTS `aps_packages` (
	96	`id` int(4) NOT NULL AUTO_INCREMENT,
	97	`path` varchar(255) NOT NULL,
	98	`name` varchar(255) NOT NULL,
	99	`category` varchar(255) NOT NULL,
	100	`version` varchar(20) NOT NULL,
	101	`release` int(4) NOT NULL,
7d4360	102	`package_url` TEXT NOT NULL,
477d4e	103	`package_status` int(1) NOT NULL DEFAULT '2',
T	104	PRIMARY KEY (`id`)
	105	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
	106
	107	-- --------------------------------------------------------
	108
	109	--
	110	-- Tabellenstruktur für Tabelle `aps_settings`
	111	--
	112
	113	CREATE TABLE IF NOT EXISTS `aps_settings` (
	114	`id` int(4) NOT NULL AUTO_INCREMENT,
	115	`name` varchar(255) NOT NULL,
	116	`value` text NOT NULL,
	117	PRIMARY KEY (`id`),
	118	UNIQUE KEY `name` (`name`)
	119	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
	120
	121	-- --------------------------------------------------------
	122
	123	--
32f943	124	-- Table structure for table `attempts_login`
L	125	--
	126
	127	CREATE TABLE `attempts_login` (
	128	`ip` varchar(39) NOT NULL,
	129	`times` int(11) DEFAULT NULL,
	130	`login_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
	131	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
	132
	133	-- --------------------------------------------------------
	134
	135	--
	136	-- Table structure for table `client`
	137	--
d82984	138
T	139	CREATE TABLE `client` (
32f943	140	`client_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
L	141	`sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
	142	`sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
	143	`sys_perm_user` varchar(5) DEFAULT NULL,
	144	`sys_perm_group` varchar(5) DEFAULT NULL,
	145	`sys_perm_other` varchar(5) DEFAULT NULL,
	146	`company_name` varchar(64) DEFAULT NULL,
	147	`company_id` varchar(30) DEFAULT NULL,
	148	`contact_name` varchar(64) DEFAULT NULL,
	149	`customer_no` varchar(64) DEFAULT NULL,
	150	`vat_id` varchar(64) DEFAULT NULL,
	151	`street` varchar(255) DEFAULT NULL,
	152	`zip` varchar(32) DEFAULT NULL,
	153	`city` varchar(64) DEFAULT NULL,
	154	`state` varchar(32) DEFAULT NULL,
	155	`country` char(2) DEFAULT NULL,
	156	`telephone` varchar(32) DEFAULT NULL,
	157	`mobile` varchar(32) DEFAULT NULL,
	158	`fax` varchar(32) DEFAULT NULL,
	159	`email` varchar(255) DEFAULT NULL,
d82984	160	`internet` varchar(255) NOT NULL,
32f943	161	`icq` varchar(16) DEFAULT NULL,
d82984	162	`notes` text,
8d0c35	163	`bank_account_owner` varchar(255) DEFAULT NULL,
7ad91f	164	`bank_account_number` varchar(255) DEFAULT NULL,
F	165	`bank_code` varchar(255) DEFAULT NULL,
	166	`bank_name` varchar(255) DEFAULT NULL,
	167	`bank_account_iban` varchar(255) DEFAULT NULL,
	168	`bank_account_swift` varchar(255) DEFAULT NULL,
bfcdef	169	`paypal_email` varchar(255) DEFAULT NULL,
32f943	170	`default_mailserver` int(11) unsigned NOT NULL DEFAULT '1',
L	171	`limit_maildomain` int(11) NOT NULL DEFAULT '-1',
	172	`limit_mailbox` int(11) NOT NULL DEFAULT '-1',
	173	`limit_mailalias` int(11) NOT NULL DEFAULT '-1',
	174	`limit_mailaliasdomain` int(11) NOT NULL DEFAULT '-1',
	175	`limit_mailforward` int(11) NOT NULL DEFAULT '-1',
	176	`limit_mailcatchall` int(11) NOT NULL DEFAULT '-1',
	177	`limit_mailrouting` int(11) NOT NULL DEFAULT '0',
	178	`limit_mailfilter` int(11) NOT NULL DEFAULT '-1',
	179	`limit_fetchmail` int(11) NOT NULL DEFAULT '-1',
	180	`limit_mailquota` int(11) NOT NULL DEFAULT '-1',
	181	`limit_spamfilter_wblist` int(11) NOT NULL DEFAULT '0',
	182	`limit_spamfilter_user` int(11) NOT NULL DEFAULT '0',
	183	`limit_spamfilter_policy` int(11) NOT NULL DEFAULT '0',
	184	`default_webserver` int(11) unsigned NOT NULL DEFAULT '1',
d82984	185	`limit_web_ip` text,
32f943	186	`limit_web_domain` int(11) NOT NULL DEFAULT '-1',
L	187	`limit_web_quota` int(11) NOT NULL DEFAULT '-1',
72695f	188	`web_php_options` varchar(255) NOT NULL DEFAULT 'no,fast-cgi,cgi,mod,suphp,php-fpm',
ac099e	189	`limit_cgi` enum('n','y') NOT NULL DEFAULT 'n',
M	190	`limit_ssi` enum('n','y') NOT NULL DEFAULT 'n',
	191	`limit_perl` enum('n','y') NOT NULL DEFAULT 'n',
	192	`limit_ruby` enum('n','y') NOT NULL DEFAULT 'n',
	193	`limit_python` enum('n','y') NOT NULL DEFAULT 'n',
	194	`force_suexec` enum('n','y') NOT NULL DEFAULT 'y',
	195	`limit_hterror` enum('n','y') NOT NULL DEFAULT 'n',
	196	`limit_wildcard` enum('n','y') NOT NULL DEFAULT 'n',
	197	`limit_ssl` enum('n','y') NOT NULL DEFAULT 'n',
32f943	198	`limit_web_subdomain` int(11) NOT NULL DEFAULT '-1',
L	199	`limit_web_aliasdomain` int(11) NOT NULL DEFAULT '-1',
	200	`limit_ftp_user` int(11) NOT NULL DEFAULT '-1',
	201	`limit_shell_user` int(11) NOT NULL DEFAULT '0',
d82984	202	`ssh_chroot` varchar(255) NOT NULL DEFAULT 'no,jailkit,ssh-chroot',
32f943	203	`limit_webdav_user` int(11) NOT NULL DEFAULT '0',
526b99	204	`limit_aps` int(11) NOT NULL DEFAULT '-1',
32f943	205	`default_dnsserver` int(11) unsigned NOT NULL DEFAULT '1',
L	206	`limit_dns_zone` int(11) NOT NULL DEFAULT '-1',
615a0a	207	`default_slave_dnsserver` int(11) unsigned NOT NULL DEFAULT '1',
32f943	208	`limit_dns_slave_zone` int(11) NOT NULL DEFAULT '-1',
L	209	`limit_dns_record` int(11) NOT NULL DEFAULT '-1',
	210	`default_dbserver` int(11) NOT NULL DEFAULT '1',
	211	`limit_database` int(11) NOT NULL DEFAULT '-1',
	212	`limit_cron` int(11) NOT NULL DEFAULT '0',
	213	`limit_cron_type` enum('url','chrooted','full') NOT NULL DEFAULT 'url',
	214	`limit_cron_frequency` int(11) NOT NULL DEFAULT '5',
	215	`limit_traffic_quota` int(11) NOT NULL DEFAULT '-1',
	216	`limit_client` int(11) NOT NULL DEFAULT '0',
	217	`limit_mailmailinglist` int(11) NOT NULL DEFAULT '-1',
f5ea1b	218	`limit_openvz_vm` int(11) NOT NULL DEFAULT '0',
0adb35	219	`limit_openvz_vm_template_id` int(11) NOT NULL DEFAULT '0',
32f943	220	`parent_client_id` int(11) unsigned NOT NULL DEFAULT '0',
L	221	`username` varchar(64) DEFAULT NULL,
	222	`password` varchar(64) DEFAULT NULL,
	223	`language` char(2) NOT NULL DEFAULT 'en',
	224	`usertheme` varchar(32) NOT NULL DEFAULT 'default',
	225	`template_master` int(11) unsigned NOT NULL DEFAULT '0',
ae171f	226	`template_additional` text NOT NULL DEFAULT '',
d82984	227	`created_at` bigint(20) DEFAULT NULL,
32f943	228	`id_rsa` varchar(2000) NOT NULL DEFAULT '',
L	229	`ssh_rsa` varchar(600) NOT NULL DEFAULT '',
	230	PRIMARY KEY (`client_id`)
	231	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	232
T	233	-- --------------------------------------------------------
	234
b17cc6	235	--
F	236	-- Table structure for table `client_circle`
	237	--
	238
	239	CREATE TABLE `client_circle` (
	240	`circle_id` int(11) NOT NULL AUTO_INCREMENT,
	241	`sys_userid` int(11) NOT NULL DEFAULT '0',
	242	`sys_groupid` int(11) NOT NULL DEFAULT '0',
	243	`sys_perm_user` varchar(5) DEFAULT NULL,
	244	`sys_perm_group` varchar(5) DEFAULT NULL,
	245	`sys_perm_other` varchar(5) DEFAULT NULL,
	246	`circle_name` varchar(64) DEFAULT NULL,
	247	`client_ids` text,
	248	`description` text,
	249	`active` enum('n','y') NOT NULL default 'y',
	250	PRIMARY KEY (`circle_id`)
	251	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
	252
	253	-- --------------------------------------------------------
	254
2332b2	255	--
d82984	256	-- Table structure for table `client_template`
2332b2	257	--
d82984	258
T	259	CREATE TABLE `client_template` (
	260	`template_id` int(11) unsigned NOT NULL auto_increment,
	261	`sys_userid` int(11) unsigned NOT NULL default '0',
	262	`sys_groupid` int(11) unsigned NOT NULL default '0',
	263	`sys_perm_user` varchar(5) default NULL,
	264	`sys_perm_group` varchar(5) default NULL,
2332b2	265	`sys_perm_other` varchar(5) default NULL,
d82984	266	`template_name` varchar(64) NOT NULL,
T	267	`template_type` varchar(1) NOT NULL default 'm',
	268	`limit_maildomain` int(11) NOT NULL default '-1',
	269	`limit_mailbox` int(11) NOT NULL default '-1',
	270	`limit_mailalias` int(11) NOT NULL default '-1',
	271	`limit_mailaliasdomain` int(11) NOT NULL default '-1',
	272	`limit_mailforward` int(11) NOT NULL default '-1',
	273	`limit_mailcatchall` int(11) NOT NULL default '-1',
	274	`limit_mailrouting` int(11) NOT NULL default '0',
	275	`limit_mailfilter` int(11) NOT NULL default '-1',
	276	`limit_fetchmail` int(11) NOT NULL default '-1',
	277	`limit_mailquota` int(11) NOT NULL default '-1',
	278	`limit_spamfilter_wblist` int(11) NOT NULL default '0',
	279	`limit_spamfilter_user` int(11) NOT NULL default '0',
	280	`limit_spamfilter_policy` int(11) NOT NULL default '0',
	281	`limit_web_ip` text,
	282	`limit_web_domain` int(11) NOT NULL default '-1',
	283	`limit_web_quota` int(11) NOT NULL default '-1',
ba5cfd	284	`web_php_options` varchar(255) NOT NULL DEFAULT 'no',
ac099e	285	`limit_cgi` enum('n','y') NOT NULL DEFAULT 'n',
M	286	`limit_ssi` enum('n','y') NOT NULL DEFAULT 'n',
	287	`limit_perl` enum('n','y') NOT NULL DEFAULT 'n',
	288	`limit_ruby` enum('n','y') NOT NULL DEFAULT 'n',
	289	`limit_python` enum('n','y') NOT NULL DEFAULT 'n',
	290	`force_suexec` enum('n','y') NOT NULL DEFAULT 'y',
	291	`limit_hterror` enum('n','y') NOT NULL DEFAULT 'n',
	292	`limit_wildcard` enum('n','y') NOT NULL DEFAULT 'n',
	293	`limit_ssl` enum('n','y') NOT NULL DEFAULT 'n',
d82984	294	`limit_web_subdomain` int(11) NOT NULL default '-1',
T	295	`limit_web_aliasdomain` int(11) NOT NULL default '-1',
	296	`limit_ftp_user` int(11) NOT NULL default '-1',
	297	`limit_shell_user` int(11) NOT NULL default '0',
ba5cfd	298	`ssh_chroot` varchar(255) NOT NULL DEFAULT 'no',
d82984	299	`limit_webdav_user` int(11) NOT NULL default '0',
cc6568	300	`limit_aps` int(11) NOT NULL DEFAULT '-1',
d82984	301	`limit_dns_zone` int(11) NOT NULL default '-1',
T	302	`limit_dns_slave_zone` int(11) NOT NULL default '-1',
	303	`limit_dns_record` int(11) NOT NULL default '-1',
	304	`limit_database` int(11) NOT NULL default '-1',
	305	`limit_cron` int(11) NOT NULL default '0',
	306	`limit_cron_type` enum('url','chrooted','full') NOT NULL default 'url',
	307	`limit_cron_frequency` int(11) NOT NULL default '5',
	308	`limit_traffic_quota` int(11) NOT NULL default '-1',
	309	`limit_client` int(11) NOT NULL default '0',
	310	`limit_mailmailinglist` int(11) NOT NULL default '-1',
ba5cfd	311	`limit_openvz_vm` int(11) NOT NULL DEFAULT '0',
0adb35	312	`limit_openvz_vm_template_id` int(11) NOT NULL DEFAULT '0',
d82984	313	PRIMARY KEY (`template_id`)
32f943	314	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	315
32f943	316	-- --------------------------------------------------------
L	317
	318	--
	319	-- Table structure for table `country`
	320	--
	321
	322	CREATE TABLE `country` (
	323	`iso` char(2) NOT NULL,
	324	`name` varchar(64) NOT NULL,
	325	`printable_name` varchar(64) NOT NULL,
	326	`iso3` char(3) DEFAULT NULL,
	327	`numcode` smallint(6) DEFAULT NULL,
	328	PRIMARY KEY (`iso`)
	329	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
d82984	330
T	331	-- --------------------------------------------------------
	332
2332b2	333	--
d82984	334	-- Table structure for table `cron`
2332b2	335	--
d82984	336	CREATE TABLE `cron` (
T	337	`id` int(11) unsigned NOT NULL auto_increment,
	338	`sys_userid` int(11) unsigned NOT NULL default '0',
	339	`sys_groupid` int(11) unsigned NOT NULL default '0',
	340	`sys_perm_user` varchar(5) NULL default NULL,
	341	`sys_perm_group` varchar(5) NULL default NULL,
	342	`sys_perm_other` varchar(5) NULL default NULL,
	343	`server_id` int(11) unsigned NOT NULL default '0',
	344	`parent_domain_id` int(11) unsigned NOT NULL default '0',
	345	`type` enum('url','chrooted','full') NOT NULL default 'url',
f5ea1b	346	`command` TEXT NOT NULL,
d82984	347	`run_min` varchar(100) NULL,
T	348	`run_hour` varchar(100) NULL,
	349	`run_mday` varchar(100) NULL,
	350	`run_month` varchar(100) NULL,
	351	`run_wday` varchar(100) NULL,
	352	`active` enum('n','y') NOT NULL default 'y',
	353	PRIMARY KEY (`id`)
32f943	354	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	355
T	356	-- --------------------------------------------------------
	357
2332b2	358	--
ef55b5	359	-- Table structure for table `directive_snippets`
2332b2	360	--
ef55b5	361
F	362	CREATE TABLE IF NOT EXISTS `directive_snippets` (
	363	`directive_snippets_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	364	`sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
	365	`sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
	366	`sys_perm_user` varchar(5) DEFAULT NULL,
	367	`sys_perm_group` varchar(5) DEFAULT NULL,
	368	`sys_perm_other` varchar(5) DEFAULT NULL,
	369	`name` varchar(255) DEFAULT NULL,
	370	`type` varchar(255) DEFAULT NULL,
	371	`snippet` mediumtext,
	372	`active` enum('n','y') NOT NULL DEFAULT 'y',
	373	PRIMARY KEY (`directive_snippets_id`)
	374	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
	375
	376	-- --------------------------------------------------------
	377
2332b2	378	--
d82984	379	-- Table structure for table `dns_rr`
2332b2	380	--
d82984	381
T	382	CREATE TABLE `dns_rr` (
	383	`id` int(11) unsigned NOT NULL auto_increment,
	384	`sys_userid` int(11) unsigned NOT NULL,
	385	`sys_groupid` int(11) unsigned NOT NULL,
	386	`sys_perm_user` varchar(5) NOT NULL,
	387	`sys_perm_group` varchar(5) NOT NULL,
	388	`sys_perm_other` varchar(5) NOT NULL,
	389	`server_id` int(11) NOT NULL default '1',
	390	`zone` int(11) unsigned NOT NULL,
	391	`name` varchar(64) NOT NULL,
fd72ba	392	`type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT') default NULL,
d82984	393	`data` varchar(255) NOT NULL,
T	394	`aux` int(11) unsigned NOT NULL default '0',
	395	`ttl` int(11) unsigned NOT NULL default '86400',
	396	`active` enum('N','Y') NOT NULL default 'Y',
	397	`stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
	398	`serial` int(10) unsigned default NULL,
	399	PRIMARY KEY (`id`),
	400	UNIQUE KEY `rr` (`zone`,`name`,`type`,`data`)
32f943	401	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
L	402
	403	-- --------------------------------------------------------
	404
	405	--
	406	-- Table structure for table `dns_slave`
	407	--
	408
	409	CREATE TABLE `dns_slave` (
	410	`id` int(10) unsigned NOT NULL auto_increment,
	411	`sys_userid` int(11) unsigned NOT NULL,
	412	`sys_groupid` int(11) unsigned NOT NULL,
	413	`sys_perm_user` varchar(5) NOT NULL,
	414	`sys_perm_group` varchar(5) NOT NULL,
	415	`sys_perm_other` varchar(5) NOT NULL,
	416	`server_id` int(11) NOT NULL default '1',
	417	`origin` varchar(255) NOT NULL,
	418	`ns` varchar(255) NOT NULL,
	419	`active` enum('N','Y') NOT NULL,
	420	`xfer` varchar(255) NOT NULL,
	421	PRIMARY KEY (`id`),
3f478f	422	UNIQUE KEY `slave` (`origin`,`server_id`),
32f943	423	KEY `active` (`active`)
L	424	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	425
T	426	-- --------------------------------------------------------
	427
2332b2	428	--
d82984	429	-- Table structure for table `dns_soa`
2332b2	430	--
d82984	431
T	432	CREATE TABLE `dns_soa` (
	433	`id` int(10) unsigned NOT NULL auto_increment,
	434	`sys_userid` int(11) unsigned NOT NULL,
	435	`sys_groupid` int(11) unsigned NOT NULL,
	436	`sys_perm_user` varchar(5) NOT NULL,
	437	`sys_perm_group` varchar(5) NOT NULL,
	438	`sys_perm_other` varchar(5) NOT NULL,
	439	`server_id` int(11) NOT NULL default '1',
	440	`origin` varchar(255) NOT NULL,
	441	`ns` varchar(255) NOT NULL,
	442	`mbox` varchar(255) NOT NULL,
	443	`serial` int(11) unsigned NOT NULL default '1',
	444	`refresh` int(11) unsigned NOT NULL default '28800',
	445	`retry` int(11) unsigned NOT NULL default '7200',
	446	`expire` int(11) unsigned NOT NULL default '604800',
	447	`minimum` int(11) unsigned NOT NULL default '86400',
	448	`ttl` int(11) unsigned NOT NULL default '86400',
	449	`active` enum('N','Y') NOT NULL,
	450	`xfer` varchar(255) NOT NULL,
	451	`also_notify` varchar(255) default NULL,
	452	`update_acl` varchar(255) default NULL,
	453	PRIMARY KEY (`id`),
	454	UNIQUE KEY `origin` (`origin`),
	455	KEY `active` (`active`)
32f943	456	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	457
T	458	-- --------------------------------------------------------
	459
2332b2	460	--
d82984	461	-- Table structure for table `dns_template`
2332b2	462	--
d82984	463
T	464	CREATE TABLE `dns_template` (
	465	`template_id` int(11) unsigned NOT NULL auto_increment,
	466	`sys_userid` int(11) unsigned NOT NULL default '0',
	467	`sys_groupid` int(11) unsigned NOT NULL default '0',
	468	`sys_perm_user` varchar(5) default NULL,
	469	`sys_perm_group` varchar(5) default NULL,
	470	`sys_perm_other` varchar(5) default NULL,
	471	`name` varchar(64) default NULL,
	472	`fields` varchar(255) default NULL,
	473	`template` text,
	474	`visible` enum('N','Y') NOT NULL default 'Y',
	475	PRIMARY KEY (`template_id`)
32f943	476	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	477
T	478	--
32f943	479	-- Table structure for table `domain`
d82984	480	--
T	481
	482	CREATE TABLE `domain` (
	483	`domain_id` int(11) unsigned NOT NULL auto_increment,
	484	`sys_userid` int(11) unsigned NOT NULL default '0',
	485	`sys_groupid` int(11) unsigned NOT NULL default '0',
	486	`sys_perm_user` varchar(5) NOT NULL default '',
	487	`sys_perm_group` varchar(5) NOT NULL default '',
	488	`sys_perm_other` varchar(5) NOT NULL default '',
	489	`domain` varchar(255) NOT NULL default '',
	490	PRIMARY KEY (`domain_id`),
	491	UNIQUE KEY `domain` (`domain`)
32f943	492	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
d82984	493
T	494	-- --------------------------------------------------------
	495
2332b2	496	--
d82984	497	-- Table structure for table `firewall`
2332b2	498	--
d82984	499
T	500	CREATE TABLE `firewall` (
	501	`firewall_id` int(11) unsigned NOT NULL auto_increment,
	502	`sys_userid` int(11) unsigned NOT NULL default '0',
	503	`sys_groupid` int(11) unsigned NOT NULL default '0',
	504	`sys_perm_user` varchar(5) default NULL,
	505	`sys_perm_group` varchar(5) default NULL,
	506	`sys_perm_other` varchar(5) default NULL,
	507	`server_id` int(11) unsigned NOT NULL default '0',
	508	`tcp_port` varchar(255) default NULL,
	509	`udp_port` varchar(255) default NULL,
	510	`active` enum('n','y') NOT NULL default 'y',
	511	PRIMARY KEY (`firewall_id`)
32f943	512	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
L	513
	514	-- --------------------------------------------------------
	515
2332b2	516	--
d82984	517	-- Table structure for table `ftp_user`
2332b2	518	--
d82984	519
T	520	CREATE TABLE `ftp_user` (
	521	`ftp_user_id` int(11) unsigned NOT NULL auto_increment,
	522	`sys_userid` int(11) unsigned NOT NULL default '0',
	523	`sys_groupid` int(11) unsigned NOT NULL default '0',
	524	`sys_perm_user` varchar(5) default NULL,
	525	`sys_perm_group` varchar(5) default NULL,
	526	`sys_perm_other` varchar(5) default NULL,
	527	`server_id` int(11) unsigned NOT NULL default '0',
	528	`parent_domain_id` int(11) unsigned NOT NULL default '0',
	529	`username` varchar(64) default NULL,
10b4c8	530	`username_prefix` varchar(50) NOT NULL default '',
d82984	531	`password` varchar(64) default NULL,
T	532	`quota_size` bigint(20) NOT NULL default '-1',
	533	`active` enum('n','y') NOT NULL default 'y',
	534	`uid` varchar(64) default NULL,
	535	`gid` varchar(64) default NULL,
	536	`dir` varchar(255) default NULL,
	537	`quota_files` bigint(20) NOT NULL default '-1',
	538	`ul_ratio` int(11) NOT NULL default '-1',
	539	`dl_ratio` int(11) NOT NULL default '-1',
	540	`ul_bandwidth` int(11) NOT NULL default '-1',
	541	`dl_bandwidth` int(11) NOT NULL default '-1',
	542	PRIMARY KEY (`ftp_user_id`),
	543	KEY `active` (`active`),
	544	KEY `server_id` (`server_id`),
	545	KEY `username` (`username`),
	546	KEY `quota_files` (`quota_files`)
32f943	547	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
L	548
	549	-- --------------------------------------------------------
	550
	551	--
	552	-- Table structure for table `help_faq`
	553	--
	554
	555	CREATE TABLE `help_faq` (
	556	`hf_id` int(11) NOT NULL AUTO_INCREMENT,
	557	`hf_section` int(11) DEFAULT NULL,
	558	`hf_order` int(11) DEFAULT '0',
	559	`hf_question` text,
	560	`hf_answer` text,
	561	`sys_userid` int(11) DEFAULT NULL,
	562	`sys_groupid` int(11) DEFAULT NULL,
	563	`sys_perm_user` varchar(5) DEFAULT NULL,
	564	`sys_perm_group` varchar(5) DEFAULT NULL,
	565	`sys_perm_other` varchar(5) DEFAULT NULL,
	566	PRIMARY KEY (`hf_id`)
	567	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
	568
	569	-- --------------------------------------------------------
	570
	571	--
	572	-- Table structure for table `help_faq_sections`
	573	--
	574
	575	CREATE TABLE `help_faq_sections` (
	576	`hfs_id` int(11) NOT NULL AUTO_INCREMENT,
	577	`hfs_name` varchar(255) DEFAULT NULL,
	578	`hfs_order` int(11) DEFAULT '0',
	579	`sys_userid` int(11) DEFAULT NULL,
	580	`sys_groupid` int(11) DEFAULT NULL,
	581	`sys_perm_user` varchar(5) DEFAULT NULL,
	582	`sys_perm_group` varchar(5) DEFAULT NULL,
	583	`sys_perm_other` varchar(5) DEFAULT NULL,
	584	PRIMARY KEY (`hfs_id`)
	585	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	586
T	587	-- --------------------------------------------------------
	588
86bacc	589	-- Table structure for table `iptables`
L	590	--
	591
	592	DROP TABLE IF EXISTS `iptables`;
	593	CREATE TABLE `iptables` (
	594	`iptables_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
	595	`server_id` int(10) unsigned NOT NULL DEFAULT '0',
	596	`table` varchar(10) DEFAULT NULL COMMENT 'INPUT OUTPUT FORWARD',
	597	`source_ip` varchar(16) DEFAULT NULL,
	598	`destination_ip` varchar(16) DEFAULT NULL,
	599	`protocol` varchar(10) DEFAULT 'TCP' COMMENT 'TCP UDP GRE',
	600	`singleport` varchar(10) DEFAULT NULL,
	601	`multiport` varchar(40) DEFAULT NULL,
	602	`state` varchar(20) DEFAULT NULL COMMENT 'NEW ESTABLISHED RECNET etc',
	603	`target` varchar(10) DEFAULT NULL COMMENT 'ACCEPT DROP REJECT LOG',
	604	`active` enum('n','y') NOT NULL DEFAULT 'y',
	605	PRIMARY KEY (`iptables_id`)
	606	) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
	607
	608	-- --------------------------------------------------------
	609
2332b2	610	--
d82984	611	-- Table structure for table `mail_access`
2332b2	612	--
d82984	613
T	614	CREATE TABLE `mail_access` (
	615	`access_id` int(11) unsigned NOT NULL auto_increment,
	616	`sys_userid` int(11) unsigned NOT NULL default '0',
	617	`sys_groupid` int(11) unsigned NOT NULL default '0',
	618	`sys_perm_user` varchar(5) NOT NULL default '',
	619	`sys_perm_group` varchar(5) NOT NULL default '',
	620	`sys_perm_other` varchar(5) NOT NULL default '',
	621	`server_id` int(11) NOT NULL default '0',
	622	`source` varchar(255) NOT NULL,
	623	`access` varchar(255) NOT NULL,
	624	`type` set('recipient','sender','client') NOT NULL,
	625	`active` enum('n','y') NOT NULL default 'y',
	626	PRIMARY KEY (`access_id`),
	627	KEY `server_id` (`server_id`,`source`)
32f943	628	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	629
T	630	-- --------------------------------------------------------
	631
2332b2	632	--
d82984	633	-- Table structure for table `mail_content_filter`
2332b2	634	--
d82984	635
T	636	CREATE TABLE `mail_content_filter` (
	637	`content_filter_id` int(11) unsigned NOT NULL auto_increment,
	638	`sys_userid` int(11) unsigned NOT NULL default '0',
	639	`sys_groupid` int(11) unsigned NOT NULL default '0',
	640	`sys_perm_user` varchar(5) default NULL,
	641	`sys_perm_group` varchar(5) default NULL,
	642	`sys_perm_other` varchar(5) default NULL,
	643	`server_id` int(11) NOT NULL default '0',
	644	`type` varchar(255) default NULL,
	645	`pattern` varchar(255) default NULL,
	646	`data` varchar(255) default NULL,
	647	`action` varchar(255) default NULL,
	648	`active` varchar(255) NOT NULL default 'y',
	649	PRIMARY KEY (`content_filter_id`)
32f943	650	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	651
T	652	-- --------------------------------------------------------
	653
2332b2	654	--
d82984	655	-- Table structure for table `mail_domain`
2332b2	656	--
d82984	657
T	658	CREATE TABLE `mail_domain` (
	659	`domain_id` int(11) unsigned NOT NULL auto_increment,
	660	`sys_userid` int(11) unsigned NOT NULL default '0',
	661	`sys_groupid` int(11) unsigned NOT NULL default '0',
	662	`sys_perm_user` varchar(5) NOT NULL default '',
	663	`sys_perm_group` varchar(5) NOT NULL default '',
	664	`sys_perm_other` varchar(5) NOT NULL default '',
	665	`server_id` int(11) unsigned NOT NULL default '0',
	666	`domain` varchar(255) NOT NULL default '',
56f698	667	`dkim` ENUM( 'n', 'y' ) NOT NULL default 'n',
T	668	`dkim_private` mediumtext NOT NULL default '',
	669	`dkim_public` mediumtext NOT NULL default '',
d82984	670	`active` enum('n','y') NOT NULL,
T	671	PRIMARY KEY (`domain_id`),
	672	KEY `server_id` (`server_id`,`domain`),
	673	KEY `domain_active` (`domain`,`active`)
32f943	674	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	675
T	676	-- --------------------------------------------------------
	677
2332b2	678	--
d82984	679	-- Table structure for table `mail_forwarding`
2332b2	680	--
d82984	681
T	682	CREATE TABLE `mail_forwarding` (
	683	`forwarding_id` int(11) unsigned NOT NULL auto_increment,
	684	`sys_userid` int(11) unsigned NOT NULL default '0',
	685	`sys_groupid` int(11) unsigned NOT NULL default '0',
	686	`sys_perm_user` varchar(5) NOT NULL default '',
	687	`sys_perm_group` varchar(5) NOT NULL default '',
	688	`sys_perm_other` varchar(5) NOT NULL default '',
	689	`server_id` int(11) unsigned NOT NULL default '0',
	690	`source` varchar(255) NOT NULL,
	691	`destination` text,
	692	`type` enum('alias','aliasdomain','forward','catchall') NOT NULL default 'alias',
	693	`active` enum('n','y') NOT NULL,
	694	PRIMARY KEY (`forwarding_id`),
	695	KEY `server_id` (`server_id`,`source`),
	696	KEY `type` (`type`)
32f943	697	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	698
T	699	-- --------------------------------------------------------
	700
2332b2	701	--
d82984	702	-- Table structure for table `mail_get`
2332b2	703	--
d82984	704
T	705	CREATE TABLE `mail_get` (
	706	`mailget_id` int(11) unsigned NOT NULL auto_increment,
	707	`sys_userid` int(11) unsigned NOT NULL default '0',
	708	`sys_groupid` int(11) unsigned NOT NULL default '0',
	709	`sys_perm_user` varchar(5) default NULL,
	710	`sys_perm_group` varchar(5) default NULL,
	711	`sys_perm_other` varchar(5) default NULL,
	712	`server_id` int(11) unsigned NOT NULL default '0',
	713	`type` varchar(255) default NULL,
	714	`source_server` varchar(255) default NULL,
	715	`source_username` varchar(255) default NULL,
	716	`source_password` varchar(64) default NULL,
	717	`source_delete` varchar(255) NOT NULL default 'y',
1fbea9	718	`source_read_all` varchar(255) NOT NULL default 'y',
d82984	719	`destination` varchar(255) default NULL,
T	720	`active` varchar(255) NOT NULL default 'y',
	721	PRIMARY KEY (`mailget_id`)
32f943	722	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	723
T	724	-- --------------------------------------------------------
	725
	726	--
	727	-- Tabellenstruktur für Tabelle `mail_mailinglist`
	728	--
	729
	730	CREATE TABLE `mail_mailinglist` (
	731	`mailinglist_id` int(11) unsigned NOT NULL auto_increment,
	732	`sys_userid` int(11) unsigned NOT NULL default '0',
	733	`sys_groupid` int(11) unsigned NOT NULL default '0',
	734	`sys_perm_user` varchar(5) NOT NULL,
	735	`sys_perm_group` varchar(5) NOT NULL,
	736	`sys_perm_other` varchar(5) NOT NULL,
	737	`server_id` int(11) unsigned NOT NULL default '0',
	738	`domain` varchar(255) NOT NULL,
	739	`listname` varchar(255) NOT NULL,
	740	`email` varchar(255) NOT NULL,
	741	`password` varchar(255) NOT NULL,
	742	PRIMARY KEY (`mailinglist_id`)
32f943	743	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	744
T	745	-- --------------------------------------------------------
	746
	747	--
	748	-- Table structure for Table `mail_relay_recipient`
	749	--
	750
	751	CREATE TABLE IF NOT EXISTS `mail_relay_recipient` (
	752	`relay_recipient_id` bigint(20) NOT NULL AUTO_INCREMENT,
	753	`sys_userid` int(11) NOT NULL DEFAULT '0',
	754	`sys_groupid` int(11) NOT NULL DEFAULT '0',
	755	`sys_perm_user` varchar(5) DEFAULT NULL,
	756	`sys_perm_group` varchar(5) DEFAULT NULL,
	757	`sys_perm_other` varchar(5) DEFAULT NULL,
	758	`server_id` int(11) NOT NULL DEFAULT '0',
	759	`source` varchar(255) DEFAULT NULL,
	760	`access` varchar(255) NOT NULL DEFAULT 'OK',
	761	`active` varchar(255) NOT NULL DEFAULT 'y',
	762	PRIMARY KEY (`relay_recipient_id`)
32f943	763	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	764
T	765	-- --------------------------------------------------------
	766
2332b2	767	--
d82984	768	-- Table structure for table `mail_traffic`
2332b2	769	--
d82984	770
T	771	CREATE TABLE `mail_traffic` (
	772	`traffic_id` int(11) unsigned NOT NULL auto_increment,
	773	`mailuser_id` int(11) unsigned NOT NULL,
	774	`month` char(7) NOT NULL,
	775	`traffic` bigint(20) unsigned NOT NULL,
	776	PRIMARY KEY (`traffic_id`),
	777	KEY `mailuser_id` (`mailuser_id`,`month`)
32f943	778	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	779
T	780	-- --------------------------------------------------------
	781
2332b2	782	--
d82984	783	-- Table structure for table `mail_transport`
2332b2	784	--
d82984	785
T	786	CREATE TABLE `mail_transport` (
	787	`transport_id` int(11) unsigned NOT NULL auto_increment,
	788	`sys_userid` int(11) unsigned NOT NULL default '0',
	789	`sys_groupid` int(11) unsigned NOT NULL default '0',
	790	`sys_perm_user` varchar(5) NOT NULL default '',
	791	`sys_perm_group` varchar(5) NOT NULL default '',
	792	`sys_perm_other` varchar(5) NOT NULL default '',
	793	`server_id` int(11) unsigned NOT NULL default '0',
	794	`domain` varchar(255) NOT NULL default '',
	795	`transport` varchar(255) NOT NULL,
	796	`sort_order` int(11) unsigned NOT NULL default '5',
	797	`active` enum('n','y') NOT NULL,
	798	PRIMARY KEY (`transport_id`),
	799	KEY `server_id` (`server_id`,`transport`),
	800	KEY `server_id_2` (`server_id`,`domain`)
32f943	801	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	802
T	803	-- --------------------------------------------------------
	804
2332b2	805	--
d82984	806	-- Table structure for table `mail_user`
2332b2	807	--
d82984	808
T	809	CREATE TABLE `mail_user` (
	810	`mailuser_id` int(11) unsigned NOT NULL auto_increment,
	811	`sys_userid` int(11) unsigned NOT NULL default '0',
	812	`sys_groupid` int(11) unsigned NOT NULL default '0',
	813	`sys_perm_user` varchar(5) NOT NULL default '',
	814	`sys_perm_group` varchar(5) NOT NULL default '',
	815	`sys_perm_other` varchar(5) NOT NULL default '',
	816	`server_id` int(11) unsigned NOT NULL default '0',
	817	`email` varchar(255) NOT NULL default '',
d4c760	818	`login` varchar(255) NOT NULL,
d82984	819	`password` varchar(255) NOT NULL,
T	820	`name` varchar(255) NOT NULL default '',
	821	`uid` int(11) unsigned NOT NULL default '5000',
	822	`gid` int(11) unsigned NOT NULL default '5000',
	823	`maildir` varchar(255) NOT NULL default '',
	824	`quota` bigint(20) NOT NULL default '-1',
	825	`cc` varchar(255) NOT NULL default '',
	826	`homedir` varchar(255) NOT NULL,
	827	`autoresponder` enum('n','y') NOT NULL default 'n',
	828	`autoresponder_start_date` datetime NOT NULL default '0000-00-00 00:00:00',
	829	`autoresponder_end_date` datetime NOT NULL default '0000-00-00 00:00:00',
687eb2	830	`autoresponder_subject` varchar(255) NOT NULL default 'Out of office reply',
d82984	831	`autoresponder_text` mediumtext NULL,
T	832	`move_junk` enum('n','y') NOT NULL default 'n',
	833	`custom_mailfilter` mediumtext,
	834	`postfix` enum('n','y') NOT NULL,
	835	`access` enum('n','y') NOT NULL,
	836	`disableimap` enum('n','y') NOT NULL default 'n',
	837	`disablepop3` enum('n','y') NOT NULL default 'n',
	838	`disabledeliver` enum('n','y') NOT NULL default 'n',
	839	`disablesmtp` enum('n','y') NOT NULL default 'n',
40c436	840	`disablesieve` enum('n','y') NOT NULL default 'n',
T	841	`disablelda` enum('n','y') NOT NULL default 'n',
cea1e5	842	`disabledoveadm` enum('n','y') NOT NULL default 'n',
615a0a	843	`last_quota_notification` date NULL default NULL,
d82984	844	PRIMARY KEY (`mailuser_id`),
T	845	KEY `server_id` (`server_id`,`email`),
	846	KEY `email_access` (`email`,`access`)
32f943	847	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	848
T	849	-- --------------------------------------------------------
	850
2332b2	851	--
d82984	852	-- Table structure for table `mail_user_filter`
2332b2	853	--
d82984	854
T	855	CREATE TABLE `mail_user_filter` (
	856	`filter_id` int(11) unsigned NOT NULL auto_increment,
	857	`sys_userid` int(11) unsigned NOT NULL default '0',
	858	`sys_groupid` int(11) unsigned NOT NULL default '0',
	859	`sys_perm_user` varchar(5) default NULL,
	860	`sys_perm_group` varchar(5) default NULL,
	861	`sys_perm_other` varchar(5) default NULL,
	862	`mailuser_id` int(11) unsigned NOT NULL default '0',
	863	`rulename` varchar(64) default NULL,
	864	`source` varchar(255) default NULL,
	865	`searchterm` varchar(255) default NULL,
	866	`op` varchar(255) default NULL,
	867	`action` varchar(255) default NULL,
	868	`target` varchar(255) default NULL,
	869	`active` enum('n','y') NOT NULL default 'y',
	870	PRIMARY KEY (`filter_id`)
32f943	871	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
L	872
	873	-- --------------------------------------------------------
	874
	875	--
	876	-- Table structure for table `monitor_data`
	877	--
	878
	879	CREATE TABLE `monitor_data` (
	880	`server_id` int(11) unsigned NOT NULL,
	881	`type` varchar(255) NOT NULL,
	882	`created` int(11) unsigned NOT NULL,
	883	`data` mediumtext NOT NULL,
	884	`state` enum('no_state','unknown','ok','info','warning','critical','error') NOT NULL DEFAULT 'unknown',
	885	PRIMARY KEY (`server_id`,`type`,`created`)
	886	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
	887
	888	-- --------------------------------------------------------
	889
	890	--
b74ef5	891	-- Table structure for table `openvz_ip`
T	892	--
	893
	894	CREATE TABLE IF NOT EXISTS `openvz_ip` (
	895	`ip_address_id` bigint(20) NOT NULL AUTO_INCREMENT,
	896	`sys_userid` int(11) NOT NULL DEFAULT '0',
	897	`sys_groupid` int(11) NOT NULL DEFAULT '0',
	898	`sys_perm_user` varchar(5) DEFAULT NULL,
	899	`sys_perm_group` varchar(5) DEFAULT NULL,
	900	`sys_perm_other` varchar(5) DEFAULT NULL,
	901	`server_id` int(11) NOT NULL DEFAULT '0',
	902	`ip_address` varchar(15) DEFAULT NULL,
	903	`vm_id` int(11) NOT NULL DEFAULT '0',
	904	`reserved` varchar(255) NOT NULL DEFAULT 'n',
	905	PRIMARY KEY (`ip_address_id`)
	906	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
	907
	908	--
	909	-- Dumping data for table `openvz_ip`
	910	--
	911
	912	-- --------------------------------------------------------
	913
	914	--
	915	-- Table structure for table `openvz_ostemplate`
	916	--
	917
	918	CREATE TABLE IF NOT EXISTS `openvz_ostemplate` (
	919	`ostemplate_id` bigint(20) NOT NULL AUTO_INCREMENT,
	920	`sys_userid` int(11) NOT NULL DEFAULT '0',
	921	`sys_groupid` int(11) NOT NULL DEFAULT '0',
	922	`sys_perm_user` varchar(5) DEFAULT NULL,
	923	`sys_perm_group` varchar(5) DEFAULT NULL,
	924	`sys_perm_other` varchar(5) DEFAULT NULL,
	925	`template_name` varchar(255) DEFAULT NULL,
	926	`template_file` varchar(255) NOT NULL,
	927	`server_id` int(11) NOT NULL DEFAULT '0',
	928	`allservers` varchar(255) NOT NULL DEFAULT 'y',
	929	`active` varchar(255) NOT NULL DEFAULT 'y',
	930	`description` text,
	931	PRIMARY KEY (`ostemplate_id`)
	932	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
	933
	934	--
	935	-- Dumping data for table `openvz_ostemplate`
	936	--
	937
	938	INSERT INTO `openvz_ostemplate` (`ostemplate_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `template_name`, `template_file`, `server_id`, `allservers`, `active`, `description`) VALUES(1, 1, 1, 'riud', 'riud', '', 'Debian minimal', 'debian-minimal-x86', 1, 'y', 'y', 'Debain minmal image.');
	939
	940	-- --------------------------------------------------------
	941
	942	--
	943	-- Table structure for table `openvz_template`
	944	--
	945
	946	CREATE TABLE IF NOT EXISTS `openvz_template` (
	947	`template_id` bigint(20) NOT NULL AUTO_INCREMENT,
	948	`sys_userid` int(11) NOT NULL DEFAULT '0',
	949	`sys_groupid` int(11) NOT NULL DEFAULT '0',
	950	`sys_perm_user` varchar(5) DEFAULT NULL,
	951	`sys_perm_group` varchar(5) DEFAULT NULL,
	952	`sys_perm_other` varchar(5) DEFAULT NULL,
	953	`template_name` varchar(255) DEFAULT NULL,
	954	`diskspace` int(11) NOT NULL DEFAULT '0',
	955	`traffic` int(11) NOT NULL DEFAULT '-1',
	956	`bandwidth` int(11) NOT NULL DEFAULT '-1',
	957	`ram` int(11) NOT NULL DEFAULT '0',
	958	`ram_burst` int(11) NOT NULL DEFAULT '0',
	959	`cpu_units` int(11) NOT NULL DEFAULT '1000',
	960	`cpu_num` int(11) NOT NULL DEFAULT '4',
	961	`cpu_limit` int(11) NOT NULL DEFAULT '400',
	962	`io_priority` int(11) NOT NULL DEFAULT '4',
	963	`active` varchar(255) NOT NULL DEFAULT 'y',
	964	`description` text,
	965	`numproc` varchar(255) DEFAULT NULL,
	966	`numtcpsock` varchar(255) DEFAULT NULL,
	967	`numothersock` varchar(255) DEFAULT NULL,
	968	`vmguarpages` varchar(255) DEFAULT NULL,
	969	`kmemsize` varchar(255) DEFAULT NULL,
	970	`tcpsndbuf` varchar(255) DEFAULT NULL,
	971	`tcprcvbuf` varchar(255) DEFAULT NULL,
	972	`othersockbuf` varchar(255) DEFAULT NULL,
	973	`dgramrcvbuf` varchar(255) DEFAULT NULL,
	974	`oomguarpages` varchar(255) DEFAULT NULL,
	975	`privvmpages` varchar(255) DEFAULT NULL,
	976	`lockedpages` varchar(255) DEFAULT NULL,
	977	`shmpages` varchar(255) DEFAULT NULL,
	978	`physpages` varchar(255) DEFAULT NULL,
	979	`numfile` varchar(255) DEFAULT NULL,
	980	`avnumproc` varchar(255) DEFAULT NULL,
	981	`numflock` varchar(255) DEFAULT NULL,
	982	`numpty` varchar(255) DEFAULT NULL,
	983	`numsiginfo` varchar(255) DEFAULT NULL,
	984	`dcachesize` varchar(255) DEFAULT NULL,
	985	`numiptent` varchar(255) DEFAULT NULL,
	986	`swappages` varchar(255) DEFAULT NULL,
	987	`hostname` varchar(255) DEFAULT NULL,
	988	`nameserver` varchar(255) DEFAULT NULL,
	989	`create_dns` varchar(1) NOT NULL DEFAULT 'n',
	990	`capability` varchar(255) DEFAULT NULL,
	991	PRIMARY KEY (`template_id`)
	992	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
	993
	994	--
	995	-- Dumping data for table `openvz_template`
	996	--
	997
	998	INSERT INTO `openvz_template` (`template_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `template_name`, `diskspace`, `traffic`, `bandwidth`, `ram`, `ram_burst`, `cpu_units`, `cpu_num`, `cpu_limit`, `io_priority`, `active`, `description`, `numproc`, `numtcpsock`, `numothersock`, `vmguarpages`, `kmemsize`, `tcpsndbuf`, `tcprcvbuf`, `othersockbuf`, `dgramrcvbuf`, `oomguarpages`, `privvmpages`, `lockedpages`, `shmpages`, `physpages`, `numfile`, `avnumproc`, `numflock`, `numpty`, `numsiginfo`, `dcachesize`, `numiptent`, `swappages`, `hostname`, `nameserver`, `create_dns`, `capability`) VALUES(1, 1, 1, 'riud', 'riud', '', 'small', 10, -1, -1, 256, 512, 1000, 4, 400, 4, 'y', '', '999999:999999', '7999992:7999992', '7999992:7999992', '65536:65536', '2147483646:2147483646', '214748160:396774400', '214748160:396774400', '214748160:396774400', '214748160:396774400', '65536:65536', '131072:131072', '999999:999999', '65536:65536', '0:2147483647', '23999976:23999976', '180:180', '999999:999999', '500000:500000', '999999:999999', '2147483646:2147483646', '999999:999999', '256000:256000', 'v{VEID}.test.tld', '8.8.8.8 8.8.4.4', 'n', '');
	999
	1000	-- --------------------------------------------------------
	1001
	1002	--
	1003	-- Table structure for table `openvz_traffic`
	1004	--
	1005
	1006	CREATE TABLE IF NOT EXISTS `openvz_traffic` (
	1007	`veid` int(11) NOT NULL,
	1008	`traffic_date` date NOT NULL,
	1009	`traffic_bytes` bigint(32) unsigned NOT NULL DEFAULT '0',
	1010	PRIMARY KEY (`veid`,`traffic_date`)
	1011	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1012
	1013	--
	1014	-- Dumping data for table `openvz_traffic`
	1015	--
	1016
	1017
	1018	-- --------------------------------------------------------
	1019
	1020	--
	1021	-- Table structure for table `openvz_vm`
	1022	--
	1023
	1024	CREATE TABLE IF NOT EXISTS `openvz_vm` (
	1025	`vm_id` bigint(20) NOT NULL AUTO_INCREMENT,
	1026	`sys_userid` int(11) NOT NULL DEFAULT '0',
	1027	`sys_groupid` int(11) NOT NULL DEFAULT '0',
	1028	`sys_perm_user` varchar(5) DEFAULT NULL,
	1029	`sys_perm_group` varchar(5) DEFAULT NULL,
	1030	`sys_perm_other` varchar(5) DEFAULT NULL,
	1031	`server_id` int(11) NOT NULL DEFAULT '0',
	1032	`veid` int(10) unsigned NOT NULL,
	1033	`ostemplate_id` int(11) NOT NULL DEFAULT '0',
	1034	`template_id` int(11) NOT NULL DEFAULT '0',
	1035	`ip_address` varchar(255) NOT NULL,
	1036	`hostname` varchar(255) DEFAULT NULL,
	1037	`vm_password` varchar(255) DEFAULT NULL,
	1038	`start_boot` varchar(255) NOT NULL DEFAULT 'y',
	1039	`active` varchar(255) NOT NULL DEFAULT 'y',
	1040	`active_until_date` date NOT NULL,
	1041	`description` text,
	1042	`diskspace` int(11) NOT NULL DEFAULT '0',
	1043	`traffic` int(11) NOT NULL DEFAULT '-1',
	1044	`bandwidth` int(11) NOT NULL DEFAULT '-1',
	1045	`ram` int(11) NOT NULL DEFAULT '0',
	1046	`ram_burst` int(11) NOT NULL DEFAULT '0',
	1047	`cpu_units` int(11) NOT NULL DEFAULT '1000',
	1048	`cpu_num` int(11) NOT NULL DEFAULT '4',
	1049	`cpu_limit` int(11) NOT NULL DEFAULT '400',
	1050	`io_priority` int(11) NOT NULL DEFAULT '4',
	1051	`nameserver` varchar(255) NOT NULL DEFAULT '8.8.8.8 8.8.4.4',
	1052	`create_dns` varchar(1) NOT NULL DEFAULT 'n',
	1053	`capability` text NOT NULL,
	1054	`config` mediumtext NOT NULL,
	1055	PRIMARY KEY (`vm_id`)
	1056	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
	1057
	1058	--
	1059	-- Dumping data for table `openvz_vm`
	1060	--
d82984	1061
T	1062	-- --------------------------------------------------------
	1063
2332b2	1064	--
d82984	1065	-- Table structure for table `remote_session`
2332b2	1066	--
d82984	1067
T	1068	CREATE TABLE `remote_session` (
	1069	`remote_session` varchar(64) NOT NULL,
	1070	`remote_userid` int(11) unsigned NOT NULL,
	1071	`remote_functions` text NOT NULL,
	1072	`tstamp` int(10) unsigned NOT NULL,
	1073	PRIMARY KEY (`remote_session`)
32f943	1074	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
d82984	1075
T	1076	-- --------------------------------------------------------
	1077
2332b2	1078	--
d82984	1079	-- Table structure for table `remote_user`
2332b2	1080	--
d82984	1081
T	1082	CREATE TABLE `remote_user` (
	1083	`remote_userid` int(11) unsigned NOT NULL auto_increment,
	1084	`sys_userid` int(11) unsigned NOT NULL default '0',
	1085	`sys_groupid` int(11) unsigned NOT NULL default '0',
	1086	`sys_perm_user` varchar(5) default NULL,
	1087	`sys_perm_group` varchar(5) default NULL,
	1088	`sys_perm_other` varchar(5) default NULL,
	1089	`remote_username` varchar(64) NOT NULL,
	1090	`remote_password` varchar(64) NOT NULL,
	1091	`remote_functions` text NOT NULL,
	1092	PRIMARY KEY (`remote_userid`)
32f943	1093	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1094
T	1095	-- --------------------------------------------------------
	1096
2332b2	1097	--
d82984	1098	-- Table structure for table `server`
2332b2	1099	--
d82984	1100
T	1101	CREATE TABLE `server` (
	1102	`server_id` int(11) unsigned NOT NULL auto_increment,
	1103	`sys_userid` int(11) unsigned NOT NULL default '0',
	1104	`sys_groupid` int(11) unsigned NOT NULL default '0',
	1105	`sys_perm_user` varchar(5) NOT NULL default '',
	1106	`sys_perm_group` varchar(5) NOT NULL default '',
	1107	`sys_perm_other` varchar(5) NOT NULL default '',
	1108	`server_name` varchar(255) NOT NULL default '',
	1109	`mail_server` tinyint(1) NOT NULL default '0',
	1110	`web_server` tinyint(1) NOT NULL default '0',
	1111	`dns_server` tinyint(1) NOT NULL default '0',
	1112	`file_server` tinyint(1) NOT NULL default '0',
	1113	`db_server` tinyint(1) NOT NULL default '0',
	1114	`vserver_server` tinyint(1) NOT NULL default '0',
80e3c9	1115	`proxy_server` tinyint(1) NOT NULL default '0',
T	1116	`firewall_server` tinyint(1) NOT NULL default '0',
d82984	1117	`config` text NOT NULL,
T	1118	`updated` bigint(20) unsigned NOT NULL default '0',
	1119	`mirror_server_id` int(11) unsigned NOT NULL default '0',
	1120	`dbversion` int(11) unsigned NOT NULL default '1',
	1121	`active` tinyint(1) NOT NULL default '1',
	1122	PRIMARY KEY (`server_id`)
32f943	1123	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1124
T	1125	-- --------------------------------------------------------
	1126
2332b2	1127	--
d82984	1128	-- Table structure for table `server_ip`
2332b2	1129	--
d82984	1130
T	1131	CREATE TABLE `server_ip` (
	1132	`server_ip_id` int(11) unsigned NOT NULL auto_increment,
	1133	`sys_userid` int(11) unsigned NOT NULL default '0',
	1134	`sys_groupid` int(11) unsigned NOT NULL default '0',
	1135	`sys_perm_user` varchar(5) default NULL,
	1136	`sys_perm_group` varchar(5) default NULL,
	1137	`sys_perm_other` varchar(5) default NULL,
	1138	`server_id` int(11) unsigned NOT NULL default '0',
40c436	1139	`client_id` int(11) unsigned NOT NULL default '0',
T	1140	`ip_type` enum( 'IPv4', 'IPv6' ) NOT NULL DEFAULT 'IPv4',
d82984	1141	`ip_address` varchar(39) default NULL,
T	1142	`virtualhost` enum('n','y') NOT NULL default 'y',
40c436	1143	`virtualhost_port` varchar(255) default '80,443',
d82984	1144	PRIMARY KEY (`server_ip_id`)
32f943	1145	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1146
T	1147	-- --------------------------------------------------------
32f943	1148
6de0aa	1149
F	1150	--
	1151	-- Table structure for table `server_php`
	1152	--
	1153
	1154	CREATE TABLE `server_php` (
	1155	`server_php_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	1156	`sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
	1157	`sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
	1158	`sys_perm_user` varchar(5) DEFAULT NULL,
	1159	`sys_perm_group` varchar(5) DEFAULT NULL,
	1160	`sys_perm_other` varchar(5) DEFAULT NULL,
	1161	`server_id` int(11) unsigned NOT NULL DEFAULT '0',
	1162	`client_id` int(11) unsigned NOT NULL DEFAULT '0',
	1163	`name` varchar(255) DEFAULT NULL,
	1164	`php_fastcgi_binary` varchar(255) DEFAULT NULL,
	1165	`php_fastcgi_ini_dir` varchar(255) DEFAULT NULL,
	1166	`php_fpm_init_script` varchar(255) DEFAULT NULL,
	1167	`php_fpm_ini_dir` varchar(255) DEFAULT NULL,
	1168	`php_fpm_pool_dir` varchar(255) DEFAULT NULL,
	1169	PRIMARY KEY (`server_php_id`)
	1170	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
	1171
	1172	-- --------------------------------------------------------
	1173
32f943	1174	--
L	1175	-- Table structure for table `shell_user`
	1176	--
d82984	1177
T	1178	CREATE TABLE `shell_user` (
	1179	`shell_user_id` int(11) unsigned NOT NULL auto_increment,
	1180	`sys_userid` int(11) unsigned NOT NULL default '0',
	1181	`sys_groupid` int(11) unsigned NOT NULL default '0',
	1182	`sys_perm_user` varchar(5) default NULL,
	1183	`sys_perm_group` varchar(5) default NULL,
	1184	`sys_perm_other` varchar(5) default NULL,
	1185	`server_id` int(11) unsigned NOT NULL default '0',
	1186	`parent_domain_id` int(11) unsigned NOT NULL default '0',
	1187	`username` varchar(64) default NULL,
10b4c8	1188	`username_prefix` varchar(50) NOT NULL default '',
d82984	1189	`password` varchar(64) default NULL,
T	1190	`quota_size` bigint(20) NOT NULL default '-1',
	1191	`active` enum('n','y') NOT NULL default 'y',
	1192	`puser` varchar(255) default NULL,
	1193	`pgroup` varchar(255) default NULL,
	1194	`shell` varchar(255) NOT NULL default '/bin/bash',
	1195	`dir` varchar(255) default NULL,
	1196	`chroot` varchar(255) NOT NULL,
8ab3cd	1197	`ssh_rsa` text NOT NULL,
d82984	1198	PRIMARY KEY (`shell_user_id`)
32f943	1199	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1200
T	1201	-- --------------------------------------------------------
	1202
2332b2	1203	--
d82984	1204	-- Table structure for table `software_package`
2332b2	1205	--
d82984	1206
T	1207	CREATE TABLE `software_package` (
	1208	`package_id` int(11) unsigned NOT NULL auto_increment,
	1209	`software_repo_id` int(11) unsigned NOT NULL,
	1210	`package_name` varchar(64) NOT NULL,
	1211	`package_title` varchar(64) NOT NULL,
	1212	`package_description` text,
	1213	`package_version` varchar(8) default NULL,
	1214	`package_type` enum('ispconfig','app','web') NOT NULL default 'app',
	1215	`package_installable` enum('yes','no','key') NOT NULL default 'yes',
	1216	`package_requires_db` enum('no','mysql') NOT NULL default 'no',
	1217	`package_remote_functions` text,
	1218	`package_key` varchar(255) NOT NULL,
	1219	`package_config` text,
	1220	PRIMARY KEY (`package_id`),
	1221	UNIQUE KEY `package_name` (`package_name`)
32f943	1222	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1223
T	1224	-- --------------------------------------------------------
	1225
2332b2	1226	--
d82984	1227	-- Table structure for table `software_repo`
2332b2	1228	--
d82984	1229
T	1230	CREATE TABLE `software_repo` (
	1231	`software_repo_id` int(11) unsigned NOT NULL auto_increment,
	1232	`sys_userid` int(11) unsigned NOT NULL default '0',
	1233	`sys_groupid` int(11) unsigned NOT NULL default '0',
	1234	`sys_perm_user` varchar(5) default NULL,
	1235	`sys_perm_group` varchar(5) default NULL,
	1236	`sys_perm_other` varchar(5) default NULL,
	1237	`repo_name` varchar(64) default NULL,
	1238	`repo_url` varchar(255) default NULL,
	1239	`repo_username` varchar(64) default NULL,
	1240	`repo_password` varchar(64) default NULL,
	1241	`active` enum('n','y') NOT NULL default 'y',
	1242	PRIMARY KEY (`software_repo_id`)
32f943	1243	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1244
T	1245	-- --------------------------------------------------------
	1246
2332b2	1247	--
d82984	1248	-- Table structure for table `software_update`
2332b2	1249	--
d82984	1250
T	1251	CREATE TABLE `software_update` (
	1252	`software_update_id` int(11) unsigned NOT NULL auto_increment,
	1253	`software_repo_id` int(11) unsigned NOT NULL,
	1254	`package_name` varchar(64) NOT NULL,
	1255	`update_url` varchar(255) NOT NULL,
	1256	`update_md5` varchar(255) NOT NULL,
	1257	`update_dependencies` varchar(255) NOT NULL,
	1258	`update_title` varchar(64) NOT NULL,
	1259	`v1` tinyint(1) NOT NULL default '0',
	1260	`v2` tinyint(1) NOT NULL default '0',
	1261	`v3` tinyint(1) NOT NULL default '0',
	1262	`v4` tinyint(1) NOT NULL default '0',
	1263	`type` enum('full','update') NOT NULL default 'full',
	1264	PRIMARY KEY (`software_update_id`)
32f943	1265	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1266
T	1267	-- --------------------------------------------------------
	1268
2332b2	1269	--
d82984	1270	-- Table structure for table `software_update_inst`
2332b2	1271	--
d82984	1272
T	1273	CREATE TABLE `software_update_inst` (
	1274	`software_update_inst_id` int(11) unsigned NOT NULL auto_increment,
	1275	`software_update_id` int(11) unsigned NOT NULL default '0',
	1276	`package_name` varchar(64) NOT NULL,
	1277	`server_id` int(11) unsigned NOT NULL,
	1278	`status` enum('none','installing','installed','deleting','deleted','failed') NOT NULL default 'none',
	1279	PRIMARY KEY (`software_update_inst_id`),
	1280	UNIQUE KEY `software_update_id` (`software_update_id`,`package_name`,`server_id`)
32f943	1281	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1282
T	1283	-- --------------------------------------------------------
	1284
2332b2	1285	--
d82984	1286	-- Table structure for table `spamfilter_policy`
2332b2	1287	--
d82984	1288
T	1289	CREATE TABLE `spamfilter_policy` (
	1290	`id` int(11) unsigned NOT NULL auto_increment,
	1291	`sys_userid` int(11) unsigned NOT NULL,
	1292	`sys_groupid` int(11) unsigned NOT NULL,
	1293	`sys_perm_user` varchar(5) NOT NULL,
	1294	`sys_perm_group` varchar(5) NOT NULL,
	1295	`sys_perm_other` varchar(5) NOT NULL,
	1296	`policy_name` varchar(64) default NULL,
	1297	`virus_lover` enum('N','Y') default NULL,
	1298	`spam_lover` enum('N','Y') default NULL,
	1299	`banned_files_lover` enum('N','Y') default NULL,
	1300	`bad_header_lover` enum('N','Y') default NULL,
	1301	`bypass_virus_checks` enum('N','Y') default NULL,
	1302	`bypass_spam_checks` enum('N','Y') default NULL,
	1303	`bypass_banned_checks` enum('N','Y') default NULL,
	1304	`bypass_header_checks` enum('N','Y') default NULL,
	1305	`spam_modifies_subj` enum('N','Y') default NULL,
	1306	`virus_quarantine_to` varchar(255) default NULL,
	1307	`spam_quarantine_to` varchar(255) default NULL,
	1308	`banned_quarantine_to` varchar(255) default NULL,
	1309	`bad_header_quarantine_to` varchar(255) default NULL,
	1310	`clean_quarantine_to` varchar(255) default NULL,
	1311	`other_quarantine_to` varchar(255) default NULL,
	1312	`spam_tag_level` float default NULL,
	1313	`spam_tag2_level` float default NULL,
	1314	`spam_kill_level` float default NULL,
	1315	`spam_dsn_cutoff_level` float default NULL,
	1316	`spam_quarantine_cutoff_level` float default NULL,
	1317	`addr_extension_virus` varchar(64) default NULL,
	1318	`addr_extension_spam` varchar(64) default NULL,
	1319	`addr_extension_banned` varchar(64) default NULL,
	1320	`addr_extension_bad_header` varchar(64) default NULL,
	1321	`warnvirusrecip` enum('N','Y') default NULL,
	1322	`warnbannedrecip` enum('N','Y') default NULL,
	1323	`warnbadhrecip` enum('N','Y') default NULL,
	1324	`newvirus_admin` varchar(64) default NULL,
	1325	`virus_admin` varchar(64) default NULL,
	1326	`banned_admin` varchar(64) default NULL,
	1327	`bad_header_admin` varchar(64) default NULL,
	1328	`spam_admin` varchar(64) default NULL,
	1329	`spam_subject_tag` varchar(64) default NULL,
	1330	`spam_subject_tag2` varchar(64) default NULL,
	1331	`message_size_limit` int(11) unsigned default NULL,
	1332	`banned_rulenames` varchar(64) default NULL,
	1333	PRIMARY KEY (`id`)
32f943	1334	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1335
T	1336	-- --------------------------------------------------------
	1337
2332b2	1338	--
d82984	1339	-- Table structure for table `spamfilter_users`
2332b2	1340	--
d82984	1341
T	1342	CREATE TABLE `spamfilter_users` (
	1343	`id` int(11) unsigned NOT NULL auto_increment,
	1344	`sys_userid` int(11) unsigned NOT NULL,
	1345	`sys_groupid` int(11) unsigned NOT NULL,
	1346	`sys_perm_user` varchar(5) NOT NULL,
	1347	`sys_perm_group` varchar(5) NOT NULL,
	1348	`sys_perm_other` varchar(5) NOT NULL,
	1349	`server_id` int(11) unsigned NOT NULL,
	1350	`priority` tinyint(3) unsigned NOT NULL default '7',
	1351	`policy_id` int(11) unsigned NOT NULL default '1',
	1352	`email` varchar(255) NOT NULL,
	1353	`fullname` varchar(64) default NULL,
	1354	`local` varchar(1) default NULL,
	1355	PRIMARY KEY (`id`),
	1356	UNIQUE KEY `email` (`email`)
32f943	1357	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1358
T	1359	-- --------------------------------------------------------
	1360
2332b2	1361	--
d82984	1362	-- Table structure for table `spamfilter_wblist`
2332b2	1363	--
d82984	1364
T	1365	CREATE TABLE `spamfilter_wblist` (
	1366	`wblist_id` int(11) unsigned NOT NULL auto_increment,
	1367	`sys_userid` int(11) unsigned NOT NULL,
	1368	`sys_groupid` int(11) unsigned NOT NULL,
	1369	`sys_perm_user` varchar(5) NOT NULL,
	1370	`sys_perm_group` varchar(5) NOT NULL,
	1371	`sys_perm_other` varchar(5) NOT NULL,
	1372	`server_id` int(11) unsigned NOT NULL,
	1373	`wb` enum('W','B') NOT NULL default 'W',
	1374	`rid` int(11) unsigned NOT NULL,
	1375	`email` varchar(255) NOT NULL,
	1376	`priority` tinyint(3) unsigned NOT NULL,
	1377	`active` enum('y','n') NOT NULL default 'y',
	1378	PRIMARY KEY (`wblist_id`)
32f943	1379	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1380
T	1381	-- --------------------------------------------------------
	1382
2332b2	1383	--
d82984	1384	-- Table structure for table `support_message`
2332b2	1385	--
d82984	1386
T	1387	CREATE TABLE `support_message` (
	1388	`support_message_id` int(11) unsigned NOT NULL auto_increment,
	1389	`sys_userid` int(11) unsigned NOT NULL default '0',
	1390	`sys_groupid` int(11) unsigned NOT NULL default '0',
	1391	`sys_perm_user` varchar(5) default NULL,
	1392	`sys_perm_group` varchar(5) default NULL,
	1393	`sys_perm_other` varchar(5) default NULL,
	1394	`recipient_id` int(11) unsigned NOT NULL default '0',
	1395	`sender_id` int(11) unsigned NOT NULL default '0',
	1396	`subject` varchar(255) default NULL,
	1397	`message` text default NULL,
	1398	`tstamp` int(11) NOT NULL default '0',
	1399	PRIMARY KEY (`support_message_id`)
32f943	1400	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
L	1401
	1402	-- --------------------------------------------------------
	1403
	1404	--
	1405	-- Table structure for table `sys_config`
	1406	--
	1407
	1408	CREATE TABLE `sys_config` (
	1409	`config_id` int(11) unsigned NOT NULL,
	1410	`group` varchar(64) NOT NULL,
	1411	`name` varchar(64) NOT NULL,
	1412	`value` varchar(255) NOT NULL
	1413	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
d82984	1414
T	1415	-- --------------------------------------------------------
	1416
2332b2	1417	--
d82984	1418	-- Table structure for table `sys_datalog`
2332b2	1419	--
d82984	1420
T	1421	CREATE TABLE `sys_datalog` (
	1422	`datalog_id` int(11) unsigned NOT NULL auto_increment,
	1423	`server_id` int(11) unsigned NOT NULL,
	1424	`dbtable` varchar(255) NOT NULL default '',
	1425	`dbidx` varchar(255) NOT NULL default '',
	1426	`action` char(1) NOT NULL default '',
	1427	`tstamp` int(11) NOT NULL default '0',
	1428	`user` varchar(255) NOT NULL default '',
04620b	1429	`data` longtext NOT NULL,
T	1430	`status` set('pending','ok','warning','error') NOT NULL default 'ok',
d82984	1431	PRIMARY KEY (`datalog_id`),
T	1432	KEY `server_id` (`server_id`,`status`)
32f943	1433	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1434
T	1435	-- --------------------------------------------------------
	1436
2332b2	1437	--
d82984	1438	-- Table structure for table `sys_dbsync`
2332b2	1439	--
d82984	1440
T	1441	CREATE TABLE `sys_dbsync` (
	1442	`id` int(11) unsigned NOT NULL auto_increment,
	1443	`jobname` varchar(64) NOT NULL default '',
	1444	`sync_interval_minutes` int(11) unsigned NOT NULL default '0',
	1445	`db_type` varchar(16) NOT NULL default '',
	1446	`db_host` varchar(255) NOT NULL default '',
	1447	`db_name` varchar(64) NOT NULL default '',
	1448	`db_username` varchar(64) NOT NULL default '',
	1449	`db_password` varchar(64) NOT NULL default '',
	1450	`db_tables` varchar(255) NOT NULL default 'admin,forms',
	1451	`empty_datalog` int(11) unsigned NOT NULL default '0',
	1452	`sync_datalog_external` int(11) unsigned NOT NULL default '0',
	1453	`active` tinyint(1) NOT NULL default '1',
	1454	`last_datalog_id` int(11) unsigned NOT NULL default '0',
	1455	PRIMARY KEY (`id`),
	1456	KEY `last_datalog_id` (`last_datalog_id`)
32f943	1457	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
L	1458
d82984	1459	-- --------------------------------------------------------
T	1460
2332b2	1461	--
d82984	1462	-- Table structure for table `sys_filesync`
2332b2	1463	--
d82984	1464
T	1465	CREATE TABLE `sys_filesync` (
	1466	`id` int(11) unsigned NOT NULL auto_increment,
	1467	`jobname` varchar(64) NOT NULL default '',
	1468	`sync_interval_minutes` int(11) unsigned NOT NULL default '0',
	1469	`ftp_host` varchar(255) NOT NULL default '',
	1470	`ftp_path` varchar(255) NOT NULL default '',
	1471	`ftp_username` varchar(64) NOT NULL default '',
	1472	`ftp_password` varchar(64) NOT NULL default '',
	1473	`local_path` varchar(255) NOT NULL default '',
	1474	`wput_options` varchar(255) NOT NULL default '--timestamping --reupload --dont-continue',
	1475	`active` tinyint(1) NOT NULL default '1',
	1476	PRIMARY KEY (`id`)
32f943	1477	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1478
T	1479	-- --------------------------------------------------------
	1480
2332b2	1481	--
d82984	1482	-- Table structure for table `sys_group`
2332b2	1483	--
d82984	1484
T	1485	CREATE TABLE `sys_group` (
	1486	`groupid` int(11) unsigned NOT NULL auto_increment,
	1487	`name` varchar(64) NOT NULL default '',
	1488	`description` text NOT NULL,
	1489	`client_id` int(11) unsigned NOT NULL default '0',
	1490	PRIMARY KEY (`groupid`)
32f943	1491	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1492
T	1493	-- --------------------------------------------------------
	1494
2332b2	1495	--
d82984	1496	-- Table structure for table `sys_ini`
2332b2	1497	--
d82984	1498
T	1499	CREATE TABLE `sys_ini` (
	1500	`sysini_id` int(11) unsigned NOT NULL auto_increment,
	1501	`config` longtext NOT NULL,
	1502	PRIMARY KEY (`sysini_id`)
32f943	1503	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1504
T	1505	-- --------------------------------------------------------
	1506
2332b2	1507	--
d82984	1508	-- Table structure for table `sys_log`
2332b2	1509	--
d82984	1510
T	1511	CREATE TABLE `sys_log` (
	1512	`syslog_id` int(11) unsigned NOT NULL auto_increment,
	1513	`server_id` int(11) unsigned NOT NULL default '0',
	1514	`datalog_id` int(11) unsigned NOT NULL default '0',
	1515	`loglevel` tinyint(4) NOT NULL default '0',
	1516	`tstamp` int(11) unsigned NOT NULL,
	1517	`message` text,
	1518	PRIMARY KEY (`syslog_id`)
32f943	1519	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1520
32f943	1521	-- --------------------------------------------------------
L	1522
	1523	--
	1524	-- Table structure for table `sys_remoteaction`
	1525	--
	1526
	1527	CREATE TABLE `sys_remoteaction` (
	1528	`action_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	1529	`server_id` int(11) unsigned NOT NULL,
	1530	`tstamp` int(11) NOT NULL,
	1531	`action_type` varchar(20) NOT NULL,
	1532	`action_param` mediumtext NOT NULL,
	1533	`action_state` enum('pending','ok','warning','error') NOT NULL,
	1534	`response` mediumtext NOT NULL,
	1535	PRIMARY KEY (`action_id`),
	1536	KEY `server_id` (`server_id`)
	1537	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
	1538
	1539	-- --------------------------------------------------------
	1540
	1541	--
	1542	-- Table structure for table `sys_session`
	1543	--
	1544
	1545	CREATE TABLE `sys_session` (
68c5cc	1546	`session_id` varchar(64) NOT NULL DEFAULT '',
32f943	1547	`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
L	1548	`last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
	1549	`session_data` longtext,
	1550	PRIMARY KEY (`session_id`),
	1551	KEY `last_updated` (`last_updated`)
	1552	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
d82984	1553
T	1554	-- --------------------------------------------------------
	1555
cea1e5	1556	--
T	1557	-- Table structure for table `sys_theme`
	1558	--
	1559
	1560	CREATE TABLE IF NOT EXISTS `sys_theme` (
4bd960	1561	`sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
T	1562	`sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
	1563	`sys_perm_user` varchar(5) DEFAULT NULL,
	1564	`sys_perm_group` varchar(5) DEFAULT NULL,
	1565	`sys_perm_other` varchar(5) DEFAULT NULL,
cea1e5	1566	`var_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
T	1567	`tpl_name` varchar(32) NOT NULL,
	1568	`username` varchar(64) NOT NULL,
	1569	`logo_url` varchar(255) NOT NULL,
	1570	PRIMARY KEY (`var_id`)
	1571	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
	1572
	1573	-- --------------------------------------------------------
	1574
2332b2	1575	--
d82984	1576	-- Table structure for table `sys_user`
2332b2	1577	--
d82984	1578
T	1579	CREATE TABLE `sys_user` (
	1580	`userid` int(11) unsigned NOT NULL auto_increment,
	1581	`sys_userid` int(11) unsigned NOT NULL default '1',
	1582	`sys_groupid` int(11) unsigned NOT NULL default '1',
	1583	`sys_perm_user` varchar(5) NOT NULL default 'riud',
	1584	`sys_perm_group` varchar(5) NOT NULL default 'riud',
	1585	`sys_perm_other` varchar(5) NOT NULL default '',
	1586	`username` varchar(64) NOT NULL default '',
	1587	`passwort` varchar(64) NOT NULL default '',
	1588	`modules` varchar(255) NOT NULL default '',
	1589	`startmodule` varchar(255) NOT NULL default '',
	1590	`app_theme` varchar(32) NOT NULL default 'default',
	1591	`typ` varchar(16) NOT NULL default 'user',
	1592	`active` tinyint(1) NOT NULL default '1',
29974f	1593	`language` varchar(2) NOT NULL default 'en',
7ee55f	1594	`groups` TEXT NOT NULL default '',
d82984	1595	`default_group` int(11) unsigned NOT NULL default '0',
T	1596	`client_id` int(11) unsigned NOT NULL default '0',
7ee55f	1597	`id_rsa` VARCHAR( 2000 ) NOT NULL default '',
2332b2	1598	`ssh_rsa` VARCHAR( 600 ) NOT NULL default '',
d82984	1599	PRIMARY KEY (`userid`)
32f943	1600	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1601
T	1602	-- --------------------------------------------------------
	1603
32f943	1604	--
L	1605	-- Table structure for table `webdav_user`
	1606	--
d82984	1607
32f943	1608	CREATE TABLE `webdav_user` (
L	1609	`webdav_user_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	1610	`sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
	1611	`sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
	1612	`sys_perm_user` varchar(5) DEFAULT NULL,
	1613	`sys_perm_group` varchar(5) DEFAULT NULL,
	1614	`sys_perm_other` varchar(5) DEFAULT NULL,
	1615	`server_id` int(11) unsigned NOT NULL DEFAULT '0',
	1616	`parent_domain_id` int(11) unsigned NOT NULL DEFAULT '0',
	1617	`username` varchar(64) DEFAULT NULL,
10b4c8	1618	`username_prefix` varchar(50) NOT NULL default '',
32f943	1619	`password` varchar(64) DEFAULT NULL,
L	1620	`active` enum('n','y') NOT NULL DEFAULT 'y',
	1621	`dir` varchar(255) DEFAULT NULL,
	1622	PRIMARY KEY (`webdav_user_id`)
	1623	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
	1624
	1625	-- --------------------------------------------------------
	1626
	1627	--
5a43e7	1628	-- Table structure for table `web_backup`
T	1629	--
	1630
	1631	CREATE TABLE `web_backup` (
	1632	`backup_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
	1633	`server_id` int(10) unsigned NOT NULL,
	1634	`parent_domain_id` int(10) unsigned NOT NULL,
2332b2	1635	`backup_type` enum('web','mongodb','mysql') NOT NULL DEFAULT 'web',
209f8a	1636	`backup_mode` varchar(64) NOT NULL DEFAULT '',
T	1637	`tstamp` int(10) unsigned NOT NULL,
	1638	`filename` varchar(255) NOT NULL,
	1639	`filesize` VARCHAR(10) NOT NULL,
	1640	PRIMARY KEY (`backup_id`)
2332b2	1641	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
T	1642
5a43e7	1643	-- --------------------------------------------------------
T	1644
	1645	--
32f943	1646	-- Table structure for table `web_database`
L	1647	--
	1648
	1649	CREATE TABLE `web_database` (
	1650	`database_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	1651	`sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
	1652	`sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
	1653	`sys_perm_user` varchar(5) DEFAULT NULL,
	1654	`sys_perm_group` varchar(5) DEFAULT NULL,
	1655	`sys_perm_other` varchar(5) DEFAULT NULL,
	1656	`server_id` int(11) unsigned NOT NULL DEFAULT '0',
5a43e7	1657	`parent_domain_id` int(11) unsigned NOT NULL DEFAULT '0',
32f943	1658	`type` varchar(16) NOT NULL DEFAULT 'y',
L	1659	`database_name` varchar(64) DEFAULT NULL,
10b4c8	1660	`database_name_prefix` varchar(50) NOT NULL default '',
381520	1661	`database_user_id` int(11) unsigned DEFAULT NULL,
M	1662	`database_ro_user_id` int(11) unsigned DEFAULT NULL,
32f943	1663	`database_charset` varchar(64) DEFAULT NULL,
L	1664	`remote_access` enum('n','y') NOT NULL DEFAULT 'y',
	1665	`remote_ips` text NOT NULL,
5a43e7	1666	`backup_interval` VARCHAR( 255 ) NOT NULL DEFAULT 'none',
T	1667	`backup_copies` INT NOT NULL DEFAULT '1',
32f943	1668	`active` enum('n','y') NOT NULL DEFAULT 'y',
381520	1669	PRIMARY KEY (`database_id`),
M	1670	KEY `database_user_id` (`database_user_id`),
	1671	KEY `database_ro_user_id` (`database_ro_user_id`)
32f943	1672	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1673
T	1674	-- --------------------------------------------------------
	1675
381520	1676	--
M	1677	-- Tabellenstruktur für Tabelle `web_database_user`
	1678	--
	1679
	1680	CREATE TABLE IF NOT EXISTS `web_database_user` (
	1681	`database_user_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	1682	`sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
	1683	`sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
	1684	`sys_perm_user` varchar(5) DEFAULT NULL,
	1685	`sys_perm_group` varchar(5) DEFAULT NULL,
	1686	`sys_perm_other` varchar(5) DEFAULT NULL,
413df7	1687	`server_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
381520	1688	`database_user` varchar(64) DEFAULT NULL,
10b4c8	1689	`database_user_prefix` varchar(50) NOT NULL default '',
381520	1690	`database_password` varchar(64) DEFAULT NULL,
2332b2	1691	`database_password_mongo` varchar(32) DEFAULT NULL,
381520	1692	PRIMARY KEY (`database_user_id`)
M	1693	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
	1694
	1695	-- --------------------------------------------------------
	1696
2332b2	1697	--
d82984	1698	-- Table structure for table `web_domain`
2332b2	1699	--
d82984	1700
T	1701	CREATE TABLE `web_domain` (
	1702	`domain_id` int(11) unsigned NOT NULL auto_increment,
	1703	`sys_userid` int(11) unsigned NOT NULL default '0',
	1704	`sys_groupid` int(11) unsigned NOT NULL default '0',
	1705	`sys_perm_user` varchar(5) default NULL,
	1706	`sys_perm_group` varchar(5) default NULL,
	1707	`sys_perm_other` varchar(5) default NULL,
	1708	`server_id` int(11) unsigned NOT NULL default '0',
	1709	`ip_address` varchar(39) default NULL,
feb022	1710	`ipv6_address` VARCHAR( 255 ) default NULL,
d82984	1711	`domain` varchar(255) default NULL,
T	1712	`type` varchar(32) default NULL,
	1713	`parent_domain_id` int(11) unsigned NOT NULL default '0',
	1714	`vhost_type` varchar(32) default NULL,
	1715	`document_root` varchar(255) default NULL,
6fb93d	1716	`web_folder` varchar(100) default NULL,
d82984	1717	`system_user` varchar(255) default NULL,
T	1718	`system_group` varchar(255) default NULL,
	1719	`hd_quota` bigint(20) NOT NULL default '0',
	1720	`traffic_quota` bigint(20) NOT NULL default '-1',
	1721	`cgi` enum('n','y') NOT NULL default 'y',
	1722	`ssi` enum('n','y') NOT NULL default 'y',
	1723	`suexec` enum('n','y') NOT NULL default 'y',
	1724	`errordocs` tinyint(1) NOT NULL default '1',
	1725	`is_subdomainwww` tinyint(1) NOT NULL default '1',
	1726	`subdomain` enum('none','www','*') NOT NULL default 'none',
	1727	`php` varchar(32) NOT NULL default 'y',
	1728	`ruby` enum('n','y') NOT NULL default 'n',
298ef5	1729	`python` enum('n','y') NOT NULL default 'n',
ab7597	1730	`perl` enum('n','y') NOT NULL default 'n',
d82984	1731	`redirect_type` varchar(255) default NULL,
T	1732	`redirect_path` varchar(255) default NULL,
e64fbb	1733	`seo_redirect` varchar(255) default NULL,
d82984	1734	`ssl` enum('n','y') NOT NULL default 'n',
T	1735	`ssl_state` varchar(255) NULL,
	1736	`ssl_locality` varchar(255) NULL,
	1737	`ssl_organisation` varchar(255) NULL,
	1738	`ssl_organisation_unit` varchar(255) NULL,
	1739	`ssl_country` varchar(255) NULL,
	1740	`ssl_domain` varchar(255) NULL,
	1741	`ssl_request` mediumtext NULL,
	1742	`ssl_cert` mediumtext NULL,
	1743	`ssl_bundle` mediumtext NULL,
cea1e5	1744	`ssl_key` mediumtext NULL,
d82984	1745	`ssl_action` varchar(16) NULL,
T	1746	`stats_password` varchar(255) default NULL,
	1747	`stats_type` varchar(255) default 'webalizer',
	1748	`allow_override` varchar(255) NOT NULL default 'All',
	1749	`apache_directives` mediumtext,
80e3c9	1750	`nginx_directives` mediumtext,
793622	1751	`php_fpm_use_socket` ENUM('n','y') NOT NULL DEFAULT 'n',
dd7ce4	1752	`pm` enum('static','dynamic','ondemand') NOT NULL DEFAULT 'dynamic',
648d43	1753	`pm_max_children` int(11) NOT NULL DEFAULT '10',
F	1754	`pm_start_servers` int(11) NOT NULL DEFAULT '2',
	1755	`pm_min_spare_servers` int(11) NOT NULL DEFAULT '1',
	1756	`pm_max_spare_servers` int(11) NOT NULL DEFAULT '5',
dd7ce4	1757	`pm_process_idle_timeout` int(11) NOT NULL DEFAULT '10',
F	1758	`pm_max_requests` int(11) NOT NULL DEFAULT '0',
d82984	1759	`php_open_basedir` mediumtext,
T	1760	`custom_php_ini` mediumtext,
	1761	`backup_interval` VARCHAR( 255 ) NOT NULL DEFAULT 'none',
	1762	`backup_copies` INT NOT NULL DEFAULT '1',
	1763	`active` enum('n','y') NOT NULL default 'y',
	1764	`traffic_quota_lock` enum('n','y') NOT NULL default 'n',
62b385	1765	`fastcgi_php_version` varchar(255) DEFAULT NULL,
bfcdef	1766	`proxy_directives` mediumtext,
615a0a	1767	`last_quota_notification` date NULL default NULL,
T	1768	`rewrite_rules` mediumtext,
d82984	1769	PRIMARY KEY (`domain_id`)
32f943	1770	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
d82984	1771
T	1772	-- --------------------------------------------------------
	1773
	1774	--
6ad46a	1775	-- Table structure for table `web_folder`
T	1776	--
	1777
	1778	CREATE TABLE IF NOT EXISTS `web_folder` (
	1779	`web_folder_id` bigint(20) NOT NULL AUTO_INCREMENT,
	1780	`sys_userid` int(11) NOT NULL DEFAULT '0',
	1781	`sys_groupid` int(11) NOT NULL DEFAULT '0',
	1782	`sys_perm_user` varchar(5) DEFAULT NULL,
	1783	`sys_perm_group` varchar(5) DEFAULT NULL,
	1784	`sys_perm_other` varchar(5) DEFAULT NULL,
	1785	`server_id` int(11) NOT NULL DEFAULT '0',
	1786	`parent_domain_id` int(11) NOT NULL DEFAULT '0',
	1787	`path` varchar(255) DEFAULT NULL,
	1788	`active` varchar(255) NOT NULL DEFAULT 'y',
	1789	PRIMARY KEY (`web_folder_id`)
	1790	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
	1791
	1792	--
	1793	-- Dumping data for table `web_folder`
	1794	--
	1795
	1796
	1797	-- --------------------------------------------------------
	1798
	1799	--
	1800	-- Table structure for table `web_folder_user`
	1801	--
	1802
	1803	CREATE TABLE IF NOT EXISTS `web_folder_user` (
	1804	`web_folder_user_id` bigint(20) NOT NULL AUTO_INCREMENT,
	1805	`sys_userid` int(11) NOT NULL DEFAULT '0',
	1806	`sys_groupid` int(11) NOT NULL DEFAULT '0',
	1807	`sys_perm_user` varchar(5) DEFAULT NULL,
	1808	`sys_perm_group` varchar(5) DEFAULT NULL,
	1809	`sys_perm_other` varchar(5) DEFAULT NULL,
524077	1810	`server_id` int(11) NOT NULL DEFAULT '0',
6ad46a	1811	`web_folder_id` int(11) NOT NULL DEFAULT '0',
T	1812	`username` varchar(255) DEFAULT NULL,
	1813	`password` varchar(255) DEFAULT NULL,
	1814	`active` varchar(255) NOT NULL DEFAULT 'y',
	1815	PRIMARY KEY (`web_folder_user_id`)
	1816	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
	1817
	1818	--
	1819	-- Dumping data for table `web_folder_user`
	1820	--
	1821
	1822	-- --------------------------------------------------------
	1823
	1824	--
d82984	1825	-- Table structure for table `web_traffic`
T	1826	--
	1827
	1828	CREATE TABLE `web_traffic` (
	1829	`hostname` varchar(255) NOT NULL,
	1830	`traffic_date` date NOT NULL,
	1831	`traffic_bytes` bigint(32) unsigned NOT NULL default '0',
	1832	PRIMARY KEY (`hostname`,`traffic_date`)
32f943	1833	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
d82984	1834
T	1835	-- --------------------------------------------------------
	1836	-- --------------------------------------------------------
	1837	-- DB-DATA
	1838	-- --------------------------------------------------------
	1839	-- --------------------------------------------------------
	1840
477d4e	1841	--
T	1842	-- Dumping data for table `aps_settings`
	1843	--
	1844
	1845	INSERT INTO `aps_settings` (`id`, `name`, `value`) VALUES(1, 'ignore-php-extension', '');
	1846	INSERT INTO `aps_settings` (`id`, `name`, `value`) VALUES(2, 'ignore-php-configuration', '');
	1847	INSERT INTO `aps_settings` (`id`, `name`, `value`) VALUES(3, 'ignore-webserver-module', '');
	1848
d82984	1849	-- --------------------------------------------------------
T	1850
	1851	--
	1852	-- Dumping data for table `country`
	1853	--
	1854
	1855	INSERT INTO `country` (`iso`, `name`, `printable_name`, `iso3`, `numcode`) VALUES
	1856	('AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4),
	1857	('AL', 'ALBANIA', 'Albania', 'ALB', 8),
	1858	('DZ', 'ALGERIA', 'Algeria', 'DZA', 12),
	1859	('AS', 'AMERICAN SAMOA', 'American Samoa', 'ASM', 16),
	1860	('AD', 'ANDORRA', 'Andorra', 'AND', 20),
	1861	('AO', 'ANGOLA', 'Angola', 'AGO', 24),
	1862	('AI', 'ANGUILLA', 'Anguilla', 'AIA', 660),
	1863	('AQ', 'ANTARCTICA', 'Antarctica', NULL, NULL),
	1864	('AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'ATG', 28),
	1865	('AR', 'ARGENTINA', 'Argentina', 'ARG', 32),
	1866	('AM', 'ARMENIA', 'Armenia', 'ARM', 51),
	1867	('AW', 'ARUBA', 'Aruba', 'ABW', 533),
	1868	('AU', 'AUSTRALIA', 'Australia', 'AUS', 36),
	1869	('AT', 'AUSTRIA', 'Austria', 'AUT', 40),
	1870	('AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', 31),
	1871	('BS', 'BAHAMAS', 'Bahamas', 'BHS', 44),
	1872	('BH', 'BAHRAIN', 'Bahrain', 'BHR', 48),
	1873	('BD', 'BANGLADESH', 'Bangladesh', 'BGD', 50),
	1874	('BB', 'BARBADOS', 'Barbados', 'BRB', 52),
	1875	('BY', 'BELARUS', 'Belarus', 'BLR', 112),
	1876	('BE', 'BELGIUM', 'Belgium', 'BEL', 56),
	1877	('BZ', 'BELIZE', 'Belize', 'BLZ', 84),
	1878	('BJ', 'BENIN', 'Benin', 'BEN', 204),
	1879	('BM', 'BERMUDA', 'Bermuda', 'BMU', 60),
	1880	('BT', 'BHUTAN', 'Bhutan', 'BTN', 64),
	1881	('BO', 'BOLIVIA', 'Bolivia', 'BOL', 68),
	1882	('BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'BIH', 70),
	1883	('BW', 'BOTSWANA', 'Botswana', 'BWA', 72),
	1884	('BV', 'BOUVET ISLAND', 'Bouvet Island', NULL, NULL),
	1885	('BR', 'BRAZIL', 'Brazil', 'BRA', 76),
	1886	('IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', NULL, NULL),
	1887	('BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', 96),
	1888	('BG', 'BULGARIA', 'Bulgaria', 'BGR', 100),
	1889	('BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', 854),
	1890	('BI', 'BURUNDI', 'Burundi', 'BDI', 108),
	1891	('KH', 'CAMBODIA', 'Cambodia', 'KHM', 116),
	1892	('CM', 'CAMEROON', 'Cameroon', 'CMR', 120),
	1893	('CA', 'CANADA', 'Canada', 'CAN', 124),
	1894	('CV', 'CAPE VERDE', 'Cape Verde', 'CPV', 132),
	1895	('KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', 136),
	1896	('CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', 140),
	1897	('TD', 'CHAD', 'Chad', 'TCD', 148),
	1898	('CL', 'CHILE', 'Chile', 'CHL', 152),
	1899	('CN', 'CHINA', 'China', 'CHN', 156),
	1900	('CX', 'CHRISTMAS ISLAND', 'Christmas Island', NULL, NULL),
	1901	('CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', NULL, NULL),
	1902	('CO', 'COLOMBIA', 'Colombia', 'COL', 170),
	1903	('KM', 'COMOROS', 'Comoros', 'COM', 174),
	1904	('CG', 'CONGO', 'Congo', 'COG', 178),
	1905	('CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, the Democratic Republic of the', 'COD', 180),
	1906	('CK', 'COOK ISLANDS', 'Cook Islands', 'COK', 184),
	1907	('CR', 'COSTA RICA', 'Costa Rica', 'CRI', 188),
	1908	('CI', 'COTE D''IVOIRE', 'Cote D''Ivoire', 'CIV', 384),
	1909	('HR', 'CROATIA', 'Croatia', 'HRV', 191),
	1910	('CU', 'CUBA', 'Cuba', 'CUB', 192),
	1911	('CY', 'CYPRUS', 'Cyprus', 'CYP', 196),
	1912	('CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', 203),
	1913	('DK', 'DENMARK', 'Denmark', 'DNK', 208),
	1914	('DJ', 'DJIBOUTI', 'Djibouti', 'DJI', 262),
	1915	('DM', 'DOMINICA', 'Dominica', 'DMA', 212),
	1916	('DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', 214),
	1917	('EC', 'ECUADOR', 'Ecuador', 'ECU', 218),
	1918	('EG', 'EGYPT', 'Egypt', 'EGY', 818),
	1919	('SV', 'EL SALVADOR', 'El Salvador', 'SLV', 222),
	1920	('GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', 226),
	1921	('ER', 'ERITREA', 'Eritrea', 'ERI', 232),
	1922	('EE', 'ESTONIA', 'Estonia', 'EST', 233),
	1923	('ET', 'ETHIOPIA', 'Ethiopia', 'ETH', 231),
	1924	('FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'FLK', 238),
	1925	('FO', 'FAROE ISLANDS', 'Faroe Islands', 'FRO', 234),
	1926	('FJ', 'FIJI', 'Fiji', 'FJI', 242),
	1927	('FI', 'FINLAND', 'Finland', 'FIN', 246),
	1928	('FR', 'FRANCE', 'France', 'FRA', 250),
	1929	('GF', 'FRENCH GUIANA', 'French Guiana', 'GUF', 254),
	1930	('PF', 'FRENCH POLYNESIA', 'French Polynesia', 'PYF', 258),
	1931	('TF', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', NULL, NULL),
	1932	('GA', 'GABON', 'Gabon', 'GAB', 266),
	1933	('GM', 'GAMBIA', 'Gambia', 'GMB', 270),
	1934	('GE', 'GEORGIA', 'Georgia', 'GEO', 268),
	1935	('DE', 'GERMANY', 'Germany', 'DEU', 276),
	1936	('GH', 'GHANA', 'Ghana', 'GHA', 288),
	1937	('GI', 'GIBRALTAR', 'Gibraltar', 'GIB', 292),
	1938	('GR', 'GREECE', 'Greece', 'GRC', 300),
	1939	('GL', 'GREENLAND', 'Greenland', 'GRL', 304),
	1940	('GD', 'GRENADA', 'Grenada', 'GRD', 308),
	1941	('GP', 'GUADELOUPE', 'Guadeloupe', 'GLP', 312),
	1942	('GU', 'GUAM', 'Guam', 'GUM', 316),
	1943	('GT', 'GUATEMALA', 'Guatemala', 'GTM', 320),
	1944	('GN', 'GUINEA', 'Guinea', 'GIN', 324),
	1945	('GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', 624),
	1946	('GY', 'GUYANA', 'Guyana', 'GUY', 328),
	1947	('HT', 'HAITI', 'Haiti', 'HTI', 332),
	1948	('HM', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Island and Mcdonald Islands', NULL, NULL),
	1949	('VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'VAT', 336),
	1950	('HN', 'HONDURAS', 'Honduras', 'HND', 340),
	1951	('HK', 'HONG KONG', 'Hong Kong', 'HKG', 344),
	1952	('HU', 'HUNGARY', 'Hungary', 'HUN', 348),
	1953	('IS', 'ICELAND', 'Iceland', 'ISL', 352),
	1954	('IN', 'INDIA', 'India', 'IND', 356),
	1955	('ID', 'INDONESIA', 'Indonesia', 'IDN', 360),
	1956	('IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'IRN', 364),
	1957	('IQ', 'IRAQ', 'Iraq', 'IRQ', 368),
	1958	('IE', 'IRELAND', 'Ireland', 'IRL', 372),
	1959	('IL', 'ISRAEL', 'Israel', 'ISR', 376),
	1960	('IT', 'ITALY', 'Italy', 'ITA', 380),
	1961	('JM', 'JAMAICA', 'Jamaica', 'JAM', 388),
	1962	('JP', 'JAPAN', 'Japan', 'JPN', 392),
	1963	('JO', 'JORDAN', 'Jordan', 'JOR', 400),
	1964	('KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', 398),
	1965	('KE', 'KENYA', 'Kenya', 'KEN', 404),
	1966	('KI', 'KIRIBATI', 'Kiribati', 'KIR', 296),
	1967	('KP', 'KOREA, DEMOCRATIC PEOPLE''S REPUBLIC OF', 'Korea, Democratic People''s Republic of', 'PRK', 408),
	1968	('KR', 'KOREA, REPUBLIC OF', 'Korea, Republic of', 'KOR', 410),
	1969	('KW', 'KUWAIT', 'Kuwait', 'KWT', 414),
	1970	('KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', 417),
	1971	('LA', 'LAO PEOPLE''S DEMOCRATIC REPUBLIC', 'Lao People''s Democratic Republic', 'LAO', 418),
	1972	('LV', 'LATVIA', 'Latvia', 'LVA', 428),
	1973	('LB', 'LEBANON', 'Lebanon', 'LBN', 422),
	1974	('LS', 'LESOTHO', 'Lesotho', 'LSO', 426),
	1975	('LR', 'LIBERIA', 'Liberia', 'LBR', 430),
	1976	('LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', 434),
	1977	('LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', 438),
	1978	('LT', 'LITHUANIA', 'Lithuania', 'LTU', 440),
	1979	('LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', 442),
	1980	('MO', 'MACAO', 'Macao', 'MAC', 446),
	1981	('MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia, the Former Yugoslav Republic of', 'MKD', 807),
	1982	('MG', 'MADAGASCAR', 'Madagascar', 'MDG', 450),
	1983	('MW', 'MALAWI', 'Malawi', 'MWI', 454),
	1984	('MY', 'MALAYSIA', 'Malaysia', 'MYS', 458),
	1985	('MV', 'MALDIVES', 'Maldives', 'MDV', 462),
	1986	('ML', 'MALI', 'Mali', 'MLI', 466),
	1987	('MT', 'MALTA', 'Malta', 'MLT', 470),
	1988	('MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'MHL', 584),
	1989	('MQ', 'MARTINIQUE', 'Martinique', 'MTQ', 474),
	1990	('MR', 'MAURITANIA', 'Mauritania', 'MRT', 478),
	1991	('MU', 'MAURITIUS', 'Mauritius', 'MUS', 480),
	1992	('YT', 'MAYOTTE', 'Mayotte', NULL, NULL),
	1993	('MX', 'MEXICO', 'Mexico', 'MEX', 484),
	1994	('FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia, Federated States of', 'FSM', 583),
	1995	('MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'MDA', 498),
	1996	('MC', 'MONACO', 'Monaco', 'MCO', 492),
	1997	('MN', 'MONGOLIA', 'Mongolia', 'MNG', 496),
	1998	('MS', 'MONTSERRAT', 'Montserrat', 'MSR', 500),
	1999	('MA', 'MOROCCO', 'Morocco', 'MAR', 504),
	2000	('MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', 508),
	2001	('MM', 'MYANMAR', 'Myanmar', 'MMR', 104),
	2002	('NA', 'NAMIBIA', 'Namibia', 'NAM', 516),
	2003	('NR', 'NAURU', 'Nauru', 'NRU', 520),
	2004	('NP', 'NEPAL', 'Nepal', 'NPL', 524),
	2005	('NL', 'NETHERLANDS', 'Netherlands', 'NLD', 528),
	2006	('AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'ANT', 530),
	2007	('NC', 'NEW CALEDONIA', 'New Caledonia', 'NCL', 540),
	2008	('NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554),
	2009	('NI', 'NICARAGUA', 'Nicaragua', 'NIC', 558),
	2010	('NE', 'NIGER', 'Niger', 'NER', 562),
	2011	('NG', 'NIGERIA', 'Nigeria', 'NGA', 566),
	2012	('NU', 'NIUE', 'Niue', 'NIU', 570),
	2013	('NF', 'NORFOLK ISLAND', 'Norfolk Island', 'NFK', 574),
	2014	('MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'MNP', 580),
	2015	('NO', 'NORWAY', 'Norway', 'NOR', 578),
	2016	('OM', 'OMAN', 'Oman', 'OMN', 512),
	2017	('PK', 'PAKISTAN', 'Pakistan', 'PAK', 586),
	2018	('PW', 'PALAU', 'Palau', 'PLW', 585),
	2019	('PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian Territory, Occupied', NULL, NULL),
	2020	('PA', 'PANAMA', 'Panama', 'PAN', 591),
	2021	('PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', 598),
	2022	('PY', 'PARAGUAY', 'Paraguay', 'PRY', 600),
	2023	('PE', 'PERU', 'Peru', 'PER', 604),
	2024	('PH', 'PHILIPPINES', 'Philippines', 'PHL', 608),
	2025	('PN', 'PITCAIRN', 'Pitcairn', 'PCN', 612),
	2026	('PL', 'POLAND', 'Poland', 'POL', 616),
	2027	('PT', 'PORTUGAL', 'Portugal', 'PRT', 620),
	2028	('PR', 'PUERTO RICO', 'Puerto Rico', 'PRI', 630),
	2029	('QA', 'QATAR', 'Qatar', 'QAT', 634),
	2030	('RE', 'REUNION', 'Reunion', 'REU', 638),
	2031	('RO', 'ROMANIA', 'Romania', 'ROM', 642),
	2032	('RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', 643),
	2033	('RW', 'RWANDA', 'Rwanda', 'RWA', 646),
	2034	('SH', 'SAINT HELENA', 'Saint Helena', 'SHN', 654),
	2035	('KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'KNA', 659),
	2036	('LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', 662),
	2037	('PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'SPM', 666),
	2038	('VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'VCT', 670),
	2039	('WS', 'SAMOA', 'Samoa', 'WSM', 882),
	2040	('SM', 'SAN MARINO', 'San Marino', 'SMR', 674),
	2041	('ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'STP', 678),
	2042	('SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', 682),
	2043	('SN', 'SENEGAL', 'Senegal', 'SEN', 686),
615a0a	2044	('RS', 'SERBIA', 'Serbia', 'SRB', 381),
d82984	2045	('SC', 'SEYCHELLES', 'Seychelles', 'SYC', 690),
T	2046	('SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', 694),
	2047	('SG', 'SINGAPORE', 'Singapore', 'SGP', 702),
	2048	('SK', 'SLOVAKIA', 'Slovakia', 'SVK', 703),
	2049	('SI', 'SLOVENIA', 'Slovenia', 'SVN', 705),
	2050	('SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', 90),
	2051	('SO', 'SOMALIA', 'Somalia', 'SOM', 706),
	2052	('ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710),
	2053	('GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia and the South Sandwich Islands', NULL, NULL),
	2054	('ES', 'SPAIN', 'Spain', 'ESP', 724),
	2055	('LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144),
	2056	('SD', 'SUDAN', 'Sudan', 'SDN', 736),
	2057	('SR', 'SURINAME', 'Suriname', 'SUR', 740),
	2058	('SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'SJM', 744),
	2059	('SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748),
	2060	('SE', 'SWEDEN', 'Sweden', 'SWE', 752),
	2061	('CH', 'SWITZERLAND', 'Switzerland', 'CHE', 756),
	2062	('SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', 760),
	2063	('TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'TWN', 158),
	2064	('TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', 762),
	2065	('TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'TZA', 834),
	2066	('TH', 'THAILAND', 'Thailand', 'THA', 764),
	2067	('TL', 'TIMOR-LESTE', 'Timor-Leste', NULL, NULL),
	2068	('TG', 'TOGO', 'Togo', 'TGO', 768),
	2069	('TK', 'TOKELAU', 'Tokelau', 'TKL', 772),
	2070	('TO', 'TONGA', 'Tonga', 'TON', 776),
	2071	('TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'TTO', 780),
	2072	('TN', 'TUNISIA', 'Tunisia', 'TUN', 788),
	2073	('TR', 'TURKEY', 'Turkey', 'TUR', 792),
	2074	('TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', 795),
	2075	('TC', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'TCA', 796),
	2076	('TV', 'TUVALU', 'Tuvalu', 'TUV', 798),
	2077	('UG', 'UGANDA', 'Uganda', 'UGA', 800),
	2078	('UA', 'UKRAINE', 'Ukraine', 'UKR', 804),
	2079	('AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', 784),
	2080	('GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826),
	2081	('US', 'UNITED STATES', 'United States', 'USA', 840),
	2082	('UM', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', NULL, NULL),
	2083	('UY', 'URUGUAY', 'Uruguay', 'URY', 858),
	2084	('UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', 860),
	2085	('VU', 'VANUATU', 'Vanuatu', 'VUT', 548),
	2086	('VE', 'VENEZUELA', 'Venezuela', 'VEN', 862),
	2087	('VN', 'VIET NAM', 'Viet Nam', 'VNM', 704),
	2088	('VG', 'VIRGIN ISLANDS, BRITISH', 'Virgin Islands, British', 'VGB', 92),
	2089	('VI', 'VIRGIN ISLANDS, U.S.', 'Virgin Islands, U.s.', 'VIR', 850),
	2090	('WF', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'WLF', 876),
	2091	('EH', 'WESTERN SAHARA', 'Western Sahara', 'ESH', 732),
	2092	('YE', 'YEMEN', 'Yemen', 'YEM', 887),
	2093	('ZM', 'ZAMBIA', 'Zambia', 'ZMB', 894),
615a0a	2094	('ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', 716),
T	2095	('ME', 'MONTENEGRO', 'Montenegro', 'MNE', 382);
d82984	2096
T	2097	-- --------------------------------------------------------
	2098
2332b2	2099	--
32f943	2100	-- Dumping data for table `dns_template`
2332b2	2101	--
d82984	2102
32f943	2103	INSERT INTO `dns_template` (`template_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `name`, `fields`, `template`, `visible`) VALUES (1, 1, 1, 'riud', 'riud', '', 'Default', 'DOMAIN,IP,NS1,NS2,EMAIL', '[ZONE]\norigin={DOMAIN}.\nns={NS1}.\nmbox={EMAIL}.\nrefresh=7200\nretry=540\nexpire=604800\nminimum=86400\nttl=3600\n\n[DNS_RECORDS]\nA\|{DOMAIN}.\|{IP}\|0\|3600\nA\|www\|{IP}\|0\|3600\nA\|mail\|{IP}\|0\|3600\nNS\|{DOMAIN}.\|{NS1}.\|0\|3600\nNS\|{DOMAIN}.\|{NS2}.\|0\|3600\nMX\|{DOMAIN}.\|mail.{DOMAIN}.\|10\|3600', 'y');
80e3c9	2104
d82984	2105	-- --------------------------------------------------------
T	2106
2332b2	2107	--
32f943	2108	-- Dumping data for table `help_faq`
2332b2	2109	--
32f943	2110
L	2111	INSERT INTO `help_faq` VALUES (1,1,0,'I would like to know ...','Yes, of course.',1,1,'riud','riud','r');
	2112
	2113	-- --------------------------------------------------------
	2114
2332b2	2115	--
32f943	2116	-- Dumping data for table `help_faq_sections`
2332b2	2117	--
32f943	2118
L	2119	INSERT INTO `help_faq_sections` VALUES (1,'General',0,NULL,NULL,NULL,NULL,NULL);
	2120
	2121	-- --------------------------------------------------------
	2122
2332b2	2123	--
32f943	2124	-- Dumping data for table `software_repo`
2332b2	2125	--
32f943	2126
L	2127	INSERT INTO `software_repo` (`software_repo_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `repo_name`, `repo_url`, `repo_username`, `repo_password`, `active`) VALUES (1, 1, 1, 'riud', 'riud', '', 'ISPConfig Addons', 'http://repo.ispconfig.org/addons/', '', '', 'n');
	2128
	2129	-- --------------------------------------------------------
	2130
2332b2	2131	--
32f943	2132	-- Dumping data for table `spamfilter_policy`
2332b2	2133	--
32f943	2134
L	2135	INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES(1, 1, 0, 'riud', 'riud', 'r', 'Non-paying', 'N', 'N', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'Y', '', '', '', '', '', '', 3, 7, 10, 0, 0, '', '', '', '', 'N', 'N', 'N', '', '', '', '', '', '', '', 0, '');
	2136	INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES(2, 1, 0, 'riud', 'riud', 'r', 'Uncensored', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', NULL, NULL, NULL, NULL, NULL, NULL, 3, 999, 999, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	2137	INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES(3, 1, 0, 'riud', 'riud', 'r', 'Wants all spam', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 999, 999, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	2138	INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES(4, 1, 0, 'riud', 'riud', 'r', 'Wants viruses', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 6.9, 6.9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	2139	INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES(5, 1, 0, 'riud', 'riud', 'r', 'Normal', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', '', '', '', '', '', '', 1, 4.5, 50, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '*SPAM*', NULL, NULL);
	2140	INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES(6, 1, 0, 'riud', 'riud', 'r', 'Trigger happy', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 5, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	2141	INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES(7, 1, 0, 'riud', 'riud', 'r', 'Permissive', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 10, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	2142
	2143	-- --------------------------------------------------------
	2144
2332b2	2145	--
32f943	2146	-- Dumping data for table `sys_group`
2332b2	2147	--
32f943	2148
L	2149	INSERT INTO `sys_group` (`groupid`, `name`, `description`, `client_id`) VALUES (1, 'admin', 'Administrators group', 0);
	2150
	2151	-- --------------------------------------------------------
	2152
2332b2	2153	--
32f943	2154	-- Dumping data for table `sys_ini`
2332b2	2155	--
32f943	2156
L	2157	INSERT INTO `sys_ini` (`sysini_id`, `config`) VALUES (1, '');
	2158
	2159	-- --------------------------------------------------------
	2160
2332b2	2161	--
32f943	2162	-- Dumping data for table `sys_user`
2332b2	2163	--
32f943	2164
cea1e5	2165	INSERT INTO `sys_theme` (`var_id`, `tpl_name`, `username`, `logo_url`) VALUES (NULL, 'default', 'global', 'themes/default/images/header_logo.png');
T	2166	INSERT INTO `sys_theme` (`var_id`, `tpl_name`, `username`, `logo_url`) VALUES (NULL, 'default-v2', 'global', 'themes/default-v2/images/header_logo.png');
	2167
	2168	-- --------------------------------------------------------
	2169
2332b2	2170	--
cea1e5	2171	-- Dumping data for table `sys_user`
2332b2	2172	--
cea1e5	2173
967a4a	2174	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`, `language`, `groups`, `default_group`, `client_id`) VALUES (1, 1, 0, 'riud', 'riud', '', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'dashboard,admin,client,mail,monitor,sites,dns,vm,tools,help', 'dashboard', 'default', 'admin', 1, 'en', '1,2', 1, 0);
32f943	2175
L	2176	-- --------------------------------------------------------
	2177
	2178	--
	2179	-- Dumping data for table `sys_config`
	2180	--
56f698	2181
3f478f	2182	INSERT INTO sys_config VALUES ('1','db','db_version','3.0.5.2');
2332b2	2183
56f698	2184	SET FOREIGN_KEY_CHECKS = 1;