Documentation Home
This version of the framework is no longer supported. View the latest documentation.
Changelog

MySQL Clean Up Script (Enterprise)

DROP TABLE BLC_FIELD_SEARCH_TYPES;
ALTER TABLE BLC_STORE DROP COLUMN ADDRESS_1;
ALTER TABLE BLC_STORE DROP COLUMN ADDRESS_2;
ALTER TABLE BLC_OFFER DROP COLUMN APPLIES_TO_RULES;
ALTER TABLE BLC_OFFER DROP COLUMN APPLIES_WHEN_RULES;
ALTER TABLE BLC_OFFER DROP COLUMN APPLY_OFFER_TO_MARKED_ITEMS;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN ARCHIVED;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN CREATED_BY;
ALTER TABLE BLC_CUSTOM_FIELD DROP COLUMN CUSTOM_FIELD_ID;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN DATE_CREATED;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN DATE_UPDATED;
ALTER TABLE BLC_FIELD DROP COLUMN FACET_FIELD_TYPE;
ALTER TABLE BLC_SEARCH_FACET DROP FOREIGN KEY FK4FFCC9863C3907C4;
ALTER TABLE BLC_SEARCH_FACET DROP COLUMN FIELD_ID;
ALTER TABLE BLC_CUSTOM_FIELD DROP COLUMN FRIENDLY_NAME;
ALTER TABLE BLC_OFFER DROP COLUMN OFFER_DELIVERY_TYPE;
ALTER TABLE BLC_OFFER DROP COLUMN PRICING_CONTEXT_RULE;
ALTER TABLE BLC_CUSTOM_FIELD DROP COLUMN SEARCHABLE;
ALTER TABLE BLC_FIELD DROP COLUMN SEARCHABLE;
ALTER TABLE BLC_CATEGORY DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CATEGORY_ATTRIBUTE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CATEGORY_MEDIA_MAP DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CATEGORY_PRODUCT_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CATEGORY_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CAT_SEARCH_FACET_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CMS_MENU DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CMS_MENU_ITEM DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CNTNT_TRGT_ACTION_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CNTNT_TRGT_ITEM_CRIT DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CNTNT_TRGT_RULES DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CONTENT_ITEM DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CONTENT_TARGETER DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CONTENT_TARGETING_ACTION DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CONTENT_TARGET_RULE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CONTENT_ZONE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CONTENT_ZONE_DEF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CON_ZONE_DEF_WDGT_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_DATA_DRVN_ENUM DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_DATA_DRVN_ENUM_VAL DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_DYNAMIC_REGIONAL_FORM DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_DYN_REG_FORM_FIELD DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_DYN_REG_FORM_FIELD_CAT DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_FLD_DEF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_FLD_GROUP DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_FULFILLMENT_OPTION DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_FULFILLMENT_PRICE_BAND DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_FULFILLMENT_WEIGHT_BAND DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_INTERNATIONAL_MSG DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_MEDIA DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_OFFER DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_OFFER_CODE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_OFFER_ITEM_CRITERIA DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_OFFER_RULE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_OFFER_RULE_MAP DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_OFFER_TIER DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_OVERRIDE_CONTENT_ITEM DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_OVERRIDE_SC_FIELD DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_OVERRIDE_SC_ITEM DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PAGE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PAGE_ATTRIBUTES DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PAGE_FLD DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PAGE_ITEM_CRITERIA DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PAGE_RULE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PAGE_TMPLT DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PAGE_TYPE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PAGE_TYPE_FLDDEF_MAP DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PGTMPLT_FLDGRP_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PL_CRITERIA_RULE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PL_RULE_MAP DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PRICE_ADJUSTMENT DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PRICE_LIST DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PRICE_MODIFIER DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PRODUCT DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PRODUCT_ATTRIBUTE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PRODUCT_CROSS_SALE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PRODUCT_FEATURED DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PRODUCT_OPTION DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PRODUCT_OPTION_VALUE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PRODUCT_OPTION_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_PRODUCT_UP_SALE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_QUAL_CRIT_OFFER_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SC DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SC_CONTENT_ITEM_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SC_FLD DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SC_FLD_MAP DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SC_ITEM_CRITERIA DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SC_RULE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SC_TYPE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SC_TYPE_WIDGET_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SEARCH_FACET DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SEARCH_FACET_RANGE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SEARCH_FACET_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SKU DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SKU_ATTRIBUTE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SKU_BNDL_ITM_PRC_DATA DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SKU_BUNDLE_ITEM DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SKU_FEE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SKU_MEDIA_MAP DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SKU_OPTION_VALUE_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SKU_PRICE_DATA DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SKU_PRICE_DATA_TIER DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_SYSTEM_PROPERTY DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_TAR_CRIT_OFFER_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_THEME_CONFIGURATION DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_THEME_DEFINITION DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_THEME_FILE DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_THEME_FILE_PAGE_TYPE_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_THEME_FLD DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_THMDEF_FLDGRP_XREF DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_TRANSLATION DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_URL_HANDLER DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_WIDGET DROP COLUMN SNDBX_APPROVAL_STATUS;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN SNDBX_ARCHIVED_FLAG;
ALTER TABLE BLC_SEARCH_FACET DROP COLUMN SNDBX_ARCHIVED_FLAG;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN SNDBX_CATALOG_FLAG;
ALTER TABLE BLC_SEARCH_FACET DROP COLUMN SNDBX_CATALOG_FLAG;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN SNDBX_DELETED_FLAG;
ALTER TABLE BLC_SEARCH_FACET DROP COLUMN SNDBX_DELETED_FLAG;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN SNDBX_ID;
ALTER TABLE BLC_SEARCH_FACET DROP COLUMN SNDBX_ID;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN SNDBX_ORIG_ITEM_ID;
ALTER TABLE BLC_SEARCH_FACET DROP COLUMN SNDBX_ORIG_ITEM_ID;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN SNDBX_ORIG_RECORD_ID;
ALTER TABLE BLC_SEARCH_FACET DROP COLUMN SNDBX_ORIG_RECORD_ID;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN SNDBX_TIER;
ALTER TABLE BLC_SEARCH_FACET DROP COLUMN SNDBX_TIER;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN SNDBX_TMPLT_RECORD_ID;
ALTER TABLE BLC_SEARCH_FACET DROP COLUMN SNDBX_TMPLT_RECORD_ID;
ALTER TABLE BLC_OFFER DROP COLUMN STACKABLE;
ALTER TABLE BLC_STORE DROP COLUMN STORE_CITY;
ALTER TABLE BLC_STORE DROP COLUMN STORE_COUNTRY;
ALTER TABLE BLC_STORE DROP COLUMN STORE_PHONE;
ALTER TABLE BLC_STORE DROP COLUMN STORE_STATE;
ALTER TABLE BLC_STORE DROP COLUMN STORE_ZIP;
ALTER TABLE BLC_CAT_SEARCH_FACET_EXCL_XREF DROP COLUMN UPDATED_BY;
ALTER TABLE BLC_OFFER DROP COLUMN USES;
ALTER TABLE BLC_OFFER DROP COLUMN USE_NEW_FORMAT;

ALTER TABLE BLC_CUSTOM_FIELD MODIFY ATTR_NAME VARCHAR(255) NULL;
ALTER TABLE BLC_CONTENT_ZONE MODIFY CONTENT_ZONE_DEF BIGINT NULL;
ALTER TABLE BLC_CUSTOM_FIELD MODIFY CUSTOM_FIELD_TARGET VARCHAR(255) NULL;
ALTER TABLE BLC_CUSTOM_FIELD MODIFY CUSTOM_FIELD_TYPE VARCHAR(255) NULL;
ALTER TABLE BLC_CUSTOM_FIELD ADD PRIMARY KEY (FIELD_ID);
ALTER TABLE BLC_ASSET_FOLDER_XREF ADD CONSTRAINT FK102A01D7706F08F1 FOREIGN KEY (PARENT_FOLDER_ID) REFERENCES BLC_ASSET_FOLDER (ASSET_FOLDER_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_ASSET_FOLDER_XREF ADD CONSTRAINT FK102A01D7FE088EE3 FOREIGN KEY (CHILD_FOLDER_ID) REFERENCES BLC_ASSET_FOLDER (ASSET_FOLDER_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_PRICE_LIST_CUST_SEG_XREF ADD CONSTRAINT FK3902F48C2EF95B6A FOREIGN KEY (PRICE_LIST_ID) REFERENCES BLC_PRICE_LIST (PRICE_LIST_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_PRICE_LIST_CUST_SEG_XREF ADD CONSTRAINT FK3902F48CB8718EEC FOREIGN KEY (CUSTOMER_SEGMENT_ID) REFERENCES BLC_CUSTOMER_SEGMENT (CUSTOMER_SEGMENT_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_INDEX_FIELD_TYPE ADD CONSTRAINT FK4A310B72CBDA280B FOREIGN KEY (INDEX_FIELD_ID) REFERENCES BLC_INDEX_FIELD (INDEX_FIELD_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_SEARCH_FACET ADD CONSTRAINT FK4FFCC986BE3CE566 FOREIGN KEY (INDEX_FIELD_TYPE_ID) REFERENCES BLC_INDEX_FIELD_TYPE (INDEX_FIELD_TYPE_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_ALLOWED_ENUM_VALUE ADD CONSTRAINT FK5552E87062A47BC4 FOREIGN KEY (FIELD_ID) REFERENCES BLC_CUSTOM_FIELD (FIELD_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_CUSTOM_FIELD ADD CONSTRAINT FK5FF15FD23C3907C4 FOREIGN KEY (FIELD_ID) REFERENCES BLC_FIELD (FIELD_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_BOOST_RULE_CAT ADD CONSTRAINT FK6F1E0F515D1A13D FOREIGN KEY (CATEGORY_ID) REFERENCES BLC_CATEGORY (CATEGORY_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_BOOST_RULE_CAT ADD CONSTRAINT FK6F1E0F5BE3CE566 FOREIGN KEY (INDEX_FIELD_TYPE_ID) REFERENCES BLC_INDEX_FIELD_TYPE (INDEX_FIELD_TYPE_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_OFFER ADD CONSTRAINT FK8F55F7B699291672 FOREIGN KEY (OFFER_TEMPLATE_ID) REFERENCES BLC_OFFER_TEMPLATE (OFFER_TEMPLATE_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_STORE ADD CONSTRAINT FK8F94D63BC13085DD FOREIGN KEY (ADDRESS_ID) REFERENCES BLC_ADDRESS (ADDRESS_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_OFFER_CODE_RULE_MAP ADD CONSTRAINT FK8FAD02C2446C7306 FOREIGN KEY (OFFER_CODE_RULE_ID) REFERENCES BLC_OFFER_CODE_RULE (OFFER_CODE_RULE_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_OFFER_CODE_RULE_MAP ADD CONSTRAINT FK8FAD02C29D28BF84 FOREIGN KEY (BLC_OFFER_CODE_OFFER_CODE_ID) REFERENCES BLC_OFFER_CODE (OFFER_CODE_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_INDEX_FIELD ADD CONSTRAINT FK9A53C1073C3907C4 FOREIGN KEY (FIELD_ID) REFERENCES BLC_FIELD (FIELD_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_CUSTOMER_CUSTOMER_SEG_XREF ADD CONSTRAINT FKB829E2CB7470F437 FOREIGN KEY (CUSTOMER_ID) REFERENCES BLC_CUSTOMER (CUSTOMER_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_CUSTOMER_CUSTOMER_SEG_XREF ADD CONSTRAINT FKB829E2CBB8718EEC FOREIGN KEY (CUSTOMER_SEGMENT_ID) REFERENCES BLC_CUSTOMER_SEGMENT (CUSTOMER_SEGMENT_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_PRODUCT_PRODUCT_GROUP_XREF ADD CONSTRAINT FKC65750A15F11A0B7 FOREIGN KEY (PRODUCT_ID) REFERENCES BLC_PRODUCT (PRODUCT_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_PRODUCT_PRODUCT_GROUP_XREF ADD CONSTRAINT FKC65750A1FBF5D076 FOREIGN KEY (PRODUCT_GROUP_ID) REFERENCES BLC_PRODUCT_GROUP (PRODUCT_GROUP_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_ASSET_FOLDER_ITEM_XREF ADD CONSTRAINT FKCEE6478B46294CB2 FOREIGN KEY (ASSET_ID) REFERENCES BLC_STATIC_ASSET (STATIC_ASSET_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_ASSET_FOLDER_ITEM_XREF ADD CONSTRAINT FKCEE6478B98CE5246 FOREIGN KEY (FOLDER_ID) REFERENCES BLC_ASSET_FOLDER (ASSET_FOLDER_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_OFFER_CUSTOMER_SEG_XREF ADD CONSTRAINT FKD280E9DDB8718EEC FOREIGN KEY (CUSTOMER_SEGMENT_ID) REFERENCES BLC_CUSTOMER_SEGMENT (CUSTOMER_SEGMENT_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_OFFER_CUSTOMER_SEG_XREF ADD CONSTRAINT FKD280E9DDD5F3FAF4 FOREIGN KEY (OFFER_ID) REFERENCES BLC_OFFER (OFFER_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_BOOST_RULE_GLOB ADD CONSTRAINT FKD74C3819BE3CE566 FOREIGN KEY (INDEX_FIELD_TYPE_ID) REFERENCES BLC_INDEX_FIELD_TYPE (INDEX_FIELD_TYPE_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_CONTENT_TGTR_CUST_SEG_XREF ADD CONSTRAINT FKE87D242FB8718EEC FOREIGN KEY (CUSTOMER_SEGMENT_ID) REFERENCES BLC_CUSTOMER_SEGMENT (CUSTOMER_SEGMENT_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_CONTENT_TGTR_CUST_SEG_XREF ADD CONSTRAINT FKE87D242FBECA250D FOREIGN KEY (CONTENT_TARGETER_ID) REFERENCES BLC_CONTENT_TARGETER (CONTENT_TARGETER_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE BLC_OFFER_DEP_FLD ADD CONSTRAINT FKEE1F406599291672 FOREIGN KEY (OFFER_TEMPLATE_ID) REFERENCES BLC_OFFER_TEMPLATE (OFFER_TEMPLATE_ID) ON UPDATE NO ACTION ON DELETE NO ACTION;