MyBB Documentation


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 post data.

!Field Type Null Key Default Description
pid int(10) No Primary Post ID
tid int(10) No Multiple 0 Thread ID
replyto int(10) No 0 Parent post ID
fid smallint(5) No 0 Forum ID
subject varchar(120) No Post subject
icon smallint(5) No 0 Post icon
uid int(10) No Multiple 0 Author's user ID
username varchar(80) No Author's username
dateline bigint(30) No Multiple 0 UNIX Timestamp of the posting time
message text No Multiple Post content
ipaddress varchar(30) No Author's IP address
longipaddress int(11) No Index 0 Author's Long IP address
includesig int(1) No 0 '1'/'0' to include user's signature
smilieoff int(1) No 0 '1'/'0' to disable/enable smilies
edituid int(10) No 0 User ID of user who last edited the post
edittime int(10) No 0 UNIX Timestamp when post was last edited
visible int(1) No Index 0 Status of the post (visible, unapproved, draft)
posthash varchar(32) No Unique hash used to correlate and limit attachments with posts


Keyname Type Cardinality Field
tid INDEX None tid, uid
uid INDEX None uid
visible INDEX None visible
dateline INDEX None dateline
longipaddress INDEX None longipaddress
message FULLTEXT None message
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