[Koha-patches] Bug 10138: Add some authorized values in french installer ; small fixes in frameworks
Mathieu Saby
mathieu.saby at univ-rennes2.fr
Sun Apr 28 19:42:57 CEST 2013
This patch adds some categories of values in french installer :
- SUGGEST
- OPAC_SUG
- REPORT_GROUP
- LOST
- DAMAGED
SUGGEST and OPAC_SUG are used by Suggestions module.
REPORT_GROUP is used by Reports module.
It also adds a new status for "ETAT" (en commande)
It creates a 995$2 subfield in french frameworks when it did not exist.
It links existing 995$2 subfield with LOST category.
It cleans up the list of authorised values installed with "Lecture
publique" framework :
- some codes are moved in general 1-Obligatoire/authorised_values.sql
(SUGGEST, REPORT_GROUP)
- some are suppressed, because they are also defined in
1-Obligatoire/authorised_values.sql (langue, COUNTRY, statut)
- the code for interting the left ones is changed (I suppress the `id`
column)
To test :
1. Take a fresh new Koha
2. Install Koha choosing French installer and UNIMARC Lecture publique
3. Check the authorised values are imported
4. Check the cataloguing frameworks are usable :
especially 995 $2 field, which must be mapped with LOST values : Perdu,
Long retard, Perdu et remboursé, Introuvable
you can also check 101$a (language codes), 102$a (country codes)
5. In OPAC, make a suggestion. See if you can select a cause for your
suggestion ("Bestseller" or "'L'exemplaire en rayon est endommagé")
6. In staff interface, manage some suggestions. See if you can select a
cause for rejection or acceptation ("Bestseller", "Budget insuffisant" etc)
7. In reports, see if you can sort reports according to values of
REPORT_GROUP ("Circulation", "Catalogue", "Adhérents" etc)
---
.../fr-FR/1-Obligatoire/authorised_values.sql | 33 ++-
.../fr-FR/1-Obligatoire/authorised_values.txt | 4 +-
.../Obligatoire/framework_DEFAULT.sql | 3 +-
.../Optionnel/cataloguage_rapide.sql | 2 +-
.../Obligatoire/framework_DEFAULT.sql | 262 +++++++++-----------
.../Obligatoire/framework_DEFAULT.txt | 3 +-
6 files changed, 162 insertions(+), 145 deletions(-)
diff --git
a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql
b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql
index 91bd629..37c7470 100644
--- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql
@@ -1,9 +1,36 @@
+-- Reasons for acceptance or rejection of suggestions in acquisitions
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('SUGGEST','Bestseller','Bestseller');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('SUGGEST','Endommagé','L''exemplaire de la bibliothèque
endommagé');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('SUGGEST','Perdu','L''exemplaire de la bibliothèque est
perdu');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('SUGGEST','PEB','Document disponible via le Prêt Entre
Bibliothèques');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('SUGGEST','Budget','Budget insuffisant');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('SUGGEST','Onéreux','Document trop onéreux');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('SUGGEST','Poldoc','Document ne correspondant pas à notre
politique d''acquisition');
+-- OPAC Suggestions reasons
+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é');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('OPAC_SUG','bestseller','Bestseller','Bestseller');
+-- Report groups
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('REPORT_GROUP', 'CIRC', 'Circulation');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('REPORT_GROUP', 'CAT', 'Catalogue');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('REPORT_GROUP', 'PAT', 'Adhérents');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('REPORT_GROUP', 'ACQ', 'Acquisitions');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('REPORT_GROUP', 'ACC', 'Comptes');
+-- availability statuses
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('LOST','1','Perdu');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('LOST','2','Long retard (perdu)');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('LOST','3','Perdu et remboursé');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('LOST','4','Introuvable');
+-- damaged status of an item
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ('DAMAGED','1','Endommagdé');
+-- Status codes
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'ETAT', '0', 'Empruntable');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'ETAT', '1', 'Exclu du prêt');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'ETAT', '3', 'En reliure');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'ETAT', '4', 'Indisponible');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'ETAT', '5', 'En traitement');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'ETAT', '6', 'Non communicable');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ( 'ETAT', '7', 'En commande');
+-- location qualification for an item, departments are linked by
default to items.location
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'LOC', 'Magasin', ' Magasin');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'LOC', 'Salle de lecture', 'Salle de lecture');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'LOC', 'Magasin des périodiques', 'Magasin des périodiques');
@@ -11,8 +38,10 @@ INSERT INTO `authorised_values` ( `category`,
`authorised_value`, `lib`) VALUES
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'LOC', 'Manquant', 'Manquant');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'LOC', 'Secrétariat', 'Secrétariat');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'LOC', 'En reliure', 'En reliure');
+-- Type of authorities
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'CAND', 'Candidat descripteur', 'Candidat descripteur');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'CAND', 'Rejeté', 'Mot clé abandonné');
+-- Country codes
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'COUNTRY', 'AN', 'Antilles Néerlandaises');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'COUNTRY', 'CR', 'Costa Rica');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'COUNTRY', 'ER', 'Allemagne');
@@ -265,6 +294,7 @@ INSERT INTO `authorised_values` ( `category`,
`authorised_value`, `lib`) VALUES
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'COUNTRY', 'ZM', 'Zambie');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'COUNTRY', 'ZW', 'Zimbabwe');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'COUNTRY', 'ZZ', 'multiple');
+-- Language codes (ISO 639-2)
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'LANG', 'aar','afar');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'LANG', 'abk','abkhaze');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'LANG', 'ace','achinese');
@@ -521,6 +551,7 @@ INSERT INTO `authorised_values` ( `category`,
`authorised_value`, `lib`) VALUES
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'LANG', 'lan','occitan (post 1500)');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'LANG', 'mla','malgache');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'LANG', 'sam','samaritain');
+-- UNIMARC function codes
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'qualif', '000', 'Fonction indéterminée');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'qualif', '005', 'Acteur');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'qualif', '010', 'Adaptateur');
@@ -655,4 +686,4 @@ INSERT INTO `authorised_values` ( `category`,
`authorised_value`, `lib`) VALUES
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'qualif', '571', 'Coordinateur');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'qualif', '573', 'Diffuseur');
INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`)
VALUES ( 'qualif', '574', 'Présentateur');
-INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ( 'qualif', '575', 'Responsable');
\ No newline at end of file
+INSERT INTO `authorised_values` ( `category`, `authorised_value`,
`lib`) VALUES ( 'qualif', '575', 'Responsable');
diff --git
a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.txt
b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.txt
index 8f49e0e..dec34d3 100644
--- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.txt
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.txt
@@ -1 +1,3 @@
-Des listes de valeurs autorisées bien utiles pour la constitution des
grilles de catalogage.
+Des listes de valeurs autorisées utiles pour la constitution des
grilles de catalogage (codes de pays, codes de langues, codes de
fonction UNIMARC),
+pour la gestion des exemplaires (statut, perte ou disparition),
+et pour le fonctionnement de Koha (tri des rapports, motifs des
suggestions)
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 a143758..1b78e27 100644
---
a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql
+++
b/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql
@@ -2013,7 +2013,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`,
`tagsubfield`, `liblibrarian`
('992', '2', 'code du système d''indexation', '', 0, 1, NULL, -1, NULL,
NULL, '', NULL, NULL, '', NULL, NULL, ''),
('992', '5', 'identifiant de l''exemplaire', '', 0, 1, NULL, -1, NULL,
NULL, '', NULL, NULL, '', NULL, NULL, ''),
('992', 'a', 'classification locale - indice', '', 0, 1, NULL, -1, NULL,
NULL, '', NULL, NULL, '', NULL, NULL, ''),
-('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, '', '', '', NULL,
1, '', NULL, NULL, ''),
+('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '',
NULL, 1, '', NULL, NULL, ''),
('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '',
'', '', NULL, 0, '', NULL, NULL, ''),
('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '',
'', '', NULL, 0, '', NULL, NULL, ''),
('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10,
'branches', '', '', NULL, 0, '', NULL, NULL, ''),
@@ -2036,4 +2036,5 @@ INSERT INTO `marc_subfield_structure` (`tagfield`,
`tagsubfield`, `liblibrarian`
('995', 'u', 'note', '', 0, 0, 'items.itemnotes', 10, '', '', '', NULL,
0, '', NULL, NULL, '');
UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
+
UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';
diff --git
a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Optionnel/cataloguage_rapide.sql
b/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Optionnel/cataloguage_rapide.sql
index d787c74..90a091b 100644
---
a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Optionnel/cataloguage_rapide.sql
+++
b/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Optionnel/cataloguage_rapide.sql
@@ -68,7 +68,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`,
`tagsubfield`, `liblibrarian`
('225', 'v', 'numérotation du volume', '', 1, 0,
'biblioitems.collectionvolume', 2, '', '', '', 0, 0, 'FA', NULL, '', ''),
('225', 'x', 'ISSN de la collection', '', 1, 0,
'biblioitems.collectionissn', 2, '', '', '', 0, 0, 'FA', NULL, '', ''),
('225', 'z', 'langue du titre parallèle', '', 1, 0, '', 2, '', '', '',
0, 0, 'FA', NULL, '', ''),
-('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, '', '', '', NULL,
1, 'FA', NULL, NULL, ''),
+('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '',
NULL, 1, 'FA', NULL, NULL, ''),
('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '',
'', '', NULL, 0, 'FA', NULL, NULL, ''),
('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '',
'', '', NULL, 0, 'FA', NULL, NULL, ''),
('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10,
'branches', '', '', NULL, 0, 'FA', NULL, NULL, ''),
diff --git
a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql
b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql
index bd27055..befaece 100644
---
a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql
+++
b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql
@@ -2359,6 +2359,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
('992', '2', 'code du système d''indexation', '', 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
('992', '5', 'identifiant de l''exemplaire', '', 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
('992', 'a', 'classification locale - indice', '', 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
('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '',
NULL, 1, '', 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
('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '',
'', '', 0, 0, '', '', '', NULL);
INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`,
`liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`,
`tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`,
`hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES
('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '',
'', '', 0, 0, '', '', '', NULL);
INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`,
`liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`,
`tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`,
`hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES
('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10,
'branches', '', '', 0, 0, '', '', '', NULL);
@@ -3701,6 +3702,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
('992', '2', 'code du système d''indexation', '', 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
('992', '5', 'identifiant de l''exemplaire', '', 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
('992', 'a', 'classification locale - indice', '', 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
('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '',
NULL, 1, 'ARTI', '', NULL, 0);
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);
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);
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);
@@ -5044,6 +5046,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
('992', '2', 'code du système d''indexation', '', 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
('992', '5', 'identifiant de l''exemplaire', '', 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
('992', 'a', 'classification locale - indice', '', 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
('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '',
NULL, 1, 'MULT', 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
('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '',
'', '', 0, 0, 'MULT', 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
('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '',
'', '', 0, 0, 'MULT', 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
('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10,
'branches', '', '', 0, 0, 'MULT', NULL, '', NULL);
@@ -6386,6 +6389,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
('992', '2', 'code du système d''indexation', '', 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
('992', '5', 'identifiant de l''exemplaire', '', 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
('992', 'a', 'classification locale - indice', '', 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
('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '',
NULL, 1, 'PERI', 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
('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '',
'', '', 0, 0, 'PERI', 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
('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '',
'', '', 0, 0, 'PERI', 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
('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', 10,
'branches', '', '', 0, 0, 'PERI', NULL, '', NULL);
@@ -7728,6 +7732,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
('992', '2', 'code du système d''indexation', '', 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
('992', '5', 'identifiant de l''exemplaire', '', 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
('992', 'a', 'classification locale - indice', '', 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
('995', '2', 'Perdu', '', 0, 0, 'items.itemlost', 10, 'LOST', '', '',
NULL, 1, 'WEB', 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
('995', '9', 'itemnumber (koha)', '', 0, 0, 'items.itemnumber', -1, '',
'', '', NULL, 0, 'WEB', '', 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
('995', 'a', 'origine du document, texte libre', '', 0, 1, '', -1, '',
'', '', NULL, 0, 'WEB', '', 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
('995', 'b', 'Propriétaire', '', 0, 1, 'items.homebranch', -1,
'branches', '', '', NULL, 0, 'WEB', '', NULL, NULL);
@@ -7743,7 +7748,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
('995', 'l', 'volumaison', '', 0, 1, '', -1, '', '', '', NULL, 0, 'WEB',
'', 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
('995', 'm', 'Date prêt', '', 0, 0, 'items.datelastseen', -1, '', '',
'', NULL, 0, 'WEB', '', 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
('995', 'n', 'date de restitution prévue', 'à rendre pour le', 0, 0,
'items.onloan', 10, '', '', '', NULL, 0, 'WEB', '', 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
('995', 'o', 'Statut', '', 0, 1, 'items.notforloan', -1, 'statut', '',
'', NULL, 0, 'WEB', '', 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
('995', 'o', 'Statut', '', 0, 1, 'items.notforloan', -1, 'ETAT', '', '',
NULL, 0, 'WEB', '', 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
('995', 'q', 'Public', '', 0, 0, '', -1, 'public', '', '', NULL, 0,
'WEB', '', 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
('995', 'r', 'type de document et support matériel', '', 0, 1, '', -1,
'', '', '', NULL, 0, 'WEB', '', 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
('995', 's', 'élément de tri', '', 0, 1, 'items.itemlost', -1, '', '',
'', NULL, 0, 'WEB', '', NULL, NULL);
@@ -7756,145 +7761,122 @@ INSERT INTO `marc_subfield_structure`
(`tagfield`, `tagsubfield`, `liblibrarian`
--
-- Valeurs autorisées nécessaires pour la cohérence des grilles.
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (1, 'genre', 'Biographie', 'Biographie');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (2, 'genre', 'Nouvelle', 'Nouvelle');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (3, 'genre', 'Policier', 'Policier');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (4, 'genre', 'Poésie', 'Poésie');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (5, 'genre', 'Théâtre', 'Théâtre');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (6, 'genre', 'Conte', 'Conte');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (7, 'genre', 'Science fiction', 'Science fiction');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (8, 'genre', 'Roman', 'Roman');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (9, 'Bsort1', '01', 'Agriculteurs, exploitant');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (10, 'Bsort1', '02', 'Artisants, commerçants, chefs
d''entreprise');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (11, 'Bsort1', '03', 'Cadres, professions intellectuelles
Supérieures');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (12, 'Bsort1', '04', 'Professions intermédiaires');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (13, 'Bsort1', '05', 'Employés');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (14, 'Bsort1', '06', 'Ouvriers');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (15, 'Bsort1', '07', 'Retraités');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (16, 'Bsort1', '08', 'Demandeurs d''emploi');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (17, 'Bsort1', '09', 'Sans emploi');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (18, 'Bsort1', '10', 'Etudiants');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (19, 'Bsort1', '11', ' CSP non déclarée');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (20, 'Bsort1', '12', 'Elèves ou enfants non scolarisés');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (21, 'statut', '0', ' Disponible');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (22, 'langue', 'fre', ' Français');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (23, 'langue', 'eng', 'Anglais');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (24, 'langue', 'ger', 'Allemand');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (25, 'langue', 'dut', 'Hollandais');
-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');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (28, 'pcdm', '0.2 Institutions musicales', '0.2
Institutions musicales');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (29, 'pcdm', '0.3 Dictionnaires', '0.3 Dictionnaires');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (30, 'pcdm', '0.4 Répertoires, catalogues', '0.4
Répertoires, catalogues');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (31, 'pcdm', '0.5 Apprentissage et enseignement', '0.5
Apprentissage et enseignement');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (32, 'pcdm', '0.6 Techniques musicales et vocales', '0.6
Techniques musicales et vocales');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (34, 'pcdm', '0.9 Histoire de la musique', '0.9 Histoire
de la musique');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (36, 'pcdm', '1.1 Blues', '1.1 Blues');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (37, 'pcdm', '1.2 Negro spirituals, Gospel', '1.2 Negro
spirituals, Gospel');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (38, 'pcdm', '1.3 Jazz', '1.3 Jazz');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (40, 'pcdm', '1.5 Rap', '1.5 Rap');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (41, 'pcdm', '1.6 Reggae', '1.6 Reggae');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (43, 'pcdm', '2.1 Rock''n''roll, rockabilly', '2.1
Rock''n''roll, rockabilly');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (44, 'pcdm', '2.2 Pop', '2.2 Pop');
-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');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (47, 'pcdm', '2.5 Hard rock, metal', '2.5 Hard rock, metal');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (48, 'pcdm', '2.6 Punk et apparentés', '2.6 Punk et
apparentés');
-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');
-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...');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (52, 'pcdm', '3- Musique classique', '3- Musique classique');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (53, 'pcdm', '3.1 Musique de chambre, concertante', '3.1
Musique de chambre, concertante');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (54, 'pcdm', '3.2 Musique orchestrale', '3.2 Musique
orchestrale');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (55, 'pcdm', '3.3 Musique vocale profane', '3.3 Musique
vocale profane');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (56, 'pcdm', '3.4 Musique vocale sacrée', '3.4 Musique
vocale sacrée');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (57, 'pcdm', '3.5 Musiques utilisant l''électronique',
'3.5 Musiques utilisant l''électronique');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (58, 'pcdm', '4- Musiques électroniques', '4- Musiques
électroniques');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (59, 'pcdm', '4.1 Précurseurs, pionniers', '4.1
Précurseurs, pionniers');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (60, 'pcdm', '4.2 Ambient, downtempo', '4.2 Ambient,
downtempo');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (61, 'pcdm', '4.3 House', '4.3 House');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (62, 'pcdm', '4.4 Techno', '4.4 Techno');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (64, 'pcdm', '4.6 Elecronica', '4.6 Elecronica');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (65, 'pcdm', '4.7 Jungle drum''n''bass', '4.7 Jungle
drum''n''bass');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (66, 'pcdm', '4.8 Dance', '4.8 Dance');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (67, 'pcdm', '5- Musiques fonctionnelles', '5- Musiques
fonctionnelles');
-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');
-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');
-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');
-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');
-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');
-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');
-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');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (76, 'pcdm', '5.9 Sons divers', '5.9 Sons divers');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (77, 'pcdm', '6- Musique et cinéma', '6- Musique et
cinéma');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (79, 'pcdm', '6.2 Compilations', '6.2 Compilations');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (80, 'pcdm', '6.2 Compilations', '6.2 Compilations');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (81, 'pcdm', '8.0 Anthologies générales', '8.0
Anthologies générales');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (82, 'pcdm', '8.2 Chansons sociales', '8.2 Chansons
sociales');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (83, 'pcdm', '8.3 Chansons humoristiques', '8.3 Chansons
humoristiques');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (84, 'pcdm', '8.4 Chansons à texte', '8.4 Chansons à texte');
-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');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (87, 'pcdm', '9- Musiques du monde', '9- Musiques du monde');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (88, 'pcdm', '9.0 Anthologies générales', '9.0
Anthologies générales');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (89, 'pcdm', '9.1 Afrique', '9.1 Afrique');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (91, 'pcdm', '9.3 Asie', '9.3 Asie');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (92, 'pcdm', '9.4 Extrême orient', '9.4 Extrême orient');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (94, 'pcdm', '9.6 France', '9.6 France');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (95, 'pcdm', '9.7 Europe, Ouest et Nord', '9.7 Europe,
Ouest et Nord');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (96, 'pcdm', '9.8 Amérique du Nord', '9.8 Amérique du
Nord');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (97, 'pcdm', '9.9 Amérique latine', '9.9 Amérique latine');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (98, 'public', 'a', ' Adulte');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (99, 'public', 'j', 'Jeune');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (100, 'public', 'u', ' Indéterminé');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (101, 'public', 'z', 'Autre');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (107, 'local', 'Espace enfant', 'Espace enfant');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (108, 'statut', '2', 'Consultation sur RdV');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (109, 'statut', '1', ' Exclu du prêt');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (110, 'statut', '3', 'En réparation');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (111, 'statut', '4', 'En reliure');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (113, 'statut', '6', 'Rachat en cours');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (114, 'local', 'Périodiques', 'Périodiques');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (118, 'local', 'Espace petite enfance', 'Espace petite
enfance');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (119, 'local', 'Magasin/réserve', 'Magasin/réserve');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (120, 'local', 'Espace audiovisuel', 'Espace audiovisuel');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (121, 'local', 'Espace multimédia', 'Espace multimédia');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (122, 'local', 'Espace consultation', 'Espace consultation');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (123, 'local', 'Fiction adultes', 'Fiction adultes');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (124, 'local', 'Doc adultes', 'Doc adultes');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (125, 'local', 'Fiction jeunesse', 'Fiction jeunesse');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (126, 'local', 'Doc jeunesse', 'Doc jeunesse');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (127, 'langue', 'spa', 'Espagnol');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (128, 'langue', 'ita', 'Italien');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (130, 'Bsort2', 'Crèche', 'Crèche');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (131, 'Bsort2', 'Ecole', 'Ecole');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (132, 'Bsort2', 'CLSH', 'CLSH');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (133, 'Bsort2', 'PMI', 'PMI');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (134, 'Bsort2', 'Prison', 'Prison');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (135, 'langue', 'chi', 'Chinois');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (136, 'langue', 'jap', 'Japonais');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (137, 'local', 'Espace document adapté', 'Espace document
adapté');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (138, 'local', 'Espace local', 'Espace local');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (139, 'local', 'Espace théâtre/poésie', 'Espace
théâtre/poésie');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (140, 'langue', 'dan', 'Danois');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (141, 'langue', 'por', 'Portugais');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (142, 'langue', 'pro', 'Provençal');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (143, 'pcdm', '8.1 Chansons pour enfants', '8.1 Chansons
pour enfants');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (144, 'SUGGEST', 'Pas assez de budget', 'Pas assez de
budget');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (145, 'SUGGEST', 'Document trop onéreux', 'Document trop
onéreux');
-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');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (147, 'COUNTRY', 'FR', 'France');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (148, 'COUNTRY', 'EN', 'Grande Bretagne');
-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`,
`lib`) VALUES (149, 'COUNTRY', 'DE', 'Allemagne');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('genre', 'Biographie', 'Biographie');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('genre', 'Nouvelle', 'Nouvelle');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('genre', 'Policier', 'Policier');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('genre', 'Poésie', 'Poésie');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('genre', 'Théâtre', 'Théâtre');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('genre', 'Conte', 'Conte');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('genre', 'Science fiction', 'Science fiction');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('genre', 'Roman', 'Roman');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort1', '01', 'Agriculteurs, exploitant');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort1', '02', 'Artisants, commerçants, chefs d''entreprise');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort1', '03', 'Cadres, professions intellectuelles Supérieures');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort1', '04', 'Professions intermédiaires');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort1', '05', 'Employés');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort1', '06', 'Ouvriers');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort1', '07', 'Retraités');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort1', '08', 'Demandeurs d''emploi');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort1', '09', 'Sans emploi');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort1', '10', 'Étudiants');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort1', '11', 'CSP non déclarée');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort1', '12', 'Élèves ou enfants non scolarisés');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('public', 'a', 'Adulte');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('public', 'j', 'Jeune');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('public', 'u', 'Indéterminé');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('public', 'z', 'Autre');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Espace document adapté', 'Espace document adapté');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Espace local', 'Espace local');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Espace théâtre/poésie', 'Espace théâtre/poésie');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Espace enfant', 'Espace enfant');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Périodiques', 'Périodiques');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Espace petite enfance', 'Espace petite enfance');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Magasin/réserve', 'Magasin/réserve');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Espace audiovisuel', 'Espace audiovisuel');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Espace multimédia', 'Espace multimédia');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Espace consultation', 'Espace consultation');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Fiction adultes', 'Fiction adultes');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Doc adultes', 'Doc adultes');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Fiction jeunesse', 'Fiction jeunesse');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('local', 'Doc jeunesse', 'Doc jeunesse');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort2', 'Crèche', 'Crèche');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort2', 'École', 'École');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort2', 'CLSH', 'CLSH');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort2', 'PMI', 'PMI');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('Bsort2', 'Prison', 'Prison');
+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');
+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');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '0.2 Institutions musicales', '0.2 Institutions musicales');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '0.3 Dictionnaires', '0.3 Dictionnaires');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '0.4 Répertoires, catalogues', '0.4 Répertoires,
catalogues');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '0.5 Apprentissage et enseignement', '0.5 Apprentissage
et enseignement');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '0.6 Techniques musicales et vocales', '0.6 Techniques
musicales et vocales');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '0.7 Sciences et techniques en lien', '0.7 Sciences et
techniques en lien');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '0.9 Histoire de la musique', '0.9 Histoire de la musique');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '1- Musiques d''influence afro-américaine', '1-
Musiques d''influence afro-américaine');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '1.1 Blues', '1.1 Blues');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '1.2 Negro spirituals, Gospel', '1.2 Negro spirituals,
Gospel');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '1.3 Jazz', '1.3 Jazz');
+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');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '1.5 Rap', '1.5 Rap');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '1.6 Reggae', '1.6 Reggae');
+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');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '2.1 Rock''n''roll, rockabilly', '2.1 Rock''n''roll,
rockabilly');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '2.2 Pop', '2.2 Pop');
+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');
+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');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '2.5 Hard rock, metal', '2.5 Hard rock, metal');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '2.6 Punk et apparentés', '2.6 Punk et apparentés');
+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');
+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...');
+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');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '3- Musique classique', '3- Musique classique');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '3.1 Musique de chambre, concertante', '3.1 Musique de
chambre, concertante');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '3.2 Musique orchestrale', '3.2 Musique orchestrale');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '3.3 Musique vocale profane', '3.3 Musique vocale profane');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '3.4 Musique vocale sacrée', '3.4 Musique vocale sacrée');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '3.5 Musiques utilisant l''électronique', '3.5 Musiques
utilisant l''électronique');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '4- Musiques électroniques', '4- Musiques électroniques');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '4.1 Précurseurs, pionniers', '4.1 Précurseurs,
pionniers');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '4.2 Ambient, downtempo', '4.2 Ambient, downtempo');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '4.3 House', '4.3 House');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '4.4 Techno', '4.4 Techno');
+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');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '4.6 Elecronica', '4.6 Elecronica');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '4.7 Jungle drum''n''bass', '4.7 Jungle drum''n''bass');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '4.8 Dance', '4.8 Dance');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '5- Musiques fonctionnelles', '5- Musiques fonctionnelles');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '5.1 Musique et les autres arts', '5.1 Musique et les
autres arts');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '5.2 Musiques liées à l''audiovisuel', '5.2 Musiques
liées à l''audiovisuel');
+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');
+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');
+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');
+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');
+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');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '5.8 Instruments particuliers, musiques mécaniques',
'5.8 Instruments particuliers, musiques mécaniques');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '5.9 Sons divers', '5.9 Sons divers');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '6- Musique et cinéma', '6- Musique et cinéma');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '6.1 Musique concernant une oeuvre filmique', '6.1
Musique concernant une oeuvre filmique');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '6.2 Compilations', '6.2 Compilations');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '6.2 Compilations', '6.2 Compilations');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '8.0 Anthologies générales', '8.0 Anthologies
générales');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '8.2 Chansons sociales', '8.2 Chansons sociales');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '8.3 Chansons humoristiques', '8.3 Chansons humoristiques');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '8.4 Chansons à texte', '8.4 Chansons à texte');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '8.5 Chansons de variétés', '8.5 chansons de variétés');
+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');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '9- Musiques du monde', '9- Musiques du monde');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '9.0 Anthologies générales', '9.0 Anthologies
générales');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '9.1 Afrique', '9.1 Afrique');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '9.2 Maghreb, proche et moyen orient', '9.2 Maghreb,
proche et moyen orient');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '9.3 Asie', '9.3 Asie');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '9.4 Extrême orient', '9.4 Extrême orient');
+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');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '9.6 France', '9.6 France');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '9.7 Europe, Ouest et Nord', '9.7 Europe, Ouest et Nord');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '9.8 Amérique du Nord', '9.8 Amérique du Nord');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '9.9 Amérique latine', '9.9 Amérique latine');
+INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`)
VALUES ('pcdm', '8.1 Chansons pour enfants', '8.1 Chansons pour enfants');
UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';
diff --git
a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.txt
b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.txt
index 4169c57..fc4ddd2 100644
---
a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.txt
+++
b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.txt
@@ -1,2 +1,3 @@
Grilles de catalogage UNIMARC.
-Ces grilles sont plutôt destinées à une utilisation de type
"bibliothèque de lecture publique". Elles sont simplifiées.
\ No newline at end of file
+Ces grilles sont plutôt destinées à une utilisation de type
"bibliothèque de lecture publique". Elles sont simplifiées.
+Les valeurs autorisées suivantes sont chargées : genres, public, CSP,
institutions, codes PCDM, exemples de localisation
--
1.7.9.5
--
Mathieu Saby
Service d'Informatique Documentaire
Service Commun de Documentation
Université Rennes 2
Téléphone : 02 99 14 12 65
Courriel : mathieu.saby at univ-rennes2.fr
More information about the Koha-patches
mailing list