wp_wpbdp_payments
StaticStores wpbdp payments data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | YES |
| listing_id | bigint(20) | NO |
| parent_id | bigint(20) | NO |
| payment_key | varchar(255) | YES |
| payment_type | varchar(255) | YES |
| payment_items | longblob | YES |
| data | longblob | YES |
| context | varchar(255) | YES |
| payer_email | varchar(255) | YES |
| payer_first_name | varchar(255) | YES |
| payer_last_name | varchar(255) | YES |
| payer_data | blob | YES |
| gateway | varchar(255) | YES |
| gateway_tx_id | varchar(255) | YES |
| currency_code | varchar(3) | NO |
| amount | decimal(10,2) | NO |
| status | varchar(255) | NO |
| is_test | boolean | YES |
| created_at | datetime | NO |
| processed_on | timestamp | YES |
| processed_by | varchar(255) | YES |
CREATE TABLE Statement
CREATE TABLE wp_wpbdp_payments ( id bigint(20) PRIMARY KEY AUTO_INCREMENT, listing_id bigint(20) NOT NULL DEFAULT 0, parent_id bigint(20) NOT NULL DEFAULT 0, payment_key varchar(255) NULL DEFAULT '', payment_type varchar(255) NULL DEFAULT '', payment_items longblob NULL, data longblob NULL, context varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', payer_email varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', payer_first_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', payer_last_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', payer_data blob NULL, gateway varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, gateway_tx_id varchar(255) NULL DEFAULT '', currency_code varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'USD', amount decimal(10,2) NOT NULL DEFAULT 0.00, status varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, is_test boolean NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', processed_on timestamp NULL DEFAULT NULL, processed_by varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, KEY listing_id (listing_id), KEY status (status) ) 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_payments`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Business Directory Plugin – Easy Listing Directories for WordPress