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