wp_bbc_botbanishclient_ip_bad
StaticStores bbc botbanishclient ip bad data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| ip_id | int unsigned | NO |
| bot_ip | varchar(39) | NO |
| hit_count | int unsigned | NO |
| first_hit | int unsigned | NO |
| last_hit | int unsigned | NO |
| forcelockout | int unsigned | NO |
| domain_name | varchar(100) | YES |
| user_agent | varchar(1024) | YES |
| domain | varchar(100) | YES |
| country | varchar(50) | YES |
| country_code | varchar(10) | YES |
| geo_info | varchar(3192) | YES |
| updated | datetime | NO |
CREATE TABLE Statement
CREATE TABLE `bbc_botbanishclient_ip_bad` ( `ip_id` int unsigned NOT NULL , `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `hit_count` int unsigned NOT NULL DEFAULT \'0\', `first_hit` int unsigned NOT NULL DEFAULT \'0\', `last_hit` int unsigned NOT NULL DEFAULT \'0\', `forcelockout` int unsigned NOT NULL DEFAULT \'0\', `domain_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `user_agent` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `domain` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `country_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `geo_info` varchar(3192) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE
Safe to delete?
If you have uninstalled BotBanish by Randem Systems, 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_bbc_botbanishclient_ip_bad`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from BotBanish by Randem Systems