From b5f8fa08ef5a082085b55ac569fd204487797054 Mon Sep 17 00:00:00 2001 From: Shi Yao Wang Date: Fri, 15 Aug 2025 08:51:48 -0400 Subject: [PATCH] Bug 20644: Change checkprevcheckout as ENUM at DB level --- .../atomicupdate/bug_20644-add_checkprevcheckout_to_items.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_20644-add_checkprevcheckout_to_items.pl b/installer/data/mysql/atomicupdate/bug_20644-add_checkprevcheckout_to_items.pl index d09e1f1e53b..a44b06df40e 100755 --- a/installer/data/mysql/atomicupdate/bug_20644-add_checkprevcheckout_to_items.pl +++ b/installer/data/mysql/atomicupdate/bug_20644-add_checkprevcheckout_to_items.pl @@ -11,7 +11,7 @@ return { $dbh->do( q{ ALTER TABLE itemtypes - ADD IF NOT EXISTS checkprevcheckout varchar(7) NOT NULL DEFAULT 'inherit' COMMENT 'produce a warning for a patron if a item of this type has previously been checked out to the same patron if ''yes'', not if ''no'', defer to category setting if ''inherit''.' + ADD IF NOT EXISTS checkprevcheckout enum('yes', 'no', 'inherit') NOT NULL DEFAULT 'inherit' COMMENT 'produce a warning for a patron if a item of this type has previously been checked out to the same patron if ''yes'', not if ''no'', defer to category setting if ''inherit''.' AFTER automatic_checkin; } ); -- 2.43.0