{"table_name":"crmlytics_email_campaigns","full_table_name":"wp_crmlytics_email_campaigns","description":"Stores crmlytics email campaigns data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_crmlytics_email_campaigns ( id BIGINT(20) UNSIGNED AUTO_INCREMENT PRIMARY KEY, campaign_name VARCHAR(255) NOT NULL, campaign_type ENUM('manual','automated') DEFAULT 'manual', target_type ENUM('all','tags','segment') DEFAULT 'all', target_tags JSON, target_segment_id BIGINT(20) UNSIGNED, subject VARCHAR(255), preheader VARCHAR(255), body LONGTEXT, template VARCHAR(50) DEFAULT 'basic', utm_source VARCHAR(50) DEFAULT 'crmlytics', utm_medium VARCHAR(50) DEFAULT 'email', utm_campaign VARCHAR(100), recipient_count INT(10) DEFAULT 0, sent_count INT(10) DEFAULT 0, failed_count INT(10) DEFAULT 0, click_count INT(10) DEFAULT 0, status ENUM('draft','scheduled','sending','sent','paused') DEFAULT 'draft', scheduled_at DATETIME, sent_at DATETIME, created_at DATETIME, updated_at DATETIME ) $charset_collate;\"; dbDelta($sql);","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":true},{"name":"campaign_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"campaign_type","type":"ENUM('manual','automated')","nullable":true,"primary_key":false},{"name":"target_type","type":"ENUM('all','tags','segment')","nullable":true,"primary_key":false},{"name":"target_tags","type":"JSON","nullable":true,"primary_key":false},{"name":"target_segment_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"subject","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"preheader","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"body","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"template","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"utm_source","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"utm_medium","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"utm_campaign","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"recipient_count","type":"INT(10)","nullable":true,"primary_key":false},{"name":"sent_count","type":"INT(10)","nullable":true,"primary_key":false},{"name":"failed_count","type":"INT(10)","nullable":true,"primary_key":false},{"name":"click_count","type":"INT(10)","nullable":true,"primary_key":false},{"name":"status","type":"ENUM('draft','scheduled','sending','sent','paused')","nullable":true,"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},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false}],"plugin":{"slug":"crmlytics","name":"CRMlytics – WooCommerce CRM & Customer Analytics","active_installs":0,"version":"1.0.2","wp_org_url":"https://wordpress.org/plugins/crmlytics/"}}