{"slug":"sg-security","name":"Security Optimizer – The All-In-One Protection Plugin","description":"Secure your WordPress site from brute-force attacks, threats, malware, and bots. Free to use and easy to set up.","author":"SiteGround","active_installs":1000000,"version":"1.6.0","wp_org_url":"https://wordpress.org/plugins/sg-security/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"sgs_log_events","full_table_name":"wp_sgs_log_events","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"visitor_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"ts","type":"int(11)","nullable":false,"primary_key":false},{"name":"activity","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ip","type":"varchar(55)","nullable":false,"primary_key":false},{"name":"hostname","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"code","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"object_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"action","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"visitor_type","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"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"},{"table_name":"sgs_log_visitors","full_table_name":"wp_sgs_log_visitors","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"ip","type":"varchar(55)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"block","type":"int(11)","nullable":false,"primary_key":false},{"name":"blocked_on","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_sgs_log_visitors` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` varchar(55) NOT NULL DEFAULT '127.0.0.1', `user_id` int(11) NOT NULL DEFAULT 0, `block` int(11) NOT NULL DEFAULT 0, `blocked_on` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), INDEX `ip_index` (`ip`), INDEX `block_user_index` (`block`, `user_id`) ) ENGINE"}],"table_count":2}