Bugzilla – Attachment 182247 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: (QA follow-up) add prefix length to index key
Bug-39618-QA-follow-up-add-prefix-length-to-index-.patch (text/plain), 1.76 KB, created by
David Cook
on 2025-05-11 23:52:05 UTC
(
hide
)
Description:
Bug 39618: (QA follow-up) add prefix length to index key
Filename:
MIME Type:
Creator:
David Cook
Created:
2025-05-11 23:52:05 UTC
Size:
1.76 KB
patch
obsolete
>From 633f0d7f3010ba21d0dcabdb4a7ffde57b715f71 Mon Sep 17 00:00:00 2001 >From: David Cook <dcook@prosentient.com.au> >Date: Sun, 11 May 2025 23:50:54 +0000 >Subject: [PATCH] Bug 39618: (QA follow-up) add prefix length to index key > >--- > installer/data/mysql/db_revs/241200037.pl | 2 +- > installer/data/mysql/kohastructure.sql | 2 +- > 2 files changed, 2 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/db_revs/241200037.pl b/installer/data/mysql/db_revs/241200037.pl >index f0fc844dcd..6161a006c2 100755 >--- a/installer/data/mysql/db_revs/241200037.pl >+++ b/installer/data/mysql/db_revs/241200037.pl >@@ -12,7 +12,7 @@ return { > $dbh->do( > q{ > ALTER TABLE `borrowers` >- ADD KEY `preferred_name_idx` (`preferred_name`) >+ ADD KEY `preferred_name_idx` (`preferred_name`(768)) > } > ); > say_success( $out, "Added index to borrowers.preferred_name" ); >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 3602c65c18..5604de24d8 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1620,7 +1620,7 @@ CREATE TABLE `borrowers` ( > KEY `cardnumber_idx` (`cardnumber`), > KEY `userid_idx` (`userid`), > KEY `middle_name_idx` (`middle_name`(768)), >- KEY `preferred_name_idx` (`preferred_name`), >+ KEY `preferred_name_idx` (`preferred_name`(768)), > 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
|
181528
|
181555
|
181872
| 182247