{"table_name":"gogasys_ms_logs","full_table_name":"wp_gogasys_ms_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","create_sql":"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 );","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"ip","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"country","type":"VARCHAR(5)","nullable":false,"primary_key":false},{"name":"request_uri","type":"TEXT","nullable":false,"primary_key":false},{"name":"request_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"pattern","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"block_reason","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"user_agent","type":"TEXT","nullable":false,"primary_key":false},{"name":"logged_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"ip","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('blocked','allowed')","nullable":false,"primary_key":false},{"name":"country","type":"VARCHAR(5)","nullable":false,"primary_key":false},{"name":"reason","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"file_path","type":"TEXT","nullable":false,"primary_key":false},{"name":"threat_type","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('pending','quarantined','deleted','ignored')","nullable":false,"primary_key":false},{"name":"detected_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"file_path","type":"TEXT","nullable":false,"primary_key":false},{"name":"hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"scanned_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"gogasys-malware-scanner","name":"Gogasys Malware Scanner","active_installs":0,"version":"1.0.7","wp_org_url":"https://wordpress.org/plugins/gogasys-malware-scanner/"}}