diff options
| author | Jacek <52388493+jacek-poreda-sonarsource@users.noreply.github.com> | 2019-07-19 10:59:07 +0200 |
|---|---|---|
| committer | SonarTech <sonartech@sonarsource.com> | 2019-07-19 20:21:15 +0200 |
| commit | 7d8052837730ed748a0dd48f647395a81e2a8d1e (patch) | |
| tree | 1676547a19c68ccddc98dca78e4a94b9cb63fe67 /server/sonar-db-core | |
| parent | bd954c8e77d79eaf23d7c8d3b681fa9af634004c (diff) | |
| download | sonarqube-7d8052837730ed748a0dd48f647395a81e2a8d1e.tar.gz sonarqube-7d8052837730ed748a0dd48f647395a81e2a8d1e.zip | |
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
Diffstat (limited to 'server/sonar-db-core')
| -rw-r--r-- | server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl | 8 |
1 files changed, 8 insertions, 0 deletions
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, |