Attachment 111833 Details for Bug 26613 – Bug 26613: Fix it-IT unimarc_framework.sql installer file

[patch] Bug 26613: Fix it-IT unimarc_framework.sql installer file

Bug-26613-Fix-it-IT-unimarcframeworksql-installer-.patch (text/plain), 9.67 KB, created by Julian Maurice on 2020-10-16 08:27:40 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Julian Maurice

Created: 2020-10-16 08:27:40 UTC

Size: 9.67 KB

patch

obsolete

>From 373b89a8351348bf349d87ea106a5bb2d0fdafe4 Mon Sep 17 00:00:00 2001
>From: John Fawcett <john@voipsupport.it>
>Date: Mon, 12 Oct 2020 11:18:30 +0200
>Subject: [PATCH] Bug 26613: Fix it-IT unimarc_framework.sql installer file
>
>This is really an installation issue, though at the
>time of installation it did not result in any error.
>
>During cataloguing in the items menu the "Type of item or material"
>is not constrained by the itemtypes authorised_values (as it is for 942c records).
>
>I have added the itemtypes to the installer sql in unimarc_framework.sql
>as well as adding the description of this field for OPAC, which had been left empty.
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
>---
> .../marcflavour/unimarc/necessari/unimarc_framework.sql     | 6 +++---
> 1 file changed, 3 insertions(+), 3 deletions(-)
>
>diff --git a/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql b/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql
>index b3876be482..5c79ca463f 100644
>--- a/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql
>+++ b/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql
>@@ -2547,7 +2547,7 @@ insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','o','Tipo di circolazione (non a prestito)','',0,0,'items.notforloan',10,'','','',0,-5,'',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','p','Periodico','',0,0,'',10,'','','',0,-1,'',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','q','Pubblico destinato (etÃ )','',0,0,'',10,'','','',0,-1,'',NULL,'','');
>-insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','r','Tipo della copia e materiale','',0,1,'items.itype',10,'','','',0,0,'',NULL,'','');
>+insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','r','Tipo della copia e materiale','Tipo della copia e materiale',0,1,'items.itype',10,'itemtypes','','',0,0,'',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','s','ModalitÃ  d\'acquisto','',0,0,'',10,'','','',0,-1,'',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','t','Genere','',0,0,'',10,'','','',0,-1,'',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','u','Nota della copia','',0,0,'items.itemnotes',10,'','','',0,0,'',NULL,'','');
>@@ -2605,7 +2605,7 @@ insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','o','Tipo di circolazione (non a prestito)','',0,0,'items.notforloan',10,'','','',0,-5,'MN',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','p','Periodico','',0,0,'',10,'','','',0,-1,'MN',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','q','Pubblico destinato (etÃ )','',0,0,'',10,'','','',0,-1,'MN',NULL,'','');
>-insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','r','Tipo della copia e materiale','',0,1,'items.itype',10,'','','',0,0,'MN',NULL,'','');
>+insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','r','Tipo della copia e materiale','Tipo della copia e materiale',0,1,'items.itype',10,'itemtypes','','',0,0,'MN',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','s','ModalitÃ  d\'acquisto','',0,0,'',10,'','','',0,-1,'MN',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','t','Genere','',0,0,'',10,'','','',0,-1,'MN',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','u','Nota della copia','',0,0,'items.itemnotes',10,'','','',0,0,'MN',NULL,'','');
>@@ -2665,7 +2665,7 @@ insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','o','Tipo di circolazione (non a prestito)','',0,0,'items.notforloan',10,'','','',0,-5,'PR',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','p','Periodico','',0,0,'',10,'','','',0,-1,'PR',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','q','Pubblico destinato (etÃ )','',0,0,'',10,'','','',0,-1,'PR',NULL,'','');
>-insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','r','Tipo della copia e materiale','',0,1,'items.itype',10,'','','',0,0,'PR',NULL,'','');
>+insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','r','Tipo della copia e materiale','Tipo della copia e materiale',0,1,'items.itype',10,'itemtypes','','',0,0,'PR',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','s','ModalitÃ  d\'acquisto','',0,0,'',10,'','','',0,-1,'PR',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','t','Genere','',0,0,'',10,'','','',0,-1,'PR',NULL,'','');
> insert  into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','u','Nota della copia','',0,0,'items.itemnotes',10,'','','',0,0,'PR',NULL,'','');
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 26613: 111258 | 111484 | 111826 | 111833