diff options
| author | Pierre <pierre.guillot@sonarsource.com> | 2020-04-20 09:53:17 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2020-05-25 20:05:21 +0000 |
| commit | ac532a55b9c7ee51b8ad3516103b453f030392d6 (patch) | |
| tree | 44c32aa7e245542fc1e105f339890e2b0a08d46d /server/sonar-db-dao/src/schema/schema-sq.ddl | |
| parent | 16b2b85fc200856e65175663bbe2477012be9275 (diff) | |
| download | sonarqube-ac532a55b9c7ee51b8ad3516103b453f030392d6.tar.gz sonarqube-ac532a55b9c7ee51b8ad3516103b453f030392d6.zip | |
SONAR-13221 change PK of quality gates from id to uuid, update FKs, update API
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, 3 insertions, 5 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index 4712533869b..62d4ba46945 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -769,7 +769,6 @@ CREATE INDEX "QPROFILE_EDIT_USERS_QPROFILE" ON "QPROFILE_EDIT_USERS"("QPROFILE_U CREATE UNIQUE INDEX "QPROFILE_EDIT_USERS_UNIQUE" ON "QPROFILE_EDIT_USERS"("USER_ID", "QPROFILE_UUID"); CREATE TABLE "QUALITY_GATE_CONDITIONS"( - "QGATE_ID" INTEGER, "PERIOD" INTEGER, "OPERATOR" VARCHAR(3), "VALUE_ERROR" VARCHAR(64), @@ -777,20 +776,19 @@ CREATE TABLE "QUALITY_GATE_CONDITIONS"( "CREATED_AT" TIMESTAMP, "UPDATED_AT" TIMESTAMP, "UUID" VARCHAR(40) NOT NULL, - "METRIC_UUID" VARCHAR(40) NOT NULL + "METRIC_UUID" VARCHAR(40) NOT NULL, + "QGATE_UUID" VARCHAR(40) NOT NULL ); ALTER TABLE "QUALITY_GATE_CONDITIONS" ADD CONSTRAINT "PK_QUALITY_GATE_CONDITIONS" PRIMARY KEY("UUID"); CREATE TABLE "QUALITY_GATES"( - "ID" INTEGER NOT NULL AUTO_INCREMENT (1,1), "UUID" VARCHAR(40) NOT NULL, "NAME" VARCHAR(100) NOT NULL, "IS_BUILT_IN" BOOLEAN NOT NULL, "CREATED_AT" TIMESTAMP, "UPDATED_AT" TIMESTAMP ); -ALTER TABLE "QUALITY_GATES" ADD CONSTRAINT "PK_QUALITY_GATES" PRIMARY KEY("ID"); -CREATE UNIQUE INDEX "UNIQ_QUALITY_GATES_UUID" ON "QUALITY_GATES"("UUID"); +ALTER TABLE "QUALITY_GATES" ADD CONSTRAINT "PK_QUALITY_GATES" PRIMARY KEY("UUID"); CREATE TABLE "RULE_REPOSITORIES"( "KEE" VARCHAR(200) NOT NULL, |