Fixes Issue 25177: Add Constraint to update C_InvoiceLine_ID to null when deleting the invoice line
authorPandeeswari Ramakrishnan <pandeeswari.ramakrishnan@openbravo.com>
Tue, 19 Nov 2013 13:44:12 +0530
changeset 526 c4b23df10e10
parent 525 a37b680d8227
child 527 5f21f98bdbde
Fixes Issue 25177: Add Constraint to update C_InvoiceLine_ID to null when deleting the invoice line
model/src-db/database/model/tables/S_TIMEEXPENSELINE.xml
--- a/model/src-db/database/model/tables/S_TIMEEXPENSELINE.xml	Mon Nov 18 13:48:50 2013 +0000
+++ b/model/src-db/database/model/tables/S_TIMEEXPENSELINE.xml	Tue Nov 19 13:44:12 2013 +0530
@@ -163,7 +163,7 @@
       <foreign-key foreignTable="C_CURRENCY" name="S_TIMEEXPENSELINE_C_CURRENCY">
         <reference local="C_CURRENCY_ID" foreign="C_CURRENCY_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_INVOICELINE" name="S_TIMEEXPENSELINE_C_INVOICELIN">
+      <foreign-key foreignTable="C_INVOICELINE" name="S_TIMEEXPENSELINE_C_INVOICELIN" onDelete="setnull">
         <reference local="C_INVOICELINE_ID" foreign="C_INVOICELINE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="C_ORDERLINE" name="S_TIMEEXPENSELINE_C_ORDERLINE">