diff options
| author | Duarte Meneses <duarte.meneses@sonarsource.com> | 2021-10-18 16:21:38 -0500 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2021-11-09 20:03:15 +0000 |
| commit | 8f6a40a2c3e066865f64955636683ac482b50526 (patch) | |
| tree | ca88ad23a516b56a786d15f80ae88654cb3d96db /server/sonar-db-dao/src/schema | |
| parent | 6bd7a4fd3a9fcbed5367add7ba9f616531ced342 (diff) | |
| download | sonarqube-8f6a40a2c3e066865f64955636683ac482b50526.tar.gz sonarqube-8f6a40a2c3e066865f64955636683ac482b50526.zip | |
SONAR-15498 DB schema and WS supports project branches selection in portfolios
Diffstat (limited to 'server/sonar-db-dao/src/schema')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 11 |
1 files changed, 10 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 7a9d8390bba..8591380930a 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -564,6 +564,14 @@ CREATE TABLE "PLUGINS"( ALTER TABLE "PLUGINS" ADD CONSTRAINT "PK_PLUGINS" PRIMARY KEY("UUID"); CREATE UNIQUE INDEX "PLUGINS_KEY" ON "PLUGINS"("KEE"); +CREATE TABLE "PORTFOLIO_PROJ_BRANCHES"( + "UUID" VARCHAR(40) NOT NULL, + "PORTFOLIO_PROJECT_UUID" VARCHAR(40) NOT NULL, + "BRANCH_KEY" VARCHAR(255) NOT NULL, + "CREATED_AT" BIGINT NOT NULL +); +ALTER TABLE "PORTFOLIO_PROJ_BRANCHES" ADD CONSTRAINT "PK_PORTFOLIO_PROJ_BRANCHES" PRIMARY KEY("UUID"); + CREATE TABLE "PORTFOLIO_PROJECTS"( "UUID" VARCHAR(40) NOT NULL, "PORTFOLIO_UUID" VARCHAR(40) NOT NULL, @@ -593,7 +601,8 @@ CREATE TABLE "PORTFOLIOS"( "SELECTION_MODE" VARCHAR(50) NOT NULL, "SELECTION_EXPRESSION" VARCHAR(4000), "CREATED_AT" BIGINT NOT NULL, - "UPDATED_AT" BIGINT NOT NULL + "UPDATED_AT" BIGINT NOT NULL, + "BRANCH_NAME" VARCHAR(255) ); ALTER TABLE "PORTFOLIOS" ADD CONSTRAINT "PK_PORTFOLIOS" PRIMARY KEY("UUID"); CREATE UNIQUE INDEX "UNIQ_PORTFOLIOS_KEE" ON "PORTFOLIOS"("KEE"); |