details: https://code.openbravo.com/erp/devel/pi/rev/f4c4839dfc48
changeset: 28808:f4c4839dfc48
user: Sandra Huguet <sandra.huguet <at> openbravo.com>
date: Thu Mar 17 10:45:05 2016 +0100
summary: Fixed issue 32498 added index in M_PRODUCT_CH_VALUE
added index in M_PRODUCT_CH_VALUE to improve characteristic performance
diffstat:
src-db/database/model/tables/M_PRODUCT_CH_VALUE.xml | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diffs (13 lines):
diff -r 8f4273ae4ccd -r f4c4839dfc48
src-db/database/model/tables/M_PRODUCT_CH_VALUE.xml
--- a/src-db/database/model/tables/M_PRODUCT_CH_VALUE.xml Thu Mar 17
09:53:43 2016 +0000
+++ b/src-db/database/model/tables/M_PRODUCT_CH_VALUE.xml Thu Mar 17
10:45:05 2016 +0100
@@ -60,6 +60,9 @@
<foreign-key foreignTable="M_PRODUCT"
name="M_PRODUCT_CH_VALUE_M_PRODUCT">
<reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
</foreign-key>
+ <index name="M_PRODUCT_CH_VALUE_CHAR_ID" unique="false">
+ <index-column name="M_CHARACTERISTIC_ID"/>
+ </index>
<index name="M_PRODUCT_CH_VALUE_VALUE" unique="true">
<index-column name="M_PRODUCT_ID"/>
<index-column name="M_CH_VALUE_ID"/>
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785231&iu=/4140
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
