WordPress database error: [Invalid default value for 'created_at']CREATE TABLE IF NOT EXISTS wp_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(191), embed_type(50)),
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 MariaDB 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_ci
WordPress database error: [Invalid default value for 'created_at']CREATE TABLE IF NOT EXISTS wp_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(191), browser_fingerprint(50)),
KEY idx_user_id (user_id(191)),
KEY idx_session_id (session_id(191)),
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 wp_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 wp_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(191)),
KEY idx_referrer_domain (referrer_domain(191)),
KEY idx_referrer_source (referrer_source),
KEY idx_utm_source (utm_source),
KEY idx_utm_medium (utm_medium),
KEY idx_utm_campaign (utm_campaign(191)),
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
Cultivating Sustainability
for the Future
This initiative aligns with SDG 3: Good Health and Well-Being, as it promotes physical activity, wellness, and healthy lifestyle practices among staff. The program encouraged participants to engage in outdoor exercise, reducing stress levels and enhancing overall fitness, which in turn supports improved productivity and mental well-being in the workplace.
