From 6e4d456422e3f3fb476a64767330b1e21766638c Mon Sep 17 00:00:00 2001 From: Sophie Meynieux Date: Tue, 29 Oct 2013 14:27:57 +0100 Subject: [PATCH] Bug 10726 - Followup : missing subfields in previous specifications edition --- .../marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql | 7 +++++++ .../unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql | 2 ++ 2 files changed, 9 insertions(+) diff --git a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql index 934af73..f76b5cc 100644 --- a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql +++ b/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql @@ -1158,17 +1158,23 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('510', 'z', 'Language of Title', 'Language of Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('512', 'a', 'Cover Title', 'Cover Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('512', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), + ('512', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('513', 'a', 'Added Title - Page Title', 'Added Title - Page Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('513', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('513', 'h', 'Number of Part', 'Number of Part', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('513', 'i', 'Name of Part', 'Name of Part', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), + ('513', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('514', 'a', 'Caption Title', 'Caption Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('514', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), + ('514', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('515', 'a', 'Running Title', 'Running Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), + ('515', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('516', 'a', 'Spine Title', 'Spine Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('516', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), + ('516', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('517', 'a', 'Variant Title', 'Variant Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('517', 'e', 'Other Title Information', 'Other Title Information', 0, 0, '', 5, '', '', NULL, 0, 0, '', '', '', NULL), + ('517', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('518', 'a', 'Title Proper, Variant Title or Uniform Title in Standard Modern Spelling', 'Title Proper, Variant Title or Uniform Title in Standard Modern Spelling', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('518', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('518', 'h', 'Number of Part', 'Number of Part', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), @@ -1193,6 +1199,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('532', 'a', 'Expanded Title', 'Expanded Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('532', 'z', 'Language of Title', 'Language of Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('540', 'a', 'Additional Title Supplied by Cataloguer', 'Additional Title Supplied by Cataloguer', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), + ('540', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('541', 'a', 'Translated Title Supplied by Cataloguer', 'Translated Title Supplied by Cataloguer', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('541', 'e', 'Other Title Information', 'Other Title Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('541', 'h', 'Number of Part', 'Number of Part', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), diff --git a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql index 175f082..314c4d7 100644 --- a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql +++ b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql @@ -1872,6 +1872,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('517', 'e', 'sous-titre', '', 1, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('517', 'h', 'numéro de partie', '', 1, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('517', 'i', 'titre de partie', '', 1, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL); +INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('517', 'n', 'autres informations', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('518', 'a', 'titre de dos', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('518', 'e', 'complément du titre', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('518', 'h', 'numéro de partie', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL); @@ -1896,6 +1897,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('532', 'a', 'titre développé', 'titre développé', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('532', 'z', 'langue du titre', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('540', 'a', 'titre ajouté par le catalogueur', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL); +INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('540', 'n', 'autres informations', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('541', 'a', 'titre traduit', 'titre traduit', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('541', 'e', 'complément du titre', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('541', 'h', 'numéro de partie', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL); -- 1.7.10.4