diff options
| author | Wojtek Wajerowicz <115081248+wojciech-wajerowicz-sonarsource@users.noreply.github.com> | 2022-11-24 19:45:16 +0100 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2022-12-08 20:02:58 +0000 |
| commit | 77e8af2605811bf1d13532585ec18ecb602970a5 (patch) | |
| tree | 042b538ba97036a4d1603cbbd2026b80a2a9f8dd /server/sonar-db-dao/src/schema/schema-sq.ddl | |
| parent | bd23178bb85c8eca984ad63fda153567ee8b222e (diff) | |
| download | sonarqube-77e8af2605811bf1d13532585ec18ecb602970a5.tar.gz sonarqube-77e8af2605811bf1d13532585ec18ecb602970a5.zip | |
SONAR-17645 Support user commissioning and decomissioning through SCIM for Okta
Diffstat (limited to 'server/sonar-db-dao/src/schema/schema-sq.ddl')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 7 |
1 files changed, 7 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 023646e06ff..eb1660e6ef6 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -920,6 +920,13 @@ CREATE TABLE "SCANNER_ANALYSIS_CACHE"( ); ALTER TABLE "SCANNER_ANALYSIS_CACHE" ADD CONSTRAINT "PK_SCANNER_ANALYSIS_CACHE" PRIMARY KEY("BRANCH_UUID"); +CREATE TABLE "SCIM_USERS"( + "SCIM_UUID" CHARACTER VARYING(40) NOT NULL, + "USER_UUID" CHARACTER VARYING(40) NOT NULL +); +ALTER TABLE "SCIM_USERS" ADD CONSTRAINT "PK_SCIM_USERS" PRIMARY KEY("SCIM_UUID"); +CREATE UNIQUE INDEX "UNIQ_SCIM_USERS_USER_UUID" ON "SCIM_USERS"("USER_UUID" NULLS FIRST); + CREATE TABLE "SESSION_TOKENS"( "UUID" CHARACTER VARYING(40) NOT NULL, "USER_UUID" CHARACTER VARYING(255) NOT NULL, |