{"slug":"jg-website-analytics","name":"JG Website Analytics","description":"An easy to use, privacy focused website analytics plugin that boasts functionality that only paid analytics tools provide.","author":"StuartCole","active_installs":10,"version":"2.6.0","wp_org_url":"https://wordpress.org/plugins/jg-website-analytics/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"jg_website_analytics_annotations","full_table_name":"wp_jg_website_analytics_annotations","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"_id","type":"INT(11)","nullable":true,"primary_key":true},{"name":"_date","type":"DATE","nullable":false,"primary_key":false},{"name":"_label","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"_description","type":"TEXT","nullable":true,"primary_key":false},{"name":"_color","type":"VARCHAR(7)","nullable":true,"primary_key":false},{"name":"_created_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"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"},{"table_name":"jg_website_analytics_bot_aggregates","full_table_name":"wp_jg_website_analytics_bot_aggregates","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"_id","type":"BIGINT","nullable":true,"primary_key":true},{"name":"_bucket_start","type":"DATETIME","nullable":false,"primary_key":false},{"name":"_route_group","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"_risk_bucket","type":"TINYINT","nullable":false,"primary_key":false},{"name":"_count_requests","type":"INT","nullable":false,"primary_key":false},{"name":"_count_html","type":"INT","nullable":false,"primary_key":false},{"name":"_count_asset","type":"INT","nullable":false,"primary_key":false},{"name":"_count_404","type":"INT","nullable":false,"primary_key":false},{"name":"_count_4xx","type":"INT","nullable":false,"primary_key":false},{"name":"_count_5xx","type":"INT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_JG_website_analytics_bot_aggregates ( _id BIGINT AUTO_INCREMENT PRIMARY KEY, _bucket_start DATETIME NOT NULL, _route_group VARCHAR(30) NOT NULL, _risk_bucket TINYINT NOT NULL DEFAULT 0, _count_requests INT NOT NULL DEFAULT 0, _count_html INT NOT NULL DEFAULT 0, _count_asset INT NOT NULL DEFAULT 0, _count_404 INT NOT NULL DEFAULT 0, _count_4xx INT NOT NULL DEFAULT 0, _count_5xx INT NOT NULL DEFAULT 0, UNIQUE KEY bucket_route_risk (_bucket_start, _route_group, _risk_bucket), KEY idx_bucket_start (_bucket_start) ) ENGINE"},{"table_name":"jg_website_analytics_bot_reasons","full_table_name":"wp_jg_website_analytics_bot_reasons","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"_id","type":"BIGINT","nullable":true,"primary_key":true},{"name":"_bucket_start","type":"DATETIME","nullable":false,"primary_key":false},{"name":"_route_group","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"_reason_code","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"_count_hits","type":"INT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_JG_website_analytics_bot_reasons ( _id BIGINT AUTO_INCREMENT PRIMARY KEY, _bucket_start DATETIME NOT NULL, _route_group VARCHAR(30) NOT NULL, _reason_code VARCHAR(30) NOT NULL, _count_hits INT NOT NULL DEFAULT 0, UNIQUE KEY bucket_route_reason (_bucket_start, _route_group, _reason_code), KEY idx_bucket_start (_bucket_start) ) ENGINE"},{"table_name":"jg_website_analytics_page_totals","full_table_name":"wp_jg_website_analytics_page_totals","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"_id","type":"INT(11)","nullable":true,"primary_key":true},{"name":"_date","type":"INT(10)","nullable":true,"primary_key":false},{"name":"_post_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"_visitors","type":"INT(10)","nullable":true,"primary_key":false},{"name":"_pageviews","type":"INT(12)","nullable":true,"primary_key":false}],"create_sql":"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"},{"table_name":"jg_website_analytics_sessions","full_table_name":"wp_jg_website_analytics_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[{"name":"_session","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"_last_seen","type":"INT(10)","nullable":false,"primary_key":false},{"name":"_last_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"_last_referrer","type":"TEXT","nullable":true,"primary_key":false},{"name":"_last_country","type":"VARCHAR(70)","nullable":false,"primary_key":false},{"name":"_last_region","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"_last_city","type":"VARCHAR(100)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_JG_website_analytics_sessions ( _session VARCHAR(100) NOT NULL, _last_seen INT(10) NOT NULL DEFAULT 0, _last_url TEXT, _last_referrer TEXT, _last_country VARCHAR(70) NOT NULL DEFAULT '', _last_region VARCHAR(100) NOT NULL DEFAULT '', _last_city VARCHAR(100) NOT NULL DEFAULT '', PRIMARY KEY (_session), KEY idx_last_seen (_last_seen) ) ENGINE"},{"table_name":"jg_website_analytics_totals","full_table_name":"wp_jg_website_analytics_totals","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"_id","type":"INT(11)","nullable":true,"primary_key":true},{"name":"_date","type":"INT(10)","nullable":true,"primary_key":false},{"name":"_visitors","type":"INT(10)","nullable":true,"primary_key":false},{"name":"_pageviews","type":"INT(12)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_JG_website_analytics_totals ( _id INT(11) AUTO_INCREMENT PRIMARY KEY, _date INT(10), _visitors INT(10), _pageviews INT(12) ) ENGINE"},{"table_name":"jg_website_analytics_visitor","full_table_name":"wp_jg_website_analytics_visitor","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"_id","type":"INT(11)","nullable":true,"primary_key":true},{"name":"_session","type":"tinytext","nullable":true,"primary_key":false},{"name":"_postID","type":"INT(11)","nullable":true,"primary_key":false},{"name":"_url","type":"text","nullable":true,"primary_key":false},{"name":"_time","type":"INT(10)","nullable":true,"primary_key":false},{"name":"_landing","type":"tinyINT(1)","nullable":true,"primary_key":false},{"name":"_referrer","type":"text","nullable":true,"primary_key":false},{"name":"_device","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"_resolution","type":"varchar(11)","nullable":true,"primary_key":false},{"name":"_browser","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"_country","type":"varchar(70)","nullable":true,"primary_key":false},{"name":"_region","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"_city","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"_bot_score","type":"TINYINT","nullable":false,"primary_key":false},{"name":"_bot_bucket","type":"TINYINT","nullable":false,"primary_key":false},{"name":"_human_verified","type":"TINYINT","nullable":false,"primary_key":false},{"name":"_visitor_type","type":"VARCHAR(20)","nullable":false,"primary_key":false}],"create_sql":"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"}],"table_count":7}