wp_cg_blocked_devices
StaticStores cg blocked devices data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) | NO |
| device_fingerprint | VARCHAR(64) | NO |
| device_info | TEXT | YES |
| added_by | BIGINT(20) UNSIGNED | YES |
| reason | TEXT | YES |
| expires_at | DATETIME | YES |
| auto_blocked | TINYINT(1) | YES |
| created_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE wp_cg_blocked_devices ( id BIGINT(20) NOT NULL AUTO_INCREMENT, device_fingerprint VARCHAR(64) NOT NULL, device_info TEXT DEFAULT NULL, added_by BIGINT(20) UNSIGNED DEFAULT NULL, reason TEXT DEFAULT NULL, expires_at DATETIME DEFAULT NULL, auto_blocked TINYINT(1) DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY device_fingerprint (device_fingerprint) ) $charset_collate;"; dbDelta($sql);
Safe to delete?
If you have uninstalled CheckoutGuard, 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_cg_blocked_devices`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from CheckoutGuard