diff options
| author | Steve Marion <unknown> | 2023-07-20 15:17:54 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2023-08-02 20:03:03 +0000 |
| commit | ed50d0636f78948fdc36cdc086cabe5eafe54c2d (patch) | |
| tree | 84b4c97622895d10cca7b1dc02d2bbe762486046 /server/sonar-db-dao/src/schema | |
| parent | 4f214cb37958b2cceddfe33c3bd10d7de260e219 (diff) | |
| download | sonarqube-ed50d0636f78948fdc36cdc086cabe5eafe54c2d.tar.gz sonarqube-ed50d0636f78948fdc36cdc086cabe5eafe54c2d.zip | |
SONAR-19372 add anticipated_transitions table
Diffstat (limited to 'server/sonar-db-dao/src/schema')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index f09fbe6fb2d..1ac97309e11 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -75,6 +75,20 @@ CREATE TABLE "ANALYSIS_PROPERTIES"( ALTER TABLE "ANALYSIS_PROPERTIES" ADD CONSTRAINT "PK_ANALYSIS_PROPERTIES" PRIMARY KEY("UUID"); CREATE INDEX "ANALYSIS_PROPERTIES_ANALYSIS" ON "ANALYSIS_PROPERTIES"("ANALYSIS_UUID" NULLS FIRST); +CREATE TABLE "ANTICIPATED_TRANSITIONS"( + "UUID" CHARACTER VARYING(40) NOT NULL, + "PROJECT_UUID" CHARACTER VARYING(40) NOT NULL, + "USER_UUID" CHARACTER VARYING(255) NOT NULL, + "TRANSITION" CHARACTER VARYING(20) NOT NULL, + "STATUS" CHARACTER VARYING(20) NOT NULL, + "TRANSITION_COMMENT" CHARACTER VARYING(4000), + "LINE" INTEGER, + "MESSAGE" CHARACTER VARYING(4000), + "LINE_HASH" CHARACTER VARYING(255), + "RULE_KEY" CHARACTER VARYING(200) NOT NULL +); +ALTER TABLE "ANTICIPATED_TRANSITIONS" ADD CONSTRAINT "PK_ANTICIPATED_TRANSITIONS" PRIMARY KEY("UUID"); + CREATE TABLE "APP_BRANCH_PROJECT_BRANCH"( "UUID" CHARACTER VARYING(40) NOT NULL, "APPLICATION_UUID" CHARACTER VARYING(40) NOT NULL, |