خطأ فى قاعدة بيانات ووردبريس: [Specified key was too long; max key length is 1000 bytes]
CREATE TABLE IF NOT EXISTS wpy9_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
درهم 150
