[Tree Extension] Adds on delete cascade to AD_REF_TREE and AD_TABLE_TREE
authorAugusto Mauch <augusto.mauch@openbravo.com>
Mon, 24 Feb 2014 09:52:55 +0100
changeset 22549 c77f6d16bf13
parent 22548 d01d2681f08c
child 22550 92d823da3866
[Tree Extension] Adds on delete cascade to AD_REF_TREE and AD_TABLE_TREE
src-db/database/model/tables/AD_REF_TREE.xml
src-db/database/model/tables/AD_TABLE_TREE.xml
--- a/src-db/database/model/tables/AD_REF_TREE.xml	Mon Feb 24 09:32:37 2014 +0100
+++ b/src-db/database/model/tables/AD_REF_TREE.xml	Mon Feb 24 09:52:55 2014 +0100
@@ -84,7 +84,7 @@
       <foreign-key foreignTable="AD_MODULE" name="AD_REF_TREE_MODULE" onDelete="cascade">
         <reference local="AD_MODULE_ID" foreign="AD_MODULE_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="AD_REF_TREE_TABLE">
+      <foreign-key foreignTable="AD_TABLE" name="AD_REF_TREE_TABLE" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_TABLE_TREE" name="AD_REF_TREE_TABTREE" onDelete="cascade">
--- a/src-db/database/model/tables/AD_TABLE_TREE.xml	Mon Feb 24 09:32:37 2014 +0100
+++ b/src-db/database/model/tables/AD_TABLE_TREE.xml	Mon Feb 24 09:52:55 2014 +0100
@@ -97,7 +97,7 @@
       <foreign-key foreignTable="AD_ORG" name="AD_TABLETREE_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="AD_TABLETREE_AD_TABLE">
+      <foreign-key foreignTable="AD_TABLE" name="AD_TABLETREE_AD_TABLE" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_MODULE" name="AD_TABLTREE_AD_MODULE">