MyBB Documentation

mybb_searchlog

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 searches.

Field Type Null Key Default Description
sid varchar(32) No Primary Search ID
uid int(10) No 0 User ID
dateline bigint(30) No 0 UNIX timestamp when search was created
ipaddress varchar(120) No IP address of the searcher
threads longtext No Cache of threads from the resulting search
posts longtext No Cache of posts from the resulting search
resulttype varchar(10) No The type of result
querycache text No The cache of the query used
keywords text No Keywords used in the search


Indexes:

Keyname Type Cardinality Field
PRIMARY PRIMARY 0 sid
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