{"table_name":"ec_email_queue","full_table_name":"wp_ec_email_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","create_sql":"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;\" );","columns":[{"name":"queue_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"email_type","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"channel","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"to_email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"subject","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"message","type":"longtext","nullable":true,"primary_key":false},{"name":"headers","type":"text","nullable":true,"primary_key":false},{"name":"attempts","type":"int(11)","nullable":false,"primary_key":false},{"name":"next_attempt","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"last_error","type":"text","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-easycart","name":"WP EasyCart: Shopping Cart and eCommerce Store","active_installs":3000,"version":"6.0.5","wp_org_url":"https://wordpress.org/plugins/wp-easycart/"}}