-- SQL_分店設定資料表_增加欄位

-- 新增網訂前台顯示欄位
ALTER TABLE `store_branch`
ADD COLUMN `online_isview`  varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '網訂分店前台顯示' AFTER `branch_tin`;
UPDATE `store_branch` SET `online_isview` = '1';

-- 新增自助時間欄位
ALTER TABLE `store_branch`
ADD COLUMN `self_time_st`  varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自助時間(起)' AFTER `online_time_end`,
ADD COLUMN `self_time_end`  varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自助時間(訖)' AFTER `self_time_st`;

-- 新增自助機碼代號
ALTER TABLE `store_branch`
ADD COLUMN `self_machine_code`  varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '自助機碼代號' AFTER `online_machine_code`;