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

Reply via email to