wp_wpbdp_listings
StaticStores wpbdp listings data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑listing_id | bigint(20) | YES |
| fee_id | bigint(20) | YES |
| fee_price | decimal(10,2) | YES |
| fee_days | smallint unsigned | YES |
| fee_images | smallint unsigned | YES |
| expiration_date | timestamp | YES |
| is_recurring | tinyint(1) | NO |
| is_sticky | tinyint(1) | NO |
| subscription_id | varchar(255) | YES |
| subscription_data | longblob | YES |
| listing_status | varchar(255) | NO |
| flags | varchar(255) | NO |
CREATE TABLE Statement
CREATE TABLE wp_wpbdp_listings ( listing_id bigint(20) PRIMARY KEY, fee_id bigint(20) NULL, fee_price decimal(10,2) NULL DEFAULT 0.00, fee_days smallint unsigned NULL DEFAULT 0, fee_images smallint unsigned NULL DEFAULT 0, expiration_date timestamp NULL DEFAULT NULL, is_recurring tinyint(1) NOT NULL DEFAULT 0, is_sticky tinyint(1) NOT NULL DEFAULT 0, subscription_id varchar(255) NULL DEFAULT '', subscription_data longblob NULL, listing_status varchar(255) NOT NULL DEFAULT 'unknown', flags varchar(255) NOT NULL DEFAULT '' ) DEFAULT CHARSET
Safe to delete?
If you have uninstalled Business Directory Plugin – Easy Listing Directories for WordPress, 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_wpbdp_listings`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Business Directory Plugin – Easy Listing Directories for WordPress