wp_login_armor_attempts
StaticStores login armor attempts data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) UNSIGNED | NO |
| ip | varchar(100) | NO |
| username | varchar(200) | YES |
| attempt_time | datetime | NO |
| status | varchar(20) | NO |
| ip | varchar(100) | NO |
| username | varchar(200) | YES |
| log_time | datetime | NO |
| status | varchar(20) | NO |
| user_agent | varchar(500) | YES |
| pattern | varchar(32) | NO |
| severity | tinyint(3) UNSIGNED | NO |
| started_at | datetime | NO |
| last_seen_at | datetime | NO |
| ip | varchar(100) | YES |
| subnet | varchar(100) | YES |
| target_username | varchar(200) | YES |
| events_count | int UNSIGNED | NO |
| status | varchar(20) | NO |
| vector | varchar(20) | NO |
CREATE TABLE Statement
CREATE TABLE wp_login_armor_attempts ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, ip varchar(100) NOT NULL, username varchar(200) DEFAULT '', attempt_time datetime NOT NULL, status varchar(20) NOT NULL DEFAULT 'failed', PRIMARY KEY (id), KEY ip (ip), KEY attempt_time (attempt_time) ) $charset_collate;"; $sql_logs = "CREATE TABLE wp_login_armor_logs ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, ip varchar(100) NOT NULL, username varchar(200) DEFAULT '', log_time datetime NOT NULL, status varchar(20) NOT NULL, user_agent varchar(500) DEFAULT '', PRIMARY KEY (id), KEY ip (ip), KEY log_time (log_time), KEY status (status) ) $charset_collate;"; $sql_incidents = "CREATE TABLE wp_login_armor_incidents ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, pattern varchar(32) NOT NULL, severity tinyint(3) UNSIGNED NOT NULL DEFAULT 1, started_at datetime NOT NULL, last_seen_at datetime NOT NULL, ip varchar(100) DEFAULT '', subnet varchar(100) DEFAULT '', target_username varchar(200) DEFAULT '', events_count int UNSIGNED NOT NULL DEFAULT 0, unique_ips int UNSIGNED NOT NULL DEFAULT 0, unique_usernames int UNSIGNED NOT NULL DEFAULT 0, status varchar(20) NOT NULL DEFAULT 'active', vector varchar(20) NOT NULL DEFAULT 'login_form', PRIMARY KEY (id), KEY pattern (pattern), KEY last_seen_at (last_seen_at), KEY status (status) ) $charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql_attempts );
Safe to delete?
If you have uninstalled Login Armor, 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_login_armor_attempts`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Login Armor