wp_conflict_radar_events
StaticStores conflict radar events data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| event_type | varchar(50) | NO |
| plugin_slug | varchar(191) | NO |
| plugin_name | varchar(191) | NO |
| version_from | varchar(50) | NO |
| version_to | varchar(50) | NO |
| update_source | varchar(20) | NO |
| triggered_by_user | bigint(20) unsigned | NO |
| snapshot_data | longtext | YES |
| correlation_id | bigint(20) unsigned | NO |
| created_at | datetime | NO |
| error_type | varchar(20) | NO |
| error_message | text | NO |
| error_file | varchar(500) | NO |
| error_line | int(11) unsigned | NO |
| raw_entry | text | NO |
| log_hash | char(32) | NO |
| event_correlation_id | bigint(20) unsigned | NO |
| correlation_confidence | varchar(10) | NO |
| logged_at | datetime | NO |
| created_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_conflict_radar_events ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, event_type varchar(50) NOT NULL, plugin_slug varchar(191) NOT NULL DEFAULT '', plugin_name varchar(191) NOT NULL DEFAULT '', version_from varchar(50) NOT NULL DEFAULT '', version_to varchar(50) NOT NULL DEFAULT '', update_source varchar(20) NOT NULL DEFAULT 'manual', triggered_by_user bigint(20) unsigned NOT NULL DEFAULT 0, snapshot_data longtext DEFAULT NULL, correlation_id bigint(20) unsigned NOT NULL DEFAULT 0, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY event_type (event_type), KEY plugin_slug (plugin_slug), KEY created_at (created_at), KEY correlation_id (correlation_id) ) $charset_collate;"; $sql_logs = "CREATE TABLE wp_conflict_radar_logs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, error_type varchar(20) NOT NULL, error_message text NOT NULL, error_file varchar(500) NOT NULL DEFAULT '', error_line int(11) unsigned NOT NULL DEFAULT 0, raw_entry text NOT NULL, log_hash char(32) NOT NULL DEFAULT '', event_correlation_id bigint(20) unsigned NOT NULL DEFAULT 0, correlation_confidence varchar(10) NOT NULL DEFAULT '', logged_at datetime NOT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY log_hash (log_hash), KEY error_type (error_type), KEY logged_at (logged_at), KEY created_at (created_at), KEY event_correlation_id (event_correlation_id) ) $charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql_events );
Safe to delete?
If you have uninstalled Conflict Radar, 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_conflict_radar_events`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Conflict Radar