CREATE TABLE `tachyforumcounter` ( `userid` int(10) unsigned NOT NULL DEFAULT '0', `forumid` smallint(5) unsigned NOT NULL DEFAULT '0', `threadcount` mediumint(8) unsigned NOT NULL DEFAULT '0', `replycount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`userid`,`forumid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;