Lines 862-869
CREATE TABLE `identity_providers` (
Link Here
|
862 |
`code` varchar(20) NOT NULL COMMENT 'Provider code', |
862 |
`code` varchar(20) NOT NULL COMMENT 'Provider code', |
863 |
`description` varchar(255) NOT NULL COMMENT 'Description for the provider', |
863 |
`description` varchar(255) NOT NULL COMMENT 'Description for the provider', |
864 |
`protocol` enum('OAuth', 'OIDC', 'LDAP', 'CAS') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Protocol provider speaks', |
864 |
`protocol` enum('OAuth', 'OIDC', 'LDAP', 'CAS') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Protocol provider speaks', |
865 |
`config` longtext NOT NULL DEFAULT '{}' COMMENT 'Configuration of the provider in JSON format', |
865 |
`config` longtext NOT NULL COMMENT 'Configuration of the provider in JSON format', |
866 |
`mapping` longtext NOT NULL DEFAULT '{}' COMMENT 'Configuration to map provider data to Koha user', |
866 |
`mapping` longtext NOT NULL COMMENT 'Configuration to map provider data to Koha user', |
867 |
`matchpoint` enum('email','userid','cardnumber') NOT NULL COMMENT 'The patron attribute to be used as matchpoint', |
867 |
`matchpoint` enum('email','userid','cardnumber') NOT NULL COMMENT 'The patron attribute to be used as matchpoint', |
868 |
`icon_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Provider icon URL', |
868 |
`icon_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Provider icon URL', |
869 |
PRIMARY KEY (`identity_provider_id`), |
869 |
PRIMARY KEY (`identity_provider_id`), |
870 |
- |
|
|