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

(-)a/installer/data/mysql/updatedatabase.pl (-8 / +8 lines)
Lines 58-63 my ( Link Here
58
    $prefitem,          # preference item in systempreferences table
58
    $prefitem,          # preference item in systempreferences table
59
);
59
);
60
60
61
my $schema = Koha::Database->new()->schema();
62
61
my $silent;
63
my $silent;
62
GetOptions(
64
GetOptions(
63
    's' =>\$silent
65
    's' =>\$silent
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
10066
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
10065
    });
10067
    });
10066
10068
10067
    my $schema = Koha::Database->new()->schema();
10068
    my $max_issue_id = $schema->resultset('Issue')->get_column('issue_id')->max();
10069
    my $max_issue_id = $schema->resultset('Issue')->get_column('issue_id')->max();
10069
    $max_issue_id ||= $schema->resultset('OldIssue')->get_column('issue_id')->max();
10070
    if ($max_issue_id) {
10070
    $max_issue_id ||= 0;
10071
        $max_issue_id++;
10071
    $max_issue_id++;
10072
        $dbh->do(qq{
10072
    $dbh->do(qq{
10073
            ALTER TABLE issues AUTO_INCREMENT = $max_issue_id
10073
        ALTER TABLE issues AUTO_INCREMENT = $max_issue_id}
10074
        });
10074
    );
10075
    }
10075
10076
10076
    print "Upgrade to $DBversion done (Bug 13790 - Add unique id issue_id to issues and oldissues tables)\n";
10077
    print "Upgrade to $DBversion done (Bug 13790 - Add unique id issue_id to issues and oldissues tables)\n";
10077
    SetVersion($DBversion);
10078
    SetVersion($DBversion);
10078
- 

Return to bug 13790