From cf083a569c43a5e7f86aed570401be0b61bc685b Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Mon, 15 Dec 2014 07:02:13 -0500 Subject: [PATCH] Bug 13023: (QA Followup) Add db mapping to frameworks Signed-off-by: Tomas Cohen Arazi --- .../marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marcflavour/marc21/optional/marc21_fastadd_framework.sql | 2 +- .../marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../en/marcflavour/marc21/optional/marc21_fastadd_framework.sql | 2 +- .../marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marcflavour/marc21/optional/marc21_fastadd_framework.sql | 2 +- .../marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql | 2 +- .../unimarc_complet/Obligatoire/framework_DEFAULT.sql | 2 +- .../marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marcflavour/marc21/optional/marc21_fastadd_framework.sql | 2 +- .../marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marcflavour/marc21/optional/marc21_fastadd_framework.sql | 2 +- .../mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql | 2 +- .../marcflavour/normarc/Valgfritt/normarc_fastadd_framework.sql | 2 +- .../marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql | 2 +- .../marc21/optional/marc21_bibliographic_FA_local.sql | 2 +- .../marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql | 2 +- 18 files changed, 18 insertions(+), 18 deletions(-) diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index f88f4bcd50..0abd590d2e 100644 --- a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -119,7 +119,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('952', 'u', 'URL', 'URL', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Preis bei Buchersatz', 'Preis bei Buchersatz', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Preis gültig von', 'Preis gültig von', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Interne Notiz', 'Interne Notiz', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Interne Notiz', 'Interne Notiz', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Koha-Medientyp', 'Koha-Medientyp', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'OPAC-Notiz', 'OPAC-Notiz', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql index ce36a1a5b3..bae61417f7 100644 --- a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql +++ b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql @@ -134,7 +134,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('952', 'u', 'URL', 'URL', 0, 0, 'items.uri', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), ('952', 'v', 'Preis bei Buchersatz', 'Preis bei Buchersatz', 0, 0, 'items.replacementprice', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), ('952', 'w', 'Preis gültig von', 'Preis gültig von', 0, 0, 'items.replacementpricedate', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'x', 'Interne Notiz', 'Interne Notiz', 1, 0, 'items.paidfor', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'x', 'Interne Notiz', 'Interne Notiz', 1, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), ('952', 'y', 'Koha-Medientyp', 'Koha-Medientyp', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'FA', '', NULL, NULL), ('952', 'z', 'OPAC-Notiz', 'OPAC-Notiz', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), ('999', 'c', 'Koha-Biblionummer', 'Koha-Biblionummer', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL), diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index 30303ca050..7a8316c5c0 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -119,7 +119,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('952', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql index ef62b871d3..2d6b84cd91 100644 --- a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql +++ b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql @@ -134,7 +134,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', 'Non-public note', 'Non-public note', 1, 0, 'items.paidfor', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'x', 'Non-public note', 'Non-public 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/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index 1a9f79cdd2..c178307224 100644 --- a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -119,7 +119,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('952', 'u', 'Identificador Uniforme del Recurso', 'Identificador Uniforme del Recurso', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Coste, precio de reemplazo', 'Coste, precio de reemplazo', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Precio válido a partir de', 'Precio válido a partir de', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Nota no pública', 'Nota no pública', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Nota no pública', 'Nota no pública', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Tipo de ítem Koha', 'Tipo de ítem Koha', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'Nota pública', 'Nota pública', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql index 91c59e600b..c1bce6fdf9 100644 --- a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql +++ b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql @@ -134,7 +134,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('952', 'u', 'Identificador Uniforme del Recurso', 'Identificador Uniforme del Recurso', 0, 0, 'items.uri', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), ('952', 'v', 'Coste, precio de reemplazo', 'Coste, precio de reemplazo', 0, 0, 'items.replacementprice', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), ('952', 'w', 'Precio válido a partir de', 'Precio válido a partir de', 0, 0, 'items.replacementpricedate', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'x', 'Nota no pública', 'Nota no pública', 1, 0, 'items.paidfor', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'x', 'Nota no pública', 'Nota no pública', 1, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), ('952', 'y', 'Tipo de ítem Koha', 'Tipo de ítem Koha', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'FA', '', NULL, NULL), ('952', 'z', 'Nota pública', 'Nota pública', 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/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql b/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql index ad0611e8d8..6dcb0ba5bf 100644 --- a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql @@ -135,7 +135,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql b/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql index b54b4dda14..17adc07c39 100644 --- a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql +++ b/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql @@ -2130,7 +2130,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('995', 'w', 'Nombre de prêts', '', 0, 0, 'items.issues', 10, '', '', '', 0, 7, '', NULL, '', ''), ('995', 'x', 'Nombre de renouvellements', '', 0, 0, 'items.renewals', 10, '', '', '', 0, -6, '', NULL, '', ''), ('995', 'y', 'Date derniere lecture cb/inventaire', '', 0, 0, 'items.datelastseen', 10, '', '', '', 0, 7, '', NULL, '', ''), -('995', 'z', 'Note interne', '', 0, 0, 'items.nonpublicnote', 10, '', '', '', 0, 0, '', NULL, '', ''); +('995', 'z', 'Note interne', '', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', 0, 0, '', NULL, '', ''); UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000'; diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index c53a087574..55e60c1ee0 100644 --- a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -119,7 +119,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('952', 'u', 'URI (Uniform Resource Identifier)', 'URI (Uniform Resource Identifier)', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Costo, costo di riacquisto', 'Costo, costo di riacquisto', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Prezzo in vigore dal', 'Prezzo in vigore dal', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Nota non pubblica', 'Nota non pubblica', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Nota non pubblica', 'Nota non pubblica', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Tipo copia default (Koha)', 'Tipo copia default (Koha)', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'Nota pubblica', 'Nota pubblica', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql index c46f5473bd..3706025031 100644 --- a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql +++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql @@ -134,7 +134,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('952', 'u', 'URI (Uniform Resource Identifier)', 'URI (Uniform Resource Identifier)', 0, 0, 'items.uri', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), ('952', 'v', 'Costo, costo di riacquisto', 'Costo, costo di riacquisto', 0, 0, 'items.replacementprice', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), ('952', 'w', 'Prezzo in vigore dal', 'Prezzo in vigore dal', 0, 0, 'items.replacementpricedate', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'x', 'Nota non pubblica', 'Nota non pubblica', 1, 0, 'items.paidfor', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'x', 'Nota non pubblica', 'Nota non pubblica', 1, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), ('952', 'y', 'Tipo copia default (Koha)', 'Tipo copia default (Koha)', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'FA', '', NULL, NULL), ('952', 'z', 'Nota pubblica', 'Nota pubblica', 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/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index 43c1a18776..600aa0858b 100644 --- a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -135,7 +135,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql index c54c369efa..3b5d7bba1b 100644 --- a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql +++ b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql @@ -131,7 +131,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 (lost item payment)','Nonpublic note (lost item payment)',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/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql b/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql index 3bb286dcd9..0d878173f8 100644 --- a/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql +++ b/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql @@ -1001,7 +1001,7 @@ INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,r INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','u','Uniform Resource Identifier (URI)','Uniform Resource Identifier (URI)','0','0','items.uri','10','','','','1','0','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','v','Pris (erstatningspris)','Pris (erstatningspris)','0','0','items.replacementprice','10','','','','0','0','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','w','Pris gjelder fra','Pris gjelder fra','0','0','items.replacementpricedate','10','','','','0','0','','','',NULL,'9999'); -INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','x','Intern note','Intern note','1','0','items.paidfor','10','','','',NULL,'7','','','',NULL,'9999'); +INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','x','Intern note','Intern note','1','0','items.itemnotes_nonpublic','10','','','',NULL,'7','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','y','Koha dokumenttype','Koha dokumenttype','0','0','items.itype','10','itemtypes','','',NULL,'0','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','z','Synlig note','Synlig note','0','0','items.itemnotes','10','','','',NULL,'0','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('999','a','Dokumenttype [Ikke i bruk]','Dokumenttype [Ikke i bruk]','0','0',NULL,'-1',NULL,NULL,'',NULL,'-5','','','',NULL,'9999'); diff --git a/installer/data/mysql/nb-NO/marcflavour/normarc/Valgfritt/normarc_fastadd_framework.sql b/installer/data/mysql/nb-NO/marcflavour/normarc/Valgfritt/normarc_fastadd_framework.sql index 13f34761ed..ae4d676987 100644 --- a/installer/data/mysql/nb-NO/marcflavour/normarc/Valgfritt/normarc_fastadd_framework.sql +++ b/installer/data/mysql/nb-NO/marcflavour/normarc/Valgfritt/normarc_fastadd_framework.sql @@ -120,7 +120,7 @@ INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,r INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','u','Uniform Resource Identifier (URI)','Uniform Resource Identifier (URI)','0','0','items.uri','10','','','','1','0','FA','','','','9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','v','Pris (erstatningspris)','Pris (erstatningspris)','0','0','items.replacementprice','10','','','','0','0','FA','','','','9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','w','Pris gjelder fra','Pris gjelder fra','0','0','items.replacementpricedate','10','','','','0','0','FA','','','','9999'); -INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','x','Intern note','Intern note','1','0','items.paidfor','10','','','','0','7','FA','','','','9999'); +INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','x','Intern note','Intern note','1','0','items.itemnotes_nonpublic','10','','','','0','7','FA','','','','9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','y','Koha dokumenttype','Koha dokumenttype','0','0','items.itype','10','itemtypes','','','0','0','FA','','','','9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','z','Synlig note','Synlig note','0','0','items.itemnotes','10','','','','0','0','FA','','','','9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('999','c','Koha biblionummer','Koha biblionummer','0','0','biblio.biblionumber','-1','','','','0','-5','FA','','','','9999'); diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index 64cd1bcec0..3671529e86 100644 --- a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -135,7 +135,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql index 7e24eb05fe..68a1335c7d 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql @@ -818,7 +818,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, 0, 'Служебное (необщедоступное) примечание', '', 10, 1, '', '', '', NULL, '', '', NULL), + ('', '', '952', 'x', 0, 0, 'Служебное (необщедоступное) примечание', '', 10, 1, '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/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql index 4cc990a6f0..a0a676d0a8 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql +++ b/installer/data/mysql/ru-RU/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); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql index 1fe39108b5..8f9b2cd9d1 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql @@ -818,7 +818,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, 0, 'Службова (незагальнодоступна) примітка', '', 10, 1, '', '', '', NULL, '', '', NULL), + ('', '', '952', 'x', 0, 0, 'Службова (незагальнодоступна) примітка', '', 10, 1, '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); -- 2.20.1