diff options
Diffstat (limited to 'server/sonar-db-dao/src/schema/schema-sq.ddl')
| -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"); |