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 online session data.

Field Type Null Key Default Description
sid varchar(32) No Primary Session ID
uid int(10) No Multiple 0 User ID
ip varchar(40) No IP address
time bigint(30) No Multiple 0 UNIX timestamp of the last time of activity
location varchar(150) No User's location
useragent varchar(100) No User's user agent
anonymous int(1) No 0 Whether or not user is browsing anonymously (invisible)
nopermission int(1) No 0 Whether or not user is viewing a "no permission" page
location1 int(10) No Multiple 0 More specific location information
location2 int(10) No Multiple 0 More specific location information
loginattempts tinyint(2) No 1 The number of login attempts attempted to be made on this accout
failedlogin bigint(30) No 0 The number of failed login attempts on this account (every time a user has reached the limit of login attempts)


Keyname Type Cardinality Field
location1 INDEX None location1
location2 INDEX None location2
time INDEX None time
uid INDEX None uid
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