From 6732b52e797f95a07aa2d887622240dfc05b03e9 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Tue, 8 Nov 2022 19:28:03 -0300 Subject: [PATCH] Bug 31378: (follow-up) MySQL 8 doens't allow default for longtext Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/db_revs/220600081.pl | 4 ++-- installer/data/mysql/kohastructure.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/db_revs/220600081.pl b/installer/data/mysql/db_revs/220600081.pl index 37563e4a296..aeef99897cc 100755 --- a/installer/data/mysql/db_revs/220600081.pl +++ b/installer/data/mysql/db_revs/220600081.pl @@ -24,8 +24,8 @@ return { `code` varchar(20) NOT NULL COMMENT 'Provider code', `description` varchar(255) NOT NULL COMMENT 'Description for the provider', `protocol` enum('OAuth', 'OIDC', 'LDAP', 'CAS') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Protocol provider speaks', - `config` longtext NOT NULL DEFAULT '{}' COMMENT 'Configuration of the provider in JSON format', - `mapping` longtext NOT NULL DEFAULT '{}' COMMENT 'Configuration to map provider data to Koha user', + `config` longtext NOT NULL COMMENT 'Configuration of the provider in JSON format', + `mapping` longtext NOT NULL COMMENT 'Configuration to map provider data to Koha user', `matchpoint` enum('email','userid','cardnumber') NOT NULL COMMENT 'The patron attribute to be used as matchpoint', `icon_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Provider icon URL', PRIMARY KEY (`identity_provider_id`), diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index c30cd7ac531..54ed708304a 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -862,8 +862,8 @@ CREATE TABLE `identity_providers` ( `code` varchar(20) NOT NULL COMMENT 'Provider code', `description` varchar(255) NOT NULL COMMENT 'Description for the provider', `protocol` enum('OAuth', 'OIDC', 'LDAP', 'CAS') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Protocol provider speaks', - `config` longtext NOT NULL DEFAULT '{}' COMMENT 'Configuration of the provider in JSON format', - `mapping` longtext NOT NULL DEFAULT '{}' COMMENT 'Configuration to map provider data to Koha user', + `config` longtext NOT NULL COMMENT 'Configuration of the provider in JSON format', + `mapping` longtext NOT NULL COMMENT 'Configuration to map provider data to Koha user', `matchpoint` enum('email','userid','cardnumber') NOT NULL COMMENT 'The patron attribute to be used as matchpoint', `icon_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Provider icon URL', PRIMARY KEY (`identity_provider_id`), -- 2.34.1