Fixes Issue 12078: Business partner could not be deleted because of a constraint
authorHarikrishnan Raja <harikrishnan.raja@openbravo.com>
Mon, 11 Oct 2010 11:56:52 +0530
changeset 8508 ecd5a5db58bd
parent 8507 2ae1dcc889dc
child 8509 979c2d69343d
Fixes Issue 12078: Business partner could not be deleted because of a constraint
src-db/database/model/tables/AD_USER.xml
--- a/src-db/database/model/tables/AD_USER.xml	Mon Oct 11 11:47:28 2010 +0530
+++ b/src-db/database/model/tables/AD_USER.xml	Mon Oct 11 11:56:52 2010 +0530
@@ -152,7 +152,7 @@
       <foreign-key foreignTable="AD_ORG" name="AD_USER_AD_ORGTRX">
         <reference local="AD_ORGTRX_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_BPARTNER" name="AD_USER_C_BPARTNER">
+      <foreign-key foreignTable="C_BPARTNER" name="AD_USER_C_BPARTNER" onDelete="cascade">
         <reference local="C_BPARTNER_ID" foreign="C_BPARTNER_ID"/>
       </foreign-key>
       <foreign-key foreignTable="C_BPARTNER_LOCATION" name="AD_USER_C_BPARTNER_LOCATION">