WordPress database error: [Invalid default value for 'created_at']
CREATE TABLE IF NOT EXISTS BFc_embedpress_analytics_content ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, content_id varchar(255) NOT NULL, content_type varchar(50) NOT NULL DEFAULT 'unknown', embed_type varchar(100) NOT NULL, embed_url text NOT NULL, post_id bigint(20) unsigned DEFAULT NULL, page_url text DEFAULT NULL, title varchar(500) DEFAULT NULL, total_views bigint(20) unsigned DEFAULT 0, total_impressions bigint(20) unsigned DEFAULT 0, total_clicks bigint(20) unsigned DEFAULT 0, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY unique_page_embed (page_url(255), embed_type), KEY idx_content_type (content_type), KEY idx_embed_type (embed_type), KEY idx_post_id (post_id), KEY idx_created_at (created_at), KEY idx_total_views (total_views) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

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 BFc_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), KEY idx_user_id (user_id), KEY idx_session_id (session_id), KEY idx_interaction_type (interaction_type), KEY idx_created_at (created_at), KEY idx_user_ip (user_ip), KEY idx_content_interaction (content_id, interaction_type), KEY idx_daily_stats (content_id, interaction_type, created_at), KEY idx_user_content_interaction (user_id, content_id, interaction_type), KEY idx_deduplication (user_id, content_id, interaction_type, created_at) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

WordPress database error: [Invalid default value for 'created_at']
CREATE TABLE IF NOT EXISTS BFc_embedpress_analytics_browser_info ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id varchar(255) DEFAULT NULL, session_id varchar(255) NOT NULL, browser_fingerprint varchar(64) DEFAULT NULL, browser_name varchar(100) DEFAULT NULL, browser_version varchar(50) DEFAULT NULL, operating_system varchar(100) DEFAULT NULL, device_type enum('desktop', 'mobile', 'tablet', 'unknown') DEFAULT 'unknown', screen_resolution varchar(20) DEFAULT NULL, language varchar(10) DEFAULT NULL, timezone varchar(50) DEFAULT NULL, country varchar(100) DEFAULT NULL, city varchar(100) DEFAULT NULL, user_agent text DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY unique_user_fingerprint (user_id, browser_fingerprint), KEY idx_user_id (user_id), KEY idx_session_id (session_id), KEY idx_browser_fingerprint (browser_fingerprint), KEY idx_browser_name (browser_name), KEY idx_operating_system (operating_system), KEY idx_device_type (device_type), KEY idx_country (country), KEY idx_created_at (created_at) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

WordPress database error: [Invalid default value for 'achieved_at']
CREATE TABLE IF NOT EXISTS BFc_embedpress_analytics_milestones ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, milestone_type enum('total_views', 'total_embeds', 'daily_views', 'monthly_views') NOT NULL, milestone_value bigint(20) unsigned NOT NULL, achieved_value bigint(20) unsigned NOT NULL, is_notified tinyint(1) DEFAULT 0, achieved_at datetime DEFAULT CURRENT_TIMESTAMP, notified_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY idx_milestone_type (milestone_type), KEY idx_milestone_value (milestone_value), KEY idx_is_notified (is_notified), KEY idx_achieved_at (achieved_at) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

WordPress database error: [Invalid default value for 'first_visit']
CREATE TABLE IF NOT EXISTS BFc_embedpress_analytics_referrers ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, referrer_url text NOT NULL, referrer_domain varchar(255) NOT NULL, referrer_source varchar(100) DEFAULT NULL, utm_source varchar(100) DEFAULT NULL, utm_medium varchar(100) DEFAULT NULL, utm_campaign varchar(255) DEFAULT NULL, utm_term varchar(255) DEFAULT NULL, utm_content varchar(255) DEFAULT NULL, total_views bigint(20) unsigned DEFAULT 0, total_clicks bigint(20) unsigned DEFAULT 0, unique_visitors bigint(20) unsigned DEFAULT 0, first_visit datetime DEFAULT CURRENT_TIMESTAMP, last_visit datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY unique_referrer_url (referrer_url(255)), KEY idx_referrer_domain (referrer_domain), KEY idx_referrer_source (referrer_source), KEY idx_utm_source (utm_source), KEY idx_utm_medium (utm_medium), KEY idx_utm_campaign (utm_campaign), KEY idx_total_views (total_views), KEY idx_total_clicks (total_clicks), KEY idx_unique_visitors (unique_visitors), KEY idx_first_visit (first_visit), KEY idx_last_visit (last_visit), KEY idx_created_at (created_at) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci