Development

Navigation

← Previous Changeset
Next Changeset →

Changeset 624

Timestamp:

06/01/07 13:15:08 (2 years ago)

Author:

rats

Message:

fixed serveral install bugs

Files:

trunk/CHANGELOG (modified) (2 diffs)
trunk/configs/database/database.sql (modified) (32 diffs)
trunk/configs/dists/fedora/database/database.sql (modified) (32 diffs)
trunk/configs/dists/freebsd/database/database.sql (modified) (32 diffs)
trunk/configs/dists/gentoo/database/database.sql (modified) (32 diffs)
trunk/configs/dists/openbsd/database/database.sql (modified) (32 diffs)
trunk/configs/dists/redhat/database/database.sql (modified) (32 diffs)
trunk/configs/dists/sles9/database/database.sql (modified) (32 diffs)
trunk/configs/dists/suse100/database/database.sql (modified) (32 diffs)
trunk/configs/dists/suse93/database/database.sql (modified) (32 diffs)
trunk/docs/Ubuntu/INSTALL (modified) (1 diff)
trunk/engine/setup/ispcp-setup (modified) (23 diffs)

Legend:

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

trunk/CHANGELOG

r619	r624
11	11	\_________________________________________________________________/
12	12
	13	2007-06-01 Benedikt Heintel
	14	- SETUP
	15	* fixed serveral install bugs
	16
13	17	2007-05-31 Benedikt Heintel
14		- DATABASE:
	18	- DATABASE
15	19	* changed Englisch language
16		- GUI:
	20	- GUI
17	21	* Fixed: missing $cfg in tr-function
18	22	* started build-in of AWStats (#7)
…	…
22	26	* Fixed #214: Wrong size for ispCP - Logo
23	27	* Fixed #292: Color Contrast in pma not ok
24		* Fixed #239: Order-Panel in old look
	28	* Fixed #239: Order-Panel in old look
25	29	* Fixed colors in the order - panel
26	30	* Fixed width of table in support

trunk/configs/database/database.sql

r614	r624
37	37	UNIQUE KEY `admin_id` (`admin_id`),
38	38	UNIQUE KEY `admin_name` (`admin_name`)
39		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	39	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
40	40
41	41	-- --------------------------------------------------------
…	…
49	49	`msg` varchar(255) default NULL,
50	50	UNIQUE KEY `id` (`id`)
51		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	51	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
52	52
53	53	-- --------------------------------------------------------
…	…
104	104	`menu_target` varchar(200) NOT NULL default '',
105	105	PRIMARY KEY (`menu_id`)
106		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	106	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
107	107
108	108	-- --------------------------------------------------------
…	…
137	137	UNIQUE KEY `domain_name` (`domain_name`),
138	138	KEY `i_domain_admin_id` (`domain_admin_id`)
139		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	139	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
140	140
141	141	-- --------------------------------------------------------
…	…
154	154	`url_forward` varchar(200) default NULL,
155	155	PRIMARY KEY (`alias_id`)
156		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	156	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
157	157
158	158	-- --------------------------------------------------------
…	…
175	175	`sec_master_dns_ip` varchar(255) default NULL,
176	176	PRIMARY KEY (`id`)
177		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	177	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
178	178
179	179	-- --------------------------------------------------------
…	…
196	196	KEY `i_domain_id` (`domain_id`),
197	197	KEY `i_dtraff_time` (`dtraff_time`)
198		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	198	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
199	199
200	200	-- --------------------------------------------------------
…	…
211	211	`message` text,
212	212	UNIQUE KEY `id` (`id`)
213		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	213	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
214	214
215	215	-- --------------------------------------------------------
…	…
227	227	`error_500` text NOT NULL,
228	228	PRIMARY KEY (`ep_id`)
229		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	229	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
230	230
231	231	-- --------------------------------------------------------
…	…
240	240	`members` text,
241	241	UNIQUE KEY `groupname` (`groupname`)
242		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	242	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
243	243
244	244	-- --------------------------------------------------------
…	…
256	256	`homedir` varchar(255) default NULL,
257	257	UNIQUE KEY `userid` (`userid`)
258		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	258	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
259	259
260	260	-- --------------------------------------------------------
…	…
276	276	`status` int(10) unsigned NOT NULL default '0',
277	277	UNIQUE KEY `id` (`id`)
278		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	278	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
279	279
280	280	-- --------------------------------------------------------
…	…
298	298	`status` varchar(255) character set utf8_general_ci collate utf8_general_ci_german1_ci default NULL,
299	299	UNIQUE KEY `id` (`id`)
300		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	300	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
301	301
302	302	-- --------------------------------------------------------
…	…
317	317	`status` varchar(255) default NULL,
318	318	UNIQUE KEY `id` (`id`)
319		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	319	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
320	320
321	321	-- --------------------------------------------------------
…	…
336	336	`status` varchar(255) default NULL,
337	337	UNIQUE KEY `id` (`id`)
338		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	338	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
339	339
340	340	-- --------------------------------------------------------
…	…
347	347	`log_message` varchar(250) default NULL,
348	348	PRIMARY KEY (`log_id`)
349		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	349	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
350	350
351	351	-- --------------------------------------------------------
…	…
361	361	`login_count` tinyint(1) default NULL,
362	362	`user_name` varchar(255) default NULL
363		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	363	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
364	364
365	365	-- --------------------------------------------------------
…	…
382	382	`mail_addr` varchar(200) default NULL,
383	383	PRIMARY KEY (`mail_id`)
384		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	384	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
385	385
386	386	-- --------------------------------------------------------
…	…
410	410	`status` varchar(255) default NULL,
411	411	PRIMARY KEY (`id`)
412		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	412	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
413	413
414	414	-- --------------------------------------------------------
…	…
424	424	`footer` text,
425	425	PRIMARY KEY (`id`)
426		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	426	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
427	427
428	428	-- --------------------------------------------------------
…	…
443	443	`files_out_avail` int(10) unsigned NOT NULL default '0',
444	444	`files_xfer_avail` int(10) unsigned NOT NULL default '0'
445		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	445	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
446	446
447	447	-- --------------------------------------------------------
…	…
460	460	`files_out_used` int(10) unsigned NOT NULL default '0',
461	461	`files_xfer_used` int(10) unsigned NOT NULL default '0'
462		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	462	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
463	463
464	464	-- --------------------------------------------------------
…	…
492	492	`reseller_ips` text,
493	493	UNIQUE KEY `id` (`id`)
494		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	494	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
495	495
496	496
…	…
508	508	`ip_alias` varchar(200) default NULL,
509	509	UNIQUE KEY `ip_id` (`ip_id`)
510		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	510	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
511	511
512	512	-- --------------------------------------------------------
…	…
531	531	KEY `i_correction` (`correction`),
532	532	KEY `i_traff_time` (`traff_time`)
533		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	533	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
534	534
535	535	-- --------------------------------------------------------
…	…
544	544	`sqld_name` varchar(64) binary default 'n/a',
545	545	UNIQUE KEY `sqld_id` (`sqld_id`)
546		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	546	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
547	547
548	548	-- --------------------------------------------------------
…	…
570	570	`straff_warn` int(10) unsigned default NULL,
571	571	`straff_email` int(10) unsigned default NULL
572		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	572	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
573	573
574	574	--
…	…
591	591	`subdomain_status` varchar(255) default NULL,
592	592	PRIMARY KEY (`subdomain_id`)
593		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	593	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
594	594
595	595	-- --------------------------------------------------------
…	…
606	606	`grp` varchar(255) default NULL,
607	607	PRIMARY KEY (`id`)
608		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	608	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
609	609
610	610	-- --------------------------------------------------------
…	…
622	622	`comment` text,
623	623	UNIQUE KEY `id` (`id`)
624		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	624	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
625	625
626	626	-- --------------------------------------------------------
…	…
642	642	`ticket_message` text,
643	643	PRIMARY KEY (`ticket_id`)
644		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	644	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
645	645
646	646	-- --------------------------------------------------------
…	…
657	657	`logo` varchar(255) NOT NULL default '0',
658	658	UNIQUE KEY `id` (`id`)
659		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	659	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

r614	r624
37	37	UNIQUE KEY `admin_id` (`admin_id`),
38	38	UNIQUE KEY `admin_name` (`admin_name`)
39		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	39	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
40	40
41	41	-- --------------------------------------------------------
…	…
49	49	`msg` varchar(255) default NULL,
50	50	UNIQUE KEY `id` (`id`)
51		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	51	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
52	52
53	53	-- --------------------------------------------------------
…	…
104	104	`menu_target` varchar(200) NOT NULL default '',
105	105	PRIMARY KEY (`menu_id`)
106		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	106	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
107	107
108	108	-- --------------------------------------------------------
…	…
137	137	UNIQUE KEY `domain_name` (`domain_name`),
138	138	KEY `i_domain_admin_id` (`domain_admin_id`)
139		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	139	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
140	140
141	141	-- --------------------------------------------------------
…	…
154	154	`url_forward` varchar(200) default NULL,
155	155	PRIMARY KEY (`alias_id`)
156		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	156	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
157	157
158	158	-- --------------------------------------------------------
…	…
175	175	`sec_master_dns_ip` varchar(255) default NULL,
176	176	PRIMARY KEY (`id`)
177		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	177	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
178	178
179	179	-- --------------------------------------------------------
…	…
196	196	KEY `i_domain_id` (`domain_id`),
197	197	KEY `i_dtraff_time` (`dtraff_time`)
198		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	198	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
199	199
200	200	-- --------------------------------------------------------
…	…
211	211	`message` text,
212	212	UNIQUE KEY `id` (`id`)
213		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	213	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
214	214
215	215	-- --------------------------------------------------------
…	…
227	227	`error_500` text NOT NULL,
228	228	PRIMARY KEY (`ep_id`)
229		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	229	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
230	230
231	231	-- --------------------------------------------------------
…	…
240	240	`members` text,
241	241	UNIQUE KEY `groupname` (`groupname`)
242		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	242	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
243	243
244	244	-- --------------------------------------------------------
…	…
256	256	`homedir` varchar(255) default NULL,
257	257	UNIQUE KEY `userid` (`userid`)
258		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	258	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
259	259
260	260	-- --------------------------------------------------------
…	…
276	276	`status` int(10) unsigned NOT NULL default '0',
277	277	UNIQUE KEY `id` (`id`)
278		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	278	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
279	279
280	280	-- --------------------------------------------------------
…	…
298	298	`status` varchar(255) character set utf8_general_ci collate utf8_general_ci_german1_ci default NULL,
299	299	UNIQUE KEY `id` (`id`)
300		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	300	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
301	301
302	302	-- --------------------------------------------------------
…	…
317	317	`status` varchar(255) default NULL,
318	318	UNIQUE KEY `id` (`id`)
319		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	319	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
320	320
321	321	-- --------------------------------------------------------
…	…
336	336	`status` varchar(255) default NULL,
337	337	UNIQUE KEY `id` (`id`)
338		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	338	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
339	339
340	340	-- --------------------------------------------------------
…	…
347	347	`log_message` varchar(250) default NULL,
348	348	PRIMARY KEY (`log_id`)
349		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	349	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
350	350
351	351	-- --------------------------------------------------------
…	…
361	361	`login_count` tinyint(1) default NULL,
362	362	`user_name` varchar(255) default NULL
363		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	363	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
364	364
365	365	-- --------------------------------------------------------
…	…
382	382	`mail_addr` varchar(200) default NULL,
383	383	PRIMARY KEY (`mail_id`)
384		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	384	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
385	385
386	386	-- --------------------------------------------------------
…	…
410	410	`status` varchar(255) default NULL,
411	411	PRIMARY KEY (`id`)
412		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	412	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
413	413
414	414	-- --------------------------------------------------------
…	…
424	424	`footer` text,
425	425	PRIMARY KEY (`id`)
426		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	426	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
427	427
428	428	-- --------------------------------------------------------
…	…
443	443	`files_out_avail` int(10) unsigned NOT NULL default '0',
444	444	`files_xfer_avail` int(10) unsigned NOT NULL default '0'
445		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	445	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
446	446
447	447	-- --------------------------------------------------------
…	…
460	460	`files_out_used` int(10) unsigned NOT NULL default '0',
461	461	`files_xfer_used` int(10) unsigned NOT NULL default '0'
462		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	462	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
463	463
464	464	-- --------------------------------------------------------
…	…
492	492	`reseller_ips` text,
493	493	UNIQUE KEY `id` (`id`)
494		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	494	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
495	495
496	496
…	…
508	508	`ip_alias` varchar(200) default NULL,
509	509	UNIQUE KEY `ip_id` (`ip_id`)
510		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	510	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
511	511
512	512	-- --------------------------------------------------------
…	…
531	531	KEY `i_correction` (`correction`),
532	532	KEY `i_traff_time` (`traff_time`)
533		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	533	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
534	534
535	535	-- --------------------------------------------------------
…	…
544	544	`sqld_name` varchar(64) binary default 'n/a',
545	545	UNIQUE KEY `sqld_id` (`sqld_id`)
546		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	546	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
547	547
548	548	-- --------------------------------------------------------
…	…
570	570	`straff_warn` int(10) unsigned default NULL,
571	571	`straff_email` int(10) unsigned default NULL
572		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	572	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
573	573
574	574	--
…	…
591	591	`subdomain_status` varchar(255) default NULL,
592	592	PRIMARY KEY (`subdomain_id`)
593		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	593	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
594	594
595	595	-- --------------------------------------------------------
…	…
606	606	`grp` varchar(255) default NULL,
607	607	PRIMARY KEY (`id`)
608		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	608	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
609	609
610	610	-- --------------------------------------------------------
…	…
622	622	`comment` text,
623	623	UNIQUE KEY `id` (`id`)
624		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	624	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
625	625
626	626	-- --------------------------------------------------------
…	…
642	642	`ticket_message` text,
643	643	PRIMARY KEY (`ticket_id`)
644		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	644	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
645	645
646	646	-- --------------------------------------------------------
…	…
657	657	`logo` varchar(255) NOT NULL default '0',
658	658	UNIQUE KEY `id` (`id`)
659		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	659	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

trunk/configs/dists/freebsd/database/database.sql

r614	r624
37	37	UNIQUE KEY `admin_id` (`admin_id`),
38	38	UNIQUE KEY `admin_name` (`admin_name`)
39		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	39	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
40	40
41	41	-- --------------------------------------------------------
…	…
49	49	`msg` varchar(255) default NULL,
50	50	UNIQUE KEY `id` (`id`)
51		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	51	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
52	52
53	53	-- --------------------------------------------------------
…	…
104	104	`menu_target` varchar(200) NOT NULL default '',
105	105	PRIMARY KEY (`menu_id`)
106		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	106	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
107	107
108	108	-- --------------------------------------------------------
…	…
137	137	UNIQUE KEY `domain_name` (`domain_name`),
138	138	KEY `i_domain_admin_id` (`domain_admin_id`)
139		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	139	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
140	140
141	141	-- --------------------------------------------------------
…	…
154	154	`url_forward` varchar(200) default NULL,
155	155	PRIMARY KEY (`alias_id`)
156		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	156	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
157	157
158	158	-- --------------------------------------------------------
…	…
175	175	`sec_master_dns_ip` varchar(255) default NULL,
176	176	PRIMARY KEY (`id`)
177		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	177	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
178	178
179	179	-- --------------------------------------------------------
…	…
196	196	KEY `i_domain_id` (`domain_id`),
197	197	KEY `i_dtraff_time` (`dtraff_time`)
198		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	198	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
199	199
200	200	-- --------------------------------------------------------
…	…
211	211	`message` text,
212	212	UNIQUE KEY `id` (`id`)
213		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	213	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
214	214
215	215	-- --------------------------------------------------------
…	…
227	227	`error_500` text NOT NULL,
228	228	PRIMARY KEY (`ep_id`)
229		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	229	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
230	230
231	231	-- --------------------------------------------------------
…	…
240	240	`members` text,
241	241	UNIQUE KEY `groupname` (`groupname`)
242		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	242	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
243	243
244	244	-- --------------------------------------------------------
…	…
256	256	`homedir` varchar(255) default NULL,
257	257	UNIQUE KEY `userid` (`userid`)
258		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	258	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
259	259
260	260	-- --------------------------------------------------------
…	…
276	276	`status` int(10) unsigned NOT NULL default '0',
277	277	UNIQUE KEY `id` (`id`)
278		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	278	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
279	279
280	280	-- --------------------------------------------------------
…	…
298	298	`status` varchar(255) character set utf8_general_ci collate utf8_general_ci_german1_ci default NULL,
299	299	UNIQUE KEY `id` (`id`)
300		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	300	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
301	301
302	302	-- --------------------------------------------------------
…	…
317	317	`status` varchar(255) default NULL,
318	318	UNIQUE KEY `id` (`id`)
319		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	319	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
320	320
321	321	-- --------------------------------------------------------
…	…
336	336	`status` varchar(255) default NULL,
337	337	UNIQUE KEY `id` (`id`)
338		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	338	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
339	339
340	340	-- --------------------------------------------------------
…	…
347	347	`log_message` varchar(250) default NULL,
348	348	PRIMARY KEY (`log_id`)
349		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	349	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
350	350
351	351	-- --------------------------------------------------------
…	…
361	361	`login_count` tinyint(1) default NULL,
362	362	`user_name` varchar(255) default NULL
363		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	363	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
364	364
365	365	-- --------------------------------------------------------
…	…
382	382	`mail_addr` varchar(200) default NULL,
383	383	PRIMARY KEY (`mail_id`)
384		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	384	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
385	385
386	386	-- --------------------------------------------------------
…	…
410	410	`status` varchar(255) default NULL,
411	411	PRIMARY KEY (`id`)
412		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	412	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
413	413
414	414	-- --------------------------------------------------------
…	…
424	424	`footer` text,
425	425	PRIMARY KEY (`id`)
426		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	426	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
427	427
428	428	-- --------------------------------------------------------
…	…
443	443	`files_out_avail` int(10) unsigned NOT NULL default '0',
444	444	`files_xfer_avail` int(10) unsigned NOT NULL default '0'
445		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	445	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
446	446
447	447	-- --------------------------------------------------------
…	…
460	460	`files_out_used` int(10) unsigned NOT NULL default '0',
461	461	`files_xfer_used` int(10) unsigned NOT NULL default '0'
462		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	462	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
463	463
464	464	-- --------------------------------------------------------
…	…
492	492	`reseller_ips` text,
493	493	UNIQUE KEY `id` (`id`)
494		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	494	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
495	495
496	496
…	…
508	508	`ip_alias` varchar(200) default NULL,
509	509	UNIQUE KEY `ip_id` (`ip_id`)
510		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	510	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
511	511
512	512	-- --------------------------------------------------------
…	…
531	531	KEY `i_correction` (`correction`),
532	532	KEY `i_traff_time` (`traff_time`)
533		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	533	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
534	534
535	535	-- --------------------------------------------------------
…	…
544	544	`sqld_name` varchar(64) binary default 'n/a',
545	545	UNIQUE KEY `sqld_id` (`sqld_id`)
546		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	546	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
547	547
548	548	-- --------------------------------------------------------
…	…
570	570	`straff_warn` int(10) unsigned default NULL,
571	571	`straff_email` int(10) unsigned default NULL
572		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	572	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
573	573
574	574	--
…	…
591	591	`subdomain_status` varchar(255) default NULL,
592	592	PRIMARY KEY (`subdomain_id`)
593		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	593	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
594	594
595	595	-- --------------------------------------------------------
…	…
606	606	`grp` varchar(255) default NULL,
607	607	PRIMARY KEY (`id`)
608		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	608	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
609	609
610	610	-- --------------------------------------------------------
…	…
622	622	`comment` text,
623	623	UNIQUE KEY `id` (`id`)
624		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	624	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
625	625
626	626	-- --------------------------------------------------------
…	…
642	642	`ticket_message` text,
643	643	PRIMARY KEY (`ticket_id`)
644		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	644	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
645	645
646	646	-- --------------------------------------------------------
…	…
657	657	`logo` varchar(255) NOT NULL default '0',
658	658	UNIQUE KEY `id` (`id`)
659		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	659	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

r614	r624
37	37	UNIQUE KEY `admin_id` (`admin_id`),
38	38	UNIQUE KEY `admin_name` (`admin_name`)
39		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	39	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
40	40
41	41	-- --------------------------------------------------------
…	…
49	49	`msg` varchar(255) default NULL,
50	50	UNIQUE KEY `id` (`id`)
51		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	51	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
52	52
53	53	-- --------------------------------------------------------
…	…
104	104	`menu_target` varchar(200) NOT NULL default '',
105	105	PRIMARY KEY (`menu_id`)
106		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	106	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
107	107
108	108	-- --------------------------------------------------------
…	…
137	137	UNIQUE KEY `domain_name` (`domain_name`),
138	138	KEY `i_domain_admin_id` (`domain_admin_id`)
139		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	139	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
140	140
141	141	-- --------------------------------------------------------
…	…
154	154	`url_forward` varchar(200) default NULL,
155	155	PRIMARY KEY (`alias_id`)
156		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	156	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
157	157
158	158	-- --------------------------------------------------------
…	…
175	175	`sec_master_dns_ip` varchar(255) default NULL,
176	176	PRIMARY KEY (`id`)
177		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	177	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
178	178
179	179	-- --------------------------------------------------------
…	…
196	196	KEY `i_domain_id` (`domain_id`),
197	197	KEY `i_dtraff_time` (`dtraff_time`)
198		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	198	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
199	199
200	200	-- --------------------------------------------------------
…	…
211	211	`message` text,
212	212	UNIQUE KEY `id` (`id`)
213		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	213	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
214	214
215	215	-- --------------------------------------------------------
…	…
227	227	`error_500` text NOT NULL,
228	228	PRIMARY KEY (`ep_id`)
229		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	229	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
230	230
231	231	-- --------------------------------------------------------
…	…
240	240	`members` text,
241	241	UNIQUE KEY `groupname` (`groupname`)
242		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	242	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
243	243
244	244	-- --------------------------------------------------------
…	…
256	256	`homedir` varchar(255) default NULL,
257	257	UNIQUE KEY `userid` (`userid`)
258		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	258	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
259	259
260	260	-- --------------------------------------------------------
…	…
276	276	`status` int(10) unsigned NOT NULL default '0',
277	277	UNIQUE KEY `id` (`id`)
278		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	278	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
279	279
280	280	-- --------------------------------------------------------
…	…
298	298	`status` varchar(255) character set utf8_general_ci collate utf8_general_ci_german1_ci default NULL,
299	299	UNIQUE KEY `id` (`id`)
300		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	300	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
301	301
302	302	-- --------------------------------------------------------
…	…
317	317	`status` varchar(255) default NULL,
318	318	UNIQUE KEY `id` (`id`)
319		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	319	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
320	320
321	321	-- --------------------------------------------------------
…	…
336	336	`status` varchar(255) default NULL,
337	337	UNIQUE KEY `id` (`id`)
338		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	338	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
339	339
340	340	-- --------------------------------------------------------
…	…
347	347	`log_message` varchar(250) default NULL,
348	348	PRIMARY KEY (`log_id`)
349		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	349	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
350	350
351	351	-- --------------------------------------------------------
…	…
361	361	`login_count` tinyint(1) default NULL,
362	362	`user_name` varchar(255) default NULL
363		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	363	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
364	364
365	365	-- --------------------------------------------------------
…	…
382	382	`mail_addr` varchar(200) default NULL,
383	383	PRIMARY KEY (`mail_id`)
384		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	384	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
385	385
386	386	-- --------------------------------------------------------
…	…
410	410	`status` varchar(255) default NULL,
411	411	PRIMARY KEY (`id`)
412		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	412	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
413	413
414	414	-- --------------------------------------------------------
…	…
424	424	`footer` text,
425	425	PRIMARY KEY (`id`)
426		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	426	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
427	427
428	428	-- --------------------------------------------------------
…	…
443	443	`files_out_avail` int(10) unsigned NOT NULL default '0',
444	444	`files_xfer_avail` int(10) unsigned NOT NULL default '0'
445		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	445	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
446	446
447	447	-- --------------------------------------------------------
…	…
460	460	`files_out_used` int(10) unsigned NOT NULL default '0',
461	461	`files_xfer_used` int(10) unsigned NOT NULL default '0'
462		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	462	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
463	463
464	464	-- --------------------------------------------------------
…	…
492	492	`reseller_ips` text,
493	493	UNIQUE KEY `id` (`id`)
494		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	494	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
495	495
496	496
…	…
508	508	`ip_alias` varchar(200) default NULL,
509	509	UNIQUE KEY `ip_id` (`ip_id`)
510		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	510	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
511	511
512	512	-- --------------------------------------------------------
…	…
531	531	KEY `i_correction` (`correction`),
532	532	KEY `i_traff_time` (`traff_time`)
533		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	533	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
534	534
535	535	-- --------------------------------------------------------
…	…
544	544	`sqld_name` varchar(64) binary default 'n/a',
545	545	UNIQUE KEY `sqld_id` (`sqld_id`)
546		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	546	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
547	547
548	548	-- --------------------------------------------------------
…	…
570	570	`straff_warn` int(10) unsigned default NULL,
571	571	`straff_email` int(10) unsigned default NULL
572		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	572	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
573	573
574	574	--
…	…
591	591	`subdomain_status` varchar(255) default NULL,
592	592	PRIMARY KEY (`subdomain_id`)
593		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	593	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
594	594
595	595	-- --------------------------------------------------------
…	…
606	606	`grp` varchar(255) default NULL,
607	607	PRIMARY KEY (`id`)
608		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	608	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
609	609
610	610	-- --------------------------------------------------------
…	…
622	622	`comment` text,
623	623	UNIQUE KEY `id` (`id`)
624		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	624	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
625	625
626	626	-- --------------------------------------------------------
…	…
642	642	`ticket_message` text,
643	643	PRIMARY KEY (`ticket_id`)
644		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	644	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
645	645
646	646	-- --------------------------------------------------------
…	…
657	657	`logo` varchar(255) NOT NULL default '0',
658	658	UNIQUE KEY `id` (`id`)
659		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	659	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

r614	r624
37	37	UNIQUE KEY `admin_id` (`admin_id`),
38	38	UNIQUE KEY `admin_name` (`admin_name`)
39		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	39	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
40	40
41	41	-- --------------------------------------------------------
…	…
49	49	`msg` varchar(255) default NULL,
50	50	UNIQUE KEY `id` (`id`)
51		) ENGINE=MyISAM DEFAULT CHARSET=utf8~~_general~~_ci;
	51	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
52	52
53	53	-- --------------------------------------------------------
…	…
104	104	`menu_target` varchar(200) NOT NULL default '',
105	105	PRIMARY KEY (`menu_id`)
106		) ENGINE=MyISAM DEFAULT CHARSET=ut