{"slug":"botbanish-firewall-client","name":"BotBanish by Randem Systems","description":"Bot and SPAM Blocking","author":"Randem Systems","active_installs":10,"version":"9.0.00","wp_org_url":"https://wordpress.org/plugins/botbanish-firewall-client/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"bbc_botbanishclient_debug_log","full_table_name":"wp_bbc_botbanishclient_debug_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"seq","type":"int","nullable":false,"primary_key":false},{"name":"bot_ip","type":"varchar(39)","nullable":false,"primary_key":false},{"name":"request","type":"longtext","nullable":true,"primary_key":false},{"name":"response","type":"longtext","nullable":true,"primary_key":false},{"name":"backtrace","type":"longtext","nullable":true,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_debug_log` ( `seq` int NOT NULL , `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `request` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `backtrace` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"bbc_botbanishclient_debug_trace","full_table_name":"wp_bbc_botbanishclient_debug_trace","description":"Stores bbc botbanishclient debug trace data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"bot_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":"last_hit","type":"int unsigned","nullable":false,"primary_key":false},{"name":"domain_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"client_info","type":"text","nullable":false,"primary_key":false},{"name":"server_info","type":"text","nullable":false,"primary_key":false},{"name":"botbanish_info","type":"text","nullable":false,"primary_key":false},{"name":"datarow","type":"text","nullable":false,"primary_key":false},{"name":"response","type":"text","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_debug_trace` ( `bot_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\\', `last_hit` int unsigned NOT NULL DEFAULT \\'0\\', `domain_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `client_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `server_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `botbanish_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `datarow` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `response` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"bbc_botbanishclient_doc_errors","full_table_name":"wp_bbc_botbanishclient_doc_errors","description":"Stores bbc botbanishclient doc errors data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"bot_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":"last_hit","type":"int unsigned","nullable":false,"primary_key":false},{"name":"domain_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"error_doc","type":"int unsigned","nullable":false,"primary_key":false},{"name":"error_cause","type":"varchar(1024)","nullable":false,"primary_key":false},{"name":"client_info","type":"text","nullable":false,"primary_key":false},{"name":"server_info","type":"text","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_doc_errors` ( `bot_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\\', `last_hit` int unsigned NOT NULL DEFAULT \\'0\\', `domain_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `error_doc` int unsigned NOT NULL, `error_cause` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `client_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `server_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"bbc_botbanishclient_domain_bad","full_table_name":"wp_bbc_botbanishclient_domain_bad","description":"Stores bbc botbanishclient domain bad data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_domain","type":"int unsigned","nullable":false,"primary_key":false},{"name":"domain","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"active","type":"int unsigned","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_domain_bad` ( `id_domain` int unsigned NOT NULL , `domain` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `active` int unsigned NOT NULL DEFAULT \\'1\\', `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"bbc_botbanishclient_domain_good","full_table_name":"wp_bbc_botbanishclient_domain_good","description":"Stores bbc botbanishclient domain good data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_domain","type":"int unsigned","nullable":false,"primary_key":false},{"name":"domain","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"active","type":"int unsigned","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_domain_good` ( `id_domain` int unsigned NOT NULL , `domain` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `active` int unsigned NOT NULL DEFAULT \\'1\\', `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"bbc_botbanishclient_email","full_table_name":"wp_bbc_botbanishclient_email","description":"Stores bbc botbanishclient email data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"email_id","type":"int UNSIGNED","nullable":false,"primary_key":true},{"name":"email","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"username","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"hit_count","type":"int","nullable":false,"primary_key":false},{"name":"first_hit","type":"int","nullable":false,"primary_key":false},{"name":"last_hit","type":"int","nullable":false,"primary_key":false},{"name":"forcelockout","type":"int UNSIGNED","nullable":false,"primary_key":false},{"name":"domain_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"user_agent","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `bbc_botbanishclient_email` ( `email_id` int UNSIGNED NOT NULL AUTO_INCREMENT, `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `username` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `hit_count` int NOT NULL DEFAULT \\'0\\', `first_hit` int NOT NULL DEFAULT \\'0\\', `last_hit` int NOT NULL DEFAULT \\'0\\', `forcelockout` int UNSIGNED NOT NULL DEFAULT \\'1\\', `domain_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT \\'\\', `user_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`email_id`), UNIQUE KEY `email` (`email`,`username`), KEY `first_hit` (`first_hit`), KEY `last_hit` (`last_hit`) ) ENGINE"},{"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","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}],"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"},{"table_name":"bbc_botbanishclient_htaccess","full_table_name":"wp_bbc_botbanishclient_htaccess","description":"Stores bbc botbanishclient htaccess data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int unsigned","nullable":false,"primary_key":false},{"name":"type","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"text","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_htaccess` ( `id` int unsigned NOT NULL , `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE"},{"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","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}],"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"},{"table_name":"bbc_botbanishclient_ip_bad_default","full_table_name":"wp_bbc_botbanishclient_ip_bad_default","description":"Stores bbc botbanishclient ip bad default data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ip_id","type":"int UNSIGNED","nullable":false,"primary_key":true},{"name":"bot_ip","type":"varchar(39)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"active","type":"int UNSIGNED","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `bbc_botbanishclient_ip_bad_default` ( `ip_id` int UNSIGNED NOT NULL AUTO_INCREMENT, `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `active` int UNSIGNED NOT NULL DEFAULT \\'1\\', `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`ip_id`), UNIQUE KEY `ip` (`bot_ip`) ) ENGINE"},{"table_name":"bbc_botbanishclient_ip_good","full_table_name":"wp_bbc_botbanishclient_ip_good","description":"Stores bbc botbanishclient ip good data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ip_id","type":"int unsigned","nullable":false,"primary_key":false},{"name":"bot_ip","type":"varchar(39)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"active","type":"int unsigned","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_ip_good` ( `ip_id` int unsigned NOT NULL , `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `active` int unsigned NOT NULL DEFAULT \\'1\\', `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"bbc_botbanishclient_redirects","full_table_name":"wp_bbc_botbanishclient_redirects","description":"Stores bbc botbanishclient redirects data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"redirect_id","type":"bigint UNSIGNED","nullable":false,"primary_key":false},{"name":"redirect_name","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"redirect_value","type":"longtext","nullable":false,"primary_key":false},{"name":"redirect_func","type":"longtext","nullable":true,"primary_key":false},{"name":"Updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_redirects` ( `redirect_id` bigint UNSIGNED NOT NULL, `redirect_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `redirect_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `redirect_func` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `Updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"bbc_botbanishclient_session","full_table_name":"wp_bbc_botbanishclient_session","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[{"name":"option_id","type":"bigint unsigned","nullable":false,"primary_key":false},{"name":"option_name","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"option_value","type":"longtext","nullable":false,"primary_key":false},{"name":"option_func","type":"longtext","nullable":true,"primary_key":false},{"name":"option_timeout","type":"longtext","nullable":false,"primary_key":false},{"name":"autoload","type":"varchar(20)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_session` ( `option_id` bigint unsigned NOT NULL , `option_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `option_func` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `option_timeout` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `autoload` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT \\'yes\\' ) ENGINE"},{"table_name":"bbc_botbanishclient_settings","full_table_name":"wp_bbc_botbanishclient_settings","description":"Stores bbc botbanishclient settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int unsigned","nullable":false,"primary_key":false},{"name":"name","type":"varchar(80)","nullable":true,"primary_key":false},{"name":"value","type":"varchar(8192)","nullable":false,"primary_key":false},{"name":"type","type":"int unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_settings` ( `id` int unsigned NOT NULL , `name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `value` varchar(8192) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `type` int unsigned NOT NULL ) ENGINE"},{"table_name":"bbc_botbanishclient_spider_bad","full_table_name":"wp_bbc_botbanishclient_spider_bad","description":"Stores bbc botbanishclient spider bad data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_spider","type":"int unsigned","nullable":false,"primary_key":false},{"name":"spider_name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"user_agent_part","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"active","type":"int unsigned","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_spider_bad` ( `id_spider` int unsigned NOT NULL , `spider_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `user_agent_part` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `active` int unsigned NOT NULL DEFAULT \\'1\\', `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"bbc_botbanishclient_spider_good","full_table_name":"wp_bbc_botbanishclient_spider_good","description":"Stores bbc botbanishclient spider good data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_spider","type":"int unsigned","nullable":false,"primary_key":false},{"name":"spider_name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"user_agent_part","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"active","type":"int unsigned","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_spider_good` ( `id_spider` int unsigned NOT NULL , `spider_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `user_agent_part` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `active` int unsigned NOT NULL DEFAULT \\'1\\', `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"bbc_botbanishclient_url_bad","full_table_name":"wp_bbc_botbanishclient_url_bad","description":"Stores bbc botbanishclient url bad data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"url_id","type":"int unsigned","nullable":false,"primary_key":false},{"name":"url_part","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"system","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"active","type":"int unsigned","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_url_bad` ( `url_id` int unsigned NOT NULL , `url_part` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `system` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `active` int unsigned NOT NULL DEFAULT \\'1\\', `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"bbc_botbanishclient_url_good","full_table_name":"wp_bbc_botbanishclient_url_good","description":"Stores bbc botbanishclient url good data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"url_id","type":"int unsigned","nullable":false,"primary_key":false},{"name":"url_part","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"system","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"active","type":"int unsigned","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_url_good` ( `url_id` int unsigned NOT NULL , `url_part` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `system` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `active` int unsigned NOT NULL DEFAULT \\'1\\', `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"bbc_botbanishclient_website_blocks","full_table_name":"wp_bbc_botbanishclient_website_blocks","description":"Stores bbc botbanishclient website blocks data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_no","type":"int unsigned","nullable":false,"primary_key":false},{"name":"bot_ip","type":"varchar(39)","nullable":false,"primary_key":false},{"name":"subject","type":"varchar(256)","nullable":false,"primary_key":false},{"name":"blocks","type":"int","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `bbc_botbanishclient_website_blocks` ( `id_no` int unsigned NOT NULL , `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `subject` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `blocks` int NOT NULL, `date` date NOT NULL, `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"bbc_botbanishclient_website_downloads","full_table_name":"wp_bbc_botbanishclient_website_downloads","description":"Stores bbc botbanishclient website downloads data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_no","type":"int unsigned","nullable":false,"primary_key":false},{"name":"filename","type":"varchar(100)","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}],"create_sql":"CREATE TABLE `bbc_botbanishclient_website_downloads` ( `id_no` int unsigned NOT NULL , `filename` varchar(100) 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"},{"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","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}],"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"},{"table_name":"botbanish_country_code","full_table_name":"wp_botbanish_country_code","description":"Stores botbanish country code data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_country","type":"int","nullable":false,"primary_key":false},{"name":"country_code","type":"varchar(4)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"active","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `botbanish_country_code` ( `id_country` int NOT NULL , `country_code` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `active` int NOT NULL DEFAULT \\'0\\' ) ENGINE"},{"table_name":"botbanish_language_text","full_table_name":"wp_botbanish_language_text","description":"Stores botbanish language text data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"lang_id","type":"int","nullable":false,"primary_key":false},{"name":"lang_key","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"lang_text","type":"varchar(1024)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `botbanish_language_text` ( `lang_id` int NOT NULL, `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE"},{"table_name":"botbanish_language_text_english","full_table_name":"wp_botbanish_language_text_english","description":"Stores botbanish language text english data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"lang_id","type":"int","nullable":false,"primary_key":false},{"name":"lang_key","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"lang_text","type":"varchar(1024)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `botbanish_language_text_english` ( `lang_id` int NOT NULL, `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE"},{"table_name":"botbanish_language_text_french","full_table_name":"wp_botbanish_language_text_french","description":"Stores botbanish language text french data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"lang_id","type":"int","nullable":false,"primary_key":false},{"name":"lang_key","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"lang_text","type":"varchar(1024)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `botbanish_language_text_french` ( `lang_id` int NOT NULL, `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE"},{"table_name":"botbanish_language_text_german","full_table_name":"wp_botbanish_language_text_german","description":"Stores botbanish language text german data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"lang_id","type":"int","nullable":false,"primary_key":false},{"name":"lang_key","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"lang_text","type":"varchar(1024)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `botbanish_language_text_german` ( `lang_id` int NOT NULL, `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE"},{"table_name":"botbanish_language_text_italian","full_table_name":"wp_botbanish_language_text_italian","description":"Stores botbanish language text italian data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"lang_id","type":"int","nullable":false,"primary_key":false},{"name":"lang_key","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"lang_text","type":"varchar(1024)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `botbanish_language_text_italian` ( `lang_id` int NOT NULL, `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE"},{"table_name":"botbanish_language_text_portuguese","full_table_name":"wp_botbanish_language_text_portuguese","description":"Stores botbanish language text portuguese data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"lang_id","type":"int","nullable":false,"primary_key":false},{"name":"lang_key","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"lang_text","type":"varchar(1024)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `botbanish_language_text_portuguese` ( `lang_id` int NOT NULL, `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE"},{"table_name":"botbanish_language_text_spanish","full_table_name":"wp_botbanish_language_text_spanish","description":"Stores botbanish language text spanish data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"lang_id","type":"int","nullable":false,"primary_key":false},{"name":"lang_key","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"lang_text","type":"varchar(1024)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `botbanish_language_text_spanish` ( `lang_id` int NOT NULL, `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE"},{"table_name":"botbanish_language_text_swedish","full_table_name":"wp_botbanish_language_text_swedish","description":"Stores botbanish language text swedish data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"lang_id","type":"int","nullable":false,"primary_key":false},{"name":"lang_key","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"lang_text","type":"varchar(1024)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `botbanish_language_text_swedish` ( `lang_id` int NOT NULL, `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE"},{"table_name":"botbanish_languages","full_table_name":"wp_botbanish_languages","description":"Stores botbanish languages data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"lang_id","type":"int","nullable":false,"primary_key":false},{"name":"language","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"lang_code","type":"varchar(10)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `botbanish_languages` ( `lang_id` int NOT NULL , `language` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lang_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE"},{"table_name":"botbanish_timezones","full_table_name":"wp_botbanish_timezones","description":"Stores botbanish timezones data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"tz_id","type":"int","nullable":false,"primary_key":false},{"name":"gmt","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"area","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"timezone","type":"varchar(100)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `botbanish_timezones` ( `tz_id` int NOT NULL , `gmt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `area` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `timezone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE"},{"table_name":"engine4_urdemo_causebug","full_table_name":"wp_engine4_urdemo_causebug","description":"Stores engine4 urdemo causebug data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"extra","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `engine4_urdemo_causebug` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `extra` int(11) NOT NULL DEFAULT 56, PRIMARY KEY (`id`), INDEX client_idx (id) ) ENGINE"},{"table_name":"hohoho","full_table_name":"wp_hohoho","description":"Stores hohoho data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE hohoho () AUTO_INCREMENT = 1 DEFAULT CHARACTER SET _utf8 PASSWORD 'test123'\"; $parser->parse($sql);"}],"table_count":34}