From e7910c67403f73ffc247c466d2336a446c4ca092 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 31 Aug 2020 14:05:05 +0000 Subject: [PATCH] Bug 20057: DBRev 20.06.00.030 Signed-off-by: Jonathan Druart --- Koha.pm | 2 +- .../atomicupdate/AutoApprovePatronProfileSettings.sql | 2 -- installer/data/mysql/updatedatabase.pl | 11 +++++++++++ 3 files changed, 12 insertions(+), 3 deletions(-) delete mode 100644 installer/data/mysql/atomicupdate/AutoApprovePatronProfileSettings.sql diff --git a/Koha.pm b/Koha.pm index 3b6ae3f730..cfee2627e8 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 = "20.06.00.029"; +$VERSION = "20.06.00.030"; sub version { return $VERSION; diff --git a/installer/data/mysql/atomicupdate/AutoApprovePatronProfileSettings.sql b/installer/data/mysql/atomicupdate/AutoApprovePatronProfileSettings.sql deleted file mode 100644 index d7c0104468..0000000000 --- a/installer/data/mysql/atomicupdate/AutoApprovePatronProfileSettings.sql +++ /dev/null @@ -1,2 +0,0 @@ -INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type`) VALUES -('AutoApprovePatronProfileSettings', '0', '', 'Automatically approve patron profile changes from the OPAC.', 'YesNo'); diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index d01f2bab91..ee5930442a 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -22678,6 +22678,17 @@ INSERT IGNORE INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Canc NewVersion( $DBversion, 25534, "Add ability to send an email specifying a reason when canceling a hold"); } +$DBversion = '20.06.00.030'; +if ( CheckVersion( $DBversion ) ) { + + $dbh->do(q{ + INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type`) VALUES + ('AutoApprovePatronProfileSettings', '0', '', 'Automatically approve patron profile changes from the OPAC.', 'YesNo'); + }); + + NewVersion( $DBversion, 20057, "Add new system preference 'AutoApprovePatronProfileSettings'"); +} + # SEE bug 13068 # if there is anything in the atomicupdate, read and execute it. my $update_dir = C4::Context->config('intranetdir') . '/installer/data/mysql/atomicupdate/'; -- 2.20.1