false positive: change in FK from no action to delete cascade and set null
authorAsier Lostalé <asier.lostale@openbravo.com>
Wed, 23 Jul 2014 07:58:16 +0200
changeset 566 4f64f24a7c0f
parent 565 be1d431cfe98
child 567 6cef4ed56fd2
false positive: change in FK from no action to delete cascade and set null
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	Tue Jul 15 10:31:03 2014 +0200
+++ b/model/src-db/database/model/tables/AD_CLIENTINFO.xml	Wed Jul 23 07:58:16 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	Tue Jul 15 10:31:03 2014 +0200
+++ b/model/src-db/database/model/tables/AD_TREE.xml	Wed Jul 23 07:58:16 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">