From a5e0c1a3e985f21f3585c7ce6f7367696e054b32 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Wed, 6 Oct 2021 17:00:07 +0200
Subject: [PATCH] Bug 18984: DB changes

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
---
 installer/data/mysql/atomicupdate/bug_18984.pl | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100755 installer/data/mysql/atomicupdate/bug_18984.pl

diff --git a/installer/data/mysql/atomicupdate/bug_18984.pl b/installer/data/mysql/atomicupdate/bug_18984.pl
new file mode 100755
index 0000000000..5c92ad7313
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_18984.pl
@@ -0,0 +1,12 @@
+use Modern::Perl;
+
+return {
+    bug_number => "18984",
+    description => "Remove NORMARC from search_marc_map.marc_type",
+    up => sub {
+        my ($args) = @_;
+        my ($dbh, $out) = @$args{qw(dbh out)};
+        $dbh->do(q{DELETE FROM search_marc_map WHERE marc_type='normarc'});
+        $dbh->do(q{ALTER TABLE search_marc_map MODIFY `marc_type` enum('marc21','unimarc') COMMENT 'what MARC type this map is for'});
+    },
+}
-- 
2.39.5