Development

Navigation

← Previous Changeset
Next Changeset →

Changeset 397

Timestamp:

03/06/07 00:49:54 (2 years ago)

Author:

malte

Message:

fixed #100

Files:

trunk/configs/database/database.sql (modified) (1 diff)
trunk/configs/dists/fedora/database/database.sql (modified) (2 diffs)
trunk/configs/dists/gentoo/database/database.sql (modified) (2 diffs)
trunk/configs/dists/openbsd/database/database.sql (modified) (2 diffs)
trunk/configs/dists/sles9/database/database.sql (modified) (15 diffs)
trunk/configs/dists/suse100/database/database.sql (modified) (15 diffs)
trunk/configs/dists/suse93/database/database.sql (modified) (15 diffs)

Legend:

: Unmodified
: Added
: Removed
: Modified
: Copied
: Moved

trunk/configs/database/database.sql

r377	r397
270	270	`props` text,
271	271	`description` varchar(255) default NULL,
272		`price` decimal(4,2) NOT NULL default '0.00',
273		`setup_fee` decimal(4,2) NOT NULL default '0.00',
	272	`price` decimal(10,2) NOT NULL default '0.00',
	273	`setup_fee` decimal(10,2) NOT NULL default '0.00',
274	274	`value` varchar(255) default NULL,
275	275	`payment` varchar(255) default NULL,

trunk/configs/dists/fedora/database/database.sql

r327	r397
75	75	'PORT_TELNET', '23;tcp;TELNET;1;0'
76	76	),(
77		'PORT_SMTP', '25;tcp;SMPT;1;0'
	77	'PORT_SMTP', '25;tcp;SMTP;1;0'
78	78	),(
79	79	'PORT_DNS', '53;tcp;DNS;1;0'
…	…
270	270	`props` text,
271	271	`description` varchar(255) default NULL,
272		`price` decimal(4,2) NOT NULL default '0.00',
273		`setup_fee` decimal(4,2) NOT NULL default '0.00',
	272	`price` decimal(10,2) NOT NULL default '0.00',
	273	`setup_fee` decimal(10,2) NOT NULL default '0.00',
274	274	`value` varchar(255) default NULL,
275	275	`payment` varchar(255) default NULL,

trunk/configs/dists/gentoo/database/database.sql

r327	r397
75	75	'PORT_TELNET', '23;tcp;TELNET;1;0'
76	76	),(
77		'PORT_SMTP', '25;tcp;SMPT;1;0'
	77	'PORT_SMTP', '25;tcp;SMTP;1;0'
78	78	),(
79	79	'PORT_DNS', '53;tcp;DNS;1;0'
…	…
270	270	`props` text,
271	271	`description` varchar(255) default NULL,
272		`price` decimal(4,2) NOT NULL default '0.00',
273		`setup_fee` decimal(4,2) NOT NULL default '0.00',
	272	`price` decimal(10,2) NOT NULL default '0.00',
	273	`setup_fee` decimal(10,2) NOT NULL default '0.00',
274	274	`value` varchar(255) default NULL,
275	275	`payment` varchar(255) default NULL,

trunk/configs/dists/openbsd/database/database.sql

r341	r397
75	75	'PORT_TELNET', '23;tcp;TELNET;1;0'
76	76	),(
77		'PORT_SMTP', '25;tcp;SMPT;1;0'
	77	'PORT_SMTP', '25;tcp;SMTP;1;0'
78	78	),(
79	79	'PORT_DNS', '53;tcp;DNS;1;0'
…	…
270	270	`props` text,
271	271	`description` varchar(255) default NULL,
272		`price` decimal(4,2) NOT NULL default '0.00',
273		`setup_fee` decimal(4,2) NOT NULL default '0.00',
	272	`price` decimal(10,2) NOT NULL default '0.00',
	273	`setup_fee` decimal(10,2) NOT NULL default '0.00',
274	274	`value` varchar(255) default NULL,
275	275	`payment` varchar(255) default NULL,

trunk/configs/dists/sles9/database/database.sql

r154	r397
3	3	use {DATABASE_NAME};
4	4
5		# VHCS(tm) - Virtual Hosting Control System
6		# (c) 2001-2006 moleSoftware
7		# http://vhcs.net \| http://www.molesoftware.com
8		# All rights reserved
9		#
10		# Datenbank: `vhcs_pro_dev`
11		# --------------------------------------------------------
12		#
13		~~# Tabellenstruktur f�~~elle `admin`
14		#
	5	--
	6	-- VHCS ω (OMEGA) - Virtual Hosting Control System \| Omega Version
	7	-- Copyright (c) 2001-2006 by moleSoftware GmbH
	8	-- Copyright (c) 2006-2007 by ispCP \| http://isp-control.net
	9	--
	10	-- --------------------------------------------------------
	11
	12	--
	13	-- Tabellenstruktur für Tabelle `admin`
	14	--
15	15
16	16	CREATE TABLE `admin` (
…	…
34	34	`street2` varchar(200) default NULL,
35	35	`uniqkey` varchar(255) default NULL,
36		`uniqkey_time` ~~TIMESTAMP~~ NULL,
	36	`uniqkey_time` timestamp NULL default NULL,
37	37	UNIQUE KEY `admin_id` (`admin_id`),
38	38	UNIQUE KEY `admin_name` (`admin_name`)
39		) ENGINE=MyISAM AUTO_INCREMENT=1 ;
40
41		#
42		# Daten f�elle `admin`
43		#
44
45
46		# --------------------------------------------------------
	39	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	40
	41	-- --------------------------------------------------------
	42
	43	--
	44	-- Tabellenstruktur für Tabelle `auto_num`
	45	--
	46
	47	CREATE TABLE `auto_num` (
	48	`id` int(10) unsigned NOT NULL auto_increment,
	49	`msg` varchar(255) default NULL,
	50	UNIQUE KEY `id` (`id`)
	51	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	52
	53	-- --------------------------------------------------------
	54
	55	--
	56	-- Tabellenstruktur für Tabelle `config`
	57	--
	58
	59	CREATE TABLE `config` (
	60	`name` varchar(255) NOT NULL default '',
	61	`value` varchar(255) NOT NULL default '',
	62	PRIMARY KEY (`name`)
	63	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
	64
	65	--
	66	-- Daten für Tabelle `auto_num`
	67	--
	68
	69	INSERT INTO `config` ( `name` , `value` )
	70	VALUES (
	71	'PORT_FTP', '21;tcp;FTP;1;0'
	72	), (
	73	'PORT_SSH', '22;tcp;SSH;1;0'
	74	),(
	75	'PORT_TELNET', '23;tcp;TELNET;1;0'
	76	),(
	77	'PORT_SMTP', '25;tcp;SMTP;1;0'
	78	),(
	79	'PORT_DNS', '53;tcp;DNS;1;0'
	80	),(
	81	'PORT_HTTP', '80;tcp;HTTP;1;0'
	82	),(
	83	'PORT_HTTPS', '443;tcp;HTTPS;1;0'
	84	),(
	85	'PORT_POP3', '110;tcp;POP3;1;0'
	86	),(
	87	'PORT_POP3-SSL', '995;tcp;POP3-SSL;1;0'
	88	),(
	89	'PORT_IMAP', '143;tcp;IMAP;1;0'
	90	),(
	91	'PORT_IMAP-SSL', '993;tcp;IMAP-SSL;1;0'
	92	);
	93
	94	-- --------------------------------------------------------
	95
	96	--
	97	-- Tabellenstruktur für Tabelle `custom_menus`
	98	--
	99	CREATE TABLE `custom_menus` (
	100	`menu_id` int(10) unsigned NOT NULL auto_increment,
	101	`menu_level` varchar(10) default NULL,
	102	`menu_name` varchar(255) default NULL,
	103	`menu_link` varchar(200) default NULL,
	104	`menu_target` varchar(200) NOT NULL default '',
	105	PRIMARY KEY (`menu_id`)
	106	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	107
	108	-- --------------------------------------------------------
	109
	110	--
	111	-- Tabellenstruktur für Tabelle `domain`
	112	--
	113
	114	CREATE TABLE `domain` (
	115	`domain_id` int(10) unsigned NOT NULL auto_increment,
	116	`domain_name` varchar(200) default NULL,
	117	`domain_gid` int(10) unsigned NOT NULL default '0',
	118	`domain_uid` int(10) unsigned NOT NULL default '0',
	119	`domain_admin_id` int(10) unsigned NOT NULL default '0',
	120	`domain_created_id` int(10) unsigned NOT NULL default '0',
	121	`domain_created` int(10) unsigned NOT NULL default '0',
	122	`domain_last_modified` int(10) unsigned NOT NULL default '0',
	123	`domain_mailacc_limit` int(11) default NULL,
	124	`domain_ftpacc_limit` int(11) default NULL,
	125	`domain_traffic_limit` bigint(20) default NULL,
	126	`domain_sqld_limit` int(11) default NULL,
	127	`domain_sqlu_limit` int(11) default NULL,
	128	`domain_status` varchar(255) default NULL,
	129	`domain_alias_limit` int(11) default NULL,
	130	`domain_subd_limit` int(11) default NULL,
	131	`domain_ip_id` int(10) unsigned default NULL,
	132	`domain_disk_limit` bigint(20) unsigned default NULL,
	133	`domain_disk_usage` bigint(20) unsigned default NULL,
	134	`domain_php` varchar(15) default NULL,
	135	`domain_cgi` varchar(15) default NULL,
	136	UNIQUE KEY `domain_id` (`domain_id`),
	137	UNIQUE KEY `domain_name` (`domain_name`),
	138	KEY `i_domain_admin_id` (`domain_admin_id`)
	139	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	140
	141	-- --------------------------------------------------------
	142
	143	--
	144	-- Tabellenstruktur für Tabelle `domain_aliasses`
	145	--
	146
	147	CREATE TABLE `domain_aliasses` (
	148	`alias_id` int(10) unsigned NOT NULL auto_increment,
	149	`domain_id` int(10) unsigned default NULL,
	150	`alias_name` varchar(200) default NULL,
	151	`alias_status` varchar(255) default NULL,
	152	`alias_mount` varchar(200) default NULL,
	153	`alias_ip_id` int(10) unsigned default NULL,
	154	`url_forward` varchar(200) default NULL,
	155	PRIMARY KEY (`alias_id`)
	156	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	157
	158	-- --------------------------------------------------------
	159
	160	--
	161	-- Tabellenstruktur für Tabelle `domain_props`
	162	--
	163
	164	CREATE TABLE `domain_props` (
	165	`id` int(10) unsigned NOT NULL auto_increment,
	166	`dmn_id` int(10) unsigned default NULL,
	167	`dmn_type` varchar(255) default NULL,
	168	`suexec_support` varchar(255) default NULL,
	169	`suexec_id` int(10) unsigned default NULL,
	170	`ssl_support` varchar(255) default NULL,
	171	`ssl_id` int(10) unsigned default NULL,
	172	`pri_master_dns` varchar(255) default NULL,
	173	`pri_master_dns_ip` varchar(255) default NULL,
	174	`sec_master_dns` varchar(255) default NULL,
	175	`sec_master_dns_ip` varchar(255) default NULL,
	176	PRIMARY KEY (`id`)
	177	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	178
	179	-- --------------------------------------------------------
	180
	181	--
	182	-- Tabellenstruktur für Tabelle `domain_traffic`
	183	--
	184
	185	CREATE TABLE `domain_traffic` (
	186	`dtraff_id` int(10) unsigned NOT NULL auto_increment,
	187	`domain_id` int(10) unsigned default NULL,
	188	`dtraff_time` int(10) unsigned default NULL,
	189	`dtraff_web` int(10) unsigned default NULL,
	190	`dtraff_ftp` int(10) unsigned default NULL,
	191	`dtraff_mail` int(10) unsigned default NULL,
	192	`dtraff_pop` int(10) unsigned default NULL,
	193	`correction` tinyint(1) NOT NULL default '0',
	194	PRIMARY KEY (`dtraff_id`),
	195	KEY `i_correction` (`correction`),
	196	KEY `i_domain_id` (`domain_id`),
	197	KEY `i_dtraff_time` (`dtraff_time`)
	198	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	199
	200	-- --------------------------------------------------------
	201
	202	--
	203	-- Tabellenstruktur für Tabelle `email_tpls`
	204	--
	205
	206	CREATE TABLE `email_tpls` (
	207	`id` int(10) unsigned NOT NULL auto_increment,
	208	`owner_id` int(10) unsigned NOT NULL default '0',
	209	`name` varchar(200) default NULL,
	210	`subject` varchar(200) default NULL,
	211	`message` text,
	212	UNIQUE KEY `id` (`id`)
	213	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	214
	215	-- --------------------------------------------------------
	216
	217	--
	218	-- Tabellenstruktur für Tabelle `error_pages`
	219	--
	220
	221	CREATE TABLE `error_pages` (
	222	`ep_id` int(10) unsigned NOT NULL auto_increment,
	223	`user_id` int(10) unsigned NOT NULL default '0',
	224	`error_401` text NOT NULL,
	225	`error_403` text NOT NULL,
	226	`error_404` text NOT NULL,
	227	`error_500` text NOT NULL,
	228	PRIMARY KEY (`ep_id`)
	229	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	230
	231	-- --------------------------------------------------------
	232
	233	--
	234	-- Tabellenstruktur für Tabelle `ftp_group`
	235	--
	236
	237	CREATE TABLE `ftp_group` (
	238	`groupname` varchar(255) default NULL,
	239	`gid` int(10) unsigned NOT NULL default '0',
	240	`members` text,
	241	UNIQUE KEY `groupname` (`groupname`)
	242	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	243
	244	-- --------------------------------------------------------
	245
	246	--
	247	-- Tabellenstruktur für Tabelle `ftp_users`
	248	--
	249
	250	CREATE TABLE `ftp_users` (
	251	`userid` varchar(255) default NULL,
	252	`passwd` varchar(255) default NULL,
	253	`uid` int(10) unsigned NOT NULL default '0',
	254	`gid` int(10) unsigned NOT NULL default '0',
	255	`shell` varchar(255) default NULL,
	256	`homedir` varchar(255) default NULL,
	257	UNIQUE KEY `userid` (`userid`)
	258	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	259
	260	-- --------------------------------------------------------
	261
	262	--
	263	-- Tabellenstruktur für Tabelle `hosting_plans`
	264	--
	265
	266	CREATE TABLE `hosting_plans` (
	267	`id` int(10) unsigned NOT NULL auto_increment,
	268	`reseller_id` int(10) unsigned NOT NULL default '0',
	269	`name` varchar(255) default NULL,
	270	`props` text,
	271	`description` varchar(255) default NULL,
	272	`price` decimal(10,2) NOT NULL default '0.00',
	273	`setup_fee` decimal(10,2) NOT NULL default '0.00',
	274	`value` varchar(255) default NULL,
	275	`payment` varchar(255) default NULL,
	276	`status` int(10) unsigned NOT NULL default '0',
	277	UNIQUE KEY `id` (`id`)
	278	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	279
	280	-- --------------------------------------------------------
	281
	282	--
	283	-- Tabellenstruktur für Tabelle `htaccess`
	284	--
	285	-- Erzeugt am: 14. Juni 2006 um 23:42
	286	-- Aktualisiert am: 09. Januar 2007 um 17:37
	287	-- Letzter Check am: 09. Januar 2007 um 17:37
	288	--
	289
	290	CREATE TABLE `htaccess` (
	291	`id` int(10) unsigned NOT NULL auto_increment,
	292	`dmn_id` int(10) unsigned NOT NULL default '0',
	293	`user_id` tinyint(4) default NULL,
	294	`group_id` tinyint(4) default NULL,
	295	`auth_type` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
	296	`auth_name` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
	297	`path` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
	298	`status` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
	299	UNIQUE KEY `id` (`id`)
	300	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	301
	302	-- --------------------------------------------------------
	303
	304	--
	305	-- Tabellenstruktur für Tabelle `htaccess_groups`
	306	--
	307	-- Erzeugt am: 05. März 2006 um 21:59
	308	-- Aktualisiert am: 01. Oktober 2006 um 13:59
	309	-- Letzter Check am: 15. September 2006 um 21:41
	310	--
	311
	312	CREATE TABLE `htaccess_groups` (
	313	`id` int(10) unsigned NOT NULL auto_increment,
	314	`dmn_id` int(10) unsigned NOT NULL default '0',
	315	`ugroup` varchar(255) default NULL,
	316	`members` text,
	317	`status` varchar(255) default NULL,
	318	UNIQUE KEY `id` (`id`)
	319	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	320
	321	-- --------------------------------------------------------
	322
	323	--
	324	-- Tabellenstruktur für Tabelle `htaccess_users`
	325	--
	326	-- Erzeugt am: 05. März 2006 um 21:59
	327	-- Aktualisiert am: 09. Januar 2007 um 17:37
	328	-- Letzter Check am: 09. Januar 2007 um 17:37
	329	--
	330
	331	CREATE TABLE `htaccess_users` (
	332	`id` int(10) unsigned NOT NULL auto_increment,
	333	`dmn_id` int(10) unsigned NOT NULL default '0',
	334	`uname` varchar(255) default NULL,
	335	`upass` varchar(255) default NULL,
	336	`status` varchar(255) default NULL,
	337	UNIQUE KEY `id` (`id`)
	338	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	339
	340	-- --------------------------------------------------------
	341	-- Tabellenstruktur für Tabelle `log`
	342	--
	343
	344	CREATE TABLE `log` (
	345	`log_id` int(10) unsigned NOT NULL auto_increment,
	346	`log_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
	347	`log_message` varchar(250) default NULL,
	348	PRIMARY KEY (`log_id`)
	349	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	350
	351	-- --------------------------------------------------------
	352
	353	--
	354	-- Tabellenstruktur für Tabelle `login`
	355	--
	356
	357	CREATE TABLE `login` (
	358	`session_id` varchar(200) default NULL,
	359	`ipaddr` varchar(15) default NULL,
	360	`lastaccess` int(10) unsigned default NULL,
	361	`login_count` tinyint(1) default NULL,
	362	`user_name` varchar(255) default NULL
	363	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	364
	365	-- --------------------------------------------------------
	366
	367	--
	368	-- Tabellenstruktur für Tabelle `mail_users`
	369	--
	370
	371	CREATE TABLE `mail_users` (
	372	`mail_id` int(10) unsigned NOT NULL auto_increment,
	373	`mail_acc` varchar(200) default NULL,
	374	`mail_pass` varchar(150) default NULL,
	375	`mail_forward` text,
	376	`domain_id` int(10) unsigned default NULL,
	377	`mail_type` varchar(20) default NULL,
	378	`sub_id` int(10) unsigned default NULL,
	379	`status` varchar(255) default NULL,
	380	`mail_auto_respond` text,
	381	`quota` int(10) default '10485760',
	382	`mail_addr` varchar(200) default NULL,
	383	PRIMARY KEY (`mail_id`)
	384	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	385
	386	-- --------------------------------------------------------
	387
	388	--
	389	-- Tabellenstruktur für Tabelle `orders`
	390	--
47	391
48	392	CREATE TABLE `orders` (
…	…
66	410	`status` varchar(255) default NULL,
67	411	PRIMARY KEY (`id`)
68		) TYPE=MyISAM;
69
70		#
71		# Daten f�elle `orders`
72		#
73
74
75		# --------------------------------------------------------
76
77		#
78		# Tabellenstruktur f�elle `orders_settings`
79		#
	412	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	413
	414	-- --------------------------------------------------------
	415
	416	--
	417	-- Tabellenstruktur für Tabelle `orders_settings`
	418	--
80	419
81	420	CREATE TABLE `orders_settings` (
…	…
85	424	`footer` text,
86	425	PRIMARY KEY (`id`)
87		) TYPE=MyISAM;
88
89		#
90		# Daten f�elle `orders_settings`
91		#
92
93
94		# --------------------------------------------------------
95
96		#
97		# Tabellenstruktur f�elle `custom_menus`
98		#
99
100		CREATE TABLE `custom_menus` (
101		`menu_id` int(10) unsigned NOT NULL auto_increment,
102		`menu_level` varchar(10) default NULL,
103		`menu_name` varchar(255) default NULL,
104		`menu_link` varchar(200) default NULL,
105		`menu_target` varchar(200) NOT NULL default '',
106		PRIMARY KEY (`menu_id`)
107		) TYPE=MyISAM AUTO_INCREMENT=1 ;
108
109		#
110		# Daten f�elle `custom_menus`
111		#
112
113
114		# --------------------------------------------------------
115
116		#
117		# Tabellenstruktur f�elle `domain`
118		#
119
120		CREATE TABLE `domain` (
121		`domain_id` int(10) unsigned NOT NULL auto_increment,
122		`domain_name` varchar(200) default NULL,
123		`domain_gid` int(10) unsigned NOT NULL default '0',
124		`domain_uid` int(10) unsigned NOT NULL default '0',
125		`domain_admin_id` int(10) unsigned NOT NULL default '0',
126		`domain_created_id` int(10) unsigned NOT NULL default '0',
127		`domain_created` int(10) unsigned NOT NULL default '0',
128		`domain_last_modified` int(10) unsigned NOT NULL default '0',
129		`domain_mailacc_limit` int(11) default NULL,
130		`domain_ftpacc_limit` int(11) default NULL,
131		`domain_traffic_limit` int(11) default NULL,
132		`domain_sqld_limit` int(11) default NULL,
133		`domain_sqlu_limit` int(11) default NULL,
134		`domain_status` varchar(255) default NULL,
135		`domain_alias_limit` int(11) default NULL,
136		`domain_subd_limit` int(11) default NULL,
137		`domain_ip_id` int(10) unsigned default NULL,
138		`domain_disk_limit` int(30) unsigned default NULL,
139		`domain_disk_usage` int(30) unsigned default NULL,
140		`domain_php` varchar(15) default NULL,
141		`domain_cgi` varchar(15) default NULL,
142		UNIQUE KEY `domain_id` (`domain_id`),
143		UNIQUE KEY `domain_name` (`domain_name`),
144		KEY `i_domain_domain_admin_id` (`domain_admin_id`)
145		) ENGINE=MyISAM AUTO_INCREMENT=1 ;
146
147		#
148		# Daten f�elle `domain`
149		#
150
151
152		# --------------------------------------------------------
153
154		#
155		# Tabellenstruktur f�elle `domain_aliasses`
156		#
157
158		CREATE TABLE `domain_aliasses` (
159		`alias_id` int(10) unsigned NOT NULL auto_increment,
160		`domain_id` int(10) unsigned default NULL,
161		`alias_name` varchar(200) default NULL,
162		`alias_status` varchar(255) default NULL,
163		`alias_mount` varchar(200) default NULL,
164		`alias_ip_id` int(10) unsigned default NULL,
165		`url_forward` varchar(200) default NULL,
166		PRIMARY KEY (`alias_id`)
167		) TYPE=MyISAM AUTO_INCREMENT=1 ;
168
169		#
170		# Daten f�elle `domain_aliasses`
171		#
172
173
174		# --------------------------------------------------------
175
176		#
177		# Tabellenstruktur f�elle `domain_props`
178		#
179
180		CREATE TABLE `domain_props` (
181		`id` int(10) unsigned NOT NULL auto_increment,
182		`dmn_id` int(10) unsigned default NULL,
183		`dmn_type` varchar(255) default NULL,
184		`suexec_support` varchar(255) default NULL,
185		`suexec_id` int(10) unsigned default NULL,
186		`ssl_support` varchar(255) default NULL,
187		`ssl_id` int(10) unsigned default NULL,
188		`pri_master_dns` varchar(255) default NULL,
189		`pri_master_dns_ip` varchar(255) default NULL,
190		`sec_master_dns` varchar(255) default NULL,
191		`sec_master_dns_ip` varchar(255) default NULL,
192		PRIMARY KEY (`id`),
193		UNIQUE KEY `id` (`id`)
194		) TYPE=MyISAM AUTO_INCREMENT=1 ;
195
196		#
197		# Daten f�elle `domain_props`
198		#
199
200
201		# --------------------------------------------------------
202
203		#
204		# Tabellenstruktur f�elle `domain_traffic`
205		#
206
207		CREATE TABLE `domain_traffic` (
208		`dtraff_id` int(10) unsigned NOT NULL auto_increment,
209		`domain_id` int(10) unsigned default NULL,
210		`dtraff_time` int(10) unsigned default NULL,
211		`dtraff_web` int(10) unsigned default NULL,
212		`dtraff_ftp` int(10) unsigned default NULL,
213		`dtraff_mail` int(10) unsigned default NULL,
214		`dtraff_pop` int(10) unsigned default NULL,
215		PRIMARY KEY (`dtraff_id`),
216		KEY `i_domain_traffic_domain_id` (`domain_id`),
217		KEY `dtraff_time` (`dtraff_time`)
218		) ENGINE=MyISAM AUTO_INCREMENT=1;
219
220		#
221		# Daten f�elle `domain_traffic`
222		#
223
224
225		# --------------------------------------------------------
226
227		#
228		# Tabellenstruktur f�elle `email_tpls`
229		#
230
231		CREATE TABLE `email_tpls` (
232		`id` int(10) unsigned NOT NULL auto_increment,
233		`owner_id` int(10) unsigned NOT NULL default '0',
234		`name` varchar(200) default NULL,
235		`subject` varchar(200) default NULL,
236		`message` text,
237		UNIQUE KEY `id` (`id`)
238		) TYPE=MyISAM AUTO_INCREMENT=1 ;
239
240		#
241		# Daten f�elle `email_tpls`
242		#
243
244
245		# --------------------------------------------------------
246
247		#
248		# Tabellenstruktur f�elle `error_pages`
249		#
250
251		CREATE TABLE `error_pages` (
252		`ep_id` int(10) unsigned NOT NULL auto_increment,
253		`user_id` int(10) unsigned NOT NULL default '0',
254		`error_401` text NOT NULL,
255		`error_403` text NOT NULL,
256		`error_404` text NOT NULL,
257		`error_500` text NOT NULL,
258		PRIMARY KEY (`ep_id`)
259		) TYPE=MyISAM AUTO_INCREMENT=3 ;
260
261		#
262		# Daten f�elle `error_pages`
263		#
264
265
266		# --------------------------------------------------------
267
268		#
269		# Tabellenstruktur f�elle `ftp_group`
270		#
271
272		CREATE TABLE `ftp_group` (
273		`groupname` varchar(255) default NULL,
274		`gid` int(10) unsigned NOT NULL default '0',
275		`members` text
276		) TYPE=MyISAM;
277
278		#
279		# Daten f�elle `ftp_group`
280		#
281
282
283		# --------------------------------------------------------
284
285		#
286		# Tabellenstruktur f�elle `hosting_plans`
287		#
288
289		CREATE TABLE `hosting_plans` (
290		`id` int(10) unsigned NOT NULL auto_increment,
291		`reseller_id` int(10) unsigned NOT NULL default '0',
292		`name` varchar(255) default NULL,
293		`description` varchar(255) default NULL,
294		`props` text,
295		`price` decimal(10,2) NOT NULL default '0.00',
296		`setup_fee` decimal(10,2) NOT NULL default '0.00',
297		`value` varchar(255) default NULL,
298		`payment` varchar(255) default NULL,
299		`status` int(10) unsigned NOT NULL default '0',
300		UNIQUE KEY `id` (`id`)
301		) TYPE=MyISAM;
302
303		#
304		# Daten f�elle `hosting_plans`
305		#
306
307
308		# --------------------------------------------------------
309
310		#
311		# Tabellenstruktur f�elle `log`
312		#
313
314		CREATE TABLE `log` (
315		`log_id` int(10) unsigned NOT NULL auto_increment,
316		`log_time` timestamp(14) NOT NULL,
317		`log_message` varchar(250) default NULL,
318		PRIMARY KEY (`log_id`)
319		) TYPE=MyISAM AUTO_INCREMENT=1 ;
320
321		#
322		# Daten f�elle `log`
323		#
324
325
326		# --------------------------------------------------------
327
328		#
329		# Tabellenstruktur f�elle `login`
330		#
331
332		CREATE TABLE `login` (
333		`session_id` varchar(200) default NULL,
334		`ipaddr` varchar(15) default NULL,
335		`lastaccess` int(10) unsigned default NULL,
336		`user_name` varchar(255) default NULL,
337		`login_count` tinyint(1) default NULL
338		) TYPE=MyISAM;
339
340		#
341		# Daten f�elle `login`
342		#
343
344
345		# --------------------------------------------------------
346
347		#
348		# Tabellenstruktur f�elle `mail_users`
349		#
350
351		CREATE TABLE `mail_users` (
352		`mail_id` int(10) unsigned NOT NULL auto_increment,
353		`mail_acc` varchar(200) default NULL,
354		`mail_pass` varchar(150) default NULL,
355		`mail_forward` text,
356		`domain_id` int(10) unsigned default NULL,
357		`mail_type` varchar(20) default NULL,
358		`sub_id` int(10) unsigned default NULL,
359		`status` varchar(255) default NULL,
360		`mail_auto_respond` text,
361		PRIMARY KEY (`mail_id`)
362		) TYPE=MyISAM AUTO_INCREMENT=1 ;
363
364		#
365		# Daten f�elle `mail_users`
366		#
367
368
369		# --------------------------------------------------------
370
371		#
372		# Tabellenstruktur f�elle `reseller_props`
373		#
	426	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	427
	428	-- --------------------------------------------------------
	429
	430	--
	431	-- Tabellenstruktur für Tabelle `quotalimits`
	432	--
	433
	434	CREATE TABLE `quotalimits` (
	435	`name` varchar(30) default NULL,
	436	`quota_type` enum('user','group','class','all') NOT NULL default 'user',
	437	`per_session` enum('false','true') NOT NULL default 'false',
	438	`limit_type` enum('soft','hard') NOT NULL default 'soft',
	439	`bytes_in_avail` float NOT NULL default '0',
	440	`bytes_out_avail` float NOT NULL default '0',
	441	`bytes_xfer_avail` float NOT NULL default '0',
	442	`files_in_avail` int(10) unsigned NOT NULL default '0',
	443	`files_out_avail` int(10) unsigned NOT NULL default '0',
	444	`files_xfer_avail` int(10) unsigned NOT NULL default '0'
	445	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	446
	447	-- --------------------------------------------------------
	448
	449	--
	450	-- Tabellenstruktur für Tabelle `quotatallies`
	451	--
	452
	453	CREATE TABLE `quotatallies` (
	454	`name` varchar(30) NOT NULL default '',
	455	`quota_type` enum('user','group','class','all') NOT NULL default 'user',
	456	`bytes_in_used` float NOT NULL default '0',
	457	`bytes_out_used` float NOT NULL default '0',
	458	`bytes_xfer_used` float NOT NULL default '0',
	459	`files_in_used` int(10) unsigned NOT NULL default '0',
	460	`files_out_used` int(10) unsigned NOT NULL default '0',
	461	`files_xfer_used` int(10) unsigned NOT NULL default '0'
	462	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	463
	464	-- --------------------------------------------------------
	465
	466
	467	-- Tabellenstruktur für Tabelle `reseller_props`
	468	--
374	469
375	470	CREATE TABLE `reseller_props` (
…	…
397	492	`reseller_ips` text,
398	493	UNIQUE KEY `id` (`id`)
399		) TYPE=MyISAM AUTO_INCREMENT=1 ;
400
401		#
402		# Daten f�elle `reseller_props`
403		#
404
405
406		# --------------------------------------------------------
407
408		#
409		# Tabellenstruktur f�elle `server_ips`
410		#
	494	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	495
	496
	497
	498	-- --------------------------------------------------------
	499
	500	--
	501	-- Tabellenstruktur für Tabelle `server_ips`
	502	--
411	503
412	504	CREATE TABLE `server_ips` (
…	…
416	508	`ip_alias` varchar(200) default NULL,
417	509	UNIQUE KEY `ip_id` (`ip_id`)
418		) TYPE=MyISAM AUTO_INCREMENT=8 ;
419
420		#
421		# Daten f�elle `server_ips`
422		#
423
424		# --------------------------------------------------------
425
426		#
427		# Tabellenstruktur f�elle `server_traffic`
428		#
	510	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	511
	512	-- --------------------------------------------------------
	513
	514	--
	515	-- Tabellenstruktur für Tabelle `server_traffic`
	516	--
429	517
430	518	CREATE TABLE `server_traffic` (
…	…
439	527	`bytes_web_in` int(10) unsigned default NULL,
440	528	`bytes_web_out` int(10) unsigned default NULL,
	529	`correction` tinyint(1) NOT NULL default '0',
441	530	PRIMARY KEY (`straff_id`),
442		KEY `traff_time` (`traff_time`)
443		) ENGINE=MyISAM AUTO_INCREMENT=1;
444
445		#
446		# Daten f�elle `server_traffic`
447		#
448
449
450		# --------------------------------------------------------
451
452		#
453		# Tabellenstruktur f�elle `sql_database`
454		#
	531	KEY `i_correction` (`correction`),
	532	KEY `i_traff_time` (`traff_time`)
	533	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	534
	535	-- --------------------------------------------------------
	536
	537	--
	538	-- Tabellenstruktur für Tabelle `sql_database`
	539	--
455	540
456	541	CREATE TABLE `sql_database` (
…	…
459	544	`sqld_name` varchar(64) binary default 'n/a',
460	545	UNIQUE KEY `sqld_id` (`sqld_id`)
461		) TYPE=MyISAM AUTO_INCREMENT=3 ;
462
463		#
464		# Daten f�elle `sql_database`
465		#
466
467
468		# --------------------------------------------------------
469
470		#
471		# Tabellenstruktur f�elle `sql_user`
472		#
	546	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	547
	548	-- --------------------------------------------------------
	549
	550	--
	551	-- Tabellenstruktur für Tabelle `sql_user`
	552	--
473	553
474	554	CREATE TABLE `sql_user` (
…	…
480	560	) TYPE=MyISAM AUTO_INCREMENT=2 ;
481	561
482		#
483		# Daten f�elle `sql_user`
484		#
485
486
487		# --------------------------------------------------------
488
489		#
490		# Tabellenstruktur f�elle `straff_settings`
491		#
	562	-- --------------------------------------------------------
	563
	564	--
	565	-- Tabellenstruktur für Tabelle `straff_settings`
	566	--
492	567
493	568	CREATE TABLE `straff_settings` (
…	…
495	570	`straff_warn` int(10) unsigned default NULL,
496	571	`straff_email` int(10) unsigned default NULL
497		) ~~TYPE=MyISAM~~;
498
499		#
500		~~# Daten f�~~elle `straff_settings`
501		#
	572	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	573
	574	--
	575	-- Daten für Tabelle `straff_settings`
	576	--
502	577
503	578	INSERT INTO `straff_settings` VALUES (0, 0, 0);
504	579
505		# --------------------------------------------------------
506
507		#
508		~~# Tabellenstruktur f�~~elle `subdomain`
509		#
	580	-- --------------------------------------------------------
	581
	582	--
	583	-- Tabellenstruktur für Tabelle `subdomain`
	584	--
510	585
511	586	CREATE TABLE `subdomain` (
…	…
516	591	`subdomain_status` varchar(255) default NULL,
517	592	PRIMARY KEY (`subdomain_id`)
518		) TYPE=MyISAM AUTO_INCREMENT=1 ;
519
520		#
521		# Daten f�elle `subdomain`
522		#
523
524
525		# --------------------------------------------------------
526
527		#
528		# Tabellenstruktur f�elle `suexec_props`
529		#
	593	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	594
	595	-- --------------------------------------------------------
	596
	597	--
	598	-- Tabellenstruktur für Tabelle `suexec_props`
	599	--
530	600
531	601	CREATE TABLE `suexec_props` (
…	…
535	605	`usr` varchar(255) default NULL,
536	606	`grp` varchar(255) default NULL,
537		PRIMARY KEY (`id`),
538		UNIQUE KEY `id` (`id`)
539		) TYPE=MyISAM AUTO_INCREMENT=2 ;
540
541		#
542		# Daten f�elle `suexec_props`
543		#
544
545		#INSERT INTO `suexec_props` VALUES (1, 3001, 3001, 'vhcs0001', 'vhcs0001');
546
547		# --------------------------------------------------------
548
549		#
550		# Tabellenstruktur f�elle `syslog`
551		#
	607	PRIMARY KEY (`id`)
	608	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	609
	610	-- --------------------------------------------------------
	611
	612	--
	613	-- Tabellenstruktur für Tabelle `syslog`
	614	--
552	615
553	616	CREATE TABLE `syslog` (
…	…
559	622	`comment` text,
560	623	UNIQUE KEY `id` (`id`)
561		) TYPE=MyISAM AUTO_INCREMENT=1 ;
562
563		#
564		# Daten f�elle `syslog`
565		#
566
567
568		# --------------------------------------------------------
569
570		#
571		# Tabellenstruktur f�elle `tickets`
572		#
	624	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	625
	626	-- --------------------------------------------------------
	627
	628	--
	629	-- Tabellenstruktur für Tabelle `tickets`
	630	--
573	631
574	632	CREATE TABLE `tickets` (
…	…
584	642	`ticket_message` text,
585	643	PRIMARY KEY (`ticket_id`)
586		) TYPE=MyISAM AUTO_INCREMENT=2 ;
587
588		#
589		# Daten f�elle `tickets`
590		#
591
592
593		# --------------------------------------------------------
594
595		#
596		# Tabellenstruktur f�elle `user_gui_props`
597		#
	644	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	645
	646	-- --------------------------------------------------------
	647
	648	--
	649	-- Tabellenstruktur für Tabelle `user_gui_props`
	650	--
598	651
599	652	CREATE TABLE `user_gui_props` (
…	…
604	657	`logo` varchar(255) NOT NULL default '0',
605	658	UNIQUE KEY `id` (`id`)
606		) TYPE=MyISAM AUTO_INCREMENT=66 ;
607
608		#
609		# Daten f�elle `user_gui_props`
610		#
611
612		#INSERT INTO `user_gui_props` VALUES (3, 3, 'lang_Deutsch', 'yellow', 'admin.jpg');
613
614
615		# --------------------------------------------------------
616
617		#
618		# Tabellenstruktur Tabelle `ftp_users`
619		#
620
621		CREATE TABLE `ftp_users` (
622		`userid` varchar(255) default NULL,
623		`passwd` varchar(255) default NULL,
624		`uid` int(10) unsigned NOT NULL default '0',
625		`gid` int(10) unsigned NOT NULL default '0',
626		`shell` varchar(255) default NULL,
627		`homedir` varchar(255) default NULL,
628		UNIQUE KEY `userid` (`userid`)
629		) TYPE=MyISAM;
630
631		#
632		# Daten f�elle `ftp_users`
633		#
634
635
636		# --------------------------------------------------------
637
638		#
639		# Tabellenstruktur f�elle `quotalimits`
640		#
641
642		CREATE TABLE `quotalimits` (
643		`name` VARCHAR(30),
644		`quota_type` ENUM("user", "group", "class", "all") NOT NULL,
645		`per_session` ENUM("false", "true") NOT NULL,
646		`limit_type` ENUM("soft", "hard") NOT NULL,
647		`bytes_in_avail` FLOAT NOT NULL,
648		`bytes_out_avail` FLOAT NOT NULL,
649		`bytes_xfer_avail` FLOAT NOT NULL,
650		`files_in_avail` INT UNSIGNED NOT NULL,
651		`files_out_avail` INT UNSIGNED NOT NULL,
652		`files_xfer_avail` INT UNSIGNED NOT NULL
653		);
654
655		#
656		# Daten f�elle `quotalimits`
657		#
658
659
660		# --------------------------------------------------------
661
662		#
663		# Tabellenstruktur f�elle `quotatallies`
664		#
665
666		CREATE TABLE `quotatallies` (
667		`name` VARCHAR(30) NOT NULL,
668		`quota_type` ENUM("user", "group", "class", "all") NOT NULL,
669		`bytes_in_used` FLOAT NOT NULL,
670		`bytes_out_used` FLOAT NOT NULL,
671		`bytes_xfer_used` FLOAT NOT NULL,
672		`files_in_used` INT UNSIGNED NOT NULL,
673		`files_out_used` INT UNSIGNED NOT NULL,
674		`files_xfer_used` INT UNSIGNED NOT NULL
675		);
676
677		#
678		# Daten f�elle `quotatallies`
679		#
680
681
682		# --------------------------------------------------------
683
684		#
685		# Tabellenstruktur f�elle `auto_num`
686		#
687
688		CREATE TABLE `auto_num` (
689		`id` INT unsigned NOT NULL AUTO_INCREMENT,
690		`msg` VARCHAR(255),
691		UNIQUE KEY `id` (`id`)
692		);
693
694		#
695		# Daten f�elle `auto_num`
696		#
697
698
699		# --------------------------------------------------------
700
701		#
702		# Tabellenstruktur f�elle `config`
703		#
704
705		CREATE TABLE `config` (
706		`name` varchar(255) NOT NULL default '',
707		`value` varchar(255) NOT NULL default '',
708		PRIMARY KEY (`name`)
709		) TYPE=MyISAM;
710
711		#
712		# Daten f�elle `auto_num`
713		#
714
715		INSERT INTO `config` ( `name` , `value` )
716		VALUES (
717		'PORT_FTP', '21;tcp;FTP;1;0'
718		), (
719		'PORT_SSH', '22;tcp;SSH;1;0'
720		),(
721		'PORT_TELNET', '23;tcp;TELNET;1;0'
722		),(
723		'PORT_SMTP', '25;tcp;SMPT;1;0'
724		),(
725		'PORT_DNS', '53;tcp;DNS;1;0'
726		),(
727		'PORT_HTTP', '80;tcp;HTTP;1;0'
728		),(
729		'PORT_HTTPS', '443;tcp;HTTPS;1;0'
730		),(
731		'PORT_POP3', '110;tcp;POP3;1;0'
732		),(
733		'PORT_POP3-SSL', '995;tcp;POP3-SSL;1;0'
734		),(
735		'PORT_IMAP', '143;tcp;IMAP;1;0'
736		),(
737		'PORT_IMAP-SSL', '993;tcp;IMAP-SSL;1;0'
738		);
739
740		# --------------------------------------------------------
741
	659	) ENGINE=MyISAM DEFAULT CHARSET=latin1;

trunk/configs/dists/suse100/database/database.sql

r154	r397
3	3	use {DATABASE_NAME};
4	4
5		# VHCS(tm) - Virtual Hosting Control System
6		# (c) 2001-2006 moleSoftware
7		# http://vhcs.net \| http://www.molesoftware.com
8		# All rights reserved
9		#
10		# Datenbank: `vhcs_pro_dev`
11		# --------------------------------------------------------
12		#
13		~~# Tabellenstruktur f�~~elle `admin`
14		#
	5	--
	6	-- VHCS ω (OMEGA) - Virtual Hosting Control System \| Omega Version
	7	-- Copyright (c) 2001-2006 by moleSoftware GmbH
	8	-- Copyright (c) 2006-2007 by ispCP \| http://isp-control.net
	9	--
	10	-- --------------------------------------------------------
	11
	12	--
	13	-- Tabellenstruktur für Tabelle `admin`
	14	--
15	15
16	16	CREATE TABLE `admin` (
…	…
34	34	`street2` varchar(200) default NULL,
35	35	`uniqkey` varchar(255) default NULL,
36		`uniqkey_time` ~~TIMESTAMP~~ NULL,
	36	`uniqkey_time` timestamp NULL default NULL,
37	37	UNIQUE KEY `admin_id` (`admin_id`),
38	38	UNIQUE KEY `admin_name` (`admin_name`)
39		) ENGINE=MyISAM AUTO_INCREMENT=1 ;
40
41		#
42		# Daten f�elle `admin`
43		#
44
45
46		# --------------------------------------------------------
	39	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	40
	41	-- --------------------------------------------------------
	42
	43	--
	44	-- Tabellenstruktur für Tabelle `auto_num`
	45	--
	46
	47	CREATE TABLE `auto_num` (
	48	`id` int(10) unsigned NOT NULL auto_increment,
	49	`msg` varchar(255) default NULL,
	50	UNIQUE KEY `id` (`id`)
	51	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	52
	53	-- --------------------------------------------------------
	54
	55	--
	56	-- Tabellenstruktur für Tabelle `config`
	57	--
	58
	59	CREATE TABLE `config` (
	60	`name` varchar(255) NOT NULL default '',
	61	`value` varchar(255) NOT NULL default '',
	62	PRIMARY KEY (`name`)
	63	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
	64
	65	--
	66	-- Daten für Tabelle `auto_num`
	67	--
	68
	69	INSERT INTO `config` ( `name` , `value` )
	70	VALUES (
	71	'PORT_FTP', '21;tcp;FTP;1;0'
	72	), (
	73	'PORT_SSH', '22;tcp;SSH;1;0'
	74	),(
	75	'PORT_TELNET', '23;tcp;TELNET;1;0'
	76	),(
	77	'PORT_SMTP', '25;tcp;SMTP;1;0'
	78	),(
	79	'PORT_DNS', '53;tcp;DNS;1;0'
	80	),(
	81	'PORT_HTTP', '80;tcp;HTTP;1;0'
	82	),(
	83	'PORT_HTTPS', '443;tcp;HTTPS;1;0'
	84	),(
	85	'PORT_POP3', '110;tcp;POP3;1;0'
	86	),(
	87	'PORT_POP3-SSL', '995;tcp;POP3-SSL;1;0'
	88	),(