gitlabFork/ISPConfig3.git - Solinfo Gitblit

Marius Burkard

2016-05-04 c3189ce6c7301c3ec17878fd3918f31d0d3cb18a

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