aboutsummaryrefslogtreecommitdiffstats
path: root/sonar-core/src
diff options
context:
space:
mode:
authorSimon Brandhof <simon.brandhof@gmail.com>2012-07-10 14:33:10 +0200
committerSimon Brandhof <simon.brandhof@gmail.com>2012-07-10 14:33:10 +0200
commit62605521a60e03ad03dd5698bf09f43fd90097df (patch)
tree9770e3246e71f277fd8451cd2293a85ef708de16 /sonar-core/src
parentd5750f0bd49bc82d8ba18daebb104cc45a400f90 (diff)
downloadsonarqube-62605521a60e03ad03dd5698bf09f43fd90097df.tar.gz
sonarqube-62605521a60e03ad03dd5698bf09f43fd90097df.zip
Add missing H2 index on PROJECTS.ROOT_ID
Diffstat (limited to 'sonar-core/src')
-rw-r--r--sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl2
1 files changed, 2 insertions, 0 deletions
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");