From 633f0d7f3010ba21d0dcabdb4a7ffde57b715f71 Mon Sep 17 00:00:00 2001 From: David Cook 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