MySQL Creation Changelogs (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="1473723834582-1" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_ALLOWED_ENUM_VALUE">
<column name="ALLOWED_ENUM_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ADMIN_DISPLAY_PRIORITY" type="INT"/>
<column name="VALUE" type="VARCHAR(255)"/>
<column name="FIELD_ID" type="BIGINT"/>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-2" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_ASSET_FOLDER">
<column name="ASSET_FOLDER_ID" type="BIGINT">
<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="1473723834582-3" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_ASSET_FOLDER_ITEM_XREF">
<column name="ASSET_FOLDER_ITEM_XREF_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ASSET_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="FOLDER_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-4" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_ASSET_FOLDER_XREF">
<column name="ASSET_FOLDER_XREF_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="CHILD_FOLDER_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="PARENT_FOLDER_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-5" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_BOOST_RULE_CAT">
<column name="BOOST_RULE_CAT_ID" type="BIGINT">
<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="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="BOOST" type="DECIMAL(19, 2)"/>
<column name="DESCENDING" type="BIT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<column name="MATCH_VALUE" type="VARCHAR(255)"/>
<column name="MINIMUM_SCORE" type="DECIMAL(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="BIGINT">
<constraints nullable="false"/>
</column>
<column name="INDEX_FIELD_TYPE_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-6" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_BOOST_RULE_GLOB">
<column name="BOOST_RULE_GLOB_ID" type="BIGINT">
<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="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="BOOST" type="DECIMAL(19, 2)"/>
<column name="DESCENDING" type="BIT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<column name="MATCH_VALUE" type="VARCHAR(255)"/>
<column name="MINIMUM_SCORE" type="DECIMAL(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="BIGINT"/>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-7" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_CONTENT_TGTR_CUST_SEG_XREF">
<column name="CONTENT_TGTR_CUST_SEG_XREF_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="CREATED_BY" type="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<column name="CONTENT_TARGETER_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="CUSTOMER_SEGMENT_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-8" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_CUSTOMER_CUSTOMER_SEG_XREF">
<column name="CUSTOMER_CUSTOMER_SEG_XREF_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="CREATED_BY" type="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<column name="CUSTOMER_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="CUSTOMER_SEGMENT_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-9" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_CUSTOMER_SEGMENT">
<column name="CUSTOMER_SEGMENT_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="CREATED_BY" type="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<column name="MATCH_RULE" type="LONGTEXT"/>
<column name="CUSTOMER_SEGMENT_NAME" type="VARCHAR(255)"/>
<column name="CUSTOMER_SEGMENT_TYPE" type="VARCHAR(255)"/>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-10" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_INDEX_FIELD">
<column name="INDEX_FIELD_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="SEARCHABLE" type="BIT"/>
<column name="FIELD_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-11" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_INDEX_FIELD_TYPE">
<column name="INDEX_FIELD_TYPE_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="FIELD_TYPE" type="VARCHAR(255)"/>
<column name="INDEX_FIELD_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-12" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_OFFER_CODE_RULE">
<column name="OFFER_CODE_RULE_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="CREATED_BY" type="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<column name="MATCH_RULE" type="LONGTEXT"/>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-13" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_OFFER_CODE_RULE_MAP">
<column name="OFFER_CODE_OFFER_CODE_RULE_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="CREATED_BY" type="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<column name="MAP_KEY" type="VARCHAR(255)">
<constraints nullable="false"/>
</column>
<column name="BLC_OFFER_CODE_OFFER_CODE_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="OFFER_CODE_RULE_ID" type="BIGINT"/>
<column name="offerCodeMatchRules_KEY" type="VARCHAR(255)"/>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-14" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_OFFER_CUSTOMER_SEG_XREF">
<column name="OFFER_CUSTOMER_SEGMENT_XREF_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="CREATED_BY" type="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<column name="CUSTOMER_SEGMENT_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="OFFER_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-15" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_OFFER_DEP_FLD">
<column name="OFFER_DEP_FLD_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="CREATED_BY" type="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<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="BIGINT"/>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-16" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_OFFER_TEMPLATE">
<column name="OFFER_TEMPLATE_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="CREATED_BY" type="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<column name="NAME" type="VARCHAR(255)">
<constraints nullable="false"/>
</column>
<column name="SEQUENCE" type="DECIMAL(10, 6)"/>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-17" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_PRICE_LIST_CUST_SEG_XREF">
<column name="PRICE_LIST_CUST_SEG_XREF_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="CREATED_BY" type="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<column name="CUSTOMER_SEGMENT_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="PRICE_LIST_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-18" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_PRODUCT_GROUP">
<column name="PRODUCT_GROUP_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="CREATED_BY" type="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<column name="MATCH_RULE" type="LONGTEXT"/>
<column name="PRODUCT_GROUP_NAME" type="VARCHAR(255)"/>
<column name="PRODUCT_GROUP_TYPE" type="VARCHAR(255)"/>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-19" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="BLC_PRODUCT_PRODUCT_GROUP_XREF">
<column name="PRODUCT_PRODUCT_GROUP_XREF_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="ARCHIVED" type="CHAR(1)"/>
<column name="CREATED_BY" type="BIGINT"/>
<column name="DATE_CREATED" type="DATETIME"/>
<column name="DATE_UPDATED" type="DATETIME"/>
<column name="UPDATED_BY" type="BIGINT"/>
<column name="ADMIN_ADDITION_STATUS" type="VARCHAR(255)"/>
<column name="SNDBX_CATALOG_FLAG" type="BIGINT"/>
<column name="SNDBX_ORIG_ITEM_ID" type="BIGINT"/>
<column name="SNDBX_ORIG_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_ID" type="BIGINT"/>
<column name="SNDBX_ARCHIVED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_DELETED_FLAG" type="CHAR(1)"/>
<column name="SNDBX_TMPLT_RECORD_ID" type="BIGINT"/>
<column name="SNDBX_TIER" type="BIGINT"/>
<column name="PRODUCT_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="PRODUCT_GROUP_ID" type="BIGINT">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-20" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_CUSTOM_FIELD">
<column name="ALLOW_MULTI_SELECT" type="BIT"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-21" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ADMIN_ROLE">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-22" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_COUNTRY">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-23" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_COUNTRY_SUB_CAT">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-24" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_CURRENCY">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-25" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_FULFILLMENT_LOCATION">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-26" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_LOCALE">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-27" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ORDER_ITEM">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-28" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SANDBOX_MGMT">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-29" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_CATALOG">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-30" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_COUNTRY_SUB">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-31" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_FIELD">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-32" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ISO_COUNTRY">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-33" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SANDBOX">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-34" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SITE">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-35" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_CUSTOM_FIELD">
<column name="CREATE_NEW_GROUP" type="BIT"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-36" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ADMIN_ROLE">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-37" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_COUNTRY">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-38" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_COUNTRY_SUB_CAT">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-39" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_CURRENCY">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-40" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_FULFILLMENT_LOCATION">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-41" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_LOCALE">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-42" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ORDER_ITEM">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-43" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SANDBOX_MGMT">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-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="1473723834582-45" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ADMIN_USER">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-46" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SEARCH_INTERCEPT">
<column name="CREATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-47" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_CATALOG">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-48" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_COUNTRY_SUB">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-49" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_FIELD">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-50" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ISO_COUNTRY">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-51" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SANDBOX">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-52" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SITE">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-53" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ADMIN_ROLE">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-54" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_COUNTRY">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-55" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_COUNTRY_SUB_CAT">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-56" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_CURRENCY">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-57" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_FULFILLMENT_LOCATION">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-58" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_LOCALE">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-59" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ORDER_ITEM">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-60" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SANDBOX_MGMT">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-61" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ADMIN_USER">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-62" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SEARCH_INTERCEPT">
<column name="DATE_CREATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-63" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_CATALOG">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-64" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_COUNTRY_SUB">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-65" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_FIELD">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-66" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ISO_COUNTRY">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-67" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SANDBOX">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-68" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SITE">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-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="1473723834582-70" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ADMIN_ROLE">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-71" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_COUNTRY">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-72" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_COUNTRY_SUB_CAT">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-73" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_CURRENCY">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-74" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_FULFILLMENT_LOCATION">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-75" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_LOCALE">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-76" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ORDER_ITEM">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-77" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SANDBOX_MGMT">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-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="1473723834582-79" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ADMIN_USER">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-80" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SEARCH_INTERCEPT">
<column name="DATE_UPDATED" type="DATETIME(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-81" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_STORE">
<column name="OPEN" type="BIT"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-82" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_CATALOG">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-83" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_COUNTRY_SUB">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-84" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_FIELD">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-85" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ISO_COUNTRY">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-86" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SANDBOX">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-87" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SITE">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-152" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ORDER_PAYMENT_TRANSACTION">
<column name="SAVE_TOKEN" type="BIT"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-153" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_STORE">
<column name="STORE_HOURS" type="VARCHAR(255 BYTE)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-154" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_ADMIN_USER">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-155" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SEARCH_INTERCEPT">
<column name="UPDATED_BY" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-172" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_STORE">
<column name="STORE_NUMBER" type="VARCHAR(255 BYTE)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-173" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_STORE">
<column name="ADDRESS_ID" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-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="1473723834582-193" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SKU">
<column name="COST" type="DECIMAL(19, 5)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-194" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SNDBX_WRKFLW_EVENT">
<column name="IS_CRITICAL" type="BIT"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-195" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SEARCH_FACET">
<column name="NAME" type="VARCHAR(255 BYTE)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-196" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_FIELD">
<column name="OVERRIDE_GENERATED_PROP_NAME" type="BIT"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-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="1473723834582-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="1473723834582-199" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_CUSTOM_FIELD">
<column name="FIELD_ID" type="BIGINT(19)">
<constraints nullable="true"/>
</column>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-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="1473723834582-201" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_CUSTOMER">
<column name="IS_TAX_EXEMPT" type="BIT"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-202" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SEARCH_FACET">
<column name="USE_FACET_RANGES" type="BIT"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-203" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SEARCH_FACET">
<column name="INDEX_FIELD_TYPE_ID" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-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="1473723834582-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="1473723834582-206" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_FLD_GROUP">
<column name="IS_MASTER_FIELD_GROUP" type="BIT"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-207" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SKU_BUNDLE_ITEM">
<column name="SEQUENCE" type="DECIMAL(10, 6)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-208" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SYSTEM_PROPERTY">
<column name="OVERRIDE_GENERATED_PROP_NAME" type="BIT"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-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="1473723834582-210" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_PRODUCT_OPTION">
<column name="NAME" type="VARCHAR(255 BYTE)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-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="1473723834582-212" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_SKU">
<column name="KEYWORDS" type="VARCHAR(255 BYTE)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-213" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_OFFER">
<column name="ORDER_MIN_TOTAL" type="DECIMAL(19, 5)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-214" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addColumn tableName="BLC_OFFER">
<column name="OFFER_TEMPLATE_ID" type="BIGINT(19)"/>
</addColumn>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-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="1473723834582-235" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK102A01D7706F08F1" tableName="BLC_ASSET_FOLDER_XREF">
<column name="PARENT_FOLDER_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-236" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK102A01D7FE088EE3" tableName="BLC_ASSET_FOLDER_XREF">
<column name="CHILD_FOLDER_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-237" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK3902F48C2EF95B6A" tableName="BLC_PRICE_LIST_CUST_SEG_XREF">
<column name="PRICE_LIST_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-238" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK3902F48CB8718EEC" tableName="BLC_PRICE_LIST_CUST_SEG_XREF">
<column name="CUSTOMER_SEGMENT_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-239" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK4A310B72CBDA280B" tableName="BLC_INDEX_FIELD_TYPE">
<column name="INDEX_FIELD_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-240" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK4FFCC986BE3CE566" tableName="BLC_SEARCH_FACET">
<column name="INDEX_FIELD_TYPE_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-241" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK5552E87062A47BC4" tableName="BLC_ALLOWED_ENUM_VALUE">
<column name="FIELD_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-242" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK6F1E0F515D1A13D" tableName="BLC_BOOST_RULE_CAT">
<column name="CATEGORY_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-243" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK6F1E0F5BE3CE566" tableName="BLC_BOOST_RULE_CAT">
<column name="INDEX_FIELD_TYPE_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-244" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK8F94D63BC13085DD" tableName="BLC_STORE">
<column name="ADDRESS_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-245" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK8FAD02C2446C7306" tableName="BLC_OFFER_CODE_RULE_MAP">
<column name="OFFER_CODE_RULE_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-246" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK8FAD02C29D28BF84" tableName="BLC_OFFER_CODE_RULE_MAP">
<column name="BLC_OFFER_CODE_OFFER_CODE_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-247" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FK9A53C1073C3907C4" tableName="BLC_INDEX_FIELD">
<column name="FIELD_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-248" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FKB829E2CB7470F437" tableName="BLC_CUSTOMER_CUSTOMER_SEG_XREF">
<column name="CUSTOMER_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-249" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FKB829E2CBB8718EEC" tableName="BLC_CUSTOMER_CUSTOMER_SEG_XREF">
<column name="CUSTOMER_SEGMENT_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-250" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FKC65750A15F11A0B7" tableName="BLC_PRODUCT_PRODUCT_GROUP_XREF">
<column name="PRODUCT_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-251" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FKC65750A1FBF5D076" tableName="BLC_PRODUCT_PRODUCT_GROUP_XREF">
<column name="PRODUCT_GROUP_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-252" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FKCEE6478B46294CB2" tableName="BLC_ASSET_FOLDER_ITEM_XREF">
<column name="ASSET_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-253" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FKCEE6478B98CE5246" tableName="BLC_ASSET_FOLDER_ITEM_XREF">
<column name="FOLDER_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-254" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FKD280E9DDB8718EEC" tableName="BLC_OFFER_CUSTOMER_SEG_XREF">
<column name="CUSTOMER_SEGMENT_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-255" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FKD280E9DDD5F3FAF4" tableName="BLC_OFFER_CUSTOMER_SEG_XREF">
<column name="OFFER_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-256" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FKD74C3819BE3CE566" tableName="BLC_BOOST_RULE_GLOB">
<column name="INDEX_FIELD_TYPE_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-257" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FKE87D242FB8718EEC" tableName="BLC_CONTENT_TGTR_CUST_SEG_XREF">
<column name="CUSTOMER_SEGMENT_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-258" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FKE87D242FBECA250D" tableName="BLC_CONTENT_TGTR_CUST_SEG_XREF">
<column name="CONTENT_TARGETER_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-259" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="FKEE1F406599291672" tableName="BLC_OFFER_DEP_FLD">
<column name="OFFER_TEMPLATE_ID"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-260" 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="1473723834582-261" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="PRODUCT_OPTION_NAME_INDEX" tableName="BLC_PRODUCT_OPTION">
<column name="NAME"/>
</createIndex>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-262" 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="1473723834582-263" 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="1473723834582-264" 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="1473723834582-265" 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="1473723834582-266" 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="1473723834582-267" 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="1473723834582-268" 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="1473723834582-269" 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="1473723834582-270" 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="1473723834582-271" 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="1473723834582-272" 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="1473723834582-273" 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="1473723834582-274" 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="1473723834582-275" 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="1473723834582-276" 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="1473723834582-277" 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="1473723834582-278" 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="1473723834582-279" 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="1473723834582-280" 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="1473723834582-281" 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="1473723834582-282" 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="1473723834582-283" 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="1473723834582-284" 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="1473723834582-285" 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="1473723834582-286" 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="1473723834582-287" 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="1473723834582-288" 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="1473723834582-289" 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>