diff options
| author | Wojtek Wajerowicz <115081248+wojciech-wajerowicz-sonarsource@users.noreply.github.com> | 2023-05-01 15:22:23 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2023-05-11 20:03:13 +0000 |
| commit | 63c1441080c51dbc2e390c3d826b2b8bcf73f10a (patch) | |
| tree | 6100b07d440b7ac2ded68d5f3cb666a4a84e16f5 /server/sonar-db-dao/src/schema/schema-sq.ddl | |
| parent | 09f0335614316c665021beca34d2006e0d02ee37 (diff) | |
| download | sonarqube-63c1441080c51dbc2e390c3d826b2b8bcf73f10a.tar.gz sonarqube-63c1441080c51dbc2e390c3d826b2b8bcf73f10a.zip | |
SONAR-19085 Create 'external_groups' table.
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 07f05419329..197259b24e8 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -311,6 +311,13 @@ ALTER TABLE "EVENTS" ADD CONSTRAINT "PK_EVENTS" PRIMARY KEY("UUID"); CREATE INDEX "EVENTS_ANALYSIS" ON "EVENTS"("ANALYSIS_UUID" NULLS FIRST); CREATE INDEX "EVENTS_COMPONENT_UUID" ON "EVENTS"("COMPONENT_UUID" NULLS FIRST); +CREATE TABLE "EXTERNAL_GROUPS"( + "GROUP_UUID" CHARACTER VARYING(40) NOT NULL, + "EXTERNAL_GROUP_ID" CHARACTER VARYING(255) NOT NULL, + "EXTERNAL_IDENTITY_PROVIDER" CHARACTER VARYING(100) NOT NULL +); +ALTER TABLE "EXTERNAL_GROUPS" ADD CONSTRAINT "PK_EXTERNAL_GROUPS" PRIMARY KEY("GROUP_UUID"); + CREATE TABLE "FILE_SOURCES"( "UUID" CHARACTER VARYING(40) NOT NULL, "PROJECT_UUID" CHARACTER VARYING(50) NOT NULL, |