Fixes Issue 21634 : Added Cascade delete to obuiapp_note.ad_table_id
authorShankar Balachandran <shankar.balachandran@openbravo.com>
Fri, 14 Sep 2012 12:13:37 +0200
changeset 17954 38acdd74058a
parent 17953 58436acaacef
child 17955 59a32d16a80f
Fixes Issue 21634 : Added Cascade delete to obuiapp_note.ad_table_id

Added onDelete Cascade to ad_table_id field in obuiapp_note table.
modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NOTE.xml
--- a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NOTE.xml	Mon Jun 11 12:39:53 2012 +0200
+++ b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NOTE.xml	Fri Sep 14 12:13:37 2012 +0200
@@ -51,7 +51,7 @@
       <foreign-key foreignTable="AD_ORG" name="OBUIAPP_NOTE_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="OBUIAPP_NOTE_AD_TABLE">
+      <foreign-key foreignTable="AD_TABLE" name="OBUIAPP_NOTE_AD_TABLE" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <index name="OBUIAPP_NOTE_AD_TABLE" unique="false">