wp_aegilock_wc_fraud_logs
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | NO |
| order_id | bigint(20) | NO |
| fraud_score | decimal(5,4) | NO |
| risk_factors | longtext | YES |
| recommendation | varchar(20) | YES |
| action_taken | varchar(50) | NO |
| review_status | varchar(20) | YES |
| reviewed_at | datetime | YES |
| reviewed_by | bigint(20) | YES |
| api_response | longtext | YES |
| created_at | datetime | YES |
| date_recorded | date | NO |
| orders_checked | int(11) | YES |
| orders_blocked | int(11) | YES |
| orders_held | int(11) | YES |
| avg_fraud_score | decimal(5,4) | YES |
| api_calls_used | int(11) | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_aegilock_wc_fraud_logs ( id bigint(20) NOT NULL AUTO_INCREMENT, order_id bigint(20) NOT NULL, fraud_score decimal(5,4) NOT NULL DEFAULT 0.0000, risk_factors longtext, recommendation varchar(20) DEFAULT 'allow', action_taken varchar(50) NOT NULL, review_status varchar(20) NULL, reviewed_at datetime NULL, reviewed_by bigint(20) NULL, api_response longtext, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY order_id (order_id), KEY fraud_score (fraud_score), KEY created_at (created_at) ) $charset_collate;"; // Statistics table $sql .= "CREATE TABLE IF NOT EXISTS wp_aegilock_wc_stats ( id bigint(20) NOT NULL AUTO_INCREMENT, date_recorded date NOT NULL, orders_checked int(11) DEFAULT 0, orders_blocked int(11) DEFAULT 0, orders_held int(11) DEFAULT 0, avg_fraud_score decimal(5,4) DEFAULT 0.0000, api_calls_used int(11) DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY date_recorded (date_recorded) ) $charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; try { $result = dbDelta( $sql );Safe to delete?
If you have uninstalled Aegilock Transaction Guardian for WooCommerce, 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_aegilock_wc_fraud_logs`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Aegilock Transaction Guardian for WooCommerce