wp_bbc_botbanishclient_email
StaticStores bbc botbanishclient email data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑email_id | int UNSIGNED | NO |
| varchar(128) | NO | |
| username | varchar(128) | NO |
| hit_count | int | NO |
| first_hit | int | NO |
| last_hit | int | NO |
| forcelockout | int UNSIGNED | NO |
| domain_name | varchar(100) | NO |
| user_agent | varchar(255) | YES |
| updated | datetime | NO |
CREATE TABLE Statement
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
Safe to delete?
If you have uninstalled BotBanish by Randem Systems, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_bbc_botbanishclient_email`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from BotBanish by Randem Systems