wp_lunexia_security_events
StaticStores lunexia security events data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| event_type | varchar(100) | NO |
| severity | varchar(20) | NO |
| ip_address | varchar(45) | YES |
| username | varchar(191) | YES |
| event_data | longtext | YES |
| file_path | text | YES |
| threat_score | int(10) unsigned | YES |
| action_taken | varchar(191) | YES |
| resolved | tinyint(1) | NO |
| created_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_lunexia_security_events ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, event_type varchar(100) NOT NULL, severity varchar(20) NOT NULL, ip_address varchar(45), username varchar(191), event_data longtext, file_path text, threat_score int(10) unsigned DEFAULT 0, action_taken varchar(191), resolved tinyint(1) NOT NULL DEFAULT 0, created_at datetime NOT NULL, PRIMARY KEY (id), KEY event_type (event_type), KEY severity (severity), KEY ip_address (ip_address), KEY created_at (created_at), KEY resolved (resolved) ) {$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_security_events`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Lunexia .htaccess Shield