-- SQL_分店資料表_調整多元金流欄位
ALTER TABLE `store_branch`
ADD COLUMN `ncccpay_e_open`  varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多元電子票證開啟' AFTER `ncccpay_open`,
MODIFY COLUMN `linepay_open`  varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'LINE Pay開啟' AFTER `ncccpay_key`,
DROP COLUMN `easycard_open`,
DROP COLUMN `easycard_id`,
DROP COLUMN `easycard_key`,
DROP COLUMN `ipass_open`,
DROP COLUMN `ipass_id`,
DROP COLUMN `ipass_key`,
DROP COLUMN `icash_open`,
DROP COLUMN `icash_id`,
DROP COLUMN `icash_key`,
DROP COLUMN `happycash_open`,
DROP COLUMN `happycash_id`,
DROP COLUMN `happycash_key`;