{"table_name":"ahc_site_searches","full_table_name":"wp_ahc_site_searches","description":"Stores ahc site searches data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `ahc_site_searches` ( `srch_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` INT(11) NOT NULL DEFAULT 1, `srch_date` DATE NOT NULL, `srch_term` VARCHAR(100) NOT NULL, `srch_count` INT(11) UNSIGNED NOT NULL DEFAULT 0, `srch_results` INT(11) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`srch_id`), UNIQUE KEY `ahcfree_uq_site_date_term` (`site_id`, `srch_date`, `srch_term`) ) DEFAULT CHARSET","columns":[{"name":"srch_id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"site_id","type":"INT(11)","nullable":false,"primary_key":false},{"name":"srch_date","type":"DATE","nullable":false,"primary_key":false},{"name":"srch_term","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"srch_count","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false},{"name":"srch_results","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false}],"plugin":{"slug":"visitors-traffic-real-time-statistics","name":"Visitor Traffic Real Time Statistics","active_installs":30000,"version":"8.18","wp_org_url":"https://wordpress.org/plugins/visitors-traffic-real-time-statistics/"}}