wp_bingocr_reservations
StaticStores bingocr reservations data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| reservation_number | varchar(20) | NO |
| car_id | bigint(20) unsigned | NO |
| customer_name | varchar(200) | NO |
| customer_email | varchar(200) | NO |
| customer_phone | varchar(50) | YES |
| pickup_date | date | NO |
| return_date | date | NO |
| pickup_time | varchar(10) | NO |
| return_time | varchar(10) | NO |
| pickup_location_id | bigint(20) unsigned | YES |
| dropoff_location_id | bigint(20) unsigned | YES |
| status | enum('pending','confirmed','active','cancelled','completed') | NO |
| total_price | decimal(10,2) | YES |
| deposit_amount | decimal(10,2) | NO |
| discount_code | varchar(50) | YES |
| discount_amount | decimal(10,2) | NO |
| extras | longtext | YES |
| notes | text | YES |
| payment_method | varchar(50) | NO |
| payment_status | varchar(20) | NO |
| paid_amount | decimal(10,2) | NO |
| language | varchar(10) | NO |
| created_at | datetime | NO |
| updated_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_bingocr_reservations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, reservation_number varchar(20) NOT NULL DEFAULT '', car_id bigint(20) unsigned NOT NULL, customer_name varchar(200) NOT NULL DEFAULT '', customer_email varchar(200) NOT NULL DEFAULT '', customer_phone varchar(50) DEFAULT NULL, pickup_date date NOT NULL, return_date date NOT NULL, pickup_time varchar(10) NOT NULL DEFAULT '10:00', return_time varchar(10) NOT NULL DEFAULT '10:00', pickup_location_id bigint(20) unsigned DEFAULT NULL, dropoff_location_id bigint(20) unsigned DEFAULT NULL, status enum('pending','confirmed','active','cancelled','completed') NOT NULL DEFAULT 'pending', total_price decimal(10,2) DEFAULT NULL, deposit_amount decimal(10,2) NOT NULL DEFAULT 0.00, discount_code varchar(50) DEFAULT NULL, discount_amount decimal(10,2) NOT NULL DEFAULT 0.00, extras longtext DEFAULT NULL, notes text DEFAULT NULL, payment_method varchar(50) NOT NULL DEFAULT 'cash', payment_status varchar(20) NOT NULL DEFAULT 'unpaid', paid_amount decimal(10,2) NOT NULL DEFAULT 0.00, language varchar(10) NOT NULL DEFAULT 'en', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY reservation_number (reservation_number), KEY car_id (car_id), KEY status (status), KEY pickup_date (pickup_date), KEY customer_email (customer_email) ) $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_reservations`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Bingo Car Rental