wp_auto_mail_queue
StaticA job queue table for managing background tasks and scheduled operations.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) unsigned | NO |
| camp_id | int(11) | YES |
| status | ENUM('sending','sent','scheduled') | NO |
| subscriber | text | YES |
| name | text | YES |
| created_at | DECIMAL(16, 6) | NO |
| updated_at | DECIMAL(16, 6) | NO |
| deleted_at | DECIMAL(16, 6) | NO |
| automation_id | bigint | YES |
| title | text | YES |
| name | text | YES |
| type | text | YES |
| status | ENUM('active','draft') | NO |
| position | int | NO |
| date | datetime | NO |
| action_id | bigint | YES |
| meta_key | VARCHAR(255) | YES |
| meta_value | LONGTEXT | YES |
| automation_id | bigint | YES |
| title | text | YES |
| type | text | YES |
| status | ENUM('active','draft') | NO |
| position | int | NO |
| date | datetime | NO |
| VARCHAR(100) | YES | |
| cart_contents | LONGTEXT | YES |
| cart_total | DECIMAL(10,2) | YES |
| session_id | VARCHAR(60) | NO |
| other_fields | LONGTEXT | YES |
| order_status | ENUM( 'normal','abandoned','completed','lost') | NO |
| unsubscribed | boolean | YES |
| coupon_code | VARCHAR(50) | YES |
| time | DATETIME | YES |
| status | ENUM('schedule','sent') | NO |
| schedule_time | bigint | NO |
| subject | text | YES |
| message | LONGTEXT | YES |
| from | text | YES |
| to | VARCHAR(100) | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_auto_mail_queue` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `camp_id` int(11) DEFAULT NULL, `status` ENUM('sending','sent','scheduled') NOT NULL DEFAULT 'scheduled', `subscriber` text DEFAULT NULL, `name` text DEFAULT NULL, `created_at` DECIMAL(16, 6) NOT NULL, `updated_at` DECIMAL(16, 6) NOT NULL, `deleted_at` DECIMAL(16, 6) NOT NULL, PRIMARY KEY (`id`) ) CHARACTER SET utf8 COLLATE utf8_general_ci;", "CREATE TABLE IF NOT EXISTS `wp_am_automation_actions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `automation_id` bigint DEFAULT NULL, `title` text DEFAULT NULL, `name` text DEFAULT NULL, `type` text DEFAULT NULL, `status` ENUM('active','draft') NOT NULL DEFAULT 'active', `position` int NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`id`) ) CHARACTER SET utf8 COLLATE utf8_general_ci;", "CREATE TABLE IF NOT EXISTS `wp_am_automation_actions_meta` ( `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT, `action_id` bigint DEFAULT NULL, `meta_key` VARCHAR(255), `meta_value` LONGTEXT, PRIMARY KEY (`meta_id`) ) CHARACTER SET utf8 COLLATE utf8_general_ci;", "CREATE TABLE IF NOT EXISTS `wp_am_automation_triggers` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `automation_id` bigint DEFAULT NULL, `title` text DEFAULT NULL, `type` text DEFAULT NULL, `status` ENUM('active','draft') NOT NULL DEFAULT 'active', `position` int NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`id`) ) CHARACTER SET utf8 COLLATE utf8_general_ci;", "CREATE TABLE IF NOT EXISTS `wp_am_cart_abandonment` ( id BIGINT(20) NOT NULL AUTO_INCREMENT, checkout_id int(11) NOT NULL, email VARCHAR(100), cart_contents LONGTEXT, cart_total DECIMAL(10,2), session_id VARCHAR(60) NOT NULL, other_fields LONGTEXT, order_status ENUM( 'normal','abandoned','completed','lost') NOT NULL DEFAULT 'normal', unsubscribed boolean DEFAULT 0, coupon_code VARCHAR(50), time DATETIME DEFAULT NULL, PRIMARY KEY (`id`, `session_id`), UNIQUE KEY `session_id_UNIQUE` (`session_id`) ) CHARACTER SET utf8 COLLATE utf8_general_ci;", "CREATE TABLE IF NOT EXISTS `wp_am_automation_emails` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `status` ENUM('schedule','sent') NOT NULL DEFAULT 'schedule', `schedule_time` bigint NOT NULL, `subject` text DEFAULT NULL, `message` LONGTEXT DEFAULT NULL, `from` text DEFAULT NULL, `to` VARCHAR(100) DEFAULT NULL, PRIMARY KEY (`id`) ) CHARACTER SET utf8 COLLATE utf8_general_ci;", ]; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );Safe to delete?
If you have uninstalled Auto Mail – Abandoned Cart Recovery, Newsletter Builder & Marketing Automation for WooCommerce, 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_auto_mail_queue`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Auto Mail – Abandoned Cart Recovery, Newsletter Builder & Marketing Automation for WooCommerce