From 25c5f3968fde4559898a8f7c6733afa534d3e08a Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Mon, 11 Dec 2017 09:39:37 +0100 Subject: [PATCH] Bug 19790: Remove additionalauthors.author from installer files In the upgrade from 2.2 to 3.0 (some time ago already) the table additionalauthors has been dropped. Unfortunately, a reference to this table has not been removed from the MARC framework installer files. This patch clears kohafield for 700$a or 200$g in 32 installer files. Note: The reference to additionalauthors in field kohafield is silently ignored in AddBiblio/ModBiblio since the routines _koha_add_biblio, _koha_add_biblioitem, _koha_modify_biblio and _koha_modify_biblioitem_nonmarc simply do not use it. You can define a Koha to MARC mapping for a biblio/biblioitem field but if the field is not referenced in one of those routines, nothing happens.. Also note that C4::Items::_koha_modify_item does not hardcode all fields and will respond to a new item mapping. Test plan: [1] Run a new install or verify somehow that the change to these sql files is correct. The change is a result of: sed -i -e "s/'additionalauthors.author'/''/g" Signed-off-by: Marcel de Rooy Run a new install with MARC21 and English. This includes the mandatory file marc21_framework_DEFAULT.sql. Verified that 700$a was inserted correctly (without additionalauthors). Signed-off-by: Charles Farmer Signed-off-by: Katrin Fischer Signed-off-by: Jonathan Druart --- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../Obligatoire/marc21_framework_DEFAULT.sql | 2 +- .../Optionnel/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../Obligatoire/framework_DEFAULT.sql | 10 +++++----- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../marcflavour/normarc/Obligatorisk/normarc.sql | 2 +- .../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 +- .../unimarc_bibliographic_DEFAULT_general.sql | 2 +- .../unimarc_bibliographic_BOOK_general.sql | 2 +- 32 files changed, 57 insertions(+), 57 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 1d5fdda5c9..14890aee67 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 @@ -2376,7 +2376,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('700', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '9', 'Koha-Normdatenidentnummer', 'Koha-Normdatenidentnummer', 0, 0, '', 7, '', '', '', 0, -5, '', '', '', NULL), - ('700', 'a', 'Personenname', 'Personenname', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), + ('700', 'a', 'Personenname', 'Personenname', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), ('700', 'b', 'Zählung', 'Zählung', 0, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'c', 'Titel und andere Wörter in Verbindung mit einem Namen', 'Titel und andere Wörter in Verbindung mit einem Namen', 1, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'd', 'Datumsangaben in Verbindung mit einem Namen', 'Datumsangaben in Verbindung mit einem Namen', 0, 0, '', 7, '', '', '', NULL, 0, '', '', '', 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 c916699714..46bf421296 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 @@ -2376,7 +2376,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, '', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, 0, '', '', '', 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 7c367c909e..fdf4e6632b 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 @@ -2376,7 +2376,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('700', '6', 'Enlace', 'Enlace', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, '', '', '', NULL), - ('700', 'a', 'Nombre de persona', 'Nombre de persona', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), + ('700', 'a', 'Nombre de persona', 'Nombre de persona', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), ('700', 'b', 'Numeración', 'Numeración', 0, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'c', 'Títulos y otros términos asociados al nombre', 'Títulos y otros términos asociados al nombre', 1, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'd', 'Fechas asociadas al nombre', 'Fechas asociadas al nombre', 0, 0, '', 7, '', '', '', NULL, 0, '', '', '', 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 95de08aee8..8f447bb602 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 @@ -2064,7 +2064,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, '', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL), diff --git a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql b/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql index 78c025a38a..b8bc4b48b5 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 @@ -2082,7 +2082,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'BKS', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'BKS', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'BKS', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'BKS', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'BKS', '', '', NULL), @@ -6009,7 +6009,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'CF', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'CF', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'CF', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'CF', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'CF', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'CF', '', '', NULL), @@ -9935,7 +9935,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'SR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'SR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'SR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'SR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'SR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'SR', '', '', NULL), @@ -13861,7 +13861,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'VR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'VR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'VR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'VR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'VR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'VR', '', '', NULL), @@ -17785,7 +17785,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'AR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'AR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'AR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'AR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'AR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'AR', '', '', NULL), @@ -21709,7 +21709,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'KT', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'KT', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'KT', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'KT', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'KT', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'KT', '', '', NULL), @@ -25634,7 +25634,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'IR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'IR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'IR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'IR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'IR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'IR', '', '', NULL), @@ -29555,7 +29555,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'SER', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'SER', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'SER', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'SER', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'SER', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'SER', '', '', NULL), diff --git a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql index 78d2a437e9..8937249c1a 100644 --- a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql +++ b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql @@ -1162,7 +1162,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'd', 'titre //', '', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'e', 'sous-titre', '', 1, 0, 'biblioitems.volume', 0, '', '', '', 0, -1, '', '', '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'f', 'auteur', 'auteur', 1, 1, 'biblio.author', 0, '', '', '', 0, 0, '', '', '',NULL); -INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'g', 'autre auteur', 'auteur secondaire', 1, 0, 'additionalauthors.author', 0, '', '', '', 0, 0, '', '', '', NULL); +INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'g', 'autre auteur', 'auteur secondaire', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'h', 'N° de partie', '', 1, 0, 'biblioitems.volumeddesc', 0, '', '', '', 0, -1, '', '', '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'i', 'titre partie', '', 1, 0, 'biblio.unititle', 0, '', '', '', 0, -1, '', '', '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'v', 'numéro de volume', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL); @@ -2506,7 +2506,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'd', 'titre //', '', 1, 0, '', 0, '', '', '', NULL, -1, 'ARTI', '', NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'e', 'sous-titre', '', 1, 0, 'biblioitems.volume', 0, '', '', '', NULL, -1, 'ARTI', '', NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'f', 'auteur', 'auteur', 1, 1, 'biblio.author', 0, '', '', '', NULL, 0, 'ARTI', '', NULL, NULL); -INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'g', 'autre auteur', 'auteur secondaire', 1, 0, 'additionalauthors.author', 0, '', '', '', NULL, 0, 'ARTI', '', NULL, NULL); +INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'g', 'autre auteur', 'auteur secondaire', 1, 0, '', 0, '', '', '', NULL, 0, 'ARTI', '', NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'h', 'N° de partie', '', 1, 0, 'biblioitems.volumeddesc', 0, '', '', '', NULL, -1, 'ARTI', '', NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'i', 'titre partie', '', 1, 0, 'biblio.unititle', 0, '', '', '', NULL, -1, 'ARTI', '', NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'v', 'numéro de volume', '', 0, 0, '', -1, '', '', '', NULL, 0, 'ARTI', '', NULL, NULL); @@ -3849,7 +3849,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'd', 'titre //', '', 1, 0, '', 0, '', '', '', 0, -1, 'MULT', NULL, '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'e', 'sous-titre', '', 1, 0, 'biblioitems.volume', 0, '', '', '', 0, -1, 'MULT', NULL, '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'f', 'auteur', 'auteur', 1, 0, 'biblio.author', 0, '', '', '', 0, 0, 'MULT', NULL, '', NULL); -INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'g', 'autre auteur', 'auteur secondaire', 1, 0, 'additionalauthors.author', 0, '', '', '', 0, 0, 'MULT', NULL, '', NULL); +INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'g', 'autre auteur', 'auteur secondaire', 1, 0, '', 0, '', '', '', 0, 0, 'MULT', NULL, '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'h', 'N° de partie', '', 1, 0, 'biblioitems.volumeddesc', 0, '', '', '', 0, -1, 'MULT', NULL, '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'i', 'titre partie', '', 1, 0, 'biblio.unititle', 0, '', '', '', 0, -1, 'MULT', NULL, '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'v', 'numéro de volume', '', 0, 0, '', -1, '', '', '', 0, 0, 'MULT', NULL, '', NULL); @@ -5193,7 +5193,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'd', 'titre //', '', 1, 0, '', 0, '', '', '', NULL, -1, 'PERI', '', NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'e', 'sous-titre', '', 1, 0, 'biblioitems.volume', 0, '', '', '', NULL, -1, 'PERI', '', NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'f', 'auteur', 'auteur', 1, 0, 'biblio.author', 0, '', '', '', NULL, 0, 'PERI', '', NULL, NULL); -INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'g', 'autre auteur', 'auteur secondaire', 1, 0, 'additionalauthors.author', 0, '', '', '', NULL, 0, 'PERI', '', NULL, NULL); +INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'g', 'autre auteur', 'auteur secondaire', 1, 0, '', 0, '', '', '', NULL, 0, 'PERI', '', NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'h', 'N° de partie', '', 1, 0, 'biblioitems.volumeddesc', 0, '', '', '', NULL, -1, 'PERI', '', NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'i', 'titre partie', '', 1, 0, 'biblio.unititle', 0, '', '', '', NULL, -1, 'PERI', '', NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'v', 'numéro de volume', '', 0, 0, '', -1, '', '', '', NULL, 0, 'PERI', '', NULL, NULL); @@ -6536,7 +6536,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'd', 'titre //', '', 1, 0, '', -1, '', '', '', 0, -1, 'WEB', NULL, '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'e', 'sous-titre', '', 1, 0, 'biblioitems.volume', 0, '', '', '', 0, -1, 'WEB', NULL, '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'f', 'auteur', 'auteur', 1, 0, 'biblio.author', 0, '', '', '', 0, 0, 'WEB', NULL, '', NULL); -INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'g', 'autre auteur', 'auteur secondaire', 1, 0, 'additionalauthors.author', -1, '', '', '', 0, 0, 'WEB', NULL, '', NULL); +INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'g', 'autre auteur', 'auteur secondaire', 1, 0, '', -1, '', '', '', 0, 0, 'WEB', NULL, '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'h', 'N° de partie', '', 1, 0, 'biblioitems.volumeddesc', -1, '', '', '', 0, -1, 'WEB', NULL, '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'i', 'titre partie', '', 1, 0, 'biblio.unititle', -1, '', '', '', 0, -1, 'WEB', NULL, '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('200', 'v', 'numéro de volume', '', 0, 0, '', -1, '', '', '', 0, 0, 'WEB', NULL, '', 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 9afda592ab..d22c1b7936 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 @@ -2376,7 +2376,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('700', '6', 'Collegamento', 'Collegamento', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, '', '', '', NULL), - ('700', 'a', 'Nome di persona', 'Nome di persona', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), + ('700', 'a', 'Nome di persona', 'Nome di persona', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), ('700', 'b', 'Numerazione', 'Numerazione', 0, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'c', 'Titoli e altre parole associate al nome', 'Titoli e altre parole associate al nome', 1, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'd', 'Date associate al nome', 'Date associate al nome', 0, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL), diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index c9879b72e1..f88da8b526 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 @@ -2064,7 +2064,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, '', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, 0, '', '', '', 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 f017cca69e..6e84df20d7 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 @@ -2081,7 +2081,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'BKS', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'BKS', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'BKS', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'BKS', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'BKS', '', '', NULL), @@ -6007,7 +6007,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'CF', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'CF', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'CF', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'CF', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'CF', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'CF', '', '', NULL), @@ -9932,7 +9932,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'SR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'SR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'SR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'SR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'SR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'SR', '', '', NULL), @@ -13857,7 +13857,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'VR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'VR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'VR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'VR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'VR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'VR', '', '', NULL), @@ -17780,7 +17780,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'AR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'AR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'AR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'AR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'AR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'AR', '', '', NULL), @@ -21703,7 +21703,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'KT', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'KT', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'KT', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'KT', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'KT', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'KT', '', '', NULL), @@ -25627,7 +25627,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'IR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'IR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'IR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'IR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'IR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'IR', '', '', NULL), @@ -29547,7 +29547,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'SER', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'SER', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'SER', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'SER', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'SER', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'SER', '', '', NULL), diff --git a/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql b/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql index 0d878173f8..7956a3fa0c 100644 --- a/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql +++ b/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql @@ -508,7 +508,7 @@ INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,r INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('658','w','Sorteringsdelfelt for delfelt $a','Sorteringsdelfelt for delfelt $a','0','0','0','6','','','','0','-1','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('700','7','Del av dokumentet som emneinnførselen gjelder','Del av dokumentet som emneinnførselen gjelder','0','0','0','7','','','','0','-1','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('700','8','Andre karakteristika forbundet med navn','Andre karakteristika forbundet med navn','0','0','0','7','','','','0','-1','','','',NULL,'9999'); -INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('700','a','Navn','Navn','0','0','additionalauthors.author','7','','','','0','-1','','','',NULL,'9999'); +INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('700','a','Navn','Navn','0','0','','7','','','','0','-1','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('700','b','Nummer','Nummer','0','0','0','7','','','','0','-1','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('700','c','Andre tilføyelser','Andre tilføyelser','0','0','0','7','','','','0','-1','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('700','d','Årstall forbundet med navn','Årstall forbundet med navn','0','0','0','7','','','','0','-1','','','',NULL,'9999'); diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index 77dc23e6fc..7866ee5e33 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 @@ -2063,7 +2063,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, '', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, 0, '', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, 0, '', '', '', 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 22532ae4ad..2621693ad8 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 @@ -2082,7 +2082,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'BKS', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'BKS', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'BKS', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'BKS', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'BKS', '', '', NULL), @@ -6009,7 +6009,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'CF', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'CF', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'CF', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'CF', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'CF', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'CF', '', '', NULL), @@ -9935,7 +9935,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'SR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'SR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'SR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'SR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'SR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'SR', '', '', NULL), @@ -13861,7 +13861,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'VR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'VR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'VR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'VR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'VR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'VR', '', '', NULL), @@ -17785,7 +17785,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'AR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'AR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'AR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'AR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'AR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'AR', '', '', NULL), @@ -21709,7 +21709,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'KT', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'KT', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'KT', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'KT', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'KT', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'KT', '', '', NULL), @@ -25634,7 +25634,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'IR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'IR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'IR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'IR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'IR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'IR', '', '', NULL), @@ -29555,7 +29555,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'SER', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'SER', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -1, 'SER', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'SER', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'SER', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, '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 55e18f5b4a..183378d7d0 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 @@ -2361,7 +2361,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '700', '5', 0, 0, 'Принадлежность поля организации', '', 7, -6, '', '', '', NULL, '', '', NULL), ('', '', '700', '6', 0, 0, 'Элемент связи', 'Элемент связи', 7, -6, '', '', '', NULL, '', '', NULL), ('', '', '700', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, 0, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, 0, '', '', '', NULL, '', '', NULL), ('', '', '700', 'b', 0, 0, 'Династический номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('', '', '700', 'c', 0, 1, 'Титул (звание)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('', '', '700', 'd', 0, 0, 'Дата', '', 7, 0, '', '', '', NULL, '', '', 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 36be7b046f..19a6a4880b 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 @@ -2332,7 +2332,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('AR', '', '700', '5', 0, 0, 'Принадлежность поля организации', '', 7, -6, '', '', '', NULL, '', '', NULL), ('AR', '', '700', '6', 0, 0, 'Элемент связи', 'Элемент связи', 7, -6, '', '', '', NULL, '', '', NULL), ('AR', '', '700', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('AR', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('AR', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, '', '', '', NULL, '', '', NULL), ('AR', '', '700', 'b', 0, 0, 'Династический номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('AR', '', '700', 'c', 0, 1, 'Титул (звание)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('AR', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 a6c1f07959..654e694fa1 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 @@ -2332,7 +2332,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('BKS', '', '700', '5', 0, 0, 'Принадлежность поля организации', '', 7, -6, '', '', '', NULL, '', '', NULL), ('BKS', '', '700', '6', 0, 0, 'Элемент связи', 'Элемент связи', 7, -6, '', '', '', NULL, '', '', NULL), ('BKS', '', '700', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('BKS', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('BKS', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, '', '', '', NULL, '', '', NULL), ('BKS', '', '700', 'b', 0, 0, 'Династический номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('BKS', '', '700', 'c', 0, 1, 'Титул (звание)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('BKS', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 9388b51496..668666fbc1 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 @@ -2332,7 +2332,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('CF', '', '700', '5', 0, 0, 'Принадлежность поля организации', '', 7, -6, '', '', '', NULL, '', '', NULL), ('CF', '', '700', '6', 0, 0, 'Элемент связи', 'Элемент связи', 7, -6, '', '', '', NULL, '', '', NULL), ('CF', '', '700', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('CF', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('CF', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, '', '', '', NULL, '', '', NULL), ('CF', '', '700', 'b', 0, 0, 'Династический номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('CF', '', '700', 'c', 0, 1, 'Титул (звание)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('CF', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 fc043daf82..e692b2d574 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 @@ -2331,7 +2331,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('IR', '', '700', '5', 0, 0, 'Принадлежность поля организации', '', 7, -6, '', '', '', NULL, '', '', NULL), ('IR', '', '700', '6', 0, 0, 'Элемент связи', 'Элемент связи', 7, -6, '', '', '', NULL, '', '', NULL), ('IR', '', '700', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('IR', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('IR', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, '', '', '', NULL, '', '', NULL), ('IR', '', '700', 'b', 0, 0, 'Династический номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('IR', '', '700', 'c', 0, 1, 'Титул (звание)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('IR', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 6897303898..c669180627 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 @@ -2332,7 +2332,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('KT', '', '700', '5', 0, 0, 'Принадлежность поля организации', '', 7, -6, '', '', '', NULL, '', '', NULL), ('KT', '', '700', '6', 0, 0, 'Элемент связи', 'Элемент связи', 7, -6, '', '', '', NULL, '', '', NULL), ('KT', '', '700', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('KT', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('KT', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, '', '', '', NULL, '', '', NULL), ('KT', '', '700', 'b', 0, 0, 'Династический номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('KT', '', '700', 'c', 0, 1, 'Титул (звание)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('KT', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 3fcc636d40..0a2eb64471 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 @@ -2331,7 +2331,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('SER', '', '700', '5', 0, 0, 'Принадлежность поля организации', '', 7, -6, '', '', '', NULL, '', '', NULL), ('SER', '', '700', '6', 0, 0, 'Элемент связи', 'Элемент связи', 7, -6, '', '', '', NULL, '', '', NULL), ('SER', '', '700', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('SER', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('SER', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, '', '', '', NULL, '', '', NULL), ('SER', '', '700', 'b', 0, 0, 'Династический номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('SER', '', '700', 'c', 0, 1, 'Титул (звание)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('SER', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 57c9c34655..c57cd23ed5 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 @@ -2332,7 +2332,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('SR', '', '700', '5', 0, 0, 'Принадлежность поля организации', '', 7, -6, '', '', '', NULL, '', '', NULL), ('SR', '', '700', '6', 0, 0, 'Элемент связи', 'Элемент связи', 7, -6, '', '', '', NULL, '', '', NULL), ('SR', '', '700', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('SR', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('SR', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, '', '', '', NULL, '', '', NULL), ('SR', '', '700', 'b', 0, 0, 'Династический номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('SR', '', '700', 'c', 0, 1, 'Титул (звание)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('SR', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 52f9550f51..3796394b10 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 @@ -2332,7 +2332,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('VR', '', '700', '5', 0, 0, 'Принадлежность поля организации', '', 7, -6, '', '', '', NULL, '', '', NULL), ('VR', '', '700', '6', 0, 0, 'Элемент связи', 'Элемент связи', 7, -6, '', '', '', NULL, '', '', NULL), ('VR', '', '700', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('VR', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('VR', 'PERSO_NAME', '700', 'a', 0, 0, 'Другие авторы', '', 7, -1, '', '', '', NULL, '', '', NULL), ('VR', '', '700', 'b', 0, 0, 'Династический номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('VR', '', '700', 'c', 0, 1, 'Титул (звание)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('VR', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 c51a46d5ee..5c2b890e04 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 @@ -2699,7 +2699,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '700', '5', 0, 0, 'Приналежність поля організації', '', 7, -6, '', '', '', NULL, '', '', NULL), ('', '', '700', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 7, -6, '', '', '', NULL, '', '', NULL), ('', '', '700', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, 0, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, 0, '', '', '', NULL, '', '', NULL), ('', '', '700', 'b', 0, 0, 'Династичний номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('', '', '700', 'c', 0, 1, 'Титул (звання)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('', '', '700', 'd', 0, 0, 'Дата', '', 7, 0, '', '', '', NULL, '', '', 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 32b4c7882f..df1b35bc05 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 @@ -2332,7 +2332,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('AR', '', '700', '5', 0, 0, 'Приналежність поля організації', '', 7, -6, '', '', '', NULL, '', '', NULL), ('AR', '', '700', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 7, -6, '', '', '', NULL, '', '', NULL), ('AR', '', '700', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('AR', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('AR', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, '', '', '', NULL, '', '', NULL), ('AR', '', '700', 'b', 0, 0, 'Династичний номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('AR', '', '700', 'c', 0, 1, 'Титул (звання)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('AR', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 778191d89b..ff1e545187 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 @@ -2332,7 +2332,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('BKS', '', '700', '5', 0, 0, 'Приналежність поля організації', '', 7, -6, '', '', '', NULL, '', '', NULL), ('BKS', '', '700', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 7, -6, '', '', '', NULL, '', '', NULL), ('BKS', '', '700', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('BKS', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('BKS', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, '', '', '', NULL, '', '', NULL), ('BKS', '', '700', 'b', 0, 0, 'Династичний номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('BKS', '', '700', 'c', 0, 1, 'Титул (звання)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('BKS', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 9e9afb21f1..98761f5d71 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 @@ -2332,7 +2332,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('CF', '', '700', '5', 0, 0, 'Приналежність поля організації', '', 7, -6, '', '', '', NULL, '', '', NULL), ('CF', '', '700', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 7, -6, '', '', '', NULL, '', '', NULL), ('CF', '', '700', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('CF', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('CF', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, '', '', '', NULL, '', '', NULL), ('CF', '', '700', 'b', 0, 0, 'Династичний номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('CF', '', '700', 'c', 0, 1, 'Титул (звання)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('CF', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 9ede88e7a2..70c7638694 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 @@ -2331,7 +2331,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('IR', '', '700', '5', 0, 0, 'Приналежність поля організації', '', 7, -6, '', '', '', NULL, '', '', NULL), ('IR', '', '700', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 7, -6, '', '', '', NULL, '', '', NULL), ('IR', '', '700', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('IR', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('IR', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, '', '', '', NULL, '', '', NULL), ('IR', '', '700', 'b', 0, 0, 'Династичний номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('IR', '', '700', 'c', 0, 1, 'Титул (звання)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('IR', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 d2bbcced09..2f8b85ea45 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 @@ -2332,7 +2332,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('KT', '', '700', '5', 0, 0, 'Приналежність поля організації', '', 7, -6, '', '', '', NULL, '', '', NULL), ('KT', '', '700', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 7, -6, '', '', '', NULL, '', '', NULL), ('KT', '', '700', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('KT', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('KT', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, '', '', '', NULL, '', '', NULL), ('KT', '', '700', 'b', 0, 0, 'Династичний номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('KT', '', '700', 'c', 0, 1, 'Титул (звання)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('KT', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 f10c87979a..07ffa82476 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 @@ -2331,7 +2331,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('SER', '', '700', '5', 0, 0, 'Приналежність поля організації', '', 7, -6, '', '', '', NULL, '', '', NULL), ('SER', '', '700', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 7, -6, '', '', '', NULL, '', '', NULL), ('SER', '', '700', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('SER', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('SER', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, '', '', '', NULL, '', '', NULL), ('SER', '', '700', 'b', 0, 0, 'Династичний номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('SER', '', '700', 'c', 0, 1, 'Титул (звання)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('SER', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 9d3222b7bb..ec0f855cb8 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 @@ -2332,7 +2332,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('SR', '', '700', '5', 0, 0, 'Приналежність поля організації', '', 7, -6, '', '', '', NULL, '', '', NULL), ('SR', '', '700', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 7, -6, '', '', '', NULL, '', '', NULL), ('SR', '', '700', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('SR', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('SR', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, '', '', '', NULL, '', '', NULL), ('SR', '', '700', 'b', 0, 0, 'Династичний номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('SR', '', '700', 'c', 0, 1, 'Титул (звання)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('SR', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', 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 9df4e2fd1c..a5c51fafd4 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 @@ -2332,7 +2332,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('VR', '', '700', '5', 0, 0, 'Приналежність поля організації', '', 7, -6, '', '', '', NULL, '', '', NULL), ('VR', '', '700', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 7, -6, '', '', '', NULL, '', '', NULL), ('VR', '', '700', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 7, -6, '', '', '', NULL, '', '', NULL), - ('VR', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, 'additionalauthors.author', '', '', NULL, '', '', NULL), + ('VR', 'PERSO_NAME', '700', 'a', 0, 0, 'Інші автори', '', 7, -1, '', '', '', NULL, '', '', NULL), ('VR', '', '700', 'b', 0, 0, 'Династичний номер', '', 7, -1, '', '', '', NULL, '', '', NULL), ('VR', '', '700', 'c', 0, 1, 'Титул (звання)', '', 7, -1, '', '', '', NULL, '', '', NULL), ('VR', '', '700', 'd', 0, 0, 'Дата', '', 7, -1, '', '', '', NULL, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql index 463abdbf63..7297ecbdcf 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql @@ -330,7 +330,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '200', 'd', 0, 1, 'Паралельна назва', '', -1, 0, '', '', '', 0, '', '', NULL), ('', '', '200', 'e', 0, 1, 'Підзаголовок', '', 0, 0, '', '', '', 0, '', '', NULL), ('', '', '200', 'f', 0, 1, 'Перші відомості про відповідальність', '', 0, 0, 'biblio.author', '', '', 0, '', '', NULL), - ('', '', '200', 'g', 0, 1, 'Наступні відомості про відповідальність', '', 0, 0, 'additionalauthors.author', '', '', 0, '', '', NULL), + ('', '', '200', 'g', 0, 1, 'Наступні відомості про відповідальність', '', 0, 0, '', '', '', 0, '', '', NULL), ('', '', '200', 'h', 0, 1, 'Позначення та/або номер частини', '', 0, 0, '', '', '', 0, '', '', NULL), ('', '', '200', 'i', 0, 1, 'Найменування частини', '', 0, 0, '', '', '', 0, '', '', NULL), ('', '', '200', 'v', 0, 1, 'Позначення тому', '', 0, 0, '', '', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_general.sql index 02967fd98b..1b8ba82eb2 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_general.sql @@ -130,7 +130,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('BOOK', '', '200', 'd', 0, 1, 'Паралельна назва', '', -1, 0, '', '', '', 0, '', '', NULL), ('BOOK', '', '200', 'e', 0, 1, 'Підзаголовок', '', 0, 0, '', '', '', 0, '', '', NULL), ('BOOK', '', '200', 'f', 0, 1, 'Перші відомості про відповідальність', '', 0, 0, 'biblio.author', '', '', 0, '', '', NULL), - ('BOOK', '', '200', 'g', 0, 1, 'Наступні відомості про відповідальність', '', 0, 0, 'additionalauthors.author', '', '', 0, '', '', NULL), + ('BOOK', '', '200', 'g', 0, 1, 'Наступні відомості про відповідальність', '', 0, 0, '', '', '', 0, '', '', NULL), ('BOOK', '', '200', 'h', 0, 1, 'Позначення та/або номер частини', '', 0, 0, '', '', '', 0, '', '', NULL), ('BOOK', '', '200', 'i', 0, 1, 'Найменування частини', '', 0, 0, '', '', '', 0, '', '', NULL), ('BOOK', '', '200', 'v', 0, 1, 'Позначення тому', '', 0, 0, '', '', '', 0, '', '', NULL), -- 2.20.1