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

(-)a/installer/data/mysql/updatedatabase.pl (-11 lines)
Lines 9021-9036 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
9021
        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')
9021
        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')
9022
    });
9022
    });
9023
9023
9024
    $dbh->do(q{
9025
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9026
    });
9027
    $dbh->do(q{
9028
       ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
9029
    });
9030
    $dbh->do(q{
9031
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
9032
    });
9033
9034
   print "Upgrade to $DBversion done (Bug 9011 - Add the ability to store the last patron to return an item)\n";
9024
   print "Upgrade to $DBversion done (Bug 9011 - Add the ability to store the last patron to return an item)\n";
9035
}
9025
}
9036
9026
9037
- 

Return to bug 9011