Fixes Issue 23902: A index missing affecting the m_inout_post process
authorShankar Balachandran <shankar.balachandran@openbravo.com>
Tue, 28 May 2013 11:11:50 +0530
changeset 20478 ded79d8fb1d0
parent 20477 51de13657be6
child 20479 4b94b5a758f8
Fixes Issue 23902: A index missing affecting the m_inout_post process

An index has been added on m_storage_detail.
src-db/database/model/tables/M_STORAGE_DETAIL.xml
--- a/src-db/database/model/tables/M_STORAGE_DETAIL.xml	Tue May 28 10:04:28 2013 +0530
+++ b/src-db/database/model/tables/M_STORAGE_DETAIL.xml	Tue May 28 11:11:50 2013 +0530
@@ -100,6 +100,9 @@
       <index name="M_STORAGE_DETAIL_PRODUCT" unique="false">
         <index-column name="M_PRODUCT_ID"/>
       </index>
+      <index name="M_STORAGE_DETAIL_UOM" unique="false">
+        <index-column name="C_UOM_ID"/>
+      </index>
       <unique name="M_STORAGE_DETAIL_UN">
         <unique-column name="M_PRODUCT_ID"/>
         <unique-column name="M_LOCATOR_ID"/>