From f2579bd8d2d1776ac91cec199f6c6cd420bf1756 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Thu, 26 Mar 2020 11:54:44 +0000 Subject: [PATCH] Bug 20415: DBRev 19.12.00.056 Signed-off-by: Martin Renvoize --- Koha.pm | 2 +- installer/data/mysql/atomicupdate/bug_20415.sql | 1 - installer/data/mysql/updatedatabase.pl | 10 ++++++++++ 3 files changed, 11 insertions(+), 2 deletions(-) delete mode 100644 installer/data/mysql/atomicupdate/bug_20415.sql diff --git a/Koha.pm b/Koha.pm index 3c332dffe6..6da12a6d29 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 = "19.12.00.055"; +$VERSION = "19.12.00.056"; sub version { return $VERSION; diff --git a/installer/data/mysql/atomicupdate/bug_20415.sql b/installer/data/mysql/atomicupdate/bug_20415.sql deleted file mode 100644 index f1bb79bd59..0000000000 --- a/installer/data/mysql/atomicupdate/bug_20415.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM systempreferences WHERE variable='UseKohaPlugins'; \ No newline at end of file diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 65ecbb7169..3c62761737 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -21296,6 +21296,7 @@ if( CheckVersion( $DBversion ) ) { $dbh->do(q| ALTER TABLE suggestions ADD CONSTRAINT `suggestions_ibfk_lastmodificationby` FOREIGN KEY (`lastmodificationby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE + A |); } @@ -21335,6 +21336,15 @@ if( CheckVersion( $DBversion ) ) { NewVersion( $DBversion, 23590, "Add lastmodificationby and lastmodificationdate to the suggestions table"); } +$DBversion = '19.12.00.056'; +if( CheckVersion( $DBversion ) ) { + + $dbh->do( "DELETE FROM systempreferences WHERE variable='UseKohaPlugins'" ); + + NewVersion( $DBversion, 20415, "Remove UseKohaPlugins preference"); +} + + # 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.39.5