Bugzilla – Attachment 179794 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 stocknumber length in items and deleteditems
Bug-39062-Increase-stocknumber-length-in-items-and.patch (text/plain), 1.69 KB, created by
Baptiste Wojtkowski (bwoj)
on 2025-03-27 13:12:43 UTC
(
hide
)
Description:
Bug 39062: Increase stocknumber length in items and deleteditems
Filename:
MIME Type:
Creator:
Baptiste Wojtkowski (bwoj)
Created:
2025-03-27 13:12:43 UTC
Size:
1.69 KB
patch
obsolete
>From 1edd4eb097febd476b2faa124d56c11a1b1462f0 Mon Sep 17 00:00:00 2001 >From: Andrew Fuerste Henry <andrew@bywatersolutions.com> >Date: Thu, 6 Feb 2025 21:51:09 +0000 >Subject: [PATCH] Bug 39062: Increase stocknumber length in items and > deleteditems > >Signed-off-by: David Cook <dcook@prosentient.com.au> >Signed-off-by: Baptiste Wojtkowski <baptiste.wojtkowski@biblibre.com> >--- > .../bug_39062_increase_stocknumber_length.pl | 20 +++++++++++++++++++ > 1 file changed, 20 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_39062_increase_stocknumber_length.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_39062_increase_stocknumber_length.pl b/installer/data/mysql/atomicupdate/bug_39062_increase_stocknumber_length.pl >new file mode 100755 >index 00000000..db0963b9 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_39062_increase_stocknumber_length.pl >@@ -0,0 +1,20 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_success say_info); >+ >+return { >+ bug_number => "39062", >+ description => "Increase the size of items.stocknumber and deleteditems.stocknumber", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ # Do you stuffs here >+ $dbh->do(q{ALTER TABLE items MODIFY COLUMN stocknumber varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)'}); >+ $dbh->do(q{ALTER TABLE deleteditems MODIFY COLUMN stocknumber varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)'}); >+ >+ # Print useful stuff here >+ # tables >+ say $out "Increased length of items.stocknumber"; >+ say $out "Increased length of deleteditems.stocknumber"; >+ }, >+}; >-- >2.30.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 39062
:
177602
|
177603
|
177604
|
177697
|
177698
|
177716
|
177717
|
179114
|
179793
| 179794 |
179795