CREATE TABLE blc_combinability_override (offer_id VARCHAR(255) NOT NULL, related_offer VARCHAR(255) NOT NULL, override_type VARCHAR(255) NOT NULL, CONSTRAINT PK_BLC_COMBINABILITY_OVERRIDE PRIMARY KEY (offer_id, related_offer));
ALTER TABLE blc_offer ADD stackable CHAR(1) DEFAULT 'N' NOT NULL;
ALTER TABLE blc_offer_marketing_message ADD display_hint VARCHAR(255) NULL;
ALTER TABLE blc_offer_marketing_message ADD location_types LONGTEXT NULL;
ALTER TABLE blc_offer_marketing_message ADD max_cart_subtotal DECIMAL(19, 2) DEFAULT null NULL;
ALTER TABLE blc_offer_marketing_message ADD min_cart_subtotal DECIMAL(19, 2) DEFAULT null NULL;
ALTER TABLE blc_offer_marketing_message ADD show_if_offer_applied CHAR(1) DEFAULT 'N' NULL;
ALTER TABLE blc_offer_marketing_message ADD use_cart_subtotal CHAR(1) DEFAULT 'N' NULL;
ALTER TABLE blc_offer ADD free_product VARCHAR(255) NULL;
ALTER TABLE blc_offer ADD is_free_gift CHAR(1) DEFAULT 'N' NOT NULL;
ALTER TABLE blc_offer ADD attributes LONGTEXT NULL;
ALTER TABLE blc_offer ADD voucher_campaign VARCHAR(255) NULL;
ALTER TABLE blc_offer ADD is_voucher CHAR(1) DEFAULT 'N' NOT NULL;
ALTER TABLE blc_offer ADD distribute_amt_to_targets CHAR(1) DEFAULT 'N' NOT NULL;
ALTER TABLE blc_offer ADD prefer_cart_bundling CHAR(1) DEFAULT 'N' NOT NULL;
ALTER TABLE blc_offer ADD estimated_value DECIMAL(19, 2) DEFAULT null NULL;