Attachment 110805 Details for Bug 26268 – Bug 26268: Correct mapping for internal note to items.itemnotes_nonpublic

[patch] Bug 26268: Correct mapping for internal note to items.itemnotes_nonpublic

Bug-26268-Correct-mapping-for-internal-note-to-ite.patch (text/plain), 6.70 KB, created by Katrin Fischer on 2020-09-26 21:55:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2020-09-26 21:55:33 UTC

Size: 6.70 KB

patch

obsolete

>From f915531789c8a83d7474286dd5c4c82abc3fcc5a Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <katrin.fischer.83@web.de>
>Date: Sat, 26 Sep 2020 23:44:02 +0200
>Subject: [PATCH] Bug 26268: Correct mapping for internal note to
> items.itemnotes_nonpublic
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> .../marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql     | 2 +-
> .../unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql       | 1 -
> .../optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql       | 2 +-
> .../uk-UA/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql | 2 +-
> 4 files changed, 3 insertions(+), 4 deletions(-)
>
>diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql
>index 77dde7ed78..8e984af85a 100644
>--- a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql
>+++ b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql
>@@ -132,7 +132,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('952','u','Uniform Resource Identifier','Uniform Resource Identifier',0,0,'items.uri',10,'','','',NULL,0,'FA','',NULL,NULL),
> 		('952','v','Cost, replacement price','Cost, replacement price',0,0,'items.replacementprice',10,'','','',NULL,0,'FA','',NULL,NULL),
> 		('952','w','Price effective from','Price effective from',0,0,'items.replacementpricedate',10,'','','',NULL,0,'FA','',NULL,NULL),
>-		('952','x','Nonpublic note (lost item payment)','Nonpublic note (lost item payment)',1,0,'items.paidfor',10,'','','',NULL,0,'FA','',NULL,NULL),
>+		('952','x','Nonpublic note','Nonpublic note',1,0,'items.itemnotes_nonpublic',10,'','','',NULL,0,'FA','',NULL,NULL),
> 		('952','y','Koha item type','Koha item type',0,0,'items.itype',10,'itemtypes','','',NULL,0,'FA','',NULL,NULL),
> 		('952','z','Public note','Public note',0,0,'items.itemnotes',10,'','','',NULL,0,'FA','',NULL,NULL),
>                 ('999', 'c', 'Koha biblionumber', 'Koha biblionumber', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL),
>diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql
>index c6aad46de1..64516d9c4b 100644
>--- a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql
>+++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql
>@@ -406,7 +406,6 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
> # restricted					995^3		ÑÑÐ°ÑÑÑ Ð¾Ð³ÑÐ°Ð½Ð¸ÑÐµÐ½Ð¸Ñ Ð´Ð¾ÑÑÑÐ¿Ð°
> # itemnotes						995^u		Ð¾Ð±ÑÐµÐ´Ð¾ÑÑÑÐ¿Ð½Ð¾Ðµ Ð¿ÑÐ¸Ð¼ÐµÑÐ°Ð½Ð¸Ðµ Ð¾ ÑÐºÐ·ÐµÐ¼Ð¿Ð»ÑÑÐµ
> # holdingbranch				995^Ñ		Ð¼ÐµÑÑÐ¾ Ð²ÑÐµÐ¼ÐµÐ½Ð½Ð¾Ð³Ð¾ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð¸Ð»Ð¸ Ð²ÑÐ´Ð°ÑÐ¸ (Ð¿Ð¾Ð´ÑÐ°Ð·Ð´ÐµÐ»ÐµÐ½Ð¸Ðµ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ), ÐºÐ¾Ð´
>-# paidfor									Ð¿Ð»Ð°ÑÐµÐ¶ Ð·Ð° ÑÑÑÐ°ÑÐµÐ½Ð½ÑÐ¹ ÑÐºÐ·ÐµÐ¼Ð¿Ð»ÑÑ
> # timestamp						995^g		Ð´Ð°ÑÐ° Ð¿Ð¾ÑÐ»ÐµÐ´Ð½ÐµÐ³Ð¾ ÑÐµÐ´Ð°ÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ ÑÐºÐ·ÐµÐ¼Ð¿Ð»ÑÑÐ°
> # location						995^e		ÑÐµÐºÑÑÐµÐµ Ð¿Ð¾Ð»Ð¾ÑÐ½Ð¾Ðµ ÑÐ°ÑÐ¿Ð¾Ð»Ð¾Ð¶ÐµÐ½Ð¸Ðµ
> # permanent_location						Ð¿Ð¾ÑÑÐ¾ÑÐ½Ð½Ð¾Ðµ Ð¿Ð¾Ð»Ð¾ÑÐ½Ð¾Ðµ ÑÐ°ÑÐ¿Ð¾Ð»Ð¾Ð¶ÐµÐ½Ð¸Ðµ
>diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql
>index 2086895536..659d27afa6 100644
>--- a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql
>+++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql
>@@ -128,7 +128,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
>  ('', '', '952', 'u', 0, 0, 'Ð£Ð½ÑÑÑÐºÐ¾Ð²Ð°Ð½Ð¸Ð¹ ÑÐ´ÐµÐ½ÑÐ¸ÑÑÐºÐ°ÑÐ¾Ñ ÑÐµÑÑÑÑÑÐ²', '',  10, 0, 'items.uri', '', '', 1, '', '', NULL),
>  ('', '', '952', 'v', 0, 0, 'Ð¡ÑÐ¾Ð¸Ð¼Ð¾ÑÑÑ, ÑÐµÐ½Ð° Ð·Ð°Ð¼ÐµÐ½Ñ', '',               10, 0, 'items.replacementprice', '', '', 0, '', '', NULL),
>  ('', '', '952', 'w', 0, 0, 'ÐÐ°ÑÐ°, Ð´Ð»Ñ ÐºÐ¾ÑÐ¾ÑÐ¾Ð¹ Ð´ÐµÐ¹ÑÑÐ²Ð¸ÑÐµÐ»ÑÐ½Ð° ÑÐµÐ½Ð°', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL),
>- ('', '', '952', 'x', 0, 1, 'Ð¡Ð»ÑÐ¶ÐµÐ±Ð½Ð¾Ðµ Ð¿ÑÐ¸Ð¼ÐµÑÐ°Ð½Ð¸Ðµ (lost item payment)', '', 10, 7, 'items.paidfor', '', '', NULL, '', '', NULL),
>+ ('', '', '952', 'x', 0, 1, 'Ð¡Ð»ÑÐ¶ÐµÐ±Ð½Ð¾Ðµ Ð¿ÑÐ¸Ð¼ÐµÑÐ°Ð½Ð¸Ðµ', '',                 10, 7, 'items.itemnotes_nonpublic', '', '', NULL, '', '', NULL),
>  ('', '', '952', 'y', 0, 0, 'Ð¢Ð¸Ð¿ ÐµÐ´Ð¸Ð½Ð¸ÑÑ (ÑÑÐ¾Ð²ÐµÐ½Ñ ÑÐºÐ·ÐµÐ¼Ð¿Ð»ÑÑÐ°)', '',     10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL),
>  ('', '', '952', 'z', 0, 0, 'ÐÐ±ÑÐµÐ´Ð¾ÑÑÑÐ¿Ð½Ð¾Ðµ Ð¿ÑÐ¸Ð¼ÐµÑÐ°Ð½Ð¸Ðµ', '',             10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL);
> 
>diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql
>index aad758b847..8259608aa9 100644
>--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql
>+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql
>@@ -55,7 +55,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
>  ('FA', '', '952', 'u', 0, 0, 'Ð£Ð½ÑÑÑÐºÐ¾Ð²Ð°Ð½Ð¸Ð¹ ÑÐ´ÐµÐ½ÑÐ¸ÑÑÐºÐ°ÑÐ¾Ñ ÑÐµÑÑÑÑÑÐ²', '', 10, 0, 'items.uri', '', '', NULL, '', NULL, NULL),
>  ('FA', '', '952', 'v', 0, 0, 'ÐÐ°ÑÑÑÑÑÑ, ÑÑÐ½Ð° Ð·Ð°Ð¼ÑÐ½Ð¸', '',              10, 0, 'items.replacementprice', '', '', NULL, '', NULL, NULL),
>  ('FA', '', '952', 'w', 0, 0, 'ÐÐ°ÑÐ°, Ð´Ð»Ñ ÑÐºÐ¾Ñ ÑÐ¸Ð½Ð½Ð° ÑÑÐ½Ð° Ð·Ð°Ð¼ÑÐ½Ð¸', '',   10, 0, 'items.replacementpricedate', '', '', NULL, '', NULL, NULL),
>- ('FA', '', '952', 'x', 0, 1, 'Ð¡Ð»ÑÐ¶Ð±Ð¾Ð²Ð° (Ð½ÐµÐ·Ð°Ð³Ð°Ð»ÑÐ½Ð¾Ð´Ð¾ÑÑÑÐ¿Ð½Ð°) Ð¿ÑÐ¸Ð¼ÑÑÐºÐ°', '', 10, 0, 'items.paidfor', '', '', NULL, '', NULL, NULL),
>+ ('FA', '', '952', 'x', 0, 1, 'Ð¡Ð»ÑÐ¶Ð±Ð¾Ð²Ð° (Ð½ÐµÐ·Ð°Ð³Ð°Ð»ÑÐ½Ð¾Ð´Ð¾ÑÑÑÐ¿Ð½Ð°) Ð¿ÑÐ¸Ð¼ÑÑÐºÐ°', '', 10, 0, 'items.itemnotes_nonpublic', '', '', NULL, '', NULL, NULL),
>  ('FA', '', '952', 'y', 0, 0, 'Ð¢Ð¸Ð¿ Ð¾Ð´Ð¸Ð½Ð¸ÑÑ (ÑÑÐ²ÐµÐ½Ñ Ð¿ÑÐ¸Ð¼ÑÑÐ½Ð¸ÐºÐ°)', '',    10, 0, 'items.itype', 'itemtypes', '', NULL, '', NULL, NULL),
>  ('FA', '', '952', 'z', 0, 0, 'ÐÐ°Ð³Ð°Ð»ÑÐ½Ð¾Ð´Ð¾ÑÑÑÐ¿Ð½Ð° Ð¿ÑÐ¸Ð¼ÑÑÐºÐ° ÑÐ¾Ð´Ð¾ Ð¿ÑÐ¸Ð¼ÑÑÐ½Ð¸ÐºÐ°', '', 10, 0, 'items.itemnotes', '', '', NULL, '', NULL, NULL);
> 
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 26268: 108797 | 108799 | 108807 | 108808 | 108809 | 108810 | 108812 | 108813 | 108814 | 109674 | 109675 | 109676 | 109677 | 109930 | 109931 | 109932 | 109933 | 109934 | 110801 | 110802 | 110803 | 110804 | 110805 | 110806 | 110836 | 110837 | 110838 | 110839 | 110840 | 110841 | 110935