wp_data_recovery_runs
StaticStores data recovery runs data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| created_at | DATETIME | NO |
| source | VARCHAR(32) | NO |
| source_filename | VARCHAR(255) | NO |
| upload_token | VARCHAR(32) | NO |
| file_exists | TINYINT(1) | NO |
| date_from | DATE | YES |
| date_to | DATE | YES |
| revision_id | BIGINT UNSIGNED | NO |
| user_id | BIGINT UNSIGNED | NO |
| rows_in_file | INT UNSIGNED | NO |
| rows_inserted | INT UNSIGNED | NO |
| rows_skipped_duplicate | INT UNSIGNED | NO |
| rows_unresolved_url | INT UNSIGNED | NO |
| status | VARCHAR(16) | NO |
| notes | TEXT | YES |
| run_id | BIGINT UNSIGNED | NO |
| a_day | DATE | NO |
| a_url | VARCHAR(512) | NO |
| object_id | BIGINT UNSIGNED | NO |
| object_type | VARCHAR(16) | NO |
| post_type | VARCHAR(255) | NO |
| total_visits | INT UNSIGNED | NO |
| outcome | ENUM('inserted','skipped_duplicate','unresolved_url') | NO |
| page_visits_id | BIGINT UNSIGNED | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_data_recovery_runs ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, created_at DATETIME NOT NULL, source VARCHAR(32) NOT NULL, source_filename VARCHAR(255) NOT NULL, upload_token VARCHAR(32) NOT NULL DEFAULT '', file_exists TINYINT(1) NOT NULL DEFAULT 0, date_from DATE NULL, date_to DATE NULL, revision_id BIGINT UNSIGNED NOT NULL DEFAULT 0, user_id BIGINT UNSIGNED NOT NULL DEFAULT 0, rows_in_file INT UNSIGNED NOT NULL DEFAULT 0, rows_inserted INT UNSIGNED NOT NULL DEFAULT 0, rows_skipped_duplicate INT UNSIGNED NOT NULL DEFAULT 0, rows_unresolved_url INT UNSIGNED NOT NULL DEFAULT 0, status VARCHAR(16) NOT NULL DEFAULT 'committed', notes TEXT NULL, PRIMARY KEY (id), KEY idx_created_at (created_at), KEY idx_revision_id (revision_id), KEY idx_upload_token (upload_token), KEY idx_status (status) ) $collate; ", " CREATE TABLE IF NOT EXISTS wp_data_recovery_run_rows ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, run_id BIGINT UNSIGNED NOT NULL, a_day DATE NOT NULL, a_url VARCHAR(512) NOT NULL, object_id BIGINT UNSIGNED NOT NULL DEFAULT 0, object_type VARCHAR(16) NOT NULL DEFAULT '', post_type VARCHAR(255) NOT NULL DEFAULT '', total_visits INT UNSIGNED NOT NULL DEFAULT 0, unique_visits INT UNSIGNED NOT NULL DEFAULT 0, outcome ENUM('inserted','skipped_duplicate','unresolved_url') NOT NULL, page_visits_id BIGINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY idx_run_id_outcome (run_id, outcome), KEY idx_run_id_a_day (run_id, a_day) ) $collate; ", " ALTER TABLE wp_page_visits ADD COLUMN recovery_run_id BIGINT UNSIGNED NOT NULL DEFAULT 0, ADD INDEX idx_recovery_run_id (recovery_run_id);Safe to delete?
If you have uninstalled First Party Analytics, 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_data_recovery_runs`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from First Party Analytics