fud30_search cache
Description of FUDforum table fud30_search_cache. This table is used to cache search requests.
| 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. |
| 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 |
