{"slug":"capably-digital-email-validation","name":"Capably Digital Email Validation and Blocklist","description":"Easily set up email blocklists and mx checking to reduce bounce rates and unwanted signups, reducing email volume and protecting sender reputation.","author":"Capably Digital","active_installs":0,"version":"0.2.0","wp_org_url":"https://wordpress.org/plugins/capably-digital-email-validation/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cdemv_domains","full_table_name":"wp_cdemv_domains","description":"Stores cdemv domains data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"domain","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"instruction","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"source","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"added_at","type":"int(10)","nullable":false,"primary_key":false},{"name":"local_part","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"domain_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"instruction","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"source","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"added_at","type":"int(10)","nullable":false,"primary_key":false},{"name":"logged_at","type":"int","nullable":false,"primary_key":false},{"name":"log_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"log_reason","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"email_to","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email_subject","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"log_data","type":"longtext","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_cdemv_domains ( id bigint(20) NOT NULL AUTO_INCREMENT, domain varchar(255) NOT NULL, instruction varchar(20) DEFAULT 'blacklist' NOT NULL, source varchar(20) DEFAULT 'dash' NOT NULL, added_at int(10) DEFAULT 0 NOT NULL, PRIMARY KEY (id), UNIQUE KEY domain (domain) ) $cdemv_charset_collate;\", \"CREATE TABLE wp_cdemv_locals ( id bigint(20) NOT NULL AUTO_INCREMENT, local_part varchar(255) NOT NULL, domain_id bigint(20) NOT NULL, instruction varchar(20) DEFAULT 'blacklist' NOT NULL, source varchar(20) DEFAULT 'dash' NOT NULL, added_at int(10) DEFAULT 0 NOT NULL, PRIMARY KEY (id), UNIQUE KEY domain_id_local_part (domain_id,local_part), KEY local_part (local_part) ) $cdemv_charset_collate;\", \"CREATE TABLE wp_cdemv_logs ( id bigint(20) NOT NULL AUTO_INCREMENT, logged_at int DEFAULT 0 NOT NULL, log_type varchar(20) NOT NULL, log_reason varchar(50) NOT NULL, email_to varchar(255) NOT NULL, email_subject varchar(255), log_data longtext, PRIMARY KEY (id), KEY logged_at (logged_at), KEY email_to (email_to) ) $cdemv_charset_collate;\" );"},{"table_name":"cdemv_locals","full_table_name":"wp_cdemv_locals","description":"Stores cdemv locals data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cdemv_logs","full_table_name":"wp_cdemv_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":3}