From b1dc44d9382b151fb808ec4c61a3f26d90e57ae3 Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Fri, 29 Jun 2012 15:24:37 +0200 Subject: [PATCH] Bug 6557 follow-up UNIMARC 924$0 in default french frameworks --- .../Obligatoire/framework_DEFAULT.sql | 2 ++ .../Obligatoire/framework_DEFAULT.sql | 12 +++++++++++- 2 files changed, 13 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql b/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql index 9b6cc7a..a143758 100644 --- a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql +++ b/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql @@ -227,6 +227,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('931', 'ancienne cote', '', 0, 0, '', ''), ('932', 'future cote', '', 0, 0, NULL, ''), ('936', 'numéro d''inventaire', '', 0, 0, NULL, ''), +('942', 'total des prêts', '', 0, 0, NULL, ''), ('950', 'forme rejetée des zones 5XX', '', 0, 0, NULL, ''), ('955', 'état de collection des publications en série', 'état de collection', 0, 0, NULL, ''), ('956', 'état de collection des publications en série : supplément et matériel d''accompagnement', 'suppléments', 0, 0, NULL, ''), @@ -1867,6 +1868,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('936', 'b', 'qualificatif', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''), ('936', 'c', 'type de la Bibliothèque', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''), ('936', 'd', 'signle de la Bibliothèque', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''), +('942', '0', 'Total des prêts', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''), ('950', '2', 'code système', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''), ('950', '3', 'numéro de la notice d''autorité', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''), ('950', '9', 'numéro d''occurrence de l''étiquette', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, 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 8cc484c..bd27055 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 @@ -220,6 +220,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('931', 'ancienne cote', '', 0, 0, '', ''); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('932', 'future cote', '', 0, 0, NULL, ''); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('936', 'numéro d''inventaire', '', 0, 0, NULL, ''); +INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('942', 'total des prêts', '', 0, 0, NULL, ''); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('950', 'forme rejetée des zones 5XX', '', 0, 0, NULL, ''); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('955', 'état de collection des publications en série', 'état de collection', 0, 0, NULL, ''); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('956', 'état de collection des publications en série : supplément et matériel d''accompagnement', 'suppléments', 0, 0, NULL, ''); @@ -418,6 +419,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('931', 'ancienne cote', '', 0, 0, '', 'ARTI'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('932', 'future cote', '', 0, 0, NULL, 'ARTI'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('936', 'numéro d''inventaire', '', 0, 0, NULL, 'ARTI'); +INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('942', 'total des prêts', '', 0, 0, NULL, 'ARTI'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('950', 'forme rejetée des zones 5XX', '', 0, 0, NULL, 'ARTI'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('955', 'état de collection des publications en série', 'état de collection', 0, 0, NULL, 'ARTI'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('956', 'état de collection des publications en série : supplément et matériel d''accompagnement', 'suppléments', 0, 0, NULL, 'ARTI'); @@ -617,6 +619,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('931', 'ancienne cote', '', 0, 0, '', 'MULT'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('932', 'future cote', '', 0, 0, NULL, 'MULT'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('936', 'numéro d''inventaire', '', 0, 0, NULL, 'MULT'); +INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('942', 'total des prêts', '', 0, 0, NULL, 'MULT'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('950', 'forme rejetée des zones 5XX', '', 0, 0, NULL, 'MULT'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('955', 'état de collection des publications en série', 'état de collection', 0, 0, NULL, 'MULT'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('956', 'état de collection des publications en série : supplément et matériel d''accompagnement', 'suppléments', 0, 0, NULL, 'MULT'); @@ -815,6 +818,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('931', 'ancienne cote', '', 0, 0, '', 'PERI'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('932', 'future cote', '', 0, 0, NULL, 'PERI'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('936', 'numéro d''inventaire', '', 0, 0, NULL, 'PERI'); +INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('942', 'total des prêts', '', 0, 0, NULL, 'PERI'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('950', 'forme rejetée des zones 5XX', '', 0, 0, NULL, 'PERI'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('955', 'état de collection des publications en série', 'état de collection', 0, 0, NULL, 'PERI'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('956', 'état de collection des publications en série : supplément et matériel d''accompagnement', 'suppléments', 0, 0, NULL, 'PERI'); @@ -1013,6 +1017,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('931', 'ancienne cote', '', 0, 0, '', 'WEB'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('932', 'future cote', '', 0, 0, NULL, 'WEB'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('936', 'numéro d''inventaire', '', 0, 0, NULL, 'WEB'); +INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('942', 'total des prêts', '', 0, 0, NULL, 'WEB'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('950', 'forme rejetée des zones 5XX', '', 0, 0, NULL, 'WEB'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('955', 'état de collection des publications en série', 'état de collection', 0, 0, NULL, 'WEB'); INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('956', 'état de collection des publications en série : supplément et matériel d''accompagnement', 'suppléments', 0, 0, NULL, 'WEB'); @@ -2209,6 +2214,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 ('936', 'b', 'qualificatif', '', 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 ('936', 'c', 'type de la Bibliothèque', '', 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 ('936', 'd', 'signle de la Bibliothèque', '', 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 ('942', '0', 'total des prêts', '', 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 ('950', '2', 'code système', '', 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 ('950', '3', 'numéro de la notice d''autorité', '', 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 ('950', '9', 'numéro d''occurrence de l''étiquette', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL); @@ -3550,6 +3556,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 ('936', 'b', 'qualificatif', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', 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 ('936', 'c', 'type de la Bibliothèque', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', 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 ('936', 'd', 'signle de la Bibliothèque', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', 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 ('942', '0', 'total des prêts', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', 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 ('950', '2', 'code système', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', 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 ('950', '3', 'numéro de la notice d''autorité', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', 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 ('950', '9', 'numéro d''occurrence de l''étiquette', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', NULL, NULL, NULL); @@ -4892,6 +4899,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 ('936', 'b', 'qualificatif', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', 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 ('936', 'c', 'type de la Bibliothèque', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', 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 ('936', 'd', 'signle de la Bibliothèque', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', 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 ('942', '0', 'total des prêts', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', 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 ('950', '2', 'code système', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', 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 ('950', '3', 'numéro de la notice d''autorité', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', 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 ('950', '9', 'numéro d''occurrence de l''étiquette', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', NULL, NULL, NULL); @@ -6233,6 +6241,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 ('936', 'b', 'qualificatif', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', 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 ('936', 'c', 'type de la Bibliothèque', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', 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 ('936', 'd', 'signle de la Bibliothèque', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', 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 ('942', '0', 'total des prêts', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', 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 ('950', '2', 'code système', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', 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 ('950', '3', 'numéro de la notice d''autorité', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', 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 ('950', '9', 'numéro d''occurrence de l''étiquette', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', NULL, NULL, NULL); @@ -7574,6 +7583,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 ('936', 'b', 'qualificatif', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', 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 ('936', 'c', 'type de la Bibliothèque', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', 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 ('936', 'd', 'signle de la Bibliothèque', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', 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 ('942', '0', 'total des prêts', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', 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 ('950', '2', 'code système', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', 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 ('950', '3', 'numéro de la notice d''autorité', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', 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 ('950', '9', 'numéro d''occurrence de l''étiquette', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', NULL, NULL, NULL); @@ -7887,4 +7897,4 @@ INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VA INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (149, 'COUNTRY', 'DE', 'Allemagne'); UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000'; -UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100'; \ No newline at end of file +UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100'; -- 1.7.9.5