{"slug":"mailnest","name":"MailNest","description":"Your complete newsletter, right inside WordPress. No limits. No upgrade walls. Your data.","author":"Stanley Okonkwo","active_installs":0,"version":"1.0.5","wp_org_url":"https://wordpress.org/plugins/mailnest/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"mailnest_campaigns","full_table_name":"wp_mailnest_campaigns","description":"Stores mailnest campaigns data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"subject","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"preview_text","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"body","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('draft','scheduled','sending','sent','paused','archived')","nullable":false,"primary_key":false},{"name":"scheduled_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"sent_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_mailnest_campaigns ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(255) NOT NULL, subject VARCHAR(255) NOT NULL, preview_text VARCHAR(255) DEFAULT '', body LONGTEXT NOT NULL, status ENUM('draft','scheduled','sending','sent','paused','archived') NOT NULL DEFAULT 'draft', scheduled_at DATETIME DEFAULT NULL, sent_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status_idx (status) ) $charset;\" );"},{"table_name":"mailnest_clicks","full_table_name":"wp_mailnest_clicks","description":"Stores mailnest clicks data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"campaign_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"subscriber_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"original_url","type":"TEXT","nullable":false,"primary_key":false},{"name":"clicked_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_mailnest_clicks ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, campaign_id BIGINT(20) UNSIGNED NOT NULL, subscriber_id BIGINT(20) UNSIGNED NOT NULL, original_url TEXT NOT NULL, clicked_at DATETIME DEFAULT CURRENT_TIMESTAMP, ip_address VARCHAR(45) DEFAULT NULL, PRIMARY KEY (id), KEY campaign_sub (campaign_id, subscriber_id) ) $charset;\" );"},{"table_name":"mailnest_opens","full_table_name":"wp_mailnest_opens","description":"Stores mailnest opens data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"campaign_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"subscriber_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"opened_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_mailnest_opens ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, campaign_id BIGINT(20) UNSIGNED NOT NULL, subscriber_id BIGINT(20) UNSIGNED NOT NULL, opened_at DATETIME DEFAULT CURRENT_TIMESTAMP, ip_address VARCHAR(45) DEFAULT NULL, PRIMARY KEY (id), KEY campaign_sub (campaign_id, subscriber_id), KEY opened_at_idx (opened_at) ) $charset;\" );"},{"table_name":"mailnest_queue","full_table_name":"wp_mailnest_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"campaign_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"subscriber_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('pending','sent','failed')","nullable":false,"primary_key":false},{"name":"sent_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"error_msg","type":"TEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_mailnest_queue ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, campaign_id BIGINT(20) UNSIGNED NOT NULL, subscriber_id BIGINT(20) UNSIGNED NOT NULL, status ENUM('pending','sent','failed') NOT NULL DEFAULT 'pending', sent_at DATETIME DEFAULT NULL, error_msg TEXT DEFAULT NULL, PRIMARY KEY (id), KEY campaign_status (campaign_id, status) ) $charset;\" );"},{"table_name":"mailnest_subscribers","full_table_name":"wp_mailnest_subscribers","description":"Stores mailnest subscribers data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"email","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"first_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"last_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"status","type":"ENUM('pending','confirmed','unsubscribed')","nullable":false,"primary_key":false},{"name":"confirm_token","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"subscribed_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":true,"primary_key":false},{"name":"meta_reeng_sent","type":"DATETIME","nullable":true,"primary_key":false},{"name":"meta_reeng_opened","type":"TINYINT(1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_mailnest_subscribers ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, email VARCHAR(255) NOT NULL, first_name VARCHAR(100) DEFAULT '', last_name VARCHAR(100) DEFAULT '', status ENUM('pending','confirmed','unsubscribed') NOT NULL DEFAULT 'pending', confirm_token VARCHAR(64) DEFAULT NULL, subscribed_at DATETIME DEFAULT CURRENT_TIMESTAMP, ip_address VARCHAR(45) DEFAULT NULL, meta_reeng_sent DATETIME DEFAULT NULL, meta_reeng_opened TINYINT(1) DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY email (email), KEY status_idx (status) ) $charset;\" );"},{"table_name":"mailnest_welcome_queue","full_table_name":"wp_mailnest_welcome_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"subscriber_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"step_index","type":"TINYINT(3) UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('pending','sent','failed','skipped')","nullable":false,"primary_key":false},{"name":"send_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"sent_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_mailnest_welcome_queue ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, subscriber_id BIGINT(20) UNSIGNED NOT NULL, step_index TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, status ENUM('pending','sent','failed','skipped') NOT NULL DEFAULT 'pending', send_at DATETIME NOT NULL, sent_at DATETIME DEFAULT NULL, PRIMARY KEY (id), KEY subscriber_status (subscriber_id, status), KEY send_at_status (send_at, status) ) $charset;\");"}],"table_count":6}