Off topic but same topic hope you like guys here is the revenge for what he done to you in early times let it pour down rain yo!
Code:
CREATE TABLE `forums` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`order` smallint(5) unsigned NOT NULL DEFAULT '0',
`title` tinyblob,
`description` blob,
`icon` enum('star.png','staff.png','member.png') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'member.png',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `forums_permission` (
`forumid` int(10) unsigned NOT NULL DEFAULT '0',
`groupid` int(10) unsigned NOT NULL DEFAULT '1',
`permissons` enum('member','staff','owner','anonymous') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'member',
`minreadclass` tinyint(3) unsigned NOT NULL DEFAULT '0',
`mincreateclass` tinyint(3) unsigned NOT NULL DEFAULT '0',
`minwriteclass` tinyint(3) unsigned NOT NULL DEFAULT '0',
UNIQUE KEY `forumid` (`forumid`, `groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
compare with TSUE 2.2
