From fda72f1ecc613fc67389dbfa84ef2b91c3db85b7 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sun, 30 Nov 2014 07:59:24 +0100 Subject: [PATCH] Bug 8909: MARC21 240$a (Uniform title) is not a URL Patch removes the 'isUrl' attribute from all 240$a fields in the various frameworks. The change removes the broken link from the staff detail MARC tab view. Changes are a little easier to spot with: git diff --color-words HEAD^ To test: - Load some or all of the frameworks - Verify that 240$a is no longer marked as being an URL Signed-off-by: Nick Clemens Signed-off-by: Kyle M Hall Signed-off-by: Tomas Cohen Arazi --- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../Obligatoire/marc21_framework_DEFAULT.sql | 2 +- .../Optionnel/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../marc21_bibliographic_DEFAULT_general.sql | 2 +- .../optional/marc21_bibliographic_AR_general.sql | 2 +- .../marc21_bibliographic_BKS_general.sql | 2 +- .../optional/marc21_bibliographic_CF_general.sql | 2 +- .../optional/marc21_bibliographic_IR_general.sql | 2 +- .../optional/marc21_bibliographic_KT_general.sql | 2 +- .../marc21_bibliographic_SER_general.sql | 2 +- .../optional/marc21_bibliographic_SR_general.sql | 2 +- .../optional/marc21_bibliographic_VR_general.sql | 2 +- .../marc21_bibliographic_DEFAULT_general.sql | 2 +- .../optional/marc21_bibliographic_AR_general.sql | 2 +- .../marc21_bibliographic_BKS_general.sql | 2 +- .../optional/marc21_bibliographic_CF_general.sql | 2 +- .../optional/marc21_bibliographic_IR_general.sql | 2 +- .../optional/marc21_bibliographic_KT_general.sql | 2 +- .../marc21_bibliographic_SER_general.sql | 2 +- .../optional/marc21_bibliographic_SR_general.sql | 2 +- .../optional/marc21_bibliographic_VR_general.sql | 2 +- 32 files changed, 81 insertions(+), 81 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 a5016c9c92..f88f4bcd50 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 @@ -986,7 +986,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('240', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '9', 'Koha-Normdatenidentnummer', 'Koha-Normdatenidentnummer', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL), - ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, '', '', '', NULL), + ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, '', '', '', NULL), ('240', 'd', 'Datum der Vertragsunterzeichnung', 'Datum der Vertragsunterzeichnung', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'f', 'Erscheinungsjahr eines Werkes', 'Erscheinungsjahr eines Werkes', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'g', 'Sonstige Informationen', 'Sonstige Informationen', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql index fb12846228..e7190d5066 100644 --- a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql @@ -951,7 +951,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '9', 'Koha-Normdatenidentnummer', 'Koha-Normdatenidentnummer', 0, 0, '', 2, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'BKS', '', '', NULL), + ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'BKS', '', '', NULL), ('240', 'd', 'Datum der Vertragsunterzeichnung', 'Datum der Vertragsunterzeichnung', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'f', 'Erscheinungsjahr eines Werkes', 'Erscheinungsjahr eines Werkes', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'g', 'Sonstige Informationen', 'Sonstige Informationen', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), @@ -4959,7 +4959,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '9', 'Koha-Normdatenidentnummer', 'Koha-Normdatenidentnummer', 0, 0, '', 2, '', '', '', 0, -5, 'CF', '', '', NULL), - ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'CF', '', '', NULL), + ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'CF', '', '', NULL), ('240', 'd', 'Datum der Vertragsunterzeichnung', 'Datum der Vertragsunterzeichnung', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'f', 'Erscheinungsjahr eines Werkes', 'Erscheinungsjahr eines Werkes', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'g', 'Sonstige Informationen', 'Sonstige Informationen', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), @@ -8966,7 +8966,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '9', 'Koha-Normdatenidentnummer', 'Koha-Normdatenidentnummer', 0, 0, '', 2, '', '', '', 0, -5, 'SR', '', '', NULL), - ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SR', '', '', NULL), + ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SR', '', '', NULL), ('240', 'd', 'Datum der Vertragsunterzeichnung', 'Datum der Vertragsunterzeichnung', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'f', 'Erscheinungsjahr eines Werkes', 'Erscheinungsjahr eines Werkes', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'g', 'Sonstige Informationen', 'Sonstige Informationen', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), @@ -12973,7 +12973,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '9', 'Koha-Normdatenidentnummer', 'Koha-Normdatenidentnummer', 0, 0, '', 2, '', '', '', 0, -5, 'VR', '', '', NULL), - ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'VR', '', '', NULL), + ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'VR', '', '', NULL), ('240', 'd', 'Datum der Vertragsunterzeichnung', 'Datum der Vertragsunterzeichnung', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'f', 'Erscheinungsjahr eines Werkes', 'Erscheinungsjahr eines Werkes', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'g', 'Sonstige Informationen', 'Sonstige Informationen', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), @@ -16978,7 +16978,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '9', 'Koha-Normdatenidentnummer', 'Koha-Normdatenidentnummer', 0, 0, '', 2, '', '', '', 0, -5, 'AR', '', '', NULL), - ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'AR', '', '', NULL), + ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'AR', '', '', NULL), ('240', 'd', 'Datum der Vertragsunterzeichnung', 'Datum der Vertragsunterzeichnung', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'f', 'Erscheinungsjahr eines Werkes', 'Erscheinungsjahr eines Werkes', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'g', 'Sonstige Informationen', 'Sonstige Informationen', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), @@ -20983,7 +20983,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '9', 'Koha-Normdatenidentnummer', 'Koha-Normdatenidentnummer', 0, 0, '', 2, '', '', '', 0, -5, 'KT', '', '', NULL), - ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'KT', '', '', NULL), + ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'KT', '', '', NULL), ('240', 'd', 'Datum der Vertragsunterzeichnung', 'Datum der Vertragsunterzeichnung', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'f', 'Erscheinungsjahr eines Werkes', 'Erscheinungsjahr eines Werkes', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'g', 'Sonstige Informationen', 'Sonstige Informationen', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), @@ -24990,7 +24990,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '9', 'Koha-Normdatenidentnummer', 'Koha-Normdatenidentnummer', 0, 0, '', 2, '', '', '', 0, -5, 'IR', '', '', NULL), - ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'IR', '', '', NULL), + ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'IR', '', '', NULL), ('240', 'd', 'Datum der Vertragsunterzeichnung', 'Datum der Vertragsunterzeichnung', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'f', 'Erscheinungsjahr eines Werkes', 'Erscheinungsjahr eines Werkes', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'g', 'Sonstige Informationen', 'Sonstige Informationen', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), @@ -28992,7 +28992,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '9', 'Koha-Normdatenidentnummer', 'Koha-Normdatenidentnummer', 0, 0, '', 2, '', '', '', 0, -5, 'SER', '', '', NULL), - ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SER', '', '', NULL), + ('240', 'a', 'Einheitstitel', 'Einheitstitel', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SER', '', '', NULL), ('240', 'd', 'Datum der Vertragsunterzeichnung', 'Datum der Vertragsunterzeichnung', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'f', 'Erscheinungsjahr eines Werkes', 'Erscheinungsjahr eines Werkes', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'g', 'Sonstige Informationen', 'Sonstige Informationen', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', 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 f8d66bc726..bb1c93d913 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 @@ -986,7 +986,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, '', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, '', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), diff --git a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql index 0c80d58569..3aade56c6e 100644 --- a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql @@ -951,7 +951,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'BKS', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'BKS', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), @@ -4959,7 +4959,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'CF', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'CF', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'CF', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), @@ -8966,7 +8966,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'SR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), @@ -12973,7 +12973,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'VR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'VR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'VR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), @@ -16978,7 +16978,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'AR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'AR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'AR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), @@ -20983,7 +20983,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'KT', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'KT', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'KT', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), @@ -24990,7 +24990,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'IR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'IR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'IR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), @@ -28992,7 +28992,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'SER', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SER', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SER', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', 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 dce46e52c0..1a9f79cdd2 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 @@ -986,7 +986,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('240', '6', 'Enlace', 'Enlace', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL), - ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, '', '', '', NULL), + ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, '', '', '', NULL), ('240', 'd', 'Fecha de la firma de un tratado', 'Fecha de la firma de un tratado', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'f', 'Fecha de publicación/de la obra', 'Fecha de publicación/de la obra', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'g', 'Información miscelánea', 'Información miscelánea', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql index f5cb8bf475..bebaddf523 100644 --- a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql @@ -951,7 +951,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Enlace', 'Enlace', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'BKS', '', '', NULL), + ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'BKS', '', '', NULL), ('240', 'd', 'Fecha de la firma de un tratado', 'Fecha de la firma de un tratado', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'f', 'Fecha de publicación/de la obra', 'Fecha de publicación/de la obra', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'g', 'Información miscelánea', 'Información miscelánea', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), @@ -4959,7 +4959,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Enlace', 'Enlace', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'CF', '', '', NULL), - ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'CF', '', '', NULL), + ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'CF', '', '', NULL), ('240', 'd', 'Fecha de la firma de un tratado', 'Fecha de la firma de un tratado', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'f', 'Fecha de publicación/de la obra', 'Fecha de publicación/de la obra', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'g', 'Información miscelánea', 'Información miscelánea', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), @@ -8966,7 +8966,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Enlace', 'Enlace', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'SR', '', '', NULL), - ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SR', '', '', NULL), + ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SR', '', '', NULL), ('240', 'd', 'Fecha de la firma de un tratado', 'Fecha de la firma de un tratado', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'f', 'Fecha de publicación/de la obra', 'Fecha de publicación/de la obra', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'g', 'Información miscelánea', 'Información miscelánea', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), @@ -12973,7 +12973,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Enlace', 'Enlace', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'VR', '', '', NULL), - ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'VR', '', '', NULL), + ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'VR', '', '', NULL), ('240', 'd', 'Fecha de la firma de un tratado', 'Fecha de la firma de un tratado', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'f', 'Fecha de publicación/de la obra', 'Fecha de publicación/de la obra', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'g', 'Información miscelánea', 'Información miscelánea', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), @@ -16978,7 +16978,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Enlace', 'Enlace', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'AR', '', '', NULL), - ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'AR', '', '', NULL), + ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'AR', '', '', NULL), ('240', 'd', 'Fecha de la firma de un tratado', 'Fecha de la firma de un tratado', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'f', 'Fecha de publicación/de la obra', 'Fecha de publicación/de la obra', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'g', 'Información miscelánea', 'Información miscelánea', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), @@ -20983,7 +20983,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Enlace', 'Enlace', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'KT', '', '', NULL), - ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'KT', '', '', NULL), + ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'KT', '', '', NULL), ('240', 'd', 'Fecha de la firma de un tratado', 'Fecha de la firma de un tratado', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'f', 'Fecha de publicación/de la obra', 'Fecha de publicación/de la obra', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'g', 'Información miscelánea', 'Información miscelánea', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), @@ -24990,7 +24990,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Enlace', 'Enlace', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'IR', '', '', NULL), - ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'IR', '', '', NULL), + ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'IR', '', '', NULL), ('240', 'd', 'Fecha de la firma de un tratado', 'Fecha de la firma de un tratado', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'f', 'Fecha de publicación/de la obra', 'Fecha de publicación/de la obra', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'g', 'Información miscelánea', 'Información miscelánea', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), @@ -28992,7 +28992,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Enlace', 'Enlace', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'SER', '', '', NULL), - ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SER', '', '', NULL), + ('240', 'a', 'Título uniforme', 'Título uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SER', '', '', NULL), ('240', 'd', 'Fecha de la firma de un tratado', 'Fecha de la firma de un tratado', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'f', 'Fecha de publicación/de la obra', 'Fecha de publicación/de la obra', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'g', 'Información miscelánea', 'Información miscelánea', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', 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 91dac51b36..ad0611e8d8 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 @@ -922,7 +922,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, '', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, '', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', 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 6cf39ca748..05902a9337 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 @@ -947,7 +947,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'BKS', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'BKS', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), @@ -4874,7 +4874,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'CF', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'CF', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'CF', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), @@ -8800,7 +8800,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'SR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), @@ -12726,7 +12726,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'VR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'VR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'VR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), @@ -16650,7 +16650,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'AR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'AR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'AR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), @@ -20574,7 +20574,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'KT', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'KT', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'KT', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), @@ -24500,7 +24500,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'IR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'IR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'IR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), @@ -28421,7 +28421,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'SER', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SER', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SER', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, '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 56cfaeba08..c53a087574 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 @@ -986,7 +986,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('240', '6', 'Collegamento', 'Collegamento', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL), - ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, '', '', '', NULL), + ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, '', '', '', NULL), ('240', 'd', 'Data di firma del trattato', 'Data di firma del trattato', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'f', 'Data dell\'opera', 'Data dell\'opera', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'g', 'Informazione miscellanea', 'Informazione miscellanea', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql index 184753a1a6..4caa941f3c 100644 --- a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql @@ -951,7 +951,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Collegamento', 'Collegamento', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'BKS', '', '', NULL), + ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'BKS', '', '', NULL), ('240', 'd', 'Data di firma del trattato', 'Data di firma del trattato', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'f', 'Data dell\'opera', 'Data dell\'opera', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'g', 'Informazione miscellanea', 'Informazione miscellanea', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), @@ -4959,7 +4959,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Collegamento', 'Collegamento', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'CF', '', '', NULL), - ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'CF', '', '', NULL), + ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'CF', '', '', NULL), ('240', 'd', 'Data di firma del trattato', 'Data di firma del trattato', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'f', 'Data dell\'opera', 'Data dell\'opera', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'g', 'Informazione miscellanea', 'Informazione miscellanea', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), @@ -8966,7 +8966,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Collegamento', 'Collegamento', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'SR', '', '', NULL), - ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SR', '', '', NULL), + ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SR', '', '', NULL), ('240', 'd', 'Data di firma del trattato', 'Data di firma del trattato', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'f', 'Data dell\'opera', 'Data dell\'opera', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'g', 'Informazione miscellanea', 'Informazione miscellanea', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), @@ -12973,7 +12973,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Collegamento', 'Collegamento', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'VR', '', '', NULL), - ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'VR', '', '', NULL), + ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'VR', '', '', NULL), ('240', 'd', 'Data di firma del trattato', 'Data di firma del trattato', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'f', 'Data dell\'opera', 'Data dell\'opera', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'g', 'Informazione miscellanea', 'Informazione miscellanea', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), @@ -16978,7 +16978,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Collegamento', 'Collegamento', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'AR', '', '', NULL), - ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'AR', '', '', NULL), + ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'AR', '', '', NULL), ('240', 'd', 'Data di firma del trattato', 'Data di firma del trattato', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'f', 'Data dell\'opera', 'Data dell\'opera', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'g', 'Informazione miscellanea', 'Informazione miscellanea', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), @@ -20983,7 +20983,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Collegamento', 'Collegamento', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'KT', '', '', NULL), - ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'KT', '', '', NULL), + ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'KT', '', '', NULL), ('240', 'd', 'Data di firma del trattato', 'Data di firma del trattato', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'f', 'Data dell\'opera', 'Data dell\'opera', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'g', 'Informazione miscellanea', 'Informazione miscellanea', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), @@ -24990,7 +24990,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Collegamento', 'Collegamento', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'IR', '', '', NULL), - ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'IR', '', '', NULL), + ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'IR', '', '', NULL), ('240', 'd', 'Data di firma del trattato', 'Data di firma del trattato', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'f', 'Data dell\'opera', 'Data dell\'opera', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'g', 'Informazione miscellanea', 'Informazione miscellanea', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), @@ -28992,7 +28992,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Collegamento', 'Collegamento', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'SER', '', '', NULL), - ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SER', '', '', NULL), + ('240', 'a', 'Titolo uniforme', 'Titolo uniforme', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SER', '', '', NULL), ('240', 'd', 'Data di firma del trattato', 'Data di firma del trattato', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'f', 'Data dell\'opera', 'Data dell\'opera', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'g', 'Informazione miscellanea', 'Informazione miscellanea', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', 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 68f74d08f8..43c1a18776 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 @@ -922,7 +922,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, '', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, '', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', 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 7977b14a45..d1784164dc 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 @@ -946,7 +946,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'BKS', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'BKS', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), @@ -4872,7 +4872,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'CF', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'CF', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'CF', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), @@ -8797,7 +8797,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'SR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), @@ -12722,7 +12722,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'VR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'VR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'VR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), @@ -16645,7 +16645,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'AR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'AR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'AR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), @@ -20568,7 +20568,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'KT', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'KT', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'KT', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), @@ -24493,7 +24493,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'IR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'IR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'IR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), @@ -28413,7 +28413,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'SER', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SER', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SER', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), 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 030b5d8e8e..64cd1bcec0 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 @@ -921,7 +921,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, '', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, '', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', 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 7bbe212840..394270bdcd 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 @@ -947,7 +947,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'BKS', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'BKS', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'BKS', '', '', NULL), @@ -4874,7 +4874,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'CF', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'CF', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'CF', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'CF', '', '', NULL), @@ -8800,7 +8800,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'SR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'SR', '', '', NULL), @@ -12726,7 +12726,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'VR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'VR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'VR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'VR', '', '', NULL), @@ -16650,7 +16650,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'AR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'AR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'AR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'AR', '', '', NULL), @@ -20574,7 +20574,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'KT', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'KT', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'KT', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'KT', '', '', NULL), @@ -24500,7 +24500,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'IR', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'IR', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'IR', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'IR', '', '', NULL), @@ -28421,7 +28421,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, 'SER', '', '', NULL), - ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, 'SER', '', '', NULL), + ('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, 'SER', '', '', NULL), ('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), ('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, 'SER', '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql index f24c2c4e96..f838810665 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql @@ -732,7 +732,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('', '', '240', '6', 0, 0, 'Элемент связи', '', 2, -6, '', '', '', 0, '', '', NULL), ('', '', '240', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('', '', '240', 'd', 0, 1, 'Дата подписания договора', '', 2, -6, '', '', '', 0, '', '', NULL), ('', '', '240', 'f', 0, 0, 'Дата публикации', '', 2, -6, '', '', '', 0, '', '', NULL), ('', '', '240', 'g', 0, 0, 'Прочие сведения', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql index 6534555dc5..63a6d0a504 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('AR', '', '240', '6', 0, 0, 'Элемент связи', '', 2, -6, '', '', '', 0, '', '', NULL), ('AR', '', '240', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('AR', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('AR', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('AR', '', '240', 'd', 0, 1, 'Дата подписания договора', '', 2, -6, '', '', '', 0, '', '', NULL), ('AR', '', '240', 'f', 0, 0, 'Дата публикации', '', 2, -6, '', '', '', 0, '', '', NULL), ('AR', '', '240', 'g', 0, 0, 'Прочие сведения', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql index b622101f78..fc918d0a55 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('BKS', '', '240', '6', 0, 0, 'Элемент связи', '', 2, -6, '', '', '', 0, '', '', NULL), ('BKS', '', '240', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('BKS', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('BKS', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('BKS', '', '240', 'd', 0, 1, 'Дата подписания договора', '', 2, -6, '', '', '', 0, '', '', NULL), ('BKS', '', '240', 'f', 0, 0, 'Дата публикации', '', 2, -6, '', '', '', 0, '', '', NULL), ('BKS', '', '240', 'g', 0, 0, 'Прочие сведения', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql index bf342b7b51..04827a4f01 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('CF', '', '240', '6', 0, 0, 'Элемент связи', '', 2, -6, '', '', '', 0, '', '', NULL), ('CF', '', '240', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('CF', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('CF', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('CF', '', '240', 'd', 0, 1, 'Дата подписания договора', '', 2, -6, '', '', '', 0, '', '', NULL), ('CF', '', '240', 'f', 0, 0, 'Дата публикации', '', 2, -6, '', '', '', 0, '', '', NULL), ('CF', '', '240', 'g', 0, 0, 'Прочие сведения', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql index 27a3760b9c..d84e336876 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('IR', '', '240', '6', 0, 0, 'Элемент связи', '', 2, -6, '', '', '', 0, '', '', NULL), ('IR', '', '240', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('IR', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('IR', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('IR', '', '240', 'd', 0, 1, 'Дата подписания договора', '', 2, -6, '', '', '', 0, '', '', NULL), ('IR', '', '240', 'f', 0, 0, 'Дата публикации', '', 2, -6, '', '', '', 0, '', '', NULL), ('IR', '', '240', 'g', 0, 0, 'Прочие сведения', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql index 35ef96a16a..81c7b50b27 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('KT', '', '240', '6', 0, 0, 'Элемент связи', '', 2, -6, '', '', '', 0, '', '', NULL), ('KT', '', '240', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('KT', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('KT', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('KT', '', '240', 'd', 0, 1, 'Дата подписания договора', '', 2, -6, '', '', '', 0, '', '', NULL), ('KT', '', '240', 'f', 0, 0, 'Дата публикации', '', 2, -6, '', '', '', 0, '', '', NULL), ('KT', '', '240', 'g', 0, 0, 'Прочие сведения', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql index 886cad5c01..0160a19880 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('SER', '', '240', '6', 0, 0, 'Элемент связи', '', 2, -6, '', '', '', 0, '', '', NULL), ('SER', '', '240', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('SER', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('SER', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('SER', '', '240', 'd', 0, 1, 'Дата подписания договора', '', 2, -6, '', '', '', 0, '', '', NULL), ('SER', '', '240', 'f', 0, 0, 'Дата публикации', '', 2, -6, '', '', '', 0, '', '', NULL), ('SER', '', '240', 'g', 0, 0, 'Прочие сведения', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql index ef6929103c..df0d94ee25 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('SR', '', '240', '6', 0, 0, 'Элемент связи', '', 2, -6, '', '', '', 0, '', '', NULL), ('SR', '', '240', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('SR', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('SR', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('SR', '', '240', 'd', 0, 1, 'Дата подписания договора', '', 2, -6, '', '', '', 0, '', '', NULL), ('SR', '', '240', 'f', 0, 0, 'Дата публикации', '', 2, -6, '', '', '', 0, '', '', NULL), ('SR', '', '240', 'g', 0, 0, 'Прочие сведения', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql index a95f49b3d9..f5786d4c7c 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('VR', '', '240', '6', 0, 0, 'Элемент связи', '', 2, -6, '', '', '', 0, '', '', NULL), ('VR', '', '240', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('VR', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('VR', '', '240', 'a', 0, 0, 'Условное заглавие', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('VR', '', '240', 'd', 0, 1, 'Дата подписания договора', '', 2, -6, '', '', '', 0, '', '', NULL), ('VR', '', '240', 'f', 0, 0, 'Дата публикации', '', 2, -6, '', '', '', 0, '', '', NULL), ('VR', '', '240', 'g', 0, 0, 'Прочие сведения', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql index ec75585535..6ccc172715 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql @@ -733,7 +733,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('', '', '240', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 2, -6, '', '', '', 0, '', '', NULL), ('', '', '240', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('', '', '240', 'd', 0, 1, 'Дата підписання договору', '', 2, -6, '', '', '', 0, '', '', NULL), ('', '', '240', 'f', 0, 0, 'Дата публікації', '', 2, -6, '', '', '', 0, '', '', NULL), ('', '', '240', 'g', 0, 0, 'Інші відомості', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql index db6e398685..2228201335 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('AR', '', '240', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 2, -6, '', '', '', 0, '', '', NULL), ('AR', '', '240', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('AR', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('AR', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('AR', '', '240', 'd', 0, 1, 'Дата підписання договору', '', 2, -6, '', '', '', 0, '', '', NULL), ('AR', '', '240', 'f', 0, 0, 'Дата публікації', '', 2, -6, '', '', '', 0, '', '', NULL), ('AR', '', '240', 'g', 0, 0, 'Інші відомості', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql index 5a71dc3845..c16acab647 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('BKS', '', '240', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 2, -6, '', '', '', 0, '', '', NULL), ('BKS', '', '240', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('BKS', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('BKS', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('BKS', '', '240', 'd', 0, 1, 'Дата підписання договору', '', 2, -6, '', '', '', 0, '', '', NULL), ('BKS', '', '240', 'f', 0, 0, 'Дата публікації', '', 2, -6, '', '', '', 0, '', '', NULL), ('BKS', '', '240', 'g', 0, 0, 'Інші відомості', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql index 5464d6b862..942e468448 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('CF', '', '240', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 2, -6, '', '', '', 0, '', '', NULL), ('CF', '', '240', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('CF', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('CF', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('CF', '', '240', 'd', 0, 1, 'Дата підписання договору', '', 2, -6, '', '', '', 0, '', '', NULL), ('CF', '', '240', 'f', 0, 0, 'Дата публікації', '', 2, -6, '', '', '', 0, '', '', NULL), ('CF', '', '240', 'g', 0, 0, 'Інші відомості', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql index 659d980aac..a1647aee06 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('IR', '', '240', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 2, -6, '', '', '', 0, '', '', NULL), ('IR', '', '240', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('IR', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('IR', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('IR', '', '240', 'd', 0, 1, 'Дата підписання договору', '', 2, -6, '', '', '', 0, '', '', NULL), ('IR', '', '240', 'f', 0, 0, 'Дата публікації', '', 2, -6, '', '', '', 0, '', '', NULL), ('IR', '', '240', 'g', 0, 0, 'Інші відомості', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql index c65d2832d5..f7c204741b 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('KT', '', '240', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 2, -6, '', '', '', 0, '', '', NULL), ('KT', '', '240', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('KT', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('KT', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('KT', '', '240', 'd', 0, 1, 'Дата підписання договору', '', 2, -6, '', '', '', 0, '', '', NULL), ('KT', '', '240', 'f', 0, 0, 'Дата публікації', '', 2, -6, '', '', '', 0, '', '', NULL), ('KT', '', '240', 'g', 0, 0, 'Інші відомості', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql index 499ce81204..4bb26cad03 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('SER', '', '240', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 2, -6, '', '', '', 0, '', '', NULL), ('SER', '', '240', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('SER', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('SER', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('SER', '', '240', 'd', 0, 1, 'Дата підписання договору', '', 2, -6, '', '', '', 0, '', '', NULL), ('SER', '', '240', 'f', 0, 0, 'Дата публікації', '', 2, -6, '', '', '', 0, '', '', NULL), ('SER', '', '240', 'g', 0, 0, 'Інші відомості', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql index 997cdbfb1a..0b83d44b28 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('SR', '', '240', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 2, -6, '', '', '', 0, '', '', NULL), ('SR', '', '240', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('SR', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('SR', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('SR', '', '240', 'd', 0, 1, 'Дата підписання договору', '', 2, -6, '', '', '', 0, '', '', NULL), ('SR', '', '240', 'f', 0, 0, 'Дата публікації', '', 2, -6, '', '', '', 0, '', '', NULL), ('SR', '', '240', 'g', 0, 0, 'Інші відомості', '', 2, -6, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql index fc39bf4b80..50f4795a19 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql @@ -706,7 +706,7 @@ INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('VR', '', '240', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 2, -6, '', '', '', 0, '', '', NULL), ('VR', '', '240', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 2, -6, '', '', '', 0, '', '', NULL), - ('VR', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 1, '', '', NULL), + ('VR', '', '240', 'a', 0, 0, 'Умовна назва', '', 2, -1, 'biblio.unititle', '', '', 0, '', '', NULL), ('VR', '', '240', 'd', 0, 1, 'Дата підписання договору', '', 2, -6, '', '', '', 0, '', '', NULL), ('VR', '', '240', 'f', 0, 0, 'Дата публікації', '', 2, -6, '', '', '', 0, '', '', NULL), ('VR', '', '240', 'g', 0, 0, 'Інші відомості', '', 2, -6, '', '', '', 0, '', '', NULL), -- 2.20.1