diff options
| author | Julien Lancelot <julien.lancelot@sonarsource.com> | 2016-01-07 10:23:09 +0100 |
|---|---|---|
| committer | Julien Lancelot <julien.lancelot@sonarsource.com> | 2016-01-07 11:04:30 +0100 |
| commit | 93598d6f84ba12c14150f160604605c68b568272 (patch) | |
| tree | 6e9e087337d0225ed39c61b0130ba9652d5d1c7c /sonar-db | |
| parent | 36619d7c9a56bef27d2430b77685e7a4f65abb55 (diff) | |
| download | sonarqube-93598d6f84ba12c14150f160604605c68b568272.tar.gz sonarqube-93598d6f84ba12c14150f160604605c68b568272.zip | |
SONAR-7176 Add index on CE_QUEUE.COMPONENT_UUID
Diffstat (limited to 'sonar-db')
3 files changed, 4 insertions, 1 deletions
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 85915c7b673..86084385665 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 = 1006; + public static final int LAST_VERSION = 1007; /** * 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 363a767dccd..4de613385f4 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 @@ -367,6 +367,7 @@ INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1003'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1004'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1005'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1006'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1007'); INSERT INTO USERS(ID, LOGIN, NAME, EMAIL, CRYPTED_PASSWORD, SALT, CREATED_AT, UPDATED_AT, REMEMBER_TOKEN, REMEMBER_TOKEN_EXPIRES_AT) VALUES (1, 'admin', 'Administrator', '', '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 036d03b4c69..42a3c21d3e9 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 @@ -705,6 +705,8 @@ CREATE UNIQUE INDEX "UNIQ_PROJECT_QPROFILES" ON "PROJECT_QPROFILES" ("PROJECT_UU CREATE UNIQUE INDEX "CE_QUEUE_UUID" ON "CE_QUEUE" ("UUID"); +CREATE INDEX "CE_QUEUE_COMPONENT_UUID" ON "CE_QUEUE" ("COMPONENT_UUID"); + CREATE UNIQUE INDEX "CE_ACTIVITY_UUID" ON "CE_ACTIVITY" ("UUID"); CREATE INDEX "CE_ACTIVITY_COMPONENT_UUID" ON "CE_ACTIVITY" ("COMPONENT_UUID"); |