H2Index: index on FILES(PATH,CONTAINER_ID), bug 415137
diff --git a/core/plugins/org.eclipse.dltk.core.index.sql.h2/resources/basic.sql b/core/plugins/org.eclipse.dltk.core.index.sql.h2/resources/basic.sql
index ab3bc81..222bfa7 100644
--- a/core/plugins/org.eclipse.dltk.core.index.sql.h2/resources/basic.sql
+++ b/core/plugins/org.eclipse.dltk.core.index.sql.h2/resources/basic.sql
@@ -15,4 +15,7 @@
TIMESTAMP BIGINT NOT NULL,
CONTAINER_ID INT NOT NULL,
FOREIGN KEY(CONTAINER_ID) REFERENCES CONTAINERS(ID) ON UPDATE CASCADE ON DELETE CASCADE,
-);
\ No newline at end of file
+);
+
+CREATE INDEX IDX_FILES_PATH_CONTAINER ON FILES(PATH, CONTAINER_ID);
+
diff --git a/core/plugins/org.eclipse.dltk.core.index.sql.h2/src/org/eclipse/dltk/internal/core/index/sql/h2/Schema.java b/core/plugins/org.eclipse.dltk.core.index.sql.h2/src/org/eclipse/dltk/internal/core/index/sql/h2/Schema.java
index 5a3181c..f0f1751 100644
--- a/core/plugins/org.eclipse.dltk.core.index.sql.h2/src/org/eclipse/dltk/internal/core/index/sql/h2/Schema.java
+++ b/core/plugins/org.eclipse.dltk.core.index.sql.h2/src/org/eclipse/dltk/internal/core/index/sql/h2/Schema.java
@@ -39,7 +39,7 @@
*/
public class Schema {
- public static final String VERSION = "0.7"; //$NON-NLS-1$
+ public static final String VERSION = "0.7.1"; //$NON-NLS-1$
/** Contains already created tables names */
private static final Set<String> TABLES_CACHE = new HashSet<String>();
