{"table_name":"data_recovery_runs","full_table_name":"wp_data_recovery_runs","description":"Stores data recovery runs data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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);","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"source_filename","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"upload_token","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"file_exists","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"date_from","type":"DATE","nullable":true,"primary_key":false},{"name":"date_to","type":"DATE","nullable":true,"primary_key":false},{"name":"revision_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"rows_in_file","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"rows_inserted","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"rows_skipped_duplicate","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"rows_unresolved_url","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(16)","nullable":false,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"run_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"a_day","type":"DATE","nullable":false,"primary_key":false},{"name":"a_url","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"object_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"object_type","type":"VARCHAR(16)","nullable":false,"primary_key":false},{"name":"post_type","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"total_visits","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"outcome","type":"ENUM('inserted','skipped_duplicate','unresolved_url')","nullable":false,"primary_key":false},{"name":"page_visits_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false}],"plugin":{"slug":"first-party-analytics","name":"First Party Analytics","active_installs":0,"version":"1.2.63","wp_org_url":"https://wordpress.org/plugins/first-party-analytics/"}}