STEP 1) ALTER TABLE users ADD `last_post` datetime NOT NULL default '0000-00-00 00:00:00'; ALTER TABLE forums ADD `forid` tinyint(2) unsigned NOT NULL default '0'; ALTER TABLE topics ADD `pollid` int(10) unsigned NOT NULL default '0'; ALTER TABLE users ADD `forum_access` datetime NOT NULL default '0000-00-00 00:00:00'; ALTER TABLE users ADD `forumpost` enum('yes','no') character set latin1 collate latin1_general_ci NOT NULL default 'yes'; STEP 2) CREATE TABLE `attachmentdownloads` ( `id` int(10) unsigned NOT NULL auto_increment, `filename` varchar(255) NOT NULL default '', `fileid` int(10) NOT NULL default '0', `username` varchar(50) NOT NULL default '', `userid` int(10) NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', `downloads` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM; STEP 3) CREATE TABLE `attachments` ( `id` int(10) unsigned NOT NULL auto_increment, `topicid` int(10) unsigned NOT NULL default '0', `postid` int(10) unsigned NOT NULL default '0', `filename` varchar(255) NOT NULL default '', `size` bigint(20) unsigned NOT NULL default '0', `owner` int(10) unsigned NOT NULL default '0', `downloads` int(10) unsigned NOT NULL default '0', `added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `topicid` (`topicid`) ) ENGINE=MyISAM STEP 4) CREATE TABLE `postpolls` ( `id` int(10) unsigned NOT NULL auto_increment, `added` datetime NOT NULL default '0000-00-00 00:00:00', `question` text NOT NULL, `option0` varchar(40) NOT NULL default '', `option1` varchar(40) NOT NULL default '', `option2` varchar(40) NOT NULL default '', `option3` varchar(40) NOT NULL default '', `option4` varchar(40) NOT NULL default '', `option5` varchar(40) NOT NULL default '', `option6` varchar(40) NOT NULL default '', `option7` varchar(40) NOT NULL default '', `option8` varchar(40) NOT NULL default '', `option9` varchar(40) NOT NULL default '', `option10` varchar(40) NOT NULL default '', `option11` varchar(40) NOT NULL default '', `option12` varchar(40) NOT NULL default '', `option13` varchar(40) NOT NULL default '', `option14` varchar(40) NOT NULL default '', `option15` varchar(40) NOT NULL default '', `option16` varchar(40) NOT NULL default '', `option17` varchar(40) NOT NULL default '', `option18` varchar(40) NOT NULL default '', `option19` varchar(40) NOT NULL default '', `sort` enum('yes','no') NOT NULL default 'no', PRIMARY KEY (`id`) ) ENGINE=MyISAM COMMENT='Post Polls Table' ; STEP 5) CREATE TABLE `postpollanswers` ( `id` int(10) unsigned NOT NULL auto_increment, `pollid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `selection` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `pollid` (`pollid`) ) ENGINE=MyISAM COMMENT='Poll for Forum Posts'; STEP 6) CREATE TABLE `overforums` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(60) NOT NULL default '', `description` varchar(200) default NULL, `minclassview` tinyint(3) unsigned NOT NULL default '0', `forid` tinyint(3) unsigned NOT NULL default '1', `sort` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;