details:   https://code.openbravo.com/erp/devel/pi/rev/5591d21a0627
changeset: 33527:5591d21a0627
user:      David Miguelez <david.miguelez <at> openbravo.com>
date:      Wed Feb 21 12:53:07 2018 +0100
summary:   Related to issue 37357. Exported database to fix the order
of the indexes in the orderline table

diffstat:

 src-db/database/model/tables/C_ORDERLINE.xml |  6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diffs (20 lines):

diff -r 0e58ce180b7c -r 5591d21a0627 
src-db/database/model/tables/C_ORDERLINE.xml
--- a/src-db/database/model/tables/C_ORDERLINE.xml      Wed Feb 21 11:06:35 
2018 +0000
+++ b/src-db/database/model/tables/C_ORDERLINE.xml      Wed Feb 21 12:53:07 
2018 +0100
@@ -396,13 +396,13 @@
         <index-column name="C_ORDER_ID"/>
         <index-column name="functionBasedColumn" 
functionExpression="OBEQUALS(QTYORDERED,QTYINVOICED)"/>
       </index>
-      <index name="C_ORDERLINE_ORDERED_INVOICED" unique="false">
-        <index-column name="functionBasedColumn" 
functionExpression="OBEQUALS(QTYORDERED,QTYINVOICED)"/>
-      </index>
       <index name="C_ORDERLINE_ORDER2" unique="false">
         <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
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to