Skip to content

Commit

Permalink
Moved the changeset that drops the orders.order_type column closer to…
Browse files Browse the repository at this point in the history 
… the start of the 1.10. upgrade
  • Loading branch information
@wluyima
wluyima committed Mar 6, 2014
1 parent ae60df4 commit e06daca
Showing 1 changed file with 16 additions and 16 deletions.
32 changes: 16 additions & 16 deletions api/src/main/resources/liquibase-update-to-latest.xml
View file
Expand Up @@ -6421,6 +6421,22 @@
</comment>
</changeSet>

<changeSet id="201403011303-TRUNK-4198_1" author="harsha">
<preConditions onFail="MARK_RAN">
<foreignKeyConstraintExists foreignKeyName="type_of_order"/>
</preConditions>
<comment>Dropping foreign key constraint on orders.order_type_id</comment>
<dropForeignKeyConstraint baseTableName="orders" constraintName="type_of_order"/>
</changeSet>

<changeSet id="201403011303-TRUNK-4198_2" author="harsha">
<preConditions onFail="MARK_RAN">
<columnExists tableName="orders" columnName="order_type_id"/>
</preConditions>
<comment>Remove the order_type_id column from orders table</comment>
<dropColumn tableName="orders" columnName="order_type_id"/>
</changeSet>

<changeSet id="201402241054" author="Akshika">
<comment>Making orders.start_date not nullable</comment>
<ext:modifyColumn tableName="orders">
Expand Down Expand Up @@ -6755,22 +6771,6 @@
<renameColumn tableName="orders" oldColumnName="discontinued_date" newColumnName="date_stopped" columnDataType="datetime"/>
</changeSet>

<changeSet id="201403011303-TRUNK-4198_1" author="harsha">
<preConditions onFail="MARK_RAN">
<foreignKeyConstraintExists foreignKeyName="type_of_order"/>
</preConditions>
<comment>Dropping foreign key constraint on orders.order_type_id</comment>
<dropForeignKeyConstraint baseTableName="orders" constraintName="type_of_order"/>
</changeSet>

<changeSet id="201403011303-TRUNK-4198_2" author="harsha">
<preConditions onFail="MARK_RAN">
<columnExists tableName="orders" columnName="order_type_id"/>
</preConditions>
<comment>Remove the order_type_id column from orders table</comment>
<dropColumn tableName="orders" columnName="order_type_id"/>
</changeSet>

<changeSet id="201312201523-TRUNK-4138" author="banka">
<preConditions onFail="HALT" onFailMessage="Please make sure all discontinued orders have the date_stopped field set">
<sqlCheck expectedResult="0">select count(*) from orders where discontinued = true and date_stopped is null</sqlCheck>
Expand Down

0 comments on commit e06daca

Please sign in to comment.