wp_cg_checkout_attempts
StaticStores cg checkout attempts data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) | NO |
| ip_address | VARCHAR(45) | YES |
| VARCHAR(100) | YES | |
| phone | VARCHAR(30) | YES |
| device_fingerprint | VARCHAR(64) | YES |
| address_hash | VARCHAR(64) | YES |
| attempt_result | VARCHAR(30) | NO |
| block_reason | TEXT | YES |
| created_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE wp_cg_checkout_attempts ( id BIGINT(20) NOT NULL AUTO_INCREMENT, ip_address VARCHAR(45) DEFAULT '', email VARCHAR(100) DEFAULT '', phone VARCHAR(30) DEFAULT '', device_fingerprint VARCHAR(64) DEFAULT '', address_hash VARCHAR(64) DEFAULT '', attempt_result VARCHAR(30) NOT NULL DEFAULT 'allowed', block_reason TEXT DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_ip_time (ip_address, created_at), KEY idx_phone_time (phone, created_at), KEY idx_email_time (email, created_at), KEY idx_device_time (device_fingerprint, created_at) ) $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_checkout_attempts`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from CheckoutGuard