# HG changeset patch
# User Atul Gaware <atul.gaware@openbravo.com>
# Date 1455599676 -19800
#      Tue Feb 16 10:44:36 2016 +0530
# Node ID 71e6846a5626f5a027e7eabf87be9a9ade169546
# Parent  8410c9a28ed6a05345aabec9362e2400ecb3bf19
Fixes Issue 32205: Deleting a line on the order line window
takes long on environment with big amount of data

Foreign keys for following columns to the same table orderline 
removed
- ref_orderline_id
- quotationline_id
- bom_parent_id

diff -r 8410c9a28ed6 -r 71e6846a5626 src-db/database/model/tables/C_ORDERLINE.xml
--- a/src-db/database/model/tables/C_ORDERLINE.xml	Wed Feb 17 12:35:01 2016 +0530
+++ b/src-db/database/model/tables/C_ORDERLINE.xml	Tue Feb 16 10:44:36 2016 +0530
@@ -290,9 +290,6 @@
       <foreign-key foreignTable="AD_ORG" name="C_ORDERLINE_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_ORDERLINE" name="C_ORDERLINE_BOMPARENTID">
-        <reference local="BOM_PARENT_ID" foreign="C_ORDERLINE_ID"/>
-      </foreign-key>
       <foreign-key foreignTable="C_BPARTNER" name="C_ORDERLINE_C_BPARTNER">
         <reference local="C_BPARTNER_ID" foreign="C_BPARTNER_ID"/>
       </foreign-key>
@@ -347,15 +344,9 @@
       <foreign-key foreignTable="M_WAREHOUSE" name="C_ORDERLINE_M_WAREHOUSE">
         <reference local="M_WAREHOUSE_ID" foreign="M_WAREHOUSE_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_ORDERLINE" name="C_ORDERLINE_QUOTATION">
-        <reference local="QUOTATIONLINE_ID" foreign="C_ORDERLINE_ID"/>
-      </foreign-key>
       <foreign-key foreignTable="S_RESOURCEASSIGNMENT" name="C_ORDERLINE_S_RESOURCEASSIGNME">
         <reference local="S_RESOURCEASSIGNMENT_ID" foreign="S_RESOURCEASSIGNMENT_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_ORDERLINE" name="C_ORDERLINE_SOPOREF">
-        <reference local="REF_ORDERLINE_ID" foreign="C_ORDERLINE_ID"/>
-      </foreign-key>
       <foreign-key foreignTable="USER1" name="C_ORDERLINE_USER1">
         <reference local="USER1_ID" foreign="USER1_ID"/>
       </foreign-key>