diff options
| author | Belen Pruvost <belen.pruvost@sonarsource.com> | 2021-10-13 15:41:19 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2021-10-22 20:03:27 +0000 |
| commit | cae2da28bfa432b9ec440219b514b057f5897c4f (patch) | |
| tree | 98199b4b48b56f5092ea8d4016eacdca6784109b /server/sonar-db-dao/src | |
| parent | 2972be1b1bfc8b3cdd974cab9fb85c89f7e05597 (diff) | |
| download | sonarqube-cae2da28bfa432b9ec440219b514b057f5897c4f.tar.gz sonarqube-cae2da28bfa432b9ec440219b514b057f5897c4f.zip | |
SONAR-15441 - Create table for qgate_group_permissions
Diffstat (limited to 'server/sonar-db-dao/src')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 9 |
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 2d69105804f..2d9f8ca32fd 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -714,6 +714,15 @@ CREATE TABLE "PROPERTIES"( ALTER TABLE "PROPERTIES" ADD CONSTRAINT "PK_PROPERTIES" PRIMARY KEY("UUID"); CREATE INDEX "PROPERTIES_KEY" ON "PROPERTIES"("PROP_KEY"); +CREATE TABLE "QGATE_GROUP_PERMISSIONS"( + "UUID" VARCHAR(40) NOT NULL, + "QUALITY_GATE_UUID" VARCHAR(40) NOT NULL, + "GROUP_UUID" VARCHAR(40) NOT NULL, + "CREATED_AT" BIGINT NOT NULL +); +ALTER TABLE "QGATE_GROUP_PERMISSIONS" ADD CONSTRAINT "PK_QGATE_GROUP_PERMISSIONS" PRIMARY KEY("UUID"); +CREATE INDEX "QG_GROUPS_UUID_IDX" ON "QGATE_GROUP_PERMISSIONS"("QUALITY_GATE_UUID"); + CREATE TABLE "QGATE_USER_PERMISSIONS"( "UUID" VARCHAR(40) NOT NULL, "QUALITY_GATE_UUID" VARCHAR(40) NOT NULL, |