This article or section is outdated.
- Parts of this article or section have been written for MyBB version 1.2 and is no longer up to date.
Contributors: Please update the article to reflect the current MyBB version, and remove this template when finished.
[edit] mybb_searchlog
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 | text | No |
|
| Cache of threads from the resulting search
|
| posts | text | No |
|
| Cache of posts from the resulting search
|
| searchtype | varchar(10) | No |
|
| The type of search being run
|
| resulttype | varchar(10) | No |
|
| The type of result
|
| querycache | text | No |
|
| The cache of the query used
|
Indexes:
| Keyname | Type | Cardinality | Field
|
| PRIMARY | PRIMARY | 0 | sid
|