{"table_name":"bearmor_blocked_ips","full_table_name":"wp_bearmor_blocked_ips","description":"Stores bearmor blocked ips data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_bearmor_blocked_ips ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, ip_address VARCHAR(45) NOT NULL, blocked_at DATETIME NOT NULL, expires_at DATETIME, reason VARCHAR(255), permanent TINYINT(1) DEFAULT 0, blocked_by BIGINT UNSIGNED, status VARCHAR(20) DEFAULT 'active', KEY expires_at (expires_at), KEY permanent (permanent), KEY status (status), KEY ip_status (ip_address, status) ) $charset_collate;\"; dbDelta( $sql );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":true},{"name":"ip_address","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"blocked_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"reason","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"permanent","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"blocked_by","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(20)","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/"}}