{"table_name":"adrotate","full_table_name":"wp_adrotate","description":"Stores adrotate data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS `wp_adrotate` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL DEFAULT '', `bannercode` longtext NOT NULL, `thetime` int(15) NOT NULL default '0', `updated` int(15) NOT NULL, `author` varchar(60) NOT NULL default '', `imagetype` varchar(10) NOT NULL, `image` varchar(255) NOT NULL, `tracker` char(1) NOT NULL default 'N', `show_everyone` char(1) NOT NULL default 'Y', `desktop` char(1) NOT NULL default 'Y', `mobile` char(1) NOT NULL default 'Y', `tablet` char(1) NOT NULL default 'Y', `os_ios` char(1) NOT NULL default 'Y', `os_android` char(1) NOT NULL default 'Y', `type` varchar(10) NOT NULL default '0', `weight` int(3) NOT NULL default '6', `autodelete` char(1) NOT NULL default 'N', `autodisable` char(1) NOT NULL default 'N', `budget` double NOT NULL default '0', `crate` double NOT NULL default '0', `irate` double NOT NULL default '0', `state_req` char(1) NOT NULL default 'N', `cities` text NOT NULL, `states` text NOT NULL, `countries` text NOT NULL, PRIMARY KEY (`id`) ) \".$charset_collate.$engine.\";\");","columns":[{"name":"id","type":"mediumint(8) unsigned","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"bannercode","type":"longtext","nullable":false,"primary_key":false},{"name":"thetime","type":"int(15)","nullable":false,"primary_key":false},{"name":"updated","type":"int(15)","nullable":false,"primary_key":false},{"name":"author","type":"varchar(60)","nullable":false,"primary_key":false},{"name":"imagetype","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"image","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"tracker","type":"char(1)","nullable":false,"primary_key":false},{"name":"show_everyone","type":"char(1)","nullable":false,"primary_key":false},{"name":"desktop","type":"char(1)","nullable":false,"primary_key":false},{"name":"mobile","type":"char(1)","nullable":false,"primary_key":false},{"name":"tablet","type":"char(1)","nullable":false,"primary_key":false},{"name":"os_ios","type":"char(1)","nullable":false,"primary_key":false},{"name":"os_android","type":"char(1)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"weight","type":"int(3)","nullable":false,"primary_key":false},{"name":"autodelete","type":"char(1)","nullable":false,"primary_key":false},{"name":"autodisable","type":"char(1)","nullable":false,"primary_key":false},{"name":"budget","type":"double","nullable":false,"primary_key":false},{"name":"crate","type":"double","nullable":false,"primary_key":false},{"name":"irate","type":"double","nullable":false,"primary_key":false},{"name":"state_req","type":"char(1)","nullable":false,"primary_key":false},{"name":"cities","type":"text","nullable":false,"primary_key":false},{"name":"states","type":"text","nullable":false,"primary_key":false},{"name":"countries","type":"text","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/"}}