From be652549aac881f0db55ee1ca7cb4871cc4babd5 Mon Sep 17 00:00:00 2001 From: Pierre Date: Wed, 10 Nov 2021 11:10:31 +0100 Subject: SONAR-13426 add project_badge_token table --- server/sonar-db-dao/src/schema/schema-sq.ddl | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'server/sonar-db-dao/src') diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index eb874b033a9..8958e1331f5 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -623,6 +623,15 @@ CREATE UNIQUE INDEX "UNIQ_PROJECT_ALM_SETTINGS" ON "PROJECT_ALM_SETTINGS"("PROJE CREATE INDEX "PROJECT_ALM_SETTINGS_ALM" ON "PROJECT_ALM_SETTINGS"("ALM_SETTING_UUID"); CREATE INDEX "PROJECT_ALM_SETTINGS_SLUG" ON "PROJECT_ALM_SETTINGS"("ALM_SLUG"); +CREATE TABLE "PROJECT_BADGE_TOKEN"( + "UUID" VARCHAR(40) NOT NULL, + "TOKEN" VARCHAR(255) NOT NULL, + "PROJECT_UUID" VARCHAR(40) NOT NULL, + "CREATED_AT" BIGINT NOT NULL, + "UPDATED_AT" BIGINT NOT NULL +); +ALTER TABLE "PROJECT_BADGE_TOKEN" ADD CONSTRAINT "PK_PROJECT_BADGE_TOKEN" PRIMARY KEY("UUID"); + CREATE TABLE "PROJECT_BRANCHES"( "UUID" VARCHAR(50) NOT NULL, "PROJECT_UUID" VARCHAR(50) NOT NULL, -- cgit v1.2.3