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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +13 lines)
Lines 8802-8808 if ( CheckVersion($DBversion) ) { Link Here
8802
8802
8803
$DBversion = "3.17.00.XXX";
8803
$DBversion = "3.17.00.XXX";
8804
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
8804
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
8805
   $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')");
8805
    $dbh->do(q{
8806
        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')
8807
    });
8808
8809
    $dbh->do(q{
8810
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
8811
    });
8812
    $dbh->do(q{
8813
       ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
8814
    });
8815
    $dbh->do(q{
8816
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
8817
    });
8806
8818
8807
   print "Upgrade to $DBversion done (Bug 9011 - Add the ability to store the last patron to return an item)\n";
8819
   print "Upgrade to $DBversion done (Bug 9011 - Add the ability to store the last patron to return an item)\n";
8808
}
8820
}
8809
- 

Return to bug 9011