From 4b3605c919c40a7ef31fa8037abdccda33c52bdf Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 30 Oct 2014 10:12:23 -0400 Subject: [PATCH] Bug 9011 [QA Followup 5] - Depend on bug 9303 for issue_id --- installer/data/mysql/updatedatabase.pl | 10 ---------- 1 files changed, 0 insertions(+), 10 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 4b47680..c3b32c9 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9021,16 +9021,6 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { 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