From 33e5916f382e4c5c089b608a94cb93d0cfc7f562 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Wed, 5 Jun 2013 10:09:40 -0400 Subject: [PATCH] Bug 9011 - Add the ability to store the last patron to return an item - Followup - Remove foreign key constrant --- installer/data/mysql/updatedatabase.pl | 2 -- 1 files changed, 0 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 1554a72..087bd2f 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -6987,11 +6987,9 @@ $DBversion = "3.13.00.XXX"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do("ALTER TABLE items ADD last_returned_by INT( 11 ) NULL DEFAULT NULL AFTER datelastseen"); $dbh->do("ALTER TABLE items ADD INDEX ( last_returned_by )"); - $dbh->do("ALTER TABLE items ADD FOREIGN KEY ( last_returned_by ) REFERENCES borrowers ( borrowernumber )"); $dbh->do("ALTER TABLE deleteditems ADD last_returned_by INT( 11 ) NULL DEFAULT NULL AFTER datelastseen"); $dbh->do("ALTER TABLE deleteditems ADD INDEX ( last_returned_by )"); - $dbh->do("ALTER TABLE deleteditems ADD FOREIGN KEY ( last_returned_by ) REFERENCES borrowers ( borrowernumber )"); $dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('StoreLastBorrower','0','','If ON, the last borrower to return an item will be stored in items.last_returned_by','YesNo')"); -- 1.7.2.5