wp_lunexia_ip_reputation
StaticStores lunexia ip reputation data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| ip_address | varchar(45) | NO |
| threat_score | bigint(20) | NO |
| last_activity | datetime | NO |
| activity_count | int(10) unsigned | NO |
| failed_logins | int(10) unsigned | NO |
| sql_injection_attempts | int(10) unsigned | NO |
| xss_attempts | int(10) unsigned | NO |
| malware_uploads | int(10) unsigned | NO |
| rate_limit_violations | int(10) unsigned | NO |
| scanner_activities | int(10) unsigned | NO |
| webshells_detected | int(10) unsigned | NO |
| notes | longtext | YES |
| created_at | datetime | NO |
| expires_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_lunexia_ip_reputation ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, ip_address varchar(45) NOT NULL, threat_score bigint(20) NOT NULL DEFAULT 0, last_activity datetime NOT NULL, activity_count int(10) unsigned NOT NULL DEFAULT 1, failed_logins int(10) unsigned NOT NULL DEFAULT 0, sql_injection_attempts int(10) unsigned NOT NULL DEFAULT 0, xss_attempts int(10) unsigned NOT NULL DEFAULT 0, malware_uploads int(10) unsigned NOT NULL DEFAULT 0, rate_limit_violations int(10) unsigned NOT NULL DEFAULT 0, scanner_activities int(10) unsigned NOT NULL DEFAULT 0, webshells_detected int(10) unsigned NOT NULL DEFAULT 0, notes longtext, created_at datetime NOT NULL, expires_at datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY ip_address (ip_address), KEY threat_score (threat_score), KEY last_activity (last_activity), KEY expires_at (expires_at) ) {$charset_collate};"; dbDelta( $sql );Safe to delete?
If you have uninstalled Lunexia .htaccess Shield, 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_lunexia_ip_reputation`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Lunexia .htaccess Shield