wp_gogasys_ms_logs
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| ip | VARCHAR(45) | NO |
| country | VARCHAR(5) | NO |
| request_uri | TEXT | NO |
| request_type | VARCHAR(20) | NO |
| pattern | VARCHAR(255) | NO |
| block_reason | VARCHAR(255) | NO |
| user_agent | TEXT | NO |
| logged_at | DATETIME | NO |
| ip | VARCHAR(45) | NO |
| status | ENUM('blocked','allowed') | NO |
| country | VARCHAR(5) | NO |
| reason | VARCHAR(255) | NO |
| created_at | DATETIME | NO |
| file_path | TEXT | NO |
| threat_type | VARCHAR(100) | NO |
| hash | VARCHAR(64) | NO |
| status | ENUM('pending','quarantined','deleted','ignored') | NO |
| detected_at | DATETIME | NO |
| file_path | TEXT | NO |
| hash | VARCHAR(64) | NO |
| scanned_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_gogasys_ms_logs` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `ip` VARCHAR(45) NOT NULL DEFAULT '', `country` VARCHAR(5) NOT NULL DEFAULT '', `request_uri` TEXT NOT NULL, `request_type` VARCHAR(20) NOT NULL DEFAULT 'GET', `pattern` VARCHAR(255) NOT NULL DEFAULT '', `block_reason` VARCHAR(255) NOT NULL DEFAULT '', `user_agent` TEXT NOT NULL, `logged_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `ip` (`ip`), KEY `logged_at` (`logged_at`), KEY `country` (`country`) ) {$charset_collate};"; // Blocked IPs table. $sql[] = "CREATE TABLE IF NOT EXISTS `wp_gogasys_ms_ips` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `ip` VARCHAR(45) NOT NULL DEFAULT '', `status` ENUM('blocked','allowed') NOT NULL DEFAULT 'blocked', `country` VARCHAR(5) NOT NULL DEFAULT '', `reason` VARCHAR(255) NOT NULL DEFAULT '', `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `ip` (`ip`), KEY `status` (`status`) ) {$charset_collate};"; // Scan results table. $sql[] = "CREATE TABLE IF NOT EXISTS `wp_gogasys_ms_scan_results` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `file_path` TEXT NOT NULL, `threat_type` VARCHAR(100) NOT NULL DEFAULT '', `hash` VARCHAR(64) NOT NULL DEFAULT '', `status` ENUM('pending','quarantined','deleted','ignored') NOT NULL DEFAULT 'pending', `detected_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `status` (`status`), KEY `detected_at` (`detected_at`) ) {$charset_collate};"; // File hashes baseline table. $sql[] = "CREATE TABLE IF NOT EXISTS `wp_gogasys_ms_file_hashes` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `file_path` TEXT NOT NULL, `hash` VARCHAR(64) NOT NULL DEFAULT '', `scanned_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) {$charset_collate};"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $sql as $query ) { // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery dbDelta( $query );Safe to delete?
If you have uninstalled Gogasys Malware Scanner, 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_gogasys_ms_logs`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Gogasys Malware Scanner