Documentation

Microsoft SQL Server Creation Changelog (Enterprise)

<?xml version="1.1" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd">
    <changeSet author="dcolgrove (generated)" id="1473916736196-1" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_ALLOWED_ENUM_VALUE">
            <column name="ALLOWED_ENUM_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ADMIN_DISPLAY_PRIORITY" type="int"/>
            <column name="VALUE" type="varchar(255)"/>
            <column name="FIELD_ID" type="numeric(19, 0)"/>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-2" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_ASSET_FOLDER">
            <column name="ASSET_FOLDER_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="NAME" type="varchar(255)">
                <constraints nullable="false"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-3" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_ASSET_FOLDER_ITEM_XREF">
            <column name="ASSET_FOLDER_ITEM_XREF_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ASSET_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="FOLDER_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-4" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_ASSET_FOLDER_XREF">
            <column name="ASSET_FOLDER_XREF_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CHILD_FOLDER_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="PARENT_FOLDER_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-5" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_BOOST_RULE_CAT">
            <column name="BOOST_RULE_CAT_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ACTIVE_END_DATE" type="datetime"/>
            <column name="ACTIVE_START_DATE" type="datetime"/>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="BOOST" type="numeric(19, 2)"/>
            <column name="DESCENDING" type="bit"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="MATCH_VALUE" type="varchar(255)"/>
            <column name="MINIMUM_SCORE" type="numeric(19, 2)"/>
            <column name="NAME" type="varchar(255)"/>
            <column name="SEARCH_TERM_QUALIFIER_REGEX" type="varchar(255)"/>
            <column name="TYPE" type="varchar(255)"/>
            <column name="CATEGORY_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="INDEX_FIELD_TYPE_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-6" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_BOOST_RULE_GLOB">
            <column name="BOOST_RULE_GLOB_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ACTIVE_END_DATE" type="datetime"/>
            <column name="ACTIVE_START_DATE" type="datetime"/>
            <column name="APPLY_TO_CATEGORY" type="bit"/>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="BOOST" type="numeric(19, 2)"/>
            <column name="DESCENDING" type="bit"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="MATCH_VALUE" type="varchar(255)"/>
            <column name="MINIMUM_SCORE" type="numeric(19, 2)"/>
            <column name="NAME" type="varchar(255)"/>
            <column name="SEARCH_TERM_QUALIFIER_REGEX" type="varchar(255)"/>
            <column name="TYPE" type="varchar(255)"/>
            <column name="INDEX_FIELD_TYPE_ID" type="numeric(19, 0)"/>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-7" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_CONTENT_TGTR_CUST_SEG_XREF">
            <column name="CONTENT_TGTR_CUST_SEG_XREF_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="CONTENT_TARGETER_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="CUSTOMER_SEGMENT_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-8" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_CUSTOMER_CUSTOMER_SEG_XREF">
            <column name="CUSTOMER_CUSTOMER_SEG_XREF_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="CUSTOMER_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="CUSTOMER_SEGMENT_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-9" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_CUSTOMER_SEGMENT">
            <column name="CUSTOMER_SEGMENT_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="MATCH_RULE" type="varchar(MAX)"/>
            <column name="CUSTOMER_SEGMENT_NAME" type="varchar(255)"/>
            <column name="CUSTOMER_SEGMENT_TYPE" type="varchar(255)"/>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-10" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_INDEX_FIELD">
            <column name="INDEX_FIELD_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="SEARCHABLE" type="bit"/>
            <column name="FIELD_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-11" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_INDEX_FIELD_TYPE">
            <column name="INDEX_FIELD_TYPE_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="FIELD_TYPE" type="varchar(255)"/>
            <column name="INDEX_FIELD_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-12" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_OFFER_CODE_RULE">
            <column name="OFFER_CODE_RULE_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="MATCH_RULE" type="varchar(MAX)"/>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-13" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_OFFER_CODE_RULE_MAP">
            <column name="OFFER_CODE_OFFER_CODE_RULE_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="MAP_KEY" type="varchar(255)">
                <constraints nullable="false"/>
            </column>
            <column name="BLC_OFFER_CODE_OFFER_CODE_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="OFFER_CODE_RULE_ID" type="numeric(19, 0)"/>
            <column name="offerCodeMatchRules_KEY" type="varchar(255)"/>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-14" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_OFFER_CUSTOMER_SEG_XREF">
            <column name="OFFER_CUSTOMER_SEGMENT_XREF_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="CUSTOMER_SEGMENT_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="OFFER_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-15" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_OFFER_DEP_FLD">
            <column name="OFFER_DEP_FLD_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="FIELD" type="varchar(255)">
                <constraints nullable="false"/>
            </column>
            <column name="FIELD_LABEL_OVERRIDE" type="varchar(255)"/>
            <column name="FIELD_VALUE_OVERRIDE" type="varchar(255)"/>
            <column name="IS_HIDDEN" type="bit"/>
            <column name="OFFER_TEMPLATE_ID" type="numeric(19, 0)"/>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-16" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_OFFER_TEMPLATE">
            <column name="OFFER_TEMPLATE_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="NAME" type="varchar(255)">
                <constraints nullable="false"/>
            </column>
            <column name="SEQUENCE" type="numeric(10, 6)"/>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-17" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_PRICE_LIST_CUST_SEG_XREF">
            <column name="PRICE_LIST_CUST_SEG_XREF_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="CUSTOMER_SEGMENT_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="PRICE_LIST_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-18" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_PRODUCT_GROUP">
            <column name="PRODUCT_GROUP_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="MATCH_RULE" type="varchar(MAX)"/>
            <column name="PRODUCT_GROUP_NAME" type="varchar(255)"/>
            <column name="PRODUCT_GROUP_TYPE" type="varchar(255)"/>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-19" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createTable tableName="BLC_PRODUCT_PRODUCT_GROUP_XREF">
            <column name="PRODUCT_PRODUCT_GROUP_XREF_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="ARCHIVED" type="char(1)"/>
            <column name="CREATED_BY" type="numeric(19, 0)"/>
            <column name="DATE_CREATED" type="datetime"/>
            <column name="DATE_UPDATED" type="datetime"/>
            <column name="UPDATED_BY" type="numeric(19, 0)"/>
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255)"/>
            <column name="SNDBX_CATALOG_FLAG" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_ITEM_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ORIG_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_ARCHIVED_FLAG" type="char(1)"/>
            <column name="SNDBX_DELETED_FLAG" type="char(1)"/>
            <column name="SNDBX_TMPLT_RECORD_ID" type="numeric(19, 0)"/>
            <column name="SNDBX_TIER" type="numeric(19, 0)"/>
            <column name="PRODUCT_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
            <column name="PRODUCT_GROUP_ID" type="numeric(19, 0)">
                <constraints nullable="false"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-20" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CUSTOM_FIELD">
            <column name="ALLOW_MULTI_SELECT" type="bit(1)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-21" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ADMIN_ROLE">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-22" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_COUNTRY">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-23" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_COUNTRY_SUB_CAT">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-24" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CURRENCY">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-25" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FULFILLMENT_LOCATION">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-26" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_LOCALE">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-27" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ORDER_ITEM">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-28" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SANDBOX_MGMT">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-29" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CATALOG">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-30" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_COUNTRY_SUB">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-31" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FIELD">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-32" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ISO_COUNTRY">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-33" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SANDBOX">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-34" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SITE">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-35" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CUSTOM_FIELD">
            <column name="CREATE_NEW_GROUP" type="bit(1)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-36" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ADMIN_ROLE">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-37" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_COUNTRY">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-38" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_COUNTRY_SUB_CAT">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-39" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CURRENCY">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-40" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FULFILLMENT_LOCATION">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-41" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_LOCALE">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-42" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ORDER_ITEM">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-43" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SANDBOX_MGMT">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-44" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CUSTOMER_PAYMENT">
            <column name="GATEWAY_TYPE" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-45" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ADMIN_USER">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-46" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SEARCH_INTERCEPT">
            <column name="CREATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-47" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CATALOG">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-48" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_COUNTRY_SUB">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-49" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FIELD">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-50" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ISO_COUNTRY">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-51" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SANDBOX">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-52" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SITE">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-53" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ADMIN_ROLE">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-54" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_COUNTRY">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-55" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_COUNTRY_SUB_CAT">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-56" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CURRENCY">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-57" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FULFILLMENT_LOCATION">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-58" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_LOCALE">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-59" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ORDER_ITEM">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-60" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SANDBOX_MGMT">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-61" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ADMIN_USER">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-62" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SEARCH_INTERCEPT">
            <column name="DATE_CREATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-63" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CATALOG">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-64" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_COUNTRY_SUB">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-65" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FIELD">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-66" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ISO_COUNTRY">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-67" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SANDBOX">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-68" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SITE">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-69" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CUSTOMER_PAYMENT">
            <column name="PAYMENT_TYPE" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-70" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ADMIN_ROLE">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-71" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_COUNTRY">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-72" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_COUNTRY_SUB_CAT">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-73" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CURRENCY">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-74" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FULFILLMENT_LOCATION">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-75" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_LOCALE">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-76" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ORDER_ITEM">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-77" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SANDBOX_MGMT">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-78" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SANDBOX_MGMT">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-79" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ADMIN_USER">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-80" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SEARCH_INTERCEPT">
            <column name="DATE_UPDATED" type="datetime(23, 3)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-81" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_STORE">
            <column name="STORE_OPEN" type="bit(1)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-82" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CATALOG">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-83" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_COUNTRY_SUB">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-84" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FIELD">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-85" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ISO_COUNTRY">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-86" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SANDBOX">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-87" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SITE">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-88" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ADMIN_ROLE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-89" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CATALOG">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-90" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CATEGORY_ATTRIBUTE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-91" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CATEGORY_MEDIA_MAP">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-92" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CAT_SEARCH_FACET_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-93" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CMS_MENU">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-94" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CNTNT_TRGT_ACTION_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-95" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CNTNT_TRGT_ITEM_CRIT">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-96" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CNTNT_TRGT_RULES">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-97" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CONTENT_TARGETING_ACTION">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-98" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CONTENT_TARGET_RULE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-99" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CONTENT_ZONE_DEF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-100" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CON_ZONE_DEF_WDGT_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-101" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_DATA_DRVN_ENUM">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-102" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_DYNAMIC_REGIONAL_FORM">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-103" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_DYN_REG_FORM_FIELD_CAT">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-104" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FIELD">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-105" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FLD_GROUP">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-106" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FULFILLMENT_LOCATION">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-107" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FULFILLMENT_OPTION">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-108" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_INTERNATIONAL_MSG">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-109" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_OFFER_CODE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-110" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_OFFER_ITEM_CRITERIA">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-111" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_OFFER_RULE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-112" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_OFFER_RULE_MAP">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-113" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_OVERRIDE_SC_FIELD">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-114" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PAGE_ATTRIBUTES">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-115" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PAGE_FLD">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-116" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PAGE_ITEM_CRITERIA">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-117" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PAGE_RULE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-118" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PAGE_TMPLT">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-119" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PAGE_TYPE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-120" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PAGE_TYPE_FLDDEF_MAP">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-121" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PGTMPLT_FLDGRP_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-122" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PL_CRITERIA_RULE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-123" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PL_RULE_MAP">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-124" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRICE_ADJUSTMENT">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-125" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRODUCT_ATTRIBUTE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-126" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRODUCT_CROSS_SALE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-127" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRODUCT_FEATURED">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-128" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRODUCT_OPTION_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-129" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRODUCT_UP_SALE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-130" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_QUAL_CRIT_OFFER_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-131" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SC_CONTENT_ITEM_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-132" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SC_FLD">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-133" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SC_FLD_MAP">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-134" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SC_ITEM_CRITERIA">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-135" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SC_RULE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-136" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SC_TYPE_WIDGET_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-137" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SEARCH_FACET_RANGE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-138" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SEARCH_FACET_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-139" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SKU_ATTRIBUTE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-140" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SKU_BNDL_ITM_PRC_DATA">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-141" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SKU_BUNDLE_ITEM">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-142" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SKU_MEDIA_MAP">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-143" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SKU_OPTION_VALUE_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-144" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SKU_PRICE_DATA_TIER">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-145" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SYSTEM_PROPERTY">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-146" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_TAR_CRIT_OFFER_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-147" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_THEME_FILE_PAGE_TYPE_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-148" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_THEME_FLD">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-149" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_THMDEF_FLDGRP_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-150" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_TRANSLATION">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-151" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_URL_HANDLER">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-152" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ORDER_PAYMENT_TRANSACTION">
            <column name="SAVE_TOKEN" type="bit(1)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-153" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_STORE">
            <column name="STORE_HOURS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-154" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ADMIN_USER">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-155" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SEARCH_INTERCEPT">
            <column name="UPDATED_BY" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-156" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CONTENT_ITEM">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-157" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CONTENT_ZONE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-158" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_DATA_DRVN_ENUM_VAL">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-159" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_DYN_REG_FORM_FIELD">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-160" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_MEDIA">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-161" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_OFFER_TIER">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-162" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_OVERRIDE_CONTENT_ITEM">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-163" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_OVERRIDE_SC_ITEM">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-164" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRICE_MODIFIER">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-165" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SC">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-166" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SC_TYPE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-167" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SEARCH_FACET">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-168" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SITE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-169" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_THEME_CONFIGURATION">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-170" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_THEME_DEFINITION">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-171" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_THEME_FILE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-172" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_STORE">
            <column name="STORE_NUMBER" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-173" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_STORE">
            <column name="ADDRESS_ID" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-174" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_ADMIN_USER">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-175" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CATEGORY_PRODUCT_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-176" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CATEGORY_XREF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-177" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FLD_DEF">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-178" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FULFILLMENT_PRICE_BAND">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-179" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FULFILLMENT_WEIGHT_BAND">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-180" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRODUCT">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-181" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRODUCT_OPTION">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-182" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRODUCT_OPTION_VALUE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-183" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SKU_FEE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-184" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SKU_PRICE_DATA">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-185" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_WIDGET">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-186" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRICE_LIST">
            <column name="CUST_QUALIFICATION_TYPE" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-187" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SNDBX_WRKFLW_DEPLOY">
            <column name="NAME" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-188" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CMS_MENU_ITEM">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-189" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CONTENT_TARGETER">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-190" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_MODULE_CONFIGURATION">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-191" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PAGE">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-192" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRICE_LIST">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-193" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SKU">
            <column name="COST" type="numeric(19, 5)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-194" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SNDBX_WRKFLW_EVENT">
            <column name="IS_CRITICAL" type="bit(1)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-195" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SEARCH_FACET">
            <column name="NAME" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-196" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FIELD">
            <column name="OVERRIDE_GENERATED_PROP_NAME" type="bit(1)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-197" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SNDBX_WRKFLW_DEPLOY">
            <column name="RECURRENCE_TYPE" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-198" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CATEGORY">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-199" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CUSTOM_FIELD">
            <column name="FIELD_ID" type="numeric(19)">
                <constraints nullable="true"/>
            </column>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-200" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_OFFER">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-201" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_CUSTOMER">
            <column name="IS_TAX_EXEMPT" type="bit(1)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-202" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SEARCH_FACET">
            <column name="USE_FACET_RANGES" type="bit(1)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-203" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SEARCH_FACET">
            <column name="INDEX_FIELD_TYPE_ID" type="numeric(19)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-204" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_DYN_REG_FORM_FIELD">
            <column name="FAILURE_MESSAGE" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-205" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_DYNAMIC_REGIONAL_FORM">
            <column name="FORM_NAME" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-206" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_FLD_GROUP">
            <column name="IS_MASTER_FIELD_GROUP" type="bit(1)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-207" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SKU_BUNDLE_ITEM">
            <column name="SEQUENCE" type="numeric(10, 6)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-208" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SYSTEM_PROPERTY">
            <column name="OVERRIDE_GENERATED_PROP_NAME" type="bit(1)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-209" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SKU">
            <column name="ADMIN_ADDITION_STATUS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-210" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_PRODUCT_OPTION">
            <column name="NAME" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-211" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SNDBX_WRKFLW_ITEM">
            <column name="REJECTION_MESSAGE" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-212" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_SKU">
            <column name="KEYWORDS" type="varchar(255 BYTE)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-213" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_OFFER">
            <column name="ORDER_MIN_TOTAL" type="numeric(19, 5)"/>
        </addColumn>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-214" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <addColumn tableName="BLC_OFFER">
            <column name="OFFER_TEMPLATE_ID" type="numeric(19)"/>
        </addColumn>
    </changeSet>

    <changeSet author="dcolgrove (generated)" id="1473916736196-234" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="CUSTOMERPAYMENT_TYPE_INDEX" tableName="BLC_CUSTOMER_PAYMENT">
            <column name="PAYMENT_TYPE"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-235" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="OFFER_TEMP_DEP_FLD_IDX" tableName="BLC_OFFER_DEP_FLD">
            <column name="OFFER_TEMPLATE_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-236" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="OFFER_TEMP_OFFER_IDX" tableName="BLC_OFFER">
            <column name="OFFER_TEMPLATE_ID"/>
        </createIndex>
    </changeSet>

    <changeSet author="dcolgrove (generated)" id="1473916736196-238" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="PRODUCT_OPTION_NAME_INDEX" tableName="BLC_PRODUCT_OPTION">
            <column name="NAME"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-239" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="SEARCH_ACTIVE_INDEX" tableName="BLC_BOOST_RULE_CAT">
            <column name="ACTIVE_END_DATE"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-240" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="SEARCH_ACTIVE_INDEX" tableName="BLC_BOOST_RULE_GLOB">
            <column name="ACTIVE_END_DATE"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-241" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLBORUCA_SNDBX_ID" tableName="BLC_BOOST_RULE_CAT">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-242" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLBORUCA_SNDBX_TEM_ID" tableName="BLC_BOOST_RULE_CAT">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-243" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLBORUGL_SNDBX_ID" tableName="BLC_BOOST_RULE_GLOB">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-244" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLBORUGL_SNDBX_TEM_ID" tableName="BLC_BOOST_RULE_GLOB">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-245" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLCOTGCUSEXR_SNDBX_ID" tableName="BLC_CONTENT_TGTR_CUST_SEG_XREF">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-246" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLCOTGCUSEXR_SNDBX_TEM_ID" tableName="BLC_CONTENT_TGTR_CUST_SEG_XREF">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-247" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLCUCUSEXR_SNDBX_ID" tableName="BLC_CUSTOMER_CUSTOMER_SEG_XREF">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-248" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLCUCUSEXR_SNDBX_TEM_ID" tableName="BLC_CUSTOMER_CUSTOMER_SEG_XREF">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-249" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLCUSE_SNDBX_ID" tableName="BLC_CUSTOMER_SEGMENT">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-250" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLCUSE_SNDBX_TEM_ID" tableName="BLC_CUSTOMER_SEGMENT">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-251" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLOFCORUMA_SNDBX_ID" tableName="BLC_OFFER_CODE_RULE_MAP">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-252" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLOFCORUMA_SNDBX_TEM_ID" tableName="BLC_OFFER_CODE_RULE_MAP">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-253" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLOFCORU_SNDBX_ID" tableName="BLC_OFFER_CODE_RULE">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-254" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLOFCORU_SNDBX_TEM_ID" tableName="BLC_OFFER_CODE_RULE">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-255" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLOFCUSEXR_SNDBX_ID" tableName="BLC_OFFER_CUSTOMER_SEG_XREF">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-256" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLOFCUSEXR_SNDBX_TEM_ID" tableName="BLC_OFFER_CUSTOMER_SEG_XREF">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-257" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLOFDEFL_SNDBX_ID" tableName="BLC_OFFER_DEP_FLD">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-258" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLOFDEFL_SNDBX_TEM_ID" tableName="BLC_OFFER_DEP_FLD">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-259" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLOFTE_SNDBX_ID" tableName="BLC_OFFER_TEMPLATE">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-260" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLOFTE_SNDBX_TEM_ID" tableName="BLC_OFFER_TEMPLATE">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-261" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLPRGR_SNDBX_ID" tableName="BLC_PRODUCT_GROUP">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-262" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLPRGR_SNDBX_TEM_ID" tableName="BLC_PRODUCT_GROUP">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-263" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLPRLICUSEXR_SNDBX_ID" tableName="BLC_PRICE_LIST_CUST_SEG_XREF">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-264" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLPRLICUSEXR_SNDBX_TEM_ID" tableName="BLC_PRICE_LIST_CUST_SEG_XREF">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-265" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLPRPRGRXR_SNDBX_ID" tableName="BLC_PRODUCT_PRODUCT_GROUP_XREF">
            <column name="SNDBX_ID"/>
        </createIndex>
    </changeSet>
    <changeSet author="dcolgrove (generated)" id="1473916736196-266" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
        <createIndex indexName="idx_BLPRPRGRXR_SNDBX_TEM_ID" tableName="BLC_PRODUCT_PRODUCT_GROUP_XREF">
            <column name="SNDBX_ORIG_ITEM_ID"/>
        </createIndex>
    </changeSet>

</databaseChangeLog>