7a3932f969
* feat: oidc feat: organization switcher refactor: org context feat: invitations GLM * feat: link current account * refactor: own page for sso registration * feat: per-user account management * refactor: code style * refactor: user existing check * refactor: restrict provider configuration to super admins only * refactor: cleanup / pr review * chore: fix lint issues * chore: pr feedbacks * test(e2e): automated tests for OIDC * fix: check url first for sso provider identification * fix: prevent oidc provider to be named "credential"
15 lines
698 B
SQL
15 lines
698 B
SQL
CREATE TABLE `sso_provider` (
|
|
`id` text PRIMARY KEY,
|
|
`provider_id` text NOT NULL UNIQUE,
|
|
`organization_id` text NOT NULL,
|
|
`user_id` text,
|
|
`issuer` text NOT NULL,
|
|
`domain` text NOT NULL,
|
|
`auto_link_matching_emails` integer DEFAULT false NOT NULL,
|
|
`oidc_config` text,
|
|
`saml_config` text,
|
|
`created_at` integer DEFAULT (unixepoch() * 1000) NOT NULL,
|
|
`updated_at` integer DEFAULT (unixepoch() * 1000) NOT NULL,
|
|
CONSTRAINT `fk_sso_provider_organization_id_organization_id_fk` FOREIGN KEY (`organization_id`) REFERENCES `organization`(`id`) ON DELETE CASCADE,
|
|
CONSTRAINT `fk_sso_provider_user_id_users_table_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users_table`(`id`) ON DELETE SET NULL
|
|
);
|