gitlabFork/ISPConfig3.git - Solinfo Gitblit

tbrehm

2012-06-11 897af06af9522ded99b1e0f46730299e89856ffe

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