CREATE TABLE `chat` (
	  `datetime` datetime DEFAULT NULL,
	  `id` int(11) NOT NULL AUTO_INCREMENT,
	  `channel` varchar(15) DEFAULT NULL,
	  `type` enum('action','public','join','part','topic','nick','kick','quit') DEFAULT NULL,
	  `nick` varchar(15) DEFAULT NULL,
	  `message` text,
	  `server` varchar(15) DEFAULT NULL,
	  PRIMARY KEY (`id`),
	  KEY `nick` (`nick`),
	  KEY `datetime` (`datetime`),
	  KEY `channel` (`channel`),
	  KEY `channel_nick` (`nick`,`channel`),
	  KEY `idx_nick_datetime` (`nick`,`datetime`,`channel`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1