View | Details | Raw Unified | Return to bug 9011
Collapse All | Expand All

(-)a/installer/data/mysql/updatedatabase.pl (-3 lines)
Lines 6987-6997 $DBversion = "3.13.00.XXX"; Link Here
6987
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
6987
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
6988
   $dbh->do("ALTER TABLE items ADD last_returned_by INT( 11 ) NULL DEFAULT NULL AFTER datelastseen");
6988
   $dbh->do("ALTER TABLE items ADD last_returned_by INT( 11 ) NULL DEFAULT NULL AFTER datelastseen");
6989
   $dbh->do("ALTER TABLE items ADD INDEX ( last_returned_by )");
6989
   $dbh->do("ALTER TABLE items ADD INDEX ( last_returned_by )");
6990
   $dbh->do("ALTER TABLE items ADD FOREIGN KEY ( last_returned_by ) REFERENCES  borrowers ( borrowernumber )");
6991
6990
6992
   $dbh->do("ALTER TABLE deleteditems ADD last_returned_by INT( 11 ) NULL DEFAULT NULL AFTER datelastseen");
6991
   $dbh->do("ALTER TABLE deleteditems ADD last_returned_by INT( 11 ) NULL DEFAULT NULL AFTER datelastseen");
6993
   $dbh->do("ALTER TABLE deleteditems ADD INDEX ( last_returned_by )");
6992
   $dbh->do("ALTER TABLE deleteditems ADD INDEX ( last_returned_by )");
6994
   $dbh->do("ALTER TABLE deleteditems ADD FOREIGN KEY ( last_returned_by ) REFERENCES  borrowers ( borrowernumber )");
6995
6993
6996
   $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')");
6994
   $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')");
6997
6995
6998
- 

Return to bug 9011