{"table_name":"burst_search_terms","full_table_name":"wp_burst_search_terms","description":"Stores burst search terms data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_burst_search_terms ( `ID` int NOT NULL AUTO_INCREMENT, `date` date NOT NULL, `query` varchar(191) NOT NULL, `property` varchar(191) NOT NULL, `clicks` int NOT NULL DEFAULT 0, `impressions` int NOT NULL DEFAULT 0, `ctr` float NOT NULL DEFAULT 0, `position` float NOT NULL DEFAULT 0, PRIMARY KEY (ID) ) $charset_collate;\" );","columns":[{"name":"ID","type":"int","nullable":false,"primary_key":true},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"query","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"property","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"clicks","type":"int","nullable":false,"primary_key":false},{"name":"impressions","type":"int","nullable":false,"primary_key":false},{"name":"ctr","type":"float","nullable":false,"primary_key":false},{"name":"position","type":"float","nullable":false,"primary_key":false}],"plugin":{"slug":"burst-statistics","name":"Burst Statistics – Simple WordPress Analytics (Google Analytics Alternative)","active_installs":200000,"version":"3.6.2","wp_org_url":"https://wordpress.org/plugins/burst-statistics/"}}