From ed50d0636f78948fdc36cdc086cabe5eafe54c2d Mon Sep 17 00:00:00 2001
From: Steve Marion <unknown>
Date: Thu, 20 Jul 2023 15:17:54 +0200
Subject: SONAR-19372 add anticipated_transitions table

---
 server/sonar-db-dao/src/schema/schema-sq.ddl | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'server/sonar-db-dao/src/schema')

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,
-- 
cgit v1.2.3