details: https://code.openbravo.com/erp/devel/pi/rev/e7e49fefcf93
changeset: 35561:e7e49fefcf93
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Thu Mar 07 19:03:09 2019 +0530
summary: Fixes Issue 0039304: [SERQA 4539]: It would be nice have partial
indexes for REPLACEDORDER_ID and REPLACEMENTORDER_ID columns in
c_order table
** Added partial indexes for columns REPLACEDORDER_ID and
REPLACEMENTORDER_ID in C_Order table.
diffstat:
src-db/database/model/tables/C_ORDER.xml | 8 ++++++++
1 files changed, 8 insertions(+), 0 deletions(-)
diffs (18 lines):
diff -r 8fef3f886c45 -r e7e49fefcf93 src-db/database/model/tables/C_ORDER.xml
--- a/src-db/database/model/tables/C_ORDER.xml Mon Mar 25 22:17:37 2019 -0300
+++ b/src-db/database/model/tables/C_ORDER.xml Thu Mar 07 19:03:09 2019 +0530
@@ -507,6 +507,14 @@
<index-column name="QUOTATION_ID"/>
<whereClause><![CDATA[QUOTATION_ID IS NOT NULL]]></whereClause>
</index>
+ <index name="C_ORDER_REPLACEDORDER" unique="false">
+ <index-column name="REPLACEDORDER_ID"/>
+ <whereClause><![CDATA[REPLACEDORDER_ID IS NOT NULL]]></whereClause>
+ </index>
+ <index name="C_ORDER_REPLACEMENTORDER" unique="false">
+ <index-column name="REPLACEMENTORDER_ID"/>
+ <whereClause><![CDATA[REPLACEMENTORDER_ID IS NOT NULL]]></whereClause>
+ </index>
<index name="C_ORDER_SALESREP" unique="false">
<index-column name="SALESREP_ID"/>
<whereClause><![CDATA[SALESREP_ID IS NOT NULL]]></whereClause>
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
