wp_cd_plugin_changes
StaticStores cd plugin changes data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| plugin_slug | VARCHAR(255) | NO |
| plugin_name | VARCHAR(255) | NO |
| action | VARCHAR(50) | NO |
| plugin_version | VARCHAR(50) | YES |
| previous_version | VARCHAR(50) | YES |
| changed_at | DATETIME | NO |
| error_type | VARCHAR(50) | NO |
| message | TEXT | NO |
| file | VARCHAR(500) | YES |
| line | INT(11) UNSIGNED | YES |
| plugin_slug | VARCHAR(255) | YES |
| plugin_name | VARCHAR(255) | YES |
| occurred_at | DATETIME | NO |
| scan_type | VARCHAR(50) | NO |
| result | LONGTEXT | NO |
| issues_found | INT(11) UNSIGNED | YES |
| scanned_at | DATETIME | NO |
| plugin_slug | VARCHAR(255) | NO |
| plugin_name | VARCHAR(255) | NO |
| action | VARCHAR(50) | NO |
| changed_at | DATETIME | NO |
| error_count | INT(11) UNSIGNED | YES |
| confidence | TINYINT(3) UNSIGNED | YES |
| reason | TEXT | YES |
| resolved | TINYINT(1) | NO |
| detected_at | DATETIME | NO |
| type | VARCHAR(10) | NO |
| action | VARCHAR(200) | NO |
| duration_ms | INT(11) | NO |
| status_code | SMALLINT(6) | NO |
| user_id | BIGINT(20) UNSIGNED | NO |
| created_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_cd_plugin_changes ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, plugin_slug VARCHAR(255) NOT NULL, plugin_name VARCHAR(255) NOT NULL, action VARCHAR(50) NOT NULL, plugin_version VARCHAR(50) DEFAULT '', previous_version VARCHAR(50) DEFAULT '', changed_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_changed_at (changed_at), KEY idx_plugin_slug (plugin_slug(100)) ) $collate;", "CREATE TABLE IF NOT EXISTS wp_cd_errors ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, error_type VARCHAR(50) NOT NULL, message TEXT NOT NULL, file VARCHAR(500) DEFAULT '', line INT(11) UNSIGNED DEFAULT 0, plugin_slug VARCHAR(255) DEFAULT '', plugin_name VARCHAR(255) DEFAULT '', occurred_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_occurred_at (occurred_at), KEY idx_plugin_slug (plugin_slug(100)) ) $collate;", "CREATE TABLE IF NOT EXISTS wp_cd_scans ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, scan_type VARCHAR(50) NOT NULL, result LONGTEXT NOT NULL, issues_found INT(11) UNSIGNED DEFAULT 0, scanned_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_scanned_at (scanned_at) ) $collate;", // Phase 2: stored conflict detections. "CREATE TABLE IF NOT EXISTS wp_cd_conflicts ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, plugin_slug VARCHAR(255) NOT NULL, plugin_name VARCHAR(255) NOT NULL, action VARCHAR(50) NOT NULL, changed_at DATETIME NOT NULL, error_count INT(11) UNSIGNED DEFAULT 0, confidence TINYINT(3) UNSIGNED DEFAULT 0, reason TEXT DEFAULT '', resolved TINYINT(1) NOT NULL DEFAULT 0, detected_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_detected_at (detected_at), KEY idx_plugin_slug (plugin_slug(100)) ) $collate;", // Phase 3: AJAX / REST slow-call log. "CREATE TABLE IF NOT EXISTS wp_cd_ajax_log ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, type VARCHAR(10) NOT NULL DEFAULT 'ajax', action VARCHAR(200) NOT NULL DEFAULT '', duration_ms INT(11) NOT NULL DEFAULT 0, status_code SMALLINT(6) NOT NULL DEFAULT 200, user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY type_created (type, created_at) ) $collate;", );
Safe to delete?
If you have uninstalled Tahhan Conflict Detective, 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_cd_plugin_changes`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Tahhan Conflict Detective