View | Details | Raw Unified | Return to bug 10138
Collapse All | Expand All

(-)a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql (-1 / +32 lines)
Lines 1-9 Link Here
1
-- Reasons for acceptance or rejection of suggestions in acquisitions
2
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('SUGGEST','Bestseller','Bestseller');
3
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('SUGGEST','Endommagé','L''exemplaire de la bibliothèque endommagé');
4
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('SUGGEST','Perdu','L''exemplaire de la bibliothèque est perdu');
5
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('SUGGEST','PEB','Document disponible via le Prêt Entre Bibliothèques');
6
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('SUGGEST','Budget','Budget insuffisant');
7
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('SUGGEST','Onéreux','Document trop onéreux');
8
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('SUGGEST','Poldoc','Document ne correspondant pas à notre politique d''acquisition');
9
-- OPAC Suggestions reasons
10
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('OPAC_SUG','damaged','L''exemplaire de la bibliothèque est endommagé','L''exemplaire de la bibliothèque est endommagdé');
11
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('OPAC_SUG','bestseller','Bestseller','Bestseller');
12
-- Report groups
13
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('REPORT_GROUP', 'CIRC', 'Circulation');
14
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('REPORT_GROUP', 'CAT', 'Catalogue');
15
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('REPORT_GROUP', 'PAT', 'Adhérents');
16
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('REPORT_GROUP', 'ACQ', 'Acquisitions');
17
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('REPORT_GROUP', 'ACC', 'Comptes');
18
-- availability statuses
19
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('LOST','1','Perdu');
20
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('LOST','2','Long retard (perdu)');
21
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('LOST','3','Perdu et remboursé');
22
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('LOST','4','Introuvable');
23
-- damaged status of an item
24
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('DAMAGED','1','Endommagdé');
25
-- Status codes
1
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '0', 'Empruntable');
26
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '0', 'Empruntable');
2
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '1', 'Exclu du prêt');
27
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '1', 'Exclu du prêt');
3
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '3', 'En reliure');
28
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '3', 'En reliure');
4
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '4', 'Indisponible');
29
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '4', 'Indisponible');
5
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '5', 'En traitement');
30
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '5', 'En traitement');
6
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '6', 'Non communicable');
31
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '6', 'Non communicable');
32
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '7', 'En commande');
33
-- location qualification for an item, departments are linked by default to items.location
7
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LOC', 'Magasin', ' Magasin');
34
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LOC', 'Magasin', ' Magasin');
8
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LOC', 'Salle de lecture', 'Salle de lecture');
35
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LOC', 'Salle de lecture', 'Salle de lecture');
9
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LOC', 'Magasin des périodiques', 'Magasin des périodiques');
36
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LOC', 'Magasin des périodiques', 'Magasin des périodiques');
Lines 11-18 INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES Link Here
11
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LOC', 'Manquant', 'Manquant');
38
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LOC', 'Manquant', 'Manquant');
12
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LOC', 'Secrétariat', 'Secrétariat');
39
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LOC', 'Secrétariat', 'Secrétariat');
13
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LOC', 'En reliure', 'En reliure');
40
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LOC', 'En reliure', 'En reliure');
41
-- Type of authorities
14
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'CAND', 'Candidat descripteur', 'Candidat descripteur');
42
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'CAND', 'Candidat descripteur', 'Candidat descripteur');
15
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'CAND', 'Rejeté', 'Mot clé abandonné');
43
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'CAND', 'Rejeté', 'Mot clé abandonné');
44
-- Country codes
16
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'AN', 'Antilles Néerlandaises');
45
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'AN', 'Antilles Néerlandaises');
17
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'CR', 'Costa Rica');
46
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'CR', 'Costa Rica');
18
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'ER', 'Allemagne');
47
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'ER', 'Allemagne');
Lines 265-270 INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES Link Here
265
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'ZM', 'Zambie');
294
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'ZM', 'Zambie');
266
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'ZW', 'Zimbabwe');
295
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'ZW', 'Zimbabwe');
267
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'ZZ', 'multiple');
296
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'ZZ', 'multiple');
297
-- Language codes (ISO 639-2)
268
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LANG', 'aar','afar');
298
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LANG', 'aar','afar');
269
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LANG', 'abk','abkhaze');
299
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LANG', 'abk','abkhaze');
270
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LANG', 'ace','achinese');
300
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LANG', 'ace','achinese');
Lines 521-526 INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES Link Here
521
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LANG', 'lan','occitan (post 1500)');
551
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LANG', 'lan','occitan (post 1500)');
522
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LANG', 'mla','malgache');
552
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LANG', 'mla','malgache');
523
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LANG', 'sam','samaritain');
553
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'LANG', 'sam','samaritain');
554
-- UNIMARC function codes
524
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '000', 'Fonction indéterminée');
555
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '000', 'Fonction indéterminée');
525
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '005', 'Acteur');
556
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '005', 'Acteur');
526
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '010', 'Adaptateur');
557
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '010', 'Adaptateur');
Lines 655-658 INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES Link Here
655
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '571', 'Coordinateur');
686
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '571', 'Coordinateur');
656
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '573', 'Diffuseur');
687
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '573', 'Diffuseur');
657
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '574', 'Présentateur');
688
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '574', 'Présentateur');
658
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '575', 'Responsable');
689
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'qualif', '575', 'Responsable');
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.txt (-1 / +3 lines)
Line 1 Link Here
1
Des listes de valeurs autorisées bien utiles pour la constitution des grilles de catalogage.
1
Des listes de valeurs autorisées utiles pour la constitution des grilles de catalogage (codes de pays, codes de langues, codes de fonction UNIMARC),
2
pour la gestion des exemplaires (statut, perte ou disparition),
3
et pour le fonctionnement de Koha (tri des rapports, motifs des suggestions)
(-)a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql (-1 / +2 lines)
Lines 2013-2019 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
2013
('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''),
2013
('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''),
2014
('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''),
2014
('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''),
2015
('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''),
2015
('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, ''),
2016
('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, '', '', '', NULL, 1, '', NULL, NULL, ''),
2016
('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '', NULL, 1, '', NULL, NULL, ''),
2017
('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', NULL, 0, '', NULL, NULL, ''),
2017
('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', NULL, 0, '', NULL, NULL, ''),
2018
('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', NULL, 0, '', NULL, NULL, ''),
2018
('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', NULL, 0, '', NULL, NULL, ''),
2019
('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', NULL, 0, '', NULL, NULL, ''),
2019
('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', NULL, 0, '', NULL, NULL, ''),
Lines 2036-2039 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
2036
('995', 'u', 'note', '', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', NULL, NULL, '');
2036
('995', 'u', 'note', '', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', NULL, NULL, '');
2037
2037
2038
UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
2038
UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
2039
2039
UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';
2040
UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';
(-)a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Optionnel/cataloguage_rapide.sql (-1 / +1 lines)
Lines 68-74 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
68
('225', 'v', 'numérotation du volume', '', 1, 0, 'biblioitems.collectionvolume', 2, '', '', '', 0, 0, 'FA', NULL, '', ''),
68
('225', 'v', 'numérotation du volume', '', 1, 0, 'biblioitems.collectionvolume', 2, '', '', '', 0, 0, 'FA', NULL, '', ''),
69
('225', 'x', 'ISSN de la collection', '', 1, 0, 'biblioitems.collectionissn', 2, '', '', '', 0, 0, 'FA', NULL, '', ''),
69
('225', 'x', 'ISSN de la collection', '', 1, 0, 'biblioitems.collectionissn', 2, '', '', '', 0, 0, 'FA', NULL, '', ''),
70
('225', 'z', 'langue du titre parallèle', '', 1, 0, '', 2, '', '', '', 0, 0, 'FA', NULL, '', ''),
70
('225', 'z', 'langue du titre parallèle', '', 1, 0, '', 2, '', '', '', 0, 0, 'FA', NULL, '', ''),
71
('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, '', '', '', NULL, 1, 'FA', NULL, NULL, ''),
71
('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '', NULL, 1, 'FA', NULL, NULL, ''),
72
('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', NULL, 0, 'FA', NULL, NULL, ''),
72
('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', NULL, 0, 'FA', NULL, NULL, ''),
73
('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', NULL, 0, 'FA', NULL, NULL, ''),
73
('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', NULL, 0, 'FA', NULL, NULL, ''),
74
('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', NULL, 0, 'FA', NULL, NULL, ''),
74
('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', NULL, 0, 'FA', NULL, NULL, ''),
(-)a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql (-140 / +122 lines)
Lines 2359-2364 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
2359
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 ('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
2359
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 ('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
2360
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 ('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
2360
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 ('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
2361
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 ('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
2361
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 ('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
2362
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 ('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '', NULL, 1, '', NULL, NULL, '');
2362
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 ('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', 0, 0, '', '', '', NULL);
2363
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 ('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', 0, 0, '', '', '', NULL);
2363
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 ('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', 0, 0, '', '', '', NULL);
2364
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 ('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', 0, 0, '', '', '', NULL);
2364
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 ('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', 0, 0, '', '', '', NULL);
2365
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 ('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', 0, 0, '', '', '', NULL);
Lines 3701-3706 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
3701
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 ('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', NULL, NULL, NULL);
3702
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 ('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', NULL, NULL, NULL);
3702
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 ('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', NULL, NULL, NULL);
3703
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 ('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', NULL, NULL, NULL);
3703
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 ('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', NULL, NULL, NULL);
3704
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 ('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'ARTI', NULL, NULL, NULL);
3705
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 ('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '', NULL, 1, 'ARTI', '', NULL, 0);
3704
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 ('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', NULL, 0, 'ARTI', '', NULL, NULL);
3706
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 ('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', NULL, 0, 'ARTI', '', NULL, NULL);
3705
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 ('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', NULL, 0, 'ARTI', '', NULL, NULL);
3707
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 ('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', NULL, 0, 'ARTI', '', NULL, NULL);
3706
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 ('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', NULL, 0, 'ARTI', '', NULL, NULL);
3708
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 ('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', NULL, 0, 'ARTI', '', NULL, NULL);
Lines 5044-5049 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
5044
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 ('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', NULL, NULL, NULL);
5046
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 ('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', NULL, NULL, NULL);
5045
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 ('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', NULL, NULL, NULL);
5047
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 ('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', NULL, NULL, NULL);
5046
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 ('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', NULL, NULL, NULL);
5048
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 ('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'MULT', NULL, NULL, NULL);
5049
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 ('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '', NULL, 1, 'MULT', NULL, NULL, '');
5047
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 ('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', 0, 0, 'MULT', NULL, '', NULL);
5050
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 ('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', 0, 0, 'MULT', NULL, '', NULL);
5048
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 ('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', 0, 0, 'MULT', NULL, '', NULL);
5051
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 ('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', 0, 0, 'MULT', NULL, '', NULL);
5049
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 ('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', 0, 0, 'MULT', NULL, '', NULL);
5052
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 ('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', 0, 0, 'MULT', NULL, '', NULL);
Lines 6386-6391 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
6386
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 ('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', NULL, NULL, NULL);
6389
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 ('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', NULL, NULL, NULL);
6387
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 ('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', NULL, NULL, NULL);
6390
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 ('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', NULL, NULL, NULL);
6388
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 ('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', NULL, NULL, NULL);
6391
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 ('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'PERI', NULL, NULL, NULL);
6392
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 ('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '', NULL, 1, 'PERI', NULL, NULL, '');
6389
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 ('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', 0, 0, 'PERI', NULL, '', NULL);
6393
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 ('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', 0, 0, 'PERI', NULL, '', NULL);
6390
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 ('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', 0, 0, 'PERI', NULL, '', NULL);
6394
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 ('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', 0, 0, 'PERI', NULL, '', NULL);
6391
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 ('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', 0, 0, 'PERI', NULL, '', NULL);
6395
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 ('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', 0, 0, 'PERI', NULL, '', NULL);
Lines 7728-7733 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
7728
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 ('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', NULL, NULL, NULL);
7732
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 ('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', NULL, NULL, NULL);
7729
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 ('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', NULL, NULL, NULL);
7733
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 ('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', NULL, NULL, NULL);
7730
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 ('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', NULL, NULL, NULL);
7734
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 ('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, 'WEB', NULL, NULL, NULL);
7735
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 ('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '', NULL, 1, 'WEB', NULL, NULL, '');
7731
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 ('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7736
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 ('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7732
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 ('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7737
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 ('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7733
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 ('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', -1, 'branches', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7738
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 ('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', -1, 'branches', '', '', NULL, 0, 'WEB', '', NULL, NULL);
Lines 7743-7749 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
7743
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 ('995', 'l', 'volumaison', '', 0, 1, '', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7748
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 ('995', 'l', 'volumaison', '', 0, 1, '', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7744
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 ('995', 'm', 'Date prêt', '', 0, 0, 'items.datelastseen', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7749
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 ('995', 'm', 'Date prêt', '', 0, 0, 'items.datelastseen', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7745
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 ('995', 'n', 'date de restitution prévue', 'à rendre pour le', 0, 0, 'items.onloan', 10, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7750
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 ('995', 'n', 'date de restitution prévue', 'à rendre pour le', 0, 0, 'items.onloan', 10, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7746
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 ('995', 'o', 'Statut', '', 0, 1, 'items.notforloan', -1, 'statut', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7751
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 ('995', 'o', 'Statut', '', 0, 1, 'items.notforloan', -1, 'ETAT', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7747
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 ('995', 'q', 'Public', '', 0, 0, '', -1, 'public', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7752
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 ('995', 'q', 'Public', '', 0, 0, '', -1, 'public', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7748
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 ('995', 'r', 'type de document et support matériel', '', 0, 1, '', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7753
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 ('995', 'r', 'type de document et support matériel', '', 0, 1, '', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7749
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 ('995', 's', 'élément de tri', '', 0, 1, 'items.itemlost', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
7754
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 ('995', 's', 'élément de tri', '', 0, 1, 'items.itemlost', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL);
Lines 7756-7900 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
7756
--
7761
--
7757
-- Valeurs autorisées nécessaires pour la cohérence des grilles.
7762
-- Valeurs autorisées nécessaires pour la cohérence des grilles.
7758
7763
7759
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1, 'genre', 'Biographie', 'Biographie');
7764
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('genre', 'Biographie', 'Biographie');
7760
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (2, 'genre', 'Nouvelle', 'Nouvelle');
7765
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('genre', 'Nouvelle', 'Nouvelle');
7761
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (3, 'genre', 'Policier', 'Policier');
7766
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('genre', 'Policier', 'Policier');
7762
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (4, 'genre', 'Poésie', 'Poésie');
7767
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('genre', 'Poésie', 'Poésie');
7763
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (5, 'genre', 'Théâtre', 'Théâtre');
7768
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('genre', 'Théâtre', 'Théâtre');
7764
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (6, 'genre', 'Conte', 'Conte');
7769
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('genre', 'Conte', 'Conte');
7765
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (7, 'genre', 'Science fiction', 'Science fiction');
7770
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('genre', 'Science fiction', 'Science fiction');
7766
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (8, 'genre', 'Roman', 'Roman');
7771
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('genre', 'Roman', 'Roman');
7767
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (9, 'Bsort1', '01', 'Agriculteurs, exploitant');
7772
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort1', '01', 'Agriculteurs, exploitant');
7768
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (10, 'Bsort1', '02', 'Artisants, commerçants, chefs d''entreprise');
7773
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort1', '02', 'Artisants, commerçants, chefs d''entreprise');
7769
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (11, 'Bsort1', '03', 'Cadres, professions intellectuelles Supérieures');
7774
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort1', '03', 'Cadres, professions intellectuelles Supérieures');
7770
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (12, 'Bsort1', '04', 'Professions intermédiaires');
7775
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort1', '04', 'Professions intermédiaires');
7771
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (13, 'Bsort1', '05', 'Employés');
7776
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort1', '05', 'Employés');
7772
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (14, 'Bsort1', '06', 'Ouvriers');
7777
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort1', '06', 'Ouvriers');
7773
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (15, 'Bsort1', '07', 'Retraités');
7778
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort1', '07', 'Retraités');
7774
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (16, 'Bsort1', '08', 'Demandeurs d''emploi');
7779
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort1', '08', 'Demandeurs d''emploi');
7775
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (17, 'Bsort1', '09', 'Sans emploi');
7780
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort1', '09', 'Sans emploi');
7776
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (18, 'Bsort1', '10', 'Etudiants');
7781
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort1', '10', 'Étudiants');
7777
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (19, 'Bsort1', '11', ' CSP non déclarée');
7782
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort1', '11', 'CSP non déclarée');
7778
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (20, 'Bsort1', '12', 'Elèves ou enfants non scolarisés');
7783
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort1', '12', 'Élèves ou enfants non scolarisés');
7779
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (21, 'statut', '0', '  Disponible');
7784
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('public', 'a', 'Adulte');
7780
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (22, 'langue', 'fre', ' Français');
7785
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('public', 'j', 'Jeune');
7781
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (23, 'langue', 'eng', 'Anglais');
7786
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('public', 'u', 'Indéterminé');
7782
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (24, 'langue', 'ger', 'Allemand');
7787
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('public', 'z', 'Autre');
7783
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (25, 'langue', 'dut', 'Hollandais');
7788
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Espace document adapté', 'Espace document adapté');
7784
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (26, 'pcdm', '0- Généralités, sciences et techniques musicales', '0- Généralités, sciences et techniques musicales');
7789
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Espace local', 'Espace local');
7785
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (27, 'pcdm', '0.1 Philosophie, esthétique, critique, sociologie, pratiques', '0.1 Philosophie, esthétique, critique, sociologie, pratiques');
7790
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Espace théâtre/poésie', 'Espace théâtre/poésie');
7786
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (28, 'pcdm', '0.2 Institutions musicales', '0.2 Institutions musicales');
7791
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Espace enfant', 'Espace enfant');
7787
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (29, 'pcdm', '0.3 Dictionnaires', '0.3 Dictionnaires');
7792
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Périodiques', 'Périodiques');
7788
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (30, 'pcdm', '0.4 Répertoires, catalogues', '0.4 Répertoires, catalogues');
7793
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Espace petite enfance', 'Espace petite enfance');
7789
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (31, 'pcdm', '0.5 Apprentissage et enseignement', '0.5 Apprentissage et enseignement');
7794
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Magasin/réserve', 'Magasin/réserve');
7790
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (32, 'pcdm', '0.6 Techniques musicales et vocales', '0.6 Techniques musicales et vocales');
7795
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Espace audiovisuel', 'Espace audiovisuel');
7791
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (33, 'pcdm', '0.7 Sciences et techniques en lien', '0.7 Sciences et techniques en lien');
7796
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Espace multimédia', 'Espace multimédia');
7792
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (34, 'pcdm', '0.9 Histoire de la musique', '0.9 Histoire de la musique');
7797
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Espace consultation', 'Espace consultation');
7793
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (35, 'pcdm', '1- Musiques d''influence afro-américaine', '1- Musiques d''influence afro-américaine');
7798
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Fiction adultes', 'Fiction adultes');
7794
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (36, 'pcdm', '1.1 Blues', '1.1 Blues');
7799
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Doc adultes', 'Doc adultes');
7795
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (37, 'pcdm', '1.2 Negro spirituals, Gospel', '1.2 Negro spirituals, Gospel');
7800
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Fiction jeunesse', 'Fiction jeunesse');
7796
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (38, 'pcdm', '1.3 Jazz', '1.3 Jazz');
7801
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('local', 'Doc jeunesse', 'Doc jeunesse');
7797
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (39, 'pcdm', '1.4 Soul music, Rhythm''n''Blues, R''n''B', '1.4 Soul music, Rhythm''n''Blues, R''n''B');
7802
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort2', 'Crèche', 'Crèche');
7798
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (40, 'pcdm', '1.5 Rap', '1.5 Rap');
7803
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort2', 'École', 'École');
7799
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (41, 'pcdm', '1.6 Reggae', '1.6 Reggae');
7804
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort2', 'CLSH', 'CLSH');
7800
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (42, 'pcdm', '2- Rock et variété internationale apparentée', '2- Rock et variété internationale apparentée');
7805
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort2', 'PMI', 'PMI');
7801
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (43, 'pcdm', '2.1 Rock''n''roll, rockabilly', '2.1 Rock''n''roll, rockabilly');
7806
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('Bsort2', 'Prison', 'Prison');
7802
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (44, 'pcdm', '2.2 Pop', '2.2 Pop');
7807
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '0- Généralités, sciences et techniques musicales', '0- Généralités, sciences et techniques musicales');
7803
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (45, 'pcdm', '2.3 Folk rock, country rock, blues rock', '2.3 Folk rock, country rock, blues rock');
7808
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '0.1 Philosophie, esthétique, critique, sociologie, pratiques', '0.1 Philosophie, esthétique, critique, sociologie, pratiques');
7804
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (46, 'pcdm', '2.4 Rock psychédélique, progressif, symphonique', '2.4 Rock psychédélique, progressif, symphonique');
7809
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '0.2 Institutions musicales', '0.2 Institutions musicales');
7805
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (47, 'pcdm', '2.5 Hard rock, metal', '2.5 Hard rock, metal');
7810
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '0.3 Dictionnaires', '0.3 Dictionnaires');
7806
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (48, 'pcdm', '2.6 Punk et apparentés', '2.6 Punk et apparentés');
7811
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '0.4 Répertoires, catalogues', '0.4 Répertoires, catalogues');
7807
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (49, 'pcdm', '2.7 New wave, cold wave, rock indus, techno pop', '2.7 New wave, cold wave, rock indus, techno pop');
7812
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '0.5 Apprentissage et enseignement', '0.5 Apprentissage et enseignement');
7808
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (50, 'pcdm', '2.8 Fusion de styles, rock d''influences...', '2.8 Fusion de styles, rock d''influences...');
7813
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '0.6 Techniques musicales et vocales', '0.6 Techniques musicales et vocales');
7809
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (51, 'pcdm', '2.9 Rock et variétés rock', '2.9 Rock et variétés rock');
7814
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '0.7 Sciences et techniques en lien', '0.7 Sciences et techniques en lien');
7810
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (52, 'pcdm', '3- Musique classique', '3- Musique classique');
7815
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '0.9 Histoire de la musique', '0.9 Histoire de la musique');
7811
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (53, 'pcdm', '3.1 Musique de chambre, concertante', '3.1 Musique de chambre, concertante');
7816
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '1- Musiques d''influence afro-américaine', '1- Musiques d''influence afro-américaine');
7812
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (54, 'pcdm', '3.2 Musique orchestrale', '3.2 Musique orchestrale');
7817
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '1.1 Blues', '1.1 Blues');
7813
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (55, 'pcdm', '3.3 Musique vocale profane', '3.3 Musique vocale profane');
7818
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '1.2 Negro spirituals, Gospel', '1.2 Negro spirituals, Gospel');
7814
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (56, 'pcdm', '3.4 Musique vocale sacrée', '3.4 Musique vocale sacrée');
7819
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '1.3 Jazz', '1.3 Jazz');
7815
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (57, 'pcdm', '3.5 Musiques utilisant l''électronique', '3.5 Musiques utilisant l''électronique');
7820
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '1.4 Soul music, Rhythm''n''Blues, R''n''B', '1.4 Soul music, Rhythm''n''Blues, R''n''B');
7816
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (58, 'pcdm', '4- Musiques électroniques', '4- Musiques électroniques');
7821
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '1.5 Rap', '1.5 Rap');
7817
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (59, 'pcdm', '4.1 Précurseurs, pionniers', '4.1 Précurseurs, pionniers');
7822
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '1.6 Reggae', '1.6 Reggae');
7818
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (60, 'pcdm', '4.2 Ambient, downtempo', '4.2 Ambient, downtempo');
7823
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '2- Rock et variété internationale apparentée', '2- Rock et variété internationale apparentée');
7819
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (61, 'pcdm', '4.3 House', '4.3 House');
7824
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '2.1 Rock''n''roll, rockabilly', '2.1 Rock''n''roll, rockabilly');
7820
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (62, 'pcdm', '4.4 Techno', '4.4 Techno');
7825
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '2.2 Pop', '2.2 Pop');
7821
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (63, 'pcdm', '4.5 Fusion de styles, électro d''influences', '4.5 Fusion de styles, électro d''influences');
7826
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '2.3 Folk rock, country rock, blues rock', '2.3 Folk rock, country rock, blues rock');
7822
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (64, 'pcdm', '4.6 Elecronica', '4.6 Elecronica');
7827
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '2.4 Rock psychédélique, progressif, symphonique', '2.4 Rock psychédélique, progressif, symphonique');
7823
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (65, 'pcdm', '4.7 Jungle drum''n''bass', '4.7 Jungle drum''n''bass');
7828
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '2.5 Hard rock, metal', '2.5 Hard rock, metal');
7824
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (66, 'pcdm', '4.8 Dance', '4.8 Dance');
7829
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '2.6 Punk et apparentés', '2.6 Punk et apparentés');
7825
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (67, 'pcdm', '5- Musiques fonctionnelles', '5- Musiques fonctionnelles');
7830
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '2.7 New wave, cold wave, rock indus, techno pop', '2.7 New wave, cold wave, rock indus, techno pop');
7826
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (68, 'pcdm', '5.1 Musique et les autres arts', '5.1 Musique et les autres arts');
7831
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '2.8 Fusion de styles, rock d''influences...', '2.8 Fusion de styles, rock d''influences...');
7827
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (69, 'pcdm', '5.2 Musiques liées à l''audiovisuel', '5.2 Musiques liées à l''audiovisuel');
7832
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '2.9 Rock et variétés rock', '2.9 Rock et variétés rock');
7828
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (70, 'pcdm', '5.3 Musiques de circonstances, musique et histoire', '5.3 Musiques de circonstances, musique et histoire');
7833
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '3- Musique classique', '3- Musique classique');
7829
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (71, 'pcdm', '5.4 Musique de détente et d''activités physiques', '5.4 Musique de détente et d''activités physiques');
7834
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '3.1 Musique de chambre, concertante', '3.1 Musique de chambre, concertante');
7830
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (72, 'pcdm', '5.5 Variétés instrumentales et vocales', '5.5 Variétés instrumentales et vocales');
7835
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '3.2 Musique orchestrale', '3.2 Musique orchestrale');
7831
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (73, 'pcdm', '5.6 Musiques de danses populaires et festives', '5.6 Musiques de danses populaires et festives');
7836
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '3.3 Musique vocale profane', '3.3 Musique vocale profane');
7832
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (74, 'pcdm', '5.7 Musique de plein air et musique de sociétés musicales', '5.7 Musique de plein air et musique de sociétés musicales');
7837
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '3.4 Musique vocale sacrée', '3.4 Musique vocale sacrée');
7833
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (75, 'pcdm', '5.8 Instruments particuliers, musiques mécaniques', '5.8 Instruments particuliers, musiques mécaniques');
7838
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '3.5 Musiques utilisant l''électronique', '3.5 Musiques utilisant l''électronique');
7834
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (76, 'pcdm', '5.9 Sons divers', '5.9 Sons divers');
7839
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '4- Musiques électroniques', '4- Musiques électroniques');
7835
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (77, 'pcdm', '6- Musique et cinéma', '6- Musique et cinéma');
7840
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '4.1 Précurseurs, pionniers', '4.1 Précurseurs, pionniers');
7836
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (78, 'pcdm', '6.1 Musique concernant une oeuvre filmique', '6.1 Musique concernant une oeuvre filmique');
7841
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '4.2 Ambient, downtempo', '4.2 Ambient, downtempo');
7837
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (79, 'pcdm', '6.2 Compilations', '6.2 Compilations');
7842
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '4.3 House', '4.3 House');
7838
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (80, 'pcdm', '6.2 Compilations', '6.2 Compilations');
7843
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '4.4 Techno', '4.4 Techno');
7839
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (81, 'pcdm', '8.0 Anthologies générales', '8.0 Anthologies générales');
7844
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '4.5 Fusion de styles, électro d''influences', '4.5 Fusion de styles, électro d''influences');
7840
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (82, 'pcdm', '8.2 Chansons sociales', '8.2 Chansons sociales');
7845
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '4.6 Elecronica', '4.6 Elecronica');
7841
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (83, 'pcdm', '8.3 Chansons humoristiques', '8.3 Chansons humoristiques');
7846
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '4.7 Jungle drum''n''bass', '4.7 Jungle drum''n''bass');
7842
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (84, 'pcdm', '8.4 Chansons à texte', '8.4 Chansons à texte');
7847
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '4.8 Dance', '4.8 Dance');
7843
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (85, 'pcdm', '8.5 chansons de variétés', '8.5 chansons de variétés');
7848
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '5- Musiques fonctionnelles', '5- Musiques fonctionnelles');
7844
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (86, 'pcdm', '8.6 chansons en lien avec d''autres genres', '8.6 chansons en lien avec d''autres genres');
7849
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '5.1 Musique et les autres arts', '5.1 Musique et les autres arts');
7845
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (87, 'pcdm', '9- Musiques du monde', '9- Musiques du monde');
7850
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '5.2 Musiques liées à l''audiovisuel', '5.2 Musiques liées à l''audiovisuel');
7846
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (88, 'pcdm', '9.0 Anthologies générales', '9.0 Anthologies générales');
7851
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '5.3 Musiques de circonstances, musique et histoire', '5.3 Musiques de circonstances, musique et histoire');
7847
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (89, 'pcdm', '9.1 Afrique', '9.1 Afrique');
7852
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '5.4 Musique de détente et d''activités physiques', '5.4 Musique de détente et d''activités physiques');
7848
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (90, 'pcdm', '9.2 Maghreb, proche et moyen orient', '9.2 Maghreb, proche et moyen orient');
7853
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '5.5 Variétés instrumentales et vocales', '5.5 Variétés instrumentales et vocales');
7849
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (91, 'pcdm', '9.3 Asie', '9.3 Asie');
7854
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '5.6 Musiques de danses populaires et festives', '5.6 Musiques de danses populaires et festives');
7850
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (92, 'pcdm', '9.4 Extrême orient', '9.4 Extrême orient');
7855
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '5.7 Musique de plein air et musique de sociétés musicales', '5.7 Musique de plein air et musique de sociétés musicales');
7851
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (93, 'pcdm', '9.5 Europe de l''est et méridionale', '9.5 Europe de l''est et méridionale');
7856
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '5.8 Instruments particuliers, musiques mécaniques', '5.8 Instruments particuliers, musiques mécaniques');
7852
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (94, 'pcdm', '9.6 France', '9.6 France');
7857
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '5.9 Sons divers', '5.9 Sons divers');
7853
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (95, 'pcdm', '9.7 Europe, Ouest et Nord', '9.7 Europe, Ouest et Nord');
7858
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '6- Musique et cinéma', '6- Musique et cinéma');
7854
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (96, 'pcdm', '9.8 Amérique du Nord', '9.8 Amérique du Nord');
7859
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '6.1 Musique concernant une oeuvre filmique', '6.1 Musique concernant une oeuvre filmique');
7855
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (97, 'pcdm', '9.9 Amérique latine', '9.9 Amérique latine');
7860
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '6.2 Compilations', '6.2 Compilations');
7856
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (98, 'public', 'a', '  Adulte');
7861
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '6.2 Compilations', '6.2 Compilations');
7857
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (99, 'public', 'j', 'Jeune');
7862
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '8.0 Anthologies générales', '8.0 Anthologies générales');
7858
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (100, 'public', 'u', ' Indéterminé');
7863
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '8.2 Chansons sociales', '8.2 Chansons sociales');
7859
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (101, 'public', 'z', 'Autre');
7864
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '8.3 Chansons humoristiques', '8.3 Chansons humoristiques');
7860
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (107, 'local', 'Espace enfant', 'Espace enfant');
7865
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '8.4 Chansons à texte', '8.4 Chansons à texte');
7861
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (108, 'statut', '2', 'Consultation sur RdV');
7866
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '8.5 Chansons de variétés', '8.5 chansons de variétés');
7862
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (109, 'statut', '1', ' Exclu du prêt');
7867
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '8.6 Chansons en lien avec d''autres genres', '8.6 chansons en lien avec d''autres genres');
7863
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (110, 'statut', '3', 'En réparation');
7868
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '9- Musiques du monde', '9- Musiques du monde');
7864
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (111, 'statut', '4', 'En reliure');
7869
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '9.0 Anthologies générales', '9.0 Anthologies générales');
7865
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (113, 'statut', '6', 'Rachat en cours');
7870
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '9.1 Afrique', '9.1 Afrique');
7866
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (114, 'local', 'Périodiques', 'Périodiques');
7871
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '9.2 Maghreb, proche et moyen orient', '9.2 Maghreb, proche et moyen orient');
7867
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (118, 'local', 'Espace petite enfance', 'Espace petite enfance');
7872
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '9.3 Asie', '9.3 Asie');
7868
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (119, 'local', 'Magasin/réserve', 'Magasin/réserve');
7873
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '9.4 Extrême orient', '9.4 Extrême orient');
7869
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (120, 'local', 'Espace audiovisuel', 'Espace audiovisuel');
7874
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '9.5 Europe de l''est et méridionale', '9.5 Europe de l''est et méridionale');
7870
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (121, 'local', 'Espace multimédia', 'Espace multimédia');
7875
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '9.6 France', '9.6 France');
7871
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (122, 'local', 'Espace consultation', 'Espace consultation');
7876
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '9.7 Europe, Ouest et Nord', '9.7 Europe, Ouest et Nord');
7872
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (123, 'local', 'Fiction adultes', 'Fiction adultes');
7877
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '9.8 Amérique du Nord', '9.8 Amérique du Nord');
7873
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (124, 'local', 'Doc adultes', 'Doc adultes');
7878
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '9.9 Amérique latine', '9.9 Amérique latine');
7874
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (125, 'local', 'Fiction jeunesse', 'Fiction jeunesse');
7879
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES ('pcdm', '8.1 Chansons pour enfants', '8.1 Chansons pour enfants');
7875
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (126, 'local', 'Doc jeunesse', 'Doc jeunesse');
7876
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (127, 'langue', 'spa', 'Espagnol');
7877
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (128, 'langue', 'ita', 'Italien');
7878
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (130, 'Bsort2', 'Crèche', 'Crèche');
7879
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (131, 'Bsort2', 'Ecole', 'Ecole');
7880
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (132, 'Bsort2', 'CLSH', 'CLSH');
7881
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (133, 'Bsort2', 'PMI', 'PMI');
7882
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (134, 'Bsort2', 'Prison', 'Prison');
7883
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (135, 'langue', 'chi', 'Chinois');
7884
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (136, 'langue', 'jap', 'Japonais');
7885
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (137, 'local', 'Espace document adapté', 'Espace document adapté');
7886
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (138, 'local', 'Espace local', 'Espace local');
7887
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (139, 'local', 'Espace théâtre/poésie', 'Espace théâtre/poésie');
7888
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (140, 'langue', 'dan', 'Danois');
7889
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (141, 'langue', 'por', 'Portugais');
7890
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (142, 'langue', 'pro', 'Provençal');
7891
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (143, 'pcdm', '8.1 Chansons pour enfants', '8.1 Chansons pour enfants');
7892
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (144, 'SUGGEST', 'Pas assez de budget', 'Pas assez de budget');
7893
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (145, 'SUGGEST', 'Document trop onéreux', 'Document trop onéreux');
7894
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (146, 'SUGGEST', 'Document ne correspondant pas à notre politique d''acquisition', 'Document ne correspondant pas à notre politique d''acquisition');
7895
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (147, 'COUNTRY', 'FR', 'France');
7896
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (148, 'COUNTRY', 'EN', 'Grande Bretagne');
7897
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (149, 'COUNTRY', 'DE', 'Allemagne');
7898
7880
7899
UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
7881
UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
7900
UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';
7882
UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';
(-)a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.txt (-2 / +2 lines)
Lines 1-2 Link Here
1
Grilles de catalogage UNIMARC.
1
Grilles de catalogage UNIMARC.
2
Ces grilles sont plutôt destinées à une utilisation de type "bibliothèque de lecture publique". Elles sont simplifiées.
2
Ces grilles sont plutôt destinées à une utilisation de type "bibliothèque de lecture publique". Elles sont simplifiées.
3
Les valeurs autorisées suivantes sont chargées : genres, public, CSP, institutions, codes PCDM, exemples de localisation
3
- 

Return to bug 10138