From f42baffc94b4e910a46c94908f09e312d1139501 Mon Sep 17 00:00:00 2001
From: Nick Clemens <nick@bywatersolutions.com>
Date: Fri, 8 Jan 2021 14:37:30 +0000
Subject: [PATCH] Bug 27349: (QA follow-up) Move DB update to perl file and add
 description

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit 37b5a14f4ca07a6b25960764a4214b00f9831542)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
---
 installer/data/mysql/atomicupdate/bug_27349.perl | 5 +++++
 installer/data/mysql/atomicupdate/bug_27349.sql  | 1 -
 2 files changed, 5 insertions(+), 1 deletion(-)
 create mode 100644 installer/data/mysql/atomicupdate/bug_27349.perl
 delete mode 100644 installer/data/mysql/atomicupdate/bug_27349.sql

diff --git a/installer/data/mysql/atomicupdate/bug_27349.perl b/installer/data/mysql/atomicupdate/bug_27349.perl
new file mode 100644
index 0000000000..e12325b396
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_27349.perl
@@ -0,0 +1,5 @@
+$DBversion = 'XXX';
+if( CheckVersion( $DBversion ) ) {
+    $dbh->do(q{UPDATE systempreferences SET `type` = 'Choice' WHERE `variable` = 'Mana'});
+    NewVersion( $DBversion, 27349, "Update type for Mana sytem preference to Choice");
+}
diff --git a/installer/data/mysql/atomicupdate/bug_27349.sql b/installer/data/mysql/atomicupdate/bug_27349.sql
deleted file mode 100644
index 23324f7a00..0000000000
--- a/installer/data/mysql/atomicupdate/bug_27349.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE systempreferences SET `type` = 'Choice' WHERE `variable` = 'Mana';
-- 
2.20.1