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 |
- |
|
|