wp_eerb_promo_codes
StaticStores eerb promo codes data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | INT UNSIGNED | NO |
| code | VARCHAR(50) | NO |
| description | VARCHAR(255) | YES |
| discount_percent | TINYINT UNSIGNED | NO |
| valid_from | DATE | YES |
| valid_to | DATE | YES |
| max_uses | SMALLINT UNSIGNED | YES |
| use_count | SMALLINT UNSIGNED | NO |
| is_active | TINYINT(1) | NO |
| created_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_eerb_promo_codes ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, code VARCHAR(50) NOT NULL, description VARCHAR(255), discount_percent TINYINT UNSIGNED NOT NULL DEFAULT 10 COMMENT 'e.g. 10 = 10% off', valid_from DATE, valid_to DATE, max_uses SMALLINT UNSIGNED COMMENT 'NULL = unlimited', use_count SMALLINT UNSIGNED NOT NULL DEFAULT 0, is_active TINYINT(1) NOT NULL DEFAULT 1, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY code (code) ) $charset;" );
Safe to delete?
If you have uninstalled Ettrick Escape Room Booking, 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_eerb_promo_codes`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Ettrick Escape Room Booking