wp_attic_scans
StaticStores attic scans data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint unsigned | NO |
| started_at | datetime | NO |
| finished_at | datetime | YES |
| status | varchar(20) | NO |
| ruleset_version | varchar(20) | NO |
| wp_version | varchar(20) | NO |
| stats | longtext | YES |
| scan_id | bigint unsigned | NO |
| rule | varchar(64) | NO |
| target_type | varchar(20) | NO |
| target_key | varchar(191) | NO |
| size_bytes | bigint unsigned | NO |
| confidence | varchar(10) | NO |
| attributed_slug | varchar(191) | YES |
| attributed_state | varchar(20) | NO |
| code_refs | smallint unsigned | NO |
| prefix_refs | smallint unsigned | NO |
| evidence | longtext | YES |
| state | varchar(20) | NO |
| fingerprint | char(40) | NO |
| first_seen_scan | bigint unsigned | NO |
| last_seen_scan | bigint unsigned | NO |
| created_at | datetime | NO |
| created_by | bigint unsigned | NO |
| note | varchar(255) | YES |
| item_count | int unsigned | NO |
| restored_at | datetime | YES |
| purge_after | datetime | YES |
| batch_id | bigint unsigned | NO |
| target_type | varchar(20) | NO |
| target_key | varchar(191) | NO |
| payload | longtext | YES |
| restore_hint | longtext | YES |
| restored_at | datetime | YES |
| last_seen_at | datetime | YES |
| seen_count | bigint unsigned | NO |
CREATE TABLE Statement
CREATE TABLE wp_attic_scans ( id bigint unsigned NOT NULL AUTO_INCREMENT, started_at datetime NOT NULL, finished_at datetime NULL, status varchar(20) NOT NULL DEFAULT 'running', ruleset_version varchar(20) NOT NULL, wp_version varchar(20) NOT NULL, stats longtext NULL, PRIMARY KEY (id), KEY status (status) ) $cs", "CREATE TABLE wp_attic_findings ( id bigint unsigned NOT NULL AUTO_INCREMENT, scan_id bigint unsigned NOT NULL, rule varchar(64) NOT NULL, target_type varchar(20) NOT NULL, target_key varchar(191) NOT NULL, size_bytes bigint unsigned NOT NULL DEFAULT 0, confidence varchar(10) NOT NULL DEFAULT 'review', attributed_slug varchar(191) NULL, attributed_state varchar(20) NOT NULL DEFAULT 'unknown', code_refs smallint unsigned NOT NULL DEFAULT 0, prefix_refs smallint unsigned NOT NULL DEFAULT 0, evidence longtext NULL, state varchar(20) NOT NULL DEFAULT 'open', fingerprint char(40) NOT NULL, first_seen_scan bigint unsigned NOT NULL DEFAULT 0, last_seen_scan bigint unsigned NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY scan_fingerprint (scan_id, fingerprint), KEY rule (rule), KEY state_confidence (state, confidence) ) $cs", "CREATE TABLE wp_attic_quarantine_batches ( id bigint unsigned NOT NULL AUTO_INCREMENT, created_at datetime NOT NULL, created_by bigint unsigned NOT NULL, note varchar(255) NULL, item_count int unsigned NOT NULL DEFAULT 0, restored_at datetime NULL, purge_after datetime NULL, PRIMARY KEY (id) ) $cs", "CREATE TABLE wp_attic_quarantine ( id bigint unsigned NOT NULL AUTO_INCREMENT, batch_id bigint unsigned NOT NULL, target_type varchar(20) NOT NULL, target_key varchar(191) NOT NULL, payload longtext NULL, restore_hint longtext NULL, restored_at datetime NULL, PRIMARY KEY (id), KEY batch_id (batch_id) ) $cs", "CREATE TABLE wp_attic_usage ( option_name varchar(191) NOT NULL, last_seen_at datetime NULL, seen_count bigint unsigned NOT NULL DEFAULT 0, PRIMARY KEY (option_name) ) $cs", ]; } private static function migrate(): void { require_once ABSPATH . 'wp-admin/includes/upgrade.php'; global $wpdb; foreach ( self::tables() as $sql ) { dbDelta( $sql );Safe to delete?
If you have uninstalled Attic — Safe Database Cleanup (Undo-Friendly), 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_attic_scans`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Attic — Safe Database Cleanup (Undo-Friendly)