wp_bearmor_login_anomalies
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | YES |
| user_id | BIGINT UNSIGNED | NO |
| ip_address | VARCHAR(45) | NO |
| country_code | VARCHAR(2) | YES |
| user_agent | TEXT | YES |
| anomaly_type | VARCHAR(50) | NO |
| anomaly_score | INT | NO |
| details | TEXT | YES |
| detected_at | DATETIME | NO |
| status | ENUM('new', 'marked_safe', 'blocked') | YES |
| action_by | BIGINT UNSIGNED | YES |
CREATE TABLE Statement
CREATE TABLE wp_bearmor_login_anomalies ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, user_id BIGINT UNSIGNED NOT NULL, ip_address VARCHAR(45) NOT NULL, country_code VARCHAR(2), user_agent TEXT, anomaly_type VARCHAR(50) NOT NULL, anomaly_score INT NOT NULL, details TEXT, detected_at DATETIME NOT NULL, status ENUM('new', 'marked_safe', 'blocked') DEFAULT 'new', action_by BIGINT UNSIGNED, KEY user_id (user_id), KEY detected_at (detected_at), KEY anomaly_score (anomaly_score), KEY status (status) ) $charset_collate;"; dbDelta( $sql );Safe to delete?
If you have uninstalled Bearmor Security, 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_bearmor_login_anomalies`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Bearmor Security