etrade / zr-etrade · Files

etrade_order_v1.1.2_fengliang.sql 281 Bytes
1 2 3 4 5 6 
ALTER TABLE `zr_etrade`.`order_payment`
    ADD COLUMN `pay_channel_sub` tinyint NULL COMMENT '园区卡支付子分类';

UPDATE zr_etrade.`order_payment` payment LEFT JOIN zr_etrade.`order` ord ON payment.order_id = ord.id
SET payment.pay_channel_sub = 1
WHERE ord.order_type = 2