From fd8df69be81cd7515b1ffd646d25a7d86332513c 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 --- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/Obligatoire/marc21_framework_DEFAULT.sql | 2 +- .../marc21/Optionnel/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../Obligatoire/framework_DEFAULT.sql | 10 +++++----- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/optional/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql | 2 +- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/optional/marc21_simple_bib_frameworks.sql | 16 ++++++++-------- .../mandatory/marc21_bibliographic_DEFAULT_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_AR_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_BKS_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_CF_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_IR_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_KT_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_SER_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_SR_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_VR_general.sql | 2 +- .../mandatory/marc21_bibliographic_DEFAULT_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_AR_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_BKS_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_CF_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_IR_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_KT_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_SER_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_SR_general.sql | 2 +- .../marc21/optional/marc21_bibliographic_VR_general.sql | 2 +- .../mandatory/unimarc_bibliographic_DEFAULT_general.sql | 2 +- .../optional/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 1d5fdda..14890ae 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 c916699..46bf421 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 7c367c9..fdf4e66 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 95de08a..8f447bb 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 78c025a..b8bc4b4 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 78d2a43..8937249 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 9afda59..d22c1b7 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 c9879b7..f88da8b 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 f017cca..6e84df2 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 0d87817..7956a3f 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 77dc23e..7866ee5 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 22532ae..2621693 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 55e18f5..183378d 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 36be7b0..19a6a48 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 a6c1f07..654e694 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 9388b51..668666f 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 fc043da..e692b2d 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 6897303..c669180 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 3fcc636..0a2eb64 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 57c9c34..c57cd23 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 52f9550..3796394 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 c51a46d..5c2b890 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 32b4c78..df1b35b 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 778191d..ff1e545 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 9e9afb2..98761f5 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 9ede88e..70c7638 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 d2bbcce..2f8b85e 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 f10c879..07ffa82 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 9d3222b..ec0f855 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 9df4e2f..a5c51fa 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 463abdb..7297ecb 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 02967fd..1b8ba82 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.1.4