Add changeset to drop fk constraint on orders.discontinued_by column …

…before dropping the column - TRUNK-4138
openmrs · Jan 2, 2014 · c5ee5ea · c5ee5ea
1 parent bc394f1
commit c5ee5ea
Showing 1 changed file with 8 additions and 0 deletions.
diff --git a/api/src/main/resources/liquibase-update-to-latest.xml b/api/src/main/resources/liquibase-update-to-latest.xml
@@ -6790,6 +6790,14 @@
         <dropColumn tableName="orders" columnName="discontinued" />
 	</changeSet>
 
+    <changeSet id="201312201601-TRUNK-4138" author="wyclif">
+        <preConditions onFail="MARK_RAN">
+            <foreignKeyConstraintExists foreignKeyName="user_who_discontinued_order" />
+        </preConditions>
+        <comment>Dropping fk constraint on orders.discontinued_by column to users.user_id column</comment>
+        <dropForeignKeyConstraint baseTableName="user_who_discontinued_order" />
+    </changeSet>
+
 	<changeSet id="201312201700-TRUNK-4138" author="banka">
         <preConditions onFail="MARK_RAN">
             <columnExists tableName="orders" columnName="discontinued_by"/>