From a8bbab1909e278e6d0a6d1c69e42ca088a60244f Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Thu, 19 Dec 2013 10:25:22 +0100 Subject: [PATCH] SONAR-4950 add unique index on GROUP_ROLES --- .../db/migrate/482_add_unique_constraint_to_group_roles.rb | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sonar-server/src/main/webapp/WEB-INF/db/migrate/482_add_unique_constraint_to_group_roles.rb b/sonar-server/src/main/webapp/WEB-INF/db/migrate/482_add_unique_constraint_to_group_roles.rb index 62752d2ad27..161b786996b 100644 --- a/sonar-server/src/main/webapp/WEB-INF/db/migrate/482_add_unique_constraint_to_group_roles.rb +++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/482_add_unique_constraint_to_group_roles.rb @@ -40,5 +40,7 @@ class AddUniqueConstraintToGroupRoles < ActiveRecord::Migration end end end + + add_index 'group_roles', ['group_id', 'resource_id', 'role'], :unique => true, :name => 'uniq_group_roles' end end -- 2.39.5