|
Lines 20-28
Link Here
|
| 20 |
-- |
20 |
-- |
| 21 |
|
21 |
|
| 22 |
|
22 |
|
| 23 |
-- |
23 |
-- |
| 24 |
-- Contenu de la table `biblio_framework` |
24 |
-- Contenu de la table `biblio_framework` |
| 25 |
-- |
25 |
-- |
| 26 |
|
26 |
|
| 27 |
set NAMES 'utf8'; |
27 |
set NAMES 'utf8'; |
| 28 |
|
28 |
|
|
Lines 31-39
INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('MULT'
Link Here
|
| 31 |
INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('PERI', 'Périodique'); |
31 |
INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('PERI', 'Périodique'); |
| 32 |
INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('WEB', 'Ressource web'); |
32 |
INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('WEB', 'Ressource web'); |
| 33 |
|
33 |
|
| 34 |
-- |
34 |
|
|
|
35 |
-- |
| 36 |
-- Valeurs autorisées nécessaires pour la cohérence des grilles. |
| 37 |
-- (authorised_values insérés besoins à venir avant marc_tag_structure et marc_subfield_structure) |
| 38 |
-- |
| 39 |
|
| 40 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1, 'genre', 'Biographie', 'Biographie'); |
| 41 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (2, 'genre', 'Nouvelle', 'Nouvelle'); |
| 42 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (3, 'genre', 'Policier', 'Policier'); |
| 43 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (4, 'genre', 'Poésie', 'Poésie'); |
| 44 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (5, 'genre', 'Théâtre', 'Théâtre'); |
| 45 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (6, 'genre', 'Conte', 'Conte'); |
| 46 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (7, 'genre', 'Science fiction', 'Science fiction'); |
| 47 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (8, 'genre', 'Roman', 'Roman'); |
| 48 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (9, 'Bsort1', '01', 'Agriculteurs, exploitant'); |
| 49 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (10, 'Bsort1', '02', 'Artisants, commerçants, chefs d''entreprise'); |
| 50 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (11, 'Bsort1', '03', 'Cadres, professions intellectuelles Supérieures'); |
| 51 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (12, 'Bsort1', '04', 'Professions intermédiaires'); |
| 52 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (13, 'Bsort1', '05', 'Employés'); |
| 53 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (14, 'Bsort1', '06', 'Ouvriers'); |
| 54 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (15, 'Bsort1', '07', 'Retraités'); |
| 55 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (16, 'Bsort1', '08', 'Demandeurs d''emploi'); |
| 56 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (17, 'Bsort1', '09', 'Sans emploi'); |
| 57 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (18, 'Bsort1', '10', 'Etudiants'); |
| 58 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (19, 'Bsort1', '11', ' CSP non déclarée'); |
| 59 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (20, 'Bsort1', '12', 'Elèves ou enfants non scolarisés'); |
| 60 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (21, 'statut', '0', ' Disponible'); |
| 61 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (22, 'langue', 'fre', ' Français'); |
| 62 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (23, 'langue', 'eng', 'Anglais'); |
| 63 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (24, 'langue', 'ger', 'Allemand'); |
| 64 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (25, 'langue', 'dut', 'Hollandais'); |
| 65 |
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'); |
| 66 |
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'); |
| 67 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (28, 'pcdm', '0.2 Institutions musicales', '0.2 Institutions musicales'); |
| 68 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (29, 'pcdm', '0.3 Dictionnaires', '0.3 Dictionnaires'); |
| 69 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (30, 'pcdm', '0.4 Répertoires, catalogues', '0.4 Répertoires, catalogues'); |
| 70 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (31, 'pcdm', '0.5 Apprentissage et enseignement', '0.5 Apprentissage et enseignement'); |
| 71 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (32, 'pcdm', '0.6 Techniques musicales et vocales', '0.6 Techniques musicales et vocales'); |
| 72 |
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'); |
| 73 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (34, 'pcdm', '0.9 Histoire de la musique', '0.9 Histoire de la musique'); |
| 74 |
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'); |
| 75 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (36, 'pcdm', '1.1 Blues', '1.1 Blues'); |
| 76 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (37, 'pcdm', '1.2 Negro spirituals, Gospel', '1.2 Negro spirituals, Gospel'); |
| 77 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (38, 'pcdm', '1.3 Jazz', '1.3 Jazz'); |
| 78 |
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'); |
| 79 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (40, 'pcdm', '1.5 Rap', '1.5 Rap'); |
| 80 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (41, 'pcdm', '1.6 Reggae', '1.6 Reggae'); |
| 81 |
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'); |
| 82 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (43, 'pcdm', '2.1 Rock''n''roll, rockabilly', '2.1 Rock''n''roll, rockabilly'); |
| 83 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (44, 'pcdm', '2.2 Pop', '2.2 Pop'); |
| 84 |
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'); |
| 85 |
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'); |
| 86 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (47, 'pcdm', '2.5 Hard rock, metal', '2.5 Hard rock, metal'); |
| 87 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (48, 'pcdm', '2.6 Punk et apparentés', '2.6 Punk et apparentés'); |
| 88 |
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'); |
| 89 |
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...'); |
| 90 |
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'); |
| 91 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (52, 'pcdm', '3- Musique classique', '3- Musique classique'); |
| 92 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (53, 'pcdm', '3.1 Musique de chambre, concertante', '3.1 Musique de chambre, concertante'); |
| 93 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (54, 'pcdm', '3.2 Musique orchestrale', '3.2 Musique orchestrale'); |
| 94 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (55, 'pcdm', '3.3 Musique vocale profane', '3.3 Musique vocale profane'); |
| 95 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (56, 'pcdm', '3.4 Musique vocale sacrée', '3.4 Musique vocale sacrée'); |
| 96 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (57, 'pcdm', '3.5 Musiques utilisant l''électronique', '3.5 Musiques utilisant l''électronique'); |
| 97 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (58, 'pcdm', '4- Musiques électroniques', '4- Musiques électroniques'); |
| 98 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (59, 'pcdm', '4.1 Précurseurs, pionniers', '4.1 Précurseurs, pionniers'); |
| 99 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (60, 'pcdm', '4.2 Ambient, downtempo', '4.2 Ambient, downtempo'); |
| 100 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (61, 'pcdm', '4.3 House', '4.3 House'); |
| 101 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (62, 'pcdm', '4.4 Techno', '4.4 Techno'); |
| 102 |
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'); |
| 103 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (64, 'pcdm', '4.6 Elecronica', '4.6 Elecronica'); |
| 104 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (65, 'pcdm', '4.7 Jungle drum''n''bass', '4.7 Jungle drum''n''bass'); |
| 105 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (66, 'pcdm', '4.8 Dance', '4.8 Dance'); |
| 106 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (67, 'pcdm', '5- Musiques fonctionnelles', '5- Musiques fonctionnelles'); |
| 107 |
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'); |
| 108 |
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'); |
| 109 |
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'); |
| 110 |
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'); |
| 111 |
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'); |
| 112 |
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'); |
| 113 |
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'); |
| 114 |
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'); |
| 115 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (76, 'pcdm', '5.9 Sons divers', '5.9 Sons divers'); |
| 116 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (77, 'pcdm', '6- Musique et cinéma', '6- Musique et cinéma'); |
| 117 |
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'); |
| 118 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (79, 'pcdm', '6.2 Compilations', '6.2 Compilations'); |
| 119 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (80, 'pcdm', '6.2 Compilations', '6.2 Compilations'); |
| 120 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (81, 'pcdm', '8.0 Anthologies générales', '8.0 Anthologies générales'); |
| 121 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (82, 'pcdm', '8.2 Chansons sociales', '8.2 Chansons sociales'); |
| 122 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (83, 'pcdm', '8.3 Chansons humoristiques', '8.3 Chansons humoristiques'); |
| 123 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (84, 'pcdm', '8.4 Chansons à texte', '8.4 Chansons à texte'); |
| 124 |
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'); |
| 125 |
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'); |
| 126 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (87, 'pcdm', '9- Musiques du monde', '9- Musiques du monde'); |
| 127 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (88, 'pcdm', '9.0 Anthologies générales', '9.0 Anthologies générales'); |
| 128 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (89, 'pcdm', '9.1 Afrique', '9.1 Afrique'); |
| 129 |
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'); |
| 130 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (91, 'pcdm', '9.3 Asie', '9.3 Asie'); |
| 131 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (92, 'pcdm', '9.4 Extrême orient', '9.4 Extrême orient'); |
| 132 |
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'); |
| 133 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (94, 'pcdm', '9.6 France', '9.6 France'); |
| 134 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (95, 'pcdm', '9.7 Europe, Ouest et Nord', '9.7 Europe, Ouest et Nord'); |
| 135 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (96, 'pcdm', '9.8 Amérique du Nord', '9.8 Amérique du Nord'); |
| 136 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (97, 'pcdm', '9.9 Amérique latine', '9.9 Amérique latine'); |
| 137 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (98, 'public', 'a', ' Adulte'); |
| 138 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (99, 'public', 'j', 'Jeune'); |
| 139 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (100, 'public', 'u', ' Indéterminé'); |
| 140 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (101, 'public', 'z', 'Autre'); |
| 141 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (107, 'local', 'Espace enfant', 'Espace enfant'); |
| 142 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (108, 'statut', '2', 'Consultation sur RdV'); |
| 143 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (109, 'statut', '1', ' Exclu du prêt'); |
| 144 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (110, 'statut', '3', 'En réparation'); |
| 145 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (111, 'statut', '4', 'En reliure'); |
| 146 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (113, 'statut', '6', 'Rachat en cours'); |
| 147 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (114, 'local', 'Périodiques', 'Périodiques'); |
| 148 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (118, 'local', 'Espace petite enfance', 'Espace petite enfance'); |
| 149 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (119, 'local', 'Magasin/réserve', 'Magasin/réserve'); |
| 150 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (120, 'local', 'Espace audiovisuel', 'Espace audiovisuel'); |
| 151 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (121, 'local', 'Espace multimédia', 'Espace multimédia'); |
| 152 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (122, 'local', 'Espace consultation', 'Espace consultation'); |
| 153 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (123, 'local', 'Fiction adultes', 'Fiction adultes'); |
| 154 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (124, 'local', 'Doc adultes', 'Doc adultes'); |
| 155 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (125, 'local', 'Fiction jeunesse', 'Fiction jeunesse'); |
| 156 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (126, 'local', 'Doc jeunesse', 'Doc jeunesse'); |
| 157 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (127, 'langue', 'spa', 'Espagnol'); |
| 158 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (128, 'langue', 'ita', 'Italien'); |
| 159 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (130, 'Bsort2', 'Crèche', 'Crèche'); |
| 160 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (131, 'Bsort2', 'Ecole', 'Ecole'); |
| 161 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (132, 'Bsort2', 'CLSH', 'CLSH'); |
| 162 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (133, 'Bsort2', 'PMI', 'PMI'); |
| 163 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (134, 'Bsort2', 'Prison', 'Prison'); |
| 164 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (135, 'langue', 'chi', 'Chinois'); |
| 165 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (136, 'langue', 'jap', 'Japonais'); |
| 166 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (137, 'local', 'Espace document adapté', 'Espace document adapté'); |
| 167 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (138, 'local', 'Espace local', 'Espace local'); |
| 168 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (139, 'local', 'Espace théâtre/poésie', 'Espace théâtre/poésie'); |
| 169 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (140, 'langue', 'dan', 'Danois'); |
| 170 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (141, 'langue', 'por', 'Portugais'); |
| 171 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (142, 'langue', 'pro', 'Provençal'); |
| 172 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (143, 'pcdm', '8.1 Chansons pour enfants', '8.1 Chansons pour enfants'); |
| 173 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (144, 'SUGGEST', 'Pas assez de budget', 'Pas assez de budget'); |
| 174 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (145, 'SUGGEST', 'Document trop onéreux', 'Document trop onéreux'); |
| 175 |
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'); |
| 176 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (147, 'COUNTRY', 'FR', 'France'); |
| 177 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (148, 'COUNTRY', 'EN', 'Grande Bretagne'); |
| 178 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (149, 'COUNTRY', 'DE', 'Allemagne'); |
| 179 |
|
| 180 |
|
| 181 |
-- |
| 35 |
-- Contenu de la table `marc_tag_structure` |
182 |
-- Contenu de la table `marc_tag_structure` |
| 36 |
-- |
183 |
-- |
| 37 |
|
184 |
|
| 38 |
INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('000', 'Label', '', 0, 1, '', ''); |
185 |
INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('000', 'Label', '', 0, 1, '', ''); |
| 39 |
INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('001', 'Numéro de notice', 'Numéro de notice', 0, 0, '', ''); |
186 |
INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('001', 'Numéro de notice', 'Numéro de notice', 0, 0, '', ''); |
|
Lines 7739-7887
INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`
Link Here
|
| 7739 |
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); |
7886 |
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); |
| 7740 |
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', 'u', 'Note', '', 0, 0, 'items.itemnotes', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL); |
7887 |
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', 'u', 'Note', '', 0, 0, 'items.itemnotes', -1, '', '', '', NULL, 0, 'WEB', '', NULL, NULL); |
| 7741 |
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', 'v', 'Note sur le N° de périodique', '', 0, 0, 'items.enumchron', 10, '', '', '', 0, 0, 'WEB', '', '', NULL); |
7888 |
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', 'v', 'Note sur le N° de périodique', '', 0, 0, 'items.enumchron', 10, '', '', '', 0, 0, 'WEB', '', '', NULL); |
| 7742 |
|
|
|
| 7743 |
|
| 7744 |
|
| 7745 |
|
| 7746 |
-- |
| 7747 |
-- Valeurs autorisées nécessaires pour la cohérence des grilles. |
| 7748 |
|
| 7749 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1, 'genre', 'Biographie', 'Biographie'); |
| 7750 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (2, 'genre', 'Nouvelle', 'Nouvelle'); |
| 7751 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (3, 'genre', 'Policier', 'Policier'); |
| 7752 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (4, 'genre', 'Poésie', 'Poésie'); |
| 7753 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (5, 'genre', 'Théâtre', 'Théâtre'); |
| 7754 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (6, 'genre', 'Conte', 'Conte'); |
| 7755 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (7, 'genre', 'Science fiction', 'Science fiction'); |
| 7756 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (8, 'genre', 'Roman', 'Roman'); |
| 7757 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (9, 'Bsort1', '01', 'Agriculteurs, exploitant'); |
| 7758 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (10, 'Bsort1', '02', 'Artisants, commerçants, chefs d''entreprise'); |
| 7759 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (11, 'Bsort1', '03', 'Cadres, professions intellectuelles Supérieures'); |
| 7760 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (12, 'Bsort1', '04', 'Professions intermédiaires'); |
| 7761 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (13, 'Bsort1', '05', 'Employés'); |
| 7762 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (14, 'Bsort1', '06', 'Ouvriers'); |
| 7763 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (15, 'Bsort1', '07', 'Retraités'); |
| 7764 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (16, 'Bsort1', '08', 'Demandeurs d''emploi'); |
| 7765 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (17, 'Bsort1', '09', 'Sans emploi'); |
| 7766 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (18, 'Bsort1', '10', 'Etudiants'); |
| 7767 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (19, 'Bsort1', '11', ' CSP non déclarée'); |
| 7768 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (20, 'Bsort1', '12', 'Elèves ou enfants non scolarisés'); |
| 7769 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (21, 'statut', '0', ' Disponible'); |
| 7770 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (22, 'langue', 'fre', ' Français'); |
| 7771 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (23, 'langue', 'eng', 'Anglais'); |
| 7772 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (24, 'langue', 'ger', 'Allemand'); |
| 7773 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (25, 'langue', 'dut', 'Hollandais'); |
| 7774 |
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'); |
| 7775 |
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'); |
| 7776 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (28, 'pcdm', '0.2 Institutions musicales', '0.2 Institutions musicales'); |
| 7777 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (29, 'pcdm', '0.3 Dictionnaires', '0.3 Dictionnaires'); |
| 7778 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (30, 'pcdm', '0.4 Répertoires, catalogues', '0.4 Répertoires, catalogues'); |
| 7779 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (31, 'pcdm', '0.5 Apprentissage et enseignement', '0.5 Apprentissage et enseignement'); |
| 7780 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (32, 'pcdm', '0.6 Techniques musicales et vocales', '0.6 Techniques musicales et vocales'); |
| 7781 |
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'); |
| 7782 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (34, 'pcdm', '0.9 Histoire de la musique', '0.9 Histoire de la musique'); |
| 7783 |
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'); |
| 7784 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (36, 'pcdm', '1.1 Blues', '1.1 Blues'); |
| 7785 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (37, 'pcdm', '1.2 Negro spirituals, Gospel', '1.2 Negro spirituals, Gospel'); |
| 7786 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (38, 'pcdm', '1.3 Jazz', '1.3 Jazz'); |
| 7787 |
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'); |
| 7788 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (40, 'pcdm', '1.5 Rap', '1.5 Rap'); |
| 7789 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (41, 'pcdm', '1.6 Reggae', '1.6 Reggae'); |
| 7790 |
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'); |
| 7791 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (43, 'pcdm', '2.1 Rock''n''roll, rockabilly', '2.1 Rock''n''roll, rockabilly'); |
| 7792 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (44, 'pcdm', '2.2 Pop', '2.2 Pop'); |
| 7793 |
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'); |
| 7794 |
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'); |
| 7795 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (47, 'pcdm', '2.5 Hard rock, metal', '2.5 Hard rock, metal'); |
| 7796 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (48, 'pcdm', '2.6 Punk et apparentés', '2.6 Punk et apparentés'); |
| 7797 |
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'); |
| 7798 |
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...'); |
| 7799 |
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'); |
| 7800 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (52, 'pcdm', '3- Musique classique', '3- Musique classique'); |
| 7801 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (53, 'pcdm', '3.1 Musique de chambre, concertante', '3.1 Musique de chambre, concertante'); |
| 7802 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (54, 'pcdm', '3.2 Musique orchestrale', '3.2 Musique orchestrale'); |
| 7803 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (55, 'pcdm', '3.3 Musique vocale profane', '3.3 Musique vocale profane'); |
| 7804 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (56, 'pcdm', '3.4 Musique vocale sacrée', '3.4 Musique vocale sacrée'); |
| 7805 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (57, 'pcdm', '3.5 Musiques utilisant l''électronique', '3.5 Musiques utilisant l''électronique'); |
| 7806 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (58, 'pcdm', '4- Musiques électroniques', '4- Musiques électroniques'); |
| 7807 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (59, 'pcdm', '4.1 Précurseurs, pionniers', '4.1 Précurseurs, pionniers'); |
| 7808 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (60, 'pcdm', '4.2 Ambient, downtempo', '4.2 Ambient, downtempo'); |
| 7809 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (61, 'pcdm', '4.3 House', '4.3 House'); |
| 7810 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (62, 'pcdm', '4.4 Techno', '4.4 Techno'); |
| 7811 |
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'); |
| 7812 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (64, 'pcdm', '4.6 Elecronica', '4.6 Elecronica'); |
| 7813 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (65, 'pcdm', '4.7 Jungle drum''n''bass', '4.7 Jungle drum''n''bass'); |
| 7814 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (66, 'pcdm', '4.8 Dance', '4.8 Dance'); |
| 7815 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (67, 'pcdm', '5- Musiques fonctionnelles', '5- Musiques fonctionnelles'); |
| 7816 |
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'); |
| 7817 |
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'); |
| 7818 |
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'); |
| 7819 |
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'); |
| 7820 |
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'); |
| 7821 |
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'); |
| 7822 |
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'); |
| 7823 |
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'); |
| 7824 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (76, 'pcdm', '5.9 Sons divers', '5.9 Sons divers'); |
| 7825 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (77, 'pcdm', '6- Musique et cinéma', '6- Musique et cinéma'); |
| 7826 |
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'); |
| 7827 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (79, 'pcdm', '6.2 Compilations', '6.2 Compilations'); |
| 7828 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (80, 'pcdm', '6.2 Compilations', '6.2 Compilations'); |
| 7829 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (81, 'pcdm', '8.0 Anthologies générales', '8.0 Anthologies générales'); |
| 7830 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (82, 'pcdm', '8.2 Chansons sociales', '8.2 Chansons sociales'); |
| 7831 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (83, 'pcdm', '8.3 Chansons humoristiques', '8.3 Chansons humoristiques'); |
| 7832 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (84, 'pcdm', '8.4 Chansons à texte', '8.4 Chansons à texte'); |
| 7833 |
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'); |
| 7834 |
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'); |
| 7835 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (87, 'pcdm', '9- Musiques du monde', '9- Musiques du monde'); |
| 7836 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (88, 'pcdm', '9.0 Anthologies générales', '9.0 Anthologies générales'); |
| 7837 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (89, 'pcdm', '9.1 Afrique', '9.1 Afrique'); |
| 7838 |
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'); |
| 7839 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (91, 'pcdm', '9.3 Asie', '9.3 Asie'); |
| 7840 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (92, 'pcdm', '9.4 Extrême orient', '9.4 Extrême orient'); |
| 7841 |
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'); |
| 7842 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (94, 'pcdm', '9.6 France', '9.6 France'); |
| 7843 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (95, 'pcdm', '9.7 Europe, Ouest et Nord', '9.7 Europe, Ouest et Nord'); |
| 7844 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (96, 'pcdm', '9.8 Amérique du Nord', '9.8 Amérique du Nord'); |
| 7845 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (97, 'pcdm', '9.9 Amérique latine', '9.9 Amérique latine'); |
| 7846 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (98, 'public', 'a', ' Adulte'); |
| 7847 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (99, 'public', 'j', 'Jeune'); |
| 7848 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (100, 'public', 'u', ' Indéterminé'); |
| 7849 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (101, 'public', 'z', 'Autre'); |
| 7850 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (107, 'local', 'Espace enfant', 'Espace enfant'); |
| 7851 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (108, 'statut', '2', 'Consultation sur RdV'); |
| 7852 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (109, 'statut', '1', ' Exclu du prêt'); |
| 7853 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (110, 'statut', '3', 'En réparation'); |
| 7854 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (111, 'statut', '4', 'En reliure'); |
| 7855 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (113, 'statut', '6', 'Rachat en cours'); |
| 7856 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (114, 'local', 'Périodiques', 'Périodiques'); |
| 7857 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (118, 'local', 'Espace petite enfance', 'Espace petite enfance'); |
| 7858 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (119, 'local', 'Magasin/réserve', 'Magasin/réserve'); |
| 7859 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (120, 'local', 'Espace audiovisuel', 'Espace audiovisuel'); |
| 7860 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (121, 'local', 'Espace multimédia', 'Espace multimédia'); |
| 7861 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (122, 'local', 'Espace consultation', 'Espace consultation'); |
| 7862 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (123, 'local', 'Fiction adultes', 'Fiction adultes'); |
| 7863 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (124, 'local', 'Doc adultes', 'Doc adultes'); |
| 7864 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (125, 'local', 'Fiction jeunesse', 'Fiction jeunesse'); |
| 7865 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (126, 'local', 'Doc jeunesse', 'Doc jeunesse'); |
| 7866 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (127, 'langue', 'spa', 'Espagnol'); |
| 7867 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (128, 'langue', 'ita', 'Italien'); |
| 7868 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (130, 'Bsort2', 'Crèche', 'Crèche'); |
| 7869 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (131, 'Bsort2', 'Ecole', 'Ecole'); |
| 7870 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (132, 'Bsort2', 'CLSH', 'CLSH'); |
| 7871 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (133, 'Bsort2', 'PMI', 'PMI'); |
| 7872 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (134, 'Bsort2', 'Prison', 'Prison'); |
| 7873 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (135, 'langue', 'chi', 'Chinois'); |
| 7874 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (136, 'langue', 'jap', 'Japonais'); |
| 7875 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (137, 'local', 'Espace document adapté', 'Espace document adapté'); |
| 7876 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (138, 'local', 'Espace local', 'Espace local'); |
| 7877 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (139, 'local', 'Espace théâtre/poésie', 'Espace théâtre/poésie'); |
| 7878 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (140, 'langue', 'dan', 'Danois'); |
| 7879 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (141, 'langue', 'por', 'Portugais'); |
| 7880 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (142, 'langue', 'pro', 'Provençal'); |
| 7881 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (143, 'pcdm', '8.1 Chansons pour enfants', '8.1 Chansons pour enfants'); |
| 7882 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (144, 'SUGGEST', 'Pas assez de budget', 'Pas assez de budget'); |
| 7883 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (145, 'SUGGEST', 'Document trop onéreux', 'Document trop onéreux'); |
| 7884 |
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'); |
| 7885 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (147, 'COUNTRY', 'FR', 'France'); |
| 7886 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (148, 'COUNTRY', 'EN', 'Grande Bretagne'); |
| 7887 |
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (149, 'COUNTRY', 'DE', 'Allemagne'); |