wp_sgs_log_events
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| visitor_id | int(11) | NO |
| ts | int(11) | NO |
| activity | varchar(255) | NO |
| description | varchar(255) | NO |
| ip | varchar(55) | NO |
| hostname | varchar(255) | YES |
| code | varchar(255) | NO |
| object_id | varchar(255) | NO |
| type | varchar(255) | NO |
| action | varchar(255) | NO |
| visitor_type | varchar(255) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_sgs_log_events` ( `id` int(11) NOT NULL AUTO_INCREMENT, `visitor_id` int(11) NOT NULL, `ts` int(11) NOT NULL DEFAULT '0', `activity` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `ip` varchar(55) NOT NULL DEFAULT '127.0.0.1', `hostname` varchar(255) DEFAULT '0', `code` varchar(255) NOT NULL DEFAULT '', `object_id` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `visitor_type` varchar(255) NOT NULL, PRIMARY KEY (`id`), INDEX `log_event_index` (`visitor_id`, `ts`, `activity`, `id`) ) ENGINE
Safe to delete?
If you have uninstalled Security Optimizer – The All-In-One Protection Plugin, 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_sgs_log_events`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Security Optimizer – The All-In-One Protection Plugin