details: https://code.openbravo.com/erp/devel/pi/rev/ba62d08c2411
changeset: 20455:ba62d08c2411
user: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
date: Thu May 23 11:07:17 2013 +0530
summary: Fixes Issue 23892 : Index missing on Fin_Payment_Schedule table.
Added an index for c_order_id field in Fin_Payment_Schedule table.
diffstat:
src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diffs (13 lines):
diff -r 72e94aea5ae8 -r ba62d08c2411
src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml
--- a/src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml Thu May 23
01:31:33 2013 +0200
+++ b/src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml Thu May 23
11:07:17 2013 +0530
@@ -109,6 +109,9 @@
<index name="FIN_PAYM_SCH_INV_IDX" unique="false">
<index-column name="C_INVOICE_ID"/>
</index>
+ <index name="FIN_PAYM_SCH_ORD_IDX" unique="false">
+ <index-column name="C_ORDER_ID"/>
+ </index>
<index name="FIN_PAYMENT_SCHEDULE_OUTAMT" unique="false">
<index-column name="OUTSTANDINGAMT"/>
</index>
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
