diff options
| author | OrlovAlexander <alexander.orlov@sonarsource.com> | 2024-11-05 16:48:04 +0100 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2024-11-11 20:02:43 +0000 |
| commit | 2659be50a7dee7cc410106fe861b0385340889b0 (patch) | |
| tree | b74a5261feaf6e2e6c94199db29b28834a5b95f2 /server/sonar-db-dao/src/schema | |
| parent | 191245551be3efdd1f2e9dbb6128cd3f252b951c (diff) | |
| download | sonarqube-2659be50a7dee7cc410106fe861b0385340889b0.tar.gz sonarqube-2659be50a7dee7cc410106fe861b0385340889b0.zip | |
SONAR-23363 Database Migration for manual_severity flag
Diffstat (limited to 'server/sonar-db-dao/src/schema')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index 272b1c156a1..b6a46b9bc40 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -511,7 +511,8 @@ ALTER TABLE "ISSUES_FIXED" ADD CONSTRAINT "PK_ISSUES_FIXED" PRIMARY KEY("PULL_RE CREATE TABLE "ISSUES_IMPACTS"( "ISSUE_KEY" CHARACTER VARYING(40) NOT NULL, "SOFTWARE_QUALITY" CHARACTER VARYING(40) NOT NULL, - "SEVERITY" CHARACTER VARYING(40) NOT NULL + "SEVERITY" CHARACTER VARYING(40) NOT NULL, + "MANUAL_SEVERITY" BOOLEAN DEFAULT FALSE NOT NULL ); ALTER TABLE "ISSUES_IMPACTS" ADD CONSTRAINT "PK_ISSUES_IMPACTS" PRIMARY KEY("ISSUE_KEY", "SOFTWARE_QUALITY"); CREATE UNIQUE NULLS NOT DISTINCT INDEX "UNIQ_ISS_KEY_SOF_QUAL" ON "ISSUES_IMPACTS"("ISSUE_KEY" NULLS FIRST, "SOFTWARE_QUALITY" NULLS FIRST); |