{"table_name":"mailnest_campaigns","full_table_name":"wp_mailnest_campaigns","description":"Stores mailnest campaigns data created by this plugin.","detection_method":"static","confidence":"high","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;\" );","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}],"plugin":{"slug":"mailnest","name":"MailNest","active_installs":0,"version":"1.0.5","wp_org_url":"https://wordpress.org/plugins/mailnest/"}}