Fixes issue 0018099: Sometimes a deadlock appear when syncrhonizing a and processing orders at the same time
authorAdrián Romero <adrianromero@openbravo.com>
Wed, 27 Jul 2011 13:58:06 +0200
changeset 9591 086ee81793cf
parent 9590 cba8150a1b95
child 9592 6a214598625f
Fixes issue 0018099: Sometimes a deadlock appear when syncrhonizing a and processing orders at the same time
It has been removed two unnecesary foreing keys to avoid the deadlock
src-db/database/model/tables/I_ORDER.xml
--- a/src-db/database/model/tables/I_ORDER.xml	Wed Jul 27 12:19:53 2011 +0200
+++ b/src-db/database/model/tables/I_ORDER.xml	Wed Jul 27 13:58:06 2011 +0200
@@ -311,9 +311,6 @@
       <foreign-key foreignTable="C_ACTIVITY" name="I_ORDER_C_ACTIVITY">
         <reference local="C_ACTIVITY_ID" foreign="C_ACTIVITY_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_BPARTNER" name="I_ORDER_C_BPARTNER">
-        <reference local="C_BPARTNER_ID" foreign="C_BPARTNER_ID"/>
-      </foreign-key>
       <foreign-key foreignTable="C_BPARTNER_LOCATION" name="I_ORDER_C_BPARTNER_LOCATION">
         <reference local="C_BPARTNER_LOCATION_ID" foreign="C_BPARTNER_LOCATION_ID"/>
       </foreign-key>
@@ -359,9 +356,6 @@
       <foreign-key foreignTable="M_PRICELIST" name="I_ORDER_M_PRICELIST">
         <reference local="M_PRICELIST_ID" foreign="M_PRICELIST_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="M_PRODUCT" name="I_ORDER_M_PRODUCT">
-        <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
-      </foreign-key>
       <foreign-key foreignTable="M_SHIPPER" name="I_ORDER_M_SHIPPER">
         <reference local="M_SHIPPER_ID" foreign="M_SHIPPER_ID"/>
       </foreign-key>