From 7d8052837730ed748a0dd48f647395a81e2a8d1e Mon Sep 17 00:00:00 2001 From: Jacek <52388493+jacek-poreda-sonarsource@users.noreply.github.com> Date: Fri, 19 Jul 2019 10:59:07 +0200 Subject: SONAR-8115 Storing default qgate in table (blue green deploy safety) (#1925) * add DDL for project_qgate table * support saving/update/delete to project quality gate and properties * add db migration tests --- .../src/main/resources/org/sonar/db/version/schema-h2.ddl | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'server/sonar-db-core') diff --git a/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl b/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl index b4553e23eaa..af7c91f6c75 100644 --- a/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl +++ b/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl @@ -313,6 +313,14 @@ CREATE TABLE "ORG_QUALITY_GATES" ( ); CREATE UNIQUE INDEX "UNIQ_ORG_QUALITY_GATES" ON "ORG_QUALITY_GATES" ("ORGANIZATION_UUID","QUALITY_GATE_UUID"); +CREATE TABLE "PROJECT_QGATES" ( +"PROJECT_UUID" VARCHAR(40) NOT NULL, +"QUALITY_GATE_UUID" VARCHAR(40) NOT NULL, + +CONSTRAINT "PK_PROJECT_QGATES" PRIMARY KEY ("PROJECT_UUID") +); +CREATE UNIQUE INDEX "UNIQ_PROJECT_QGATES" ON "PROJECT_QGATES" ("PROJECT_UUID", "QUALITY_GATE_UUID"); + CREATE TABLE "PROPERTIES" ( "ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), "PROP_KEY" VARCHAR(512) NOT NULL, -- cgit v1.2.3