Bugzilla – Attachment 168436 Details for
Bug 36453
BlockExpiredPatronOpacActions should allow multiple actions options
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 36453: (QA follow-up) Use varchar instead of mediumtext
Bug-36453-QA-follow-up-Use-varchar-instead-of-medi.patch (text/plain), 3.35 KB, created by
Pedro Amorim
on 2024-07-03 10:39:55 UTC
(
hide
)
Description:
Bug 36453: (QA follow-up) Use varchar instead of mediumtext
Filename:
MIME Type:
Creator:
Pedro Amorim
Created:
2024-07-03 10:39:55 UTC
Size:
3.35 KB
patch
obsolete
>From 0b0a2249529849565a40e7768805f1a4faa9dcd4 Mon Sep 17 00:00:00 2001 >From: Pedro Amorim <pedro.amorim@ptfs-europe.com> >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 >--- > 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.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 36453
:
164042
|
164043
|
164044
|
164045
|
164046
|
164047
|
164048
|
164762
|
164763
|
164764
|
164765
|
164766
|
164767
|
164768
|
165413
|
165414
|
165454
|
167461
|
167462
|
167463
|
167464
|
167465
|
167466
|
167467
|
167468
|
167469
|
167470
|
167471
|
167472
|
167473
|
167474
|
167475
|
167476
|
167477
|
167478
|
167479
|
167480
|
168435
| 168436