wp_contenttrace_duplicates
StaticStores contenttrace duplicates data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | NO |
| post_id | bigint(20) | NO |
| source_url | varchar(500) | NO |
| score | decimal(5,2) | NO |
| found_at | datetime | YES |
| notified | tinyint(1) | YES |
| notified_email | varchar(255) | YES |
| notified_at | datetime | YES |
| status | varchar(50) | YES |
| created_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE wp_contenttrace_duplicates ( id bigint(20) NOT NULL AUTO_INCREMENT, post_id bigint(20) NOT NULL, source_url varchar(500) NOT NULL, score decimal(5,2) NOT NULL, found_at datetime DEFAULT CURRENT_TIMESTAMP, notified tinyint(1) DEFAULT 0, notified_email varchar(255) DEFAULT NULL, notified_at datetime DEFAULT NULL, status varchar(50) DEFAULT 'new', created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY post_id (post_id), KEY score (score), KEY status (status) ) {$charset_collate};"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );Safe to delete?
If you have uninstalled ContentTrace, 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_contenttrace_duplicates`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.