gitlabFork/ISPConfig3.git - Solinfo Gitblit

Till Brehm

2014-04-15 2868133887226bed53154ade8d10e3d070e2e2f5

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