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

(-)a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql (-150 / +151 lines)
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');
(-)a/installer/data/mysql/kohastructure.sql (-11 / +16 lines)
Lines 48-54 CREATE TABLE `auth_subfield_structure` ( Link Here
48
  `repeatable` tinyint(4) NOT NULL default 0,
48
  `repeatable` tinyint(4) NOT NULL default 0,
49
  `mandatory` tinyint(4) NOT NULL default 0,
49
  `mandatory` tinyint(4) NOT NULL default 0,
50
  `tab` tinyint(1) default NULL,
50
  `tab` tinyint(1) default NULL,
51
  `authorised_value` varchar(10) default NULL,
51
  `authorised_value` varchar(30) default NULL,
52
  `value_builder` varchar(80) default NULL,
52
  `value_builder` varchar(80) default NULL,
53
  `seealso` varchar(255) default NULL,
53
  `seealso` varchar(255) default NULL,
54
  `isurl` tinyint(1) default NULL,
54
  `isurl` tinyint(1) default NULL,
Lines 57-63 CREATE TABLE `auth_subfield_structure` ( Link Here
57
  `kohafield` varchar(45) NULL default '',
57
  `kohafield` varchar(45) NULL default '',
58
  `frameworkcode` varchar(10) NOT NULL default '',
58
  `frameworkcode` varchar(10) NOT NULL default '',
59
  PRIMARY KEY  (`authtypecode`,`tagfield`,`tagsubfield`),
59
  PRIMARY KEY  (`authtypecode`,`tagfield`,`tagsubfield`),
60
  KEY `tab` (`authtypecode`,`tab`)
60
  KEY `tab` (`authtypecode`,`tab`),
61
  CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_values` (`category`) ON DELETE CASCADE ON UPDATE CASCADE
61
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
62
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
62
63
63
--
64
--
Lines 72-80 CREATE TABLE `auth_tag_structure` ( Link Here
72
  `libopac` varchar(255) NOT NULL default '',
73
  `libopac` varchar(255) NOT NULL default '',
73
  `repeatable` tinyint(4) NOT NULL default 0,
74
  `repeatable` tinyint(4) NOT NULL default 0,
74
  `mandatory` tinyint(4) NOT NULL default 0,
75
  `mandatory` tinyint(4) NOT NULL default 0,
75
  `authorised_value` varchar(10) default NULL,
76
  `authorised_value` varchar(30) default NULL,
76
  PRIMARY KEY  (`authtypecode`,`tagfield`),
77
  PRIMARY KEY  (`authtypecode`,`tagfield`),
77
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
78
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE,
79
  CONSTRAINT `auth_tag_structure_ibfk_2` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_values` (`category`) ON DELETE CASCADE ON UPDATE CASCADE
78
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
80
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
79
81
80
--
82
--
Lines 97-103 CREATE TABLE `auth_types` ( Link Here
97
DROP TABLE IF EXISTS `authorised_values`;
99
DROP TABLE IF EXISTS `authorised_values`;
98
CREATE TABLE `authorised_values` ( -- stores values for authorized values categories and values
100
CREATE TABLE `authorised_values` ( -- stores values for authorized values categories and values
99
  `id` int(11) NOT NULL auto_increment, -- unique key, used to identify the authorized value
101
  `id` int(11) NOT NULL auto_increment, -- unique key, used to identify the authorized value
100
  `category` varchar(10) NOT NULL default '', -- key used to identify the authorized value category
102
  `category` varchar(30) NOT NULL default '', -- key used to identify the authorized value category
101
  `authorised_value` varchar(80) NOT NULL default '', -- code use to identify the authorized value
103
  `authorised_value` varchar(80) NOT NULL default '', -- code use to identify the authorized value
102
  `lib` varchar(80) default NULL, -- authorized value description as printed in the staff client
104
  `lib` varchar(80) default NULL, -- authorized value description as printed in the staff client
103
  `lib_opac` VARCHAR(80) default NULL, -- authorized value description as printed in the OPAC
105
  `lib_opac` VARCHAR(80) default NULL, -- authorized value description as printed in the OPAC
Lines 284-295 CREATE TABLE `borrower_attribute_types` ( -- definitions for custom patron field Link Here
284
  `opac_display` tinyint(1) NOT NULL default 0, -- defines if this field is visible to patrons on their account in the OPAC (1 for yes, 0 for no)
286
  `opac_display` tinyint(1) NOT NULL default 0, -- defines if this field is visible to patrons on their account in the OPAC (1 for yes, 0 for no)
285
  `password_allowed` tinyint(1) NOT NULL default 0, -- defines if it is possible to associate a password with this custom field (1 for yes, 0 for no)
287
  `password_allowed` tinyint(1) NOT NULL default 0, -- defines if it is possible to associate a password with this custom field (1 for yes, 0 for no)
286
  `staff_searchable` tinyint(1) NOT NULL default 0, -- defines if this field is searchable via the patron search in the staff client (1 for yes, 0 for no)
288
  `staff_searchable` tinyint(1) NOT NULL default 0, -- defines if this field is searchable via the patron search in the staff client (1 for yes, 0 for no)
287
  `authorised_value_category` varchar(10) default NULL, -- foreign key from authorised_values that links this custom field to an authorized value category
289
  `authorised_value_category` varchar(30) default NULL, -- foreign key from authorised_values that links this custom field to an authorized value category
288
  `display_checkout` tinyint(1) NOT NULL default 0,-- defines if this field displays in checkout screens
290
  `display_checkout` tinyint(1) NOT NULL default 0,-- defines if this field displays in checkout screens
289
  `category_code` VARCHAR(1) NOT NULL DEFAULT '',-- defines a category for an attribute_type
291
  `category_code` VARCHAR(1) NOT NULL DEFAULT '',-- defines a category for an attribute_type
290
  `class` VARCHAR(255) NOT NULL DEFAULT '',-- defines a class for an attribute_type
292
  `class` VARCHAR(255) NOT NULL DEFAULT '',-- defines a class for an attribute_type
291
  PRIMARY KEY  (`code`),
293
  PRIMARY KEY  (`code`),
292
  KEY `auth_val_cat_idx` (`authorised_value_category`)
294
  KEY `auth_val_cat_idx` (`authorised_value_category`),
295
  CONSTRAINT `borrower_attribute_types_ibfk_1` FOREIGN KEY (`authorised_value_category`) REFERENCES `authorised_values` (`category`) ON DELETE CASCADE ON UPDATE CASCADE
293
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
296
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
294
297
295
--
298
--
Lines 1198-1204 CREATE TABLE `marc_subfield_structure` ( Link Here
1198
  `mandatory` tinyint(4) NOT NULL default 0,
1201
  `mandatory` tinyint(4) NOT NULL default 0,
1199
  `kohafield` varchar(40) default NULL,
1202
  `kohafield` varchar(40) default NULL,
1200
  `tab` tinyint(1) default NULL,
1203
  `tab` tinyint(1) default NULL,
1201
  `authorised_value` varchar(20) default NULL,
1204
  `authorised_value` varchar(30) default NULL,
1202
  `authtypecode` varchar(20) default NULL,
1205
  `authtypecode` varchar(20) default NULL,
1203
  `value_builder` varchar(80) default NULL,
1206
  `value_builder` varchar(80) default NULL,
1204
  `isurl` tinyint(1) default NULL,
1207
  `isurl` tinyint(1) default NULL,
Lines 1211-1217 CREATE TABLE `marc_subfield_structure` ( Link Here
1211
  PRIMARY KEY  (`frameworkcode`,`tagfield`,`tagsubfield`),
1214
  PRIMARY KEY  (`frameworkcode`,`tagfield`,`tagsubfield`),
1212
  KEY `kohafield_2` (`kohafield`),
1215
  KEY `kohafield_2` (`kohafield`),
1213
  KEY `tab` (`frameworkcode`,`tab`),
1216
  KEY `tab` (`frameworkcode`,`tab`),
1214
  KEY `kohafield` (`frameworkcode`,`kohafield`)
1217
  KEY `kohafield` (`frameworkcode`,`kohafield`),
1218
  CONSTRAINT `marc_subfield_structure_ibfk_1` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_values` (`category`) ON DELETE CASCADE ON UPDATE CASCADE
1215
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1219
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1216
1220
1217
--
1221
--
Lines 1225-1233 CREATE TABLE `marc_tag_structure` ( Link Here
1225
  `libopac` varchar(255) NOT NULL default '',
1229
  `libopac` varchar(255) NOT NULL default '',
1226
  `repeatable` tinyint(4) NOT NULL default 0,
1230
  `repeatable` tinyint(4) NOT NULL default 0,
1227
  `mandatory` tinyint(4) NOT NULL default 0,
1231
  `mandatory` tinyint(4) NOT NULL default 0,
1228
  `authorised_value` varchar(10) default NULL,
1232
  `authorised_value` varchar(30) default NULL,
1229
  `frameworkcode` varchar(4) NOT NULL default '',
1233
  `frameworkcode` varchar(4) NOT NULL default '',
1230
  PRIMARY KEY  (`frameworkcode`,`tagfield`)
1234
  PRIMARY KEY  (`frameworkcode`,`tagfield`),
1235
  CONSTRAINT `marc_tag_structure_ibfk_1` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_values` (`category`) ON DELETE CASCADE ON UPDATE CASCADE
1231
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1236
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1232
1237
1233
--
1238
--
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt (-2 / +1 lines)
Lines 59-65 Link Here
59
        <fieldset class="rows"><ol>
59
        <fieldset class="rows"><ol>
60
        <li>
60
        <li>
61
			 [% IF ( action_add_category ) %]<label for="category">Category</label>
61
			 [% IF ( action_add_category ) %]<label for="category">Category</label>
62
		<input type="text" name="category"  id="category" size="10" maxlength="10" />
62
            <input type="text" name="category"  id="category" size="30" maxlength="30" />
63
			 [% ELSE %]<span class="label">Category</span>
63
			 [% ELSE %]<span class="label">Category</span>
64
		<input type="hidden" name="category" value="[% category %]" />	 [% category %]
64
		<input type="hidden" name="category" value="[% category %]" />	 [% category %]
65
			 [% END %]
65
			 [% END %]
66
- 

Return to bug 6175