From 849c8b93a843433e95837975c30573f8b2319899 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 --- 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 e8da46d..80f2816 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3868,7 +3868,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.8.1