{"table_name":"attentiq_hourly_stats","full_table_name":"wp_attentiq_hourly_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_attentiq_hourly_stats` ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, post_id BIGINT UNSIGNED NOT NULL, stat_date DATE NOT NULL, stat_hour TINYINT UNSIGNED NOT NULL, device VARCHAR(10) NOT NULL DEFAULT 'all', views INT UNSIGNED DEFAULT 0, unique_views INT UNSIGNED DEFAULT 0, total_time FLOAT DEFAULT 0, avg_scroll FLOAT DEFAULT 0, UNIQUE KEY post_date_hour_device (post_id, stat_date, stat_hour, device), KEY idx_stat_date (stat_date) ) {$charset}\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":true},{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"stat_date","type":"DATE","nullable":false,"primary_key":false},{"name":"stat_hour","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"device","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"views","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"total_time","type":"FLOAT","nullable":true,"primary_key":false},{"name":"avg_scroll","type":"FLOAT","nullable":true,"primary_key":false}],"plugin":{"slug":"attentiq","name":"AttentIQ","active_installs":0,"version":"1.2.3","wp_org_url":"https://wordpress.org/plugins/attentiq/"}}