From dd9ad9bb3a6f4c8b86f83177bc2a743e3f504a4f Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Tue, 8 Mar 2016 15:05:06 +0100 Subject: SONAR-7379 Drop inefficient index ISSUES_SEVERITY --- sonar-db/src/main/java/org/sonar/db/version/DatabaseVersion.java | 2 +- sonar-db/src/main/resources/org/sonar/db/version/rows-h2.sql | 1 + sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl | 2 -- 3 files changed, 2 insertions(+), 3 deletions(-) (limited to 'sonar-db/src') diff --git a/sonar-db/src/main/java/org/sonar/db/version/DatabaseVersion.java b/sonar-db/src/main/java/org/sonar/db/version/DatabaseVersion.java index 67b823778ac..b0c7ac94eb8 100644 --- a/sonar-db/src/main/java/org/sonar/db/version/DatabaseVersion.java +++ b/sonar-db/src/main/java/org/sonar/db/version/DatabaseVersion.java @@ -29,7 +29,7 @@ import org.sonar.db.MyBatis; public class DatabaseVersion { - public static final int LAST_VERSION = 1114; + public static final int LAST_VERSION = 1115; /** * The minimum supported version which can be upgraded. Lower diff --git a/sonar-db/src/main/resources/org/sonar/db/version/rows-h2.sql b/sonar-db/src/main/resources/org/sonar/db/version/rows-h2.sql index 76ad5e03d09..f44bf0fccd1 100644 --- a/sonar-db/src/main/resources/org/sonar/db/version/rows-h2.sql +++ b/sonar-db/src/main/resources/org/sonar/db/version/rows-h2.sql @@ -392,6 +392,7 @@ INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1111'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1112'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1113'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1114'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1115'); INSERT INTO USERS(ID, LOGIN, NAME, EMAIL, EXTERNAL_IDENTITY, EXTERNAL_IDENTITY_PROVIDER, CRYPTED_PASSWORD, SALT, CREATED_AT, UPDATED_AT, REMEMBER_TOKEN, REMEMBER_TOKEN_EXPIRES_AT) VALUES (1, 'admin', 'Administrator', '', 'admin', 'sonarqube', 'a373a0e667abb2604c1fd571eb4ad47fe8cc0878', '48bc4b0d93179b5103fd3885ea9119498e9d161b', '1418215735482', '1418215735482', null, null); ALTER TABLE USERS ALTER COLUMN ID RESTART WITH 2; diff --git a/sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl b/sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl index e6116e12792..af42d8ac7a3 100644 --- a/sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl +++ b/sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl @@ -637,8 +637,6 @@ CREATE INDEX "ISSUES_PROJECT_UUID" ON "ISSUES" ("PROJECT_UUID"); CREATE INDEX "ISSUES_RULE_ID" ON "ISSUES" ("RULE_ID"); -CREATE INDEX "ISSUES_SEVERITY" ON "ISSUES" ("SEVERITY"); - CREATE INDEX "ISSUES_RESOLUTION" ON "ISSUES" ("RESOLUTION"); CREATE INDEX "ISSUES_ASSIGNEE" ON "ISSUES" ("ASSIGNEE"); -- cgit v1.2.3