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