diff options
| author | Jacek <jacek.poreda@sonarsource.com> | 2020-04-30 15:30:41 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2020-05-25 20:05:22 +0000 |
| commit | 584c92dff0d1d904c770ecace709bb6e6d895ec3 (patch) | |
| tree | e2147c6c235ccf7d06266ce2747bf100440ebd57 /server/sonar-db-dao/src/schema/schema-sq.ddl | |
| parent | 7925b2f67b87f0d3d6086a3b006e276341f70566 (diff) | |
| download | sonarqube-584c92dff0d1d904c770ecace709bb6e6d895ec3.tar.gz sonarqube-584c92dff0d1d904c770ecace709bb6e6d895ec3.zip | |
SONAR-13221 change QPROFILE_EDIT_USERS 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 | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index 9a09829ee26..129fc3b2f18 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -760,13 +760,13 @@ CREATE UNIQUE INDEX "QPROFILE_EDIT_GROUPS_UNIQUE" ON "QPROFILE_EDIT_GROUPS"("GRO CREATE TABLE "QPROFILE_EDIT_USERS"( "UUID" VARCHAR(40) NOT NULL, - "USER_ID" INTEGER NOT NULL, "QPROFILE_UUID" VARCHAR(255) NOT NULL, - "CREATED_AT" BIGINT NOT NULL + "CREATED_AT" BIGINT NOT NULL, + "USER_UUID" VARCHAR(40) NOT NULL ); ALTER TABLE "QPROFILE_EDIT_USERS" ADD CONSTRAINT "PK_QPROFILE_EDIT_USERS" PRIMARY KEY("UUID"); CREATE INDEX "QPROFILE_EDIT_USERS_QPROFILE" ON "QPROFILE_EDIT_USERS"("QPROFILE_UUID"); -CREATE UNIQUE INDEX "QPROFILE_EDIT_USERS_UNIQUE" ON "QPROFILE_EDIT_USERS"("USER_ID", "QPROFILE_UUID"); +CREATE UNIQUE INDEX "QPROFILE_EDIT_USERS_UNIQUE" ON "QPROFILE_EDIT_USERS"("USER_UUID", "QPROFILE_UUID"); CREATE TABLE "QUALITY_GATE_CONDITIONS"( "PERIOD" INTEGER, |