From fee45a12dee88fe8cc0aa60b1c3cacfbcb794014 Mon Sep 17 00:00:00 2001 From: Pedro Amorim Date: Mon, 13 Oct 2025 08:39:40 +0000 Subject: [PATCH] Bug 40517: DB changes --- installer/data/mysql/kohastructure.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index fe7454cfe2f..c6fc8abd9e9 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3551,6 +3551,9 @@ DROP TABLE IF EXISTS `hold_groups`; /*!40101 SET character_set_client = utf8mb4 */; 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', + KEY `hold_groups_borrowernumber` (`borrowernumber`), + CONSTRAINT `hold_groups_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE, PRIMARY KEY (`hold_group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- 2.39.5