Reapply cset 7335ef336f63 after Q2 release
authorStefan Huehner <stefan.huehner@openbravo.com>
Thu, 22 May 2014 11:51:27 +0000
changeset 558 1d31ccaa77de
parent 557 26def1e5b23b
child 559 450bcc30c03c
Reapply cset 7335ef336f63 after Q2 release
model/src-db/database/model/tables/M_REQUISITIONORDER.xml
--- a/model/src-db/database/model/tables/M_REQUISITIONORDER.xml	Thu May 22 11:32:51 2014 +0000
+++ b/model/src-db/database/model/tables/M_REQUISITIONORDER.xml	Thu May 22 11:51:27 2014 +0000
@@ -51,12 +51,15 @@
       <foreign-key foreignTable="AD_ORG" name="M_REQUISITIONORDER_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_ORDERLINE" name="M_REQUISITIONORDER_C_ORDERLINE">
+      <foreign-key foreignTable="C_ORDERLINE" name="M_REQUISITIONORDER_C_ORDERLINE" onDelete="cascade">
         <reference local="C_ORDERLINE_ID" foreign="C_ORDERLINE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="M_REQUISITIONLINE" name="M_REQUISITIONORDER_M_REQUISITI">
         <reference local="M_REQUISITIONLINE_ID" foreign="M_REQUISITIONLINE_ID"/>
       </foreign-key>
+      <index name="M_REQUISITIONORDER_ORDLINE_IDX" unique="false">
+        <index-column name="C_ORDERLINE_ID"/>
+      </index>
       <index name="M_REQUISITIONORDER_REQLINE_IDX" unique="false">
         <index-column name="M_REQUISITIONLINE_ID"/>
       </index>