Hana card travel bucket

CREATE TABLE OMH_SUITE.HO_PROMOTION_CHANNEL (
PROMOTION_SEQ bigint NOT NULL COMMENT 'Promotion seq',
CHANNEL_CODE bigint NOT NULL COMMENT 'Channel Code',
FIRST_INSERT_UNO bigint NOT NULL DEFAULT 10000 COMMENT '최초 입력 사용자번호',
FIRST_INSERT_DATETIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '최초 입력 시각',
LAST_UPDATE_UNO bigint NOT NULL DEFAULT 10000 COMMENT '최종 수정 사용자번호',
LAST_UPDATE_DATETIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '최종 수정 시각',
PRIMARY KEY (PROMOTION_SEQ, CHANNEL_CODE)
)
ENGINE = INNODB,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_unicode_ci,
COMMENT = 'Promotiom Hotel Channel';

ALTER TABLE OMH_SUITE.HO_PROMOTION_CHANNEL
ADD INDEX XIF_HO_PROMOTION_CHANNEL_01 (PROMOTION_SEQ);

ALTER TABLE OMH_SUITE.HO_PROMOTION_CHANNEL
ADD INDEX XIF_HO_PROMOTION_CHANNEL_02 (CHANNEL_CODE);

ALTER TABLE OMH_SUITE.HO_PROMOTION_CHANNEL
ADD UNIQUE INDEX XPK_HO_PROMOTION_CHANNEL (PROMOTION_SEQ, CHANNEL_CODE);