wp_ebay_auctions
StaticStores ebay auctions data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) unsigned | NO |
| ebay_id | bigint(255) | YES |
| auction_title | varchar(255) | YES |
| auction_type | varchar(255) | YES |
| listing_duration | varchar(255) | YES |
| date_created | datetime | YES |
| date_published | datetime | YES |
| date_finished | datetime | YES |
| end_date | datetime | YES |
| price | float | YES |
| quantity | int(11) | YES |
| quantity_sold | int(11) | YES |
| status | varchar(50) | YES |
| details | text | YES |
| ViewItemURL | varchar(255) | YES |
| GalleryURL | varchar(255) | YES |
| post_content | text | YES |
| post_id | int(11) | YES |
| profile_id | int(11) | YES |
| profile_data | text | YES |
| template | varchar(255) | YES |
| fees | float | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_ebay_auctions` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ebay_id` bigint(255) DEFAULT NULL, `auction_title` varchar(255) DEFAULT NULL, `auction_type` varchar(255) DEFAULT NULL, `listing_duration` varchar(255) DEFAULT NULL, `date_created` datetime DEFAULT NULL, `date_published` datetime DEFAULT NULL, `date_finished` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `price` float DEFAULT NULL, `quantity` int(11) DEFAULT NULL, `quantity_sold` int(11) DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `details` text, `ViewItemURL` varchar(255) DEFAULT NULL, `GalleryURL` varchar(255) DEFAULT NULL, `post_content` text, `post_id` int(11) DEFAULT NULL, `profile_id` int(11) DEFAULT NULL, `profile_data` text, `template` varchar(255) DEFAULT '', `fees` float DEFAULT NULL, PRIMARY KEY (`id`) );
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_auctions`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-Lister Lite for eBay