Bugzilla – Attachment 180926 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 KEY to kohastructure.sql
Bug-39618-Add-KEY-to-kohastructuresql.patch (text/plain), 1.82 KB, created by
Lucas Gass (lukeg)
on 2025-04-14 18:12:08 UTC
(
hide
)
Description:
Bug 39618: Add KEY to kohastructure.sql
Filename:
MIME Type:
Creator:
Lucas Gass (lukeg)
Created:
2025-04-14 18:12:08 UTC
Size:
1.82 KB
patch
obsolete
>From 679fe97e489e6a930d5e627d399b43d39bb7e362 Mon Sep 17 00:00:00 2001 >From: Lucas Gass <lucas@bywatersolutions.com> >Date: Mon, 14 Apr 2025 18:09:43 +0000 >Subject: [PATCH] Bug 39618: Add KEY to kohastructure.sql > >--- > .../data/mysql/atomicupdate/bug_39618_add_preferred_name_key.pl | 2 +- > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 2 insertions(+), 1 deletion(-) > >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 >index 564c788af17..015f83b1430 100755 >--- a/installer/data/mysql/atomicupdate/bug_39618_add_preferred_name_key.pl >+++ b/installer/data/mysql/atomicupdate/bug_39618_add_preferred_name_key.pl >@@ -8,7 +8,7 @@ return { > my ($args) = @_; > my ( $dbh, $out ) = @$args{qw(dbh out)}; > >- unless ( index_exists( 'article_requests', 'debit_id' ) ) { >+ unless ( index_exists( 'borrowers', 'preferred_name' ) ) { > $dbh->do( > q{ > ALTER TABLE `borrowers` >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 93ad196454c..1641118a682 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1620,6 +1620,7 @@ CREATE TABLE `borrowers` ( > KEY `cardnumber_idx` (`cardnumber`), > KEY `userid_idx` (`userid`), > KEY `middle_name_idx` (`middle_name`(768)), >+ KEY `preferred_name` (`preferred_name`), > CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), > CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`), > CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE >-- >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