From c2b9b3f8312f4d33f0e9cecfccb125af7a05415c Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 24 Oct 2017 14:57:54 -0300 Subject: [PATCH] Bug 19028: DBRev 17.06.00.020 Signed-off-by: Jonathan Druart --- Koha.pm | 2 +- .../bug_19028_shelving_location_column.perl | 15 --------------- installer/data/mysql/updatedatabase.pl | 17 +++++++++++++++++ 3 files changed, 18 insertions(+), 16 deletions(-) delete mode 100644 installer/data/mysql/atomicupdate/bug_19028_shelving_location_column.perl diff --git a/Koha.pm b/Koha.pm index 07e7115b86..3c82d0a433 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 = "17.06.00.019"; +$VERSION = "17.06.00.020"; sub version { return $VERSION; diff --git a/installer/data/mysql/atomicupdate/bug_19028_shelving_location_column.perl b/installer/data/mysql/atomicupdate/bug_19028_shelving_location_column.perl deleted file mode 100644 index 5f41e889d9..0000000000 --- a/installer/data/mysql/atomicupdate/bug_19028_shelving_location_column.perl +++ /dev/null @@ -1,15 +0,0 @@ -$DBversion = 'XXX'; -if( CheckVersion( $DBversion ) ) { - $dbh->do(q{ - UPDATE systempreferences - SET - variable='OpacLocationOnDetail', - options='holding|home|both|column', - explanation='In the OPAC detail, display the shelving location on its own column or under a library columns.' - WHERE - variable='OpacLocationBranchToDisplayShelving' - }); - - SetVersion( $DBversion ); - print "Upgrade to $DBversion done (Bug 19028: Add 'shelving location' to holdings table in detail page)\n"; -} \ No newline at end of file diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index b84efd9df4..08db4e3744 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -14857,6 +14857,23 @@ if( CheckVersion( $DBversion ) ) { print "Upgrade to $DBversion done (Bug 12768 - Add 'Processing Fee' to the account_offset_types table if missing)"; } +$DBversion = '17.06.00.020'; +if( CheckVersion( $DBversion ) ) { + $dbh->do(q{ + UPDATE systempreferences + SET + variable='OpacLocationOnDetail', + options='holding|home|both|column', + explanation='In the OPAC detail, display the shelving location on its own column or under a library columns.' + WHERE + variable='OpacLocationBranchToDisplayShelving' + }); + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 19028: Add 'shelving location' to holdings table in detail page (Rename syspref OpacLocationBranchToDisplayShelving with OpacLocationOnDetail))\n"; +} + + # DEVELOPER PROCESS, search for anything to execute in the db_update directory # SEE bug 13068 -- 2.39.5