From 3130827fa6d9bc814c04209656fcf5aa910712de Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 17 Oct 2016 14:47:02 +0100 Subject: [PATCH] Bug 5670: Update constraint name to match with the one in updatedatabase Signed-off-by: Kyle M Hall --- installer/data/mysql/kohastructure.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 593826c900..214265752d 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3866,7 +3866,7 @@ CREATE TABLE IF NOT EXISTS `housebound_role` ( `housebound_chooser` tinyint(1) NOT NULL DEFAULT 0, -- set to 1 to indicate this patron is a housebound chooser volunteer `housebound_deliverer` tinyint(1) NOT NULL DEFAULT 0, -- set to 1 to indicate this patron is a housebound deliverer volunteer PRIMARY KEY (`borrowernumber_id`), - CONSTRAINT `houseboundvisit_bnfk` + CONSTRAINT `houseboundrole_bnfk` FOREIGN KEY (`borrowernumber_id`) REFERENCES `borrowers` (`borrowernumber`) ON UPDATE CASCADE ON DELETE CASCADE -- 2.39.5