wp_jg_website_analytics_annotations
StaticStores analytics or statistics data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑_id | INT(11) | YES |
| _date | DATE | NO |
| _label | VARCHAR(100) | NO |
| _description | TEXT | YES |
| _color | VARCHAR(7) | YES |
| _created_at | TIMESTAMP | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_JG_website_analytics_annotations ( _id INT(11) AUTO_INCREMENT PRIMARY KEY, _date DATE NOT NULL, _label VARCHAR(100) NOT NULL, _description TEXT, _color VARCHAR(7) DEFAULT '#fe7404', _created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) 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_annotations`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from JG Website Analytics