wp_bbc_botbanishclient_website_visits
StaticStores bbc botbanishclient website visits data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| id_no | int unsigned | NO |
| page_name | varchar(255) | NO |
| ip_addr | varchar(39) | NO |
| hostname | varchar(100) | NO |
| http_user_agent | varchar(1024) | YES |
| http_referer | varchar(255) | YES |
| date | date | NO |
| rpt_date | datetime | NO |
| user_id | int unsigned | NO |
| country | varchar(50) | YES |
| country_code | varchar(10) | YES |
| geo_info | varchar(3192) | YES |
| system | varchar(20) | YES |
| updated | datetime | NO |
CREATE TABLE Statement
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
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_website_visits`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from BotBanish by Randem Systems