wp_bingocr_discounts

Static

Stores bingocr discounts data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idbigint(20) unsignedNO
codevarchar(50)NO
typeenum('percentage','flat')NO
valuedecimal(10,2)NO
min_daystinyint(3) unsignedNO
max_usesint(11)YES
used_countint(11)NO
expires_atdateYES
statusenum('active','inactive')NO

CREATE TABLE Statement

CREATE TABLE wp_bingocr_discounts ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, code varchar(50) NOT NULL DEFAULT '', type enum('percentage','flat') NOT NULL DEFAULT 'percentage', value decimal(10,2) NOT NULL DEFAULT 0.00, min_days tinyint(3) unsigned NOT NULL DEFAULT 1, max_uses int(11) DEFAULT NULL, used_count int(11) NOT NULL DEFAULT 0, expires_at date DEFAULT NULL, status enum('active','inactive') NOT NULL DEFAULT 'active', PRIMARY KEY (id), UNIQUE KEY code (code) ) $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_discounts`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Bingo Car Rental