Lines 37-43
use Getopt::Long;
Link Here
|
37 |
use C4::Context; |
37 |
use C4::Context; |
38 |
use C4::Installer; |
38 |
use C4::Installer; |
39 |
use C4::Dates; |
39 |
use C4::Dates; |
40 |
use Koha::Database; |
|
|
41 |
|
40 |
|
42 |
use MARC::Record; |
41 |
use MARC::Record; |
43 |
use MARC::File::XML ( BinaryEncoding => 'utf8' ); |
42 |
use MARC::File::XML ( BinaryEncoding => 'utf8' ); |
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 |
10063 |
UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC |
10065 |
}); |
10064 |
}); |
10066 |
|
10065 |
|
10067 |
my $schema = Koha::Database->new()->schema(); |
10066 |
my $schema = Koha::Database->new()->schema(); |
10068 |
my $max_issue_id = $schema->resultset('Issue')->get_column('issue_id')->max(); |
10067 |
my $max_issue_id = $schema->resultset('Issue')->get_column('issue_id')->max(); |
10069 |
$max_issue_id ||= $schema->resultset('OldIssue')->get_column('issue_id')->max(); |
10068 |
if ($max_issue_id) { |
10070 |
$max_issue_id ||= 0; |
10069 |
$max_issue_id++; |
10071 |
$max_issue_id++; |
10070 |
$dbh->do(qq{ |
10072 |
$dbh->do(qq{ |
10071 |
ALTER TABLE issues AUTO_INCREMENT = $max_issue_id |
10073 |
ALTER TABLE issues AUTO_INCREMENT = $max_issue_id} |
10072 |
}); |
10074 |
); |
10073 |
} |
10075 |
|
10074 |
|
10076 |
print "Upgrade to $DBversion done (Bug 13790 - Add unique id issue_id to issues and oldissues tables)\n"; |
10075 |
print "Upgrade to $DBversion done (Bug 13790 - Add unique id issue_id to issues and oldissues tables)\n"; |
10077 |
SetVersion($DBversion); |
10076 |
SetVersion($DBversion); |
10078 |
- |
|
|