Attachment #8999 for bug #7861

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

Lines 1-5 Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_default_matching_rules.txt (-3 / +1 lines)
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

Line 1 Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.txt (-1 / +1 lines)
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.




-- MARC code list for Relators, taken from
-- http://www.loc.gov/marc/relators/relacode.html

INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','acp','Art copyist');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','act','Actor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','adp','Adapter');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aft','Author of afterword, colophon, etc.');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anl','Analyst');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anm','Animator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ann','Annotator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ant','Bibliographic antecedent');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','app','Applicant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aqt','Author in quotations or text abstracts');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arc','Architect');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ard','Artistic director');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arr','Arranger');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','art','Artist');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asg','Assignee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asn','Associated name');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','att','Attributed name');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','auc','Auctioneer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aud','Author of dialog');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aui','Author of introduction');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aus','Author of screenplay');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aut','Author');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bdd','Binding designer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bjd','Bookjacket designer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkd','Book designer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkp','Book producer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','blw','Blurb writer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bnd','Binder');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bpd','Bookplate designer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bsl','Bookseller');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ccp','Conceptor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','chr','Choreographer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clb','Collaborator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cli','Client');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cll','Calligrapher');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clr','Colorist');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clt','Collotyper');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmm','Commentator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmp','Composer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmt','Compositor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cng','Cinematographer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cnd','Conductor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cns','Censor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','coe','Contestant -appellee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','col','Collector');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','com','Compiler');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','con','Conservator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cos','Contestant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cot','Contestant -appellant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cov','Cover designer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpc','Copyright claimant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpe','Complainant-appellee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cph','Copyright holder');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpl','Complainant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpt','Complainant-appellant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cre','Creator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','crp','Correspondent');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','crr','Corrector');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csl','Consultant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csp','Consultant to a project');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cst','Costume designer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctb','Contributor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cte','Contestee-appellee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctg','Cartographer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctr','Contractor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cts','Contestee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctt','Contestee-appellant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cur','Curator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cwt','Commentator for written text');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfd','Defendant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfe','Defendant-appellee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dft','Defendant-appellant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dgg','Degree grantor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dis','Dissertant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dln','Delineator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnc','Dancer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnr','Donor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpb','Distribution place');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpc','Depicted');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpt','Depositor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drm','Draftsman');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drt','Director');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dsr','Designer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dst','Distributor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtc','Data contributor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dte','Dedicatee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtm','Data manager');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dto','Dedicator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dub','Dubious author');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','edt','Editor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','egr','Engraver');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elg','Electrician');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elt','Electrotyper');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','eng','Engineer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','etr','Etcher');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','evp','Event place');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','exp','Expert');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fac','Facsimilist');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fld','Field director');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','flm','Film editor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fmo','Former owner');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fpy','First party');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fnd','Funder');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','frg','Forger');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','gis','Geographic information specialist');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','-grt','Graphic technician');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hnr','Honoree');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hst','Host');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ill','Illustrator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ilu','Illuminator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ins','Inscriber');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','inv','Inventor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','itr','Instrumentalist');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ive','Interviewee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ivr','Interviewer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbr','Laboratory');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbt','Librettist');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ldr','Laboratory director');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','led','Lead');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lee','Libelee-appellee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lel','Libelee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','len','Lender');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','let','Libelee-appellant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lgd','Lighting designer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lie','Libelant-appellee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lil','Libelant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lit','Libelant-appellant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lsa','Landscape architect');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lse','Licensee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lso','Licensor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ltg','Lithographer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lyr','Lyricist');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mcp','Music copyist');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfp','Manufacture place');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfr','Manufacturer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mdc','Metadata contact');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mod','Moderator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mon','Monitor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrb','Marbler');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrk','Markup editor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','msd','Musical director');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mte','Metal-engraver');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mus','Musician');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','nrt','Narrator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','opn','Opponent');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','org','Originator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','orm','Organizer of meeting');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','oth','Other');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','own','Owner');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pat','Patron');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbd','Publishing director');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbl','Publisher');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pdr','Project director');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pfr','Proofreader');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pht','Photographer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','plt','Platemaker');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pma','Permitting agency');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pmn','Production manager');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pop','Printer of plates');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppm','Papermaker');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppt','Puppeteer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prc','Process contact');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prd','Production personnel');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prf','Performer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prg','Programmer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prm','Printmaker');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pro','Producer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prp','Production place');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prt','Printer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pta','Patent applicant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pte','Plaintiff -appellee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptf','Plaintiff');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pth','Patent holder');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptt','Plaintiff-appellant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pup','Publication place');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rbr','Rubricator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rce','Recording engineer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rcp','Recipient');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','red','Redactor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ren','Renderer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','res','Researcher');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rev','Reviewer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rps','Repository');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpt','Reporter');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpy','Responsible party');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rse','Respondent-appellee');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsg','Restager');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsp','Respondent');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rst','Respondent-appellant');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rth','Research team head');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rtm','Research team member');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sad','Scientific advisor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sce','Scenarist');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scl','Sculptor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scr','Scribe');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sds','Sound designer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sec','Secretary');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sgn','Signer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sht','Supporting host');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sng','Singer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spk','Speaker');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spn','Sponsor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spy','Second party');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','srv','Surveyor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','std','Set designer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stl','Storyteller');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stm','Stage manager');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stn','Standards body');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','str','Stereotyper');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tcd','Technical director');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tch','Teacher');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ths','Thesis advisor');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trc','Transcriber');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trl','Translator');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyd','Type designer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyg','Typographer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','uvp','University place');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','vdg','Videographer');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','voc','Vocalist');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wam','Writer of accompanying material');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wdc','Woodcutter');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wde','Wood-engraver');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wit','Witness');

Line 0 Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_relatorterms.txt (+1 lines)
	1	Lista codici MARC21 per tipologie autori, da http://www.loc.gov/marc/relators/relaterm.html

Lines 1-4 Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.txt (-1 / +1 lines)
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




-- Default UNIMARC matching rules for Koha
--
-- This file is part of Koha.
--
-- Koha is free software; you can redistribute it and/or modify it under the
-- terms of the GNU General Public License as published by the Free Software
-- Foundation; either version 2 of the License, or (at your option) any later
-- version.
--
-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY
-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
-- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License along with
-- Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
-- Suite 330, Boston, MA  02111-1307 USA

INSERT INTO marc_matchers (code, description, record_type, threshold)
    VALUES ('ISBN', '010$a', 'biblio', 1000);
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
    SELECT MAX(matchpoint_id), 1, '010', 'a' FROM matchpoints;
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
    SELECT MAX(matchpoint_component_id), 1, 'ISBN' FROM matchpoint_components;

INSERT INTO marc_matchers (code, description, record_type, threshold)
    VALUES ('ISSN', '011$a', 'biblio', 1000);
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
    SELECT MAX(matchpoint_id), 1, '011', 'a' FROM matchpoints;
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;

Line 0 Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_default_matching_rules.txt (+3 lines)
	1	Seleziona regole di corrispondenza secondo lo standard Unimarc:
	2	ISBN
	3	ISSN




-- Qualifiche per gli autori

INSERT INTO authorised_values (category, authorised_value, lib) VALUES
('qualif', '570', 'Altro'),
('qualif', '205', 'Collaboratore'),
('qualif', '210', 'Commentatore'),
('qualif', '571', 'Coordinatore'),
('qualif', '573', 'Diffusore'),
('qualif', '651', 'Direttore editoriale'),
('qualif', '650', 'Editore'),
('qualif', '440', 'Illustratore'),
('qualif', '075', 'Postfatore'),
('qualif', '080', 'Prefatore'),
('qualif', '574', 'Presentatore'),
('qualif', '710', 'Redattore'),
('qualif', '575', 'Responsabile'),
('qualif', '730', 'Traduttore'),
('qualif', '020', 'Chiosatore'),
('qualif', '723', 'Sponsor'),
('qualif', '675', 'Recensore'),
('qualif', '600', 'Fotografo'),
('qualif', '370', 'Film editor'),
('qualif', '673', 'Direttore'),
('qualif', '605', 'Presentatore'),
('qualif', '557', 'Organizzatore del congresso'),
('qualif', '340', 'Editor'),
('qualif', '727', 'Relatore di tesi'),
('qualif', '220', 'Compilatore'),
('qualif', '395', 'Fondatore'),
('qualif', '100', 'Autore dell''opere che è stata adattata'),
('qualif', '230', 'Compositore'),
('qualif', '520', 'Paroliere'),
('qualif', '295', 'Istituzione garante della tesi'),
('qualif', '010', 'Adattarore');

Line 0 Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_relatorterms.txt (+1 lines)
	1	Lista codici tipologie autori da UNIMARC, 3° edizione




SET FOREIGN_KEY_CHECKS=0;

-- To manage Yes/No
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Si','Si');

-- Reasons for acceptance or rejection of suggestions in acquisitions
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestseller');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Copia a scaffale danneggiata');

INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Disponibile via prestito ILL');

-- availability statuses
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOST','0','Non persa');
INSERT INTO authorised_values  (category, authorised_value, lib) VALUES ('LOST','2','Lungo ritardo (persa)');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOST','1','Persa');
INSERT INTO authorised_values  (category, authorised_value, lib ) VALUES ('LOST','3','Persa e pagata da');
INSERT INTO authorised_values  (category, authorised_value, lib )VALUES ('LOST','4','Mancante');

-- damaged status of an item
INSERT INTO authorised_values  (category, authorised_value, lib) VALUES ('DAMAGED','0','Non danneggiata');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('DAMAGED','1','Danneggiata');

-- location qualification for an item, departments are linked by default to items.location
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','FIC','Fiction');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','CHILD','Area bambini');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','DISPLAY','A scaffale aperto');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','NEW','Scaffale novitÃ ');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','STAFF','Ufficio staff');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','GEN','Sezione generale');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','AV','Audiovideo');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','REF','Strumenti di reference');

-- collection codes for an item
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','REF','Strumenti di reference');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');

-- withdrawn status of an item, linked to items.wthdrawn
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('WITHDRAWN','0','Non ritirata');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ritirata dalla circolazione');

-- loanability status of an item, linked to items.notforloan
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordinato');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('NOT_LOAN','0','Per il prestito');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Non per il prestito');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Uso interno');

-- restricted status of an item, linked to items.restricted
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RESTRICTED','0','Nessuna restrizione');
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RESTRICTED','1','Accesso limitato');

-- manual invoice types
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MANUAL_INV','Costo fotocopie','.25');

-- custom borrower notes
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Indirizzo (Nota)');

-- Qualifiche per gli autori

-- OPAC Suggestions reasons
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','La copia disponibile Ã¨ danneggiata','La copia disponibile Ã¨ danneggiata');
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');
('qualif', '210', 'Commentatore'),
('qualif', '571', 'Coordinatore'),
('qualif', '573', 'Diffusore'),
('qualif', '651', 'Direttore editoriale'),
('qualif', '650', 'Editore'),
('qualif', '440', 'Illustratore'),
('qualif', '075', 'Postfatore'),
('qualif', '080', 'Prefatore'),
('qualif', '574', 'Presentatore'),
('qualif', '710', 'Redattore'),
('qualif', '575', 'Responsabile'),
('qualif', '730', 'Traduttore'),
('qualif', '020', 'Chiosatore'),
('qualif', '723', 'Sponsor'),
('qualif', '675', 'Recensore'),
('qualif', '600', 'Fotografo'),
('qualif', '370', 'Film editor'),
('qualif', '673', 'Direttore'),
('qualif', '605', 'Presentatore'),
('qualif', '557', 'Organizzatore del congresso'),
('qualif', '340', 'Editor'),
('qualif', '727', 'Relatore di tesi'),
('qualif', '220', 'Compilatore'),
('qualif', '395', 'Fondatore'),
('qualif', '100', 'Autore dell''opere che Ã¨ stata adattata'),
('qualif', '230', 'Compositore'),
('qualif', '520', 'Paroliere'),
('qualif', '295', 'Istituzione garante della tesi'),
('qualif', '010', 'Adattarore');

-- Codici dei Paesi (COUNTRY)
INSERT INTO authorised_values (category, authorised_value, lib) VALUES
('COUNTRY', 'IT', 'Italia'),
('COUNTRY', 'US', 'Stati Uniti'),
('COUNTRY', 'GB', 'Regno Unito - UK '),

('COUNTRY', 'IN', 'India');

-- Codici delle lingue (LANG)
INSERT INTO authorised_values (category, authorised_value, lib) VALUES
('LANG', 'ita', 'italiano'),
('LANG', 'eng', 'inglese'),
('LANG', 'ger', 'tedesco'),

('LANG', 'lat', 'latino');

SET FOREIGN_KEY_CHECKS=1;





INSERT INTO letter (module, code, name, title, content)
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'),
('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>'),
('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.'),

('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>>'),
('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>>'),
('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>>');
INSERT INTO letter (module, code, name, title, content, is_html)
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(<<borrowers.cardnumber>>) <br />

<<today>><br />

<h4>Checked Out</h4>
<checkedout>
<p>
<<biblio.title>> <br />
Barcode: <<items.barcode>><br />
Date due: <<issues.date_due>><br />
</p>
</checkedout>

<h4>Overdues</h4>
<overdue>
<p>
<<biblio.title>> <br />
Barcode: <<items.barcode>><br />
Date due: <<issues.date_due>><br />
</p>
</overdue>

<hr>

<h4 style="text-align: center; font-style:italic;">News</h4>
<news>
<div class="newsitem">
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
<hr />
</div>
</news>', 1),
('circulation','ISSUEQSLIP','Issue Quick Slip','Issue Quick Slip', '<h3><<branches.branchname>></h3>
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(<<borrowers.cardnumber>>) <br />

<<today>><br />

<h4>Checked Out Today</h4>
<checkedout>
<p>
<<biblio.title>> <br />
Barcode: <<items.barcode>><br />
Date due: <<issues.date_due>><br />
</p>
</checkedout>', 1),
('circulation','RESERVESLIP','Reserve Slip','Reserve Slip', '<h5>Date: <<today>></h5>

<h3> Transfer to/Hold in <<branches.branchname>></h3>

<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>

<ul>
    <li><<borrowers.cardnumber>></li>
    <li><<borrowers.phone>></li>
    <li> <<borrowers.address>><br />
         <<borrowers.address2>><br />
         <<borrowers.city >>  <<borrowers.zipcode>>
    </li>
    <li><<borrowers.email>></li>
</ul>
<br />
<h3>ITEM ON HOLD</h3>
<h4><<biblio.title>></h4>
<h5><<biblio.author>></h5>
<ul>
   <li><<items.barcode>></li>
   <li><<items.itemcallnumber>></li>
   <li><<reserves.waitingdate>></li>
</ul>
<p>Notes:
<pre><<reserves.reservenotes>></pre>
</p>
', 1),
('circulation','TRANSFERSLIP','Transfer Slip','Transfer Slip', '<h5>Date: <<today>></h5>

<h3>Transfer to <<branches.branchname>></h3>

<h3>ITEM</h3>
<h4><<biblio.title>></h4>
<h5><<biblio.author>></h5>
<ul>
   <li><<items.barcode>></li>
   <li><<items.itemcallnumber>></li>
</ul>', 1);




   (13, 'label_creator', 'Crea etichette da stampare e barcodes dal catalogo e dai dati degli utenti'),
   (13, 'edit_calendar', 'Definisci i giorni di chiusura della biblioteca'),
   (13, 'moderate_comments', 'Modera i commenti degli utenti'),
   (13, 'edit_notices', 'Definisci le notifiche'),
   (13, 'edit_notice_status_triggers', 'Imposta il messaggio o lo stato delle notifiche per le copie in ritardo'),
   (13, 'view_system_logs', 'Scorri i log di sistema'),
   (13, 'inventory', 'Lavora sugli inventari (stocktaking) del tuo catalogo'),
   (13, 'stage_marc_import', 'Opera sui Record MARC presenti nella zona di lavoro'),

   (13, 'manage_csv_profiles', 'Gestisci i profili CSV di export'),
   (13, 'moderate_tags', 'Modera i tag inseriti dagli utenti'),
   (13, 'rotating_collections', 'Gestisci le collezioni circolanti (rotating collections)'),
   (13, 'upload_local_cover_images', 'Carica copertine in locale'),
   (15, 'check_expiration', 'Controlla la scadenza di una risora in continuazione'),
   (15, 'claim_serials', 'Richiedi i fascicoli non arrivati'),
   (15, 'create_subscription', 'Crea un nuovo abbonamento'),
- 

Return to bug 7861

Lines 1431-1437 insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql (-2 / +2 lines)
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);

Line 0 Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_default_matching_rules.sql (+34 lines)
	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;

Line 0 Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_relatorterms.sql (+34 lines)
	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');

Lines 1-5 Link Here

(-)a/installer/data/mysql/it-IT/necessari/auth_val.sql (-65 / +37 lines)
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

Lines 1-4 Link Here

(-)a/installer/data/mysql/it-IT/necessari/notices.sql (-1 / +90 lines)
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);

Lines 22-29 INSERT INTO permissions (module_bit, code, description) VALUES Link Here

(-)a/installer/data/mysql/it-IT/necessari/userpermissions.sql (-4 / +3 lines)
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	-