{"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","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","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}],"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/"}}