fud30_search cache - fudforum/FUDforum GitHub Wiki

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
⚠️ **GitHub.com Fallback** ⚠️