From 5a46d23fee376b43920e58331103009bcaeef2b3 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Sat, 11 Jul 2015 18:49:45 +0200 Subject: [PATCH] Bug 14199: Modify webinstaller sql files for marc21_orgcode plugin This patch updates the sql installer files for new installations. Occurrences to the three plugins marc21_field_003, 040c and 040d are replaced by marc21_orgcode.pl. This has been generated by one sed statement. Test plan: [1] Run a new installation or run some of the changed sql files manually. [2] Verify that marc21_orgcode is linked to fields previously linked to the three old plugins. [3] Do a git grep on the three plugin file names. No occurrences expected. Signed-off-by: Marcel de Rooy Have tested the three english sql files: authorities_normal_marc21.sql: 18 rows with marc21_orgcode (003 and 040a for 9 auth codes) marc21_framework_DEFAULT.sql: 1 row with marc21_orgcode (003) -- this patch does not add them to 040c or 040d; no behavior change.. marc21_simple_bib_frameworks.sql: 8 rows (003 for 8 frameworks) Signed-off-by: Bernardo Gonzalez Kriegel Signed-off-by: Marcel de Rooy The following files do no longer need an adjustment: installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql For details, check Bug 15097: Update MARC21 de-DE frameworks to Update 21. And similar reports for es-ES and it-IT. Verified this change by installing de-DE in the webinstaller. The plugin for field 003 was correctly set to marc21_orgcode.pl. Signed-off-by: Jonathan Druart Signed-off-by: Kyle M Hall --- .../mandatory/authorities_normal_marc21.sql | 4 +-- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../mandatory/authorities_normal_marc21.sql | 4 +-- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../mandatory/authorities_normal_marc21.sql | 4 +-- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../Obligatoire/authorities_normal_marc21.sql | 36 +++++++++---------- .../Obligatoire/marc21_framework_DEFAULT.sql | 2 +- .../marc21_simple_bib_frameworks.sql | 16 ++++----- .../mandatory/authorities_normal_marc21.sql | 4 +-- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../mandatory/authorities_normal_marc21.sql | 36 +++++++++---------- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 ++++----- .../mandatory/authorities_normal_marc21.sql | 36 +++++++++---------- .../mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 ++++----- .../marc21_authorities_DEFAULT_general.sql | 4 +-- .../marc21_bibliographic_DEFAULT_general.sql | 2 +- .../marc21_authorities_CHRON_TERM_general.sql | 4 +-- .../marc21_authorities_CORPO_NAME_general.sql | 4 +-- .../marc21_authorities_GENRE-FORM_general.sql | 4 +-- .../marc21_authorities_GEOGR_NAME_general.sql | 4 +-- .../marc21_authorities_MEETI_NAME_general.sql | 4 +-- .../marc21_authorities_PERSO_NAME_general.sql | 4 +-- .../marc21_authorities_TOPIC_TERM_general.sql | 4 +-- .../marc21_authorities_UNIF_TITLE_general.sql | 4 +-- .../marc21_bibliographic_AR_general.sql | 2 +- .../marc21_bibliographic_BKS_general.sql | 2 +- .../marc21_bibliographic_CF_general.sql | 2 +- .../marc21_bibliographic_IR_general.sql | 2 +- .../marc21_bibliographic_KT_general.sql | 2 +- .../marc21_bibliographic_SER_general.sql | 2 +- .../marc21_bibliographic_SR_general.sql | 2 +- .../marc21_bibliographic_VR_general.sql | 2 +- .../marc21_authorities_DEFAULT_general.sql | 4 +-- .../marc21_bibliographic_DEFAULT_general.sql | 2 +- .../marc21_authorities_CHRON_TERM_general.sql | 4 +-- .../marc21_authorities_CORPO_NAME_general.sql | 4 +-- .../marc21_authorities_GENRE-FORM_general.sql | 4 +-- .../marc21_authorities_GEOGR_NAME_general.sql | 4 +-- .../marc21_authorities_MEETI_NAME_general.sql | 4 +-- .../marc21_authorities_PERSO_NAME_general.sql | 4 +-- .../marc21_authorities_TOPIC_TERM_general.sql | 4 +-- .../marc21_authorities_UNIF_TITLE_general.sql | 4 +-- .../marc21_bibliographic_AR_general.sql | 2 +- .../marc21_bibliographic_BKS_general.sql | 2 +- .../marc21_bibliographic_CF_general.sql | 2 +- .../marc21_bibliographic_IR_general.sql | 2 +- .../marc21_bibliographic_KT_general.sql | 2 +- .../marc21_bibliographic_SER_general.sql | 2 +- .../marc21_bibliographic_SR_general.sql | 2 +- .../marc21_bibliographic_VR_general.sql | 2 +- 53 files changed, 147 insertions(+), 147 deletions(-) diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index 1fac36bae7..e3f9e30566 100644 --- a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -273,7 +273,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'Kontrollfeld mit fester Länge', 'Kontrollfeld mit fester Länge', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'Kontrollfeld mit fester Länge', 'Kontrollfeld mit fester Länge', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'LC-Kontrollnummer', 'LC-Kontrollnummer', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -351,7 +351,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Gelöschte/ungültige Kontrollnummer', 'Gelöschte/ungültige Kontrollnummer', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Original-Katalogisierungsstelle', 'Original-Katalogisierungsstelle', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Original-Katalogisierungsstelle', 'Original-Katalogisierungsstelle', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Katalogisierungssprache', 'Katalogisierungssprache', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Übertragungsstelle', 'Übertragungsstelle', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Bearbeitungsstelle', 'Bearbeitungsstelle', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), 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 dd17b1972d..5a147c95d7 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 @@ -513,7 +513,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'Kontrollfeld mit fester Länge', 'Kontrollfeld mit fester Länge', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'Kontrollfeld mit fester Länge', 'Kontrollfeld mit fester Länge', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'Kontrollfeld mit fester Länge', 'Kontrollfeld mit fester Länge', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, '', '', '', NULL), diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index 83bf952d2c..04b41b6535 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -273,7 +273,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -351,7 +351,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Canceled/invalid system control number', 'Canceled/invalid system control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), 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 7f9a5a4354..09db0490f6 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 @@ -513,7 +513,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, '', '', '', NULL), diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index f92a6d4369..ddc932a3e2 100644 --- a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -273,7 +273,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'campo de control de longitud fija', 'campo de control de longitud fija', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'campo de control', 'campo de control', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'campo de control', 'campo de control', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'campo de control', 'campo de control', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'campo de control', 'campo de control', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'campo de control de longitud fija', 'campo de control de longitud fija', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'Número de control de LC', 'Número de control de LC', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -351,7 +351,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Número de control cancelado/no válido', 'Número de control cancelado/no válido', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Enlace', 'Enlace', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Centro catalogador/agencia de origen', 'Centro catalogador/agencia de origen', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Centro catalogador/agencia de origen', 'Centro catalogador/agencia de origen', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Lengua de catalogación', 'Lengua de catalogación', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Centro/agencia transcriptor', 'Centro/agencia transcriptor', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Centro/agencia modificador', 'Centro/agencia modificador', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), 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 1c84912d76..08ef8816e1 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 @@ -513,7 +513,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'campo de control de longitud fija', 'campo de control de longitud fija', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'campo de control', 'campo de control', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'campo de control', 'campo de control', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'campo de control', 'campo de control', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'campo de control', 'campo de control', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'campo de control de longitud fija', 'campo de control de longitud fija', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'campo de control de longitud fija', 'campo de control de longitud fija', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, '', '', '', NULL), diff --git a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/authorities_normal_marc21.sql b/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/authorities_normal_marc21.sql index 6d28c41843..f9b7b7f8b5 100644 --- a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/authorities_normal_marc21.sql +++ b/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/authorities_normal_marc21.sql @@ -267,7 +267,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -337,7 +337,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1728,7 +1728,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('PERSO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1780,7 +1780,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('PERSO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2652,7 +2652,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('CORPO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2704,7 +2704,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CORPO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3552,7 +3552,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('MEETI_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3622,7 +3622,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('MEETI_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4474,7 +4474,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('UNIF_TITLE', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4544,7 +4544,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('UNIF_TITLE', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5418,7 +5418,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('CHRON_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5457,7 +5457,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CHRON_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6286,7 +6286,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('TOPIC_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6325,7 +6325,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('TOPIC_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7158,7 +7158,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('GEOGR_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7197,7 +7197,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GEOGR_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8029,7 +8029,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('GENRE/FORM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8050,7 +8050,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GENRE/FORM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), 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 6dcb0ba5bf..95de08aee8 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 @@ -501,7 +501,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 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 05902a9337..7b0e023600 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 @@ -527,7 +527,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'BKS', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'BKS', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'BKS', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'BKS', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'BKS', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'BKS', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'BKS', '', '', NULL), @@ -4454,7 +4454,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'CF', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'CF', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'CF', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'CF', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'CF', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'CF', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'CF', '', '', NULL), @@ -8380,7 +8380,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'SR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'SR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'SR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'SR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'SR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'SR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'SR', '', '', NULL), @@ -12306,7 +12306,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'VR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'VR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'VR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'VR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'VR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'VR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'VR', '', '', NULL), @@ -16230,7 +16230,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'AR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'AR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'AR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'AR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'AR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'AR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'AR', '', '', NULL), @@ -20154,7 +20154,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'KT', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'KT', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'KT', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'KT', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'KT', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'KT', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'KT', '', '', NULL), @@ -24080,7 +24080,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'IR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'IR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'IR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'IR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'IR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'IR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'IR', '', '', NULL), @@ -28001,7 +28001,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'SER', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'SER', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'SER', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'SER', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'SER', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'SER', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'SER', '', '', NULL), diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index b3206a684c..177f7d9ca6 100644 --- a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -273,7 +273,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'campo di controllo', 'campo di controllo', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'campo di controllo', 'campo di controllo', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'campo di controllo', 'campo di controllo', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'campo di controllo', 'campo di controllo', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'Numero di controllo della LC', 'Numero di controllo della LC', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -351,7 +351,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Numero di controllo del sistema cancellato o errato', 'Numero di controllo del sistema cancellato o errato', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Collegamento', 'Collegamento', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Agenzia catalografica originale', 'Agenzia catalografica originale', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Agenzia catalografica originale', 'Agenzia catalografica originale', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Lingua della catalogazione', 'Lingua della catalogazione', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Agenzia che fa la trascrizione', 'Agenzia che fa la trascrizione', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Agenzia che fa la modifica', 'Agenzia che fa la modifica', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), 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 a2e477c25d..e40b10a29e 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 @@ -513,7 +513,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'campo di controllo', 'campo di controllo', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'campo di controllo', 'campo di controllo', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'campo di controllo', 'campo di controllo', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'campo di controllo', 'campo di controllo', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, '', '', '', NULL), diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index 6d28c41843..f9b7b7f8b5 100644 --- a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -267,7 +267,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -337,7 +337,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1728,7 +1728,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('PERSO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1780,7 +1780,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('PERSO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2652,7 +2652,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('CORPO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2704,7 +2704,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CORPO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3552,7 +3552,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('MEETI_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3622,7 +3622,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('MEETI_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4474,7 +4474,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('UNIF_TITLE', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4544,7 +4544,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('UNIF_TITLE', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5418,7 +5418,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('CHRON_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5457,7 +5457,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CHRON_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6286,7 +6286,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('TOPIC_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6325,7 +6325,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('TOPIC_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7158,7 +7158,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('GEOGR_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7197,7 +7197,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GEOGR_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8029,7 +8029,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('GENRE/FORM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8050,7 +8050,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GENRE/FORM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), 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 600aa0858b..c9879b72e1 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 @@ -501,7 +501,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 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 d1784164dc..f78e9dfc33 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 @@ -526,7 +526,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'BKS', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'BKS', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'BKS', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'BKS', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'BKS', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'BKS', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'BKS', '', '', NULL), @@ -4452,7 +4452,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'CF', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'CF', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'CF', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'CF', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'CF', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'CF', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'CF', '', '', NULL), @@ -8377,7 +8377,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'SR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'SR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'SR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'SR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'SR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'SR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'SR', '', '', NULL), @@ -12302,7 +12302,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'VR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'VR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'VR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'VR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'VR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'VR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'VR', '', '', NULL), @@ -16225,7 +16225,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'AR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'AR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'AR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'AR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'AR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'AR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'AR', '', '', NULL), @@ -20148,7 +20148,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'KT', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'KT', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'KT', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'KT', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'KT', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'KT', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'KT', '', '', NULL), @@ -24073,7 +24073,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'IR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'IR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'IR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'IR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'IR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'IR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'IR', '', '', NULL), @@ -27993,7 +27993,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'SER', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'SER', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'SER', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'SER', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'SER', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'SER', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'SER', '', '', NULL), diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index 6d28c41843..f9b7b7f8b5 100644 --- a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -267,7 +267,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -337,7 +337,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1728,7 +1728,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('PERSO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1780,7 +1780,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('PERSO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2652,7 +2652,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('CORPO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2704,7 +2704,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CORPO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3552,7 +3552,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('MEETI_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3622,7 +3622,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('MEETI_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4474,7 +4474,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('UNIF_TITLE', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4544,7 +4544,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('UNIF_TITLE', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5418,7 +5418,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('CHRON_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5457,7 +5457,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CHRON_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6286,7 +6286,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('TOPIC_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6325,7 +6325,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('TOPIC_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7158,7 +7158,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('GEOGR_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7197,7 +7197,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GEOGR_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8029,7 +8029,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('GENRE/FORM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8050,7 +8050,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GENRE/FORM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), 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 3671529e86..77dc23e6fc 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 @@ -500,7 +500,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 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 394270bdcd..22532ae4ad 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 @@ -527,7 +527,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'BKS', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'BKS', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'BKS', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'BKS', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'BKS', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'BKS', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'BKS', '', '', NULL), @@ -4454,7 +4454,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'CF', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'CF', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'CF', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'CF', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'CF', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'CF', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'CF', '', '', NULL), @@ -8380,7 +8380,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'SR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'SR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'SR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'SR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'SR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'SR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'SR', '', '', NULL), @@ -12306,7 +12306,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'VR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'VR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'VR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'VR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'VR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'VR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'VR', '', '', NULL), @@ -16230,7 +16230,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'AR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'AR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'AR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'AR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'AR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'AR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'AR', '', '', NULL), @@ -20154,7 +20154,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'KT', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'KT', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'KT', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'KT', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'KT', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'KT', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'KT', '', '', NULL), @@ -24080,7 +24080,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'IR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'IR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'IR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'IR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'IR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'IR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'IR', '', '', NULL), @@ -28001,7 +28001,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat 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 ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'SER', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'SER', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'SER', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'SER', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'SER', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'SER', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'SER', '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql index 9560b54eca..143ef79d66 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', '', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', '', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -140,7 +140,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', '', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', '', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', '', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', '', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), 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 f838810665..55e18f5b4a 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 @@ -19,7 +19,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '005', '', '', 'Дата корректировки', '', ''); diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql index b4685fb2c3..058a47f63b 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CHRON_TERM', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'CHRON_TERM', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'CHRON_TERM', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CHRON_TERM', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -93,7 +93,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'CHRON_TERM', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'CHRON_TERM', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'CHRON_TERM', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'CHRON_TERM', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql index 7a5429beaf..cd91143a19 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CORPO_NAME', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'CORPO_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'CORPO_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CORPO_NAME', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -118,7 +118,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'CORPO_NAME', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'CORPO_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'CORPO_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'CORPO_NAME', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql index 8cb28d114e..ff53c76b03 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GENRE/FORM', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'GENRE/FORM', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'GENRE/FORM', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GENRE/FORM', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -71,7 +71,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'GENRE/FORM', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'GENRE/FORM', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'GENRE/FORM', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'GENRE/FORM', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql index 541635fb42..4e8896b6af 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GEOGR_NAME', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'GEOGR_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'GEOGR_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GEOGR_NAME', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -93,7 +93,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'GEOGR_NAME', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'GEOGR_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'GEOGR_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'GEOGR_NAME', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql index c7ada4f65a..2e9de3f7f0 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('MEETI_NAME', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'MEETI_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'MEETI_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('MEETI_NAME', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -140,7 +140,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'MEETI_NAME', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'MEETI_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'MEETI_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'MEETI_NAME', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql index 4fcb4b1103..f4add34f9b 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('PERSO_NAME', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'PERSO_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'PERSO_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('PERSO_NAME', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -118,7 +118,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'PERSO_NAME', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'PERSO_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'PERSO_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'PERSO_NAME', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql index 898b90f8c3..37f221ca08 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('TOPIC_TERM', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'TOPIC_TERM', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'TOPIC_TERM', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('TOPIC_TERM', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -93,7 +93,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'TOPIC_TERM', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'TOPIC_TERM', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'TOPIC_TERM', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'TOPIC_TERM', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql index 3efc4469bf..cd6edcf7e0 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('UNIF_TITLE', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'UNIF_TITLE', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'UNIF_TITLE', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('UNIF_TITLE', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -140,7 +140,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'UNIF_TITLE', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'UNIF_TITLE', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'UNIF_TITLE', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'UNIF_TITLE', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), 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 63a6d0a504..36be7b046f 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('AR', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('AR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('AR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('AR', '005', '', '', 'Дата корректировки', '', ''); 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 fc918d0a55..a6c1f07959 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('BKS', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('BKS', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('BKS', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('BKS', '005', '', '', 'Дата корректировки', '', ''); 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 04827a4f01..9388b51496 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CF', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('CF', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('CF', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CF', '005', '', '', 'Дата корректировки', '', ''); 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 d84e336876..fc043daf82 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('IR', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('IR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('IR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('IR', '005', '', '', 'Дата корректировки', '', ''); 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 81c7b50b27..6897303898 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('KT', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('KT', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('KT', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('KT', '005', '', '', 'Дата корректировки', '', ''); 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 0160a19880..3fcc636d40 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SER', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('SER', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('SER', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SER', '005', '', '', 'Дата корректировки', '', ''); 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 df0d94ee25..57c9c34655 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SR', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('SR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('SR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SR', '005', '', '', 'Дата корректировки', '', ''); 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 f5786d4c7c..52f9550f51 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('VR', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('VR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('VR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('VR', '005', '', '', 'Дата корректировки', '', ''); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql index c1aa57c981..d580ab00ef 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', '', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', '', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -140,7 +140,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', '', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', '', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', '', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', '', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), 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 6ccc172715..0233171a6b 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '005', '', '', 'Дата коректування', '', ''); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql index 269756a078..1172d60f6e 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CHRON_TERM', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'CHRON_TERM', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'CHRON_TERM', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CHRON_TERM', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -93,7 +93,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'CHRON_TERM', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'CHRON_TERM', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'CHRON_TERM', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'CHRON_TERM', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql index 199eb6f7e6..a54ab1949c 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CORPO_NAME', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'CORPO_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'CORPO_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CORPO_NAME', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -118,7 +118,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'CORPO_NAME', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'CORPO_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'CORPO_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'CORPO_NAME', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql index 880fc64b49..f63b34491d 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GENRE/FORM', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'GENRE/FORM', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'GENRE/FORM', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GENRE/FORM', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -71,7 +71,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'GENRE/FORM', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'GENRE/FORM', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'GENRE/FORM', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'GENRE/FORM', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql index 709af63b0f..214dd90271 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GEOGR_NAME', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'GEOGR_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'GEOGR_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GEOGR_NAME', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -93,7 +93,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'GEOGR_NAME', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'GEOGR_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'GEOGR_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'GEOGR_NAME', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql index ee5ef54b8b..1b6dcef02f 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('MEETI_NAME', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'MEETI_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'MEETI_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('MEETI_NAME', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -140,7 +140,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'MEETI_NAME', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'MEETI_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'MEETI_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'MEETI_NAME', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql index 8d95e8c0b0..375d63d232 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('PERSO_NAME', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'PERSO_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'PERSO_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('PERSO_NAME', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -118,7 +118,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'PERSO_NAME', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'PERSO_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'PERSO_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'PERSO_NAME', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql index 01c511ac9b..f4d4f131a4 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('TOPIC_TERM', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'TOPIC_TERM', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'TOPIC_TERM', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('TOPIC_TERM', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -93,7 +93,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'TOPIC_TERM', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'TOPIC_TERM', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'TOPIC_TERM', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'TOPIC_TERM', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql index 8a94519d45..f3f7e9e88a 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('UNIF_TITLE', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'UNIF_TITLE', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'UNIF_TITLE', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('UNIF_TITLE', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -140,7 +140,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'UNIF_TITLE', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'UNIF_TITLE', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'UNIF_TITLE', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'UNIF_TITLE', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), 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 2228201335..1f91fa35b8 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('AR', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('AR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('AR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('AR', '005', '', '', 'Дата коректування', '', ''); 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 c16acab647..d713b7caaa 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('BKS', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('BKS', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('BKS', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('BKS', '005', '', '', 'Дата коректування', '', ''); 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 942e468448..ac4b789a34 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CF', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('CF', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('CF', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CF', '005', '', '', 'Дата коректування', '', ''); 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 a1647aee06..9ca7ce0c2b 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('IR', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('IR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('IR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('IR', '005', '', '', 'Дата коректування', '', ''); 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 f7c204741b..2b791c50a9 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('KT', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('KT', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('KT', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('KT', '005', '', '', 'Дата коректування', '', ''); 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 4bb26cad03..d619c99a32 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SER', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('SER', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('SER', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SER', '005', '', '', 'Дата коректування', '', ''); 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 0b83d44b28..47da9fdc48 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SR', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('SR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('SR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SR', '005', '', '', 'Дата коректування', '', ''); 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 50f4795a19..f3829b1687 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('VR', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('VR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('VR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('VR', '005', '', '', 'Дата коректування', '', ''); -- 2.39.5