WordPress database error: [Specified key was too long; max key length is 1000 bytes]CREATE TABLE IF NOT EXISTS wpfx_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_520_ci
We Serve
Lion David Davis says this:
What a great tournament for an even better cause, “Sight”. Thank you to my fellow Lions for all the hard work, and to all the sponsors and participants… Thank you all!!!!!
Thank you to Lion Dr. Joyce Haskell and Lion Susan Davis Callis for these pictures!
