details: https://code.openbravo.com/erp/devel/pi/rev/149e5d9ac93d
changeset: 33612:149e5d9ac93d
user: David Miguelez <david.miguelez <at> openbravo.com>
date: Tue Feb 27 12:59:41 2018 +0100
summary: Related to issue 37357. Removed unnecessary index.
There is already a similar index, with the c_order_id included.
This index is not needed since the other one is used (orderlines are
also filtered by order)
diffstat:
src-db/database/model/tables/C_ORDERLINE.xml | 3 ---
1 files changed, 0 insertions(+), 3 deletions(-)
diffs (13 lines):
diff -r 43e5679d96fd -r 149e5d9ac93d
src-db/database/model/tables/C_ORDERLINE.xml
--- a/src-db/database/model/tables/C_ORDERLINE.xml Fri Feb 23 14:26:31
2018 +0530
+++ b/src-db/database/model/tables/C_ORDERLINE.xml Tue Feb 27 12:59:41
2018 +0100
@@ -400,9 +400,6 @@
<index-column name="C_ORDER_ID"/>
<index-column name="functionBasedColumn"
functionExpression="OBEQUALS(QTYDELIVERED,QTYINVOICED)"/>
</index>
- <index name="C_ORDERLINE_ORDERED_INVOICED" unique="false">
- <index-column name="functionBasedColumn"
functionExpression="OBEQUALS(QTYORDERED,QTYINVOICED)"/>
- </index>
<index name="C_ORDERLINE_PRODUCT" unique="false">
<index-column name="M_PRODUCT_ID"/>
</index>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits