wp_cdemv_domains

Static

Stores cdemv domains data created by this plugin.

CREATE TABLE Statement

CREATE TABLE wp_cdemv_domains (\r\n\t\t\tid bigint(20) NOT NULL AUTO_INCREMENT,\r\n\t\t\tdomain varchar(255) NOT NULL,\r\n\t\t\tinstruction varchar(20) DEFAULT 'blacklist' NOT NULL,\r\n\t\t\tsource varchar(20) DEFAULT 'dash' NOT NULL,\r\n\t\t\tadded_at int(10) DEFAULT 0 NOT NULL,\r\n\t\t\tPRIMARY KEY (id),\r\n\t\t\tUNIQUE KEY domain (domain)\r\n\t\t) {$cdemv_charset_collate};", "CREATE TABLE wp_cdemv_locals (\r\n\t\t\tid bigint(20) NOT NULL AUTO_INCREMENT,\r\n\t\t\tlocal_part varchar(255) NOT NULL,\r\n\t\t\tdomain_id bigint(20) NOT NULL,\r\n\t\t\tinstruction varchar(20) DEFAULT 'blacklist' NOT NULL,\r\n\t\t\tsource varchar(20) DEFAULT 'dash' NOT NULL,\r\n\t\t\tadded_at int(10) DEFAULT 0 NOT NULL,\r\n\t\t\tPRIMARY KEY (id),\r\n\t\t\tUNIQUE KEY domain_id_local_part (domain_id,local_part),\r\n\t\t\tKEY local_part (local_part)\r\n\t\t) {$cdemv_charset_collate};", "CREATE TABLE wp_cdemv_logs (\r\n\t\t\tid bigint(20) NOT NULL AUTO_INCREMENT,\r\n\t\t\tlogged_at int DEFAULT 0 NOT NULL,\r\n\t\t\tlog_type varchar(20) NOT NULL,\r\n\t\t\tlog_reason varchar(50) NOT NULL,\r\n\t\t\temail_to varchar(255) NOT NULL,\r\n\t\t\temail_subject varchar(255),\r\n\t\t\tlog_data longtext,\r\n\t\t\tPRIMARY KEY (id),\r\n\t\t\tKEY logged_at (logged_at),\r\n\t\t\tKEY email_to (email_to)\r\n\t\t) {$cdemv_charset_collate};");

Safe to delete?

If you have uninstalled Capably Digital Email Validation and Blocklist, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_cdemv_domains`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Capably Digital Email Validation and Blocklist

wp_cdemv_locals wp_cdemv_logs