wp_esherpa_failed_logins

Static

A logging table that records activity, events, or audit history.

Column Definitions

Column	Type	Nullable
🔑id	BIGINT(20) UNSIGNED	NO
ip_hash	VARCHAR(64)	NO
attempted_username	VARCHAR(255)	NO
user_agent	TEXT	YES
bot_detected	VARCHAR(50)	YES
attempted_password	VARCHAR(500)	YES
timestamp	DATETIME	YES
ip_hash	VARCHAR(64)	NO
username	VARCHAR(255)	NO
user_agent	TEXT	YES
timestamp	DATETIME	YES
ip_hash	VARCHAR(64)	NO
user_agent	TEXT	YES
matched_pattern	VARCHAR(500)	YES
timestamp	DATETIME	YES

CREATE TABLE Statement

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);

Safe to delete?

If you have uninstalled eSherpa Login Guard, 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_esherpa_failed_logins`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from eSherpa Login Guard

wp_esherpa_blocked_ua_attempts wp_esherpa_successful_logins