wp_gdef_lite_audit
StaticStores gdef lite audit data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | YES |
| created_at | INT UNSIGNED | NO |
| actor_id | BIGINT UNSIGNED | NO |
| actor_login | VARCHAR(190) | NO |
| ip | VARCHAR(45) | NO |
| category | VARCHAR(40) | NO |
| action | VARCHAR(80) | NO |
| severity | TINYINT UNSIGNED | NO |
| target | VARCHAR(255) | NO |
| detail | TEXT | YES |
| prev_hash | CHAR(64) | NO |
| row_hash | CHAR(64) | NO |
| created_at | INT UNSIGNED | NO |
| engine | VARCHAR(20) | NO |
| severity | VARCHAR(10) | NO |
| subject | VARCHAR(190) | NO |
| title | VARCHAR(255) | NO |
| body | TEXT | YES |
| status | VARCHAR(20) | NO |
| resolved_at | INT UNSIGNED | YES |
| path | VARCHAR(500) | NO |
| sha256 | CHAR(64) | NO |
| size | BIGINT UNSIGNED | NO |
| mtime | INT UNSIGNED | NO |
| recorded_at | INT UNSIGNED | NO |
CREATE TABLE Statement
CREATE TABLE wp_gdef_lite_audit ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, created_at INT UNSIGNED NOT NULL, actor_id BIGINT UNSIGNED NOT NULL DEFAULT 0, actor_login VARCHAR(190) NOT NULL DEFAULT '', ip VARCHAR(45) NOT NULL DEFAULT '', category VARCHAR(40) NOT NULL, action VARCHAR(80) NOT NULL, severity TINYINT UNSIGNED NOT NULL DEFAULT 1, target VARCHAR(255) NOT NULL DEFAULT '', detail TEXT NULL, prev_hash CHAR(64) NOT NULL DEFAULT '', row_hash CHAR(64) NOT NULL DEFAULT '', KEY created_at (created_at), KEY category (category) ) {$charset};"; $findings = "CREATE TABLE wp_gdef_lite_findings ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, created_at INT UNSIGNED NOT NULL, engine VARCHAR(20) NOT NULL, severity VARCHAR(10) NOT NULL DEFAULT 'low', subject VARCHAR(190) NOT NULL, title VARCHAR(255) NOT NULL, body TEXT NULL, status VARCHAR(20) NOT NULL DEFAULT 'open', resolved_at INT UNSIGNED NULL, KEY engine_status (engine, status), KEY created_at (created_at) ) {$charset};"; $baseline = "CREATE TABLE wp_gdef_lite_baseline ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, path VARCHAR(500) NOT NULL, sha256 CHAR(64) NOT NULL, size BIGINT UNSIGNED NOT NULL DEFAULT 0, mtime INT UNSIGNED NOT NULL DEFAULT 0, recorded_at INT UNSIGNED NOT NULL, UNIQUE KEY path (path(255)) ) {$charset};"; dbDelta( $audit );Safe to delete?
If you have uninstalled Ghostables Defender Lite, 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_gdef_lite_audit`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Ghostables Defender Lite