{"slug":"askova","name":"Askova – Smart FAQ Chat","description":"A smart bilingual (Arabic/English) FAQ + AI chatbot: floating widget, WooCommerce search, lead capture, Calendly booking, and analytics.","author":"hossamhamed","active_installs":0,"version":"2.15.0","wp_org_url":"https://wordpress.org/plugins/askova/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"askova_gaps","full_table_name":"wp_askova_gaps","description":"Stores askova gaps data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint unsigned","nullable":false,"primary_key":true},{"name":"question","type":"text","nullable":false,"primary_key":false},{"name":"fingerprint","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"reason","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"occurrences","type":"int unsigned","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"notes","type":"text","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_askova_gaps (id bigint unsigned NOT NULL AUTO_INCREMENT, question text NOT NULL, fingerprint varchar(64) NOT NULL, reason varchar(40) NOT NULL, occurrences int unsigned NOT NULL DEFAULT 1, status varchar(20) NOT NULL DEFAULT 'open', notes text NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY fingerprint (fingerprint)) $c;\");"},{"table_name":"askova_quota","full_table_name":"wp_askova_quota","description":"Stores askova quota data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"day","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"requests","type":"int unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_askova_quota (day varchar(10) NOT NULL, requests int unsigned NOT NULL DEFAULT 0, PRIMARY KEY (day)) $c;\");"},{"table_name":"askova_usage","full_table_name":"wp_askova_usage","description":"Stores askova usage data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint unsigned","nullable":false,"primary_key":true},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"provider","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"model","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"purpose","type":"varchar(24)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"input_tokens","type":"bigint","nullable":true,"primary_key":false},{"name":"output_tokens","type":"bigint","nullable":true,"primary_key":false},{"name":"cost","type":"decimal(18,8)","nullable":true,"primary_key":false},{"name":"latency_ms","type":"int unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_askova_usage (id bigint unsigned NOT NULL AUTO_INCREMENT, created_at datetime NOT NULL, provider varchar(32) NOT NULL, model varchar(255) NOT NULL, purpose varchar(24) NOT NULL, status varchar(32) NOT NULL, input_tokens bigint DEFAULT NULL, output_tokens bigint DEFAULT NULL, cost decimal(18,8) DEFAULT NULL, latency_ms int unsigned NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY created_at (created_at)) $c;\");"},{"table_name":"askova_vectors","full_table_name":"wp_askova_vectors","description":"Stores askova vectors data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"chunk_id","type":"bigint unsigned","nullable":false,"primary_key":false},{"name":"profile","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"vector","type":"longtext","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_askova_vectors (chunk_id bigint unsigned NOT NULL, profile varchar(64) NOT NULL, vector longtext NOT NULL, PRIMARY KEY (chunk_id), KEY profile (profile)) $c;\");"},{"table_name":"wpfaqcb_calendly_bookings","full_table_name":"wp_wpfaqcb_calendly_bookings","description":"Stores wpfaqcb calendly bookings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpfaqcb_faq_views","full_table_name":"wp_wpfaqcb_faq_views","description":"Stores wpfaqcb faq views data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpfaqcb_kb_chunks","full_table_name":"wp_wpfaqcb_kb_chunks","description":"Stores wpfaqcb kb chunks data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpfaqcb_kb_files","full_table_name":"wp_wpfaqcb_kb_files","description":"Stores wpfaqcb kb files data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpfaqcb_ratings","full_table_name":"wp_wpfaqcb_ratings","description":"Stores wpfaqcb ratings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpfaqcb_submissions","full_table_name":"wp_wpfaqcb_submissions","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":10}