{"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","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","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}],"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/"}}