Bugzilla – Attachment 23827 Details for
Bug 10138
Add some authorized values in french installer
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[PASSED QA] Bug 10138: Add some authorized values in french installer ; small fixes in frameworks
PASSED-QA-Bug-10138-Add-some-authorized-values-in-.patch (text/plain), 68.52 KB, created by
Katrin Fischer
on 2013-12-27 06:57:01 UTC
(
hide
)
Description:
[PASSED QA] Bug 10138: Add some authorized values in french installer ; small fixes in frameworks
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2013-12-27 06:57:01 UTC
Size:
68.52 KB
patch
obsolete
>From 541b965a6205b66135066c627d09dc7185775434 Mon Sep 17 00:00:00 2001 >From: Mathieu Saby <mathieu.saby@univ-rennes2.fr> >Date: Sun, 28 Apr 2013 19:06:11 +0200 >Subject: [PATCH] [PASSED QA] Bug 10138: Add some authorized values in french > installer ; small fixes in frameworks >MIME-Version: 1.0 >Content-Type: text/plain; charset=UTF-8 >Content-Transfer-Encoding: 8bit > >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) > >Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com> >Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de> >Comments on second patch. >--- > .../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.8.3.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10138
:
17773
|
23799
|
23800
| 23827 |
23828