Description of FUDforum table fud30_search_cache. This table is used to cache search requests.
Fields
| Column Name | Datatype | Can be Null? | Key? | Default | Description
|
| srch_query | varchar(32) | NO | MUL | | Hash of query keys.
|
| query_type | int(11) | NO | | 0 | Type of query: 0 == index; 1 == title_index.
|
| expiry | int(11) | NO | MUL | 0 | Expiry time.
|
| msg_id | int(11) | NO | | 0 | References fud30_msg.id.
|
| n_match | int(11) | NO | | 0 | Number of matches.
|
Keys
| Index Name | Uniqueness | Column Name | Seq in index | Comments
|
| fud30_search_cache_i_sq | NOT UNIQUE | srch_query | 1 |
|
| fud30_search_cache_i_sq | NOT UNIQUE | query_type | 2 |
|
| fud30_search_cache_i_e | NOT UNIQUE | expiry | 1 |
|