Bug 11586 follow-up

 * itemtype = a mix was made between 099$t (biblioitems level) and 995$r (items level).
   I've chosen 099$t (manual change still possible for librarians that want it)
 * the 616$z is mistakenly displayed in tab 0. Switched to 6
 * field "abimé" (995$1) activated, it's better

Signed-off-by: Paul Poulain <paul.poulain@biblibre.com>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>

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 09118e7..b54b4dd 100644 (file)
--- 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
@@ -347,7 +347,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`
 ('099', 'c', 'date creation notice (koha)', '', 0, 0, 'biblio.datecreated', 0, '', '', '', 0, 6, '', NULL, '', ''),
 ('099', 'd', 'date modification notice (koha)', '', 0, 0, 'biblio.timestamp', 0, '', '', '', 0, 6, '', NULL, '', ''),
 ('099', 's', 'Périodique', '', 0, 0, 'biblio.serial', 0, '', '', '', 0, 7, '', NULL, '', ''),
-('099', 't', 'Type de document', '', 0, 0, 'biblioitems.itemtype', 0, 'SUPPORT', '', '', 0, 0, '', NULL, '', ''),
+('099', 't', 'Type de document', '', 0, 0, 'biblioitems.itemtype', 0, 'itemtypes', '', '', 0, 0, '', NULL, '', ''),
 ('099', 'x', 'Nombre de prêts', '', 0, 0, 'biblioitems.totalissues', 0, '', '', '', 0, 6, '', NULL, '', ''),
 ('100', 'a', 'données générales de traitement', '', 0, 1, '', 1, '', '', 'unimarc_field_100.pl', NULL, 0, '', '', NULL, ''),
 ('101', 'a', 'langue du document', '', 1, 0, '', 1, 'LANG', '', '', 0, 0, '', NULL, '', 'fre'),
@@ -1653,7 +1653,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`
 ('616', 'j', 'subdivision de forme', '', 1, 0, '', 6, '', '', '', 0, 0, '', NULL, '', ''),
 ('616', 'x', 'subdivision de la catégorie sujet sous forme textuelle', '', 0, 0, '', 6, '', '', '', 0, 0, '', NULL, '', ''),
 ('616', 'y', 'subdivision géographique', '', 1, 0, '', 6, '', '', '', 0, 0, '', NULL, '', ''),
-('616', 'z', 'Subdivision chronologique', '', 1, 0, '', 0, '', '', '', 0, 0, '', NULL, '', ''),
+('616', 'z', 'Subdivision chronologique', '', 1, 0, '', 6, '', '', '', 0, 0, '', NULL, '', ''),
 ('620', '3', 'numéro de la ville d''autorité', '', 1, 0, '', 6, '', '', '', 0, 0, '', NULL, '', ''),
 ('620', 'a', 'pays', 'lieu d''édition', 1, 0, '', 6, '', '', '', 0, 0, '', NULL, '', ''),
 ('620', 'b', 'Etat, région, etc', 'lieu d''édition', 0, 0, '', 6, '', '', '', 0, 0, '', NULL, '', ''),
@@ -2096,7 +2096,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`
 ('992', '5', 'identifiant de l''exemplaire', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''),
 ('992', 'a', 'classification locale - indice', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''),
 ('995', '0', 'Exclu du prêt', '', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, -8, '', NULL, '', '0'),
-('995', '1', 'Abîmé', '', 0, 0, 'items.damaged', 10, 'DAMAGED', '', '', 0, -1, '', NULL, '', ''),
+('995', '1', 'Abîmé', '', 0, 0, 'items.damaged', 10, 'DAMAGED', '', '', 0, 0, '', NULL, '', ''),
 ('995', '2', 'Perdu ?', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', NULL, '', '0'),
 ('995', '3', 'Retiré de la circulation', '', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', NULL, '', '0'),
 ('995', '4', 'Source de classification', '', 0, 0, 'items.cn_source', -1, 'cn_source', '', '', 0, 0, '', NULL, '', ''),
@@ -2122,7 +2122,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`
 ('995', 'o', 'Statut', '', 0, 0, 'items.notforloan', 10, 'ETAT', '', '', 0, 0, '', NULL, '', ''),
 ('995', 'p', 'Prix', '', 0, 0, 'items.price', 10, '', '', '', 0, -1, '', NULL, '', ''),
 ('995', 'q', 'public visé', '', 0, 0, '', -1, '', '', '', 0, 0, '', NULL, '', ''),
-('995', 'r', 'Type de prêt', '', 0, 1, 'items.itype', 10, 'itemtypes', '', '', 0, 0, '', NULL, '', 'PRETLIV'),
+('995', 'r', 'Type de prêt', '', 0, 1, 'items.itype', -1, 'itemtypes', '', '', 0, 0, '', NULL, '', 'PRETLIV'),
 ('995', 's', 'élément de tri', '', 0, 0, 'items.cn_sort', 10, '', '', '', 0, 7, '', NULL, '', ''),
 ('995', 't', 'Réservation', '', 0, 0, 'items.reserves', 10, '', '', '', 0, 7, '', NULL, '', ''),
 ('995', 'u', 'Note publique /note de retour', '', 0, 0, 'items.itemnotes', 10, '', '', '', 0, 0, '', NULL, '', ''),