reapplied changeset for FK false positive after Q3 realese
authorAsier Lostalé <asier.lostale@openbravo.com>
Wed, 06 Aug 2014 16:05:41 +0200
changeset 575 7366cc5cfc84
parent 574 70cc28bd9188
child 576 99de7d7493b2
reapplied changeset for FK false positive after Q3 realese
model/src-db/database/model/tables/AD_CLIENTINFO.xml
model/src-db/database/model/tables/AD_TREE.xml
--- a/model/src-db/database/model/tables/AD_CLIENTINFO.xml	Mon Aug 04 08:43:33 2014 +0200
+++ b/model/src-db/database/model/tables/AD_CLIENTINFO.xml	Wed Aug 06 16:05:41 2014 +0200
@@ -183,7 +183,7 @@
       <foreign-key foreignTable="AD_TREE" name="AD_CLIENTINFO_AD_TREE_MENU">
         <reference local="AD_TREE_MENU_ID" foreign="AD_TREE_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TREE" name="AD_CLIENTINFO_AD_TREE_OBRECAT">
+      <foreign-key foreignTable="AD_TREE" name="AD_CLIENTINFO_AD_TREE_OBRECAT" onDelete="setnull">
         <reference local="AD_TREE_OBRE_RESOURCE_CATEGORY" foreign="AD_TREE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_TREE" name="AD_CLIENTINFO_AD_TREE_ORG">
--- a/model/src-db/database/model/tables/AD_TREE.xml	Mon Aug 04 08:43:33 2014 +0200
+++ b/model/src-db/database/model/tables/AD_TREE.xml	Wed Aug 06 16:05:41 2014 +0200
@@ -59,7 +59,7 @@
       <foreign-key foreignTable="AD_ORG" name="AD_TREE_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="AD_TREE_AD_TABLE">
+      <foreign-key foreignTable="AD_TABLE" name="AD_TREE_AD_TABLE" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <unique name="AD_TREE_NAME">