wp_analytics_visitors
StaticStores analytics visitors data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| uuid | char(36) | NO |
| ip | varchar(255) | NO |
| user_agent | varchar(255) | NO |
| device | varchar(255) | NO |
| browser_name | varchar(255) | NO |
| browser_version | varchar(255) | NO |
| domain | varchar(255) | NO |
| lang | varchar(255) | NO |
| country_code | varchar(255) | YES |
| country_name | varchar(255) | YES |
| city | varchar(225) | YES |
| isp | varchar(255) | YES |
| geo_created_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE `wp_analytics_visitors` ( `uuid` char(36) NOT NULL, `ip` varchar(255) NOT NULL, `user_agent` varchar(255) NOT NULL, `device` varchar(255) NOT NULL, `browser_name` varchar(255) NOT NULL, `browser_version` varchar(255) NOT NULL, `domain` varchar(255) NOT NULL, `lang` varchar(255) NOT NULL, `country_code` varchar(255) DEFAULT NULL, `country_name` varchar(255) DEFAULT NULL, `city` varchar(225) DEFAULT NULL, `isp` varchar(255) DEFAULT NULL, `geo_created_at` datetime DEFAULT NULL, PRIMARY KEY (`uuid`), INDEX `idx_domain` (`domain`) ) ENGINE
Safe to delete?
If you have uninstalled AesirX Analytics, 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_analytics_visitors`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AesirX Analytics