From 24bed13aa49081c20f164dcc5e57dafffe9f092e Mon Sep 17 00:00:00 2001 From: Andrew Fuerste Henry Date: Thu, 6 Feb 2025 21:26:03 +0000 Subject: [PATCH] Bug 39062: increase length of items.stocknumber and deleteditems.stocknumber in kohastructure.sql To test: 1: try to save a value in the 952$i that is more than 32 characters 2: It does not work. 3: apply patch 4: try to save a value in the 952$i that is more than 32 characters 5: it does work! 6: delete your item and use a report to confirm the full string is in deleteditems.stocknumber 7: Maybe use DESCRIBE from mysql commandline to see the length and confirm it's changed? Signed-off-by: David Cook --- installer/data/mysql/kohastructure.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 3bf15c1007..2355fd817c 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2806,7 +2806,7 @@ CREATE TABLE `deleteditems` ( `more_subfields_xml` longtext DEFAULT NULL COMMENT 'additional 952 subfields in XML format', `enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)', `copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', - `stocknumber` varchar(32) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', + `stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', `new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.', `exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', PRIMARY KEY (`itemnumber`), @@ -4108,7 +4108,7 @@ CREATE TABLE `items` ( `more_subfields_xml` longtext DEFAULT NULL COMMENT 'additional 952 subfields in XML format', `enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)', `copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', - `stocknumber` varchar(32) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', + `stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', `new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.', `exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', PRIMARY KEY (`itemnumber`), -- 2.39.5