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);
|
