Microsoft SQL Server Clean Up Changelog
<?xml version="1.1" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd">
<changeSet author="dcolgrove (generated)" id="1473916736196-215" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="ALLOWED_ENUM_ID" constraintName="PK__BLC_ALLO__ABA5F9BB3DAF5B78" tableName="BLC_ALLOWED_ENUM_VALUE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-216" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="ASSET_FOLDER_ITEM_XREF_ID" constraintName="PK__BLC_ASSE__459A6D91D0E06A04" tableName="BLC_ASSET_FOLDER_ITEM_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-217" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="ASSET_FOLDER_XREF_ID" constraintName="PK__BLC_ASSE__D781557F01358781" tableName="BLC_ASSET_FOLDER_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-218" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="ASSET_FOLDER_ID" constraintName="PK__BLC_ASSE__DE2284B96B15F9C2" tableName="BLC_ASSET_FOLDER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-219" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="BOOST_RULE_CAT_ID" constraintName="PK__BLC_BOOS__B237DD2AC4A2842D" tableName="BLC_BOOST_RULE_CAT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-220" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="BOOST_RULE_GLOB_ID" constraintName="PK__BLC_BOOS__BAFA55211C94B138" tableName="BLC_BOOST_RULE_GLOB"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-221" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="CONTENT_TGTR_CUST_SEG_XREF_ID" constraintName="PK__BLC_CONT__10653B3BAFD96542" tableName="BLC_CONTENT_TGTR_CUST_SEG_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-222" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="CUSTOMER_CUSTOMER_SEG_XREF_ID" constraintName="PK__BLC_CUST__15D1440F0CD1E162" tableName="BLC_CUSTOMER_CUSTOMER_SEG_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-223" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="CUSTOMER_SEGMENT_ID" constraintName="PK__BLC_CUST__9F6AF532C2DA0B90" tableName="BLC_CUSTOMER_SEGMENT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-224" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="INDEX_FIELD_ID" constraintName="PK__BLC_INDE__2EAE7AAE24C632CD" tableName="BLC_INDEX_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-225" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="INDEX_FIELD_TYPE_ID" constraintName="PK__BLC_INDE__9DF57988775A2F5A" tableName="BLC_INDEX_FIELD_TYPE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-226" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="OFFER_CODE_OFFER_CODE_RULE_ID" constraintName="PK__BLC_OFFE__1751392EFBB074BD" tableName="BLC_OFFER_CODE_RULE_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-227" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="OFFER_TEMPLATE_ID" constraintName="PK__BLC_OFFE__1BB45F21CD47EBF6" tableName="BLC_OFFER_TEMPLATE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-228" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="OFFER_DEP_FLD_ID" constraintName="PK__BLC_OFFE__51F76E37291C1E73" tableName="BLC_OFFER_DEP_FLD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-229" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="OFFER_CODE_RULE_ID" constraintName="PK__BLC_OFFE__ADD7EDA41ED976A2" tableName="BLC_OFFER_CODE_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-230" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="OFFER_CUSTOMER_SEGMENT_XREF_ID" constraintName="PK__BLC_OFFE__F6FDE04C788F6BCD" tableName="BLC_OFFER_CUSTOMER_SEG_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-231" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="PRICE_LIST_CUST_SEG_XREF_ID" constraintName="PK__BLC_PRIC__EF66634FA98AC99B" tableName="BLC_PRICE_LIST_CUST_SEG_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-232" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="PRODUCT_PRODUCT_GROUP_XREF_ID" constraintName="PK__BLC_PROD__011793CD68696E89" tableName="BLC_PRODUCT_PRODUCT_GROUP_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-233" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addPrimaryKey columnNames="PRODUCT_GROUP_ID" constraintName="PK__BLC_PROD__D1152948B046DF71" tableName="BLC_PRODUCT_GROUP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-267" 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="1473916736196-268" 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="1473916736196-269" 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="1473916736196-270" 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="1473916736196-271" 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="1473916736196-272" 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="1473916736196-273" 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="1473916736196-274" 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="1473916736196-275" 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="1473916736196-276" 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="1473916736196-277" 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="1473916736196-278" 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="1473916736196-279" 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="1473916736196-280" 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="1473916736196-281" 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="1473916736196-282" 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="1473916736196-283" 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="1473916736196-284" 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="1473916736196-285" 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="1473916736196-286" 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="1473916736196-287" 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="1473916736196-288" 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="1473916736196-289" 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="1473916736196-290" 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="1473916736196-291" 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="1473916736196-292" 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="1473916736196-293" 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="1473916736196-294">
<dropForeignKeyConstraint baseTableName="PD_SITE" constraintName="FK15D9EB2843A8B63"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-295">
<dropForeignKeyConstraint baseTableName="BLC_SEARCH_FACET" constraintName="FK4FFCC9863C3907C4"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-296">
<dropForeignKeyConstraint baseTableName="DPC_SKU" constraintName="FK998805F5B78C9977"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-297">
<dropForeignKeyConstraint baseTableName="BLC_FIELD_SEARCH_TYPES" constraintName="FKF52D130D3C3907C4"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-298">
<dropTable tableName="BLC_FIELD_SEARCH_TYPES"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-299">
<dropTable tableName="DPC_SKU"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-300">
<dropTable tableName="PD_SITE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-301">
<dropColumn columnName="ADDRESS_1" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-302">
<dropColumn columnName="ADDRESS_2" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-303">
<dropColumn columnName="APPLIES_TO_RULES" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-304">
<dropColumn columnName="APPLIES_WHEN_RULES" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-305">
<dropColumn columnName="APPLY_OFFER_TO_MARKED_ITEMS" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-306">
<dropColumn columnName="ARCHIVED" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-307">
<dropColumn columnName="CREATED_BY" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-308">
<dropColumn columnName="CUSTOM_FIELD_ID" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-309">
<dropColumn columnName="DATE_CREATED" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-310">
<dropColumn columnName="DATE_UPDATED" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-311">
<dropColumn columnName="FACET_FIELD_TYPE" tableName="BLC_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-312">
<dropColumn columnName="FIELD_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-313">
<dropColumn columnName="FRIENDLY_NAME" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-314">
<dropColumn columnName="OFFER_DELIVERY_TYPE" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-315">
<dropColumn columnName="PRICING_CONTEXT_RULE" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-316">
<dropColumn columnName="SEARCHABLE" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-317">
<dropColumn columnName="SEARCHABLE" tableName="BLC_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-318">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CATEGORY"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-319">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CATEGORY_ATTRIBUTE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-320">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CATEGORY_MEDIA_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-321">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CATEGORY_PRODUCT_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-322">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CATEGORY_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-323">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-324">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CAT_SEARCH_FACET_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-325">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CMS_MENU"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-326">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CMS_MENU_ITEM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-327">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CNTNT_TRGT_ACTION_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-328">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CNTNT_TRGT_ITEM_CRIT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-329">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CNTNT_TRGT_RULES"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-330">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CONTENT_ITEM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-331">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CONTENT_TARGETER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-332">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CONTENT_TARGETING_ACTION"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-333">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CONTENT_TARGET_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-334">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CONTENT_ZONE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-335">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CONTENT_ZONE_DEF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-336">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_CON_ZONE_DEF_WDGT_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-337">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_DATA_DRVN_ENUM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-338">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_DATA_DRVN_ENUM_VAL"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-339">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_DYNAMIC_REGIONAL_FORM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-340">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_DYN_REG_FORM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-341">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_DYN_REG_FORM_FIELD_CAT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-342">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_FLD_DEF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-343">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_FLD_GROUP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-344">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_FULFILLMENT_OPTION"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-345">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_FULFILLMENT_PRICE_BAND"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-346">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_FULFILLMENT_WEIGHT_BAND"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-347">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_INTERNATIONAL_MSG"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-348">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_MEDIA"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-349">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-350">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OFFER_CODE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-351">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OFFER_ITEM_CRITERIA"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-352">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OFFER_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-353">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OFFER_RULE_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-354">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OFFER_TIER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-355">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OVERRIDE_CONTENT_ITEM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-356">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OVERRIDE_SC_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-357">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_OVERRIDE_SC_ITEM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-358">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-359">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_ATTRIBUTES"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-360">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_FLD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-361">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_ITEM_CRITERIA"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-362">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-363">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_TMPLT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-364">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_TYPE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-365">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PAGE_TYPE_FLDDEF_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-366">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PGTMPLT_FLDGRP_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-367">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PL_CRITERIA_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-368">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PL_RULE_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-369">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRICE_ADJUSTMENT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-370">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRICE_LIST"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-371">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRICE_MODIFIER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-372">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-373">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_ATTRIBUTE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-374">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_CROSS_SALE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-375">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_FEATURED"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-376">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_OPTION"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-377">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_OPTION_VALUE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-378">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_OPTION_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-379">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_PRODUCT_UP_SALE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-380">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_QUAL_CRIT_OFFER_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-381">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-382">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_CONTENT_ITEM_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-383">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_FLD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-384">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_FLD_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-385">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_ITEM_CRITERIA"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-386">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_RULE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-387">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_TYPE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-388">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SC_TYPE_WIDGET_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-389">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-390">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SEARCH_FACET_RANGE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-391">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SEARCH_FACET_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-392">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-393">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_ATTRIBUTE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-394">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_BNDL_ITM_PRC_DATA"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-395">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_BUNDLE_ITEM"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-396">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_FEE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-397">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_MEDIA_MAP"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-398">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_OPTION_VALUE_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-399">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_PRICE_DATA"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-400">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SKU_PRICE_DATA_TIER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-401">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_SYSTEM_PROPERTY"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-402">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_TAR_CRIT_OFFER_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-403">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_THEME_CONFIGURATION"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-404">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_THEME_DEFINITION"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-405">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_THEME_FILE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-406">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_THEME_FILE_PAGE_TYPE_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-407">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_THEME_FLD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-408">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_THMDEF_FLDGRP_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-409">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_TRANSLATION"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-410">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_URL_HANDLER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-411">
<dropColumn columnName="SNDBX_APPROVAL_STATUS" tableName="BLC_WIDGET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-412">
<dropColumn columnName="SNDBX_ARCHIVED_FLAG" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-413">
<dropColumn columnName="SNDBX_ARCHIVED_FLAG" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-414">
<dropColumn columnName="SNDBX_CATALOG_FLAG" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-415">
<dropColumn columnName="SNDBX_CATALOG_FLAG" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-416">
<dropColumn columnName="SNDBX_DELETED_FLAG" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-417">
<dropColumn columnName="SNDBX_DELETED_FLAG" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-418">
<dropColumn columnName="SNDBX_ID" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-419">
<dropColumn columnName="SNDBX_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-420">
<dropColumn columnName="SNDBX_ORIG_ITEM_ID" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-421">
<dropColumn columnName="SNDBX_ORIG_ITEM_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-422">
<dropColumn columnName="SNDBX_ORIG_RECORD_ID" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-423">
<dropColumn columnName="SNDBX_ORIG_RECORD_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-424">
<dropColumn columnName="SNDBX_TIER" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-425">
<dropColumn columnName="SNDBX_TIER" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-426">
<dropColumn columnName="SNDBX_TMPLT_RECORD_ID" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-427">
<dropColumn columnName="SNDBX_TMPLT_RECORD_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-428">
<dropColumn columnName="STACKABLE" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-429">
<dropColumn columnName="STORE_CITY" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-430">
<dropColumn columnName="STORE_COUNTRY" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-431">
<dropColumn columnName="STORE_PHONE" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-432">
<dropColumn columnName="STORE_STATE" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-433">
<dropColumn columnName="STORE_ZIP" tableName="BLC_STORE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-434">
<dropColumn columnName="UPDATED_BY" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-435">
<dropColumn columnName="USES" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-436">
<dropColumn columnName="USE_NEW_FORMAT" tableName="BLC_OFFER"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-437">
<dropIndex indexName="PK__BLC_CUST__6DEABC619FE6179A" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-438">
<dropIndex indexName="idx_BLCASEFAEXXR_SNDBX_ID" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-439">
<dropIndex indexName="idx_BLCASEFAEXXR_SNDBX_TEM_ID" tableName="BLC_CAT_SEARCH_FACET_EXCL_XREF"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-440">
<dropIndex indexName="idx_BLSEFA_SNDBX_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-441">
<dropIndex indexName="idx_BLSEFA_SNDBX_TEM_ID" tableName="BLC_SEARCH_FACET"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-442">
<dropNotNullConstraint columnDataType="varchar(255)" columnName="ATTR_NAME" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-443">
<dropNotNullConstraint columnDataType="number(19)" columnName="CONTENT_ZONE_DEF" tableName="BLC_CONTENT_ZONE"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-444">
<dropNotNullConstraint columnDataType="varchar(255)" columnName="CUSTOM_FIELD_TARGET" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-445">
<dropNotNullConstraint columnDataType="varchar(255)" columnName="CUSTOM_FIELD_TYPE" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-446">
<dropPrimaryKey tableName="BLC_CUSTOM_FIELD"/>
<addPrimaryKey columnNames="FIELD_ID" constraintName="PK__BLC_CUST__E86DCC3FC78BDFA7" tableName="BLC_CUSTOM_FIELD"/>
</changeSet>
<changeSet author="dcolgrove (generated)" id="1473916736196-237" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex clustered="true" indexName="PK__BLC_CUST__E86DCC3FC78BDFA7" tableName="BLC_CUSTOM_FIELD" unique="true">
<column name="FIELD_ID"/>
</createIndex>
</changeSet>
</databaseChangeLog>