{"table_name":"askova_gaps","full_table_name":"wp_askova_gaps","description":"Stores askova gaps data created by this plugin.","detection_method":"static","confidence":"high","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;\");","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}],"plugin":{"slug":"askova","name":"Askova – Smart FAQ Chat","active_installs":0,"version":"2.15.0","wp_org_url":"https://wordpress.org/plugins/askova/"}}