{"table_name":"adrotate_stats_archive","full_table_name":"wp_adrotate_stats_archive","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS `wp_adrotate_stats_archive` ( `id` bigint(9) unsigned NOT NULL auto_increment, `ad` int(5) unsigned NOT NULL default '0', `group` int(5) unsigned NOT NULL default '0', `thetime` int(15) unsigned NOT NULL default '0', `clicks` int(15) unsigned NOT NULL default '0', `impressions` int(15) unsigned NOT NULL default '0', PRIMARY KEY (`id`), INDEX `ad_thetime` (`ad`, `thetime`), INDEX `thetime` (`thetime`) ) \".$charset_collate.$engine.\";\");","columns":[{"name":"id","type":"bigint(9) unsigned","nullable":false,"primary_key":true},{"name":"ad","type":"int(5) unsigned","nullable":false,"primary_key":false},{"name":"group","type":"int(5) unsigned","nullable":false,"primary_key":false},{"name":"thetime","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"clicks","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"impressions","type":"int(15) unsigned","nullable":false,"primary_key":false}],"plugin":{"slug":"adrotate","name":"AdRotate Banner Manager","active_installs":20000,"version":"5.17.5","wp_org_url":"https://wordpress.org/plugins/adrotate/"}}