wp_ebay_accounts

Static

Stores ebay accounts data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idint(11) unsignedNO
titlevarchar(128)NO
site_idint(11)YES
site_codevarchar(16)YES
sandbox_modevarchar(16)YES
user_namevarchar(32)YES
user_detailstextNO
activeint(11)YES
tokentextNO
valid_untildatetimeYES
ebay_motorsint(11)YES
seller_profilesint(11)YES
shipping_profilestextNO
payment_profilestextNO
return_profilestextNO
categories_map_ebaytextNO
categories_map_storetextNO
default_ebay_category_idbigint(20)YES
paypal_emailvarchar(64)YES
sync_ordersint(11)YES
sync_productsint(11)YES
last_orders_syncdatetimeYES

CREATE TABLE Statement

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

Safe to delete?

If you have uninstalled WP-Lister Lite for eBay, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_ebay_accounts`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from WP-Lister Lite for eBay