aboutsummaryrefslogtreecommitdiffstats
path: root/server/sonar-db-dao/src
diff options
context:
space:
mode:
authorPierre <pierre.guillot@sonarsource.com>2021-11-10 11:10:31 +0100
committersonartech <sonartech@sonarsource.com>2021-11-15 20:04:34 +0000
commitbe652549aac881f0db55ee1ca7cb4871cc4babd5 (patch)
treebb89798d17dbe4acbcb81b9c6fbce6d9b08f4f86 /server/sonar-db-dao/src
parent5dc2bc2d5b4baa68970f5b72d6814787a1eda6ba (diff)
downloadsonarqube-be652549aac881f0db55ee1ca7cb4871cc4babd5.tar.gz
sonarqube-be652549aac881f0db55ee1ca7cb4871cc4babd5.zip
SONAR-13426 add project_badge_token table
Diffstat (limited to 'server/sonar-db-dao/src')
-rw-r--r--server/sonar-db-dao/src/schema/schema-sq.ddl9
1 files changed, 9 insertions, 0 deletions
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,