Attachment 88218 Details for Bug 21336 – Bug 21336: Add borrowers.flgAnonymized in an explicit position

[patch] Bug 21336: Add borrowers.flgAnonymized in an explicit position

Bug-21336-Add-borrowersflgAnonymized-in-an-explici.patch (text/plain), 1.54 KB, created by Tomás Cohen Arazi (tcohen) on 2019-04-17 17:39:57 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2019-04-17 17:39:57 UTC

Size: 1.54 KB

patch

obsolete

>From 580477d2f64528415ee7eccd40bd59846f653fb3 Mon Sep 17 00:00:00 2001
>From: Tomas Cohen Arazi <tomascohen@theke.io>
>Date: Wed, 17 Apr 2019 14:34:24 -0300
>Subject: [PATCH] Bug 21336: Add borrowers.flgAnonymized in an explicit
> position
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>---
> installer/data/mysql/updatedatabase.pl | 15 +++++++++++++--
> 1 file changed, 13 insertions(+), 2 deletions(-)
>
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index e4d36516f0..6a30650907 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -18037,8 +18037,19 @@ if( CheckVersion( $DBversion ) ) {
> 
> $DBversion = '18.12.00.049';
> if( CheckVersion( $DBversion ) ) {
>-    $dbh->do( "ALTER TABLE borrowers ADD COLUMN flgAnonymized tinyint DEFAULT 0" ) if !column_exists('borrowers', 'flgAnonymized');
>-    $dbh->do( "ALTER TABLE deletedborrowers ADD COLUMN flgAnonymized tinyint DEFAULT 0" ) if !column_exists('deletedborrowers', 'flgAnonymized');
>+
>+    $dbh->do(q{
>+        ALTER TABLE borrowers
>+            ADD COLUMN flgAnonymized tinyint DEFAULT 0
>+            AFTER overdrive_auth_token
>+    }) if !column_exists('borrowers', 'flgAnonymized');
>+
>+    $dbh->do(q{
>+        ALTER TABLE deletedborrowers
>+            ADD COLUMN flgAnonymized tinyint DEFAULT 0
>+            AFTER overdrive_auth_token
>+    }) if !column_exists('deletedborrowers', 'flgAnonymized');
>+
>     SetVersion( $DBversion );
>     print "Upgrade to $DBversion done (Bug 21336 - Add field flgAnonymized)\n";
> }
>-- 
>2.21.0

Actions: View | Diff | Splinter Review

Attachments on bug 21336: 79165 | 79166 | 79167 | 79168 | 79169 | 79170 | 80201 | 80202 | 80203 | 80204 | 80205 | 80206 | 80207 | 80208 | 80213 | 80214 | 80386 | 80387 | 80403 | 81112 | 81113 | 81114 | 81115 | 81116 | 81117 | 81118 | 81119 | 81270 | 81474 | 81475 | 81476 | 81477 | 81478 | 81479 | 81480 | 81481 | 81482 | 81483 | 82051 | 82052 | 82053 | 82054 | 82055 | 82056 | 82057 | 82058 | 82059 | 83202 | 83203 | 83204 | 83205 | 83206 | 83207 | 83208 | 83209 | 83256 | 87158 | 87159 | 87160 | 87161 | 87162 | 87163 | 87164 | 87165 | 87166 | 87167 | 87168 | 87176 | 87177 | 87178 | 87179 | 87180 | 87181 | 87182 | 87183 | 87184 | 87185 | 87387 | 87388 | 87389 | 87390 | 87391 | 87392 | 87393 | 87394 | 87395 | 87396 | 87397 | 87400 | 87401 | 88198 | 88199 | 88217 | 88218