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