diff options
| author | Sébastien Lesaint <sebastien.lesaint@sonarsource.com> | 2016-01-19 19:04:58 +0100 |
|---|---|---|
| committer | Sébastien Lesaint <sebastien.lesaint@sonarsource.com> | 2016-01-20 14:46:14 +0100 |
| commit | bbda3cfd4c3463509430a0d9cf4e283167c9769a (patch) | |
| tree | 115823d689aa1e4962b45bfc4089dcf6472b40ce /sonar-db | |
| parent | 59c1b3d49a6f4c43ebfadd1310e7bea52c911a99 (diff) | |
| download | sonarqube-bbda3cfd4c3463509430a0d9cf4e283167c9769a.tar.gz sonarqube-bbda3cfd4c3463509430a0d9cf4e283167c9769a.zip | |
add index on project_measures.person_id
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 4593d40db8c..b5f895b29ab 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 = 1009; + public static final int LAST_VERSION = 1010; /** * 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 775d65c4fe3..c629c8113d2 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 @@ -371,6 +371,7 @@ INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1006'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1007'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1008'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1009'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1010'); 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 42a3c21d3e9..0db4c0881af 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 @@ -589,6 +589,8 @@ CREATE UNIQUE INDEX "GROUPS_USERS_UNIQUE" ON "GROUPS_USERS" ("GROUP_ID", "USER_I CREATE INDEX "MEASURES_SID_METRIC" ON "PROJECT_MEASURES" ("SNAPSHOT_ID", "METRIC_ID"); +CREATE INDEX "MEASURES_PERSON" ON "PROJECT_MEASURES" ("PERSON_ID"); + CREATE UNIQUE INDEX "METRICS_UNIQUE_NAME" ON "METRICS" ("NAME"); CREATE INDEX "EVENTS_SNAPSHOT_ID" ON "EVENTS" ("SNAPSHOT_ID"); |