gitlabFork/ISPConfig3.git - Solinfo Gitblit

Merged revisions 3803-3844 from stable branch.

tbrehm

2013-02-22 526b997c9891a796b152cdbab8e329b356b1f596

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