wp_bingocr_cars
StaticStores bingocr cars data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| brand | varchar(100) | NO |
| model | varchar(100) | NO |
| year | smallint(4) | YES |
| category | varchar(50) | NO |
| transmission | varchar(20) | NO |
| fuel_type | varchar(20) | NO |
| seats | tinyint(3) unsigned | NO |
| price_per_day | decimal(10,2) | NO |
| deposit_type | enum('default','percentage','flat') | NO |
| deposit_value | decimal(10,2) | NO |
| image_id | bigint(20) unsigned | YES |
| image_url | varchar(500) | YES |
| description | text | YES |
| features | longtext | YES |
| quantity | tinyint(3) unsigned | NO |
| status | enum('available','unavailable','maintenance') | NO |
| sort_order | int(11) | NO |
| created_at | datetime | NO |
| updated_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_bingocr_cars ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, brand varchar(100) NOT NULL DEFAULT '', model varchar(100) NOT NULL DEFAULT '', year smallint(4) DEFAULT NULL, category varchar(50) NOT NULL DEFAULT '', transmission varchar(20) NOT NULL DEFAULT 'manual', fuel_type varchar(20) NOT NULL DEFAULT 'petrol', seats tinyint(3) unsigned NOT NULL DEFAULT 5, price_per_day decimal(10,2) NOT NULL DEFAULT 0.00, deposit_type enum('default','percentage','flat') NOT NULL DEFAULT 'default', deposit_value decimal(10,2) NOT NULL DEFAULT 0.00, image_id bigint(20) unsigned DEFAULT NULL, image_url varchar(500) DEFAULT NULL, description text DEFAULT NULL, features longtext DEFAULT NULL, quantity tinyint(3) unsigned NOT NULL DEFAULT 1, status enum('available','unavailable','maintenance') NOT NULL DEFAULT 'available', sort_order int(11) NOT NULL DEFAULT 0, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY category (category), KEY status (status) ) $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_cars`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Bingo Car Rental