MySQL Clean up 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="1473723834582-215" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="ALLOWED_ENUM_ID" constraintName="PRIMARY" tableName="BLC_ALLOWED_ENUM_VALUE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-216" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="ASSET_FOLDER_ID" constraintName="PRIMARY" tableName="BLC_ASSET_FOLDER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-217" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="ASSET_FOLDER_ITEM_XREF_ID" constraintName="PRIMARY" tableName="BLC_ASSET_FOLDER_ITEM_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-218" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="ASSET_FOLDER_XREF_ID" constraintName="PRIMARY" tableName="BLC_ASSET_FOLDER_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-219" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="BOOST_RULE_CAT_ID" constraintName="PRIMARY" tableName="BLC_BOOST_RULE_CAT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-220" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="BOOST_RULE_GLOB_ID" constraintName="PRIMARY" tableName="BLC_BOOST_RULE_GLOB"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-221" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="CONTENT_TGTR_CUST_SEG_XREF_ID" constraintName="PRIMARY" tableName="BLC_CONTENT_TGTR_CUST_SEG_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-222" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="CUSTOMER_CUSTOMER_SEG_XREF_ID" constraintName="PRIMARY" tableName="BLC_CUSTOMER_CUSTOMER_SEG_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-223" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="CUSTOMER_SEGMENT_ID" constraintName="PRIMARY" tableName="BLC_CUSTOMER_SEGMENT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-224" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="INDEX_FIELD_ID" constraintName="PRIMARY" tableName="BLC_INDEX_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-225" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="INDEX_FIELD_TYPE_ID" constraintName="PRIMARY" tableName="BLC_INDEX_FIELD_TYPE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-226" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="OFFER_CODE_RULE_ID" constraintName="PRIMARY" tableName="BLC_OFFER_CODE_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-227" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="OFFER_CODE_OFFER_CODE_RULE_ID" constraintName="PRIMARY" tableName="BLC_OFFER_CODE_RULE_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-228" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="OFFER_CUSTOMER_SEGMENT_XREF_ID" constraintName="PRIMARY" tableName="BLC_OFFER_CUSTOMER_SEG_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-229" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="OFFER_DEP_FLD_ID" constraintName="PRIMARY" tableName="BLC_OFFER_DEP_FLD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-230" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="OFFER_TEMPLATE_ID" constraintName="PRIMARY" tableName="BLC_OFFER_TEMPLATE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-231" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="PRICE_LIST_CUST_SEG_XREF_ID" constraintName="PRIMARY" tableName="BLC_PRICE_LIST_CUST_SEG_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-232" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="PRODUCT_GROUP_ID" constraintName="PRIMARY" tableName="BLC_PRODUCT_GROUP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-233" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="PRODUCT_PRODUCT_GROUP_XREF_ID" constraintName="PRIMARY" tableName="BLC_PRODUCT_PRODUCT_GROUP_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-290" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="PARENT_FOLDER_ID" baseTableName="BLC_ASSET_FOLDER_XREF" constraintName="FK102A01D7706F08F1" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="ASSET_FOLDER_ID" referencedTableName="BLC_ASSET_FOLDER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-291" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="CHILD_FOLDER_ID" baseTableName="BLC_ASSET_FOLDER_XREF" constraintName="FK102A01D7FE088EE3" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="ASSET_FOLDER_ID" referencedTableName="BLC_ASSET_FOLDER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-292" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="PRICE_LIST_ID" baseTableName="BLC_PRICE_LIST_CUST_SEG_XREF" constraintName="FK3902F48C2EF95B6A" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="PRICE_LIST_ID" referencedTableName="BLC_PRICE_LIST"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-293" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="CUSTOMER_SEGMENT_ID" baseTableName="BLC_PRICE_LIST_CUST_SEG_XREF" constraintName="FK3902F48CB8718EEC" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="CUSTOMER_SEGMENT_ID" referencedTableName="BLC_CUSTOMER_SEGMENT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-294" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="INDEX_FIELD_ID" baseTableName="BLC_INDEX_FIELD_TYPE" constraintName="FK4A310B72CBDA280B" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="INDEX_FIELD_ID" referencedTableName="BLC_INDEX_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-295" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="INDEX_FIELD_TYPE_ID" baseTableName="BLC_SEARCH_FACET" constraintName="FK4FFCC986BE3CE566" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="INDEX_FIELD_TYPE_ID" referencedTableName="BLC_INDEX_FIELD_TYPE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-296" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="FIELD_ID" baseTableName="BLC_ALLOWED_ENUM_VALUE" constraintName="FK5552E87062A47BC4" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="FIELD_ID" referencedTableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-297" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="FIELD_ID" baseTableName="BLC_CUSTOM_FIELD" constraintName="FK5FF15FD23C3907C4" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="FIELD_ID" referencedTableName="BLC_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-298" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="CATEGORY_ID" baseTableName="BLC_BOOST_RULE_CAT" constraintName="FK6F1E0F515D1A13D" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="CATEGORY_ID" referencedTableName="BLC_CATEGORY"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-299" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="INDEX_FIELD_TYPE_ID" baseTableName="BLC_BOOST_RULE_CAT" constraintName="FK6F1E0F5BE3CE566" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="INDEX_FIELD_TYPE_ID" referencedTableName="BLC_INDEX_FIELD_TYPE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-300" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="OFFER_TEMPLATE_ID" baseTableName="BLC_OFFER" constraintName="FK8F55F7B699291672" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="OFFER_TEMPLATE_ID" referencedTableName="BLC_OFFER_TEMPLATE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-301" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="ADDRESS_ID" baseTableName="BLC_STORE" constraintName="FK8F94D63BC13085DD" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="ADDRESS_ID" referencedTableName="BLC_ADDRESS"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-302" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="OFFER_CODE_RULE_ID" baseTableName="BLC_OFFER_CODE_RULE_MAP" constraintName="FK8FAD02C2446C7306" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="OFFER_CODE_RULE_ID" referencedTableName="BLC_OFFER_CODE_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-303" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="BLC_OFFER_CODE_OFFER_CODE_ID" baseTableName="BLC_OFFER_CODE_RULE_MAP" constraintName="FK8FAD02C29D28BF84" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="OFFER_CODE_ID" referencedTableName="BLC_OFFER_CODE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-304" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="FIELD_ID" baseTableName="BLC_INDEX_FIELD" constraintName="FK9A53C1073C3907C4" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="FIELD_ID" referencedTableName="BLC_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-305" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="CUSTOMER_ID" baseTableName="BLC_CUSTOMER_CUSTOMER_SEG_XREF" constraintName="FKB829E2CB7470F437" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="CUSTOMER_ID" referencedTableName="BLC_CUSTOMER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-306" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="CUSTOMER_SEGMENT_ID" baseTableName="BLC_CUSTOMER_CUSTOMER_SEG_XREF" constraintName="FKB829E2CBB8718EEC" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="CUSTOMER_SEGMENT_ID" referencedTableName="BLC_CUSTOMER_SEGMENT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-307" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="PRODUCT_ID" baseTableName="BLC_PRODUCT_PRODUCT_GROUP_XREF" constraintName="FKC65750A15F11A0B7" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="PRODUCT_ID" referencedTableName="BLC_PRODUCT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-308" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="PRODUCT_GROUP_ID" baseTableName="BLC_PRODUCT_PRODUCT_GROUP_XREF" constraintName="FKC65750A1FBF5D076" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="PRODUCT_GROUP_ID" referencedTableName="BLC_PRODUCT_GROUP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-309" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="ASSET_ID" baseTableName="BLC_ASSET_FOLDER_ITEM_XREF" constraintName="FKCEE6478B46294CB2" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="STATIC_ASSET_ID" referencedTableName="BLC_STATIC_ASSET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-310" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="FOLDER_ID" baseTableName="BLC_ASSET_FOLDER_ITEM_XREF" constraintName="FKCEE6478B98CE5246" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="ASSET_FOLDER_ID" referencedTableName="BLC_ASSET_FOLDER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-311" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="CUSTOMER_SEGMENT_ID" baseTableName="BLC_OFFER_CUSTOMER_SEG_XREF" constraintName="FKD280E9DDB8718EEC" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="CUSTOMER_SEGMENT_ID" referencedTableName="BLC_CUSTOMER_SEGMENT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-312" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="OFFER_ID" baseTableName="BLC_OFFER_CUSTOMER_SEG_XREF" constraintName="FKD280E9DDD5F3FAF4" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="OFFER_ID" referencedTableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-313" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="INDEX_FIELD_TYPE_ID" baseTableName="BLC_BOOST_RULE_GLOB" constraintName="FKD74C3819BE3CE566" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="INDEX_FIELD_TYPE_ID" referencedTableName="BLC_INDEX_FIELD_TYPE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-314" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="CUSTOMER_SEGMENT_ID" baseTableName="BLC_CONTENT_TGTR_CUST_SEG_XREF" constraintName="FKE87D242FB8718EEC" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="CUSTOMER_SEGMENT_ID" referencedTableName="BLC_CUSTOMER_SEGMENT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-315" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="CONTENT_TARGETER_ID" baseTableName="BLC_CONTENT_TGTR_CUST_SEG_XREF" constraintName="FKE87D242FBECA250D" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="CONTENT_TARGETER_ID" referencedTableName="BLC_CONTENT_TARGETER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-316" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="OFFER_TEMPLATE_ID" baseTableName="BLC_OFFER_DEP_FLD" constraintName="FKEE1F406599291672" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="OFFER_TEMPLATE_ID" referencedTableName="BLC_OFFER_TEMPLATE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-317">
<dropForeignKeyConstraint baseTableName="BLC_SEARCH_FACET" constraintName="FK4FFCC9863C3907C4"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-319">
<dropForeignKeyConstraint baseTableName="BLC_FIELD_SEARCH_TYPES" constraintName="FKF52D130D3C3907C4"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-320">
<dropTable tableName="BLC_FIELD_SEARCH_TYPES"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-322">
<dropColumn columnName="ADDRESS_1" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-323">
<dropColumn columnName="ADDRESS_2" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-324">
<dropColumn columnName="APPLIES_TO_RULES" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-325">
<dropColumn columnName="APPLIES_WHEN_RULES" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-326">
<dropColumn columnName="APPLY_OFFER_TO_MARKED_ITEMS" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-327">
<dropColumn columnName="ARCHIVED" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-328">
<dropColumn columnName="CREATED_BY" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-329">
<dropColumn columnName="CUSTOM_FIELD_ID" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-330">
<dropColumn columnName="DATE_CREATED" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-331">
<dropColumn columnName="DATE_UPDATED" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-332">
<dropColumn columnName="FACET_FIELD_TYPE" tableName="BLC_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-333">
<dropColumn columnName="FIELD_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-334">
<dropColumn columnName="FRIENDLY_NAME" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-335">
<dropColumn columnName="OFFER_DELIVERY_TYPE" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-336">
<dropColumn columnName="PRICING_CONTEXT_RULE" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-337">
<dropColumn columnName="SEARCHABLE" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-338">
<dropColumn columnName="SEARCHABLE" tableName="BLC_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-339">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CATEGORY"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-340">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CATEGORY_ATTRIBUTE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-341">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CATEGORY_MEDIA_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-342">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CATEGORY_PRODUCT_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-343">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CATEGORY_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-344">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-345">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CAT_SEARCH_FACET_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-346">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CMS_MENU"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-347">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CMS_MENU_ITEM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-348">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CNTNT_TRGT_ACTION_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-349">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CNTNT_TRGT_ITEM_CRIT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-350">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CNTNT_TRGT_RULES"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-351">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CONTENT_ITEM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-352">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CONTENT_TARGETER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-353">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CONTENT_TARGETING_ACTION"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-354">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CONTENT_TARGET_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-355">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CONTENT_ZONE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-356">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CONTENT_ZONE_DEF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-357">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CON_ZONE_DEF_WDGT_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-358">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_DATA_DRVN_ENUM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-359">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_DATA_DRVN_ENUM_VAL"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-360">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_DYNAMIC_REGIONAL_FORM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-361">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_DYN_REG_FORM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-362">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_DYN_REG_FORM_FIELD_CAT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-363">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_FLD_DEF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-364">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_FLD_GROUP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-365">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_FULFILLMENT_OPTION"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-366">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_FULFILLMENT_PRICE_BAND"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-367">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_FULFILLMENT_WEIGHT_BAND"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-368">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_INTERNATIONAL_MSG"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-369">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_MEDIA"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-370">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-371">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OFFER_CODE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-372">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OFFER_ITEM_CRITERIA"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-373">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OFFER_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-374">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OFFER_RULE_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-375">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OFFER_TIER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-376">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OVERRIDE_CONTENT_ITEM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-377">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OVERRIDE_SC_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-378">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OVERRIDE_SC_ITEM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-379">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-380">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_ATTRIBUTES"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-381">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_FLD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-382">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_ITEM_CRITERIA"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-383">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-384">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_TMPLT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-385">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_TYPE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-386">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_TYPE_FLDDEF_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-387">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PGTMPLT_FLDGRP_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-388">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PL_CRITERIA_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-389">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PL_RULE_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-390">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRICE_ADJUSTMENT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-391">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRICE_LIST"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-392">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRICE_MODIFIER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-393">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-394">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_ATTRIBUTE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-395">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_CROSS_SALE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-396">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_FEATURED"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-397">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_OPTION"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-398">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_OPTION_VALUE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-399">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_OPTION_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-400">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_UP_SALE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-401">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_QUAL_CRIT_OFFER_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-402">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-403">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_CONTENT_ITEM_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-404">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_FLD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-405">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_FLD_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-406">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_ITEM_CRITERIA"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-407">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-408">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_TYPE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-409">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_TYPE_WIDGET_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-410">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-411">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SEARCH_FACET_RANGE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-412">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SEARCH_FACET_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-413">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-414">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_ATTRIBUTE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-415">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_BNDL_ITM_PRC_DATA"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-416">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_BUNDLE_ITEM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-417">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_FEE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-418">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_MEDIA_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-419">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_OPTION_VALUE_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-420">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_PRICE_DATA"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-421">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_PRICE_DATA_TIER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-422">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SYSTEM_PROPERTY"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-423">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_TAR_CRIT_OFFER_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-424">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_THEME_CONFIGURATION"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-425">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_THEME_DEFINITION"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-426">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_THEME_FILE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-427">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_THEME_FILE_PAGE_TYPE_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-428">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_THEME_FLD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-429">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_THMDEF_FLDGRP_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-430">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_TRANSLATION"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-431">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_URL_HANDLER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-432">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_WIDGET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-433">
<dropColumn columnName="SNDBX_ARCHIVED_FLAG" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-434">
<dropColumn columnName="SNDBX_ARCHIVED_FLAG" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-435">
<dropColumn columnName="SNDBX_CATALOG_FLAG" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-436">
<dropColumn columnName="SNDBX_CATALOG_FLAG" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-437">
<dropColumn columnName="SNDBX_DELETED_FLAG" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-438">
<dropColumn columnName="SNDBX_DELETED_FLAG" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-439">
<dropColumn columnName="SNDBX_ID" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-440">
<dropColumn columnName="SNDBX_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-441">
<dropColumn columnName="SNDBX_ORIG_ITEM_ID" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-442">
<dropColumn columnName="SNDBX_ORIG_ITEM_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-443">
<dropColumn columnName="SNDBX_ORIG_RECORD_ID" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-444">
<dropColumn columnName="SNDBX_ORIG_RECORD_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-445">
<dropColumn columnName="SNDBX_TIER" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-446">
<dropColumn columnName="SNDBX_TIER" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-447">
<dropColumn columnName="SNDBX_TMPLT_RECORD_ID" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-448">
<dropColumn columnName="SNDBX_TMPLT_RECORD_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-449">
<dropColumn columnName="STACKABLE" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-450">
<dropColumn columnName="STORE_CITY" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-451">
<dropColumn columnName="STORE_COUNTRY" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-452">
<dropColumn columnName="STORE_PHONE" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-453">
<dropColumn columnName="STORE_STATE" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-454">
<dropColumn columnName="STORE_ZIP" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-455">
<dropColumn columnName="UPDATED_BY" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-456">
<dropColumn columnName="USES" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-457">
<dropColumn columnName="USE_NEW_FORMAT" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-458">
<dropIndex indexName="idx_BLCASEFAEXXR_SNDBX_ID" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-459">
<dropIndex indexName="idx_BLCASEFAEXXR_SNDBX_TEM_ID" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-460">
<dropIndex indexName="idx_BLSEFA_SNDBX_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-461">
<dropIndex indexName="idx_BLSEFA_SNDBX_TEM_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-462">
<dropNotNullConstraint columnDataType="varchar(255)" columnName="ATTR_NAME" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-463">
<dropNotNullConstraint columnDataType="bigint(19)" columnName="CONTENT_ZONE_DEF" tableName="BLC_CONTENT_ZONE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-464">
<dropNotNullConstraint columnDataType="varchar(255)" columnName="CUSTOM_FIELD_TARGET" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-465">
<dropNotNullConstraint columnDataType="varchar(255)" columnName="CUSTOM_FIELD_TYPE" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473723834582-466">
<dropPrimaryKey tableName="BLC_CUSTOM_FIELD"/>
<addPrimaryKey columnNames="FIELD_ID" constraintName="PRIMARY" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
</databaseChangeLog>