{"table_name":"amazon_listings","full_table_name":"wp_amazon_listings","description":"Stores amazon listings data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_listings` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `asin` varchar(64) DEFAULT NULL, `sku` varchar(64) DEFAULT NULL, `listing_title` varchar(255) DEFAULT NULL, `listing_type` varchar(255) DEFAULT NULL, `date_created` datetime DEFAULT NULL, `date_published` datetime DEFAULT NULL, `price` float DEFAULT NULL, `quantity` int(11) DEFAULT NULL, `quantity_sold` int(11) DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `details` text, `attributes` text, `history` text, `url` varchar(255) DEFAULT NULL, `description` text, `post_id` int(11) DEFAULT NULL, `profile_id` int(11) DEFAULT NULL, `fees` float DEFAULT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"asin","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"sku","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"listing_title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"listing_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date_created","type":"datetime","nullable":true,"primary_key":false},{"name":"date_published","type":"datetime","nullable":true,"primary_key":false},{"name":"price","type":"float","nullable":true,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":true,"primary_key":false},{"name":"quantity_sold","type":"int(11)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"details","type":"text","nullable":true,"primary_key":false},{"name":"attributes","type":"text","nullable":true,"primary_key":false},{"name":"history","type":"text","nullable":true,"primary_key":false},{"name":"url","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"profile_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"fees","type":"float","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-lister-for-amazon","name":"WP-Lister Lite for Amazon","active_installs":800,"version":"2.9.1","wp_org_url":"https://wordpress.org/plugins/wp-lister-for-amazon/"}}