wp_fe_event_coupons
StaticStores fe event coupons data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT | NO |
| code | VARCHAR(32) | NO |
| description | VARCHAR(100) | NO |
| date_created | DATETIME | NO |
| date_modified | DATETIME | NO |
| type | ENUM('percent','fixed') | NO |
| amount | DECIMAL(10,2) | NO |
| usage_limit | INT UNSIGNED | NO |
| usage_limit_per_user | INT UNSIGNED | NO |
| used | INT UNSIGNED | NO |
| last_used | DATETIME | YES |
| start_date | DATETIME | NO |
| end_date | DATETIME | NO |
| events | VARCHAR(64) | YES |
| tickets | VARCHAR(256) | YES |
| minimum_tickets | INT UNSIGNED | YES |
| maximum_tickets | INT UNSIGNED | YES |
| minimum_amount | DECIMAL(10,2) | YES |
| maximum_amount | DECIMAL(10,2) | YES |
| VARCHAR(100) | YES |
CREATE TABLE Statement
CREATE TABLE wp_fe_event_coupons ( id BIGINT NOT NULL AUTO_INCREMENT, code VARCHAR(32) NOT NULL, description VARCHAR(100) NOT NULL, date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_modified DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, type ENUM('percent','fixed') NOT NULL DEFAULT 'fixed', amount DECIMAL(10,2) NOT NULL, usage_limit INT UNSIGNED NOT NULL DEFAULT '1', usage_limit_per_user INT UNSIGNED NOT NULL DEFAULT '1', used INT UNSIGNED NOT NULL DEFAULT '0', last_used DATETIME NULL, start_date DATETIME NOT NULL, end_date DATETIME NOT NULL, events VARCHAR(64) NULL, tickets VARCHAR(256) NULL, minimum_tickets INT UNSIGNED NULL, maximum_tickets INT UNSIGNED NULL, minimum_amount DECIMAL(10,2) NULL, maximum_amount DECIMAL(10,2) NULL, email VARCHAR(100) NULL, PRIMARY KEY (id), UNIQUE code_index (code) ) ENGINESafe to delete?
If you have uninstalled Fast Events, 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_fe_event_coupons`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Fast Events