{"table_name":"adrotate_tracker","full_table_name":"wp_adrotate_tracker","description":"Stores adrotate tracker data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_adrotate_tracker` ( `id` bigint(9) unsigned NOT NULL auto_increment, `ipaddress` varchar(15) NOT NULL default '0', `timer` int(15) unsigned NOT NULL default '0', `bannerid` int(15) unsigned NOT NULL default '0', `stat` char(1) NOT NULL default 'c', PRIMARY KEY (`id`), KEY `ipaddress` (`ipaddress`), KEY `timer` (`timer`) ) \".$charset_collate.$engine.\";\");","columns":[{"name":"id","type":"bigint(9) unsigned","nullable":false,"primary_key":true},{"name":"ipaddress","type":"varchar(15)","nullable":false,"primary_key":false},{"name":"timer","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"bannerid","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"stat","type":"char(1)","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/"}}