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