wp_cdemv_domains
StaticStores cdemv domains data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | NO |
| domain | varchar(255) | NO |
| instruction | varchar(20) | NO |
| source | varchar(20) | NO |
| added_at | int(10) | NO |
| local_part | varchar(255) | NO |
| domain_id | bigint(20) | NO |
| instruction | varchar(20) | NO |
| source | varchar(20) | NO |
| added_at | int(10) | NO |
| logged_at | int | NO |
| log_type | varchar(20) | NO |
| log_reason | varchar(50) | NO |
| email_to | varchar(255) | NO |
| email_subject | varchar(255) | YES |
| log_data | longtext | YES |
CREATE TABLE Statement
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;" );
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