CREATE TABLE `irclogs` (
  `stamp` int(12) default NULL,
  `channel` varchar(40) NOT NULL default '',
  `user` varchar(40) default NULL,
  `action` enum('v','a','n') NOT NULL default 'v',
  `data` text,
  KEY `channel` (`channel`,`user`)
);