WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json DEFAULT NULL,
view_duration int(11) unsigned DEFAULT 0,
' at line 11]
CREATE TABLE IF NOT EXISTS wp_embedpress_analytics_views (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
content_id varchar(255) NOT NULL,
user_id varchar(255) DEFAULT NULL,
session_id varchar(255) NOT NULL,
user_ip varchar(45) DEFAULT NULL,
user_agent text DEFAULT NULL,
referrer_url text DEFAULT NULL,
page_url text DEFAULT NULL,
interaction_type enum('impression', 'click', 'view', 'play', 'pause', 'complete') NOT NULL DEFAULT 'impression',
interaction_data json DEFAULT NULL,
view_duration int(11) unsigned DEFAULT 0,
created_at datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id),
KEY idx_content_id (content_id(191)),
KEY idx_user_id (user_id(191)),
KEY idx_session_id (session_id(191)),
KEY idx_interaction_type (interaction_type),
KEY idx_created_at (created_at),
KEY idx_user_ip (user_ip),
KEY idx_content_interaction (content_id(191), interaction_type),
KEY idx_daily_stats (content_id(191), interaction_type, created_at),
KEY idx_user_content_interaction (user_id(100), content_id(100), interaction_type),
KEY idx_deduplication (user_id(100), content_id(100), interaction_type, created_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
