{"table_name":"elmlemag_submissions","full_table_name":"wp_elmlemag_submissions","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"medium","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","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}],"plugin":{"slug":"unjacketed-ebook-lead-magnets","name":"Unjacketed Ebook Lead Magnets","active_installs":0,"version":"0.1.0","wp_org_url":"https://wordpress.org/plugins/unjacketed-ebook-lead-magnets/"}}