{"table_name":"login_armor_attempts","full_table_name":"wp_login_armor_attempts","description":"Stores login armor attempts data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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), KEY ip_status_time (ip, status, 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 );","columns":[{"name":"id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"ip","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"username","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"attempt_time","type":"datetime","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"ip","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"username","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"log_time","type":"datetime","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"user_agent","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"pattern","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"severity","type":"tinyint(3) UNSIGNED","nullable":false,"primary_key":false},{"name":"started_at","type":"datetime","nullable":false,"primary_key":false},{"name":"last_seen_at","type":"datetime","nullable":false,"primary_key":false},{"name":"ip","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"subnet","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"target_username","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"events_count","type":"int UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"vector","type":"varchar(20)","nullable":false,"primary_key":false}],"plugin":{"slug":"login-armor","name":"Login Armor","active_installs":100,"version":"2.4.3","wp_org_url":"https://wordpress.org/plugins/login-armor/"}}