View | Details | Raw Unified | Return to bug 31378
Collapse All | Expand All

(-)a/installer/data/mysql/db_revs/220600081.pl (-2 / +2 lines)
Lines 24-31 return { Link Here
24
                `code` varchar(20) NOT NULL COMMENT 'Provider code',
24
                `code` varchar(20) NOT NULL COMMENT 'Provider code',
25
                `description` varchar(255) NOT NULL COMMENT 'Description for the provider',
25
                `description` varchar(255) NOT NULL COMMENT 'Description for the provider',
26
                `protocol` enum('OAuth', 'OIDC', 'LDAP', 'CAS') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Protocol provider speaks',
26
                `protocol` enum('OAuth', 'OIDC', 'LDAP', 'CAS') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Protocol provider speaks',
27
                `config` longtext NOT NULL DEFAULT '{}' COMMENT 'Configuration of the provider in JSON format',
27
                `config` longtext NOT NULL COMMENT 'Configuration of the provider in JSON format',
28
                `mapping` longtext NOT NULL DEFAULT '{}' COMMENT 'Configuration to map provider data to Koha user',
28
                `mapping` longtext NOT NULL COMMENT 'Configuration to map provider data to Koha user',
29
                `matchpoint` enum('email','userid','cardnumber') NOT NULL COMMENT 'The patron attribute to be used as matchpoint',
29
                `matchpoint` enum('email','userid','cardnumber') NOT NULL COMMENT 'The patron attribute to be used as matchpoint',
30
                `icon_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Provider icon URL',
30
                `icon_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Provider icon URL',
31
                PRIMARY KEY (`identity_provider_id`),
31
                PRIMARY KEY (`identity_provider_id`),
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
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
- 

Return to bug 31378