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