details: https://code.openbravo.com/erp/devel/pi/rev/7b398b3fba78
changeset: 20128:7b398b3fba78
user: Augusto Mauch <augusto.mauch <at> openbravo.com>
date: Wed Apr 17 15:08:59 2013 +0200
summary: Fixes issue 23571: Added missing index
And index has been added to the m_storage_detail table.
diffstat:
src-db/database/model/tables/M_STORAGE_DETAIL.xml | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diffs (13 lines):
diff -r efbfc531da73 -r 7b398b3fba78
src-db/database/model/tables/M_STORAGE_DETAIL.xml
--- a/src-db/database/model/tables/M_STORAGE_DETAIL.xml Wed Apr 17 12:48:34
2013 +0200
+++ b/src-db/database/model/tables/M_STORAGE_DETAIL.xml Wed Apr 17 15:08:59
2013 +0200
@@ -94,6 +94,9 @@
<foreign-key foreignTable="M_PRODUCT_UOM"
name="M_STORAGE_DETAIL_M_PRODUCT_UOM">
<reference local="M_PRODUCT_UOM_ID" foreign="M_PRODUCT_UOM_ID"/>
</foreign-key>
+ <index name="M_STORAGE_DETAIL_LOCATOR" unique="false">
+ <index-column name="M_LOCATOR_ID"/>
+ </index>
<index name="M_STORAGE_DETAIL_PRODUCT" unique="false">
<index-column name="M_PRODUCT_ID"/>
</index>
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
