changeset:   35598:d85f5ab36bf0
tag:         tip
user:        Ioritz Cia <ioritz.cia@openbravo.com>
date:        Mon Nov 25 16:50:11 2019 +0100
summary:     [Upgrade task 533] Create index to improve queries over c_import_entry

diff -r 15c1d48bf5c0 -r d85f5ab36bf0 src-db/database/model/tables/C_IMPORT_ENTRY.xml
--- a/src-db/database/model/tables/C_IMPORT_ENTRY.xml	Mon Nov 25 12:01:17 2019 +0100
+++ b/src-db/database/model/tables/C_IMPORT_ENTRY.xml	Mon Nov 25 16:50:11 2019 +0100
@@ -78,5 +78,9 @@
         <index-column name="IMPORTSTATUS"/>
         <index-column name="CREATED"/>
       </index>
+      <index name="C_IMPORT_ENTRY_TYPE_STATUS" unique="false">
+        <index-column name="TYPEOFDATA"/>
+        <index-column name="IMPORTSTATUS"/>
+      </index>
     </table>
   </database>