gitlabFork/ISPConfig3.git - Solinfo Gitblit

- Merged language files - Updated version number to 3.0.5.4rc1

Till Brehm

2014-04-03 a08e6c32e70561a3fadbd6062ca02c5f8c94b81d

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