Attachment 125830 Details for Bug 18984 – Bug 18984: DB changes

[patch] Bug 18984: DB changes

Bug-18984-DB-changes.patch (text/plain), 1.06 KB, created by Jonathan Druart on 2021-10-06 15:00:27 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2021-10-06 15:00:27 UTC

Size: 1.06 KB

patch

obsolete

>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

Actions: View | Diff | Splinter Review

Attachments on bug 18984: 115514 | 115515 | 120397 | 120398 | 125417 | 125418 | 125819 | 125820 | 125826 | 125827 | 125828 | 125829 | 125830 | 125850 | 125851 | 125852 | 125876 | 125877 | 125878