MyBB Documentation

mybb_forums

The 1.6 Documentation is no longer maintained and some information may be outdated.

The MyBB 1.6 series reached end of life on October 1, 2015.

This means there will be no more security or maintenance releases for these series and forums running these versions of MyBB may be at risk of unfixed security issues. All administrators are strongly encouraged to upgrade their forums to the latest release of MyBB as soon as possible.

Stores the information about the forums (and categories).

Field Type Null Key Default Description
fid smallint(5) No Primary Forum ID
name varchar(120) No Name of the forum
description text No Forum description
linkto varchar(180) No External link (redirect forum)
type char(1) No 'f' or 'c' indicating forum or category respectively
pid smallint(5) No 0 Parent forum ID
parentlist text No Comma-delimited list of the forum's parent tree
disporder smallint(5) No 0 Display order
active int(1) No 0 '1'/'0' indicating whether the forum is active or not
open int(1) No 0 '1'/'0' indicating whether the forum is open or not
threads int(10) No 0 Number of threads
posts int(10) No 0 Number of posts
lastpost int(10) No 0 UNIX timestamp of the last post
lastposter varchar(120) No Username of the last poster
lastposteruid int(10) No 0 User ID of the last poster
lastposttid int(10) No 0 Thread ID containing the last post
lastpostsubject varchar(120) No Subject of the last post
allowhtml int(1) No 0 '1'/'0' permission allowing HTML to be parsed
allowmycode int(1) No 0 '1'/'0' permission allowing MyCode to be parsed
allowsmilies int(1) No 0 '1'/'0' permission allowing Smilies to be parsed
allowimgcode int(1) No 0 '1'/'0' permission allowing [img] codes to be parsed
allowvideocode int(1) No 0 '1'/'0' permission allowing [video] codes to be parsed
allowpicons int(1) No 0 '1'/'0' permission allowing post icons to be used
allowtratings int(1) No 0 '1'/'0' permission allowing thread ratings
status int(4) No 1 An integer
usepostcounts int(1) No '1'/'0' indicating whether or not users' post counts are incremented
password varchar(50) No Forum password
showinjump int(1) No 0 '1'/'0' to show this forum in the forum jump
modposts int(1) No 0 '1'/'0' to moderate posts
modthreads int(1) No 0 '1'/'0' to moderate threads
mod_edit_posts int(1) No 0 '1'/'0' to moderate posts after they are edited
modattachments int(1) No 0 '1'/'0' to moderate attachments
style smallint(5) No 0 Theme ID for this forum
overridestyle int(1) No 0 '1'/'0' to override user's chosen style
rulestype smallint(1) No 0 Type of rules
rulestitle varchar(200) No Title of the forum rules
rules text No Forum rules
unapprovedthreads int(10) No 0 The number of unapproved threads in the forum
unapprovedposts int(10) No 0 The number of unapproved posts in the forum
defaultdatecut smallint(4) No 0 The default date cut for threads to be displayed
defaultsortby varchar(10) No The default sort column of the threads displayed in the forum
defaultsortorder varchar(4) No The default sort order of the threads displayed in the forum

Indexes:

Keyname Type Cardinality Field
PRIMARY PRIMARY 2 fid
MyBB Documentation
Front End Index Page - Portal - Forum Display - Thread Display - Posting Threads and Replies - Searching - User CP - Member Profile - Private Messages - Calendar - Member List - Help Docs - Who Is Online - Lite (Archive) Mode - Forum Team - Statistics - RSS Syndication - Miscellaneous
Moderation Standard Thread Moderation - Inline Thread Moderation - Inline Post Moderation - Warning System
Mod CP Home - Forums and Posts - Users
Admin CP Home - Configuration - Forums & Posts - Users & Groups - Templates & Style - Tools & Maintenance
Templates & Themes Images - Postbit - Templates - Themes
Developer Database Methods - Database Tables
Miscellaneous Cookies - UTF8 Setup - Default Settings

Edit this page on GitHub