WordPress database error: [Specified key was too long; max key length is 1000 bytes]
CREATE TABLE wp_ajr_esf_youtube_cache (
id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
cache_key varchar(255) NOT NULL,
cache_data longtext NOT NULL COMMENT 'Compressed JSON data',
cache_type enum('account','feed','api') DEFAULT 'feed',
feed_id bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Feed ID for feed-scoped cache',
account_id bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Account ID for account-scoped cache',
expires_at datetime NOT NULL,
created_at datetime NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY cache_key (cache_key),
KEY expires_at (expires_at),
KEY cache_type (cache_type),
KEY feed_id (feed_id),
KEY account_id (account_id),
KEY cache_key_expires (cache_key, expires_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [Specified key was too long; max key length is 1000 bytes]
CREATE TABLE wp_ajr_esf_twitter_cache (
id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
cache_key varchar(255) NOT NULL,
cache_data longtext NOT NULL COMMENT 'JSON-encoded API response',
cache_type enum('account','feed','api') DEFAULT 'api',
feed_id bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Feed ID for feed-scoped cache',
account_id bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Account ID for account-scoped cache',
expires_at datetime NOT NULL,
created_at datetime NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY cache_key (cache_key),
KEY expires_at (expires_at),
KEY cache_type (cache_type),
KEY feed_id (feed_id),
KEY account_id (account_id),
KEY cache_key_expires (cache_key, expires_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci