{"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","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","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}],"plugin":{"slug":"jg-website-analytics","name":"JG Website Analytics","active_installs":10,"version":"2.6.0","wp_org_url":"https://wordpress.org/plugins/jg-website-analytics/"}}