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 | 8 |
1 files changed, 8 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 8d0ad1275a1..94c89f05103 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -357,6 +357,14 @@ CREATE TABLE "GITHUB_ORGS_GROUPS"( ); ALTER TABLE "GITHUB_ORGS_GROUPS" ADD CONSTRAINT "PK_GITHUB_ORGS_GROUPS" PRIMARY KEY("GROUP_UUID"); +CREATE TABLE "GITHUB_PERMS_MAPPING"( + "UUID" CHARACTER VARYING(40) NOT NULL, + "GITHUB_ROLE" CHARACTER VARYING(100) NOT NULL, + "SONARQUBE_ROLE" CHARACTER VARYING(64) NOT NULL +); +ALTER TABLE "GITHUB_PERMS_MAPPING" ADD CONSTRAINT "PK_GITHUB_PERMS_MAPPING" PRIMARY KEY("UUID"); +CREATE UNIQUE NULLS DISTINCT INDEX "UNIQ_GITHUB_PERM_MAPPINGS" ON "GITHUB_PERMS_MAPPING"("GITHUB_ROLE" NULLS FIRST, "SONARQUBE_ROLE" NULLS FIRST); + CREATE TABLE "GROUP_ROLES"( "UUID" CHARACTER VARYING(40) NOT NULL, "ROLE" CHARACTER VARYING(64) NOT NULL, |