Fud30 search cache

From FUDforum Wiki
Jump to: navigation, search

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

fud30_action log | fud30_ann forums | fud30_announce | fud30_attach | fud30_avatar | fud30_blocked_logins | fud30_bookmarks | fud30_buddy | fud30_calendar | fud30_cat | fud30_custom_fields | fud30_custom_tags | fud30_email_block | fud30_ext_block | fud30_fc_view | fud30_fl_1 | fud30_fl_pg | fud30_fl_pm | fud30_forum | fud30_forum_notify | fud30_forum_read | fud30_geoip | fud30_group_cache | fud30_group_members | fud30_group_resources | fud30_groups | fud30_index | fud30_ip_block | fud30_jobs | fud30_level | fud30_mime | fud30_mlist | fud30_mod | fud30_msg | fud30_msg_report | fud30_msg_store | fud30_nntp | fud30_pages | fud30_plugins | fud30_pmsg | fud30_poll | fud30_poll_opt | fud30_poll_opt_track | fud30_read | fud30_replace | fud30_search | fud30_search cache | fud30_ses | fud30_smiley | fud30_spiders | fud30_stats_cache | fud30_themes | fud30_thr_exchange | fud30_thread | fud30_thread_notify | fud30_thread_rate_track | fud30_title_index | fud30_tv_1 | fud30_user_ignore | fud30_users | fud30_xmlagg

Languages
Personal tools
This is a cached copy of the requested page, and may not be up to date.

Sorry! This site is experiencing technical difficulties.
Try waiting a few minutes and reloading.

(Can't contact the database server: Cannot return last error, no db connection)


You can try searching via Google in the meantime.
Note that their indexes of our content may be out of date.