[Doubtful Debt] Adds missing fk constraints
authorEduardo Argal Guibert <eduardo.argal@openbravo.com>
Wed, 23 Jan 2013 20:10:27 +0100
changeset 19574 09a4805f5ffc
parent 19573 c08987499bab
child 19575 ff1e5f202a21
[Doubtful Debt] Adds missing fk constraints
src-db/database/model/tables/FIN_DOUBTFUL_DEBT_METHOD.xml
--- a/src-db/database/model/tables/FIN_DOUBTFUL_DEBT_METHOD.xml	Wed Jan 23 19:56:40 2013 +0100
+++ b/src-db/database/model/tables/FIN_DOUBTFUL_DEBT_METHOD.xml	Wed Jan 23 20:10:27 2013 +0100
@@ -49,5 +49,12 @@
         <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
+      <foreign-key foreignTable="AD_CLIENT" name="FIN_DOUBTFULDEBTMETHOD_CLIENT">
+        <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
+      </foreign-key>
+      <foreign-key foreignTable="AD_ORG" name="FIN_DOUBTFULDEBTMETHOD_ORG">
+        <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
+      </foreign-key>
+      <check name="FIN_DOUBTDEBTMETHOD_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>