@@ -, +, @@ frameworks --- .../Obligatoire/framework_DEFAULT.sql | 2 ++ .../Obligatoire/framework_DEFAULT.sql | 12 +++++++++++- 2 files changed, 13 insertions(+), 1 deletion(-) --- a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql +++ a/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, ''), --- a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql +++ a/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'; +UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100'; --