{"table_name":"bbc_botbanishclient_geo","full_table_name":"wp_bbc_botbanishclient_geo","description":"Stores bbc botbanishclient geo data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `bbc_botbanishclient_geo` ( `geo_id` bigint NOT NULL, `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `country_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `geo_info` varchar(3192) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `uploaded` int NOT NULL DEFAULT \\'0\\' ) ENGINE","columns":[{"name":"geo_id","type":"bigint","nullable":false,"primary_key":false},{"name":"bot_ip","type":"varchar(39)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"country_code","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"geo_info","type":"varchar(3192)","nullable":true,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false},{"name":"uploaded","type":"int","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/"}}