From edb1515cc14f8edc5e82914686497ddbea1b56fc Mon Sep 17 00:00:00 2001 From: Paul POULAIN Date: Fri, 23 Nov 2007 19:26:13 +0100 Subject: [PATCH] 1507 : Possible Missing Foreign Key in Accountoffsets Signed-off-by: Joshua Ferraro --- installer/data/mysql/kohastructure.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 07049cde08..f2fa557bd3 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -50,7 +50,9 @@ CREATE TABLE `accountoffsets` ( `accountno` smallint(6) NOT NULL default 0, `offsetaccount` smallint(6) NOT NULL default 0, `offsetamount` decimal(28,6) default NULL, - `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP + `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + CONSTRAINT `accountoffsets_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, + ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 2.39.2