wp_amazon_feeds

Static

Stores amazon feeds data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idint(11)NO
FeedSubmissionIdvarchar(64)YES
FeedTypevarchar(64)YES
FeedProcessingStatusvarchar(64)YES
resultstextYES
successvarchar(16)YES
statusvarchar(16)YES
SubmittedDatedatetimeYES
CompletedProcessingDatedatetimeYES
date_createddatetimeYES
MarketplaceIdListvarchar(255)YES
account_idint(11)YES
line_countint(11)YES
datamediumblobYES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS `wp_amazon_feeds` ( `id` int(11) NOT NULL AUTO_INCREMENT, `FeedSubmissionId` varchar(64) DEFAULT NULL, `FeedType` varchar(64) DEFAULT NULL, `FeedProcessingStatus` varchar(64) DEFAULT '', `results` text, `success` varchar(16) DEFAULT NULL, `status` varchar(16) DEFAULT NULL, `SubmittedDate` datetime DEFAULT NULL, `CompletedProcessingDate` datetime DEFAULT NULL, `date_created` datetime DEFAULT NULL, `MarketplaceIdList` varchar(255) DEFAULT NULL, `account_id` int(11) DEFAULT NULL, `line_count` int(11) DEFAULT NULL, `data` mediumblob, 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_feeds`;

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

Other tables from WP-Lister Lite for Amazon