{"slug":"bad-ip-wp","name":"bad_ip WP","description":"Lightweight WordPress firewall plugin to block malicious IPs, TOR nodes, and brute-force attacks with real-time sync and control.","author":"Iridium Intelligence","active_installs":20,"version":"2.0.7","wp_org_url":"https://wordpress.org/plugins/bad-ip-wp/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"bad_ip_blacklist","full_table_name":"wp_bad_ip_blacklist","description":"Stores bad ip blacklist data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bad_ip_blacklist` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `ip` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `ip` (`ip`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"bad_ip_denied","full_table_name":"wp_bad_ip_denied","description":"Stores bad ip denied data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bad_ip_denied` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `ip` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `seen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `type` tinytext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `ip` (`ip`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"bad_ip_query_whitelist","full_table_name":"wp_bad_ip_query_whitelist","description":"Stores bad ip query whitelist data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bad_ip_query_whitelist` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `query` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"bad_ip_reports","full_table_name":"wp_bad_ip_reports","description":"Stores bad ip reports data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bad_ip_reports` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `ip` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `seen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `action` tinytext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `type` tinytext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"bad_ip_settings","full_table_name":"wp_bad_ip_settings","description":"Stores bad ip settings data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bad_ip_settings` (\\n  `deny_access` int NOT NULL,\\n  `tor_block` int NOT NULL,\\n  `bad_queries` int NOT NULL,\\n  `login_incidents` int NOT NULL,\\n  `origin` int NOT NULL,\\n  `reporter` int NOT NULL,\\n  `token` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `type` int DEFAULT NULL,\\n  `login_attempts` int DEFAULT NULL,\\n  `bot_access` int NOT NULL,\\n  UNIQUE KEY `type` (`type`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"bad_ip_whitelist","full_table_name":"wp_bad_ip_whitelist","description":"Stores bad ip whitelist data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bad_ip_whitelist` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `ip` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `ip` (`ip`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":6}