details: https://code.openbravo.com/erp/devel/pi/rev/a09d6ae570dd
changeset: 31106:a09d6ae570dd
user: Andy <collazoandy4 <at> gmail.com>
date: Fri Jan 13 12:25:24 2017 -0500
summary: Fixed issue 34874: Added an index in fin_payment.fin_rev_payment_id
Added an index in fin_payment.fin_rev_payment_id to improve the performance
diffstat:
src-db/database/model/tables/FIN_PAYMENT.xml | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diffs (14 lines):
diff -r a75ea21e11ec -r a09d6ae570dd
src-db/database/model/tables/FIN_PAYMENT.xml
--- a/src-db/database/model/tables/FIN_PAYMENT.xml Mon Jan 16 13:15:25
2017 -0500
+++ b/src-db/database/model/tables/FIN_PAYMENT.xml Fri Jan 13 12:25:24
2017 -0500
@@ -190,6 +190,10 @@
<index name="FIN_PAYMENT_POSTED" unique="false">
<index-column name="POSTED"/>
</index>
+ <index name="FIN_PAYMENT_REVERSEPAYMENT" unique="false">
+ <index-column name="FIN_REV_PAYMENT_ID"/>
+ <index-column name="FIN_PAYMENT_ID"/>
+ </index>
<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>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
