-- SQL_分店設定資料表_調整多元支付相關欄位
ALTER TABLE `store_branch`
MODIFY COLUMN `ncccpay_open`  varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多元信用卡開啟' AFTER `InstanceId`,
MODIFY COLUMN `ncccpay_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多元信用卡ID' AFTER `ncccpay_open`,
MODIFY COLUMN `ncccpay_key`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多元信用卡金鑰' AFTER `ncccpay_id`,
CHANGE COLUMN `applepay_open` `happycash_open`  varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '有錢卡開啟' AFTER `icash_key`,
CHANGE COLUMN `applepay_id` `happycash_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '有錢卡ID' AFTER `happycash_open`,
CHANGE COLUMN `applepay_key` `happycash_key`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '有錢卡金鑰' AFTER `happycash_id`;

-- SQL_銷售訂單資料表_調整多元支付相關欄位
ALTER TABLE `sale_order`
ADD COLUMN `pay_ncccpay_price`  float(10,2) NULL DEFAULT NULL COMMENT '多元信用卡金額' AFTER `pay_credit_price`,
CHANGE COLUMN `pay_applepay_price` `pay_happycash_price`  float(10,2) NULL DEFAULT NULL COMMENT '有錢卡金額' AFTER `pay_icash_price`;

-- SQL_交班單資料表_調整多元支付相關欄位
ALTER TABLE `hand_over_new`
ADD COLUMN `ncccpay_price`  float(10,2) NULL DEFAULT NULL COMMENT '多元信用卡金額' AFTER `credit_price`,
CHANGE COLUMN `applepay_price` `happycash_price`  float(10,2) NULL DEFAULT NULL COMMENT '有錢卡金額' AFTER `icash_price`;