Anonymous

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 ;