wp_wpbdp_plans
StaticStores wpbdp plans data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | YES |
| label | varchar(255) | NO |
| amount | decimal(10,2) | NO |
| days | smallint unsigned | NO |
| images | smallint unsigned | NO |
| sticky | tinyint(1) | NO |
| recurring | tinyint(1) | NO |
| pricing_model | varchar(100) | NO |
| pricing_details | blob | YES |
| supported_categories | text | NO |
| weight | int(5) | NO |
| enabled | tinyint(1) | NO |
| description | TEXT | YES |
| extra_data | longblob | YES |
| tag | varchar(255) | NO |
CREATE TABLE Statement
CREATE TABLE wp_wpbdp_plans ( id bigint(20) PRIMARY KEY AUTO_INCREMENT, label varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, amount decimal(10,2) NOT NULL DEFAULT 0.00, days smallint unsigned NOT NULL DEFAULT 0, images smallint unsigned NOT NULL DEFAULT 0, sticky tinyint(1) NOT NULL DEFAULT 0, recurring tinyint(1) NOT NULL DEFAULT 0, pricing_model varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'flat', pricing_details blob NULL, supported_categories text NOT NULL DEFAULT '', weight int(5) NOT NULL DEFAULT 0, enabled tinyint(1) NOT NULL DEFAULT 1, description TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', extra_data longblob NULL, tag 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_plans`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Business Directory Plugin – Easy Listing Directories for WordPress