Bugzilla – Attachment 180887 Details for
Bug 39618
Add a non-unique index/key to borrowers table for preferred_name
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 39618: Add index to borrowers.preferred_name column
Bug-39618-Add-index-to-borrowerspreferredname-colu.patch (text/plain), 1.40 KB, created by
Lucas Gass (lukeg)
on 2025-04-11 20:42:18 UTC
(
hide
)
Description:
Bug 39618: Add index to borrowers.preferred_name column
Filename:
MIME Type:
Creator:
Lucas Gass (lukeg)
Created:
2025-04-11 20:42:18 UTC
Size:
1.40 KB
patch
obsolete
>From 67e8530a990095f6159ba90223964995c08f40ad Mon Sep 17 00:00:00 2001 >From: Lucas Gass <lucas@bywatersolutions.com> >Date: Fri, 11 Apr 2025 20:41:17 +0000 >Subject: [PATCH] Bug 39618: Add index to borrowers.preferred_name column > >To test: >1. APPLY PATCH >2. updatedatabase >--- > .../bug_39618_add_preferred_name_key.pl | 21 +++++++++++++++++++ > 1 file changed, 21 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_39618_add_preferred_name_key.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_39618_add_preferred_name_key.pl b/installer/data/mysql/atomicupdate/bug_39618_add_preferred_name_key.pl >new file mode 100755 >index 00000000000..564c788af17 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_39618_add_preferred_name_key.pl >@@ -0,0 +1,21 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_success say_info); >+ >+return { >+ bug_number => "39618", >+ description => "Add index to borrowers.preferred_name", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ unless ( index_exists( 'article_requests', 'debit_id' ) ) { >+ $dbh->do( >+ q{ >+ ALTER TABLE `borrowers` >+ ADD KEY `preferred_name` (`preferred_name`) >+ } >+ ); >+ } >+ say_success( $out, "Added index to borrowers.preferred_name" ); >+ }, >+}; >-- >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 39618
: 180887 |
180926