wp_cfr2_offload_status
StaticStores analytics or statistics data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| attachment_id | BIGINT UNSIGNED | NO |
| r2_key | VARCHAR(500) | NO |
| r2_url | VARCHAR(500) | NO |
| local_path | VARCHAR(500) | NO |
| local_exists | TINYINT(1) | YES |
| file_size | BIGINT UNSIGNED | YES |
| offloaded_at | DATETIME | YES |
| attachment_id | BIGINT UNSIGNED | NO |
| action | ENUM('offload', 'restore', 'delete_local') | NO |
| status | ENUM('pending', 'processing', 'completed', 'failed', 'cancelled') | YES |
| error_message | TEXT | YES |
| created_at | DATETIME | YES |
| processed_at | DATETIME | YES |
| date | DATE | NO |
| transformations | INT UNSIGNED | YES |
| bandwidth_bytes | BIGINT UNSIGNED | YES |
CREATE TABLE Statement
CREATE TABLE wp_cfr2_offload_status ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, attachment_id BIGINT UNSIGNED NOT NULL, r2_key VARCHAR(500) NOT NULL, r2_url VARCHAR(500) NOT NULL, local_path VARCHAR(500) NOT NULL, local_exists TINYINT(1) DEFAULT 1, file_size BIGINT UNSIGNED DEFAULT 0, offloaded_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY idx_attachment (attachment_id), KEY idx_r2_key (r2_key(191)) ) $charset_collate;"; // Queue table. $sql_queue = "CREATE TABLE wp_cfr2_offload_queue ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, attachment_id BIGINT UNSIGNED NOT NULL, action ENUM('offload', 'restore', 'delete_local') NOT NULL, status ENUM('pending', 'processing', 'completed', 'failed', 'cancelled') DEFAULT 'pending', error_message TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, processed_at DATETIME, PRIMARY KEY (id), KEY idx_status (status), KEY idx_attachment (attachment_id) ) $charset_collate;"; // Stats table. $sql_stats = "CREATE TABLE wp_cfr2_stats ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, date DATE NOT NULL, transformations INT UNSIGNED DEFAULT 0, bandwidth_bytes BIGINT UNSIGNED DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY idx_date (date) ) $charset_collate;"; dbDelta( $sql_status );Safe to delete?
If you have uninstalled TP Media Offload & Edge CDN, 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_cfr2_offload_status`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from TP Media Offload & Edge CDN