From 62605521a60e03ad03dd5698bf09f43fd90097df Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Tue, 10 Jul 2012 14:33:10 +0200 Subject: [PATCH] Add missing H2 index on PROJECTS.ROOT_ID --- .../src/main/resources/org/sonar/core/persistence/schema-h2.ddl | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl b/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl index 60efa80788a..df9d24c9993 100644 --- a/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl +++ b/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl @@ -590,6 +590,8 @@ CREATE INDEX "MANUAL_MEASURES_RESOURCE_ID" ON "MANUAL_MEASURES" ("RESOURCE_ID"); CREATE INDEX "PROJECTS_KEE" ON "PROJECTS" ("KEE"); +CREATE INDEX "PROJECTS_ROOT_ID" ON "PROJECTS" ("ROOT_ID"); + CREATE INDEX "RESOURCE_INDEX_KEE" ON "RESOURCE_INDEX" ("KEE"); CREATE INDEX "RESOURCE_INDEX_RID" ON "RESOURCE_INDEX" ("RESOURCE_ID"); -- 2.39.5