Attachment 60689 Details for Bug 18110 – Bug 16034 - DBRev 16.12.00.010

[patch] Bug 16034 - DBRev 16.12.00.010

Bug-16034---DBRev-161200010.patch (text/plain), 2.60 KB, created by Baptiste Wojtkowski (bwoj) on 2017-02-27 08:54:04 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Baptiste Wojtkowski (bwoj)

Created: 2017-02-27 08:54:04 UTC

Size: 2.60 KB

patch

obsolete

>From a02f9d88e52a33909977dd36c57932847ebbfbc1 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Tue, 21 Feb 2017 20:01:17 +0000
>Subject: [PATCH] Bug 16034 - DBRev 16.12.00.010
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>
>https://bugs.koha-community.org/show_bug.cgi?id=18110
>---
> Koha.pm                                         |  2 +-
> installer/data/mysql/atomicupdate/overdrive.sql |  4 ----
> installer/data/mysql/updatedatabase.pl          | 15 +++++++++++++++
> 3 files changed, 16 insertions(+), 5 deletions(-)
> delete mode 100644 installer/data/mysql/atomicupdate/overdrive.sql
>
>diff --git a/Koha.pm b/Koha.pm
>index c08f388..fb3229c 100644
>--- a/Koha.pm
>+++ b/Koha.pm
>@@ -29,7 +29,7 @@ use vars qw{ $VERSION };
> # - #4 : the developer version. The 4th number is the database subversion.
> #        used by developers when the database changes. updatedatabase take care of the changes itself
> #        and is automatically called by Auth.pm when needed.
>-$VERSION = "16.12.00.009";
>+$VERSION = "16.12.00.010";
> 
> sub version {
>     return $VERSION;
>diff --git a/installer/data/mysql/atomicupdate/overdrive.sql b/installer/data/mysql/atomicupdate/overdrive.sql
>deleted file mode 100644
>index 98cea68..0000000
>--- a/installer/data/mysql/atomicupdate/overdrive.sql
>+++ /dev/null
>@@ -1,4 +0,0 @@
>-ALTER TABLE borrowers ADD overdrive_auth_token text default NULL AFTER lastseen;
>-
>-INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
>-VALUES ('OverDriveCirculation','0','Enable client to see their OverDrive account','','YesNo');
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 4eb6588..2d94ecd 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -13907,6 +13907,21 @@ if( CheckVersion( $DBversion ) ) {
>     print "Upgrade to $DBversion done (Bug 17453 - Inter-site holds improvement)\n";
> }
> 
>+$DBversion = "16.12.00.010";
>+if( CheckVersion( $DBversion ) ) {
>+    $dbh->do(q{
>+        ALTER TABLE borrowers ADD overdrive_auth_token text default NULL AFTER lastseen;
>+    });
>+
>+    $dbh->do(q{
>+        INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
>+        VALUES ('OverDriveCirculation','0','Enable client to see their OverDrive account','','YesNo');
>+    });
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 16034 - Integration with OverDrive Patron API)\n";
>+}
>+
> # DEVELOPER PROCESS, search for anything to execute in the db_update directory
> # SEE bug 13068
> # if there is anything in the atomicupdate, read and execute it.
>-- 
>2.7.4

Actions: View | Diff | Splinter Review

Attachments on bug 18110: 60176 | 60214 | 60215 | 60426 | 60657 | 60689 | 60690 | 60694 | 60695 | 61610 | 61639 | 61650 | 61651 | 61652 | 61656 | 61796 | 62651 | 62652 | 62664 | 62740 | 62741 | 62742 | 62743 | 62744 | 62745