خطأ فى قاعدة بيانات ووردبريس: [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