Documentation

Microsoft Create Script (Enterprise)

CREATE TABLE [BLC_ALLOWED_ENUM_VALUE] ([ALLOWED_ENUM_ID] [numeric](19, 0) NOT NULL, [ADMIN_DISPLAY_PRIORITY] [int], [VALUE] [varchar](255), [FIELD_ID] [numeric](19, 0))
GO

CREATE TABLE [BLC_ASSET_FOLDER] ([ASSET_FOLDER_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [NAME] [varchar](255) NOT NULL)
GO

CREATE TABLE [BLC_ASSET_FOLDER_ITEM_XREF] ([ASSET_FOLDER_ITEM_XREF_ID] [numeric](19, 0) NOT NULL, [ASSET_ID] [numeric](19, 0) NOT NULL, [FOLDER_ID] [numeric](19, 0) NOT NULL)
GO

CREATE TABLE [BLC_ASSET_FOLDER_XREF] ([ASSET_FOLDER_XREF_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [CHILD_FOLDER_ID] [numeric](19, 0) NOT NULL, [PARENT_FOLDER_ID] [numeric](19, 0) NOT NULL)
GO

CREATE TABLE [BLC_BOOST_RULE_CAT] ([BOOST_RULE_CAT_ID] [numeric](19, 0) NOT NULL, [ACTIVE_END_DATE] [datetime], [ACTIVE_START_DATE] [datetime], [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [BOOST] [numeric](19, 2), [DESCENDING] [bit], [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [MATCH_VALUE] [varchar](255), [MINIMUM_SCORE] [numeric](19, 2), [NAME] [varchar](255), [SEARCH_TERM_QUALIFIER_REGEX] [varchar](255), [TYPE] [varchar](255), [CATEGORY_ID] [numeric](19, 0) NOT NULL, [INDEX_FIELD_TYPE_ID] [numeric](19, 0) NOT NULL)
GO

CREATE TABLE [BLC_BOOST_RULE_GLOB] ([BOOST_RULE_GLOB_ID] [numeric](19, 0) NOT NULL, [ACTIVE_END_DATE] [datetime], [ACTIVE_START_DATE] [datetime], [APPLY_TO_CATEGORY] [bit], [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [BOOST] [numeric](19, 2), [DESCENDING] [bit], [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [MATCH_VALUE] [varchar](255), [MINIMUM_SCORE] [numeric](19, 2), [NAME] [varchar](255), [SEARCH_TERM_QUALIFIER_REGEX] [varchar](255), [TYPE] [varchar](255), [INDEX_FIELD_TYPE_ID] [numeric](19, 0))
GO

CREATE TABLE [BLC_CONTENT_TGTR_CUST_SEG_XREF] ([CONTENT_TGTR_CUST_SEG_XREF_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [CONTENT_TARGETER_ID] [numeric](19, 0) NOT NULL, [CUSTOMER_SEGMENT_ID] [numeric](19, 0) NOT NULL)
GO

CREATE TABLE [BLC_CUSTOMER_CUSTOMER_SEG_XREF] ([CUSTOMER_CUSTOMER_SEG_XREF_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [CUSTOMER_ID] [numeric](19, 0) NOT NULL, [CUSTOMER_SEGMENT_ID] [numeric](19, 0) NOT NULL)
GO

CREATE TABLE [BLC_CUSTOMER_SEGMENT] ([CUSTOMER_SEGMENT_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [MATCH_RULE] [varchar](MAX), [CUSTOMER_SEGMENT_NAME] [varchar](255), [CUSTOMER_SEGMENT_TYPE] [varchar](255))
GO

CREATE TABLE [BLC_INDEX_FIELD] ([INDEX_FIELD_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [SEARCHABLE] [bit], [FIELD_ID] [numeric](19, 0) NOT NULL)
GO

CREATE TABLE [BLC_INDEX_FIELD_TYPE] ([INDEX_FIELD_TYPE_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [FIELD_TYPE] [varchar](255), [INDEX_FIELD_ID] [numeric](19, 0) NOT NULL)
GO

CREATE TABLE [BLC_OFFER_CODE_RULE] ([OFFER_CODE_RULE_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [MATCH_RULE] [varchar](MAX))
GO

CREATE TABLE [BLC_OFFER_CODE_RULE_MAP] ([OFFER_CODE_OFFER_CODE_RULE_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [MAP_KEY] [varchar](255) NOT NULL, [BLC_OFFER_CODE_OFFER_CODE_ID] [numeric](19, 0) NOT NULL, [OFFER_CODE_RULE_ID] [numeric](19, 0), [offerCodeMatchRules_KEY] [varchar](255))
GO

CREATE TABLE [BLC_OFFER_CUSTOMER_SEG_XREF] ([OFFER_CUSTOMER_SEGMENT_XREF_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [CUSTOMER_SEGMENT_ID] [numeric](19, 0) NOT NULL, [OFFER_ID] [numeric](19, 0) NOT NULL)
GO

CREATE TABLE [BLC_OFFER_DEP_FLD] ([OFFER_DEP_FLD_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [FIELD] [varchar](255) NOT NULL, [FIELD_LABEL_OVERRIDE] [varchar](255), [FIELD_VALUE_OVERRIDE] [varchar](255), [IS_HIDDEN] [bit], [OFFER_TEMPLATE_ID] [numeric](19, 0))
GO

CREATE TABLE [BLC_OFFER_TEMPLATE] ([OFFER_TEMPLATE_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [NAME] [varchar](255) NOT NULL, [SEQUENCE] [numeric](10, 6))
GO

CREATE TABLE [BLC_PRICE_LIST_CUST_SEG_XREF] ([PRICE_LIST_CUST_SEG_XREF_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [CUSTOMER_SEGMENT_ID] [numeric](19, 0) NOT NULL, [PRICE_LIST_ID] [numeric](19, 0) NOT NULL)
GO

CREATE TABLE [BLC_PRODUCT_GROUP] ([PRODUCT_GROUP_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [MATCH_RULE] [varchar](MAX), [PRODUCT_GROUP_NAME] [varchar](255), [PRODUCT_GROUP_TYPE] [varchar](255))
GO

CREATE TABLE [BLC_PRODUCT_PRODUCT_GROUP_XREF] ([PRODUCT_PRODUCT_GROUP_XREF_ID] [numeric](19, 0) NOT NULL, [ARCHIVED] [char](1), [CREATED_BY] [numeric](19, 0), [DATE_CREATED] [datetime], [DATE_UPDATED] [datetime], [UPDATED_BY] [numeric](19, 0), [ADMIN_ADDITION_STATUS] [varchar](255), [SNDBX_CATALOG_FLAG] [numeric](19, 0), [SNDBX_ORIG_ITEM_ID] [numeric](19, 0), [SNDBX_ORIG_RECORD_ID] [numeric](19, 0), [SNDBX_ID] [numeric](19, 0), [SNDBX_ARCHIVED_FLAG] [char](1), [SNDBX_DELETED_FLAG] [char](1), [SNDBX_TMPLT_RECORD_ID] [numeric](19, 0), [SNDBX_TIER] [numeric](19, 0), [PRODUCT_ID] [numeric](19, 0) NOT NULL, [PRODUCT_GROUP_ID] [numeric](19, 0) NOT NULL)
GO

ALTER TABLE [BLC_CUSTOM_FIELD] ADD [ALLOW_MULTI_SELECT] [bit]
GO

ALTER TABLE [BLC_ADMIN_ROLE] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_COUNTRY] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_COUNTRY_SUB_CAT] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_CURRENCY] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_FULFILLMENT_LOCATION] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_LOCALE] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_ORDER_ITEM] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_SANDBOX_MGMT] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_CATALOG] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_COUNTRY_SUB] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_FIELD] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_ISO_COUNTRY] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_SANDBOX] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_SITE] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_CUSTOM_FIELD] ADD [CREATE_NEW_GROUP] [bit]
GO

ALTER TABLE [BLC_ADMIN_ROLE] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_COUNTRY] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_COUNTRY_SUB_CAT] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_CURRENCY] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_FULFILLMENT_LOCATION] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_LOCALE] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_ORDER_ITEM] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_SANDBOX_MGMT] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_CUSTOMER_PAYMENT] ADD [GATEWAY_TYPE] [varchar](255)
GO

ALTER TABLE [BLC_ADMIN_USER] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_SEARCH_INTERCEPT] ADD [CREATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_CATALOG] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_COUNTRY_SUB] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_FIELD] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_ISO_COUNTRY] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_SANDBOX] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_SITE] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_ADMIN_ROLE] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_COUNTRY] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_COUNTRY_SUB_CAT] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_CURRENCY] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_FULFILLMENT_LOCATION] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_LOCALE] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_ORDER_ITEM] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_SANDBOX_MGMT] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_ADMIN_USER] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_SEARCH_INTERCEPT] ADD [DATE_CREATED] [datetime]
GO

ALTER TABLE [BLC_CATALOG] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_COUNTRY_SUB] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_FIELD] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_ISO_COUNTRY] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_SANDBOX] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_SITE] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_CUSTOMER_PAYMENT] ADD [PAYMENT_TYPE] [varchar](255)
GO

ALTER TABLE [BLC_ADMIN_ROLE] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_COUNTRY] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_COUNTRY_SUB_CAT] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_CURRENCY] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_FULFILLMENT_LOCATION] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_LOCALE] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_ORDER_ITEM] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_SANDBOX_MGMT] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_SANDBOX_MGMT] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_ADMIN_USER] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_SEARCH_INTERCEPT] ADD [DATE_UPDATED] [datetime]
GO

ALTER TABLE [BLC_STORE] ADD [STORE_OPEN] [bit]
GO

ALTER TABLE [BLC_CATALOG] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_COUNTRY_SUB] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_FIELD] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_ISO_COUNTRY] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_SANDBOX] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_SITE] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_ADMIN_ROLE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CATALOG] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CATEGORY_ATTRIBUTE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CATEGORY_MEDIA_MAP] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CMS_MENU] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CNTNT_TRGT_ACTION_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CNTNT_TRGT_ITEM_CRIT] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CNTNT_TRGT_RULES] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CONTENT_TARGETING_ACTION] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CONTENT_TARGET_RULE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CONTENT_ZONE_DEF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CON_ZONE_DEF_WDGT_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_DATA_DRVN_ENUM] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_DYNAMIC_REGIONAL_FORM] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_DYN_REG_FORM_FIELD_CAT] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_FIELD] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_FLD_GROUP] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_FULFILLMENT_LOCATION] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_FULFILLMENT_OPTION] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_INTERNATIONAL_MSG] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_OFFER_CODE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_OFFER_ITEM_CRITERIA] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_OFFER_RULE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_OFFER_RULE_MAP] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_OVERRIDE_SC_FIELD] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PAGE_ATTRIBUTES] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PAGE_FLD] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PAGE_ITEM_CRITERIA] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PAGE_RULE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PAGE_TMPLT] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PAGE_TYPE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PAGE_TYPE_FLDDEF_MAP] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PGTMPLT_FLDGRP_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PL_CRITERIA_RULE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PL_RULE_MAP] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRICE_ADJUSTMENT] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRODUCT_ATTRIBUTE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRODUCT_CROSS_SALE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRODUCT_FEATURED] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRODUCT_OPTION_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRODUCT_UP_SALE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_QUAL_CRIT_OFFER_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SC_CONTENT_ITEM_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SC_FLD] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SC_FLD_MAP] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SC_ITEM_CRITERIA] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SC_RULE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SC_TYPE_WIDGET_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SEARCH_FACET_RANGE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SEARCH_FACET_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SKU_ATTRIBUTE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SKU_BNDL_ITM_PRC_DATA] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SKU_BUNDLE_ITEM] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SKU_MEDIA_MAP] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SKU_OPTION_VALUE_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SKU_PRICE_DATA_TIER] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SYSTEM_PROPERTY] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_TAR_CRIT_OFFER_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_THEME_FILE_PAGE_TYPE_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_THEME_FLD] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_THMDEF_FLDGRP_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_TRANSLATION] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_URL_HANDLER] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_ORDER_PAYMENT_TRANSACTION] ADD [SAVE_TOKEN] [bit]
GO

ALTER TABLE [BLC_STORE] ADD [STORE_HOURS] [varchar](255)
GO

ALTER TABLE [BLC_ADMIN_USER] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_SEARCH_INTERCEPT] ADD [UPDATED_BY] [numeric](19, 0)
GO

ALTER TABLE [BLC_CONTENT_ITEM] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CONTENT_ZONE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_DATA_DRVN_ENUM_VAL] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_DYN_REG_FORM_FIELD] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_MEDIA] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_OFFER_TIER] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_OVERRIDE_CONTENT_ITEM] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_OVERRIDE_SC_ITEM] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRICE_MODIFIER] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SC] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SC_TYPE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SEARCH_FACET] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SITE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_THEME_CONFIGURATION] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_THEME_DEFINITION] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_THEME_FILE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_STORE] ADD [STORE_NUMBER] [varchar](255)
GO

ALTER TABLE [BLC_STORE] ADD [ADDRESS_ID] [numeric](19, 0)
GO

ALTER TABLE [BLC_ADMIN_USER] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CATEGORY_PRODUCT_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CATEGORY_XREF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_FLD_DEF] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_FULFILLMENT_PRICE_BAND] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_FULFILLMENT_WEIGHT_BAND] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRODUCT] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRODUCT_OPTION] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRODUCT_OPTION_VALUE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SKU_FEE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SKU_PRICE_DATA] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_WIDGET] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRICE_LIST] ADD [CUST_QUALIFICATION_TYPE] [varchar](255)
GO

ALTER TABLE [BLC_SNDBX_WRKFLW_DEPLOY] ADD [NAME] [varchar](255)
GO

ALTER TABLE [BLC_CMS_MENU_ITEM] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CONTENT_TARGETER] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_MODULE_CONFIGURATION] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PAGE] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRICE_LIST] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_SKU] ADD [COST] [numeric](19, 5)
GO

ALTER TABLE [BLC_SNDBX_WRKFLW_EVENT] ADD [IS_CRITICAL] [bit]
GO

ALTER TABLE [BLC_SEARCH_FACET] ADD [NAME] [varchar](255)
GO

ALTER TABLE [BLC_FIELD] ADD [OVERRIDE_GENERATED_PROP_NAME] [bit]
GO

ALTER TABLE [BLC_SNDBX_WRKFLW_DEPLOY] ADD [RECURRENCE_TYPE] [varchar](255)
GO

ALTER TABLE [BLC_CATEGORY] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CUSTOM_FIELD] ADD [FIELD_ID] [numeric](19, 0)
GO

ALTER TABLE [BLC_OFFER] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_CUSTOMER] ADD [IS_TAX_EXEMPT] [bit]
GO

ALTER TABLE [BLC_SEARCH_FACET] ADD [USE_FACET_RANGES] [bit]
GO

ALTER TABLE [BLC_SEARCH_FACET] ADD [INDEX_FIELD_TYPE_ID] [numeric](19, 0)
GO

ALTER TABLE [BLC_DYN_REG_FORM_FIELD] ADD [FAILURE_MESSAGE] [varchar](255)
GO

ALTER TABLE [BLC_DYNAMIC_REGIONAL_FORM] ADD [FORM_NAME] [varchar](255)
GO

ALTER TABLE [BLC_FLD_GROUP] ADD [IS_MASTER_FIELD_GROUP] [bit]
GO

ALTER TABLE [BLC_SKU_BUNDLE_ITEM] ADD [SEQUENCE] [numeric](10, 6)
GO

ALTER TABLE [BLC_SYSTEM_PROPERTY] ADD [OVERRIDE_GENERATED_PROP_NAME] [bit]
GO

ALTER TABLE [BLC_SKU] ADD [ADMIN_ADDITION_STATUS] [varchar](255)
GO

ALTER TABLE [BLC_PRODUCT_OPTION] ADD [NAME] [varchar](255)
GO

ALTER TABLE [BLC_SNDBX_WRKFLW_ITEM] ADD [REJECTION_MESSAGE] [varchar](255)
GO

ALTER TABLE [BLC_SKU] ADD [KEYWORDS] [varchar](255)
GO

ALTER TABLE [BLC_OFFER] ADD [ORDER_MIN_TOTAL] [numeric](19, 5)
GO

ALTER TABLE [BLC_OFFER] ADD [OFFER_TEMPLATE_ID] [numeric](19, 0)
GO

CREATE NONCLUSTERED INDEX [CUSTOMERPAYMENT_TYPE_INDEX] ON [BLC_CUSTOMER_PAYMENT]([PAYMENT_TYPE])
GO

CREATE NONCLUSTERED INDEX [OFFER_TEMP_DEP_FLD_IDX] ON [BLC_OFFER_DEP_FLD]([OFFER_TEMPLATE_ID])
GO

CREATE NONCLUSTERED INDEX [OFFER_TEMP_OFFER_IDX] ON [BLC_OFFER]([OFFER_TEMPLATE_ID])
GO

CREATE NONCLUSTERED INDEX [PRODUCT_OPTION_NAME_INDEX] ON [BLC_PRODUCT_OPTION]([NAME])
GO

CREATE NONCLUSTERED INDEX [SEARCH_ACTIVE_INDEX] ON [BLC_BOOST_RULE_CAT]([ACTIVE_END_DATE])
GO

CREATE NONCLUSTERED INDEX [SEARCH_ACTIVE_INDEX] ON [BLC_BOOST_RULE_GLOB]([ACTIVE_END_DATE])
GO

CREATE NONCLUSTERED INDEX [idx_BLBORUCA_SNDBX_ID] ON [BLC_BOOST_RULE_CAT]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLBORUCA_SNDBX_TEM_ID] ON [BLC_BOOST_RULE_CAT]([SNDBX_ORIG_ITEM_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLBORUGL_SNDBX_ID] ON [BLC_BOOST_RULE_GLOB]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLBORUGL_SNDBX_TEM_ID] ON [BLC_BOOST_RULE_GLOB]([SNDBX_ORIG_ITEM_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLCOTGCUSEXR_SNDBX_ID] ON [BLC_CONTENT_TGTR_CUST_SEG_XREF]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLCOTGCUSEXR_SNDBX_TEM_ID] ON [BLC_CONTENT_TGTR_CUST_SEG_XREF]([SNDBX_ORIG_ITEM_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLCUCUSEXR_SNDBX_ID] ON [BLC_CUSTOMER_CUSTOMER_SEG_XREF]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLCUCUSEXR_SNDBX_TEM_ID] ON [BLC_CUSTOMER_CUSTOMER_SEG_XREF]([SNDBX_ORIG_ITEM_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLCUSE_SNDBX_ID] ON [BLC_CUSTOMER_SEGMENT]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLCUSE_SNDBX_TEM_ID] ON [BLC_CUSTOMER_SEGMENT]([SNDBX_ORIG_ITEM_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLOFCORUMA_SNDBX_ID] ON [BLC_OFFER_CODE_RULE_MAP]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLOFCORUMA_SNDBX_TEM_ID] ON [BLC_OFFER_CODE_RULE_MAP]([SNDBX_ORIG_ITEM_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLOFCORU_SNDBX_ID] ON [BLC_OFFER_CODE_RULE]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLOFCORU_SNDBX_TEM_ID] ON [BLC_OFFER_CODE_RULE]([SNDBX_ORIG_ITEM_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLOFCUSEXR_SNDBX_ID] ON [BLC_OFFER_CUSTOMER_SEG_XREF]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLOFCUSEXR_SNDBX_TEM_ID] ON [BLC_OFFER_CUSTOMER_SEG_XREF]([SNDBX_ORIG_ITEM_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLOFDEFL_SNDBX_ID] ON [BLC_OFFER_DEP_FLD]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLOFDEFL_SNDBX_TEM_ID] ON [BLC_OFFER_DEP_FLD]([SNDBX_ORIG_ITEM_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLOFTE_SNDBX_ID] ON [BLC_OFFER_TEMPLATE]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLOFTE_SNDBX_TEM_ID] ON [BLC_OFFER_TEMPLATE]([SNDBX_ORIG_ITEM_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLPRGR_SNDBX_ID] ON [BLC_PRODUCT_GROUP]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLPRGR_SNDBX_TEM_ID] ON [BLC_PRODUCT_GROUP]([SNDBX_ORIG_ITEM_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLPRLICUSEXR_SNDBX_ID] ON [BLC_PRICE_LIST_CUST_SEG_XREF]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLPRLICUSEXR_SNDBX_TEM_ID] ON [BLC_PRICE_LIST_CUST_SEG_XREF]([SNDBX_ORIG_ITEM_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLPRPRGRXR_SNDBX_ID] ON [BLC_PRODUCT_PRODUCT_GROUP_XREF]([SNDBX_ID])
GO

CREATE NONCLUSTERED INDEX [idx_BLPRPRGRXR_SNDBX_TEM_ID] ON [BLC_PRODUCT_PRODUCT_GROUP_XREF]([SNDBX_ORIG_ITEM_ID])
GO