diff options
| author | Jacek <jacek.poreda@sonarsource.com> | 2020-04-28 09:16:46 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2020-05-25 20:05:21 +0000 |
| commit | 8d7585051ae8a3ec4edad6e8f1a0428b9f5ff192 (patch) | |
| tree | 5d3f557240fbd5a7e70d2bd2f1cd19f5efd0e78e /server/sonar-db-dao/src/schema/schema-sq.ddl | |
| parent | 3d4a3d278a957142a3d10f216b9a430b89f40607 (diff) | |
| download | sonarqube-8d7585051ae8a3ec4edad6e8f1a0428b9f5ff192.tar.gz sonarqube-8d7585051ae8a3ec4edad6e8f1a0428b9f5ff192.zip | |
SONAR-13221 change USERS_GROUPS user_id FK to user_uuid
Diffstat (limited to 'server/sonar-db-dao/src/schema/schema-sq.ddl')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index 62d4ba46945..434c991da89 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -333,12 +333,12 @@ CREATE TABLE "GROUPS"( ALTER TABLE "GROUPS" ADD CONSTRAINT "PK_GROUPS" PRIMARY KEY("UUID"); CREATE TABLE "GROUPS_USERS"( - "USER_ID" BIGINT, - "GROUP_UUID" VARCHAR(40) NOT NULL + "GROUP_UUID" VARCHAR(40) NOT NULL, + "USER_UUID" VARCHAR(40) NOT NULL ); -CREATE INDEX "INDEX_GROUPS_USERS_ON_USER_ID" ON "GROUPS_USERS"("USER_ID"); CREATE INDEX "INDEX_GROUPS_USERS_GROUP_UUID" ON "GROUPS_USERS"("GROUP_UUID"); -CREATE UNIQUE INDEX "GROUPS_USERS_UNIQUE" ON "GROUPS_USERS"("GROUP_UUID", "USER_ID"); +CREATE INDEX "INDEX_GROUPS_USERS_USER_UUID" ON "GROUPS_USERS"("USER_UUID"); +CREATE UNIQUE INDEX "GROUPS_USERS_UNIQUE" ON "GROUPS_USERS"("USER_UUID", "GROUP_UUID"); CREATE TABLE "INTERNAL_COMPONENT_PROPS"( "UUID" VARCHAR(40) NOT NULL, |