WordPress database error: [Specified key was too long; max key length is 1000 bytes]CREATE TABLE wp_autoship_quicklink_confirmations (
id BIGINT UNSIGNED AUTO_INCREMENT,
uuid VARCHAR(36) NOT NULL,
slug VARCHAR(255) NOT NULL,
scheduled_order_id BIGINT NOT NULL,
site_id BIGINT NOT NULL,
action_type TINYINT NOT NULL,
action_name VARCHAR(50) NOT NULL,
status VARCHAR(20) DEFAULT 'pending',
ip_address VARCHAR(45) NULL,
submission_ip_address VARCHAR(45) NULL,
ip_changed TINYINT(1) DEFAULT 0,
user_agent TEXT NULL,
referer TEXT NULL,
customer_id BIGINT NULL,
wp_user_id BIGINT NULL,
shown_at DATETIME NOT NULL,
submitted_at DATETIME NULL,
executed_at DATETIME NULL,
expired_at DATETIME NULL,
time_to_submit_seconds INT NULL,
verification_metadata LONGTEXT NULL,
execution_result LONGTEXT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY uuid (uuid),
KEY idx_status (status),
KEY idx_slug_order (slug, scheduled_order_id),
KEY idx_shown_at (shown_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
