-- SQL_銷售訂單資料表_新增LINEPAY及街口支付訂單編號
ALTER TABLE `sale_order`
ADD COLUMN `linepay_no`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'LINEPAY訂單編號' AFTER `back_inv_cancel_date`,
ADD COLUMN `jkopay_no`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '街口支付訂單編號' AFTER `linepay_no`;