From b20d919e00581718db5d2c5865f52a9f35e8c3a6 Mon Sep 17 00:00:00 2001 From: Pedro Amorim Date: Wed, 3 Jul 2024 09:59:54 +0000 Subject: [PATCH] Bug 36453: (QA follow-up) Use varchar instead of mediumtext Test plan: 1) ktd down 2) DB_IMAGE=mysql:8.0 ktd up 3) Should now work with no issues Signed-off-by: Katrin Fischer --- installer/data/mysql/db_revs/240600002.pl | 4 ++-- installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/db_revs/240600002.pl b/installer/data/mysql/db_revs/240600002.pl index d267ca250e..0aee778d92 100755 --- a/installer/data/mysql/db_revs/240600002.pl +++ b/installer/data/mysql/db_revs/240600002.pl @@ -36,8 +36,8 @@ return { # Update categories database table BlockExpiredPatronOpacActions column settings $dbh->do( - "ALTER TABLE categories MODIFY BlockExpiredPatronOpacActions mediumtext NOT NULL DEFAULT 'follow_syspref_BlockExpiredPatronOpacActions' COMMENT 'specific actions expired patrons of this category are blocked from performing or if the BlockExpiredPatronOpacActions system preference is to be followed'" - ) and say_success( $out, "Updated categories.BlockExpiredPatronOpacActions to mediumtext" ); + "ALTER TABLE categories MODIFY BlockExpiredPatronOpacActions varchar(128) NOT NULL DEFAULT 'follow_syspref_BlockExpiredPatronOpacActions' COMMENT 'specific actions expired patrons of this category are blocked from performing or if the BlockExpiredPatronOpacActions system preference is to be followed'" + ) and say_success( $out, "Updated categories.BlockExpiredPatronOpacActions to varchar(128)" ); # Update patron categories using -1 $dbh->do( diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 14cef909b3..7499810da8 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1796,7 +1796,7 @@ CREATE TABLE `categories` ( `reservefee` decimal(28,6) DEFAULT NULL COMMENT 'cost to place holds', `hidelostitems` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'are lost items shown to this category (1 for yes, 0 for no)', `category_type` varchar(1) NOT NULL DEFAULT 'A' COMMENT 'type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)', - `BlockExpiredPatronOpacActions` mediumtext NOT NULL DEFAULT 'follow_syspref_BlockExpiredPatronOpacActions' COMMENT 'specific actions expired patrons of this category are blocked from performing or if the BlockExpiredPatronOpacActions system preference is to be followed', + `BlockExpiredPatronOpacActions` varchar(128) NOT NULL DEFAULT 'follow_syspref_BlockExpiredPatronOpacActions' COMMENT 'specific actions expired patrons of this category are blocked from performing or if the BlockExpiredPatronOpacActions system preference is to be followed', `default_privacy` enum('default','never','forever') NOT NULL DEFAULT 'default' COMMENT 'Default privacy setting for this patron category', `checkprevcheckout` varchar(7) NOT NULL DEFAULT 'inherit' COMMENT 'produce a warning for this patron category if this item has previously been checked out to this patron if ''yes'', not if ''no'', defer to syspref setting if ''inherit''.', `can_place_ill_in_opac` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'can this patron category place interlibrary loan requests', -- 2.39.5