WordPress database error: [Specified key was too long; max key length is 1000 bytes]
CREATE TABLE wp31_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