diff options
| author | Simon Brandhof <simon.brandhof@sonarsource.com> | 2016-10-12 23:08:47 +0200 |
|---|---|---|
| committer | Simon Brandhof <simon.brandhof@sonarsource.com> | 2016-10-13 12:18:42 +0200 |
| commit | 5975e1771500cef122160c35a648cd712b60a252 (patch) | |
| tree | 6d3ba4074f10ab861a0fd8a4a8351040811d96c7 /sonar-db/src/test/resources/org | |
| parent | 1a169ae32047cf9da7bb43bfc7ce1765faebd3fc (diff) | |
| download | sonarqube-5975e1771500cef122160c35a648cd712b60a252.tar.gz sonarqube-5975e1771500cef122160c35a648cd712b60a252.zip | |
SONAR-8134 populate column group_roles.organization_uuid on upgrade
Diffstat (limited to 'sonar-db/src/test/resources/org')
| -rw-r--r-- | sonar-db/src/test/resources/org/sonar/db/version/v62/PopulateOrganizationUuidOfGroupRolesTest/group_roles.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sonar-db/src/test/resources/org/sonar/db/version/v62/PopulateOrganizationUuidOfGroupRolesTest/group_roles.sql b/sonar-db/src/test/resources/org/sonar/db/version/v62/PopulateOrganizationUuidOfGroupRolesTest/group_roles.sql new file mode 100644 index 00000000000..775ab11911e --- /dev/null +++ b/sonar-db/src/test/resources/org/sonar/db/version/v62/PopulateOrganizationUuidOfGroupRolesTest/group_roles.sql @@ -0,0 +1,21 @@ +CREATE TABLE "GROUP_ROLES" ( + "ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), + "ORGANIZATION_UUID" VARCHAR(40), + "GROUP_ID" INTEGER, + "RESOURCE_ID" INTEGER, + "ROLE" VARCHAR(64) NOT NULL +); + +CREATE INDEX "GROUP_ROLES_RESOURCE" ON "GROUP_ROLES" ("RESOURCE_ID"); + +CREATE UNIQUE INDEX "UNIQ_GROUP_ROLES" ON "GROUP_ROLES" ("GROUP_ID", "RESOURCE_ID", "ROLE"); + +CREATE TABLE "INTERNAL_PROPERTIES" ( + "KEE" VARCHAR(50) NOT NULL PRIMARY KEY, + "IS_EMPTY" BOOLEAN NOT NULL, + "TEXT_VALUE" VARCHAR(4000), + "CLOB_VALUE" CLOB, + "CREATED_AT" BIGINT +); + +CREATE UNIQUE INDEX "UNIQ_INTERNAL_PROPERTIES" ON "INTERNAL_PROPERTIES" ("KEE"); |