{"table_name":"auto_mail_queue","full_table_name":"wp_auto_mail_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"medium","create_sql":"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' );","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"camp_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"status","type":"ENUM('sending','sent','scheduled')","nullable":false,"primary_key":false},{"name":"subscriber","type":"text","nullable":true,"primary_key":false},{"name":"name","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"DECIMAL(16, 6)","nullable":false,"primary_key":false},{"name":"updated_at","type":"DECIMAL(16, 6)","nullable":false,"primary_key":false},{"name":"deleted_at","type":"DECIMAL(16, 6)","nullable":false,"primary_key":false},{"name":"automation_id","type":"bigint","nullable":true,"primary_key":false},{"name":"title","type":"text","nullable":true,"primary_key":false},{"name":"name","type":"text","nullable":true,"primary_key":false},{"name":"type","type":"text","nullable":true,"primary_key":false},{"name":"status","type":"ENUM('active','draft')","nullable":false,"primary_key":false},{"name":"position","type":"int","nullable":false,"primary_key":false},{"name":"date","type":"datetime","nullable":false,"primary_key":false},{"name":"action_id","type":"bigint","nullable":true,"primary_key":false},{"name":"meta_key","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"automation_id","type":"bigint","nullable":true,"primary_key":false},{"name":"title","type":"text","nullable":true,"primary_key":false},{"name":"type","type":"text","nullable":true,"primary_key":false},{"name":"status","type":"ENUM('active','draft')","nullable":false,"primary_key":false},{"name":"position","type":"int","nullable":false,"primary_key":false},{"name":"date","type":"datetime","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"cart_contents","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"cart_total","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"session_id","type":"VARCHAR(60)","nullable":false,"primary_key":false},{"name":"other_fields","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"order_status","type":"ENUM( 'normal','abandoned','completed','lost')","nullable":false,"primary_key":false},{"name":"unsubscribed","type":"boolean","nullable":true,"primary_key":false},{"name":"coupon_code","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"time","type":"DATETIME","nullable":true,"primary_key":false},{"name":"status","type":"ENUM('schedule','sent')","nullable":false,"primary_key":false},{"name":"schedule_time","type":"bigint","nullable":false,"primary_key":false},{"name":"subject","type":"text","nullable":true,"primary_key":false},{"name":"message","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"from","type":"text","nullable":true,"primary_key":false},{"name":"to","type":"VARCHAR(100)","nullable":true,"primary_key":false}],"plugin":{"slug":"auto-mail","name":"Auto Mail – Abandoned Cart Recovery, Newsletter Builder & Marketing Automation for WooCommerce","active_installs":10,"version":"1.2.37","wp_org_url":"https://wordpress.org/plugins/auto-mail/"}}