-- ---------------------------- 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; -- ---------------------------- -- command_log -- ----------------------------