{"table_name":"bbc_botbanishclient_website_visits","full_table_name":"wp_bbc_botbanishclient_website_visits","description":"Stores bbc botbanishclient website visits data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `bbc_botbanishclient_website_visits` ( `id_no` int unsigned NOT NULL , `page_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `ip_addr` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `hostname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `http_user_agent` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `http_referer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `date` date NOT NULL, `rpt_date` datetime NOT NULL, `user_id` int unsigned NOT NULL DEFAULT \\'0\\', `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, `system` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE","columns":[{"name":"id_no","type":"int unsigned","nullable":false,"primary_key":false},{"name":"page_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ip_addr","type":"varchar(39)","nullable":false,"primary_key":false},{"name":"hostname","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"http_user_agent","type":"varchar(1024)","nullable":true,"primary_key":false},{"name":"http_referer","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"rpt_date","type":"datetime","nullable":false,"primary_key":false},{"name":"user_id","type":"int unsigned","nullable":false,"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":"system","type":"varchar(20)","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/"}}