Related To Issue 27194:API Change, Add unique constraint for Org, Warehouse
authorAtul Gaware <atul.gaware@openbravo.com>
Wed, 30 Jul 2014 15:01:57 +0530
changeset 569 9091788f82d3
parent 568 9f871961236f
child 570 661cf72176cd
Related To Issue 27194:API Change, Add unique constraint for Org, Warehouse
model/src-db/database/model/tables/AD_ORG_WAREHOUSE.xml
--- a/model/src-db/database/model/tables/AD_ORG_WAREHOUSE.xml	Wed Jul 30 08:18:22 2014 +0530
+++ b/model/src-db/database/model/tables/AD_ORG_WAREHOUSE.xml	Wed Jul 30 15:01:57 2014 +0530
@@ -53,6 +53,10 @@
       <index name="AD_ORGWAREHOUSE_ORG_IDX" unique="false">
         <index-column name="AD_ORG_ID"/>
       </index>
+      <unique name="AD_ORG_WAREHOUSE_WAREHOUSE_UN">
+      	<unique-column name="AD_ORG_ID"/>
+      	<unique-column name="M_WAREHOUSE_ID"/>
+      </unique>
       <check name="AD_ORG_WAREHOUSE_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>