From 89ab883abdf49d899598608c69359b0139ffb68a Mon Sep 17 00:00:00 2001 From: Duarte Meneses Date: Wed, 21 Aug 2019 11:29:17 -0500 Subject: [PATCH] New Code Period table --- server/sonar-db-dao/src/schema/schema-sq.ddl | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index 0c1d1f69281..9f5c9f136b8 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -403,6 +403,18 @@ CREATE TABLE METRICS( ALTER TABLE METRICS ADD CONSTRAINT PK_METRICS PRIMARY KEY(ID); CREATE UNIQUE INDEX METRICS_UNIQUE_NAME ON METRICS(NAME); +CREATE TABLE NEW_CODE_PERIODS( + UUID VARCHAR(40) NOT NULL, + PROJECT_UUID VARCHAR(40), + BRANCH_UUID VARCHAR(40), + TYPE VARCHAR(30) NOT NULL, + VALUE VARCHAR(40), + UPDATED_AT BIGINT NOT NULL, + CREATED_AT BIGINT NOT NULL +); +ALTER TABLE NEW_CODE_PERIODS ADD CONSTRAINT PK_NEW_CODE_PERIODS PRIMARY KEY(UUID); +CREATE UNIQUE INDEX UNIQ_NEW_CODE_PERIODS ON NEW_CODE_PERIODS(PROJECT_UUID, BRANCH_UUID); + CREATE TABLE NOTIFICATIONS( ID INTEGER NOT NULL AUTO_INCREMENT (1,1), DATA BLOB -- 2.39.5