{"table_name":"bearmor_login_anomalies","full_table_name":"wp_bearmor_login_anomalies","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"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 );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"country_code","type":"VARCHAR(2)","nullable":true,"primary_key":false},{"name":"user_agent","type":"TEXT","nullable":true,"primary_key":false},{"name":"anomaly_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"anomaly_score","type":"INT","nullable":false,"primary_key":false},{"name":"details","type":"TEXT","nullable":true,"primary_key":false},{"name":"detected_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('new', 'marked_safe', 'blocked')","nullable":true,"primary_key":false},{"name":"action_by","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false}],"plugin":{"slug":"bearmor-security","name":"Bearmor Security","active_installs":50,"version":"1.0.4","wp_org_url":"https://wordpress.org/plugins/bearmor-security/"}}