{"slug":"unjacketed-ebook-lead-magnets","name":"Unjacketed Ebook Lead Magnets","description":"Deliver a free ebook via email opt-in with daily availability limits, social proof toasts, and Brevo integration.","author":"unjacketed","active_installs":0,"version":"0.1.0","wp_org_url":"https://wordpress.org/plugins/unjacketed-ebook-lead-magnets/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"elmlemag_magnets","full_table_name":"wp_elmlemag_magnets","description":"Stores elmlemag magnets data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"pitch_line","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"button_initial","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"button_label","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"pdf_path","type":"VARCHAR(512)","nullable":true,"primary_key":false},{"name":"epub_path","type":"VARCHAR(512)","nullable":true,"primary_key":false},{"name":"brevo_list_id","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"from_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"from_email","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"email_subject","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"email_body","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"daily_limit","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"max_downloads","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"active","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_elmlemag_magnets ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(255) NOT NULL DEFAULT '', pitch_line VARCHAR(255) NOT NULL DEFAULT '', button_initial VARCHAR(255) NOT NULL DEFAULT '', button_label VARCHAR(255) NOT NULL DEFAULT '', pdf_path VARCHAR(512) DEFAULT NULL, epub_path VARCHAR(512) DEFAULT NULL, brevo_list_id VARCHAR(64) DEFAULT NULL, from_name VARCHAR(255) DEFAULT NULL, from_email VARCHAR(255) DEFAULT NULL, email_subject VARCHAR(255) NOT NULL DEFAULT '', email_body LONGTEXT NOT NULL DEFAULT '', daily_limit INT UNSIGNED NOT NULL DEFAULT 0, max_downloads TINYINT UNSIGNED NOT NULL DEFAULT 3, active TINYINT(1) NOT NULL DEFAULT 1, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE"},{"table_name":"elmlemag_meta","full_table_name":"wp_elmlemag_meta","description":"Stores additional metadata (key-value pairs) for elmlemag records.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"meta_key","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"meta_value","type":"LONGTEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_elmlemag_meta ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, meta_key VARCHAR(100) NOT NULL, meta_value LONGTEXT, PRIMARY KEY (id), UNIQUE KEY meta_key (meta_key) ) ENGINE"},{"table_name":"elmlemag_submissions","full_table_name":"wp_elmlemag_submissions","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"magnet_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"first_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"cookie_id","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"submitted_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"download_token","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"unsubscribe_token","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"pdf_downloads","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"epub_downloads","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"brevo_added","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"unsubscribed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"unsubscribed_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"resend_count","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"resend_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_elmlemag_submissions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, magnet_id BIGINT UNSIGNED NOT NULL, first_name VARCHAR(100) NOT NULL DEFAULT '', email VARCHAR(255) NOT NULL, ip_address VARCHAR(45) NOT NULL DEFAULT '', cookie_id VARCHAR(64) DEFAULT NULL, submitted_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, download_token VARCHAR(64) NOT NULL, unsubscribe_token VARCHAR(64) NOT NULL, pdf_downloads TINYINT UNSIGNED NOT NULL DEFAULT 0, epub_downloads TINYINT UNSIGNED NOT NULL DEFAULT 0, brevo_added TINYINT(1) NOT NULL DEFAULT 0, unsubscribed TINYINT(1) NOT NULL DEFAULT 0, unsubscribed_at DATETIME DEFAULT NULL, resend_count TINYINT UNSIGNED NOT NULL DEFAULT 0, resend_at DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY download_token (download_token), UNIQUE KEY unsubscribe_token (unsubscribe_token), KEY idx_magnet (magnet_id), KEY idx_email_magnet (magnet_id, email) ) ENGINE"}],"table_count":3}