wp_fe_event_email_log
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT | NO |
| event_id | BIGINT(20) UNSIGNED | NO |
| order_id | BIGINT(20) UNSIGNED | NO |
| date_created | DATETIME | NO |
| date_modified | DATETIME | NO |
| provider_id | ENUM('local','smtp','amazon','brevo','mailgun','mailjet','postmark','sendgrid','smtp2go','sparkpost') | NO |
| email_type | ENUM('normal','confirm','free') | NO |
| provider_email_id | VARCHAR(100) | NO |
| sender_email | VARCHAR(100) | NO |
| receiver_email | VARCHAR(100) | NO |
| email_subject | VARCHAR(100) | NO |
| email_events | TEXT | NO |
CREATE TABLE Statement
CREATE TABLE wp_fe_event_email_log ( id BIGINT NOT NULL AUTO_INCREMENT, event_id BIGINT(20) UNSIGNED NOT NULL, order_id BIGINT(20) UNSIGNED NOT NULL, date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_modified DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, provider_id ENUM('local','smtp','amazon','brevo','mailgun','mailjet','postmark','sendgrid','smtp2go','sparkpost') NOT NULL DEFAULT 'local', email_type ENUM('normal','confirm','free') NOT NULL DEFAULT 'normal', provider_email_id VARCHAR(100) NOT NULL, sender_email VARCHAR(100) NOT NULL, receiver_email VARCHAR(100) NOT NULL, email_subject VARCHAR(100) NOT NULL, email_events TEXT NOT NULL, PRIMARY KEY (id), UNIQUE KEY provider_email_id_index (provider_email_id), UNIQUE KEY order_date_index (order_id, date_created) ) 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_email_log`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Fast Events