ngds/sql/2020_12/update.sql

ALTER TABLE `AR_EXCEL_ORDER_SHOP` ADD `ORDER_DAY` DATE NOT NULL AFTER `PERIOD_NUM`;
ALTER TABLE `AR_EXCEL_ORDER_SHOP` ADD `ORDER_TYPE` CHAR(4) NOT NULL DEFAULT 'FX' AFTER `ORDER_DAY`;
ALTER TABLE `AR_EXCEL_ORDER_SHOP` DROP INDEX `PERIOD_NUM`;

ALTER TABLE `AR_ORDER_SHOP` ADD `ORDER_DAY` DATE NOT NULL AFTER `PERIOD_NUM`;

ALTER TABLE `AR_ORDER_GOODS_SHOP` ADD `ORDER_DAY` DATE NOT NULL AFTER `PERIOD_NUM`;
ALTER TABLE `AR_ORDER_GOODS_SHOP` ADD `PAY_TYPE` VARCHAR(32) NOT NULL DEFAULT 'cahs' AFTER `ORDER_DAY`;