wp_ec_email_queue
StaticA job queue table for managing background tasks and scheduled operations.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑queue_id | int(11) | NO |
| created_at | datetime | YES |
| email_type | varchar(40) | NO |
| order_id | int(11) | NO |
| channel | varchar(20) | NO |
| to_email | varchar(255) | NO |
| subject | varchar(255) | NO |
| message | longtext | YES |
| headers | text | YES |
| attempts | int(11) | NO |
| next_attempt | datetime | YES |
| status | varchar(20) | NO |
| last_error | text | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS ec_email_queue ( queue_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', channel varchar(20) NOT NULL DEFAULT 'order', to_email varchar(255) NOT NULL DEFAULT '', subject varchar(255) NOT NULL DEFAULT '', message longtext, headers text, attempts int(11) NOT NULL DEFAULT '0', next_attempt datetime DEFAULT NULL, status varchar(20) NOT NULL DEFAULT 'pending', last_error text, PRIMARY KEY (queue_id), KEY status_next (status, next_attempt), KEY order_id (order_id) ) $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_queue`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP EasyCart: Shopping Cart and eCommerce Store