{"table_name":"bbc_botbanishclient_ip_bad","full_table_name":"wp_bbc_botbanishclient_ip_bad","description":"Stores bbc botbanishclient ip bad data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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","columns":[{"name":"ip_id","type":"int unsigned","nullable":false,"primary_key":false},{"name":"bot_ip","type":"varchar(39)","nullable":false,"primary_key":false},{"name":"hit_count","type":"int unsigned","nullable":false,"primary_key":false},{"name":"first_hit","type":"int unsigned","nullable":false,"primary_key":false},{"name":"last_hit","type":"int unsigned","nullable":false,"primary_key":false},{"name":"forcelockout","type":"int unsigned","nullable":false,"primary_key":false},{"name":"domain_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"user_agent","type":"varchar(1024)","nullable":true,"primary_key":false},{"name":"domain","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"country","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"country_code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"geo_info","type":"varchar(3192)","nullable":true,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"botbanish-firewall-client","name":"BotBanish by Randem Systems","active_installs":10,"version":"9.0.00","wp_org_url":"https://wordpress.org/plugins/botbanish-firewall-client/"}}