aboutsummaryrefslogtreecommitdiffstats
path: root/server/sonar-db-dao/src/schema/schema-sq.ddl
diff options
context:
space:
mode:
Diffstat (limited to 'server/sonar-db-dao/src/schema/schema-sq.ddl')
-rw-r--r--server/sonar-db-dao/src/schema/schema-sq.ddl6
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,