wp_amazon_reports
StaticStores amazon reports data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| ReportRequestId | varchar(64) | YES |
| ReportType | varchar(64) | YES |
| ReportProcessingStatus | varchar(64) | YES |
| results | text | YES |
| success | varchar(16) | YES |
| SubmittedDate | datetime | YES |
| StartedProcessingDate | datetime | YES |
| CompletedDate | datetime | YES |
| GeneratedReportId | varchar(64) | YES |
| account_id | int(11) | YES |
| line_count | int(11) | YES |
| data | longblob | YES |
CREATE TABLE Statement
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
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_reports`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-Lister Lite for Amazon