{"slug":"wp-lister-for-ebay","name":"WP-Lister Lite for eBay","description":"List products from WordPress on eBay. The easy way.","author":"WP Lab","active_installs":2000,"version":"3.8.7","wp_org_url":"https://wordpress.org/plugins/wp-lister-for-ebay/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ebay_accounts","full_table_name":"wp_ebay_accounts","description":"Stores ebay 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":"site_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"site_code","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"sandbox_mode","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"user_name","type":"varchar(32)","nullable":true,"primary_key":false},{"name":"user_details","type":"text","nullable":false,"primary_key":false},{"name":"active","type":"int(11)","nullable":true,"primary_key":false},{"name":"token","type":"text","nullable":false,"primary_key":false},{"name":"valid_until","type":"datetime","nullable":true,"primary_key":false},{"name":"ebay_motors","type":"int(11)","nullable":true,"primary_key":false},{"name":"seller_profiles","type":"int(11)","nullable":true,"primary_key":false},{"name":"shipping_profiles","type":"text","nullable":false,"primary_key":false},{"name":"payment_profiles","type":"text","nullable":false,"primary_key":false},{"name":"return_profiles","type":"text","nullable":false,"primary_key":false},{"name":"categories_map_ebay","type":"text","nullable":false,"primary_key":false},{"name":"categories_map_store","type":"text","nullable":false,"primary_key":false},{"name":"default_ebay_category_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"paypal_email","type":"varchar(64)","nullable":true,"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_ebay_accounts` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(128) NOT NULL, `site_id` int(11) DEFAULT NULL, `site_code` varchar(16) DEFAULT NULL, `sandbox_mode` varchar(16) DEFAULT NULL, `user_name` varchar(32) DEFAULT NULL, `user_details` text NOT NULL, `active` int(11) DEFAULT NULL, `token` text NOT NULL, `valid_until` datetime DEFAULT NULL, `ebay_motors` int(11) DEFAULT NULL, `seller_profiles` int(11) DEFAULT NULL, `shipping_profiles` text NOT NULL, `payment_profiles` text NOT NULL, `return_profiles` text NOT NULL, `categories_map_ebay` text NOT NULL, `categories_map_store` text NOT NULL, `default_ebay_category_id` bigint(20) DEFAULT NULL, `paypal_email` varchar(64) DEFAULT 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":"ebay_auctions","full_table_name":"wp_ebay_auctions","description":"Stores ebay auctions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"ebay_id","type":"bigint(255)","nullable":true,"primary_key":false},{"name":"auction_title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"auction_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"listing_duration","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":"date_finished","type":"datetime","nullable":true,"primary_key":false},{"name":"end_date","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":"ViewItemURL","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"GalleryURL","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"post_content","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":"profile_data","type":"text","nullable":true,"primary_key":false},{"name":"template","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"fees","type":"float","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_ebay_auctions` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ebay_id` bigint(255) DEFAULT NULL, `auction_title` varchar(255) DEFAULT NULL, `auction_type` varchar(255) DEFAULT NULL, `listing_duration` varchar(255) DEFAULT NULL, `date_created` datetime DEFAULT NULL, `date_published` datetime DEFAULT NULL, `date_finished` datetime DEFAULT NULL, `end_date` 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, `ViewItemURL` varchar(255) DEFAULT NULL, `GalleryURL` varchar(255) DEFAULT NULL, `post_content` text, `post_id` int(11) DEFAULT NULL, `profile_id` int(11) DEFAULT NULL, `profile_data` text, `template` varchar(255) DEFAULT '', `fees` float DEFAULT NULL, PRIMARY KEY (`id`) );"},{"table_name":"ebay_categories","full_table_name":"wp_ebay_categories","description":"Stores ebay categories data created by this plugin.","detection_method":"static","confidence":"high","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_ebay_categories` ( `cat_id` bigint(16), `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, PRIMARY KEY `cat_id` (`cat_id`), KEY `parent_cat_id` (`parent_cat_id`) );"},{"table_name":"ebay_documents","full_table_name":"wp_ebay_documents","description":"Stores ebay documents data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(11)","nullable":false,"primary_key":true},{"name":"account_id","type":"bigint(11)","nullable":false,"primary_key":false},{"name":"attachment_id","type":"bigint(11)","nullable":false,"primary_key":false},{"name":"document_id","type":"varchar(25)","nullable":false,"primary_key":false},{"name":"document_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"date_added","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_ebay_documents` ( `id` bigint(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `account_id` bigint(11) NOT NULL, `attachment_id` bigint(11) NOT NULL, `document_id` varchar(25) NOT NULL, `document_type` varchar(50) NOT NULL, `date_added` datetime NOT NULL );"},{"table_name":"ebay_jobs","full_table_name":"wp_ebay_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","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_ebay_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`) );"},{"table_name":"ebay_log","full_table_name":"wp_ebay_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":"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":"callname","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"success","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"ebay_id","type":"bigint(255)","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_ebay_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `timestamp` datetime DEFAULT NULL, `request_url` text DEFAULT NULL, `request` text DEFAULT NULL, `response` text DEFAULT NULL, `callname` varchar(64) DEFAULT NULL, `success` varchar(16) DEFAULT NULL, `ebay_id` bigint(255) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) );"},{"table_name":"ebay_manufacturers","full_table_name":"wp_ebay_manufacturers","description":"Stores ebay manufacturers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(6)","nullable":false,"primary_key":true},{"name":"street1","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"street2","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"state","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"postcode","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"country","type":"varchar(2)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"company","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"date_added","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_ebay_manufacturers` ( `id` int(6) NOT NULL AUTO_INCREMENT PRIMARY KEY, `street1` varchar(100) NOT NULL, `street2` varchar(100) NULL, `city` varchar(100) NULL, `state` varchar(50) NULL, `postcode` varchar(10) NULL, `country` varchar(2) NULL, `email` varchar(100) NULL, `phone` varchar(25) NULL, `company` varchar(150) NOT NULL, `date_added` datetime NOT NULL );"},{"table_name":"ebay_messages","full_table_name":"wp_ebay_messages","description":"Stores ebay messages data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"message_id","type":"varchar(128)","nullable":true,"primary_key":false},{"name":"received_date","type":"datetime","nullable":true,"primary_key":false},{"name":"subject","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"sender","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"flag_read","type":"varchar(1)","nullable":true,"primary_key":false},{"name":"flag_replied","type":"varchar(1)","nullable":true,"primary_key":false},{"name":"flag_flagged","type":"varchar(1)","nullable":true,"primary_key":false},{"name":"item_title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"item_id","type":"bigint(255)","nullable":true,"primary_key":false},{"name":"folder_id","type":"bigint(255)","nullable":true,"primary_key":false},{"name":"msg_text","type":"text","nullable":true,"primary_key":false},{"name":"msg_content","type":"text","nullable":true,"primary_key":false},{"name":"details","type":"text","nullable":true,"primary_key":false},{"name":"expiration_date","type":"datetime","nullable":true,"primary_key":false},{"name":"response_url","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_ebay_messages` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `message_id` varchar(128) DEFAULT NULL, `received_date` datetime DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `sender` varchar(255) DEFAULT NULL, `flag_read` varchar(1) DEFAULT NULL, `flag_replied` varchar(1) DEFAULT NULL, `flag_flagged` varchar(1) DEFAULT NULL, `item_title` varchar(255) DEFAULT NULL, `item_id` bigint(255) DEFAULT NULL, `folder_id` bigint(255) DEFAULT NULL, `msg_text` text, `msg_content` text, `details` text, `expiration_date` datetime DEFAULT NULL, `response_url` varchar(255) DEFAULT NULL, `status` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) );"},{"table_name":"ebay_orders","full_table_name":"wp_ebay_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","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":"eBayPaymentStatus","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"CheckoutStatus","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ShippingService","type":"varchar(75)","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}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_ebay_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, `eBayPaymentStatus` varchar(50) DEFAULT NULL, `CheckoutStatus` varchar(50) DEFAULT NULL, `ShippingService` varchar(75) DEFAULT NULL, `PaymentMethod` varchar(50) DEFAULT NULL, `ShippingAddress_City` varchar(50) DEFAULT NULL, `CompleteStatus` varchar(50) DEFAULT NULL, `LastTimeModified` datetime DEFAULT NULL, PRIMARY KEY (`id`) );"},{"table_name":"ebay_payment","full_table_name":"wp_ebay_payment","description":"Stores ebay payment data created by this plugin.","detection_method":"static","confidence":"high","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_ebay_payment` ( `payment_name` varchar(255) DEFAULT NULL, `payment_description` varchar(255) DEFAULT NULL, `version` int(11) DEFAULT NULL );"},{"table_name":"ebay_profiles","full_table_name":"wp_ebay_profiles","description":"Stores ebay profiles data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"profile_id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"profile_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"profile_description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"listing_duration","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"details","type":"text","nullable":true,"primary_key":false},{"name":"conditions","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_ebay_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`) );"},{"table_name":"ebay_responsible_persons","full_table_name":"wp_ebay_responsible_persons","description":"Stores ebay responsible persons data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(6)","nullable":false,"primary_key":true},{"name":"street1","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"street2","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"state","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"postcode","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"country","type":"varchar(2)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"company","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"date_added","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_ebay_responsible_persons` ( `id` int(6) NOT NULL AUTO_INCREMENT PRIMARY KEY, `street1` varchar(100) NOT NULL, `street2` varchar(100) NULL, `city` varchar(100) NULL, `state` varchar(50) NULL, `postcode` varchar(10) NULL, `country` varchar(2) NULL, `email` varchar(100) NULL, `phone` varchar(25) NULL, `company` varchar(150) NOT NULL, `date_added` datetime NOT NULL );"},{"table_name":"ebay_shipping","full_table_name":"wp_ebay_shipping","description":"Stores ebay shipping data created by this plugin.","detection_method":"static","confidence":"high","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_ebay_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 );"},{"table_name":"ebay_sites","full_table_name":"wp_ebay_sites","description":"Stores ebay sites data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"code","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"url","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"enabled","type":"int(11)","nullable":true,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":true,"primary_key":false},{"name":"last_refresh","type":"datetime","nullable":true,"primary_key":false},{"name":"categories_map_ebay","type":"text","nullable":false,"primary_key":false},{"name":"DispatchTimeMaxDetails","type":"text","nullable":false,"primary_key":false},{"name":"MinListingStartPrices","type":"text","nullable":false,"primary_key":false},{"name":"ReturnsWithinOptions","type":"text","nullable":false,"primary_key":false},{"name":"CountryDetails","type":"text","nullable":false,"primary_key":false},{"name":"ShippingPackageDetails","type":"text","nullable":false,"primary_key":false},{"name":"ShippingCostPaidByOptions","type":"text","nullable":false,"primary_key":false},{"name":"ShippingLocationDetails","type":"text","nullable":false,"primary_key":false},{"name":"ExcludeShippingLocationDetails","type":"text","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_ebay_sites` ( `id` int(11), `title` varchar(128) NOT NULL, `code` varchar(16) DEFAULT NULL, `url` varchar(64) DEFAULT NULL, `enabled` int(11) DEFAULT NULL, `sort_order` int(11) DEFAULT NULL, `last_refresh` datetime DEFAULT NULL, `categories_map_ebay` text NOT NULL, `DispatchTimeMaxDetails` text NOT NULL, `MinListingStartPrices` text NOT NULL, `ReturnsWithinOptions` text NOT NULL, `CountryDetails` text NOT NULL, `ShippingPackageDetails` text NOT NULL, `ShippingCostPaidByOptions` text NOT NULL, `ShippingLocationDetails` text NOT NULL, `ExcludeShippingLocationDetails` text NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"ebay_stocks_log","full_table_name":"wp_ebay_stocks_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":"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_ebay_stocks_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_name":"ebay_store_categories","full_table_name":"wp_ebay_store_categories","description":"Stores ebay store categories data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"cat_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"parent_cat_id","type":"bigint(20)","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":"order","type":"int(11)","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_ebay_store_categories` ( `cat_id` bigint(20) DEFAULT NULL, `parent_cat_id` bigint(20) DEFAULT NULL, `level` int(11) DEFAULT NULL, `leaf` tinyint(4) DEFAULT NULL, `version` int(11) DEFAULT NULL, `cat_name` varchar(255) DEFAULT NULL, `order` int(11) DEFAULT NULL, `wp_term_id` int(11) DEFAULT NULL, KEY `cat_id` (`cat_id`), KEY `parent_cat_id` (`parent_cat_id`) );"},{"table_name":"ebay_transactions","full_table_name":"wp_ebay_transactions","description":"Stores ebay transactions data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"item_id","type":"bigint(255)","nullable":true,"primary_key":false},{"name":"transaction_id","type":"bigint(255)","nullable":true,"primary_key":false},{"name":"date_created","type":"datetime","nullable":true,"primary_key":false},{"name":"item_title","type":"varchar(255)","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":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"details","type":"text","nullable":true,"primary_key":false},{"name":"post_id","type":"int(11)","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":"eBayPaymentStatus","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"CheckoutStatus","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ShippingService","type":"varchar(75)","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}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_ebay_transactions` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `item_id` bigint(255) DEFAULT NULL, `transaction_id` bigint(255) DEFAULT NULL, `date_created` datetime DEFAULT NULL, `item_title` varchar(255) DEFAULT NULL, `price` float DEFAULT NULL, `quantity` int(11) DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `details` text, `post_id` int(11) DEFAULT NULL, `buyer_userid` varchar(255) DEFAULT NULL, `buyer_name` varchar(255) DEFAULT NULL, `buyer_email` varchar(255) DEFAULT NULL, `eBayPaymentStatus` varchar(50) DEFAULT NULL, `CheckoutStatus` varchar(50) DEFAULT NULL, `ShippingService` varchar(75) DEFAULT NULL, `PaymentMethod` varchar(50) DEFAULT NULL, `ShippingAddress_City` varchar(50) DEFAULT NULL, `CompleteStatus` varchar(50) DEFAULT NULL, `LastTimeModified` datetime DEFAULT NULL, PRIMARY KEY (`id`) );"},{"table_name":"jquery","full_table_name":"wp_jquery","description":"Stores jquery data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"create table jQuery('div.ebay_item_compatibility_table_wrapper').prepend('<table class=\"ebay_item_compatibility_table\"></table>');"}],"table_count":18}