ALTER TABLE pay_details MODIFY COLUMN `trade_no` VARCHAR(32) COMMENT '支付系统交易订单号'; CREATE INDEX order_number_index ON pay_details(order_id); CREATE INDEX trade_no_index ON pay_details(trade_no);