wp_bingocr_period_pricing
StaticStores bingocr period pricing data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| name | varchar(200) | NO |
| pricing_type | enum('fixed_total','rate_per_day') | NO |
| min_days | tinyint(3) unsigned | NO |
| max_days | tinyint(3) unsigned | NO |
| fixed_price | decimal(10,2) | NO |
| price_per_day | decimal(10,2) | NO |
| applies_to | enum('all','category','car') | NO |
| category | varchar(50) | NO |
| car_id | bigint(20) unsigned | YES |
| priority | tinyint(3) | NO |
| status | enum('active','inactive') | NO |
| created_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_bingocr_period_pricing ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(200) NOT NULL DEFAULT '', pricing_type enum('fixed_total','rate_per_day') NOT NULL DEFAULT 'rate_per_day', min_days tinyint(3) unsigned NOT NULL DEFAULT 1, max_days tinyint(3) unsigned NOT NULL DEFAULT 30, fixed_price decimal(10,2) NOT NULL DEFAULT 0.00, price_per_day decimal(10,2) NOT NULL DEFAULT 0.00, applies_to enum('all','category','car') NOT NULL DEFAULT 'all', category varchar(50) NOT NULL DEFAULT '', car_id bigint(20) unsigned DEFAULT NULL, priority tinyint(3) NOT NULL DEFAULT 0, status enum('active','inactive') NOT NULL DEFAULT 'active', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status), KEY min_days (min_days), KEY max_days (max_days) ) $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_period_pricing`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Bingo Car Rental