wp_amazon_accounts
StaticStores amazon accounts data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) unsigned | NO |
| title | varchar(128) | NO |
| merchant_id | varchar(32) | NO |
| marketplace_id | varchar(32) | NO |
| access_key_id | varchar(32) | NO |
| secret_key | varchar(64) | NO |
| market_id | int(11) | YES |
| market_code | varchar(16) | YES |
| config | text | NO |
| sync_orders | int(11) | YES |
| sync_products | int(11) | YES |
| last_orders_sync | datetime | YES |
CREATE TABLE Statement
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
Safe to delete?
If you have uninstalled WP-Lister Lite for Amazon, 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_amazon_accounts`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-Lister Lite for Amazon