Fixed issue 32498 added index in M_PRODUCT_CH_VALUE
authorSandra Huguet <sandra.huguet@openbravo.com>
Thu, 17 Mar 2016 10:45:05 +0100
changeset 28952 f4c4839dfc48
parent 28951 8f4273ae4ccd
child 28953 0a46b38a4b04
child 29161 e7d73e95cf43
Fixed issue 32498 added index in M_PRODUCT_CH_VALUE

added index in M_PRODUCT_CH_VALUE to improve characteristic performance
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"/>