wp_fe_event_qrcodes
StaticStores fe event qrcodes data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| order_id | BIGINT(20) UNSIGNED | NO |
| event_id | BIGINT(20) UNSIGNED | NO |
| ticket_type | VARCHAR(50) | NO |
| qrcode | VARCHAR(32) | NO |
| personalised_input | VARCHAR(512) | YES |
| tracking_nonce | VARCHAR(16) | NO |
| created_at | DATETIME | NO |
| amount | DECIMAL(10,4) | NO |
| scan_date | DATETIME | YES |
| scan_location | VARCHAR(32) | NO |
| exit_scan | TINYINT(1) | NO |
CREATE TABLE Statement
CREATE TABLE wp_fe_event_qrcodes ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT(20) UNSIGNED NOT NULL, event_id BIGINT(20) UNSIGNED NOT NULL, ticket_type VARCHAR(50) NOT NULL DEFAULT '', qrcode VARCHAR(32) NOT NULL DEFAULT '', personalised_input VARCHAR(512) NULL DEFAULT NULL, tracking_nonce VARCHAR(16) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, amount DECIMAL(10,4) NOT NULL DEFAULT '0.0000', scan_date DATETIME NULL DEFAULT NULL, scan_location VARCHAR(32) NOT NULL DEFAULT '', exit_scan TINYINT(1) NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY order_id (order_id), UNIQUE KEY qrcode (qrcode), INDEX event_id (event_id) ) ENGINE
Safe 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_qrcodes`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Fast Events