OMH

ALTER TABLE BS_COUPON_BUDGET ADD COLUMN
COUPON_RATE_PERCENTAGE decimal(15, 2) DEFAULT NULL;

ALTER TABLE BS_COUPON_BUDGET
ADD COLUMN
ARRIVAL_FROM_DATE date ,
ADD COLUMN ARRIVAL_TO_DATE date

ALTER TABLE BS_COUPON_BUDGET
ADD COLUMN BUDGET_COUPON_CLAIM_YN varchar(1) NOT NULL DEFAULT 'N'
COMMENT 'Coupon distribution type: Y=User must claim first (deduct on claim), N=No claim needed (open code)';

CREATE TABLE OMH_SUITE.BS_COUPON_COUNTRY_BUDGET (
COUPON_BUDGET_SEQ bigint(20) NOT NULL COMMENT 'Main key of coupon budget (FK to coupon budget master)',
COUNTRY_CODE varchar(5) NOT NULL COMMENT 'Country Code (FK to BS_COUNTRY_CODE)',
FIRST_INSERT_UNO bigint(20) NOT NULL DEFAULT 10000 COMMENT 'User created this item',
FIRST_INSERT_DATETIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created date time',
LAST_UPDATE_UNO bigint(20) NOT NULL DEFAULT 10000 COMMENT 'User updated this item',
LAST_UPDATE_DATETIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last update date time',
PRIMARY KEY (COUPON_BUDGET_SEQ, COUNTRY_CODE)
)
ENGINE = INNODB,
AVG_ROW_LENGTH = 162,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_unicode_ci,
COMMENT = 'This for country coupon';

ALTER TABLE OMH_SUITE.BS_COUPON_COUNTRY_BUDGET
ADD INDEX XIF_BS_COUPON_COUNTRY_BUDGET_COUNTRY_CODE (COUNTRY_CODE);

ALTER TABLE OMH_SUITE.BS_COUPON_COUNTRY_BUDGET
ADD UNIQUE INDEX XPK_BS_COUPON_COUNTRY_BUDGET_COUPON_BUDGET_SEQ_REGION_CODE (COUPON_BUDGET_SEQ, COUNTRY_CODE);

API download coupons

insert into BS_API_SERVICE_CODE (API_SERVICE_URL, METHOD_NAME, OWNER_COMP_CODE, API_SERVICE_NAME_EN,
API_SERVICE_NAME_KO, SCHEMA_FILE_NAME_RQ, SCHEMA_FILE_NAME_RS, VENDOR_SERVICE_NAME,
API_SERVICE_DESC, SAMPLE_REQUEST_MESSAGE, SAMPLE_RESPONSE_MESSAGE, OPEN_API_YN,
OUTSIDE_INTERFACE_YN, LOG_SAVE_YN, IGNORE_SCHEMA_YN, CONTROL_REMARK, USE_YN,
FIRST_INSERT_UNO, FIRST_INSERT_DATETIME, LAST_UPDATE_UNO, LAST_UPDATE_DATETIME)
values ('/coupon/hotel/download-list'
, 'POST'
, 110000
, 'Download list B2C coupons by hotel'
, 'Download list B2C coupons by hotel'
, '/hotel/coupon/download_list/download_list_schema_rq.json'
, '/hotel/coupon/download_list/download_list_schema_rs.json'
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 'N'
, 'N'
, NULL
, 'Y'
, 90043
, NOW
, 90043
, NOW
);

table BS_COUPON_REGION_BUDGET

--
-- Set character set the client will use to send SQL statements to the server
--
SET NAMES 'utf8';

--
-- Set default database
--
USE OMH_SUITE;

--
-- Create table `BS_COUPON_REGION_BUDGET`
--
CREATE TABLE BS_COUPON_REGION_BUDGET (
COUPON_BUDGET_SEQ BIGINT NOT NULL COMMENT 'Main key of coupon budget (FK to coupon budget master)',
REGION_CODE BIGINT NOT NULL COMMENT 'Hotel Region Code (FK to BS_REGION_CODE)',
FIRST_INSERT_UNO BIGINT NOT NULL DEFAULT 10000 COMMENT 'User created this item',
FIRST_INSERT_DATETIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created date time',
LAST_UPDATE_UNO BIGINT NOT NULL DEFAULT 10000 COMMENT 'User updated this item',
LAST_UPDATE_DATETIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last update date time',
PRIMARY KEY (COUPON_BUDGET_SEQ, REGION_CODE)
)
ENGINE = INNODB,
AVG_ROW_LENGTH = 162,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_unicode_ci,
COMMENT = 'This for hotel region coupon',
ROW_FORMAT = DYNAMIC;

--
-- Create index `XIF_BS_COUPON_REGION_BUDGET_REGION_CODE` on table `BS_COUPON_REGION_BUDGET`
--
ALTER TABLE BS_COUPON_REGION_BUDGET
ADD INDEX XIF_BS_COUPON_REGION_BUDGET_REGION_CODE(REGION_CODE);

--
-- Create index `XPK_BS_COUPON_REGION_BUDGET_PROMOTION_SEQ_REGION_CODE` on table `BS_COUPON_REGION_BUDGET`
--
ALTER TABLE BS_COUPON_REGION_BUDGET
ADD UNIQUE INDEX XPK_BS_COUPON_REGION_BUDGET_PROMOTION_SEQ_REGION_CODE(COUPON_BUDGET_SEQ, REGION_CODE);