Attachment 129159 Details for Bug 29605 – Bug 29605: search_marc_map.marc_type

[patch] Bug 29605: search_marc_map.marc_type

Bug-29605-searchmarcmapmarctype.patch (text/plain), 1.79 KB, created by Nick Clemens (kidclamp) on 2022-01-07 13:16:29 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2022-01-07 13:16:29 UTC

Size: 1.79 KB

patch

obsolete

>From 04a1cb691aef181c46d82a473ffaa29b570ccc21 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Thu, 2 Dec 2021 12:37:33 +0100
>Subject: [PATCH] Bug 29605: search_marc_map.marc_type
>
>NOT NULL was missing when MODIFY
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>---
> installer/data/mysql/atomicupdate/bug_29605.pl | 3 +++
> installer/data/mysql/db_revs/210600031.pl      | 2 +-
> 2 files changed, 4 insertions(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_29605.pl b/installer/data/mysql/atomicupdate/bug_29605.pl
>index d07fc1f9a3..c1febb4717 100755
>--- a/installer/data/mysql/atomicupdate/bug_29605.pl
>+++ b/installer/data/mysql/atomicupdate/bug_29605.pl
>@@ -59,6 +59,9 @@ return {
>         );
>         say $out "Ensure additional_contents.lang is VARCHAR(50)";
> 
>+        $dbh->do(q{ALTER TABLE search_marc_map MODIFY `marc_type` enum('marc21','unimarc') NOT NULL COMMENT 'what MARC type this map is for'});
>+        say $out "Ensure NOT NULL on search_marc_map.marc_type";
>+
>     },
> 
> }
>diff --git a/installer/data/mysql/db_revs/210600031.pl b/installer/data/mysql/db_revs/210600031.pl
>index 5c92ad7313..c62450925f 100755
>--- a/installer/data/mysql/db_revs/210600031.pl
>+++ b/installer/data/mysql/db_revs/210600031.pl
>@@ -7,6 +7,6 @@ return {
>         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'});
>+        $dbh->do(q{ALTER TABLE search_marc_map MODIFY `marc_type` enum('marc21','unimarc') NOT NULL COMMENT 'what MARC type this map is for'});
>     },
> }
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 29605: 128113 | 128114 | 128152 | 128153 | 128154 | 128155 | 128156 | 128157 | 128158 | 128239 | 128313 | 128314 | 128437 | 128438 | 128439 | 128440 | 128441 | 128442 | 128443 | 128444 | 128445 | 128483 | 129153 | 129154 | 129155 | 129156 | 129157 | 129158 | 129159 | 129160 | 129161