Attachment 30999 Details for Bug 9011 – [SIGNED OFF] Bug 9011 [QA Followup 4] - Add issue_id to issues tables

[patch] [SIGNED OFF] Bug 9011 [QA Followup 4] - Add issue_id to issues tables

SIGNED-OFF-Bug-9011-QA-Followup-4---Add-issueid-to.patch (text/plain), 1.74 KB, created by Nick Clemens (kidclamp) on 2014-08-19 20:20:04 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2014-08-19 20:20:04 UTC

Size: 1.74 KB

patch

obsolete

>From 003944ed6524375b73c56b87a6e2b7703065b70a Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Tue, 19 Aug 2014 07:32:24 -0400
>Subject: [PATCH] [SIGNED OFF] Bug 9011 [QA Followup 4] - Add issue_id to
> issues tables
>
>Signed-off-by: Nick Clemens <nick@quecheelibrary.org>
>---
> installer/data/mysql/updatedatabase.pl |   14 +++++++++++++-
> 1 file changed, 13 insertions(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 3467911..4a547dd 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -8615,7 +8615,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";
>    SetVersion ($DBversion);
>-- 
>1.7.10.4

Actions: View | Diff | Splinter Review

Attachments on bug 9011: 13258 | 15117 | 15200 | 16666 | 16763 | 16773 | 18676 | 20180 | 20181 | 20329 | 20342 | 20343 | 20344 | 22577 | 22578 | 22579 | 25866 | 25867 | 25868 | 25869 | 25870 | 25871 | 25872 | 25873 | 28923 | 28924 | 28925 | 29301 | 29745 | 29749 | 29750 | 29930 | 29931 | 30979 | 30993 | 30994 | 30995 | 30996 | 30997 | 30998 | 30999 | 32430 | 32431 | 32432 | 32433 | 32434 | 32435 | 32436 | 32437 | 32438 | 32439 | 32440 | 32441 | 32442 | 32443 | 32977 | 37113 | 37114 | 37115 | 37116 | 37117 | 38441 | 38442 | 38443 | 38444 | 38445 | 39812 | 39813 | 39814 | 39815 | 39816