CREATE TABLE `messages` (
  `id` int(11) NOT NULL auto_increment,
  `body` text NOT NULL,
  `created_at` datetime NOT NULL,
  `channel` int(11) NOT NULL,
  `ircuser` int(11) NOT NULL,
  `vectors` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`),
  KEY `ircuser` (`ircuser`),
  KEY `channel` (`channel`),
  KEY `created_at` (`created_at`),
  KEY `ircuser_2` (`ircuser`),
  KEY `channel_2` (`channel`),
  FULLTEXT KEY `body` (`body`)
) ENGINE=MyISAM AUTO_INCREMENT=775289 DEFAULT CHARSET=latin1