diff options
| author | Daniel Schwarz <daniel.schwarz@sonarsource.com> | 2017-03-01 13:49:20 +0100 |
|---|---|---|
| committer | Daniel Schwarz <bartfastiel@users.noreply.github.com> | 2017-03-03 16:57:17 +0100 |
| commit | 85f7fcad4280c797f580dc2ceaf5d029092cd9c1 (patch) | |
| tree | b0e3383b08980ebe9ba05598c598d67cf0cb0e10 /server/sonar-db-core | |
| parent | 01b4e8235eea4f1b4e78809a774279e71d7f0d5c (diff) | |
| download | sonarqube-85f7fcad4280c797f580dc2ceaf5d029092cd9c1.tar.gz sonarqube-85f7fcad4280c797f580dc2ceaf5d029092cd9c1.zip | |
SONAR-8857 add organisation uuid to quality profile database table
Diffstat (limited to 'server/sonar-db-core')
| -rw-r--r-- | server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql | 5 | ||||
| -rw-r--r-- | server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl | 3 |
2 files changed, 7 insertions, 1 deletions
diff --git a/server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql b/server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql index ca981dba0c0..1ecd670a4c8 100644 --- a/server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql +++ b/server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql @@ -534,6 +534,11 @@ INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1517'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1600'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1601'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1602'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1603'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1604'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1605'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1606'); INSERT INTO USERS(ID, LOGIN, NAME, EMAIL, EXTERNAL_IDENTITY, EXTERNAL_IDENTITY_PROVIDER, USER_LOCAL, CRYPTED_PASSWORD, SALT, IS_ROOT, CREATED_AT, UPDATED_AT) VALUES (1, 'admin', 'Administrator', '', 'admin', 'sonarqube', true, 'a373a0e667abb2604c1fd571eb4ad47fe8cc0878', '48bc4b0d93179b5103fd3885ea9119498e9d161b', false, '1418215735482', '1418215735482'); ALTER TABLE USERS ALTER COLUMN ID RESTART WITH 2; diff --git a/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl b/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl index c23180d5a44..3b50a832c0b 100644 --- a/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl +++ b/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl @@ -40,6 +40,7 @@ CREATE TABLE "RULES_PROFILES" ( "ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), "NAME" VARCHAR(100) NOT NULL, "LANGUAGE" VARCHAR(20), + "ORGANIZATION_UUID" VARCHAR(40) NOT NULL, "KEE" VARCHAR(255) NOT NULL, "PARENT_KEE" VARCHAR(255), "RULES_UPDATED_AT" VARCHAR(100), @@ -49,7 +50,7 @@ CREATE TABLE "RULES_PROFILES" ( "LAST_USED" BIGINT, "USER_UPDATED_AT" BIGINT ); -CREATE UNIQUE INDEX "UNIQ_QPROF_KEY" ON "RULES_PROFILES" ("KEE"); +CREATE UNIQUE INDEX "UNIQ_QPROF_ORG_AND_KEY" ON "RULES_PROFILES" ("ORGANIZATION_UUID", "KEE"); CREATE TABLE "PROJECT_QPROFILES" ( |