gitlabFork/ISPConfig3.git - Solinfo Gitblit

Till Brehm

2014-10-28 8348c8143be4775eccb5c24edebf7f7215a6f90a

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