Bugzilla – Attachment 177697 Details for
Bug 39062
Increase length of inventory number field in database
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 39062: increase length of items.stocknumber and deleteditems.stocknumber in kohastructure.sql
Bug-39062-increase-length-of-itemsstocknumber-and-.patch (text/plain), 2.63 KB, created by
Andrew Fuerste-Henry
on 2025-02-10 14:29:24 UTC
(
hide
)
Description:
Bug 39062: increase length of items.stocknumber and deleteditems.stocknumber in kohastructure.sql
Filename:
MIME Type:
Creator:
Andrew Fuerste-Henry
Created:
2025-02-10 14:29:24 UTC
Size:
2.63 KB
patch
obsolete
>From 49b15c69ae8fdc220ed5e8b28ad57744277cbf49 Mon Sep 17 00:00:00 2001 >From: Andrew Fuerste Henry <andrew@bywatersolutions.com> >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? >--- > 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
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 39062
:
177602
|
177603
|
177604
|
177697
|
177698
|
177716
|
177717
|
179114
|
179793
|
179794
|
179795