From 679fe97e489e6a930d5e627d399b43d39bb7e362 Mon Sep 17 00:00:00 2001 From: Lucas Gass 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