Added liquibase changesets to rename orders.discontinued_reason and discontinued_reason_non_coded to order_reason and order_reason_non_coded respectively - TRUNK-4138

wluyima · wluyima · commit d4281f579226 · 2014-03-27T14:38:15.000-04:00
diff --git a/api/src/main/resources/liquibase-update-to-latest.xml b/api/src/main/resources/liquibase-update-to-latest.xml
@@ -7184,6 +7184,22 @@
 								 referencedTableName="users"/>
 	</changeSet>
 
+    <changeSet id="201402041601-TRUNK-4138" author="wyclif">
+        <preConditions onFail="MARK_RAN">
+            <columnExists columnName="discontinued_reason" tableName="orders" />
+        </preConditions>
+        <comment>Renaming orders.discontinued_reason column to order_reason</comment>
+        <renameColumn tableName="orders" newColumnName="order_reason" oldColumnName="discontinued_reason" columnDataType="int" />
+    </changeSet>
+
+    <changeSet id="201402041604-TRUNK-4138" author="wyclif">
+        <preConditions onFail="MARK_RAN">
+            <columnExists columnName="discontinued_reason_non_coded" tableName="orders" />
+        </preConditions>
+        <comment>Renaming orders.discontinued_reason_non_coded column to order_reason_non_coded</comment>
+        <renameColumn tableName="orders" newColumnName="order_reason_non_coded" oldColumnName="discontinued_reason_non_coded" columnDataType="varchar(255)" />
+    </changeSet>
+
     <changeSet id="201401161532-TRUNK-4202" author="k-joseph">
         <preConditions onFail="MARK_RAN">
             <not><sqlCheck expectedResult="0">select count(*) from orders</sqlCheck></not>
