gitlabFork/ISPConfig3.git - Solinfo Gitblit

Merge remote-tracking branch 'origin/stable-3.0.5'

Marius Cramer

2014-02-17 ebbe6374fc9c308daf729d2ad1b2f8007ed771ce

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