details:   https://code.openbravo.com/erp/stable/2.50/rev/086ee81793cf
changeset: 9591:086ee81793cf
user:      Adrián Romero <adrianromero <at> openbravo.com>
date:      Wed Jul 27 13:58:06 2011 +0200
summary:   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

diffstat:

 src-db/database/model/tables/I_ORDER.xml |  6 ------
 1 files changed, 0 insertions(+), 6 deletions(-)

diffs (23 lines):

diff -r cba8150a1b95 -r 086ee81793cf 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>

------------------------------------------------------------------------------
Got Input?   Slashdot Needs You.
Take our quick survey online.  Come on, we don't ask for help often.
Plus, you'll get a chance to win $100 to spend on ThinkGeek.
http://p.sf.net/sfu/slashdot-survey
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to