From 8f9d941f5025f5e0b4e665229c5f5770b7f9cc6f Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 26 May 2020 12:08:23 +0200 Subject: [PATCH] Bug 25449: Set items.itype mandatory by default --- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../mandatory/marc21_framework_DEFAULT.yml | 2 +- .../obligatoire/marc21_framework_DEFAULT.sql | 2 +- .../Obligatoire/marc21_framework_DEFAULT.sql | 2 +- .../Optionnel/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_sample_fastadd_framework.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../marcflavour/normarc/Obligatorisk/normarc.sql | 2 +- .../Valgfritt/normarc_fastadd_framework.sql | 2 +- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_sample_fastadd_framework.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../marc21_bibliographic_DEFAULT_local.sql | 2 +- .../optional/marc21_bibliographic_AR_local.sql | 2 +- .../optional/marc21_bibliographic_BKS_local.sql | 2 +- .../optional/marc21_bibliographic_CF_local.sql | 2 +- .../optional/marc21_bibliographic_FA_local.sql | 2 +- .../optional/marc21_bibliographic_IR_local.sql | 2 +- .../optional/marc21_bibliographic_KT_local.sql | 2 +- .../optional/marc21_bibliographic_SER_local.sql | 2 +- .../optional/marc21_bibliographic_SR_local.sql | 2 +- .../optional/marc21_bibliographic_VR_local.sql | 2 +- ..._bibliographic_DEFAULT_local_952_obsolete.sql | 2 +- .../marc21_bibliographic_DEFAULT_local.sql | 2 +- .../optional/marc21_bibliographic_AR_local.sql | 2 +- .../optional/marc21_bibliographic_BKS_local.sql | 2 +- .../optional/marc21_bibliographic_CF_local.sql | 2 +- .../optional/marc21_bibliographic_FA_local.sql | 2 +- .../optional/marc21_bibliographic_IR_local.sql | 2 +- .../optional/marc21_bibliographic_KT_local.sql | 2 +- .../optional/marc21_bibliographic_SER_local.sql | 2 +- .../optional/marc21_bibliographic_SR_local.sql | 2 +- .../optional/marc21_bibliographic_VR_local.sql | 2 +- 35 files changed, 56 insertions(+), 56 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 f85666d007..5d4ca75e5a 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 @@ -120,7 +120,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('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, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), - ('952', 'y', 'Koha-Medientyp', 'Koha-Medientyp', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), + ('952', 'y', 'Koha-Medientyp', 'Koha-Medientyp', 0, 1, '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/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml index 1464de9eed..02a7c4b365 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml @@ -963,7 +963,7 @@ tables: liblibrarian: "Koha item type" libopac: "Koha item type" repeatable: 0 - mandatory: 0 + mandatory: 1 kohafield: items.itype tab: 10 authorised_value: itemtypes diff --git a/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_framework_DEFAULT.sql b/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_framework_DEFAULT.sql index 4b8ee13f0e..c8f9ad39c6 100644 --- a/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_framework_DEFAULT.sql @@ -110,7 +110,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ("952","v","Prix de remplacement","Prix de remplacement","0","0","items.replacementprice","10","","","","0","0","","","","","9999"), ("952","w","Prix en vigueur à partir du","Prix en vigueur à partir du","0","0","items.replacementpricedate","10","","","","0","0","","","","","9999"), ("952","x","Note non destinée au public","Note non destinée au public","0","0","","10","","","","0","1","","","","","9999"), -("952","y","Type de document","Type de document","0","0","items.itype","10","itemtypes","","","0","0","","","","","9999"), +("952","y","Type de document","Type de document","0","1","items.itype","10","itemtypes","","","0","0","","","","","9999"), ("952","z","Note destinée au public","Note destinée au public","0","0","items.itemnotes","10","","","","0","0","","","","","9999"); -- ******************************************************* 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 7106bad8b6..2adf8a2fc9 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 @@ -136,7 +136,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('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, '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', 'y', 'Koha item type', 'Koha item type', 0, 1, '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/marc21/Optionnel/marc21_simple_bib_frameworks.sql b/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql index 6cd59dbee7..bd2e948f89 100644 --- a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql +++ b/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql @@ -195,7 +195,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'BKS', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'BKS', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'BKS', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'BKS', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'BKS', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'BKS', '', '', NULL); @@ -4122,7 +4122,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'CF', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'CF', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'CF', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'CF', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'CF', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'CF', '', '', NULL); @@ -8050,7 +8050,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'SR', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'SR', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'SR', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'SR', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'SR', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'SR', '', '', NULL); @@ -11977,7 +11977,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'VR', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'VR', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'VR', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'VR', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'VR', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'VR', '', '', NULL); @@ -15903,7 +15903,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'AR', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'AR', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'AR', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'AR', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'AR', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'AR', '', '', NULL); @@ -19829,7 +19829,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'KT', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'KT', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'KT', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'KT', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'KT', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'KT', '', '', NULL); @@ -23755,7 +23755,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'IR', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'IR', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'IR', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'IR', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'IR', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'IR', '', '', NULL); @@ -27679,7 +27679,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'SER', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'SER', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'SER', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'SER', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'SER', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'SER', '', '', NULL); 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 44b8b3ca30..fb7488092d 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 @@ -120,7 +120,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('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, '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', 'y', 'Tipo copia default (Koha)', 'Tipo copia default (Koha)', 0, 1, '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/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index f6402c8148..90e962bdfc 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 @@ -136,7 +136,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('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, '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', 'y', 'Koha item type', 'Koha item type', 0, 1, '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_sample_fastadd_framework.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql index 3b5d7bba1b..f460e0dbf4 100644 --- a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql +++ b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql @@ -132,7 +132,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('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.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','y','Koha item type','Koha item type',0,1,'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), ('999', 'd', 'Koha biblioitemnumber', 'Koha biblioitemnumber', 0, 0, 'biblioitems.biblioitemnumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL); diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql index 7fb00d68e3..f380490425 100644 --- a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql @@ -194,7 +194,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'BKS', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'BKS', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'BKS', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'BKS', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'BKS', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'BKS', '', '', NULL); @@ -4120,7 +4120,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'CF', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'CF', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'CF', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'CF', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'CF', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'CF', '', '', NULL); @@ -8047,7 +8047,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'SR', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'SR', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'SR', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'SR', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'SR', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'SR', '', '', NULL); @@ -11973,7 +11973,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'VR', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'VR', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'VR', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'VR', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'VR', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'VR', '', '', NULL); @@ -15898,7 +15898,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'AR', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'AR', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'AR', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'AR', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'AR', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'AR', '', '', NULL); @@ -19822,7 +19822,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'KT', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'KT', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'KT', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'KT', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'KT', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'KT', '', '', NULL); @@ -23747,7 +23747,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'IR', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'IR', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'IR', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'IR', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'IR', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'IR', '', '', NULL); @@ -27670,7 +27670,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'SER', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'SER', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'SER', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'SER', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'SER', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'SER', '', '', 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 7015bcf694..ba557d45fa 100644 --- a/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql +++ b/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql @@ -1002,7 +1002,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','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.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','y','Koha dokumenttype','Koha dokumenttype','0','1','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'); 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','b','Koha Dewey [Ikke i bruk]','Koha Dewey [Ikke i bruk]','0','0',NULL,'0',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 fe4e25fe27..80d0213775 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 @@ -121,7 +121,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','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.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','y','Koha dokumenttype','Koha dokumenttype','0','1','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'); 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','d','Koha biblioitemnummer','Koha biblioitemnummer','0','0','biblioitems.biblioitemnumber','-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 ceb45e2ecc..c0c198c233 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 @@ -136,7 +136,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('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, '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', 'y', 'Koha item type', 'Koha item type', 0, 1, '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/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..d40df2fc75 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 @@ -133,7 +133,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('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','y','Koha item type','Koha item type',0,0,'items.itype',10,'itemtypes','','',NULL,0,'FA','',NULL,NULL), + ('952','y','Koha item type','Koha item type',0,1,'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), ('999', 'd', 'Koha biblioitemnumber', 'Koha biblioitemnumber', 0, 0, 'biblioitems.biblioitemnumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL); diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql index 905e4dbe3b..e31780872f 100644 --- a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql @@ -195,7 +195,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'BKS', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'BKS', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'BKS', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'BKS', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'BKS', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'BKS', '', '', NULL); @@ -4122,7 +4122,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'CF', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'CF', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'CF', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'CF', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'CF', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'CF', '', '', NULL); @@ -8050,7 +8050,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'SR', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'SR', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'SR', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'SR', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'SR', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'SR', '', '', NULL); @@ -11977,7 +11977,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'VR', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'VR', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'VR', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'VR', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'VR', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'VR', '', '', NULL); @@ -15903,7 +15903,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'AR', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'AR', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'AR', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'AR', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'AR', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'AR', '', '', NULL); @@ -19828,7 +19828,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'KT', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'KT', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'KT', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'KT', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'KT', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'KT', '', '', NULL); @@ -23754,7 +23754,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'IR', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'IR', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'IR', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'IR', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'IR', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'IR', '', '', NULL); @@ -27678,7 +27678,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, 'SER', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, 'SER', '', '', NULL), ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, 'SER', '', '', NULL), - ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'SER', '', '', NULL), + ('952', 'y', 'Koha item type', 'Koha item type', 0, 1, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'SER', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'SER', '', '', 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 d3b4a7b5b5..b196b34d3c 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 @@ -819,7 +819,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '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, 'items.itemnotes_nonpublic', '', '', NULL, '', '', NULL), - ('', '', '952', 'y', 0, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('', '', '952', 'y', 1, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('', '', '952', 'z', 0, 0, 'Общедоступное примечание о экземпляре', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql index 87a9d5a280..ba6683ade8 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('AR', '', '952', 'v', 0, 0, 'Стоимость, цена замены', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('AR', '', '952', 'w', 0, 0, 'Дата, для которой действительна цена замены', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('AR', '', '952', 'x', 0, 0, 'Служебное (необщедоступное) примечание', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('AR', '', '952', 'y', 0, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('AR', '', '952', 'y', 1, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('AR', '', '952', 'z', 0, 0, 'Общедоступное примечание о экземпляре', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql index 066c9ec41c..10976bbfe3 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('BKS', '', '952', 'v', 0, 0, 'Стоимость, цена замены', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('BKS', '', '952', 'w', 0, 0, 'Дата, для которой действительна цена замены', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('BKS', '', '952', 'x', 0, 0, 'Служебное (необщедоступное) примечание', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('BKS', '', '952', 'y', 0, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('BKS', '', '952', 'y', 1, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('BKS', '', '952', 'z', 0, 0, 'Общедоступное примечание о экземпляре', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql index 50590c0f38..8ade65bff2 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('CF', '', '952', 'v', 0, 0, 'Стоимость, цена замены', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('CF', '', '952', 'w', 0, 0, 'Дата, для которой действительна цена замены', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('CF', '', '952', 'x', 0, 0, 'Служебное (необщедоступное) примечание', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('CF', '', '952', 'y', 0, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('CF', '', '952', 'y', 1, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('CF', '', '952', 'z', 0, 0, 'Общедоступное примечание о экземпляре', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES 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 a0a676d0a8..05f7d5a4ab 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 @@ -56,7 +56,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('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.itemnotes_nonpublic', '', '', NULL, '', NULL, NULL), - ('FA', '', '952', 'y', 0, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', NULL, NULL), + ('FA', '', '952', 'y', 1, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', NULL, NULL), ('FA', '', '952', 'z', 0, 0, 'Общедоступное примечание о экземпляре', '', 10, 0, 'items.itemnotes', '', '', NULL, '', NULL, NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql index d088a229ce..32f56b8d9b 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('IR', '', '952', 'v', 0, 0, 'Стоимость, цена замены', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('IR', '', '952', 'w', 0, 0, 'Дата, для которой действительна цена замены', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('IR', '', '952', 'x', 0, 0, 'Служебное (необщедоступное) примечание', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('IR', '', '952', 'y', 0, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('IR', '', '952', 'y', 1, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('IR', '', '952', 'z', 0, 0, 'Общедоступное примечание о экземпляре', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql index 4c95ceae11..60d2b37aa7 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('KT', '', '952', 'v', 0, 0, 'Стоимость, цена замены', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('KT', '', '952', 'w', 0, 0, 'Дата, для которой действительна цена замены', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('KT', '', '952', 'x', 0, 0, 'Служебное (необщедоступное) примечание', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('KT', '', '952', 'y', 0, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('KT', '', '952', 'y', 1, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('KT', '', '952', 'z', 0, 0, 'Общедоступное примечание о экземпляре', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql index 18daf8bb79..24b3f524cd 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('SER', '', '952', 'v', 0, 0, 'Стоимость, цена замены', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('SER', '', '952', 'w', 0, 0, 'Дата, для которой действительна цена замены', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('SER', '', '952', 'x', 0, 0, 'Служебное (необщедоступное) примечание', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('SER', '', '952', 'y', 0, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('SER', '', '952', 'y', 1, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('SER', '', '952', 'z', 0, 0, 'Общедоступное примечание о экземпляре', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql index e7e1c5d79b..a2f816b7c8 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('SR', '', '952', 'v', 0, 0, 'Стоимость, цена замены', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('SR', '', '952', 'w', 0, 0, 'Дата, для которой действительна цена замены', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('SR', '', '952', 'x', 0, 0, 'Служебное (необщедоступное) примечание', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('SR', '', '952', 'y', 0, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('SR', '', '952', 'y', 1, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('SR', '', '952', 'z', 0, 0, 'Общедоступное примечание о экземпляре', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql index 40ea88718a..fd0805f07a 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('VR', '', '952', 'v', 0, 0, 'Стоимость, цена замены', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('VR', '', '952', 'w', 0, 0, 'Дата, для которой действительна цена замены', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('VR', '', '952', 'x', 0, 0, 'Служебное (необщедоступное) примечание', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('VR', '', '952', 'y', 0, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('VR', '', '952', 'y', 1, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('VR', '', '952', 'z', 0, 0, 'Общедоступное примечание о экземпляре', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES 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..778b29b385 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 @@ -129,7 +129,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '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', 'y', 0, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('', '', '952', 'y', 1, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('', '', '952', 'z', 0, 0, 'Общедоступное примечание', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES 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 8b64c97843..50327dffa5 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 @@ -819,7 +819,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '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, 'items.itemnotes_nonpublic', '', '', NULL, '', '', NULL), - ('', '', '952', 'y', 0, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('', '', '952', 'y', 1, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('', '', '952', 'z', 0, 0, 'Загальнодоступна примітка щодо примірника', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql index 2824beb754..881ced4aaf 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('AR', '', '952', 'v', 0, 0, 'Вартість, ціна заміни', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('AR', '', '952', 'w', 0, 0, 'Дата, для якої чинна ціна заміни', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('AR', '', '952', 'x', 0, 0, 'Службова (незагальнодоступна) примітка', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('AR', '', '952', 'y', 0, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('AR', '', '952', 'y', 1, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('AR', '', '952', 'z', 0, 0, 'Загальнодоступна примітка щодо примірника', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql index 6f11b78109..d17e39e7cd 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('BKS', '', '952', 'v', 0, 0, 'Вартість, ціна заміни', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('BKS', '', '952', 'w', 0, 0, 'Дата, для якої чинна ціна заміни', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('BKS', '', '952', 'x', 0, 0, 'Службова (незагальнодоступна) примітка', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('BKS', '', '952', 'y', 0, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('BKS', '', '952', 'y', 1, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('BKS', '', '952', 'z', 0, 0, 'Загальнодоступна примітка щодо примірника', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql index 6226858d75..98172069bb 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('CF', '', '952', 'v', 0, 0, 'Вартість, ціна заміни', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('CF', '', '952', 'w', 0, 0, 'Дата, для якої чинна ціна заміни', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('CF', '', '952', 'x', 0, 0, 'Службова (незагальнодоступна) примітка', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('CF', '', '952', 'y', 0, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('CF', '', '952', 'y', 1, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('CF', '', '952', 'z', 0, 0, 'Загальнодоступна примітка щодо примірника', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES 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..ebae569a99 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 @@ -56,7 +56,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('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', 'y', 0, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', NULL, NULL), + ('FA', '', '952', 'y', 1, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', NULL, NULL), ('FA', '', '952', 'z', 0, 0, 'Загальнодоступна примітка щодо примірника', '', 10, 0, 'items.itemnotes', '', '', NULL, '', NULL, NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql index f3cca0b562..0bd8ab7e70 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('IR', '', '952', 'v', 0, 0, 'Вартість, ціна заміни', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('IR', '', '952', 'w', 0, 0, 'Дата, для якої чинна ціна заміни', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('IR', '', '952', 'x', 0, 0, 'Службова (незагальнодоступна) примітка', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('IR', '', '952', 'y', 0, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('IR', '', '952', 'y', 1, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('IR', '', '952', 'z', 0, 0, 'Загальнодоступна примітка щодо примірника', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql index e7a702967f..5991f2547f 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('KT', '', '952', 'v', 0, 0, 'Вартість, ціна заміни', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('KT', '', '952', 'w', 0, 0, 'Дата, для якої чинна ціна заміни', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('KT', '', '952', 'x', 0, 0, 'Службова (незагальнодоступна) примітка', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('KT', '', '952', 'y', 0, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('KT', '', '952', 'y', 1, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('KT', '', '952', 'z', 0, 0, 'Загальнодоступна примітка щодо примірника', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql index 77b8b16bd1..63dbe67270 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('SER', '', '952', 'v', 0, 0, 'Вартість, ціна заміни', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('SER', '', '952', 'w', 0, 0, 'Дата, для якої чинна ціна заміни', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('SER', '', '952', 'x', 0, 0, 'Службова (незагальнодоступна) примітка', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('SER', '', '952', 'y', 0, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('SER', '', '952', 'y', 1, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('SER', '', '952', 'z', 0, 0, 'Загальнодоступна примітка щодо примірника', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql index 78e6d813d6..db69649789 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('SR', '', '952', 'v', 0, 0, 'Вартість, ціна заміни', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('SR', '', '952', 'w', 0, 0, 'Дата, для якої чинна ціна заміни', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('SR', '', '952', 'x', 0, 0, 'Службова (незагальнодоступна) примітка', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('SR', '', '952', 'y', 0, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('SR', '', '952', 'y', 1, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('SR', '', '952', 'z', 0, 0, 'Загальнодоступна примітка щодо примірника', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql index 38c63cdae6..f969c66e08 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql @@ -795,7 +795,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('VR', '', '952', 'v', 0, 0, 'Вартість, ціна заміни', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('VR', '', '952', 'w', 0, 0, 'Дата, для якої чинна ціна заміни', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), ('VR', '', '952', 'x', 0, 0, 'Службова (незагальнодоступна) примітка', '', 10, 1, '', '', '', NULL, '', '', NULL), - ('VR', '', '952', 'y', 0, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), + ('VR', '', '952', 'y', 1, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('VR', '', '952', 'z', 0, 0, 'Загальнодоступна примітка щодо примірника', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES -- 2.20.1