From b84084cf0d8024d49a29b997bf0dc138bebcd3ec Mon Sep 17 00:00:00 2001 From: Julien Lancelot Date: Fri, 7 Nov 2014 12:48:55 +0100 Subject: [PATCH] SONAR-4950 Add missing unique index in the H3 schema --- .../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 608e80bc6db..1b23e14f193 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 @@ -671,6 +671,8 @@ CREATE INDEX "SNAPSHOTS_ROOT_PROJECT_ID" ON "SNAPSHOTS" ("ROOT_PROJECT_ID"); CREATE INDEX "GROUP_ROLES_ROLE" ON "GROUP_ROLES" ("ROLE"); +CREATE UNIQUE INDEX "UNIQ_GROUP_ROLES" ON "GROUP_ROLES" ("GROUP_ID", "RESOURCE_ID", "ROLE"); + CREATE UNIQUE INDEX "RULES_REPO_KEY" ON "RULES" ("PLUGIN_NAME", "PLUGIN_RULE_KEY"); CREATE INDEX "CHARACTERISTICS_ENABLED" ON "CHARACTERISTICS" ("ENABLED"); -- 2.39.5