wp_jg_website_analytics_page_totals

Static

Stores analytics or statistics data.

Column Definitions

Column	Type	Nullable
🔑_id	INT(11)	YES
_date	INT(10)	YES
_post_id	bigint(20)	YES
_visitors	INT(10)	YES
_pageviews	INT(12)	YES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS wp_JG_website_analytics_page_totals ( _id INT(11) AUTO_INCREMENT PRIMARY KEY, _date INT(10), _post_id bigint(20), _visitors INT(10), _pageviews INT(12) ) 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_page_totals`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from JG Website Analytics

wp_jg_website_analytics_annotations wp_jg_website_analytics_bot_aggregates wp_jg_website_analytics_bot_reasons wp_jg_website_analytics_sessions wp_jg_website_analytics_totals wp_jg_website_analytics_visitor