Bug 2720: (follow-up) add foreign key from new table to borrowers

[koha.git] / installer / data / mysql / updatedatabase.pl

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index 78ef75f..6c351d2 100755 (executable)
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -7608,7 +7608,9 @@ CREATE TABLE borrower_debarments (
   created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   updated timestamp NULL DEFAULT NULL,
   PRIMARY KEY (borrower_debarment_id),
-  KEY borrowernumber (borrowernumber)
+  KEY borrowernumber (borrowernumber) ,
+  CONSTRAINT `borrower_debarments_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
+    ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
     });