Fixed issue 26468.Modified FK definition.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Tue, 06 May 2014 11:16:26 +0200
changeset 550 7335ef336f63
parent 549 d48bbec14105
child 551 c80c3e708e41
Fixed issue 26468.Modified FK definition.
model/src-db/database/model/tables/M_REQUISITIONORDER.xml
--- a/model/src-db/database/model/tables/M_REQUISITIONORDER.xml	Thu Apr 10 20:01:26 2014 +0530
+++ b/model/src-db/database/model/tables/M_REQUISITIONORDER.xml	Tue May 06 11:16:26 2014 +0200
@@ -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>