wp_ec_email_log
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑log_id | int(11) | NO |
| created_at | datetime | YES |
| email_type | varchar(40) | NO |
| order_id | int(11) | NO |
| to_email | varchar(255) | NO |
| subject | varchar(255) | NO |
| transport | varchar(30) | NO |
| status | varchar(20) | NO |
| error_text | text | YES |
| attempts | int(11) | NO |
| queue_id | int(11) | NO |
| body_hash | varchar(40) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS ec_email_log ( log_id int(11) NOT NULL AUTO_INCREMENT, created_at datetime DEFAULT NULL, email_type varchar(40) NOT NULL DEFAULT '', order_id int(11) NOT NULL DEFAULT '0', to_email varchar(255) NOT NULL DEFAULT '', subject varchar(255) NOT NULL DEFAULT '', transport varchar(30) NOT NULL DEFAULT '', status varchar(20) NOT NULL DEFAULT '', error_text text, attempts int(11) NOT NULL DEFAULT '1', queue_id int(11) NOT NULL DEFAULT '0', body_hash varchar(40) NOT NULL DEFAULT '', PRIMARY KEY (log_id), KEY created_at (created_at), KEY order_id (order_id), KEY status (status), KEY to_email (to_email(100)) ) $collate;" );
Safe to delete?
If you have uninstalled WP EasyCart: Shopping Cart and eCommerce Store, 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_ec_email_log`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP EasyCart: Shopping Cart and eCommerce Store