gitlabFork/ISPConfig3.git - Solinfo Gitblit

Pascal Dreissen

2016-07-08 f1193b43f4c9fd132741d30f03f0b35841011989

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