gitlabFork/ISPConfig3.git - Solinfo Gitblit

tbrehm

2009-09-03 5421462b39a5b41014569af59d3861b9ffe8a44f

commit \| author \| age
24854c	1
T	2	/*
	3	Copyright (c) 2007-2009, Till Brehm, projektfarm Gmbh
	4	All rights reserved.
	5
	6	Redistribution and use in source and binary forms, with or without modification,
	7	are permitted provided that the following conditions are met:
	8
	9	* Redistributions of source code must retain the above copyright notice,
	10	this list of conditions and the following disclaimer.
	11	* Redistributions in binary form must reproduce the above copyright notice,
	12	this list of conditions and the following disclaimer in the documentation
	13	and/or other materials provided with the distribution.
	14	* Neither the name of ISPConfig nor the names of its contributors
	15	may be used to endorse or promote products derived from this software without
	16	specific prior written permission.
	17
	18	THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
	19	ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
	20	WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
	21	IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
	22	INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
	23	BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
	24	DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
	25	OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
	26	NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
	27	EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
	28	*/
	29
	30	--
	31	-- ISPConfig 3
	32	-- DB-Version: 3.0.0.9
	33	--
	34
	35	SET FOREIGN_KEY_CHECKS = 0;
	36
	37	-- --------------------------------------------------------
	38	-- --------------------------------------------------------
	39	-- DB-STRUCTURE
	40	-- --------------------------------------------------------
	41	-- --------------------------------------------------------
	42
	43	--
	44	-- Table structure for table `client`
	45	--
	46
	47	CREATE TABLE `client` (
	48	`client_id` int(11) unsigned NOT NULL auto_increment,
	49	`sys_userid` int(11) unsigned NOT NULL default '0',
	50	`sys_groupid` int(11) unsigned NOT NULL default '0',
	51	`sys_perm_user` varchar(5) default NULL,
	52	`sys_perm_group` varchar(5) default NULL,
	53	`sys_perm_other` varchar(5) default NULL,
	54	`company_name` varchar(64) default NULL,
	55	`contact_name` varchar(64) default NULL,
	56	`street` varchar(255) default NULL,
	57	`zip` varchar(32) default NULL,
	58	`city` varchar(64) default NULL,
	59	`state` varchar(32) default NULL,
	60	`country` char(2) default NULL,
	61	`telephone` varchar(32) default NULL,
	62	`mobile` varchar(32) default NULL,
	63	`fax` varchar(32) default NULL,
	64	`email` varchar(255) default NULL,
	65	`internet` varchar(255) NOT NULL,
	66	`icq` varchar(16) default NULL,
	67	`notes` text,
	68	`default_mailserver` int(11) unsigned NOT NULL default '1',
	69	`limit_maildomain` int(11) NOT NULL default '-1',
	70	`limit_mailbox` int(11) NOT NULL default '-1',
	71	`limit_mailalias` int(11) NOT NULL default '-1',
	72	`limit_mailforward` int(11) NOT NULL default '-1',
	73	`limit_mailcatchall` int(11) NOT NULL default '-1',
	74	`limit_mailrouting` int(11) NOT NULL default '0',
	75	`limit_mailfilter` int(11) NOT NULL default '-1',
	76	`limit_fetchmail` int(11) NOT NULL default '-1',
	77	`limit_mailquota` int(11) NOT NULL default '-1',
	78	`limit_spamfilter_wblist` int(11) NOT NULL default '0',
	79	`limit_spamfilter_user` int(11) NOT NULL default '0',
	80	`limit_spamfilter_policy` int(11) NOT NULL default '0',
	81	`default_webserver` int(11) unsigned NOT NULL default '1',
	82	`limit_web_ip` text,
	83	`limit_web_domain` int(11) NOT NULL default '-1',
	84	`web_php_options` varchar(255) NOT NULL default 'no,fast-cgi,cgi,mod,suphp',
	85	`limit_web_subdomain` int(11) NOT NULL default '-1',
	86	`limit_web_aliasdomain` int(11) NOT NULL default '-1',
	87	`limit_ftp_user` int(11) NOT NULL default '-1',
	88	`limit_shell_user` int(11) NOT NULL default '0',
	89	`ssh_chroot` varchar(255) NOT NULL DEFAULT 'no,jailkit,ssh-chroot',
	90	`default_dnsserver` int(11) unsigned NOT NULL default '1',
	91	`limit_dns_zone` int(11) NOT NULL default '-1',
	92	`limit_dns_record` int(11) NOT NULL default '-1',
	93	`default_dbserver` int(11) NOT NULL default '1',
	94	`limit_database` int(11) NOT NULL default '-1',
8c4aa3	95	`limit_cron` int(11) NOT NULL default '0',
T	96	`limit_cron_type` enum('url','chrooted','full') NOT NULL default 'url',
	97	`limit_cron_frequency` int(11) NOT NULL default '5',
24854c	98	`limit_client` int(11) NOT NULL default '0',
T	99	`parent_client_id` int(11) unsigned NOT NULL default '0',
	100	`username` varchar(64) default NULL,
	101	`password` varchar(64) default NULL,
	102	`language` char(2) NOT NULL default 'en',
	103	`usertheme` varchar(32) NOT NULL default 'default',
	104	`template_master` int(11) unsigned NOT NULL default '0',
	105	`template_additional` varchar(255) NOT NULL default '',
	106	`created_at` datetime default NULL,
	107	PRIMARY KEY (`client_id`)
	108	) ENGINE=MyISAM AUTO_INCREMENT=1;
	109
	110	-- --------------------------------------------------------
	111
	112	--
	113	-- Table structure for table `client_template`
	114	--
	115
	116	CREATE TABLE `client_template` (
	117	`template_id` int(11) unsigned NOT NULL auto_increment,
	118	`sys_userid` int(11) unsigned NOT NULL default '0',
	119	`sys_groupid` int(11) unsigned NOT NULL default '0',
	120	`sys_perm_user` varchar(5) default NULL,
	121	`sys_perm_group` varchar(5) default NULL,
	122	`sys_perm_other` varchar(5) default NULL,
	123	`template_name` varchar(64) NOT NULL,
	124	`template_type` varchar(1) NOT NULL default 'm',
	125	`limit_maildomain` int(11) NOT NULL default '-1',
	126	`limit_mailbox` int(11) NOT NULL default '-1',
	127	`limit_mailalias` int(11) NOT NULL default '-1',
	128	`limit_mailforward` int(11) NOT NULL default '-1',
	129	`limit_mailcatchall` int(11) NOT NULL default '-1',
	130	`limit_mailrouting` int(11) NOT NULL default '0',
	131	`limit_mailfilter` int(11) NOT NULL default '-1',
	132	`limit_fetchmail` int(11) NOT NULL default '-1',
	133	`limit_mailquota` int(11) NOT NULL default '-1',
	134	`limit_spamfilter_wblist` int(11) NOT NULL default '0',
	135	`limit_spamfilter_user` int(11) NOT NULL default '0',
	136	`limit_spamfilter_policy` int(11) NOT NULL default '0',
	137	`limit_web_ip` text,
	138	`limit_web_domain` int(11) NOT NULL default '-1',
	139	`limit_web_subdomain` int(11) NOT NULL default '-1',
	140	`limit_web_aliasdomain` int(11) NOT NULL default '-1',
	141	`limit_ftp_user` int(11) NOT NULL default '-1',
	142	`limit_shell_user` int(11) NOT NULL default '0',
	143	`limit_dns_zone` int(11) NOT NULL default '-1',
	144	`limit_dns_record` int(11) NOT NULL default '-1',
	145	`limit_database` int(11) NOT NULL default '-1',
8c4aa3	146	`limit_cron` int(11) NOT NULL default '0',
T	147	`limit_cron_type` enum('url','chrooted','full') NOT NULL default 'url',
	148	`limit_cron_frequency` int(11) NOT NULL default '5',
24854c	149	`limit_client` int(11) NOT NULL default '0',
T	150	PRIMARY KEY (`template_id`)
	151	) ENGINE=MyISAM AUTO_INCREMENT=1;
8c4aa3	152
T	153
	154	-- --------------------------------------------------------
	155
	156	--
	157	-- Table structure for table `dns_rr`
	158	--
	159	CREATE TABLE `cron` (
	160	`id` int(11) unsigned NOT NULL auto_increment,
	161	`sys_userid` int(11) unsigned NOT NULL default '0',
	162	`sys_groupid` int(11) unsigned NOT NULL default '0',
	163	`sys_perm_user` varchar(5) NULL default NULL,
	164	`sys_perm_group` varchar(5) NULL default NULL,
	165	`sys_perm_other` varchar(5) NULL default NULL,
	166	`server_id` int(11) unsigned NOT NULL default '0',
	167	`parent_domain_id` int(11) unsigned NOT NULL default '0',
	168	`type` enum('url','chrooted','full') NOT NULL default 'url',
	169	`command` varchar(255) NOT NULL,
	170	`run_min` varchar(100) NULL,
	171	`run_hour` varchar(100) NULL,
	172	`run_mday` varchar(100) NULL,
	173	`run_month` varchar(100) NULL,
	174	`run_wday` varchar(100) NULL,
	175	`active` enum('n','y') NOT NULL default 'y',
	176	PRIMARY KEY (`id`)
	177	) ENGINE=MyISAM AUTO_INCREMENT=1;
	178
24854c	179
T	180	-- --------------------------------------------------------
	181
	182	--
	183	-- Table structure for table `dns_rr`
	184	--
	185
	186	CREATE TABLE `dns_rr` (
	187	`id` int(11) unsigned NOT NULL auto_increment,
	188	`sys_userid` int(11) unsigned NOT NULL,
	189	`sys_groupid` int(11) unsigned NOT NULL,
	190	`sys_perm_user` varchar(5) NOT NULL,
	191	`sys_perm_group` varchar(5) NOT NULL,
	192	`sys_perm_other` varchar(5) NOT NULL,
	193	`server_id` int(11) NOT NULL default '1',
	194	`zone` int(11) unsigned NOT NULL,
	195	`name` varchar(64) NOT NULL,
	196	`type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT') default NULL,
	197	`data` varchar(255) NOT NULL,
	198	`aux` int(11) unsigned NOT NULL default '0',
	199	`ttl` int(11) unsigned NOT NULL default '86400',
	200	`active` enum('N','Y') NOT NULL default 'Y',
	201	`stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
	202	`serial` int(10) unsigned default NULL,
	203	PRIMARY KEY (`id`),
	204	UNIQUE KEY `rr` (`zone`,`name`,`type`,`data`)
	205	) ENGINE=MyISAM AUTO_INCREMENT=1;
	206
	207	-- --------------------------------------------------------
	208
	209	--
	210	-- Table structure for table `dns_soa`
	211	--
	212
	213	CREATE TABLE `dns_soa` (
	214	`id` int(10) unsigned NOT NULL auto_increment,
	215	`sys_userid` int(11) unsigned NOT NULL,
	216	`sys_groupid` int(11) unsigned NOT NULL,
	217	`sys_perm_user` varchar(5) NOT NULL,
	218	`sys_perm_group` varchar(5) NOT NULL,
	219	`sys_perm_other` varchar(5) NOT NULL,
	220	`server_id` int(11) NOT NULL default '1',
	221	`origin` varchar(255) NOT NULL,
	222	`ns` varchar(255) NOT NULL,
	223	`mbox` varchar(255) NOT NULL,
	224	`serial` int(11) unsigned NOT NULL default '1',
	225	`refresh` int(11) unsigned NOT NULL default '28800',
	226	`retry` int(11) unsigned NOT NULL default '7200',
	227	`expire` int(11) unsigned NOT NULL default '604800',
	228	`minimum` int(11) unsigned NOT NULL default '86400',
	229	`ttl` int(11) unsigned NOT NULL default '86400',
	230	`active` enum('N','Y') NOT NULL,
	231	`xfer` varchar(255) NOT NULL,
	232	PRIMARY KEY (`id`),
	233	UNIQUE KEY `origin` (`origin`),
	234	KEY `active` (`active`)
	235	) ENGINE=MyISAM AUTO_INCREMENT=1;
	236
	237	-- --------------------------------------------------------
	238
	239	--
	240	-- Table structure for table `dns_template`
	241	--
	242
	243	CREATE TABLE `dns_template` (
	244	`template_id` int(11) unsigned NOT NULL auto_increment,
	245	`sys_userid` int(11) unsigned NOT NULL default '0',
	246	`sys_groupid` int(11) unsigned NOT NULL default '0',
	247	`sys_perm_user` varchar(5) default NULL,
	248	`sys_perm_group` varchar(5) default NULL,
	249	`sys_perm_other` varchar(5) default NULL,
	250	`name` varchar(64) default NULL,
	251	`fields` varchar(255) default NULL,
	252	`template` text,
	253	`visible` enum('N','Y') NOT NULL default 'Y',
	254	PRIMARY KEY (`template_id`)
	255	) ENGINE=MyISAM AUTO_INCREMENT=1;
	256
	257	-- --------------------------------------------------------
	258
	259	--
	260	-- Table structure for table `firewall`
	261	--
	262
	263	CREATE TABLE `firewall` (
	264	`firewall_id` int(11) unsigned NOT NULL auto_increment,
	265	`sys_userid` int(11) unsigned NOT NULL default '0',
	266	`sys_groupid` int(11) unsigned NOT NULL default '0',
	267	`sys_perm_user` varchar(5) default NULL,
	268	`sys_perm_group` varchar(5) default NULL,
	269	`sys_perm_other` varchar(5) default NULL,
	270	`server_id` int(11) unsigned NOT NULL default '0',
	271	`tcp_port` varchar(255) default NULL,
	272	`udp_port` varchar(255) default NULL,
	273	`active` enum('n','y') NOT NULL default 'y',
	274	PRIMARY KEY (`firewall_id`)
	275	) ENGINE=MyISAM AUTO_INCREMENT=1;
	276
	277	-- --------------------------------------------------------
	278
	279	--
	280	-- Table structure for table `ftp_user`
	281	--
	282
	283	CREATE TABLE `ftp_user` (
	284	`ftp_user_id` int(11) unsigned NOT NULL auto_increment,
	285	`sys_userid` int(11) unsigned NOT NULL default '0',
	286	`sys_groupid` int(11) unsigned NOT NULL default '0',
	287	`sys_perm_user` varchar(5) default NULL,
	288	`sys_perm_group` varchar(5) default NULL,
	289	`sys_perm_other` varchar(5) default NULL,
	290	`server_id` int(11) unsigned NOT NULL default '0',
	291	`parent_domain_id` int(11) unsigned NOT NULL default '0',
	292	`username` varchar(64) default NULL,
	293	`password` varchar(64) default NULL,
	294	`quota_size` int(11) NOT NULL default '-1',
	295	`active` enum('n','y') NOT NULL default 'y',
	296	`uid` varchar(64) default NULL,
	297	`gid` varchar(64) default NULL,
	298	`dir` varchar(255) default NULL,
	299	`quota_files` int(11) NOT NULL default '-1',
	300	`ul_ratio` int(11) NOT NULL default '-1',
	301	`dl_ratio` int(11) NOT NULL default '-1',
	302	`ul_bandwidth` int(11) NOT NULL default '-1',
	303	`dl_bandwidth` int(11) NOT NULL default '-1',
	304	PRIMARY KEY (`ftp_user_id`),
	305	KEY `active` (`active`),
	306	KEY `server_id` (`server_id`),
	307	KEY `username` (`username`),
	308	KEY `quota_files` (`quota_files`)
	309	) ENGINE=MyISAM AUTO_INCREMENT=1;
	310
	311	-- --------------------------------------------------------
	312
	313	--
	314	-- Table structure for table `mail_access`
	315	--
	316
	317	CREATE TABLE `mail_access` (
	318	`access_id` int(11) unsigned NOT NULL auto_increment,
	319	`sys_userid` int(11) unsigned NOT NULL default '0',
	320	`sys_groupid` int(11) unsigned NOT NULL default '0',
	321	`sys_perm_user` varchar(5) NOT NULL default '',
	322	`sys_perm_group` varchar(5) NOT NULL default '',
	323	`sys_perm_other` varchar(5) NOT NULL default '',
	324	`server_id` int(11) NOT NULL default '0',
	325	`source` varchar(255) NOT NULL,
	326	`access` varchar(255) NOT NULL,
	327	`type` set('recipient','sender','client') NOT NULL,
	328	`active` enum('n','y') NOT NULL default 'y',
	329	PRIMARY KEY (`access_id`),
	330	KEY `server_id` (`server_id`,`source`)
	331	) ENGINE=MyISAM AUTO_INCREMENT=1;
	332
	333	-- --------------------------------------------------------
	334
	335	--
	336	-- Table structure for table `mail_content_filter`
	337	--
	338
	339	CREATE TABLE `mail_content_filter` (
	340	`content_filter_id` int(11) unsigned NOT NULL auto_increment,
	341	`sys_userid` int(11) unsigned NOT NULL default '0',
	342	`sys_groupid` int(11) unsigned NOT NULL default '0',
	343	`sys_perm_user` varchar(5) default NULL,
	344	`sys_perm_group` varchar(5) default NULL,
	345	`sys_perm_other` varchar(5) default NULL,
	346	`server_id` int(11) NOT NULL default '0',
	347	`type` varchar(255) default NULL,
	348	`pattern` varchar(255) default NULL,
	349	`data` varchar(255) default NULL,
	350	`action` varchar(255) default NULL,
	351	`active` varchar(255) NOT NULL default 'y',
	352	PRIMARY KEY (`content_filter_id`)
	353	) ENGINE=MyISAM AUTO_INCREMENT=1;
	354
	355	-- --------------------------------------------------------
	356
	357	--
	358	-- Table structure for table `mail_domain`
	359	--
	360
	361	CREATE TABLE `mail_domain` (
	362	`domain_id` int(11) unsigned NOT NULL auto_increment,
	363	`sys_userid` int(11) unsigned NOT NULL default '0',
	364	`sys_groupid` int(11) unsigned NOT NULL default '0',
	365	`sys_perm_user` varchar(5) NOT NULL default '',
	366	`sys_perm_group` varchar(5) NOT NULL default '',
	367	`sys_perm_other` varchar(5) NOT NULL default '',
	368	`server_id` int(11) unsigned NOT NULL default '0',
	369	`domain` varchar(255) NOT NULL default '',
	370	`active` enum('n','y') NOT NULL,
	371	PRIMARY KEY (`domain_id`),
	372	KEY `server_id` (`server_id`,`domain`),
	373	KEY `domain_active` (`domain`,`active`)
	374	) ENGINE=MyISAM AUTO_INCREMENT=1;
	375
	376	-- --------------------------------------------------------
	377
	378	--
	379	-- Table structure for table `mail_forwarding`
	380	--
	381
	382	CREATE TABLE `mail_forwarding` (
	383	`forwarding_id` int(11) unsigned NOT NULL auto_increment,
	384	`sys_userid` int(11) unsigned NOT NULL default '0',
	385	`sys_groupid` int(11) unsigned NOT NULL default '0',
	386	`sys_perm_user` varchar(5) NOT NULL default '',
	387	`sys_perm_group` varchar(5) NOT NULL default '',
	388	`sys_perm_other` varchar(5) NOT NULL default '',
	389	`server_id` int(11) unsigned NOT NULL default '0',
	390	`source` varchar(255) NOT NULL,
	391	`destination` varchar(255) NOT NULL default '',
	392	`type` enum('alias','forward','catchall') NOT NULL default 'alias',
	393	`active` enum('n','y') NOT NULL,
	394	PRIMARY KEY (`forwarding_id`),
	395	KEY `server_id` (`server_id`,`source`)
	396	) ENGINE=MyISAM AUTO_INCREMENT=1;
	397
	398	-- --------------------------------------------------------
	399
	400	--
	401	-- Table structure for table `mail_get`
	402	--
	403
	404	CREATE TABLE `mail_get` (
	405	`mailget_id` int(11) unsigned NOT NULL auto_increment,
	406	`sys_userid` int(11) unsigned NOT NULL default '0',
	407	`sys_groupid` int(11) unsigned NOT NULL default '0',
	408	`sys_perm_user` varchar(5) default NULL,
	409	`sys_perm_group` varchar(5) default NULL,
	410	`sys_perm_other` varchar(5) default NULL,
	411	`server_id` int(11) unsigned NOT NULL default '0',
	412	`type` varchar(255) default NULL,
	413	`source_server` varchar(255) default NULL,
	414	`source_username` varchar(255) default NULL,
	415	`source_password` varchar(64) default NULL,
	416	`source_delete` varchar(255) NOT NULL default 'y',
	417	`destination` varchar(255) default NULL,
	418	`active` varchar(255) NOT NULL default 'y',
	419	PRIMARY KEY (`mailget_id`)
	420	) ENGINE=MyISAM AUTO_INCREMENT=1;
	421
	422	-- --------------------------------------------------------
	423
	424	--
	425	-- Table structure for table `mail_greylist`
	426	--
	427
	428	CREATE TABLE `mail_greylist` (
	429	`greylist_id` int(11) unsigned NOT NULL auto_increment,
	430	`relay_ip` varchar(39) default NULL,
	431	`from_domain` varchar(255) default NULL,
	432	`block_expires` datetime NOT NULL default '0000-00-00 00:00:00',
	433	`record_expires` datetime NOT NULL default '0000-00-00 00:00:00',
	434	`origin_type` enum('MANUAL','AUTO') NOT NULL default 'AUTO',
	435	`create_time` datetime NOT NULL default '0000-00-00 00:00:00',
	436	PRIMARY KEY (`greylist_id`)
	437	) ENGINE=MyISAM AUTO_INCREMENT=1;
	438
	439	-- --------------------------------------------------------
	440
	441	--
	442	-- Table structure for table `mail_mailman_domain`
	443	--
	444
	445	CREATE TABLE `mail_mailman_domain` (
	446	`mailman_id` int(11) unsigned NOT NULL auto_increment,
	447	`server_id` int(11) unsigned NOT NULL default '0',
	448	`domain` varchar(255) NOT NULL default '',
	449	`mm_home` varchar(255) NOT NULL default '',
	450	`mm_wrap` varchar(255) NOT NULL default '',
	451	`mm_user` varchar(50) NOT NULL default '',
	452	`mm_group` varchar(50) NOT NULL default '',
	453	PRIMARY KEY (`mailman_id`,`server_id`,`domain`)
	454	) ENGINE=MyISAM AUTO_INCREMENT=1;
	455
	456
	457	-- --------------------------------------------------------
	458
	459	--
	460	-- Table structure for table `mail_traffic`
	461	--
	462
	463	CREATE TABLE `mail_traffic` (
	464	`traffic_id` int(11) unsigned NOT NULL auto_increment,
	465	`mailuser_id` int(11) unsigned NOT NULL,
	466	`month` char(7) NOT NULL,
	467	`traffic` bigint(20) unsigned NOT NULL,
	468	PRIMARY KEY (`traffic_id`),
	469	KEY `mailuser_id` (`mailuser_id`,`month`)
	470	) ENGINE=MyISAM AUTO_INCREMENT=1;
	471
	472	-- --------------------------------------------------------
	473
	474	--
	475	-- Table structure for table `mail_transport`
	476	--
	477
	478	CREATE TABLE `mail_transport` (
	479	`transport_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) unsigned NOT NULL default '0',
	486	`domain` varchar(255) NOT NULL default '',
	487	`transport` varchar(255) NOT NULL,
	488	`sort_order` int(11) unsigned NOT NULL default '5',
	489	`active` enum('n','y') NOT NULL,
	490	PRIMARY KEY (`transport_id`),
	491	KEY `server_id` (`server_id`,`transport`),
	492	KEY `server_id_2` (`server_id`,`domain`)
	493	) ENGINE=MyISAM AUTO_INCREMENT=1;
	494
	495	-- --------------------------------------------------------
	496
	497	--
	498	-- Table structure for table `mail_user`
	499	--
	500
	501	CREATE TABLE `mail_user` (
	502	`mailuser_id` int(11) unsigned NOT NULL auto_increment,
	503	`sys_userid` int(11) unsigned NOT NULL default '0',
	504	`sys_groupid` int(11) unsigned NOT NULL default '0',
	505	`sys_perm_user` varchar(5) NOT NULL default '',
	506	`sys_perm_group` varchar(5) NOT NULL default '',
	507	`sys_perm_other` varchar(5) NOT NULL default '',
	508	`server_id` int(11) unsigned NOT NULL default '0',
	509	`email` varchar(255) NOT NULL default '',
	510	`password` varchar(255) NOT NULL,
	511	`name` varchar(255) NOT NULL default '',
	512	`uid` int(11) unsigned NOT NULL default '5000',
	513	`gid` int(11) unsigned NOT NULL default '5000',
	514	`maildir` varchar(255) NOT NULL default '',
69944a	515	`quota` int(11) NOT NULL default '-1',
24854c	516	`homedir` varchar(255) NOT NULL,
T	517	`autoresponder` enum('n','y') NOT NULL default 'n',
	518	`autoresponder_text` mediumtext NULL,
	519	`custom_mailfilter` mediumtext,
	520	`postfix` enum('n','y') NOT NULL,
	521	`access` enum('n','y') NOT NULL,
	522	`disableimap` enum('0','1') NOT NULL default '0',
	523	`disablepop3` enum('0','1') NOT NULL default '0',
	524	PRIMARY KEY (`mailuser_id`),
	525	KEY `server_id` (`server_id`,`email`),
	526	KEY `email_access` (`email`,`access`)
	527	) ENGINE=MyISAM AUTO_INCREMENT=1;
	528
	529	-- --------------------------------------------------------
	530
	531	--
	532	-- Table structure for table `mail_user_filter`
	533	--
	534
	535	CREATE TABLE `mail_user_filter` (
	536	`filter_id` int(11) unsigned NOT NULL auto_increment,
	537	`sys_userid` int(11) unsigned NOT NULL default '0',
	538	`sys_groupid` int(11) unsigned NOT NULL default '0',
	539	`sys_perm_user` varchar(5) default NULL,
	540	`sys_perm_group` varchar(5) default NULL,
	541	`sys_perm_other` varchar(5) default NULL,
	542	`mailuser_id` int(11) unsigned NOT NULL default '0',
	543	`rulename` varchar(64) default NULL,
	544	`source` varchar(255) default NULL,
	545	`searchterm` varchar(255) default NULL,
	546	`op` varchar(255) default NULL,
	547	`action` varchar(255) default NULL,
	548	`target` varchar(255) default NULL,
	549	`active` enum('n','y') NOT NULL default 'y',
	550	PRIMARY KEY (`filter_id`)
	551	) ENGINE=MyISAM AUTO_INCREMENT=1;
	552
	553	-- --------------------------------------------------------
	554
	555	--
	556	-- Table structure for table `remote_session`
	557	--
	558
	559	CREATE TABLE `remote_session` (
	560	`remote_session` varchar(64) NOT NULL,
	561	`remote_userid` int(11) unsigned NOT NULL,
	562	`remote_functions` text NOT NULL,
	563	`tstamp` int(10) unsigned NOT NULL,
	564	PRIMARY KEY (`remote_session`)
	565	) ENGINE=MyISAM;
	566
	567	-- --------------------------------------------------------
	568
	569	--
	570	-- Table structure for table `remote_user`
	571	--
	572
	573	CREATE TABLE `remote_user` (
	574	`remote_userid` int(11) unsigned NOT NULL auto_increment,
542146	575	`sys_userid` int(11) unsigned NOT NULL default '0',
T	576	`sys_groupid` int(11) unsigned NOT NULL default '0',
	577	`sys_perm_user` varchar(5) default NULL,
	578	`sys_perm_group` varchar(5) default NULL,
	579	`sys_perm_other` varchar(5) default NULL,
24854c	580	`remote_username` varchar(64) NOT NULL,
T	581	`remote_password` varchar(64) NOT NULL,
	582	`remote_functions` text NOT NULL,
	583	PRIMARY KEY (`remote_userid`)
	584	) ENGINE=MyISAM AUTO_INCREMENT=1;
	585
	586	-- --------------------------------------------------------
	587
	588	--
	589	-- Table structure for table `server`
	590	--
	591
	592	CREATE TABLE `server` (
	593	`server_id` int(11) unsigned NOT NULL auto_increment,
	594	`sys_userid` int(11) unsigned NOT NULL default '0',
	595	`sys_groupid` int(11) unsigned NOT NULL default '0',
	596	`sys_perm_user` varchar(5) NOT NULL default '',
	597	`sys_perm_group` varchar(5) NOT NULL default '',
	598	`sys_perm_other` varchar(5) NOT NULL default '',
	599	`server_name` varchar(255) NOT NULL default '',
	600	`mail_server` tinyint(1) NOT NULL default '0',
	601	`web_server` tinyint(1) NOT NULL default '0',
	602	`dns_server` tinyint(1) NOT NULL default '0',
	603	`file_server` tinyint(1) NOT NULL default '0',
	604	`db_server` tinyint(1) NOT NULL default '0',
	605	`vserver_server` tinyint(1) NOT NULL default '0',
	606	`config` text NOT NULL,
	607	`updated` bigint(20) unsigned NOT NULL default '0',
	608	`active` tinyint(1) NOT NULL default '1',
	609	PRIMARY KEY (`server_id`)
	610	) ENGINE=MyISAM AUTO_INCREMENT=1;
	611
	612	-- --------------------------------------------------------
	613
	614	--
	615	-- Table structure for table `server_ip`
	616	--
	617
	618	CREATE TABLE `server_ip` (
	619	`server_ip_id` int(11) unsigned NOT NULL auto_increment,
	620	`sys_userid` int(11) unsigned NOT NULL default '0',
	621	`sys_groupid` int(11) unsigned NOT NULL default '0',
	622	`sys_perm_user` varchar(5) default NULL,
	623	`sys_perm_group` varchar(5) default NULL,
	624	`sys_perm_other` varchar(5) default NULL,
	625	`server_id` int(11) unsigned NOT NULL default '0',
	626	`ip_address` varchar(39) default NULL,
	627	`virtualhost` enum('n','y') NOT NULL default 'y',
	628	PRIMARY KEY (`server_ip_id`)
	629	) ENGINE=MyISAM AUTO_INCREMENT=1;
	630
	631	-- --------------------------------------------------------
	632
	633	CREATE TABLE `shell_user` (
	634	`shell_user_id` int(11) unsigned NOT NULL auto_increment,
	635	`sys_userid` int(11) unsigned NOT NULL default '0',
	636	`sys_groupid` int(11) unsigned NOT NULL default '0',
	637	`sys_perm_user` varchar(5) default NULL,
	638	`sys_perm_group` varchar(5) default NULL,
	639	`sys_perm_other` varchar(5) default NULL,
	640	`server_id` int(11) unsigned NOT NULL default '0',
	641	`parent_domain_id` int(11) unsigned NOT NULL default '0',
	642	`username` varchar(64) default NULL,
	643	`password` varchar(64) default NULL,
	644	`quota_size` int(11) NOT NULL default '-1',
	645	`active` enum('n','y') NOT NULL default 'y',
	646	`puser` varchar(255) default NULL,
	647	`pgroup` varchar(255) default NULL,
	648	`shell` varchar(255) NOT NULL default '/bin/bash',
	649	`dir` varchar(255) default NULL,
	650	`chroot` varchar(255) NOT NULL,
	651	PRIMARY KEY (`shell_user_id`)
	652	) ENGINE=MyISAM AUTO_INCREMENT=1;
	653
	654	-- --------------------------------------------------------
	655
	656	--
	657	-- Table structure for table `software_package`
	658	--
	659
	660	CREATE TABLE `software_package` (
	661	`package_id` int(11) unsigned NOT NULL auto_increment,
	662	`software_repo_id` int(11) unsigned NOT NULL,
	663	`package_name` varchar(64) NOT NULL,
	664	`package_title` varchar(64) NOT NULL,
	665	`package_description` text,
	666	`package_version` varchar(8) default NULL,
	667	PRIMARY KEY (`package_id`),
	668	UNIQUE KEY `package_name` (`package_name`)
	669	) ENGINE=MyISAM AUTO_INCREMENT=1;
	670
	671	-- --------------------------------------------------------
	672
	673	--
	674	-- Table structure for table `software_repo`
	675	--
	676
	677	CREATE TABLE `software_repo` (
	678	`software_repo_id` int(11) unsigned NOT NULL auto_increment,
	679	`sys_userid` int(11) unsigned NOT NULL default '0',
	680	`sys_groupid` int(11) unsigned NOT NULL default '0',
	681	`sys_perm_user` varchar(5) default NULL,
	682	`sys_perm_group` varchar(5) default NULL,
	683	`sys_perm_other` varchar(5) default NULL,
	684	`repo_name` varchar(64) default NULL,
	685	`repo_url` varchar(255) default NULL,
	686	`repo_username` varchar(64) default NULL,
	687	`repo_password` varchar(64) default NULL,
	688	`active` enum('n','y') NOT NULL default 'y',
	689	PRIMARY KEY (`software_repo_id`)
	690	) ENGINE=MyISAM AUTO_INCREMENT=1;
	691
	692	-- --------------------------------------------------------
	693
	694	--
	695	-- Table structure for table `software_update`
	696	--
	697
	698	CREATE TABLE `software_update` (
	699	`software_update_id` int(11) unsigned NOT NULL auto_increment,
	700	`software_repo_id` int(11) unsigned NOT NULL,
	701	`package_name` varchar(64) NOT NULL,
	702	`update_url` varchar(255) NOT NULL,
	703	`update_md5` varchar(255) NOT NULL,
	704	`update_dependencies` varchar(255) NOT NULL,
	705	`update_title` varchar(64) NOT NULL,
	706	`v1` tinyint(1) NOT NULL default '0',
	707	`v2` tinyint(1) NOT NULL default '0',
	708	`v3` tinyint(1) NOT NULL default '0',
	709	`v4` tinyint(1) NOT NULL default '0',
	710	`type` enum('full','update') NOT NULL default 'full',
	711	PRIMARY KEY (`software_update_id`)
	712	) ENGINE=MyISAM AUTO_INCREMENT=1;
	713
	714	-- --------------------------------------------------------
	715
	716	--
	717	-- Table structure for table `software_update_inst`
	718	--
	719
	720	CREATE TABLE `software_update_inst` (
	721	`software_update_inst_id` int(11) unsigned NOT NULL auto_increment,
	722	`software_update_id` int(11) unsigned NOT NULL default '0',
	723	`package_name` varchar(64) NOT NULL,
	724	`server_id` int(11) unsigned NOT NULL,
	725	`status` enum('none','installing','installed','deleting','deleted') NOT NULL default 'none',
	726	PRIMARY KEY (`software_update_inst_id`),
	727	UNIQUE KEY `software_update_id` (`software_update_id`,`package_name`,`server_id`)
	728	) ENGINE=MyISAM AUTO_INCREMENT=1;
	729
	730	-- --------------------------------------------------------
	731
	732	--
	733	-- Table structure for table `spamfilter_policy`
	734	--
	735
	736	CREATE TABLE `spamfilter_policy` (
	737	`id` int(11) unsigned NOT NULL auto_increment,
	738	`sys_userid` int(11) unsigned NOT NULL,
	739	`sys_groupid` int(11) unsigned NOT NULL,
	740	`sys_perm_user` varchar(5) NOT NULL,
	741	`sys_perm_group` varchar(5) NOT NULL,
	742	`sys_perm_other` varchar(5) NOT NULL,
	743	`policy_name` varchar(64) default NULL,
	744	`virus_lover` enum('N','Y') default NULL,
	745	`spam_lover` enum('N','Y') default NULL,
	746	`banned_files_lover` enum('N','Y') default NULL,
	747	`bad_header_lover` enum('N','Y') default NULL,
	748	`bypass_virus_checks` enum('N','Y') default NULL,
	749	`bypass_spam_checks` enum('N','Y') default NULL,
	750	`bypass_banned_checks` enum('N','Y') default NULL,
	751	`bypass_header_checks` enum('N','Y') default NULL,
	752	`spam_modifies_subj` enum('N','Y') default NULL,
	753	`virus_quarantine_to` varchar(255) default NULL,
	754	`spam_quarantine_to` varchar(255) default NULL,
	755	`banned_quarantine_to` varchar(255) default NULL,
	756	`bad_header_quarantine_to` varchar(255) default NULL,
	757	`clean_quarantine_to` varchar(255) default NULL,
	758	`other_quarantine_to` varchar(255) default NULL,
	759	`spam_tag_level` float default NULL,
	760	`spam_tag2_level` float default NULL,
	761	`spam_kill_level` float default NULL,
	762	`spam_dsn_cutoff_level` float default NULL,
	763	`spam_quarantine_cutoff_level` float default NULL,
	764	`addr_extension_virus` varchar(64) default NULL,
	765	`addr_extension_spam` varchar(64) default NULL,
	766	`addr_extension_banned` varchar(64) default NULL,
	767	`addr_extension_bad_header` varchar(64) default NULL,
	768	`warnvirusrecip` enum('N','Y') default NULL,
	769	`warnbannedrecip` enum('N','Y') default NULL,
	770	`warnbadhrecip` enum('N','Y') default NULL,
	771	`newvirus_admin` varchar(64) default NULL,
	772	`virus_admin` varchar(64) default NULL,
	773	`banned_admin` varchar(64) default NULL,
	774	`bad_header_admin` varchar(64) default NULL,
	775	`spam_admin` varchar(64) default NULL,
	776	`spam_subject_tag` varchar(64) default NULL,
	777	`spam_subject_tag2` varchar(64) default NULL,
	778	`message_size_limit` int(11) unsigned default NULL,
	779	`banned_rulenames` varchar(64) default NULL,
	780	PRIMARY KEY (`id`)
	781	) ENGINE=MyISAM AUTO_INCREMENT=1 ;
	782
	783	-- --------------------------------------------------------
	784
	785	--
	786	-- Table structure for table `spamfilter_users`
	787	--
	788
	789	CREATE TABLE `spamfilter_users` (
	790	`id` int(11) unsigned NOT NULL auto_increment,
	791	`sys_userid` int(11) unsigned NOT NULL,
	792	`sys_groupid` int(11) unsigned NOT NULL,
	793	`sys_perm_user` varchar(5) NOT NULL,
	794	`sys_perm_group` varchar(5) NOT NULL,
	795	`sys_perm_other` varchar(5) NOT NULL,
	796	`server_id` int(11) unsigned NOT NULL,
	797	`priority` tinyint(3) unsigned NOT NULL default '7',
	798	`policy_id` int(11) unsigned NOT NULL default '1',
	799	`email` varchar(255) NOT NULL,
	800	`fullname` varchar(64) default NULL,
	801	`local` varchar(1) default NULL,
	802	PRIMARY KEY (`id`),
	803	UNIQUE KEY `email` (`email`)
	804	) ENGINE=MyISAM AUTO_INCREMENT=1;
	805
	806	-- --------------------------------------------------------
	807
	808	--
	809	-- Table structure for table `spamfilter_wblist`
	810	--
	811
	812	CREATE TABLE `spamfilter_wblist` (
	813	`wblist_id` int(11) unsigned NOT NULL auto_increment,
	814	`sys_userid` int(11) unsigned NOT NULL,
	815	`sys_groupid` int(11) unsigned NOT NULL,
	816	`sys_perm_user` varchar(5) NOT NULL,
	817	`sys_perm_group` varchar(5) NOT NULL,
	818	`sys_perm_other` varchar(5) NOT NULL,
	819	`server_id` int(11) unsigned NOT NULL,
	820	`wb` enum('W','B') NOT NULL default 'W',
	821	`rid` int(11) unsigned NOT NULL,
	822	`email` varchar(255) NOT NULL,
	823	`priority` tinyint(3) unsigned NOT NULL,
	824	`active` enum('y','n') NOT NULL default 'y',
	825	PRIMARY KEY (`wblist_id`)
	826	) ENGINE=MyISAM AUTO_INCREMENT=1;
	827
	828	-- --------------------------------------------------------
	829
	830	--
	831	-- Table structure for table `support_message`
	832	--
	833
	834	CREATE TABLE `support_message` (
	835	`support_message_id` int(11) unsigned NOT NULL auto_increment,
	836	`sys_userid` int(11) unsigned NOT NULL default '0',
	837	`sys_groupid` int(11) unsigned NOT NULL default '0',
	838	`sys_perm_user` varchar(5) default NULL,
	839	`sys_perm_group` varchar(5) default NULL,
	840	`sys_perm_other` varchar(5) default NULL,
	841	`recipient_id` int(11) unsigned NOT NULL default '0',
	842	`sender_id` int(11) unsigned NOT NULL default '0',
	843	`subject` varchar(255) default NULL,
	844	`message` text default NULL,
	845	`tstamp` int(11) NOT NULL default '0',
	846	PRIMARY KEY (`support_message_id`)
	847	) ENGINE=MyISAM AUTO_INCREMENT=1;
	848
	849	-- --------------------------------------------------------
	850
	851	--
	852	-- Table structure for table `sys_datalog`
	853	--
	854
	855	CREATE TABLE `sys_datalog` (
	856	`datalog_id` int(11) unsigned NOT NULL auto_increment,
	857	`server_id` int(11) unsigned NOT NULL,
	858	`dbtable` varchar(255) NOT NULL default '',
	859	`dbidx` varchar(255) NOT NULL default '',
	860	`action` char(1) NOT NULL default '',
	861	`tstamp` int(11) NOT NULL default '0',
	862	`user` varchar(255) NOT NULL default '',
	863	`data` text NOT NULL,
	864	`status` set('pending','ok','warning','error') NOT NULL default 'pending',
	865	PRIMARY KEY (`datalog_id`),
	866	KEY `server_id` (`server_id`,`status`)
	867	) ENGINE=MyISAM AUTO_INCREMENT=1;
	868
	869	-- --------------------------------------------------------
	870
	871	--
	872	-- Table structure for table `sys_dbsync`
	873	--
	874
	875	CREATE TABLE `sys_dbsync` (
	876	`id` int(11) unsigned NOT NULL auto_increment,
	877	`jobname` varchar(64) NOT NULL default '',
	878	`sync_interval_minutes` int(11) unsigned NOT NULL default '0',
	879	`db_type` varchar(16) NOT NULL default '',
	880	`db_host` varchar(255) NOT NULL default '',
	881	`db_name` varchar(64) NOT NULL default '',
	882	`db_username` varchar(64) NOT NULL default '',
	883	`db_password` varchar(64) NOT NULL default '',
	884	`db_tables` varchar(255) NOT NULL default 'admin,forms',
	885	`empty_datalog` int(11) unsigned NOT NULL default '0',
	886	`sync_datalog_external` int(11) unsigned NOT NULL default '0',
	887	`active` tinyint(1) NOT NULL default '1',
	888	`last_datalog_id` int(11) unsigned NOT NULL default '0',
	889	PRIMARY KEY (`id`),
	890	KEY `last_datalog_id` (`last_datalog_id`)
	891	) ENGINE=MyISAM AUTO_INCREMENT=1;
	892	-- --------------------------------------------------------
	893
	894	--
	895	-- Table structure for table `sys_filesync`
	896	--
	897
	898	CREATE TABLE `sys_filesync` (
	899	`id` int(11) unsigned NOT NULL auto_increment,
	900	`jobname` varchar(64) NOT NULL default '',
	901	`sync_interval_minutes` int(11) unsigned NOT NULL default '0',
	902	`ftp_host` varchar(255) NOT NULL default '',
	903	`ftp_path` varchar(255) NOT NULL default '',
	904	`ftp_username` varchar(64) NOT NULL default '',
	905	`ftp_password` varchar(64) NOT NULL default '',
	906	`local_path` varchar(255) NOT NULL default '',
	907	`wput_options` varchar(255) NOT NULL default '--timestamping --reupload --dont-continue',
	908	`active` tinyint(1) NOT NULL default '1',
	909	PRIMARY KEY (`id`)
	910	) ENGINE=MyISAM AUTO_INCREMENT=1;
	911
	912	-- --------------------------------------------------------
	913
	914	--
	915	-- Table structure for table `sys_group`
	916	--
	917
	918	CREATE TABLE `sys_group` (
	919	`groupid` int(11) unsigned NOT NULL auto_increment,
	920	`name` varchar(64) NOT NULL default '',
	921	`description` text NOT NULL,
	922	`client_id` int(11) unsigned NOT NULL default '0',
	923	PRIMARY KEY (`groupid`)
	924	) ENGINE=MyISAM AUTO_INCREMENT=1 ;
	925
	926	-- --------------------------------------------------------
	927
	928	--
	929	-- Table structure for table `sys_ini`
	930	--
	931
	932	CREATE TABLE `sys_ini` (
	933	`sysini_id` int(11) unsigned NOT NULL auto_increment,
	934	`config` longtext NOT NULL,
	935	PRIMARY KEY (`sysini_id`)
	936	) ENGINE=MyISAM AUTO_INCREMENT=1;
	937
	938	-- --------------------------------------------------------
	939
	940	--
	941	-- Table structure for table `sys_log`
	942	--
	943
	944	CREATE TABLE `sys_log` (
	945	`syslog_id` int(11) unsigned NOT NULL auto_increment,
	946	`server_id` int(11) unsigned NOT NULL default '0',
	947	`datalog_id` int(11) unsigned NOT NULL default '0',
	948	`loglevel` tinyint(4) NOT NULL default '0',
	949	`tstamp` int(11) unsigned NOT NULL,
	950	`message` text,
	951	PRIMARY KEY (`syslog_id`)
	952	) ENGINE=MyISAM AUTO_INCREMENT=1;
	953
	954
	955	-- --------------------------------------------------------
	956
	957	--
	958	-- Table structure for table `sys_user`
	959	--
	960
	961	CREATE TABLE `sys_user` (
	962	`userid` int(11) unsigned NOT NULL auto_increment,
	963	`sys_userid` int(11) unsigned NOT NULL default '1',
	964	`sys_groupid` int(11) unsigned NOT NULL default '1',
	965	`sys_perm_user` varchar(5) NOT NULL default 'riud',
	966	`sys_perm_group` varchar(5) NOT NULL default 'riud',
	967	`sys_perm_other` varchar(5) NOT NULL default '',
	968	`username` varchar(64) NOT NULL default '',
	969	`passwort` varchar(64) NOT NULL default '',
	970	`modules` varchar(255) NOT NULL default '',
	971	`startmodule` varchar(255) NOT NULL default '',
	972	`app_theme` varchar(32) NOT NULL default 'default',
	973	`typ` varchar(16) NOT NULL default 'user',
	974	`active` tinyint(1) NOT NULL default '1',
	975	`language` varchar(2) NOT NULL default 'de',
	976	`groups` varchar(255) NOT NULL default '',
	977	`default_group` int(11) unsigned NOT NULL default '0',
	978	`client_id` int(11) unsigned NOT NULL default '0',
	979	PRIMARY KEY (`userid`)
	980	) ENGINE=MyISAM AUTO_INCREMENT=1;
	981
	982	-- --------------------------------------------------------
	983
	984	--
	985	-- Table structure for table `web_domain`
	986	--
	987
	988	CREATE TABLE `web_domain` (
	989	`domain_id` int(11) unsigned NOT NULL auto_increment,
	990	`sys_userid` int(11) unsigned NOT NULL default '0',
	991	`sys_groupid` int(11) unsigned NOT NULL default '0',
	992	`sys_perm_user` varchar(5) default NULL,
	993	`sys_perm_group` varchar(5) default NULL,
	994	`sys_perm_other` varchar(5) default NULL,
	995	`server_id` int(11) unsigned NOT NULL default '0',
	996	`ip_address` varchar(39) default NULL,
	997	`domain` varchar(255) default NULL,
	998	`type` varchar(32) default NULL,
	999	`parent_domain_id` int(11) unsigned NOT NULL default '0',
	1000	`vhost_type` varchar(32) default NULL,
	1001	`document_root` varchar(255) default NULL,
	1002	`system_user` varchar(255) default NULL,
	1003	`system_group` varchar(255) default NULL,
	1004	`hd_quota` int(11) NOT NULL default '0',
	1005	`traffic_quota` int(11) NOT NULL default '0',
	1006	`cgi` enum('n','y') NOT NULL default 'y',
	1007	`ssi` enum('n','y') NOT NULL default 'y',
	1008	`suexec` enum('n','y') NOT NULL default 'y',
	1009	`errordocs` tinyint(1) NOT NULL default '1',
	1010	`is_subdomainwww` tinyint(1) NOT NULL default '1',
	1011	`subdomain` enum('none','www','*') NOT NULL default 'none',
	1012	`php` varchar(32) NOT NULL default 'y',
	1013	`redirect_type` varchar(255) default NULL,
	1014	`redirect_path` varchar(255) default NULL,
	1015	`ssl` enum('n','y') NOT NULL default 'n',
	1016	`ssl_state` varchar(255) NULL,
	1017	`ssl_locality` varchar(255) NULL,
	1018	`ssl_organisation` varchar(255) NULL,
	1019	`ssl_organisation_unit` varchar(255) NULL,
	1020	`ssl_country` varchar(255) NULL,
	1021	`ssl_request` mediumtext NULL,
	1022	`ssl_cert` mediumtext NULL,
	1023	`ssl_bundle` mediumtext NULL,
	1024	`ssl_action` varchar(16) NULL,
	1025	`stats_password` varchar(255) default NULL,
	1026	`apache_directives` text,
	1027	`active` enum('n','y') NOT NULL default 'y',
	1028	PRIMARY KEY (`domain_id`)
	1029	) ENGINE=MyISAM AUTO_INCREMENT=1;
	1030
	1031	-- --------------------------------------------------------
	1032
	1033	--
	1034	-- Table structure for table `web_database`
	1035	--
	1036
	1037	CREATE TABLE `web_database` (
	1038	`database_id` int(11) unsigned NOT NULL auto_increment,
	1039	`sys_userid` int(11) unsigned NOT NULL default '0',
	1040	`sys_groupid` int(11) unsigned NOT NULL default '0',
	1041	`sys_perm_user` varchar(5) default NULL,
	1042	`sys_perm_group` varchar(5) default NULL,
	1043	`sys_perm_other` varchar(5) default NULL,
	1044	`server_id` int(11) unsigned NOT NULL default '0',
	1045	`type` varchar(16) NOT NULL default 'y',
	1046	`database_name` varchar(64) default NULL,
	1047	`database_user` varchar(64) default NULL,
	1048	`database_password` varchar(64) default NULL,
	1049	`database_charset` varchar(64) default NULL,
	1050	`remote_access` enum('n','y') NOT NULL default 'y',
8c4aa3	1051	`remote_ips` text NOT NULL,
24854c	1052	`active` enum('n','y') NOT NULL default 'y',
T	1053	PRIMARY KEY (`database_id`)
	1054	) ENGINE=MyISAM AUTO_INCREMENT=1;
8c4aa3	1055
T	1056
	1057	-- --------------------------------------------------------
	1058
	1059	--
	1060	-- Table structure for table `web_traffic`
	1061	--
	1062
	1063	CREATE TABLE `web_traffic` (
	1064	`hostname` varchar(255) NOT NULL,
	1065	`traffic_date` date NOT NULL,
	1066	`traffic_bytes` bigint(32) unsigned NOT NULL default '0',
	1067	PRIMARY KEY (`hostname`,`traffic_date`)
	1068	) ENGINE=MyISAM;
24854c	1069
T	1070
	1071	-- --------------------------------------------------------
	1072
	1073	--
	1074	-- Table structure for table `attempts_login`
	1075	--
	1076
	1077	CREATE TABLE `attempts_login` (
	1078	`ip` varchar(39) NOT NULL,
	1079	`times` int(11) default NULL,
	1080	`login_time` timestamp
	1081	) ENGINE=MyISAM;
	1082
	1083	-- --------------------------------------------------------
	1084
	1085	--
	1086	-- Table structure for table `monitor_data`
	1087	--
	1088
	1089	CREATE TABLE `monitor_data` (
	1090	`server_id` int(11) unsigned NOT NULL,
	1091	`type` varchar(255) NOT NULL,
	1092	`created` int(11) unsigned NOT NULL,
	1093	`data` mediumtext NOT NULL,
	1094	`state` enum('no_state', 'unknown', 'ok', 'info', 'warning', 'critical', 'error') NOT NULL default 'unknown',
	1095	PRIMARY KEY (`server_id`,`type`,`created`)
	1096	) ENGINE=MyISAM;
	1097
	1098	-- --------------------------------------------------------
	1099
	1100	--
	1101	-- Table structure for table `sys_config`
	1102	--
	1103
	1104	CREATE TABLE `sys_config` (
	1105	`config_id` int(11) unsigned NOT NULL,
	1106	`group` varchar(64) NOT NULL,
	1107	`name` varchar(64) NOT NULL,
	1108	`value` varchar(255) NOT NULL
	1109	) ENGINE=MyISAM;
	1110
	1111	-- --------------------------------------------------------
	1112
	1113	--
	1114	-- iso_country_list.sql
	1115	--
	1116	-- This will create and then populate a MySQL table with a list of the names and
	1117	-- ISO 3166 codes for countries in existence as of the date below.
	1118	--
	1119	-- For updates to this file, see http://27.org/isocountrylist/
	1120	-- For more about ISO 3166, see http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html
	1121	--
	1122	-- Created by getisocountrylist.pl on Sun Nov 2 14:59:20 2003.
	1123	-- Wm. Rhodes <iso_country_list@27.org>
	1124	--
	1125
	1126	--
	1127	-- Table structure for table `country`
	1128	--
	1129
	1130	CREATE TABLE `country` (
	1131	`iso` char(2) NOT NULL PRIMARY KEY,
	1132	`name` varchar(64) NOT NULL,
	1133	`printable_name` varchar(64) NOT NULL,
	1134	`iso3` char(3),
	1135	`numcode` SMALLINT
	1136	) ENGINE=MyISAM;
	1137
	1138
	1139
	1140	-- --------------------------------------------------------
	1141	-- --------------------------------------------------------
	1142	-- DB-DATA
	1143	-- --------------------------------------------------------
	1144	-- --------------------------------------------------------
	1145
	1146	--
	1147	-- Dumping data for table `dns_template`
	1148	--
	1149
	1150	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=28800\nretry=7200\nexpire=604800\nminimum=86400\nttl=86400\n\n[DNS_RECORDS]\nA\|{DOMAIN}.\|{IP}\|0\|86400\nA\|www\|{IP}\|0\|86400\nA\|mail\|{IP}\|0\|86400\nNS\|{DOMAIN}.\|{NS1}.\|0\|86400\nNS\|{DOMAIN}.\|{NS2}.\|0\|86400\nMX\|{DOMAIN}.\|mail.{DOMAIN}.\|10\|86400', 'y');
	1151
	1152	-- --------------------------------------------------------
	1153
	1154	--
	1155	-- Dumping data for table `software_repo`
	1156	--
	1157
	1158	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');
	1159
	1160	-- --------------------------------------------------------
	1161
	1162	--
	1163	-- Dumping data for table `spamfilter_policy`
	1164	--
	1165
	1166	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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	1167	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);
	1168	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);
	1169	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);
	1170	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', 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);
	1171	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);
	1172	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);
	1173
	1174	-- --------------------------------------------------------
	1175
	1176	--
	1177	-- Dumping data for table `sys_group`
	1178	--
	1179
	1180	INSERT INTO `sys_group` (`groupid`, `name`, `description`, `client_id`) VALUES (1, 'admin', 'Administrators group', 0);
	1181
	1182	-- --------------------------------------------------------
	1183
	1184	--
	1185	-- Dumping data for table `sys_ini`
	1186	--
	1187
	1188	INSERT INTO `sys_ini` (`sysini_id`, `config`) VALUES (1, '');
	1189
	1190	-- --------------------------------------------------------
	1191
	1192	--
	1193	-- Dumping data for table `sys_user`
	1194	--
	1195
	1196	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', 'admin,client,mail,monitor,sites,dns,tools,help', 'mail', 'default', 'admin', 1, 'en', '1,2', 1, 0);
	1197
	1198	-- --------------------------------------------------------
	1199
	1200	--
	1201	-- Dumping data for table `sys_config`
	1202	--
	1203
8c4aa3	1204	INSERT INTO sys_config VALUES ('1','db','db_version','3.0.1.4');
24854c	1205
T	1206	-- --------------------------------------------------------
	1207
	1208	--
	1209	-- iso_country_list.sql
	1210	--
	1211	-- This will create and then populate a MySQL table with a list of the names and
	1212	-- ISO 3166 codes for countries in existence as of the date below.
	1213	--
	1214	-- For updates to this file, see http://27.org/isocountrylist/
	1215	-- For more about ISO 3166, see http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html
	1216	--
	1217	-- Created by getisocountrylist.pl on Sun Nov 2 14:59:20 2003.
	1218	-- Wm. Rhodes <iso_country_list@27.org>
	1219	--
	1220
	1221	--
	1222	-- Dumping data for table `country`
	1223	--
	1224
	1225	INSERT INTO `country` (`iso`, `name`, `printable_name`, `iso3`, `numcode`) VALUES
	1226	('AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4),
	1227	('AL', 'ALBANIA', 'Albania', 'ALB', 8),
	1228	('DZ', 'ALGERIA', 'Algeria', 'DZA', 12),
	1229	('AS', 'AMERICAN SAMOA', 'American Samoa', 'ASM', 16),
	1230	('AD', 'ANDORRA', 'Andorra', 'AND', 20),
	1231	('AO', 'ANGOLA', 'Angola', 'AGO', 24),
	1232	('AI', 'ANGUILLA', 'Anguilla', 'AIA', 660),
	1233	('AQ', 'ANTARCTICA', 'Antarctica', NULL, NULL),
	1234	('AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'ATG', 28),
	1235	('AR', 'ARGENTINA', 'Argentina', 'ARG', 32),
	1236	('AM', 'ARMENIA', 'Armenia', 'ARM', 51),
	1237	('AW', 'ARUBA', 'Aruba', 'ABW', 533),
	1238	('AU', 'AUSTRALIA', 'Australia', 'AUS', 36),
	1239	('AT', 'AUSTRIA', 'Austria', 'AUT', 40),
	1240	('AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', 31),
	1241	('BS', 'BAHAMAS', 'Bahamas', 'BHS', 44),
	1242	('BH', 'BAHRAIN', 'Bahrain', 'BHR', 48),
	1243	('BD', 'BANGLADESH', 'Bangladesh', 'BGD', 50),
	1244	('BB', 'BARBADOS', 'Barbados', 'BRB', 52),
	1245	('BY', 'BELARUS', 'Belarus', 'BLR', 112),
	1246	('BE', 'BELGIUM', 'Belgium', 'BEL', 56),
	1247	('BZ', 'BELIZE', 'Belize', 'BLZ', 84),
	1248	('BJ', 'BENIN', 'Benin', 'BEN', 204),
	1249	('BM', 'BERMUDA', 'Bermuda', 'BMU', 60),
	1250	('BT', 'BHUTAN', 'Bhutan', 'BTN', 64),
	1251	('BO', 'BOLIVIA', 'Bolivia', 'BOL', 68),
	1252	('BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'BIH', 70),
	1253	('BW', 'BOTSWANA', 'Botswana', 'BWA', 72),
	1254	('BV', 'BOUVET ISLAND', 'Bouvet Island', NULL, NULL),
	1255	('BR', 'BRAZIL', 'Brazil', 'BRA', 76),
	1256	('IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', NULL, NULL),
	1257	('BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', 96),
	1258	('BG', 'BULGARIA', 'Bulgaria', 'BGR', 100),
	1259	('BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', 854),
	1260	('BI', 'BURUNDI', 'Burundi', 'BDI', 108),
	1261	('KH', 'CAMBODIA', 'Cambodia', 'KHM', 116),
	1262	('CM', 'CAMEROON', 'Cameroon', 'CMR', 120),
	1263	('CA', 'CANADA', 'Canada', 'CAN', 124),
	1264	('CV', 'CAPE VERDE', 'Cape Verde', 'CPV', 132),
	1265	('KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', 136),
	1266	('CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', 140),
	1267	('TD', 'CHAD', 'Chad', 'TCD', 148),
	1268	('CL', 'CHILE', 'Chile', 'CHL', 152),
	1269	('CN', 'CHINA', 'China', 'CHN', 156),
	1270	('CX', 'CHRISTMAS ISLAND', 'Christmas Island', NULL, NULL),
	1271	('CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', NULL, NULL),
	1272	('CO', 'COLOMBIA', 'Colombia', 'COL', 170),
	1273	('KM', 'COMOROS', 'Comoros', 'COM', 174),
	1274	('CG', 'CONGO', 'Congo', 'COG', 178),
	1275	('CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, the Democratic Republic of the', 'COD', 180),
	1276	('CK', 'COOK ISLANDS', 'Cook Islands', 'COK', 184),
	1277	('CR', 'COSTA RICA', 'Costa Rica', 'CRI', 188),
	1278	('CI', 'COTE D''IVOIRE', 'Cote D''Ivoire', 'CIV', 384),
	1279	('HR', 'CROATIA', 'Croatia', 'HRV', 191),
	1280	('CU', 'CUBA', 'Cuba', 'CUB', 192),
	1281	('CY', 'CYPRUS', 'Cyprus', 'CYP', 196),
	1282	('CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', 203),
	1283	('DK', 'DENMARK', 'Denmark', 'DNK', 208),
	1284	('DJ', 'DJIBOUTI', 'Djibouti', 'DJI', 262),
	1285	('DM', 'DOMINICA', 'Dominica', 'DMA', 212),
	1286	('DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', 214),
	1287	('EC', 'ECUADOR', 'Ecuador', 'ECU', 218),
	1288	('EG', 'EGYPT', 'Egypt', 'EGY', 818),
	1289	('SV', 'EL SALVADOR', 'El Salvador', 'SLV', 222),
	1290	('GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', 226),
	1291	('ER', 'ERITREA', 'Eritrea', 'ERI', 232),
	1292	('EE', 'ESTONIA', 'Estonia', 'EST', 233),
	1293	('ET', 'ETHIOPIA', 'Ethiopia', 'ETH', 231),
	1294	('FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'FLK', 238),
	1295	('FO', 'FAROE ISLANDS', 'Faroe Islands', 'FRO', 234),
	1296	('FJ', 'FIJI', 'Fiji', 'FJI', 242),
	1297	('FI', 'FINLAND', 'Finland', 'FIN', 246),
	1298	('FR', 'FRANCE', 'France', 'FRA', 250),
	1299	('GF', 'FRENCH GUIANA', 'French Guiana', 'GUF', 254),
	1300	('PF', 'FRENCH POLYNESIA', 'French Polynesia', 'PYF', 258),
	1301	('TF', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', NULL, NULL),
	1302	('GA', 'GABON', 'Gabon', 'GAB', 266),
	1303	('GM', 'GAMBIA', 'Gambia', 'GMB', 270),
	1304	('GE', 'GEORGIA', 'Georgia', 'GEO', 268),
	1305	('DE', 'GERMANY', 'Germany', 'DEU', 276),
	1306	('GH', 'GHANA', 'Ghana', 'GHA', 288),
	1307	('GI', 'GIBRALTAR', 'Gibraltar', 'GIB', 292),
	1308	('GR', 'GREECE', 'Greece', 'GRC', 300),
	1309	('GL', 'GREENLAND', 'Greenland', 'GRL', 304),
	1310	('GD', 'GRENADA', 'Grenada', 'GRD', 308),
	1311	('GP', 'GUADELOUPE', 'Guadeloupe', 'GLP', 312),
	1312	('GU', 'GUAM', 'Guam', 'GUM', 316),
	1313	('GT', 'GUATEMALA', 'Guatemala', 'GTM', 320),
	1314	('GN', 'GUINEA', 'Guinea', 'GIN', 324),
	1315	('GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', 624),
	1316	('GY', 'GUYANA', 'Guyana', 'GUY', 328),
	1317	('HT', 'HAITI', 'Haiti', 'HTI', 332),
	1318	('HM', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Island and Mcdonald Islands', NULL, NULL),
	1319	('VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'VAT', 336),
	1320	('HN', 'HONDURAS', 'Honduras', 'HND', 340),
	1321	('HK', 'HONG KONG', 'Hong Kong', 'HKG', 344),
	1322	('HU', 'HUNGARY', 'Hungary', 'HUN', 348),
	1323	('IS', 'ICELAND', 'Iceland', 'ISL', 352),
	1324	('IN', 'INDIA', 'India', 'IND', 356),
	1325	('ID', 'INDONESIA', 'Indonesia', 'IDN', 360),
	1326	('IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'IRN', 364),
	1327	('IQ', 'IRAQ', 'Iraq', 'IRQ', 368),
	1328	('IE', 'IRELAND', 'Ireland', 'IRL', 372),
	1329	('IL', 'ISRAEL', 'Israel', 'ISR', 376),
	1330	('IT', 'ITALY', 'Italy', 'ITA', 380),
	1331	('JM', 'JAMAICA', 'Jamaica', 'JAM', 388),
	1332	('JP', 'JAPAN', 'Japan', 'JPN', 392),
	1333	('JO', 'JORDAN', 'Jordan', 'JOR', 400),
	1334	('KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', 398),
	1335	('KE', 'KENYA', 'Kenya', 'KEN', 404),
	1336	('KI', 'KIRIBATI', 'Kiribati', 'KIR', 296),
	1337	('KP', 'KOREA, DEMOCRATIC PEOPLE''S REPUBLIC OF', 'Korea, Democratic People''s Republic of', 'PRK', 408),
	1338	('KR', 'KOREA, REPUBLIC OF', 'Korea, Republic of', 'KOR', 410),
	1339	('KW', 'KUWAIT', 'Kuwait', 'KWT', 414),
	1340	('KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', 417),
	1341	('LA', 'LAO PEOPLE''S DEMOCRATIC REPUBLIC', 'Lao People''s Democratic Republic', 'LAO', 418),
	1342	('LV', 'LATVIA', 'Latvia', 'LVA', 428),
	1343	('LB', 'LEBANON', 'Lebanon', 'LBN', 422),
	1344	('LS', 'LESOTHO', 'Lesotho', 'LSO', 426),
	1345	('LR', 'LIBERIA', 'Liberia', 'LBR', 430),
	1346	('LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', 434),
	1347	('LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', 438),
	1348	('LT', 'LITHUANIA', 'Lithuania', 'LTU', 440),
	1349	('LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', 442),
	1350	('MO', 'MACAO', 'Macao', 'MAC', 446),
	1351	('MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia, the Former Yugoslav Republic of', 'MKD', 807),
	1352	('MG', 'MADAGASCAR', 'Madagascar', 'MDG', 450),
	1353	('MW', 'MALAWI', 'Malawi', 'MWI', 454),
	1354	('MY', 'MALAYSIA', 'Malaysia', 'MYS', 458),
	1355	('MV', 'MALDIVES', 'Maldives', 'MDV', 462),
	1356	('ML', 'MALI', 'Mali', 'MLI', 466),
	1357	('MT', 'MALTA', 'Malta', 'MLT', 470),
	1358	('MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'MHL', 584),
	1359	('MQ', 'MARTINIQUE', 'Martinique', 'MTQ', 474),
	1360	('MR', 'MAURITANIA', 'Mauritania', 'MRT', 478),
	1361	('MU', 'MAURITIUS', 'Mauritius', 'MUS', 480),
	1362	('YT', 'MAYOTTE', 'Mayotte', NULL, NULL),
	1363	('MX', 'MEXICO', 'Mexico', 'MEX', 484),
	1364	('FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia, Federated States of', 'FSM', 583),
	1365	('MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'MDA', 498),
	1366	('MC', 'MONACO', 'Monaco', 'MCO', 492),
	1367	('MN', 'MONGOLIA', 'Mongolia', 'MNG', 496),
	1368	('MS', 'MONTSERRAT', 'Montserrat', 'MSR', 500),
	1369	('MA', 'MOROCCO', 'Morocco', 'MAR', 504),
	1370	('MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', 508),
	1371	('MM', 'MYANMAR', 'Myanmar', 'MMR', 104),
	1372	('NA', 'NAMIBIA', 'Namibia', 'NAM', 516),
	1373	('NR', 'NAURU', 'Nauru', 'NRU', 520),
	1374	('NP', 'NEPAL', 'Nepal', 'NPL', 524),
	1375	('NL', 'NETHERLANDS', 'Netherlands', 'NLD', 528),
	1376	('AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'ANT', 530),
	1377	('NC', 'NEW CALEDONIA', 'New Caledonia', 'NCL', 540),
	1378	('NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554),
	1379	('NI', 'NICARAGUA', 'Nicaragua', 'NIC', 558),
	1380	('NE', 'NIGER', 'Niger', 'NER', 562),
	1381	('NG', 'NIGERIA', 'Nigeria', 'NGA', 566),
	1382	('NU', 'NIUE', 'Niue', 'NIU', 570),
	1383	('NF', 'NORFOLK ISLAND', 'Norfolk Island', 'NFK', 574),
	1384	('MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'MNP', 580),
	1385	('NO', 'NORWAY', 'Norway', 'NOR', 578),
	1386	('OM', 'OMAN', 'Oman', 'OMN', 512),
	1387	('PK', 'PAKISTAN', 'Pakistan', 'PAK', 586),
	1388	('PW', 'PALAU', 'Palau', 'PLW', 585),
	1389	('PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian Territory, Occupied', NULL, NULL),
	1390	('PA', 'PANAMA', 'Panama', 'PAN', 591),
	1391	('PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', 598),
	1392	('PY', 'PARAGUAY', 'Paraguay', 'PRY', 600),
	1393	('PE', 'PERU', 'Peru', 'PER', 604),
	1394	('PH', 'PHILIPPINES', 'Philippines', 'PHL', 608),
	1395	('PN', 'PITCAIRN', 'Pitcairn', 'PCN', 612),
	1396	('PL', 'POLAND', 'Poland', 'POL', 616),
	1397	('PT', 'PORTUGAL', 'Portugal', 'PRT', 620),
	1398	('PR', 'PUERTO RICO', 'Puerto Rico', 'PRI', 630),
	1399	('QA', 'QATAR', 'Qatar', 'QAT', 634),
	1400	('RE', 'REUNION', 'Reunion', 'REU', 638),
	1401	('RO', 'ROMANIA', 'Romania', 'ROM', 642),
	1402	('RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', 643),
	1403	('RW', 'RWANDA', 'Rwanda', 'RWA', 646),
	1404	('SH', 'SAINT HELENA', 'Saint Helena', 'SHN', 654),
	1405	('KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'KNA', 659),
	1406	('LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', 662),
	1407	('PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'SPM', 666),
	1408	('VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'VCT', 670),
	1409	('WS', 'SAMOA', 'Samoa', 'WSM', 882),
	1410	('SM', 'SAN MARINO', 'San Marino', 'SMR', 674),
	1411	('ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'STP', 678),
	1412	('SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', 682),
	1413	('SN', 'SENEGAL', 'Senegal', 'SEN', 686),
	1414	('CS', 'SERBIA AND MONTENEGRO', 'Serbia and Montenegro', NULL, NULL),
	1415	('SC', 'SEYCHELLES', 'Seychelles', 'SYC', 690),
	1416	('SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', 694),
	1417	('SG', 'SINGAPORE', 'Singapore', 'SGP', 702),
	1418	('SK', 'SLOVAKIA', 'Slovakia', 'SVK', 703),
	1419	('SI', 'SLOVENIA', 'Slovenia', 'SVN', 705),
	1420	('SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', 90),
	1421	('SO', 'SOMALIA', 'Somalia', 'SOM', 706),
	1422	('ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710),
	1423	('GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia and the South Sandwich Islands', NULL, NULL),
	1424	('ES', 'SPAIN', 'Spain', 'ESP', 724),
	1425	('LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144),
	1426	('SD', 'SUDAN', 'Sudan', 'SDN', 736),
	1427	('SR', 'SURINAME', 'Suriname', 'SUR', 740),
	1428	('SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'SJM', 744),
	1429	('SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748),
	1430	('SE', 'SWEDEN', 'Sweden', 'SWE', 752),
	1431	('CH', 'SWITZERLAND', 'Switzerland', 'CHE', 756),
	1432	('SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', 760),
	1433	('TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'TWN', 158),
	1434	('TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', 762),
	1435	('TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'TZA', 834),
	1436	('TH', 'THAILAND', 'Thailand', 'THA', 764),
	1437	('TL', 'TIMOR-LESTE', 'Timor-Leste', NULL, NULL),
	1438	('TG', 'TOGO', 'Togo', 'TGO', 768),
	1439	('TK', 'TOKELAU', 'Tokelau', 'TKL', 772),
	1440	('TO', 'TONGA', 'Tonga', 'TON', 776),
	1441	('TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'TTO', 780),
	1442	('TN', 'TUNISIA', 'Tunisia', 'TUN', 788),
	1443	('TR', 'TURKEY', 'Turkey', 'TUR', 792),
	1444	('TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', 795),
	1445	('TC', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'TCA', 796),
	1446	('TV', 'TUVALU', 'Tuvalu', 'TUV', 798),
	1447	('UG', 'UGANDA', 'Uganda', 'UGA', 800),
	1448	('UA', 'UKRAINE', 'Ukraine', 'UKR', 804),
	1449	('AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', 784),
	1450	('GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826),
	1451	('US', 'UNITED STATES', 'United States', 'USA', 840),
	1452	('UM', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', NULL, NULL),
	1453	('UY', 'URUGUAY', 'Uruguay', 'URY', 858),
	1454	('UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', 860),
	1455	('VU', 'VANUATU', 'Vanuatu', 'VUT', 548),
	1456	('VE', 'VENEZUELA', 'Venezuela', 'VEN', 862),
	1457	('VN', 'VIET NAM', 'Viet Nam', 'VNM', 704),
	1458	('VG', 'VIRGIN ISLANDS, BRITISH', 'Virgin Islands, British', 'VGB', 92),
	1459	('VI', 'VIRGIN ISLANDS, U.S.', 'Virgin Islands, U.s.', 'VIR', 850),
	1460	('WF', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'WLF', 876),
	1461	('EH', 'WESTERN SAHARA', 'Western Sahara', 'ESH', 732),
	1462	('YE', 'YEMEN', 'Yemen', 'YEM', 887),
	1463	('ZM', 'ZAMBIA', 'Zambia', 'ZMB', 894),
	1464	('ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', 716);
	1465
	1466	-- --------------------------------------------------------
	1467	-- --------------------------------------------------------
	1468
	1469	SET FOREIGN_KEY_CHECKS = 1;