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

(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_default_matching_rules.txt (-3 / +1 lines)
Lines 1-5 Link Here
1
Selected matching rules for MARC 21 bibliographic
1
Inserisci regole di corrispondenza per records MARC21 che includono:
2
records, including:
3
4
ISBN
2
ISBN
5
ISSN
3
ISSN
(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.txt (-1 / +1 lines)
Line 1 Link Here
1
'FA', a 'Fast Add' minimal MARC21 framework suitable for ILL or on-the-fly cataloguing.
1
'FA', una griglia di catalogazione minimale, 'FAST' per ILL o ctalogazionone al volo.
(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_relatorterms.sql (+226 lines)
Line 0 Link Here
1
-- MARC code list for Relators, taken from
2
-- http://www.loc.gov/marc/relators/relacode.html
3
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','acp','Art copyist');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','act','Actor');
6
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','adp','Adapter');
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aft','Author of afterword, colophon, etc.');
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anl','Analyst');
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anm','Animator');
10
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ann','Annotator');
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ant','Bibliographic antecedent');
12
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','app','Applicant');
13
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aqt','Author in quotations or text abstracts');
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arc','Architect');
15
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ard','Artistic director');
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arr','Arranger');
17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','art','Artist');
18
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asg','Assignee');
19
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asn','Associated name');
20
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','att','Attributed name');
21
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','auc','Auctioneer');
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aud','Author of dialog');
23
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aui','Author of introduction');
24
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aus','Author of screenplay');
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aut','Author');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bdd','Binding designer');
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bjd','Bookjacket designer');
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkd','Book designer');
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkp','Book producer');
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','blw','Blurb writer');
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bnd','Binder');
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bpd','Bookplate designer');
33
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bsl','Bookseller');
34
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ccp','Conceptor');
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','chr','Choreographer');
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clb','Collaborator');
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cli','Client');
38
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cll','Calligrapher');
39
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clr','Colorist');
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clt','Collotyper');
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmm','Commentator');
42
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmp','Composer');
43
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmt','Compositor');
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cng','Cinematographer');
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cnd','Conductor');
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cns','Censor');
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','coe','Contestant -appellee');
48
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','col','Collector');
49
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','com','Compiler');
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','con','Conservator');
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cos','Contestant');
52
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cot','Contestant -appellant');
53
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cov','Cover designer');
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpc','Copyright claimant');
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpe','Complainant-appellee');
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cph','Copyright holder');
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpl','Complainant');
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpt','Complainant-appellant');
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cre','Creator');
60
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','crp','Correspondent');
61
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','crr','Corrector');
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csl','Consultant');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csp','Consultant to a project');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cst','Costume designer');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctb','Contributor');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cte','Contestee-appellee');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctg','Cartographer');
68
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctr','Contractor');
69
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cts','Contestee');
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctt','Contestee-appellant');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cur','Curator');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cwt','Commentator for written text');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfd','Defendant');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfe','Defendant-appellee');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dft','Defendant-appellant');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dgg','Degree grantor');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dis','Dissertant');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dln','Delineator');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnc','Dancer');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnr','Donor');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpb','Distribution place');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpc','Depicted');
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpt','Depositor');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drm','Draftsman');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drt','Director');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dsr','Designer');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dst','Distributor');
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtc','Data contributor');
89
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dte','Dedicatee');
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtm','Data manager');
91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dto','Dedicator');
92
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dub','Dubious author');
93
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','edt','Editor');
94
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','egr','Engraver');
95
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elg','Electrician');
96
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elt','Electrotyper');
97
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','eng','Engineer');
98
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','etr','Etcher');
99
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','evp','Event place');
100
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','exp','Expert');
101
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fac','Facsimilist');
102
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fld','Field director');
103
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','flm','Film editor');
104
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fmo','Former owner');
105
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fpy','First party');
106
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fnd','Funder');
107
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','frg','Forger');
108
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','gis','Geographic information specialist');
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','-grt','Graphic technician');
110
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hnr','Honoree');
111
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hst','Host');
112
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ill','Illustrator');
113
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ilu','Illuminator');
114
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ins','Inscriber');
115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','inv','Inventor');
116
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','itr','Instrumentalist');
117
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ive','Interviewee');
118
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ivr','Interviewer');
119
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbr','Laboratory');
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbt','Librettist');
121
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ldr','Laboratory director');
122
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','led','Lead');
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lee','Libelee-appellee');
124
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lel','Libelee');
125
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','len','Lender');
126
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','let','Libelee-appellant');
127
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lgd','Lighting designer');
128
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lie','Libelant-appellee');
129
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lil','Libelant');
130
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lit','Libelant-appellant');
131
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lsa','Landscape architect');
132
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lse','Licensee');
133
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lso','Licensor');
134
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ltg','Lithographer');
135
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lyr','Lyricist');
136
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mcp','Music copyist');
137
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfp','Manufacture place');
138
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfr','Manufacturer');
139
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mdc','Metadata contact');
140
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mod','Moderator');
141
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mon','Monitor');
142
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrb','Marbler');
143
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrk','Markup editor');
144
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','msd','Musical director');
145
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mte','Metal-engraver');
146
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mus','Musician');
147
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','nrt','Narrator');
148
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','opn','Opponent');
149
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','org','Originator');
150
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','orm','Organizer of meeting');
151
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','oth','Other');
152
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','own','Owner');
153
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pat','Patron');
154
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbd','Publishing director');
155
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbl','Publisher');
156
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pdr','Project director');
157
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pfr','Proofreader');
158
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pht','Photographer');
159
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','plt','Platemaker');
160
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pma','Permitting agency');
161
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pmn','Production manager');
162
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pop','Printer of plates');
163
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppm','Papermaker');
164
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppt','Puppeteer');
165
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prc','Process contact');
166
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prd','Production personnel');
167
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prf','Performer');
168
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prg','Programmer');
169
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prm','Printmaker');
170
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pro','Producer');
171
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prp','Production place');
172
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prt','Printer');
173
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pta','Patent applicant');
174
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pte','Plaintiff -appellee');
175
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptf','Plaintiff');
176
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pth','Patent holder');
177
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptt','Plaintiff-appellant');
178
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pup','Publication place');
179
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rbr','Rubricator');
180
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rce','Recording engineer');
181
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rcp','Recipient');
182
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','red','Redactor');
183
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ren','Renderer');
184
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','res','Researcher');
185
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rev','Reviewer');
186
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rps','Repository');
187
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpt','Reporter');
188
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpy','Responsible party');
189
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rse','Respondent-appellee');
190
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsg','Restager');
191
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsp','Respondent');
192
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rst','Respondent-appellant');
193
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rth','Research team head');
194
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rtm','Research team member');
195
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sad','Scientific advisor');
196
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sce','Scenarist');
197
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scl','Sculptor');
198
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scr','Scribe');
199
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sds','Sound designer');
200
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sec','Secretary');
201
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sgn','Signer');
202
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sht','Supporting host');
203
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sng','Singer');
204
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spk','Speaker');
205
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spn','Sponsor');
206
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spy','Second party');
207
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','srv','Surveyor');
208
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','std','Set designer');
209
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stl','Storyteller');
210
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stm','Stage manager');
211
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stn','Standards body');
212
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','str','Stereotyper');
213
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tcd','Technical director');
214
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tch','Teacher');
215
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ths','Thesis advisor');
216
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trc','Transcriber');
217
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trl','Translator');
218
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyd','Type designer');
219
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyg','Typographer');
220
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','uvp','University place');
221
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','vdg','Videographer');
222
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','voc','Vocalist');
223
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wam','Writer of accompanying material');
224
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wdc','Woodcutter');
225
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wde','Wood-engraver');
226
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wit','Witness');
(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_relatorterms.txt (+1 lines)
Line 0 Link Here
1
Lista codici MARC21 per  tipologie autori, da http://www.loc.gov/marc/relators/relaterm.html
(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.txt (-1 / +1 lines)
Lines 1-4 Link Here
1
Simple MARC 21 bibliographic frameworks for some common types of bibliographic material.  Frameworks are used to define the structure of your MARC records and the behavior of the integrated MARC editor. You can change these at any time after installation. The frameworks in this optional default setting include:
1
Alcune griglie predefinite per i materiali piu' comuni:
2
2
3
BKS	Books, Booklets, Workbooks
3
BKS	Books, Booklets, Workbooks
4
CF	CD-ROMs, DVD-ROMs, General Online Resources
4
CF	CD-ROMs, DVD-ROMs, General Online Resources
(-)a/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql (-2 / +2 lines)
Lines 1431-1437 insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` Link Here
1431
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 ('200','i','Nome della parte','',1,0,'',2,'','','',NULL,0,'MN',NULL,NULL,NULL);
1431
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 ('200','i','Nome della parte','',1,0,'',2,'','','',NULL,0,'MN',NULL,NULL,NULL);
1432
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 ('200','v','Indicazione Volume','',0,0,'',2,'','','',NULL,0,'MN',NULL,NULL,NULL);
1432
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 ('200','v','Indicazione Volume','',0,0,'',2,'','','',NULL,0,'MN',NULL,NULL,NULL);
1433
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 ('200','z','Lingua titolo parallelo','',1,0,'',2,'','','',NULL,0,'MN',NULL,NULL,NULL);
1433
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 ('200','z','Lingua titolo parallelo','',1,0,'',2,'','','',NULL,0,'MN',NULL,NULL,NULL);
1434
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 ('205','a','Formulazione di edizione','',0,0,'',2,'','','',NULL,0,'MN','',NULL,NULL);
1434
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 ('205','a','Formulazione di edizione','',0,0,'biblioitems.editionstatement',2,'','','',NULL,0,'MN','',NULL,NULL);
1435
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 ('205','b','Formulazione aggiuntiva di edizione','',1,0,'',2,'','','',NULL,0,'MN','',NULL,NULL);
1435
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 ('205','b','Formulazione aggiuntiva di edizione','',1,0,'',2,'','','',NULL,0,'MN','',NULL,NULL);
1436
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 ('205','d','Formulazione parallela di edizione','',1,0,'',2,'','','',NULL,0,'MN','',NULL,NULL);
1436
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 ('205','d','Formulazione parallela di edizione','',1,0,'',2,'','','',NULL,0,'MN','',NULL,NULL);
1437
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 ('205','f','Formulazione di responsabilità relativa all\'edizione','',1,0,'',2,'','','',NULL,0,'MN','',NULL,NULL);
1437
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 ('205','f','Formulazione di responsabilità relativa all\'edizione','',1,0,'',2,'','','',NULL,0,'MN','',NULL,NULL);
Lines 1761-1767 insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` Link Here
1761
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 ('200','i','Nome della parte','',1,0,'',2,'','','',NULL,0,'PR',NULL,NULL,NULL);
1761
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 ('200','i','Nome della parte','',1,0,'',2,'','','',NULL,0,'PR',NULL,NULL,NULL);
1762
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 ('200','v','Indicazione Volume','',0,0,'',2,'','','',NULL,0,'PR',NULL,NULL,NULL);
1762
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 ('200','v','Indicazione Volume','',0,0,'',2,'','','',NULL,0,'PR',NULL,NULL,NULL);
1763
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 ('200','z','Lingua titolo parallelo','',1,0,'',2,'','','',NULL,0,'PR',NULL,NULL,NULL);
1763
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 ('200','z','Lingua titolo parallelo','',1,0,'',2,'','','',NULL,0,'PR',NULL,NULL,NULL);
1764
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 ('205','a','Formulazione di edizione','',0,0,'',2,'','','',NULL,0,'PR','',NULL,NULL);
1764
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 ('205','a','Formulazione di edizione','',0,0,'biblioitems.editionstatement',2,'','','',NULL,0,'PR','',NULL,NULL);
1765
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 ('205','b','Formulazione aggiuntiva di edizione','',1,0,'',2,'','','',NULL,0,'PR','',NULL,NULL);
1765
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 ('205','b','Formulazione aggiuntiva di edizione','',1,0,'',2,'','','',NULL,0,'PR','',NULL,NULL);
1766
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 ('205','d','Formulazione parallela di edizione','',1,0,'',2,'','','',NULL,0,'PR','',NULL,NULL);
1766
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 ('205','d','Formulazione parallela di edizione','',1,0,'',2,'','','',NULL,0,'PR','',NULL,NULL);
1767
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 ('205','f','Formulazione di responsabilità relativa all\'edizione','',1,0,'',2,'','','',NULL,0,'PR','',NULL,NULL);
1767
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 ('205','f','Formulazione di responsabilità relativa all\'edizione','',1,0,'',2,'','','',NULL,0,'PR','',NULL,NULL);
(-)a/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_default_matching_rules.sql (+34 lines)
Line 0 Link Here
1
-- Default UNIMARC matching rules for Koha
2
--
3
-- This file is part of Koha.
4
--
5
-- Koha is free software; you can redistribute it and/or modify it under the
6
-- terms of the GNU General Public License as published by the Free Software
7
-- Foundation; either version 2 of the License, or (at your option) any later
8
-- version.
9
--
10
-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY
11
-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
12
-- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
13
--
14
-- You should have received a copy of the GNU General Public License along with
15
-- Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
16
-- Suite 330, Boston, MA  02111-1307 USA
17
18
INSERT INTO marc_matchers (code, description, record_type, threshold)
19
    VALUES ('ISBN', '010$a', 'biblio', 1000);
20
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
21
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
22
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
23
    SELECT MAX(matchpoint_id), 1, '010', 'a' FROM matchpoints;
24
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
25
    SELECT MAX(matchpoint_component_id), 1, 'ISBN' FROM matchpoint_components;
26
27
INSERT INTO marc_matchers (code, description, record_type, threshold)
28
    VALUES ('ISSN', '011$a', 'biblio', 1000);
29
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
30
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
31
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
32
    SELECT MAX(matchpoint_id), 1, '011', 'a' FROM matchpoints;
33
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
34
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
(-)a/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_default_matching_rules.txt (+3 lines)
Line 0 Link Here
1
Seleziona regole di corrispondenza secondo lo standard Unimarc:
2
ISBN
3
ISSN
(-)a/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_relatorterms.sql (+34 lines)
Line 0 Link Here
1
-- Qualifiche per gli autori
2
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES
4
('qualif', '570', 'Altro'),
5
('qualif', '205', 'Collaboratore'),
6
('qualif', '210', 'Commentatore'),
7
('qualif', '571', 'Coordinatore'),
8
('qualif', '573', 'Diffusore'),
9
('qualif', '651', 'Direttore editoriale'),
10
('qualif', '650', 'Editore'),
11
('qualif', '440', 'Illustratore'),
12
('qualif', '075', 'Postfatore'),
13
('qualif', '080', 'Prefatore'),
14
('qualif', '574', 'Presentatore'),
15
('qualif', '710', 'Redattore'),
16
('qualif', '575', 'Responsabile'),
17
('qualif', '730', 'Traduttore'),
18
('qualif', '020', 'Chiosatore'),
19
('qualif', '723', 'Sponsor'),
20
('qualif', '675', 'Recensore'),
21
('qualif', '600', 'Fotografo'),
22
('qualif', '370', 'Film editor'),
23
('qualif', '673', 'Direttore'),
24
('qualif', '605', 'Presentatore'),
25
('qualif', '557', 'Organizzatore del congresso'),
26
('qualif', '340', 'Editor'),
27
('qualif', '727', 'Relatore di tesi'),
28
('qualif', '220', 'Compilatore'),
29
('qualif', '395', 'Fondatore'),
30
('qualif', '100', 'Autore dell''opere che è stata adattata'),
31
('qualif', '230', 'Compositore'),
32
('qualif', '520', 'Paroliere'),
33
('qualif', '295', 'Istituzione garante della tesi'),
34
('qualif', '010', 'Adattarore');
(-)a/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_relatorterms.txt (+1 lines)
Line 0 Link Here
1
Lista codici tipologie autori da UNIMARC, 3° edizione
(-)a/installer/data/mysql/it-IT/necessari/auth_val.sql (-65 / +37 lines)
Lines 1-5 Link Here
1
SET FOREIGN_KEY_CHECKS=0;
1
SET FOREIGN_KEY_CHECKS=0;
2
2
3
-- To manage Yes/No
4
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');
5
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Si','Si');
6
3
-- Reasons for acceptance or rejection of suggestions in acquisitions
7
-- Reasons for acceptance or rejection of suggestions in acquisitions
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestseller');
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestseller');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Copia a scaffale danneggiata');
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Copia a scaffale danneggiata');
Lines 7-94 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST Link Here
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Disponibile via prestito ILL');
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Disponibile via prestito ILL');
8
12
9
-- availability statuses
13
-- availability statuses
10
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0','Non persa');
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOST','0','Non persa');
11
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Lungo ritardo (persa)');
15
INSERT INTO authorised_values  (category, authorised_value, lib) VALUES ('LOST','2','Lungo ritardo (persa)');
12
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Persa');
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOST','1','Persa');
13
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Persa e pagata da');
17
INSERT INTO authorised_values  (category, authorised_value, lib ) VALUES ('LOST','3','Persa e pagata da');
14
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Mancante');
18
INSERT INTO authorised_values  (category, authorised_value, lib )VALUES ('LOST','4','Mancante');
15
19
16
-- damaged status of an item
20
-- damaged status of an item
17
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('DAMAGED','0','Non danneggiata');
21
INSERT INTO authorised_values  (category, authorised_value, lib) VALUES ('DAMAGED','0','Non danneggiata');
18
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Danneggiata');
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('DAMAGED','1','Danneggiata');
19
23
20
-- location qualification for an item, departments are linked by default to items.location
24
-- location qualification for an item, departments are linked by default to items.location
21
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Fiction');
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','FIC','Fiction');
22
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CHILD','Area bambini');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','CHILD','Area bambini');
23
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','DISPLAY','A scaffale aperto');
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','DISPLAY','A scaffale aperto');
24
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','NEW','Scaffale novità');
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','NEW','Scaffale novità');
25
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','STAFF','Ufficio staff');
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','STAFF','Ufficio staff');
26
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','Sezione generale');
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','GEN','Sezione generale');
27
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','Audiovideo');
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','AV','Audiovideo');
28
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Strumenti di reference');
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','REF','Strumenti di reference');
29
33
30
-- collection codes for an item
34
-- collection codes for an item
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction');
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction');
32
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Strumenti di reference');
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','REF','Strumenti di reference');
33
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
34
38
35
-- withdrawn status of an item, linked to items.wthdrawn
39
-- withdrawn status of an item, linked to items.wthdrawn
36
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0','Non ritirata');
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('WITHDRAWN','0','Non ritirata');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ritirata dalla circolazione');
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ritirata dalla circolazione');
38
42
39
-- loanability status of an item, linked to items.notforloan
43
-- loanability status of an item, linked to items.notforloan
40
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordinato');
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordinato');
41
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0','Per il prestito');
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('NOT_LOAN','0','Per il prestito');
42
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Non per il prestito');
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Non per il prestito');
43
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Uso interno');
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Uso interno');
44
48
45
-- restricted status of an item, linked to items.restricted
49
-- restricted status of an item, linked to items.restricted
46
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0','Nessuna restrizione');
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RESTRICTED','0','Nessuna restrizione');
47
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Accesso limitato');
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RESTRICTED','1','Accesso limitato');
48
52
49
-- manual invoice types
53
-- manual invoice types
50
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUAL_INV','Costo fotocopie','.25');
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MANUAL_INV','Costo fotocopie','.25');
51
55
52
-- custom borrower notes
56
-- custom borrower notes
53
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Indirizzo (Nota)');
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Indirizzo (Nota)');
54
55
-- Qualifiche per gli autori
56
58
57
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES 
59
-- OPAC Suggestions reasons
58
('qualif', '570', 'Altro'),
60
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','La copia disponibile è danneggiata','La copia disponibile è danneggiata');
59
('qualif', '205', 'Collaboratore'),
61
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Titolo in arrivo di autore famoso','Titolo in arrivo di autore famoso');
60
('qualif', '210', 'Commentatore'),
61
('qualif', '571', 'Coordinatore'),
62
('qualif', '573', 'Diffusore'),
63
('qualif', '651', 'Direttore editoriale'),
64
('qualif', '650', 'Editore'),
65
('qualif', '440', 'Illustratore'),
66
('qualif', '075', 'Postfatore'),
67
('qualif', '080', 'Prefatore'),
68
('qualif', '574', 'Presentatore'),
69
('qualif', '710', 'Redattore'),
70
('qualif', '575', 'Responsabile'),
71
('qualif', '730', 'Traduttore'),
72
('qualif', '020', 'Chiosatore'),
73
('qualif', '723', 'Sponsor'),
74
('qualif', '675', 'Recensore'),
75
('qualif', '600', 'Fotografo'),
76
('qualif', '370', 'Film editor'),
77
('qualif', '673', 'Direttore'),
78
('qualif', '605', 'Presentatore'),
79
('qualif', '557', 'Organizzatore del congresso'),
80
('qualif', '340', 'Editor'),
81
('qualif', '727', 'Relatore di tesi'),
82
('qualif', '220', 'Compilatore'),
83
('qualif', '395', 'Fondatore'),
84
('qualif', '100', 'Autore dell''opere che è stata adattata'),
85
('qualif', '230', 'Compositore'),
86
('qualif', '520', 'Paroliere'),
87
('qualif', '295', 'Istituzione garante della tesi'),
88
('qualif', '010', 'Adattarore');
89
62
90
-- Codici dei Paesi (COUNTRY)
63
-- Codici dei Paesi (COUNTRY)
91
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES
92
('COUNTRY', 'IT', 'Italia'),
65
('COUNTRY', 'IT', 'Italia'),
93
('COUNTRY', 'US', 'Stati Uniti'),
66
('COUNTRY', 'US', 'Stati Uniti'),
94
('COUNTRY', 'GB', 'Regno Unito - UK '),
67
('COUNTRY', 'GB', 'Regno Unito - UK '),
Lines 99-105 INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES Link Here
99
('COUNTRY', 'IN', 'India');
72
('COUNTRY', 'IN', 'India');
100
73
101
-- Codici delle lingue (LANG)
74
-- Codici delle lingue (LANG)
102
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES
103
('LANG', 'ita', 'italiano'),
76
('LANG', 'ita', 'italiano'),
104
('LANG', 'eng', 'inglese'),
77
('LANG', 'eng', 'inglese'),
105
('LANG', 'ger', 'tedesco'),
78
('LANG', 'ger', 'tedesco'),
Lines 107-110 INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES Link Here
107
('LANG', 'lat', 'latino');
80
('LANG', 'lat', 'latino');
108
81
109
SET FOREIGN_KEY_CHECKS=1;
82
SET FOREIGN_KEY_CHECKS=1;
110
(-)a/installer/data/mysql/it-IT/necessari/notices.sql (-1 / +90 lines)
Lines 1-4 Link Here
1
INSERT INTO `letter` (module, code, name, title, content) 
1
INSERT INTO letter (module, code, name, title, content)
2
VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nAccording to our current records, you have items that are overdue.Your library does not charge late fines, but please return or renew them at the branch below as soon as possible.\n\n<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>> <<branches.branchaddress3>>\nPhone: <<branches.branchphone>>\nFax: <<branches.branchfax>>\nEmail: <<branches.branchemail>>\n\nIf you have registered a password with the library, and you have a renewal available, you may renew online. If an item becomes more than 30 days overdue, you will be unable to use your library card until the item is returned.\n\nThe following item(s) is/are currently overdue:\n\n<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <fine>GBP</fine></item>\n\nThank-you for your prompt attention to this matter.\n\n<<branches.branchname>> Staff\n'),
2
VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nAccording to our current records, you have items that are overdue.Your library does not charge late fines, but please return or renew them at the branch below as soon as possible.\n\n<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>> <<branches.branchaddress3>>\nPhone: <<branches.branchphone>>\nFax: <<branches.branchfax>>\nEmail: <<branches.branchemail>>\n\nIf you have registered a password with the library, and you have a renewal available, you may renew online. If an item becomes more than 30 days overdue, you will be unable to use your library card until the item is returned.\n\nThe following item(s) is/are currently overdue:\n\n<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <fine>GBP</fine></item>\n\nThank-you for your prompt attention to this matter.\n\n<<branches.branchname>> Staff\n'),
3
('claimacquisition','ACQCLAIM','Acquisition Claim','Item Not Received','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<aqorders.title>>) (<<aqorders.quantity>> ordered) ($<<aqorders.listprice>> each) has not been received.</order>'),
3
('claimacquisition','ACQCLAIM','Acquisition Claim','Item Not Received','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<aqorders.title>>) (<<aqorders.quantity>> ordered) ($<<aqorders.listprice>> each) has not been received.</order>'),
4
('serial','RLIST','Routing List','Serial is now available','<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following issue is now available:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nPlease pick it up at your convenience.'),
4
('serial','RLIST','Routing List','Serial is now available','<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following issue is now available:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nPlease pick it up at your convenience.'),
Lines 16-18 VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f Link Here
16
('suggestions','AVAILABLE','Suggestion available', 'Suggested purchase available','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nWe are pleased to inform you that the item you requested is now part of the collection.\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>'),
16
('suggestions','AVAILABLE','Suggestion available', 'Suggested purchase available','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nWe are pleased to inform you that the item you requested is now part of the collection.\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>'),
17
('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nWe are pleased to inform you that the item you requested has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>'),
17
('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nWe are pleased to inform you that the item you requested has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>'),
18
('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>');
18
('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>');
19
INSERT INTO letter (module, code, name, title, content, is_html)
20
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
21
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
22
(<<borrowers.cardnumber>>) <br />
23
24
<<today>><br />
25
26
<h4>Checked Out</h4>
27
<checkedout>
28
<p>
29
<<biblio.title>> <br />
30
Barcode: <<items.barcode>><br />
31
Date due: <<issues.date_due>><br />
32
</p>
33
</checkedout>
34
35
<h4>Overdues</h4>
36
<overdue>
37
<p>
38
<<biblio.title>> <br />
39
Barcode: <<items.barcode>><br />
40
Date due: <<issues.date_due>><br />
41
</p>
42
</overdue>
43
44
<hr>
45
46
<h4 style="text-align: center; font-style:italic;">News</h4>
47
<news>
48
<div class="newsitem">
49
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
50
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
51
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
52
<hr />
53
</div>
54
</news>', 1),
55
('circulation','ISSUEQSLIP','Issue Quick Slip','Issue Quick Slip', '<h3><<branches.branchname>></h3>
56
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
57
(<<borrowers.cardnumber>>) <br />
58
59
<<today>><br />
60
61
<h4>Checked Out Today</h4>
62
<checkedout>
63
<p>
64
<<biblio.title>> <br />
65
Barcode: <<items.barcode>><br />
66
Date due: <<issues.date_due>><br />
67
</p>
68
</checkedout>', 1),
69
('circulation','RESERVESLIP','Reserve Slip','Reserve Slip', '<h5>Date: <<today>></h5>
70
71
<h3> Transfer to/Hold in <<branches.branchname>></h3>
72
73
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
74
75
<ul>
76
    <li><<borrowers.cardnumber>></li>
77
    <li><<borrowers.phone>></li>
78
    <li> <<borrowers.address>><br />
79
         <<borrowers.address2>><br />
80
         <<borrowers.city >>  <<borrowers.zipcode>>
81
    </li>
82
    <li><<borrowers.email>></li>
83
</ul>
84
<br />
85
<h3>ITEM ON HOLD</h3>
86
<h4><<biblio.title>></h4>
87
<h5><<biblio.author>></h5>
88
<ul>
89
   <li><<items.barcode>></li>
90
   <li><<items.itemcallnumber>></li>
91
   <li><<reserves.waitingdate>></li>
92
</ul>
93
<p>Notes:
94
<pre><<reserves.reservenotes>></pre>
95
</p>
96
', 1),
97
('circulation','TRANSFERSLIP','Transfer Slip','Transfer Slip', '<h5>Date: <<today>></h5>
98
99
<h3>Transfer to <<branches.branchname>></h3>
100
101
<h3>ITEM</h3>
102
<h4><<biblio.title>></h4>
103
<h5><<biblio.author>></h5>
104
<ul>
105
   <li><<items.barcode>></li>
106
   <li><<items.itemcallnumber>></li>
107
</ul>', 1);
(-)a/installer/data/mysql/it-IT/necessari/userpermissions.sql (-4 / +3 lines)
Lines 22-29 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
22
   (13, 'label_creator', 'Crea etichette da stampare e barcodes dal catalogo e dai dati degli utenti'),
22
   (13, 'label_creator', 'Crea etichette da stampare e barcodes dal catalogo e dai dati degli utenti'),
23
   (13, 'edit_calendar', 'Definisci i giorni di chiusura della biblioteca'),
23
   (13, 'edit_calendar', 'Definisci i giorni di chiusura della biblioteca'),
24
   (13, 'moderate_comments', 'Modera i commenti degli utenti'),
24
   (13, 'moderate_comments', 'Modera i commenti degli utenti'),
25
   (13, 'edit_notices', 'Definisci gli avvisi'),
25
   (13, 'edit_notices', 'Definisci le notifiche'),
26
   (13, 'edit_notice_status_triggers', 'Imposta il messaggio o lo stato degli avvisi per le copie in ritardo'),
26
   (13, 'edit_notice_status_triggers', 'Imposta il messaggio o lo stato delle notifiche per le copie in ritardo'),
27
   (13, 'view_system_logs', 'Scorri i log di sistema'),
27
   (13, 'view_system_logs', 'Scorri i log di sistema'),
28
   (13, 'inventory', 'Lavora sugli inventari (stocktaking) del tuo catalogo'),
28
   (13, 'inventory', 'Lavora sugli inventari (stocktaking) del tuo catalogo'),
29
   (13, 'stage_marc_import', 'Opera sui Record MARC presenti nella zona di lavoro'),
29
   (13, 'stage_marc_import', 'Opera sui Record MARC presenti nella zona di lavoro'),
Lines 38-44 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
38
   (13, 'manage_csv_profiles', 'Gestisci i profili CSV di export'),
38
   (13, 'manage_csv_profiles', 'Gestisci i profili CSV di export'),
39
   (13, 'moderate_tags', 'Modera i tag inseriti dagli utenti'),
39
   (13, 'moderate_tags', 'Modera i tag inseriti dagli utenti'),
40
   (13, 'rotating_collections', 'Gestisci le collezioni circolanti (rotating collections)'),
40
   (13, 'rotating_collections', 'Gestisci le collezioni circolanti (rotating collections)'),
41
   (13, 'upload_local_cover_images', 'Upload local cover images'),
41
   (13, 'upload_local_cover_images', 'Carica copertine in locale'),
42
   (15, 'check_expiration', 'Controlla la scadenza di una risora in continuazione'),
42
   (15, 'check_expiration', 'Controlla la scadenza di una risora in continuazione'),
43
   (15, 'claim_serials', 'Richiedi i fascicoli non arrivati'),
43
   (15, 'claim_serials', 'Richiedi i fascicoli non arrivati'),
44
   (15, 'create_subscription', 'Crea un nuovo abbonamento'),
44
   (15, 'create_subscription', 'Crea un nuovo abbonamento'),
45
- 

Return to bug 7861