From 30f2f3114a2d023dd700c28ccdc68ceb2e9ab9d0 Mon Sep 17 00:00:00 2001
From: Kyle M Hall <kyle@bywatersolutions.com>
Date: Wed, 8 Jan 2014 07:58:14 -0500
Subject: [PATCH] Bug 9303 [QA Followup] - Set AUTO_INCREMENT value for issues.issue_id
---
installer/data/mysql/updatedatabase.pl | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index f56e102..2f7ed85 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -37,6 +37,7 @@ use Getopt::Long;
use C4::Context;
use C4::Installer;
use C4::Dates;
+use Koha::Database;
use MARC::Record;
use MARC::File::XML ( BinaryEncoding => 'utf8' );
@@ -7962,6 +7963,16 @@ if(CheckVersion($DBversion)) {
$dbh->do(qq{
UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
});
+
+ my $schema = Koha::Database->new()->schema();
+ my $max_issue_id = $schema->resultset('Issue')->get_column('issue_id')->max();
+ $max_issue_id ||= $schema->resultset('OldIssue')->get_column('issue_id')->max();
+ $max_issue_id ||= 0;
+ $max_issue_id++;
+ $dbh->do(qq{
+ ALTER TABLE issues AUTO_INCREMENT = $max_issue_id
+ });
+
print "Upgrade to $DBversion done (Bug 9303 - relative's checkouts in the opac)\n";
SetVersion($DBversion);
}
--
1.7.2.5