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

(-)a/installer/data/mysql/updatedatabase.pl (-9 / +7 lines)
Lines 37-43 use Getopt::Long; Link Here
37
use C4::Context;
37
use C4::Context;
38
use C4::Installer;
38
use C4::Installer;
39
use C4::Dates;
39
use C4::Dates;
40
use Koha::Database;
41
40
42
use MARC::Record;
41
use MARC::Record;
43
use MARC::File::XML ( BinaryEncoding => 'utf8' );
42
use MARC::File::XML ( BinaryEncoding => 'utf8' );
Lines 10064-10077 if(CheckVersion($DBversion)) { Link Here
10064
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
10063
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
10065
    });
10064
    });
10066
10065
10067
    my $schema = Koha::Database->new()->schema();
10066
    my $schema  = Koha::Database->new()->schema();
10068
    my $max_issue_id = $schema->resultset('Issue')->get_column('issue_id')->max();
10067
    my $max_issue_id = $schema->resultset('Issue')->get_column('issue_id')->max();
10069
    $max_issue_id ||= $schema->resultset('OldIssue')->get_column('issue_id')->max();
10068
    if ($max_issue_id) {
10070
    $max_issue_id ||= 0;
10069
        $max_issue_id++;
10071
    $max_issue_id++;
10070
        $dbh->do(qq{
10072
    $dbh->do(qq{
10071
            ALTER TABLE issues AUTO_INCREMENT = $max_issue_id
10073
        ALTER TABLE issues AUTO_INCREMENT = $max_issue_id}
10072
        });
10074
    );
10073
    }
10075
10074
10076
    print "Upgrade to $DBversion done (Bug 13790 - Add unique id issue_id to issues and oldissues tables)\n";
10075
    print "Upgrade to $DBversion done (Bug 13790 - Add unique id issue_id to issues and oldissues tables)\n";
10077
    SetVersion($DBversion);
10076
    SetVersion($DBversion);
10078
- 

Return to bug 13790