From ceab93145b3f90c1b1ccaeb2c624e6680bca91ce Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Tue, 3 Apr 2012 12:09:39 +0200 Subject: Add missing indices on RESOURCE_INDEX --- .../webapp/WEB-INF/db/migrate/285_add_resource_index_primary_key.rb | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/sonar-server/src/main/webapp/WEB-INF/db/migrate/285_add_resource_index_primary_key.rb b/sonar-server/src/main/webapp/WEB-INF/db/migrate/285_add_resource_index_primary_key.rb index 01231a9d2bc..3b0180903c9 100644 --- a/sonar-server/src/main/webapp/WEB-INF/db/migrate/285_add_resource_index_primary_key.rb +++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/285_add_resource_index_primary_key.rb @@ -48,7 +48,8 @@ class AddResourceIndexPrimaryKey < ActiveRecord::Migration t.column 'root_project_id', :integer, :null => false t.column 'qualifier', :string, :limit => 10, :null => false end - + add_index 'resource_index', 'kee', :name => 'resource_index_key' + add_index 'resource_index', 'resource_id', :name => 'resource_index_rid' end end -- cgit v1.2.3