ALTER TABLE qrcode_ticket
    ADD COLUMN mp_visitor_id BIGINT NULL COMMENT '访客ID（mp_visitor.id）' AFTER order_id,
    ADD COLUMN generate_time DATETIME NULL COMMENT '二维码生成基准时间' AFTER ticket_status,
    ADD COLUMN expire_time DATETIME NULL COMMENT '二维码失效时间' AFTER generate_time;

ALTER TABLE qrcode_ticket
    ADD KEY idx_order_visitor_status (order_id, mp_visitor_id, ticket_status);