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 10171-10184 if(CheckVersion($DBversion)) { Link Here
10171
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
10173
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
10172
    });
10174
    });
10173
10175
10174
    my $schema = Koha::Database->new()->schema();
10175
    my $max_issue_id = $schema->resultset('Issue')->get_column('issue_id')->max();
10176
    my $max_issue_id = $schema->resultset('Issue')->get_column('issue_id')->max();
10176
    $max_issue_id ||= $schema->resultset('OldIssue')->get_column('issue_id')->max();
10177
    if ($max_issue_id) {
10177
    $max_issue_id ||= 0;
10178
        $max_issue_id++;
10178
    $max_issue_id++;
10179
        $dbh->do(qq{
10179
    $dbh->do(qq{
10180
            ALTER TABLE issues AUTO_INCREMENT = $max_issue_id
10180
        ALTER TABLE issues AUTO_INCREMENT = $max_issue_id}
10181
        });
10181
    );
10182
    }
10182
10183
10183
    print "Upgrade to $DBversion done (Bug 13790 - Add unique id issue_id to issues and oldissues tables)\n";
10184
    print "Upgrade to $DBversion done (Bug 13790 - Add unique id issue_id to issues and oldissues tables)\n";
10184
    SetVersion($DBversion);
10185
    SetVersion($DBversion);
10185
- 

Return to bug 13790