CREATE TABLE BLC_COMBINABILITY_OVERRIDE (OFFER_ID VARCHAR2(255 CHAR) NOT NULL, RELATED_OFFER VARCHAR2(255 CHAR) NOT NULL, OVERRIDE_TYPE VARCHAR2(255 CHAR) NOT NULL, CONSTRAINT CT_VM6IH1XEN85MXAFDI4I2 PRIMARY KEY (OFFER_ID, RELATED_OFFER));
ALTER TABLE BLC_OFFER ADD STACKABLE CHAR(1 CHAR) DEFAULT 'N' NOT NULL;
ALTER TABLE BLC_OFFER_MARKETING_MESSAGE ADD DISPLAY_HINT VARCHAR2(255 CHAR);
ALTER TABLE BLC_OFFER_MARKETING_MESSAGE ADD LOCATION_TYPES CLOB;
ALTER TABLE BLC_OFFER_MARKETING_MESSAGE ADD MAX_CART_SUBTOTAL NUMBER(19, 2);
ALTER TABLE BLC_OFFER_MARKETING_MESSAGE ADD MIN_CART_SUBTOTAL NUMBER(19, 2);
ALTER TABLE BLC_OFFER_MARKETING_MESSAGE ADD SHOW_IF_OFFER_APPLIED CHAR(1 CHAR) DEFAULT 'N';
ALTER TABLE BLC_OFFER_MARKETING_MESSAGE ADD USE_CART_SUBTOTAL CHAR(1 CHAR) DEFAULT 'N';
ALTER TABLE BLC_OFFER ADD FREE_PRODUCT VARCHAR2(255 CHAR);
ALTER TABLE BLC_OFFER ADD IS_FREE_GIFT CHAR(1 CHAR) DEFAULT 'N' NOT NULL;
ALTER TABLE BLC_OFFER ADD ATTRIBUTES CLOB;
ALTER TABLE BLC_OFFER ADD IS_VOUCHER CHAR(1 CHAR) DEFAULT 'N' NOT NULL;
ALTER TABLE BLC_OFFER ADD VOUCHER_CAMPAIGN VARCHAR2(255 CHAR);
ALTER TABLE BLC_OFFER ADD DISTRIBUTE_AMT_TO_TARGETS CHAR(1 CHAR) DEFAULT 'N' NOT NULL;
ALTER TABLE BLC_OFFER ADD PREFER_CART_BUNDLING CHAR(1 CHAR) DEFAULT 'N' NOT NULL;
ALTER TABLE BLC_OFFER ADD ESTIMATED_VALUE NUMBER(19, 2);
