wp_jg_website_analytics_visitor
StaticStores analytics or statistics data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑_id | INT(11) | YES |
| _session | tinytext | YES |
| _postID | INT(11) | YES |
| _url | text | YES |
| _time | INT(10) | YES |
| _landing | tinyINT(1) | YES |
| _referrer | text | YES |
| _device | varchar(10) | YES |
| _resolution | varchar(11) | YES |
| _browser | varchar(10) | YES |
| _country | varchar(70) | YES |
| _region | varchar(100) | NO |
| _city | varchar(100) | NO |
| _bot_score | TINYINT | NO |
| _bot_bucket | TINYINT | NO |
| _human_verified | TINYINT | NO |
| _visitor_type | VARCHAR(20) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_JG_website_analytics_visitor ( _id INT(11) AUTO_INCREMENT PRIMARY KEY, _session tinytext, _postID INT(11), _url text, _time INT(10), _landing tinyINT(1), _referrer text, _device varchar(10), _resolution varchar(11), _browser varchar(10), _country varchar(70), _region varchar(100) NOT NULL DEFAULT '', _city varchar(100) NOT NULL DEFAULT '', _bot_score TINYINT NOT NULL DEFAULT 0, _bot_bucket TINYINT NOT NULL DEFAULT 0, _human_verified TINYINT NOT NULL DEFAULT 0, _visitor_type VARCHAR(20) NOT NULL DEFAULT 'unknown' ) ENGINE
Safe to delete?
If you have uninstalled JG Website 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_jg_website_analytics_visitor`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from JG Website Analytics