wp_amazon_btg
StaticStores amazon btg data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| node_id | bigint(16) | YES |
| parent_id | bigint(16) | YES |
| top_id | bigint(16) | YES |
| level | int(11) | YES |
| leaf | tinyint(4) | YES |
| keyword | varchar(255) | YES |
| node_name | varchar(255) | YES |
| node_path | varchar(255) | YES |
| site_id | int(11) | YES |
CREATE TABLE Statement
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
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_btg`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-Lister Lite for Amazon