details: https://code.openbravo.com/erp/devel/pi/rev/409cf54877df
changeset: 22814:409cf54877df
user: Augusto Mauch <augusto.mauch <at> openbravo.com>
date: Wed Apr 02 10:38:53 2014 +0200
summary: Fixes issue 26139: Adds missing constraint in AD_TABLE_TREE table
The column obserds_datasource_id of the ad_table_tree is a foreign key to the
key column of the obserds_datasource. There should be a contraint to explicit
this in the database.
diffstat:
src-db/database/model/tables/AD_TABLE_TREE.xml | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diffs (13 lines):
diff -r b16bfb087dd5 -r 409cf54877df
src-db/database/model/tables/AD_TABLE_TREE.xml
--- a/src-db/database/model/tables/AD_TABLE_TREE.xml Wed Apr 02 10:35:54
2014 +0200
+++ b/src-db/database/model/tables/AD_TABLE_TREE.xml Wed Apr 02 10:38:53
2014 +0200
@@ -100,6 +100,9 @@
<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="OBSERDS_DATASOURCE"
name="AD_TABLETREE_DATASOURCE">
+ <reference local="OBSERDS_DATASOURCE_ID"
foreign="OBSERDS_DATASOURCE_ID"/>
+ </foreign-key>
<foreign-key foreignTable="AD_MODULE" name="AD_TABLTREE_AD_MODULE">
<reference local="AD_MODULE_ID" foreign="AD_MODULE_ID"/>
</foreign-key>
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
