CREATE TABLE `pb_threads` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `title` varchar(128) NOT NULL,
  `status` set('onhold','deleted','closed','fixed','open') NOT NULL default 'open',
  `boardId` int(10) unsigned NOT NULL default '0',
  `readCount` int(10) unsigned NOT NULL default '0',
  `messagecount` bigint(20) NOT NULL default '0',
  `lastAction` datetime default NULL,
  `approved_by` int(10) default NULL,
  `pollText` text default NULL,
  `pollState` varchar(8) default NULL,
  `lastVote` datetime default NULL,
  `voteCount` int(10) default NULL,
  `voted` varchar(128) default NULL,
  PRIMARY KEY  (`id`),
  KEY `lastAction` (`lastAction`),
  KEY `boardId` (`boardId`),
  KEY `status` (`status`)
);