From a29ce95a0a8c76473792197db02880e72fac04cf Mon Sep 17 00:00:00 2001 From: Pedro Amorim Date: Fri, 24 Oct 2025 16:59:28 +0000 Subject: [PATCH] Bug 40517: (QA follow-up): Fix kohstructure.sql The order was wrong, PRIMARY KEY must come first. --- 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 0c333a6ad4a..998007871e2 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3554,9 +3554,9 @@ CREATE TABLE `hold_groups` ( `hold_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table', `visual_hold_group_id` int(11) DEFAULT NULL COMMENT 'visual ID for this hold group, in the context of the related patron', + PRIMARY KEY (`hold_group_id`), KEY `hold_groups_borrowernumber` (`borrowernumber`), - CONSTRAINT `hold_groups_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE, - PRIMARY KEY (`hold_group_id`) + CONSTRAINT `hold_groups_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- 2.39.5