MyBB Documentation

mybb_threads

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 each thread. The posts in each thread are stored in Database Tables/mybb_posts.

Field Type Null Key Default Description
tid int(10) No Primary Thread ID
fid smallint(5) No Multiple 0 Forum ID
subject varchar(120) No Multiple Thread subject
prefix smallint(5) No 0 Thread prefix ID
icon smallint(5) No 0 Post Icon ID
poll int(10) No 0 Poll ID (if one exists)
uid int(10) No Multiple 0 User ID of the author
username varchar(80) No Username of the author
dateline bigint(30) No Multiple 0 UNIX Timestamp of the time the thread was created
firstpost int(10) No Multiple 0 Post ID of the first post
lastpost bigint(30) No Multiple 0 UNIX Timestamp of the time the last post was posted
lastposter varchar(120) No Username of the author who posted the last post
lastposteruid int(10) No 0 User ID of the last poster
views int(100) No 0 Number of thread views
replies int(100) No 0 Number of replies
closed varchar(30) No Closed/moved thread status
sticky int(1) No 0 Sticky thread status
numratings smallint(5) No 0 Number of thread ratings
totalratings smallint(5) No 0 Total ratings value
notes text No Moderator thread notes
visible int(1) No 0 Status of the thread (visible, unapproved, draft)
unapprovedposts int(10) No 0 The number of unapproved posts in the thread
attachmentcount int(10) No 0 The number of attachments in the thread
deletetime int(10) No 0 Used to keep track of moved threads with a "temporary" Moved link (UNIX Timestamp)

Indexes:

Keyname Type Cardinality Field
PRIMARY PRIMARY 0 tid
fid INDEX None fid, visible, sticky
dateline INDEX None dateline
lastpost INDEX None lastpost, fid
firstpost INDEX None firstpost
uid INDEX None uid
subject FULLTEXT None subject
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