details: /erp/stable/2.50/rev/af5adef2ad21
changeset: 9438:af5adef2ad21
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Thu May 19 10:44:07 2011 +0200
summary: Fix db consistency issue in new constraint.
diffstat:
src-db/database/model/tables/FIN_PAYMENT.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 8b560d9f0ec9 -r af5adef2ad21
src-db/database/model/tables/FIN_PAYMENT.xml
--- a/src-db/database/model/tables/FIN_PAYMENT.xml Thu May 19 10:20:19
2011 +0200
+++ b/src-db/database/model/tables/FIN_PAYMENT.xml Thu May 19 10:44:07
2011 +0200
@@ -159,7 +159,7 @@
<foreign-key foreignTable="C_PROJECT" name="FIN_PAYMENT_PROJECT">
<reference local="C_PROJECT_ID" foreign="C_PROJECT_ID"/>
</foreign-key>
- <check name="FIN_PAYMENT_BP_CREDIT_CHECK"><![CDATA[(C_BPARTNER_ID IS
NULL AND COALESCE(GENERATED_CREDIT, 0) = 0) OR C_BPARTNER_ID IS NOT
NULL]]></check>
+ <check name="FIN_PAYMENT_BP_CREDIT_CHECK"><![CDATA[((C_BPARTNER_ID IS
NULL) AND (COALESCE(GENERATED_CREDIT, 0) = 0)) OR (C_BPARTNER_ID IS NOT
NULL)]]></check>
<check name="FIN_PAYMENT_CREATE_ALGORIT_CHK"><![CDATA[CREATEDBYALGORITHM
IN ('Y', 'N')]]></check>
<check name="FIN_PAYMENT_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y',
'N')]]></check>
</table>
------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its
next-generation tools to help Windows* and Linux* C/C++ and Fortran
developers boost performance applications - including clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
