DROP TABLE IF EXISTS `threads`; CREATE TABLE `threads` ( `id` int(100) NOT NULL auto_increment, `pinned` set('1','0') NOT NULL default '0', `locked` set('1','0') NOT NULL default '0', `title` varchar(255) default NULL, `posterId` int(100) default NULL, `date` int(10) default NULL, `views` int(100) default NULL, `inForum` int(100) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;