DROP TABLE IF EXISTS `logs`; -- create logs table CREATE TABLE `logs` ( `time` int(14) NOT NULL, `realm` int(4) NOT NULL, `type` int(4) NOT NULL, `string` text ) ENGINE=MyISAM DEFAULT CHARSET=latin1;