Fixed 7405
authorStefan Hühner <stefan.huehner@openbravo.com>
Mon, 09 Feb 2009 18:34:07 +0000
changeset 3034 dfc7d481301d
parent 3033 af5309ad09cb
child 3035 2329f0a48785
Fixed 7405
Add two missing indexes to speed up production
src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml
src-db/database/model/tables/M_COSTING.xml
--- a/src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml	Mon Feb 09 17:33:08 2009 +0000
+++ b/src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml	Mon Feb 09 18:34:07 2009 +0000
@@ -95,6 +95,9 @@
       <foreign-key foreignTable="M_PRODUCT_UOM" name="MPRODUCTUOMID_MASEQPRODUCT">
         <reference local="M_PRODUCT_UOM_ID" foreign="M_PRODUCT_UOM_ID"/>
       </foreign-key>
+      <index name="MA_SEQ_PROD_SEQ_ID" unique="false">
+        <index-column name="MA_SEQUENCE_ID"/>
+      </index>
       <check name="MA_SEQUENCEPROD_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/M_COSTING.xml	Mon Feb 09 17:33:08 2009 +0000
+++ b/src-db/database/model/tables/M_COSTING.xml	Mon Feb 09 18:34:07 2009 +0000
@@ -103,5 +103,8 @@
       <foreign-key foreignTable="M_INOUTLINE" name="MINOUTLINE_MCOSTING">
         <reference local="M_INOUTLINE_ID" foreign="M_INOUTLINE_ID"/>
       </foreign-key>
+      <index name="M_COSTING_M_PRODUCT_ID" unique="false">
+        <index-column name="M_PRODUCT_ID"/>
+      </index>
     </table>
   </database>