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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +13 lines)
Lines 8615-8621 if ( CheckVersion($DBversion) ) { Link Here
8615
8615
8616
$DBversion = "3.17.00.XXX";
8616
$DBversion = "3.17.00.XXX";
8617
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
8617
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
8618
   $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')");
8618
    $dbh->do(q{
8619
        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')
8620
    });
8621
8622
    $dbh->do(q{
8623
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
8624
    });
8625
    $dbh->do(q{
8626
       ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
8627
    });
8628
    $dbh->do(q{
8629
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
8630
    });
8619
8631
8620
   print "Upgrade to $DBversion done (Bug 9011 - Add the ability to store the last patron to return an item)\n";
8632
   print "Upgrade to $DBversion done (Bug 9011 - Add the ability to store the last patron to return an item)\n";
8621
   SetVersion ($DBversion);
8633
   SetVersion ($DBversion);
8622
- 

Return to bug 9011