From e80246135301de18b25110b21570e1d191e069d3 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 25 Nov 2024 14:51:28 +0100 Subject: [PATCH] Bug 22421: Fix KEY names There is a mismatch in KEY names. We should use the ones auto-generated by the server, not pass specific ones. --- installer/data/mysql/kohastructure.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 6d2354d858c..445d476b704 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -144,10 +144,10 @@ CREATE TABLE `accountlines` ( KEY `debit_type_code` (`debit_type_code`), KEY `itemnumber` (`itemnumber`), KEY `branchcode` (`branchcode`), - KEY `issue_id` (`issue_id`), - KEY `old_issue_id` (`old_issue_id`), KEY `manager_id` (`manager_id`), KEY `accountlines_ibfk_registers` (`register_id`), + KEY `accountlines_ibfk_old_issues` (`old_issue_id`), + KEY `accountlines_ibfk_issues` (`issue_id`), CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, -- 2.34.1