wp_bingocr_payments
StaticStores bingocr payments data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| reservation_id | bigint(20) unsigned | NO |
| method | varchar(20) | NO |
| amount | decimal(10,2) | NO |
| currency | varchar(10) | NO |
| status | varchar(20) | NO |
| paypal_order_id | varchar(64) | YES |
| paypal_capture_id | varchar(64) | YES |
| payer_email | varchar(200) | YES |
| gateway_response | longtext | YES |
| created_at | datetime | NO |
| completed_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE wp_bingocr_payments ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, reservation_id bigint(20) unsigned NOT NULL, method varchar(20) NOT NULL DEFAULT 'paypal', amount decimal(10,2) NOT NULL DEFAULT 0.00, currency varchar(10) NOT NULL DEFAULT 'EUR', status varchar(20) NOT NULL DEFAULT 'pending', paypal_order_id varchar(64) DEFAULT NULL, paypal_capture_id varchar(64) DEFAULT NULL, payer_email varchar(200) DEFAULT NULL, gateway_response longtext DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, completed_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY reservation_id (reservation_id), KEY paypal_order_id (paypal_order_id) ) $c;" );
Safe to delete?
If you have uninstalled Bingo Car Rental, 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_bingocr_payments`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Bingo Car Rental