From b732ae8cd01beac84c2576e37412f2270c8219d1 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

---
 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 00000000000..5c92ad73130
--- /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.25.1