From 31485070bafc9dd9ae1ba6932cde803db337571d Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Thu, 29 Jan 2026 21:32:24 +0000 Subject: [PATCH] Bug 23260: Fix kohastructure.sql --- installer/data/mysql/kohastructure.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 0fa24cb24b9..004d16a26e7 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -4256,10 +4256,11 @@ DROP TABLE IF EXISTS `items_last_borrower`; CREATE TABLE `items_last_borrower` ( `id` int(11) NOT NULL AUTO_INCREMENT, `itemnumber` int(11) NOT NULL, - `borrowernumber` int(11) NULL, - `created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), + `borrowernumber` int(11) DEFAULT NULL, + `created_on` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `borrowernumber` (`borrowernumber`), + KEY `items_last_borrower_ibfk_1` (`itemnumber`), CONSTRAINT `items_last_borrower_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `items_last_borrower_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 2.39.5