diff options
| author | Simon Brandhof <simon.brandhof@gmail.com> | 2013-12-19 10:25:22 +0100 |
|---|---|---|
| committer | Simon Brandhof <simon.brandhof@gmail.com> | 2013-12-19 10:25:34 +0100 |
| commit | a8bbab1909e278e6d0a6d1c69e42ca088a60244f (patch) | |
| tree | dc5c50316a9b440db60204c2e458461c413df5a4 /sonar-server/src/main/webapp/WEB-INF | |
| parent | 001e5dfa8cf023561cde1f92c995adb7e7b46c65 (diff) | |
| download | sonarqube-a8bbab1909e278e6d0a6d1c69e42ca088a60244f.tar.gz sonarqube-a8bbab1909e278e6d0a6d1c69e42ca088a60244f.zip | |
SONAR-4950 add unique index on GROUP_ROLES
Diffstat (limited to 'sonar-server/src/main/webapp/WEB-INF')
| -rw-r--r-- | sonar-server/src/main/webapp/WEB-INF/db/migrate/482_add_unique_constraint_to_group_roles.rb | 2 |
1 files changed, 2 insertions, 0 deletions
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 |