{"table_name":"cdemv_domains","full_table_name":"wp_cdemv_domains","description":"Stores cdemv domains data created by this plugin.","detection_method":"static","confidence":"medium","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;\" );","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}],"plugin":{"slug":"capably-digital-email-validation","name":"Capably Digital Email Validation and Blocklist","active_installs":0,"version":"0.2.0","wp_org_url":"https://wordpress.org/plugins/capably-digital-email-validation/"}}