{"slug":"speedy-search","name":"Snappy Search","description":"A fast, lightweight search plugin powered by TNTSearch, indexing posts for near instant, accurate results.","author":"Poly Plugins","active_installs":0,"version":"1.6.0","wp_org_url":"https://wordpress.org/plugins/speedy-search/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"doclist","full_table_name":"wp_doclist","description":"Stores doclist data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"term_id","type":"INTEGER","nullable":true,"primary_key":false},{"name":"doc_id","type":"INTEGER","nullable":true,"primary_key":false},{"name":"hit_count","type":"INTEGER","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS doclist ( term_id INTEGER, doc_id INTEGER, hit_count INTEGER)\");"},{"table_name":"fields","full_table_name":"wp_fields","description":"Stores fields data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INTEGER","nullable":true,"primary_key":true},{"name":"name","type":"TEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS fields ( id INTEGER PRIMARY KEY, name TEXT)\");"},{"table_name":"filemap","full_table_name":"wp_filemap","description":"Stores filemap data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INTEGER","nullable":true,"primary_key":true},{"name":"path","type":"TEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS filemap ( id INTEGER PRIMARY KEY, path TEXT)');"},{"table_name":"hitlist","full_table_name":"wp_hitlist","description":"Stores hitlist data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"term_id","type":"INTEGER","nullable":true,"primary_key":false},{"name":"doc_id","type":"INTEGER","nullable":true,"primary_key":false},{"name":"field_id","type":"INTEGER","nullable":true,"primary_key":false},{"name":"position","type":"INTEGER","nullable":true,"primary_key":false},{"name":"hit_count","type":"INTEGER","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS hitlist ( term_id INTEGER, doc_id INTEGER, field_id INTEGER, position INTEGER, hit_count INTEGER)\");"},{"table_name":"info","full_table_name":"wp_info","description":"Stores info data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"value","type":"INTEGER","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS info (key TEXT, value INTEGER)\");"},{"table_name":"locations","full_table_name":"wp_locations","description":"Stores locations data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"doc_id","type":"INTEGER","nullable":true,"primary_key":false},{"name":"longitude","type":"REAL","nullable":true,"primary_key":false},{"name":"latitude","type":"REAL","nullable":true,"primary_key":false},{"name":"cos_lat","type":"REAL","nullable":true,"primary_key":false},{"name":"sin_lat","type":"REAL","nullable":true,"primary_key":false},{"name":"cos_lng","type":"REAL","nullable":true,"primary_key":false},{"name":"sin_lng","type":"REAL","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS locations ( doc_id INTEGER, longitude REAL, latitude REAL, cos_lat REAL, sin_lat REAL, cos_lng REAL, sin_lng REAL )\");"},{"table_name":"ss_term_logs","full_table_name":"wp_ss_term_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wordlist","full_table_name":"wp_wordlist","description":"Stores wordlist data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INTEGER","nullable":true,"primary_key":true},{"name":"term","type":"TEXT","nullable":true,"primary_key":false},{"name":"num_hits","type":"INTEGER","nullable":true,"primary_key":false},{"name":"num_docs","type":"INTEGER","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wordlist ( id INTEGER PRIMARY KEY, term TEXT UNIQUE COLLATE nocase, num_hits INTEGER, num_docs INTEGER)\");"}],"table_count":8}