{"table_name":"esherpa_failed_logins","full_table_name":"wp_esherpa_failed_logins","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_esherpa_failed_logins ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, ip_hash VARCHAR(64) NOT NULL, attempted_username VARCHAR(255) NOT NULL, user_agent TEXT, bot_detected VARCHAR(50), attempted_password VARCHAR(500), timestamp DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY ip_hash (ip_hash), KEY timestamp (timestamp) ) $charset_collate;\" ], 'successful_logins' => [ 'table_name' => wp_'esherpa_successful_logins', 'schema' => \"CREATE TABLE wp_esherpa_successful_logins ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, ip_hash VARCHAR(64) NOT NULL, username VARCHAR(255) NOT NULL, user_agent TEXT, timestamp DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY ip_hash (ip_hash), KEY timestamp (timestamp) ) $charset_collate;\" ], 'blocked_ua_attempts' => [ 'table_name' => wp_'esherpa_blocked_ua_attempts', 'schema' => \"CREATE TABLE wp_esherpa_blocked_ua_attempts ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, ip_hash VARCHAR(64) NOT NULL, user_agent TEXT, matched_pattern VARCHAR(500), timestamp DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY ip_hash (ip_hash), KEY timestamp (timestamp) ) $charset_collate;\" ] ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; // Verwende dbDelta für alle Tabellen (aktualisiert Schema falls nötig) foreach ($tables as $table_info) { $table_name = $table_info['table_name']; $sql = $table_info['schema']; // Prüfe ob Tabelle existiert if ($wpdb->get_var(\"SHOW TABLES LIKE '$table_name'\") !== $table_name) { // Neue Tabelle erstellen dbDelta($sql);","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"ip_hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"attempted_username","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"user_agent","type":"TEXT","nullable":true,"primary_key":false},{"name":"bot_detected","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"attempted_password","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"timestamp","type":"DATETIME","nullable":true,"primary_key":false},{"name":"ip_hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"username","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"user_agent","type":"TEXT","nullable":true,"primary_key":false},{"name":"timestamp","type":"DATETIME","nullable":true,"primary_key":false},{"name":"ip_hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"user_agent","type":"TEXT","nullable":true,"primary_key":false},{"name":"matched_pattern","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"timestamp","type":"DATETIME","nullable":true,"primary_key":false}],"plugin":{"slug":"esherpa-login-guard","name":"eSherpa Login Guard","active_installs":0,"version":"3.0.0","wp_org_url":"https://wordpress.org/plugins/esherpa-login-guard/"}}