CREATE TABLE `CF_forums` (
`forumid` int(10) NOT NULL auto_increment,
`forumcat` int(5) default NULL,
`forumtitle` varchar(100) collate latin1_general_ci default NULL,
`forumcomment` varchar(200) collate latin1_general_ci default NULL,
`forumorder` int(10) default NULL,
`lastforumposter` varchar(100) collate latin1_general_ci NOT NULL default '',
`lastdatepost` int(11) NOT NULL default '0',
`lastidpost` int(11) NOT NULL default '0',
`forumtopic` int(11) NOT NULL default '0',
`forumposts` int(11) NOT NULL default '0',
`openforum` enum('Y','N') collate latin1_general_ci NOT NULL default 'Y',
PRIMARY KEY (`forumid`)
);