From c82e8cbcf642d844dec206ed2b12d3fed383a098 Mon Sep 17 00:00:00 2001 From: Julien Lancelot Date: Wed, 22 May 2013 15:17:42 +0200 Subject: [PATCH] SONAR-3755 Remove index on issues.project_id --- .../src/main/resources/org/sonar/core/persistence/schema-h2.ddl | 2 -- .../src/main/webapp/WEB-INF/db/migrate/398_create_issues.rb | 1 - 2 files changed, 3 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 8f5fb36dc4a..a451c3ce6e6 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 @@ -679,8 +679,6 @@ CREATE UNIQUE INDEX "ISSUES_KEE" ON "ISSUES" ("KEE"); CREATE INDEX "ISSUES_RESOURCE_ID" ON "ISSUES" ("RESOURCE_ID"); -CREATE INDEX "ISSUES_PROJECT_ID" ON "ISSUES" ("PROJECT_ID"); - CREATE INDEX "ISSUES_RULE_ID" ON "ISSUES" ("RULE_ID"); CREATE INDEX "ISSUES_SEVERITY" ON "ISSUES" ("SEVERITY"); diff --git a/sonar-server/src/main/webapp/WEB-INF/db/migrate/398_create_issues.rb b/sonar-server/src/main/webapp/WEB-INF/db/migrate/398_create_issues.rb index 548fadaab18..4f60847a2cb 100644 --- a/sonar-server/src/main/webapp/WEB-INF/db/migrate/398_create_issues.rb +++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/398_create_issues.rb @@ -55,7 +55,6 @@ class CreateIssues < ActiveRecord::Migration add_index :issues, :kee, :name => 'issues_kee', :unique => true add_index :issues, :resource_id, :name => 'issues_resource_id' - add_index :issues, :project_id, :name => 'issues_project_id' add_index :issues, :rule_id, :name => 'issues_rule_id' add_index :issues, :severity, :name => 'issues_severity' add_index :issues, :status, :name => 'issues_status' -- 2.39.5