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