gitlabFork/ISPConfig3.git - Solinfo Gitblit

- don't set password via remoting if field is empty

Marius Cramer

2015-08-06 37b29231e47a0c4458dc1c15d98588f16f07e1e2

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