Documentation

MySQL Creation Script (Enterprise)

CREATE TABLE BLC_ALLOWED_ENUM_VALUE (ALLOWED_ENUM_ID BIGINT NOT NULL, ADMIN_DISPLAY_PRIORITY INT NULL, VALUE VARCHAR(255) NULL, FIELD_ID BIGINT NULL);
CREATE TABLE BLC_ASSET_FOLDER (ASSET_FOLDER_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, NAME VARCHAR(255) NOT NULL);
CREATE TABLE BLC_ASSET_FOLDER_ITEM_XREF (ASSET_FOLDER_ITEM_XREF_ID BIGINT NOT NULL, ASSET_ID BIGINT NOT NULL, FOLDER_ID BIGINT NOT NULL);
CREATE TABLE BLC_ASSET_FOLDER_XREF (ASSET_FOLDER_XREF_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, CHILD_FOLDER_ID BIGINT NOT NULL, PARENT_FOLDER_ID BIGINT NOT NULL);
CREATE TABLE BLC_BOOST_RULE_CAT (BOOST_RULE_CAT_ID BIGINT NOT NULL, ACTIVE_END_DATE DATETIME NULL, ACTIVE_START_DATE DATETIME NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, BOOST DECIMAL(19, 2) NULL, DESCENDING TINYINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, MATCH_VALUE VARCHAR(255) NULL, MINIMUM_SCORE DECIMAL(19, 2) NULL, NAME VARCHAR(255) NULL, SEARCH_TERM_QUALIFIER_REGEX VARCHAR(255) NULL, TYPE VARCHAR(255) NULL, CATEGORY_ID BIGINT NOT NULL, INDEX_FIELD_TYPE_ID BIGINT NOT NULL);
CREATE TABLE BLC_BOOST_RULE_GLOB (BOOST_RULE_GLOB_ID BIGINT NOT NULL, ACTIVE_END_DATE DATETIME NULL, ACTIVE_START_DATE DATETIME NULL, APPLY_TO_CATEGORY TINYINT NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, BOOST DECIMAL(19, 2) NULL, DESCENDING TINYINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, MATCH_VALUE VARCHAR(255) NULL, MINIMUM_SCORE DECIMAL(19, 2) NULL, NAME VARCHAR(255) NULL, SEARCH_TERM_QUALIFIER_REGEX VARCHAR(255) NULL, TYPE VARCHAR(255) NULL, INDEX_FIELD_TYPE_ID BIGINT NULL);
CREATE TABLE BLC_CONTENT_TGTR_CUST_SEG_XREF (CONTENT_TGTR_CUST_SEG_XREF_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, CONTENT_TARGETER_ID BIGINT NOT NULL, CUSTOMER_SEGMENT_ID BIGINT NOT NULL);
CREATE TABLE BLC_CUSTOMER_CUSTOMER_SEG_XREF (CUSTOMER_CUSTOMER_SEG_XREF_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, CUSTOMER_ID BIGINT NOT NULL, CUSTOMER_SEGMENT_ID BIGINT NOT NULL);
CREATE TABLE BLC_CUSTOMER_SEGMENT (CUSTOMER_SEGMENT_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, MATCH_RULE LONGTEXT NULL, CUSTOMER_SEGMENT_NAME VARCHAR(255) NULL, CUSTOMER_SEGMENT_TYPE VARCHAR(255) NULL);
CREATE TABLE BLC_INDEX_FIELD (INDEX_FIELD_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, SEARCHABLE TINYINT NULL, FIELD_ID BIGINT NOT NULL);
CREATE TABLE BLC_INDEX_FIELD_TYPE (INDEX_FIELD_TYPE_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, FIELD_TYPE VARCHAR(255) NULL, INDEX_FIELD_ID BIGINT NOT NULL);
CREATE TABLE BLC_OFFER_CODE_RULE (OFFER_CODE_RULE_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, MATCH_RULE LONGTEXT NULL);
CREATE TABLE BLC_OFFER_CODE_RULE_MAP (OFFER_CODE_OFFER_CODE_RULE_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, MAP_KEY VARCHAR(255) NOT NULL, BLC_OFFER_CODE_OFFER_CODE_ID BIGINT NOT NULL, OFFER_CODE_RULE_ID BIGINT NULL, offerCodeMatchRules_KEY VARCHAR(255) NULL);
CREATE TABLE BLC_OFFER_CUSTOMER_SEG_XREF (OFFER_CUSTOMER_SEGMENT_XREF_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, CUSTOMER_SEGMENT_ID BIGINT NOT NULL, OFFER_ID BIGINT NOT NULL);
CREATE TABLE BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, FIELD VARCHAR(255) NOT NULL, FIELD_LABEL_OVERRIDE VARCHAR(255) NULL, FIELD_VALUE_OVERRIDE VARCHAR(255) NULL, IS_HIDDEN TINYINT NULL, OFFER_TEMPLATE_ID BIGINT NULL);
CREATE TABLE BLC_OFFER_TEMPLATE (OFFER_TEMPLATE_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, NAME VARCHAR(255) NOT NULL, SEQUENCE DECIMAL(10, 6) NULL);
CREATE TABLE BLC_PRICE_LIST_CUST_SEG_XREF (PRICE_LIST_CUST_SEG_XREF_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, CUSTOMER_SEGMENT_ID BIGINT NOT NULL, PRICE_LIST_ID BIGINT NOT NULL);
CREATE TABLE BLC_PRODUCT_GROUP (PRODUCT_GROUP_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, MATCH_RULE LONGTEXT NULL, PRODUCT_GROUP_NAME VARCHAR(255) NULL, PRODUCT_GROUP_TYPE VARCHAR(255) NULL);
CREATE TABLE BLC_PRODUCT_PRODUCT_GROUP_XREF (PRODUCT_PRODUCT_GROUP_XREF_ID BIGINT NOT NULL, ARCHIVED CHAR(1) NULL, CREATED_BY BIGINT NULL, DATE_CREATED DATETIME NULL, DATE_UPDATED DATETIME NULL, UPDATED_BY BIGINT NULL, ADMIN_ADDITION_STATUS VARCHAR(255) NULL, SNDBX_CATALOG_FLAG BIGINT NULL, SNDBX_ORIG_ITEM_ID BIGINT NULL, SNDBX_ORIG_RECORD_ID BIGINT NULL, SNDBX_ID BIGINT NULL, SNDBX_ARCHIVED_FLAG CHAR(1) NULL, SNDBX_DELETED_FLAG CHAR(1) NULL, SNDBX_TMPLT_RECORD_ID BIGINT NULL, SNDBX_TIER BIGINT NULL, PRODUCT_ID BIGINT NOT NULL, PRODUCT_GROUP_ID BIGINT NOT NULL);
ALTER TABLE BLC_CUSTOM_FIELD ADD ALLOW_MULTI_SELECT TINYINT NULL;
ALTER TABLE BLC_ADMIN_ROLE ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_COUNTRY ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_COUNTRY_SUB_CAT ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_CURRENCY ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_FULFILLMENT_LOCATION ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_LOCALE ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_ORDER_ITEM ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_SANDBOX_MGMT ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_CATALOG ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_COUNTRY_SUB ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_FIELD ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_ISO_COUNTRY ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_SANDBOX ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_SITE ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_CUSTOM_FIELD ADD CREATE_NEW_GROUP TINYINT NULL;
ALTER TABLE BLC_ADMIN_ROLE ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_COUNTRY ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_COUNTRY_SUB_CAT ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_CURRENCY ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_FULFILLMENT_LOCATION ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_LOCALE ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_ORDER_ITEM ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_SANDBOX_MGMT ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_CUSTOMER_PAYMENT ADD GATEWAY_TYPE VARCHAR(255) NULL;
ALTER TABLE BLC_ADMIN_USER ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_SEARCH_INTERCEPT ADD CREATED_BY BIGINT NULL;
ALTER TABLE BLC_CATALOG ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_COUNTRY_SUB ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_FIELD ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_ISO_COUNTRY ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_SANDBOX ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_SITE ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_ADMIN_ROLE ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_COUNTRY ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_COUNTRY_SUB_CAT ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_CURRENCY ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_FULFILLMENT_LOCATION ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_LOCALE ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_ORDER_ITEM ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_SANDBOX_MGMT ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_ADMIN_USER ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_SEARCH_INTERCEPT ADD DATE_CREATED DATETIME NULL;
ALTER TABLE BLC_CATALOG ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_COUNTRY_SUB ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_FIELD ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_ISO_COUNTRY ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_SANDBOX ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_SITE ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_CUSTOMER_PAYMENT ADD PAYMENT_TYPE VARCHAR(255) NULL;
ALTER TABLE BLC_ADMIN_ROLE ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_COUNTRY ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_COUNTRY_SUB_CAT ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_CURRENCY ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_FULFILLMENT_LOCATION ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_LOCALE ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_ORDER_ITEM ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_SANDBOX_MGMT ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_SANDBOX_MGMT ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_ADMIN_USER ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_SEARCH_INTERCEPT ADD DATE_UPDATED DATETIME NULL;
ALTER TABLE BLC_STORE ADD OPEN TINYINT NULL;
ALTER TABLE BLC_CATALOG ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_COUNTRY_SUB ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_FIELD ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_ISO_COUNTRY ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_SANDBOX ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_SITE ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_ADMIN_ROLE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CATALOG ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CATEGORY_ATTRIBUTE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CATEGORY_MEDIA_MAP ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CAT_SEARCH_FACET_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CMS_MENU ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CNTNT_TRGT_ACTION_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CNTNT_TRGT_ITEM_CRIT ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CNTNT_TRGT_RULES ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CONTENT_TARGETING_ACTION ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CONTENT_TARGET_RULE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CONTENT_ZONE_DEF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CON_ZONE_DEF_WDGT_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_DATA_DRVN_ENUM ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_DYNAMIC_REGIONAL_FORM ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_DYN_REG_FORM_FIELD_CAT ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_FIELD ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_FLD_GROUP ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_FULFILLMENT_LOCATION ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_FULFILLMENT_OPTION ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_INTERNATIONAL_MSG ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_OFFER_CODE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_OFFER_ITEM_CRITERIA ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_OFFER_RULE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_OFFER_RULE_MAP ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_OVERRIDE_SC_FIELD ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PAGE_ATTRIBUTES ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PAGE_FLD ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PAGE_ITEM_CRITERIA ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PAGE_RULE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PAGE_TMPLT ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PAGE_TYPE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PAGE_TYPE_FLDDEF_MAP ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PGTMPLT_FLDGRP_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PL_CRITERIA_RULE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PL_RULE_MAP ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRICE_ADJUSTMENT ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRODUCT_ATTRIBUTE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRODUCT_CROSS_SALE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRODUCT_FEATURED ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRODUCT_OPTION_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRODUCT_UP_SALE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_QUAL_CRIT_OFFER_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SC_CONTENT_ITEM_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SC_FLD ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SC_FLD_MAP ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SC_ITEM_CRITERIA ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SC_RULE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SC_TYPE_WIDGET_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SEARCH_FACET_RANGE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SEARCH_FACET_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SKU_ATTRIBUTE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SKU_BNDL_ITM_PRC_DATA ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SKU_BUNDLE_ITEM ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SKU_MEDIA_MAP ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SKU_OPTION_VALUE_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SKU_PRICE_DATA_TIER ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SYSTEM_PROPERTY ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_TAR_CRIT_OFFER_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_THEME_FILE_PAGE_TYPE_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_THEME_FLD ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_THMDEF_FLDGRP_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_TRANSLATION ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_URL_HANDLER ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_ORDER_PAYMENT_TRANSACTION ADD SAVE_TOKEN TINYINT NULL;
ALTER TABLE BLC_STORE ADD STORE_HOURS VARCHAR(255) NULL;
ALTER TABLE BLC_ADMIN_USER ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_SEARCH_INTERCEPT ADD UPDATED_BY BIGINT NULL;
ALTER TABLE BLC_CONTENT_ITEM ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CONTENT_ZONE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_DATA_DRVN_ENUM_VAL ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_DYN_REG_FORM_FIELD ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_MEDIA ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_OFFER_TIER ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_OVERRIDE_CONTENT_ITEM ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_OVERRIDE_SC_ITEM ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRICE_MODIFIER ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SC ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SC_TYPE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SEARCH_FACET ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SITE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_THEME_CONFIGURATION ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_THEME_DEFINITION ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_THEME_FILE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_STORE ADD STORE_NUMBER VARCHAR(255) NULL;
ALTER TABLE BLC_STORE ADD ADDRESS_ID BIGINT NULL;
ALTER TABLE BLC_ADMIN_USER ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CATEGORY_PRODUCT_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CATEGORY_XREF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_FLD_DEF ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_FULFILLMENT_PRICE_BAND ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_FULFILLMENT_WEIGHT_BAND ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRODUCT ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRODUCT_OPTION ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRODUCT_OPTION_VALUE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SKU_FEE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SKU_PRICE_DATA ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_WIDGET ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRICE_LIST ADD CUST_QUALIFICATION_TYPE VARCHAR(255) NULL;
ALTER TABLE BLC_SNDBX_WRKFLW_DEPLOY ADD NAME VARCHAR(255) NULL;
ALTER TABLE BLC_CMS_MENU_ITEM ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CONTENT_TARGETER ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_MODULE_CONFIGURATION ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PAGE ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRICE_LIST ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_SKU ADD COST DECIMAL(19, 5) NULL;
ALTER TABLE BLC_SNDBX_WRKFLW_EVENT ADD IS_CRITICAL TINYINT NULL;
ALTER TABLE BLC_SEARCH_FACET ADD NAME VARCHAR(255) NULL;
ALTER TABLE BLC_FIELD ADD OVERRIDE_GENERATED_PROP_NAME TINYINT NULL;
ALTER TABLE BLC_SNDBX_WRKFLW_DEPLOY ADD RECURRENCE_TYPE VARCHAR(255) NULL;
ALTER TABLE BLC_CATEGORY ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CUSTOM_FIELD ADD FIELD_ID BIGINT NOT NULL;
ALTER TABLE BLC_OFFER ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CUSTOMER ADD IS_TAX_EXEMPT TINYINT NULL;
ALTER TABLE BLC_SEARCH_FACET ADD USE_FACET_RANGES TINYINT NULL;
ALTER TABLE BLC_SEARCH_FACET ADD INDEX_FIELD_TYPE_ID BIGINT NULL;
ALTER TABLE BLC_DYN_REG_FORM_FIELD ADD FAILURE_MESSAGE VARCHAR(255) NULL;
ALTER TABLE BLC_DYNAMIC_REGIONAL_FORM ADD FORM_NAME VARCHAR(255) NULL;
ALTER TABLE BLC_FLD_GROUP ADD IS_MASTER_FIELD_GROUP TINYINT NULL;
ALTER TABLE BLC_SKU_BUNDLE_ITEM ADD SEQUENCE DECIMAL(10, 6) NULL;
ALTER TABLE BLC_SYSTEM_PROPERTY ADD OVERRIDE_GENERATED_PROP_NAME TINYINT NULL;
ALTER TABLE BLC_SKU ADD ADMIN_ADDITION_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_PRODUCT_OPTION ADD NAME VARCHAR(255) NULL;
ALTER TABLE BLC_SNDBX_WRKFLW_ITEM ADD REJECTION_MESSAGE VARCHAR(255) NULL;
ALTER TABLE BLC_SKU ADD KEYWORDS VARCHAR(255) NULL;
ALTER TABLE BLC_OFFER ADD ORDER_MIN_TOTAL DECIMAL(19, 5) NULL;
ALTER TABLE BLC_OFFER ADD OFFER_TEMPLATE_ID BIGINT NULL;
ALTER TABLE BLC_ALLOWED_ENUM_VALUE ADD PRIMARY KEY (ALLOWED_ENUM_ID);
ALTER TABLE BLC_ASSET_FOLDER ADD PRIMARY KEY (ASSET_FOLDER_ID);
ALTER TABLE BLC_ASSET_FOLDER_ITEM_XREF ADD PRIMARY KEY (ASSET_FOLDER_ITEM_XREF_ID);
ALTER TABLE BLC_ASSET_FOLDER_XREF ADD PRIMARY KEY (ASSET_FOLDER_XREF_ID);
ALTER TABLE BLC_BOOST_RULE_CAT ADD PRIMARY KEY (BOOST_RULE_CAT_ID);
ALTER TABLE BLC_BOOST_RULE_GLOB ADD PRIMARY KEY (BOOST_RULE_GLOB_ID);
ALTER TABLE BLC_CONTENT_TGTR_CUST_SEG_XREF ADD PRIMARY KEY (CONTENT_TGTR_CUST_SEG_XREF_ID);
ALTER TABLE BLC_CUSTOMER_CUSTOMER_SEG_XREF ADD PRIMARY KEY (CUSTOMER_CUSTOMER_SEG_XREF_ID);
ALTER TABLE BLC_CUSTOMER_SEGMENT ADD PRIMARY KEY (CUSTOMER_SEGMENT_ID);
ALTER TABLE BLC_INDEX_FIELD ADD PRIMARY KEY (INDEX_FIELD_ID);
ALTER TABLE BLC_INDEX_FIELD_TYPE ADD PRIMARY KEY (INDEX_FIELD_TYPE_ID);
ALTER TABLE BLC_OFFER_CODE_RULE ADD PRIMARY KEY (OFFER_CODE_RULE_ID);
ALTER TABLE BLC_OFFER_CODE_RULE_MAP ADD PRIMARY KEY (OFFER_CODE_OFFER_CODE_RULE_ID);
ALTER TABLE BLC_OFFER_CUSTOMER_SEG_XREF ADD PRIMARY KEY (OFFER_CUSTOMER_SEGMENT_XREF_ID);
ALTER TABLE BLC_OFFER_DEP_FLD ADD PRIMARY KEY (OFFER_DEP_FLD_ID);
ALTER TABLE BLC_OFFER_TEMPLATE ADD PRIMARY KEY (OFFER_TEMPLATE_ID);
ALTER TABLE BLC_PRICE_LIST_CUST_SEG_XREF ADD PRIMARY KEY (PRICE_LIST_CUST_SEG_XREF_ID);
ALTER TABLE BLC_PRODUCT_GROUP ADD PRIMARY KEY (PRODUCT_GROUP_ID);
ALTER TABLE BLC_PRODUCT_PRODUCT_GROUP_XREF ADD PRIMARY KEY (PRODUCT_PRODUCT_GROUP_XREF_ID);
CREATE INDEX CUSTOMERPAYMENT_TYPE_INDEX ON BLC_CUSTOMER_PAYMENT(PAYMENT_TYPE);
CREATE INDEX FK102A01D7706F08F1 ON BLC_ASSET_FOLDER_XREF(PARENT_FOLDER_ID);
CREATE INDEX FK102A01D7FE088EE3 ON BLC_ASSET_FOLDER_XREF(CHILD_FOLDER_ID);
CREATE INDEX FK3902F48C2EF95B6A ON BLC_PRICE_LIST_CUST_SEG_XREF(PRICE_LIST_ID);
CREATE INDEX FK3902F48CB8718EEC ON BLC_PRICE_LIST_CUST_SEG_XREF(CUSTOMER_SEGMENT_ID);
CREATE INDEX FK4A310B72CBDA280B ON BLC_INDEX_FIELD_TYPE(INDEX_FIELD_ID);
CREATE INDEX FK4FFCC986BE3CE566 ON BLC_SEARCH_FACET(INDEX_FIELD_TYPE_ID);
CREATE INDEX FK5552E87062A47BC4 ON BLC_ALLOWED_ENUM_VALUE(FIELD_ID);
CREATE INDEX FK6F1E0F515D1A13D ON BLC_BOOST_RULE_CAT(CATEGORY_ID);
CREATE INDEX FK6F1E0F5BE3CE566 ON BLC_BOOST_RULE_CAT(INDEX_FIELD_TYPE_ID);
CREATE INDEX FK8F94D63BC13085DD ON BLC_STORE(ADDRESS_ID);
CREATE INDEX FK8FAD02C2446C7306 ON BLC_OFFER_CODE_RULE_MAP(OFFER_CODE_RULE_ID);
CREATE INDEX FK8FAD02C29D28BF84 ON BLC_OFFER_CODE_RULE_MAP(BLC_OFFER_CODE_OFFER_CODE_ID);
CREATE INDEX FK9A53C1073C3907C4 ON BLC_INDEX_FIELD(FIELD_ID);
CREATE INDEX FKB829E2CB7470F437 ON BLC_CUSTOMER_CUSTOMER_SEG_XREF(CUSTOMER_ID);
CREATE INDEX FKB829E2CBB8718EEC ON BLC_CUSTOMER_CUSTOMER_SEG_XREF(CUSTOMER_SEGMENT_ID);
CREATE INDEX FKC65750A15F11A0B7 ON BLC_PRODUCT_PRODUCT_GROUP_XREF(PRODUCT_ID);
CREATE INDEX FKC65750A1FBF5D076 ON BLC_PRODUCT_PRODUCT_GROUP_XREF(PRODUCT_GROUP_ID);
CREATE INDEX FKCEE6478B46294CB2 ON BLC_ASSET_FOLDER_ITEM_XREF(ASSET_ID);
CREATE INDEX FKCEE6478B98CE5246 ON BLC_ASSET_FOLDER_ITEM_XREF(FOLDER_ID);
CREATE INDEX FKD280E9DDB8718EEC ON BLC_OFFER_CUSTOMER_SEG_XREF(CUSTOMER_SEGMENT_ID);
CREATE INDEX FKD280E9DDD5F3FAF4 ON BLC_OFFER_CUSTOMER_SEG_XREF(OFFER_ID);
CREATE INDEX FKD74C3819BE3CE566 ON BLC_BOOST_RULE_GLOB(INDEX_FIELD_TYPE_ID);
CREATE INDEX FKE87D242FB8718EEC ON BLC_CONTENT_TGTR_CUST_SEG_XREF(CUSTOMER_SEGMENT_ID);
CREATE INDEX FKE87D242FBECA250D ON BLC_CONTENT_TGTR_CUST_SEG_XREF(CONTENT_TARGETER_ID);
CREATE INDEX FKEE1F406599291672 ON BLC_OFFER_DEP_FLD(OFFER_TEMPLATE_ID);
CREATE INDEX OFFER_TEMP_OFFER_IDX ON BLC_OFFER(OFFER_TEMPLATE_ID);
CREATE INDEX PRODUCT_OPTION_NAME_INDEX ON BLC_PRODUCT_OPTION(NAME);
CREATE INDEX SEARCH_ACTIVE_INDEX ON BLC_BOOST_RULE_CAT(ACTIVE_END_DATE);
CREATE INDEX SEARCH_ACTIVE_INDEX ON BLC_BOOST_RULE_GLOB(ACTIVE_END_DATE);
CREATE INDEX idx_BLBORUCA_SNDBX_ID ON BLC_BOOST_RULE_CAT(SNDBX_ID);
CREATE INDEX idx_BLBORUCA_SNDBX_TEM_ID ON BLC_BOOST_RULE_CAT(SNDBX_ORIG_ITEM_ID);
CREATE INDEX idx_BLBORUGL_SNDBX_ID ON BLC_BOOST_RULE_GLOB(SNDBX_ID);
CREATE INDEX idx_BLBORUGL_SNDBX_TEM_ID ON BLC_BOOST_RULE_GLOB(SNDBX_ORIG_ITEM_ID);
CREATE INDEX idx_BLCOTGCUSEXR_SNDBX_ID ON BLC_CONTENT_TGTR_CUST_SEG_XREF(SNDBX_ID);
CREATE INDEX idx_BLCOTGCUSEXR_SNDBX_TEM_ID ON BLC_CONTENT_TGTR_CUST_SEG_XREF(SNDBX_ORIG_ITEM_ID);
CREATE INDEX idx_BLCUCUSEXR_SNDBX_ID ON BLC_CUSTOMER_CUSTOMER_SEG_XREF(SNDBX_ID);
CREATE INDEX idx_BLCUCUSEXR_SNDBX_TEM_ID ON BLC_CUSTOMER_CUSTOMER_SEG_XREF(SNDBX_ORIG_ITEM_ID);
CREATE INDEX idx_BLCUSE_SNDBX_ID ON BLC_CUSTOMER_SEGMENT(SNDBX_ID);
CREATE INDEX idx_BLCUSE_SNDBX_TEM_ID ON BLC_CUSTOMER_SEGMENT(SNDBX_ORIG_ITEM_ID);
CREATE INDEX idx_BLOFCORUMA_SNDBX_ID ON BLC_OFFER_CODE_RULE_MAP(SNDBX_ID);
CREATE INDEX idx_BLOFCORUMA_SNDBX_TEM_ID ON BLC_OFFER_CODE_RULE_MAP(SNDBX_ORIG_ITEM_ID);
CREATE INDEX idx_BLOFCORU_SNDBX_ID ON BLC_OFFER_CODE_RULE(SNDBX_ID);
CREATE INDEX idx_BLOFCORU_SNDBX_TEM_ID ON BLC_OFFER_CODE_RULE(SNDBX_ORIG_ITEM_ID);
CREATE INDEX idx_BLOFCUSEXR_SNDBX_ID ON BLC_OFFER_CUSTOMER_SEG_XREF(SNDBX_ID);
CREATE INDEX idx_BLOFCUSEXR_SNDBX_TEM_ID ON BLC_OFFER_CUSTOMER_SEG_XREF(SNDBX_ORIG_ITEM_ID);
CREATE INDEX idx_BLOFDEFL_SNDBX_ID ON BLC_OFFER_DEP_FLD(SNDBX_ID);
CREATE INDEX idx_BLOFDEFL_SNDBX_TEM_ID ON BLC_OFFER_DEP_FLD(SNDBX_ORIG_ITEM_ID);
CREATE INDEX idx_BLOFTE_SNDBX_ID ON BLC_OFFER_TEMPLATE(SNDBX_ID);
CREATE INDEX idx_BLOFTE_SNDBX_TEM_ID ON BLC_OFFER_TEMPLATE(SNDBX_ORIG_ITEM_ID);
CREATE INDEX idx_BLPRGR_SNDBX_ID ON BLC_PRODUCT_GROUP(SNDBX_ID);
CREATE INDEX idx_BLPRGR_SNDBX_TEM_ID ON BLC_PRODUCT_GROUP(SNDBX_ORIG_ITEM_ID);
CREATE INDEX idx_BLPRLICUSEXR_SNDBX_ID ON BLC_PRICE_LIST_CUST_SEG_XREF(SNDBX_ID);
CREATE INDEX idx_BLPRLICUSEXR_SNDBX_TEM_ID ON BLC_PRICE_LIST_CUST_SEG_XREF(SNDBX_ORIG_ITEM_ID);
CREATE INDEX idx_BLPRPRGRXR_SNDBX_ID ON BLC_PRODUCT_PRODUCT_GROUP_XREF(SNDBX_ID);
CREATE INDEX idx_BLPRPRGRXR_SNDBX_TEM_ID ON BLC_PRODUCT_PRODUCT_GROUP_XREF(SNDBX_ORIG_ITEM_ID);

MySQL Creation Script (Enterprise with MultiTenant)

ALTER TABLE BLC_FIELD ADD SITE_DISC BIGINT NULL;
ALTER TABLE BLC_CUSTOMER_SEGMENT ADD SITE_DISC BIGINT NULL;
ALTER TABLE BLC_CUSTOMER_CUSTOMER_SEG_XREF ADD SITE_DISC BIGINT NULL;
ALTER TABLE BLC_OFFER_CUSTOMER_SEG_XREF ADD SITE_DISC BIGINT NULL;
ALTER TABLE BLC_PRICE_LIST_CUST_SEG_XREF ADD SITE_DISC BIGINT NULL;
ALTER TABLE BLC_PRODUCT_GROUP ADD SITE_DISC BIGINT NULL;
ALTER TABLE BLC_ASSET_FOLDER ADD SITE_DISC BIGINT NULL;
UPDATE BLC_ASSET_FOLDER SET SITE_DISC = -1 WHERE NAME = 'blcRootFolder';
ALTER TABLE BLC_ASSET_FOLDER_ITEM_XREF ADD SITE_DISC BIGINT NULL;
ALTER TABLE BLC_ASSET_FOLDER_XREF ADD SITE_DISC BIGINT NULL;
ALTER TABLE BLC_INDEX_FIELD ADD CATALOG_DISC BIGINT NULL;
ALTER TABLE BLC_OFFER_TEMPLATE ADD CATALOG_DISC BIGINT NULL;
ALTER TABLE BLC_INDEX_FIELD_TYPE ADD CATALOG_DISC BIGINT NULL;
ALTER TABLE BLC_SITE ADD CONFIG_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_CATALOG ADD CONFIG_STATUS VARCHAR(255) NULL;
ALTER TABLE BLC_OFFER_DEP_FLD ADD CATALOG_DISC BIGINT NULL;