{"slug":"wp-lister-for-amazon","name":"WP-Lister Lite for Amazon","description":"List products from WordPress on Amazon.","author":"WP Lab","active_installs":800,"version":"2.9.1","wp_org_url":"https://wordpress.org/plugins/wp-lister-for-amazon/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"amazon_accounts","full_table_name":"wp_amazon_accounts","description":"Stores amazon accounts data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"title","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"merchant_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"marketplace_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"access_key_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"secret_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"market_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"market_code","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"config","type":"text","nullable":false,"primary_key":false},{"name":"sync_orders","type":"int(11)","nullable":true,"primary_key":false},{"name":"sync_products","type":"int(11)","nullable":true,"primary_key":false},{"name":"last_orders_sync","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_accounts` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(128) NOT NULL, `merchant_id` varchar(32) NOT NULL DEFAULT '', `marketplace_id` varchar(32) NOT NULL DEFAULT '', `access_key_id` varchar(32) NOT NULL DEFAULT '', `secret_key` varchar(64) NOT NULL DEFAULT '', `market_id` int(11) DEFAULT NULL, `market_code` varchar(16) DEFAULT NULL, `config` text NOT NULL, `sync_orders` int(11) DEFAULT NULL, `sync_products` int(11) DEFAULT NULL, `last_orders_sync` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"amazon_btg","full_table_name":"wp_amazon_btg","description":"Stores amazon btg data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"node_id","type":"bigint(16)","nullable":true,"primary_key":false},{"name":"parent_id","type":"bigint(16)","nullable":true,"primary_key":false},{"name":"top_id","type":"bigint(16)","nullable":true,"primary_key":false},{"name":"level","type":"int(11)","nullable":true,"primary_key":false},{"name":"leaf","type":"tinyint(4)","nullable":true,"primary_key":false},{"name":"keyword","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"node_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"node_path","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"site_id","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_btg` ( `id` int(11) NOT NULL AUTO_INCREMENT, `node_id` bigint(16) DEFAULT NULL, `parent_id` bigint(16) DEFAULT NULL, `top_id` bigint(16) DEFAULT NULL, `level` int(11) DEFAULT NULL, `leaf` tinyint(4) DEFAULT NULL, `keyword` varchar(255) DEFAULT NULL, `node_name` varchar(255) DEFAULT NULL, `node_path` varchar(255) DEFAULT NULL, `site_id` int(11) DEFAULT NULL, KEY `node_id` (`node_id`), KEY `parent_id` (`parent_id`), KEY `top_id` (`top_id`), KEY `keyword` (`keyword`), PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"amazon_categories","full_table_name":"wp_amazon_categories","description":"Stores amazon categories data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"cat_id","type":"bigint(16)","nullable":true,"primary_key":false},{"name":"parent_cat_id","type":"bigint(11)","nullable":true,"primary_key":false},{"name":"level","type":"int(11)","nullable":true,"primary_key":false},{"name":"leaf","type":"tinyint(4)","nullable":true,"primary_key":false},{"name":"version","type":"int(11)","nullable":true,"primary_key":false},{"name":"cat_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"wp_term_id","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_categories` ( `cat_id` bigint(16) DEFAULT NULL, `parent_cat_id` bigint(11) DEFAULT NULL, `level` int(11) DEFAULT NULL, `leaf` tinyint(4) DEFAULT NULL, `version` int(11) DEFAULT NULL, `cat_name` varchar(255) DEFAULT NULL, `wp_term_id` int(11) DEFAULT NULL, KEY `cat_id` (`cat_id`), KEY `parent_cat_id` (`parent_cat_id`) ) DEFAULT CHARSET"},{"table_name":"amazon_feed_templates","full_table_name":"wp_amazon_feed_templates","description":"Stores amazon feed templates data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"version","type":"varchar(32)","nullable":true,"primary_key":false},{"name":"site_id","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_feed_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `version` varchar(32) DEFAULT NULL, `site_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"amazon_feed_tpl_data","full_table_name":"wp_amazon_feed_tpl_data","description":"Stores amazon feed tpl data data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"field","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"label","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"definition","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"accepted","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"example","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"group_id","type":"varchar(32)","nullable":true,"primary_key":false},{"name":"required","type":"varchar(32)","nullable":true,"primary_key":false},{"name":"group","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tpl_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"site_id","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_feed_tpl_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `field` varchar(255) DEFAULT NULL, `label` varchar(255) DEFAULT NULL, `definition` varchar(255) DEFAULT NULL, `accepted` varchar(255) DEFAULT NULL, `example` varchar(255) DEFAULT NULL, `group_id` varchar(32) DEFAULT NULL, `required` varchar(32) DEFAULT NULL, `group` varchar(255) DEFAULT NULL, `tpl_id` int(11) DEFAULT NULL, `site_id` int(11) DEFAULT NULL, KEY `id` (`id`), KEY `field` (`field`), KEY `required` (`required`), KEY `group_id` (`group_id`), KEY `tpl_id` (`tpl_id`), PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"amazon_feed_tpl_values","full_table_name":"wp_amazon_feed_tpl_values","description":"Stores amazon feed tpl values data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"field","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"label","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"values","type":"text","nullable":true,"primary_key":false},{"name":"tpl_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"site_id","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_feed_tpl_values` ( `id` int(11) NOT NULL AUTO_INCREMENT, `field` varchar(255) DEFAULT NULL, `label` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `values` text DEFAULT NULL, `tpl_id` int(11) DEFAULT NULL, `site_id` int(11) DEFAULT NULL, KEY `id` (`id`), KEY `field` (`field`), KEY `tpl_id` (`tpl_id`), PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"amazon_feeds","full_table_name":"wp_amazon_feeds","description":"Stores amazon feeds data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"FeedSubmissionId","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"FeedType","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"FeedProcessingStatus","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"results","type":"text","nullable":true,"primary_key":false},{"name":"success","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"SubmittedDate","type":"datetime","nullable":true,"primary_key":false},{"name":"CompletedProcessingDate","type":"datetime","nullable":true,"primary_key":false},{"name":"date_created","type":"datetime","nullable":true,"primary_key":false},{"name":"MarketplaceIdList","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"account_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"line_count","type":"int(11)","nullable":true,"primary_key":false},{"name":"data","type":"mediumblob","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_feeds` ( `id` int(11) NOT NULL AUTO_INCREMENT, `FeedSubmissionId` varchar(64) DEFAULT NULL, `FeedType` varchar(64) DEFAULT NULL, `FeedProcessingStatus` varchar(64) DEFAULT '', `results` text, `success` varchar(16) DEFAULT NULL, `status` varchar(16) DEFAULT NULL, `SubmittedDate` datetime DEFAULT NULL, `CompletedProcessingDate` datetime DEFAULT NULL, `date_created` datetime DEFAULT NULL, `MarketplaceIdList` varchar(255) DEFAULT NULL, `account_id` int(11) DEFAULT NULL, `line_count` int(11) DEFAULT NULL, `data` mediumblob, PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"amazon_fulfillment_feed_items","full_table_name":"wp_amazon_fulfillment_feed_items","description":"Stores amazon fulfillment feed items data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"feed_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"order_item_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"ship_date","type":"datetime","nullable":false,"primary_key":false},{"name":"carrier_code","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"carrier_name","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"tracking_number","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"ship_method","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"ship_from_address_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ship_from_address_line1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ship_from_address_line2","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ship_from_address_city","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"ship_from_address_state","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"ship_from_address_postal","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"ship_from_address_country","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"date_added","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_amazon_fulfillment_feed_items` ( `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `feed_id` int(11) NOT NULL, `order_id` varchar(64) NOT NULL, `order_item_id` varchar(64) NOT NULL, `quantity` int(11) NOT NULL, `ship_date` datetime NOT NULL, `carrier_code` varchar(64) NOT NULL, `carrier_name` varchar(128) NOT NULL, `tracking_number` varchar(128) NOT NULL, `ship_method` varchar(128) NOT NULL, `ship_from_address_name` varchar(255) NOT NULL, `ship_from_address_line1` varchar(255) NOT NULL, `ship_from_address_line2` varchar(255) NOT NULL, `ship_from_address_city` varchar(128) NOT NULL, `ship_from_address_state` varchar(128) NOT NULL, `ship_from_address_postal` varchar(64) NOT NULL, `ship_from_address_country` varchar(128) NOT NULL, `date_added` datetime NOT NULL );"},{"table_name":"amazon_jobs","full_table_name":"wp_amazon_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"job_key","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"job_name","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"tasklist","type":"text","nullable":true,"primary_key":false},{"name":"results","type":"text","nullable":true,"primary_key":false},{"name":"success","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"date_created","type":"datetime","nullable":true,"primary_key":false},{"name":"date_finished","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_jobs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `job_key` varchar(64) DEFAULT NULL, `job_name` varchar(64) DEFAULT NULL, `tasklist` text DEFAULT NULL, `results` text DEFAULT NULL, `success` varchar(16) DEFAULT NULL, `date_created` datetime DEFAULT NULL, `date_finished` datetime DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"amazon_listings","full_table_name":"wp_amazon_listings","description":"Stores amazon listings data created by this plugin.","detection_method":"static","confidence":"high","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}],"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"},{"table_name":"amazon_log","full_table_name":"wp_amazon_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"timestamp","type":"datetime","nullable":true,"primary_key":false},{"name":"request_url","type":"text","nullable":true,"primary_key":false},{"name":"request","type":"text","nullable":true,"primary_key":false},{"name":"response","type":"text","nullable":true,"primary_key":false},{"name":"result","type":"text","nullable":true,"primary_key":false},{"name":"callname","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"success","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"amazon_id","type":"bigint(255)","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"curl","type":"text","nullable":true,"primary_key":false},{"name":"parameters","type":"text","nullable":true,"primary_key":false},{"name":"account_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"market_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"http_code","type":"varchar(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `timestamp` datetime DEFAULT NULL, `request_url` text, `request` text, `response` text, `result` text, `callname` varchar(64) DEFAULT NULL, `success` varchar(16) DEFAULT NULL, `amazon_id` bigint(255) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `curl` text, `parameters` text, `account_id` int(11) DEFAULT NULL, `market_id` int(11) DEFAULT NULL, `http_code` varchar(11) DEFAULT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"amazon_markets","full_table_name":"wp_amazon_markets","description":"Stores amazon markets data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"developer_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"code","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"url","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"enabled","type":"tinyint(2) unsigned","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"group_title","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_markets` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `developer_id` varchar(32) NOT NULL, `title` varchar(255) NOT NULL, `code` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `enabled` tinyint(2) unsigned NOT NULL DEFAULT '0', `sort_order` int(11) unsigned NOT NULL DEFAULT '0', `group_title` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"amazon_orders","full_table_name":"wp_amazon_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"order_id","type":"varchar(128)","nullable":true,"primary_key":false},{"name":"date_created","type":"datetime","nullable":true,"primary_key":false},{"name":"total","type":"float","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"items","type":"text","nullable":true,"primary_key":false},{"name":"details","type":"text","nullable":true,"primary_key":false},{"name":"history","type":"text","nullable":true,"primary_key":false},{"name":"buyer_userid","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"buyer_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"buyer_email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"CheckoutStatus","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ShippingService","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"PaymentMethod","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ShippingAddress_City","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"CompleteStatus","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"LastTimeModified","type":"datetime","nullable":true,"primary_key":false},{"name":"account_id","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_orders` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `order_id` varchar(128) DEFAULT NULL, `date_created` datetime DEFAULT NULL, `total` float DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `post_id` int(11) DEFAULT NULL, `items` text, `details` text, `history` text, `buyer_userid` varchar(255) DEFAULT NULL, `buyer_name` varchar(255) DEFAULT NULL, `buyer_email` varchar(255) DEFAULT NULL, `CheckoutStatus` varchar(50) DEFAULT NULL, `ShippingService` varchar(50) DEFAULT NULL, `PaymentMethod` varchar(50) DEFAULT NULL, `ShippingAddress_City` varchar(50) DEFAULT NULL, `CompleteStatus` varchar(50) DEFAULT NULL, `LastTimeModified` datetime DEFAULT NULL, `account_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"amazon_payment","full_table_name":"wp_amazon_payment","description":"Stores amazon payment data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"payment_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payment_description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"version","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_payment` ( `payment_name` varchar(255) DEFAULT NULL, `payment_description` varchar(255) DEFAULT NULL, `version` int(11) DEFAULT NULL ) DEFAULT CHARSET"},{"table_name":"amazon_product_types","full_table_name":"wp_amazon_product_types","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(11)","nullable":false,"primary_key":true},{"name":"marketplace_id","type":"varchar(25)","nullable":false,"primary_key":false},{"name":"product_type","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"display_name","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"version","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"property_groups","type":"longtext","nullable":false,"primary_key":false},{"name":"schema","type":"longtext","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_product_types` ( `id` bigint(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `marketplace_id` varchar(25) NOT NULL, `product_type` varchar(100) NOT NULL, `display_name` varchar(150) NOT NULL, `version` varchar(100) NOT NULL, `property_groups` longtext NOT NULL, `schema` longtext NOT NULL );"},{"table_name":"amazon_profiles","full_table_name":"wp_amazon_profiles","description":"Stores amazon profiles data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_profiles` ( // `profile_id` int(11) unsigned NOT NULL AUTO_INCREMENT, // `profile_name` varchar(255) DEFAULT NULL, // `profile_description` varchar(255) DEFAULT NULL, // `listing_duration` varchar(255) DEFAULT NULL, // `type` varchar(255) DEFAULT NULL, // `details` text, // `conditions` text, // PRIMARY KEY (`profile_id`) // ) DEFAULT CHARSET"},{"table_name":"amazon_reports","full_table_name":"wp_amazon_reports","description":"Stores amazon reports data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"ReportRequestId","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"ReportType","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"ReportProcessingStatus","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"results","type":"text","nullable":true,"primary_key":false},{"name":"success","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"SubmittedDate","type":"datetime","nullable":true,"primary_key":false},{"name":"StartedProcessingDate","type":"datetime","nullable":true,"primary_key":false},{"name":"CompletedDate","type":"datetime","nullable":true,"primary_key":false},{"name":"GeneratedReportId","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"account_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"line_count","type":"int(11)","nullable":true,"primary_key":false},{"name":"data","type":"longblob","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_reports` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ReportRequestId` varchar(64) DEFAULT NULL, `ReportType` varchar(64) DEFAULT NULL, `ReportProcessingStatus` varchar(64) DEFAULT '', `results` text, `success` varchar(16) DEFAULT NULL, `SubmittedDate` datetime DEFAULT NULL, `StartedProcessingDate` datetime DEFAULT NULL, `CompletedDate` datetime DEFAULT NULL, `GeneratedReportId` varchar(64) DEFAULT NULL, `account_id` int(11) DEFAULT NULL, `line_count` int(11) DEFAULT NULL, `data` longblob, PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"amazon_shipping","full_table_name":"wp_amazon_shipping","description":"Stores amazon shipping data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"service_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"service_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"service_description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"carrier","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"international","type":"tinyint(4)","nullable":true,"primary_key":false},{"name":"version","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_shipping` ( `service_id` int(11) DEFAULT NULL, `service_name` varchar(255) DEFAULT NULL, `service_description` varchar(255) DEFAULT NULL, `carrier` varchar(255) DEFAULT NULL, `international` tinyint(4) DEFAULT NULL, `version` int(11) DEFAULT NULL ) DEFAULT CHARSET"},{"table_name":"amazon_stock_log","full_table_name":"wp_amazon_stock_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"timestamp","type":"datetime","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"sku","type":"varchar(32)","nullable":true,"primary_key":false},{"name":"old_stock","type":"int(11)","nullable":true,"primary_key":false},{"name":"new_stock","type":"int(11)","nullable":true,"primary_key":false},{"name":"caller","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"method","type":"varchar(128)","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"backtrace","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_stock_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `timestamp` datetime DEFAULT NULL, `product_id` int(11) DEFAULT NULL, `sku` varchar(32) DEFAULT NULL, `old_stock` int(11) DEFAULT NULL, `new_stock` int(11) DEFAULT NULL, `caller` varchar(64) DEFAULT NULL, `method` varchar(128) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `backtrace` text, PRIMARY KEY (`id`) ) DEFAULT CHARSET"}],"table_count":19}