DROP TABLE IF EXISTS cdb_forums;
CREATE TABLE cdb_forums (
fid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
fup smallint(6) unsigned NOT NULL DEFAULT '0',
`type` enum('group','forum','sub') NOT NULL DEFAULT 'forum',
`name` char(50) NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT '0',
displayorder tinyint(3) NOT NULL DEFAULT '0',
styleid smallint(6) unsigned NOT NULL DEFAULT '0',
threads mediumint(8) unsigned NOT NULL DEFAULT '0',
posts mediumint(8) unsigned NOT NULL DEFAULT '0',
todayposts mediumint(8) unsigned NOT NULL DEFAULT '0',
lastpost char(110) NOT NULL DEFAULT '',
allowsmilies tinyint(1) NOT NULL DEFAULT '0',
allowhtml tinyint(1) NOT NULL DEFAULT '0',
allowbbcode tinyint(1) NOT NULL DEFAULT '0',
allowimgcode tinyint(1) NOT NULL DEFAULT '0',
allowanonymous tinyint(1) NOT NULL DEFAULT '0',
allowshare tinyint(1) NOT NULL DEFAULT '0',
allowpostspecial tinyint(1) NOT NULL DEFAULT '15',
allowspecialonly tinyint(1) unsigned NOT NULL DEFAULT '0',
alloweditrules tinyint(1) NOT NULL DEFAULT '0',
recyclebin tinyint(1) NOT NULL DEFAULT '0',
modnewposts tinyint(1) NOT NULL DEFAULT '0',
jammer tinyint(1) NOT NULL DEFAULT '0',
disablewatermark tinyint(1) NOT NULL DEFAULT '0',
inheritedmod tinyint(1) NOT NULL DEFAULT '0',
autoclose smallint(6) NOT NULL DEFAULT '0',
forumcolumns tinyint(3) unsigned NOT NULL DEFAULT '0',
threadcaches tinyint(1) NOT NULL DEFAULT '0',
allowpaytoauthor tinyint(1) unsigned NOT NULL DEFAULT '1',
alloweditpost tinyint(1) unsigned NOT NULL DEFAULT '1',
`simple` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (fid),
KEY forum (`status`,`type`,displayorder),
KEY fup (fup)
) TYPE=MyISAM AUTO_INCREMENT=3;
) TYPE=MyISAM;
