From 4895aafb40a7fd20a8145a00a5e392ea4b8b5578 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Tue, 19 Aug 2014 07:32:24 -0400 Subject: [PATCH] Bug 9011 [QA Followup 4] - Add issue_id to issues tables Signed-off-by: Nick Clemens --- installer/data/mysql/updatedatabase.pl | 14 +++++++++++++- 1 files changed, 13 insertions(+), 1 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 98b1f48..ab0a45b 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8802,7 +8802,19 @@ if ( CheckVersion($DBversion) ) { $DBversion = "3.17.00.XXX"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('StoreLastBorrower','0','','If ON, the last borrower to return an item will be stored in items.last_returned_by','YesNo')"); + $dbh->do(q{ + INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('StoreLastBorrower','0','','If ON, the last borrower to return an item will be stored in items.last_returned_by','YesNo') + }); + + $dbh->do(q{ + ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST + }); + $dbh->do(q{ + ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST; + }); + $dbh->do(q{ + UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC + }); print "Upgrade to $DBversion done (Bug 9011 - Add the ability to store the last patron to return an item)\n"; } -- 1.7.2.5