Cultivating Sustainability
for the Future
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
