diff options
| author | Michal Duda <michal.duda@sonarsource.com> | 2020-10-09 14:25:55 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2020-10-16 20:07:40 +0000 |
| commit | 4d8f0c4bf3214a0a36e15ada2a8b1090543eaf8e (patch) | |
| tree | 0806728aaa059a3b1f1b3c908bcf2dc8ef098ec1 /server/sonar-db-dao/src/schema | |
| parent | 276abb42335b4609f922bbf7c289cc26bb98f302 (diff) | |
| download | sonarqube-4d8f0c4bf3214a0a36e15ada2a8b1090543eaf8e.tar.gz sonarqube-4d8f0c4bf3214a0a36e15ada2a8b1090543eaf8e.zip | |
SONAR-13936 Remove use of organizations in Groups
Diffstat (limited to 'server/sonar-db-dao/src/schema')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index 25052cb6ecc..eba030939d8 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -325,14 +325,14 @@ CREATE INDEX "GROUP_ROLES_COMPONENT_UUID" ON "GROUP_ROLES"("COMPONENT_UUID"); CREATE UNIQUE INDEX "UNIQ_GROUP_ROLES" ON "GROUP_ROLES"("GROUP_UUID", "COMPONENT_UUID", "ROLE"); CREATE TABLE "GROUPS"( - "ORGANIZATION_UUID" VARCHAR(40) NOT NULL, - "NAME" VARCHAR(500), + "NAME" VARCHAR(500) NOT NULL, "DESCRIPTION" VARCHAR(200), "CREATED_AT" TIMESTAMP, "UPDATED_AT" TIMESTAMP, "UUID" VARCHAR(40) NOT NULL ); ALTER TABLE "GROUPS" ADD CONSTRAINT "PK_GROUPS" PRIMARY KEY("UUID"); +CREATE UNIQUE INDEX "UNIQ_GROUPS_NAME" ON "GROUPS"("NAME"); CREATE TABLE "GROUPS_USERS"( "GROUP_UUID" VARCHAR(40) NOT NULL, |