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 | 18 |
1 files changed, 18 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 b2bd8e58ffe..9c0dd073f9f 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -826,6 +826,24 @@ CREATE TABLE "QUALITY_GATES"( ); ALTER TABLE "QUALITY_GATES" ADD CONSTRAINT "PK_QUALITY_GATES" PRIMARY KEY("UUID"); +CREATE TABLE "REPORT_SCHEDULES"( + "UUID" CHARACTER VARYING(40) NOT NULL, + "PORTFOLIO_UUID" CHARACTER VARYING(40), + "BRANCH_UUID" CHARACTER VARYING(40), + "LAST_SEND_TIME_IN_MS" BIGINT NOT NULL +); +ALTER TABLE "REPORT_SCHEDULES" ADD CONSTRAINT "PK_REPORT_SCHEDULES" PRIMARY KEY("UUID"); +CREATE UNIQUE INDEX "UNIQ_REPORT_SCHEDULES" ON "REPORT_SCHEDULES"("PORTFOLIO_UUID" NULLS FIRST, "BRANCH_UUID" NULLS FIRST); + +CREATE TABLE "REPORT_SUBSCRIPTIONS"( + "UUID" CHARACTER VARYING(40) NOT NULL, + "PORTFOLIO_UUID" CHARACTER VARYING(40), + "BRANCH_UUID" CHARACTER VARYING(40), + "USER_UUID" CHARACTER VARYING(40) NOT NULL +); +ALTER TABLE "REPORT_SUBSCRIPTIONS" ADD CONSTRAINT "PK_REPORT_SUBSCRIPTIONS" PRIMARY KEY("UUID"); +CREATE UNIQUE INDEX "UNIQ_REPORT_SUBSCRIPTIONS" ON "REPORT_SUBSCRIPTIONS"("PORTFOLIO_UUID" NULLS FIRST, "BRANCH_UUID" NULLS FIRST, "USER_UUID" NULLS FIRST); + CREATE TABLE "RULE_DESC_SECTIONS"( "UUID" CHARACTER VARYING(40) NOT NULL, "RULE_UUID" CHARACTER VARYING(40) NOT NULL, |