Hier mein Grosser =)
Code:
DROP TABLE IF EXISTS `command_log`;
CREATE TABLE `command_log` (
`userid` int(11) DEFAULT NULL,
`server` int(11) DEFAULT NULL,
`ip` text,
`port` int(11) DEFAULT NULL,
`username` varchar(12) CHARACTER SET big5 NOT NULL DEFAULT 'NONAME',
`command` varchar(20) CHARACTER SET big5 COLLATE big5_bin DEFAULT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;