From 75803ffc9c0deac728da9d274c95c35e886b6e14 Mon Sep 17 00:00:00 2001 From: Zeno Tajoli Date: Sat, 31 Mar 2012 17:42:52 +0200 Subject: [PATCH] [BUG 7861] Update of italian sql files for 3.8 Content-Type: text/plain; charset="utf-8" --- .../optional/marc21_default_matching_rules.txt | 4 +- .../marc21/optional/marc21_fastadd_framework.txt | 2 +- .../marc21/optional/marc21_relatorterms.sql | 226 ++++++++++++++++++++ .../marc21/optional/marc21_relatorterms.txt | 1 + .../optional/marc21_simple_bib_frameworks.txt | 20 +- .../unimarc/necessari/unimarc_framework.sql | 4 +- .../opzionali/unimarc_default_matching_rules.sql | 35 +++ .../opzionali/unimarc_default_matching_rules.txt | 3 + .../unimarc/opzionali/unimarc_relatorterms.sql | 34 +++ .../unimarc/opzionali/unimarc_relatorterms.txt | 1 + installer/data/mysql/it-IT/necessari/auth_val.sql | 193 +++++++---------- installer/data/mysql/it-IT/necessari/notices.sql | 91 ++++++++- .../data/mysql/it-IT/necessari/userpermissions.sql | 6 +- 13 files changed, 490 insertions(+), 130 deletions(-) create mode 100644 installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_relatorterms.sql create mode 100644 installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_relatorterms.txt rewrite installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.txt (66%) create mode 100644 installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_default_matching_rules.sql create mode 100644 installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_default_matching_rules.txt create mode 100644 installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_relatorterms.sql create mode 100644 installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_relatorterms.txt rewrite installer/data/mysql/it-IT/necessari/auth_val.sql (74%) diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_default_matching_rules.txt b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_default_matching_rules.txt index 471db24..b452753 100644 --- a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_default_matching_rules.txt +++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_default_matching_rules.txt @@ -1,5 +1,3 @@ -Selected matching rules for MARC 21 bibliographic -records, including: - +Inserisci regole di corrispondenza per records MARC21 che includono: ISBN ISSN diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.txt b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.txt index a183658..a59e3c2 100644 --- a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.txt +++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.txt @@ -1 +1 @@ -'FA', a 'Fast Add' minimal MARC21 framework suitable for ILL or on-the-fly cataloguing. +'FA', una griglia di catalogazione minimale, 'FAST' per ILL o ctalogazionone al volo. diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_relatorterms.sql b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_relatorterms.sql new file mode 100644 index 0000000..485bbed --- /dev/null +++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_relatorterms.sql @@ -0,0 +1,226 @@ +-- 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'); diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_relatorterms.txt b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_relatorterms.txt new file mode 100644 index 0000000..7d4971a --- /dev/null +++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_relatorterms.txt @@ -0,0 +1 @@ +Lista codici MARC21 per tipologie autori, da http://www.loc.gov/marc/relators/relaterm.html diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.txt b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.txt dissimilarity index 66% index cf49dc3..7a3ac23 100644 --- a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.txt +++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.txt @@ -1,10 +1,10 @@ -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: - -BKS Books, Booklets, Workbooks -CF CD-ROMs, DVD-ROMs, General Online Resources -SR Audio Cassettes, CDs -VR DVDs, VHS -AR Models -KT Kits -IR Binders -SER Serials +Alcune griglie predefinite per i materiali piu' comuni: + +BKS Books, Booklets, Workbooks +CF CD-ROMs, DVD-ROMs, General Online Resources +SR Audio Cassettes, CDs +VR DVDs, VHS +AR Models +KT Kits +IR Binders +SER Serials diff --git a/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql b/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql index 27929db..d400e85 100644 --- a/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql +++ b/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql @@ -1431,7 +1431,7 @@ insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('200','i','Nome della parte','',1,0,'',2,'','','',NULL,0,'MN',NULL,NULL,NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('200','v','Indicazione Volume','',0,0,'',2,'','','',NULL,0,'MN',NULL,NULL,NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('200','z','Lingua titolo parallelo','',1,0,'',2,'','','',NULL,0,'MN',NULL,NULL,NULL); -insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('205','a','Formulazione di edizione','',0,0,'',2,'','','',NULL,0,'MN','',NULL,NULL); +insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('205','a','Formulazione di edizione','',0,0,'biblioitems.editionstatement',2,'','','',NULL,0,'MN','',NULL,NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('205','b','Formulazione aggiuntiva di edizione','',1,0,'',2,'','','',NULL,0,'MN','',NULL,NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('205','d','Formulazione parallela di edizione','',1,0,'',2,'','','',NULL,0,'MN','',NULL,NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('205','f','Formulazione di responsabilità relativa all\'edizione','',1,0,'',2,'','','',NULL,0,'MN','',NULL,NULL); @@ -1761,7 +1761,7 @@ insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('200','i','Nome della parte','',1,0,'',2,'','','',NULL,0,'PR',NULL,NULL,NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('200','v','Indicazione Volume','',0,0,'',2,'','','',NULL,0,'PR',NULL,NULL,NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('200','z','Lingua titolo parallelo','',1,0,'',2,'','','',NULL,0,'PR',NULL,NULL,NULL); -insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('205','a','Formulazione di edizione','',0,0,'',2,'','','',NULL,0,'PR','',NULL,NULL); +insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('205','a','Formulazione di edizione','',0,0,'biblioitems.editionstatement',2,'','','',NULL,0,'PR','',NULL,NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('205','b','Formulazione aggiuntiva di edizione','',1,0,'',2,'','','',NULL,0,'PR','',NULL,NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('205','d','Formulazione parallela di edizione','',1,0,'',2,'','','',NULL,0,'PR','',NULL,NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('205','f','Formulazione di responsabilità relativa all\'edizione','',1,0,'',2,'','','',NULL,0,'PR','',NULL,NULL); diff --git a/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_default_matching_rules.sql b/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_default_matching_rules.sql new file mode 100644 index 0000000..77866fd --- /dev/null +++ b/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_default_matching_rules.sql @@ -0,0 +1,35 @@ +-- 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; + diff --git a/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_default_matching_rules.txt b/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_default_matching_rules.txt new file mode 100644 index 0000000..21b8bde --- /dev/null +++ b/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_default_matching_rules.txt @@ -0,0 +1,3 @@ +Seleziona regole di corrispondenza secondo lo standard Unimarc: +ISBN +ISSN diff --git a/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_relatorterms.sql b/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_relatorterms.sql new file mode 100644 index 0000000..d44b6ad --- /dev/null +++ b/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_relatorterms.sql @@ -0,0 +1,34 @@ +-- 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'); \ No newline at end of file diff --git a/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_relatorterms.txt b/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_relatorterms.txt new file mode 100644 index 0000000..01c95ff --- /dev/null +++ b/installer/data/mysql/it-IT/marcflavour/unimarc/opzionali/unimarc_relatorterms.txt @@ -0,0 +1 @@ +Lista codici tipologie autori da UNIMARC, 3° edizione \ No newline at end of file diff --git a/installer/data/mysql/it-IT/necessari/auth_val.sql b/installer/data/mysql/it-IT/necessari/auth_val.sql dissimilarity index 74% index 01a2e8f..42436a0 100644 --- a/installer/data/mysql/it-IT/necessari/auth_val.sql +++ b/installer/data/mysql/it-IT/necessari/auth_val.sql @@ -1,110 +1,83 @@ -SET FOREIGN_KEY_CHECKS=0; - --- 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','LCL','Copia della biblioteca persa'); -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 - -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'); - --- 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', 'DE', 'Germania'), -('COUNTRY', 'FR', 'Francia'), -('COUNTRY', 'VA', 'Vaticano'), -('COUNTRY', 'CN', 'Cina'), -('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', 'fre', 'francese'), -('LANG', 'lat', 'latino'); - -SET FOREIGN_KEY_CHECKS=1; - +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','LCL','Copia della biblioteca persa'); +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)'); + +-- 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'); + +-- 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', 'DE', 'Germania'), +('COUNTRY', 'FR', 'Francia'), +('COUNTRY', 'VA', 'Vaticano'), +('COUNTRY', 'CN', 'Cina'), +('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', 'fre', 'francese'), +('LANG', 'lat', 'latino'); + +SET FOREIGN_KEY_CHECKS=1; + diff --git a/installer/data/mysql/it-IT/necessari/notices.sql b/installer/data/mysql/it-IT/necessari/notices.sql index 0450bd0..3f48994 100644 --- a/installer/data/mysql/it-IT/necessari/notices.sql +++ b/installer/data/mysql/it-IT/necessari/notices.sql @@ -1,4 +1,4 @@ -INSERT INTO `letter` (module, code, name, title, content) +INSERT INTO letter (module, code, name, title, content) VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <> <>,\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<>\n<>\n<> <>\nPhone: <>\nFax: <>\nEmail: <>\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"<>" by <>, <>, Barcode: <> Fine: GBP\n\nThank-you for your prompt attention to this matter.\n\n<> Staff\n'), ('claimacquisition','ACQCLAIM','Acquisition Claim','Item Not Received','<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n\r\nOrdernumber <> (<>) (<> ordered) ($<> each) has not been received.'), ('serial','RLIST','Routing List','Serial is now available','<> <>,\r\n\r\nThe following issue is now available:\r\n\r\n<>, <> (<>)\r\n\r\nPlease pick it up at your convenience.'), @@ -16,3 +16,92 @@ VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\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 <>.\n\nThank you,\n\n<>'), ('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\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 <>\n\nThank you,\n\n<>'), ('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <>\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>'); +INSERT INTO letter (module, code, name, title, content, is_html) +VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '

<>

+Checked out to <> <> <> <>
+(<>)
+ +<>
+ +

Checked Out

+ +

+<>
+Barcode: <>
+Date due: <>
+

+
+ +

Overdues

+ +

+<>
+Barcode: <>
+Date due: <>
+

+
+ +
+ +

News

+ +
+
<>
+

<>

+

Posted on <>

+
+
+
', 1), +('circulation','ISSUEQSLIP','Issue Quick Slip','Issue Quick Slip', '

<>

+Checked out to <> <> <> <>
+(<>)
+ +<>
+ +

Checked Out Today

+ +

+<>
+Barcode: <>
+Date due: <>
+

+
', 1), +('circulation','RESERVESLIP','Reserve Slip','Reserve Slip', '
Date: <>
+ +

Transfer to/Hold in <>

+ +

<>, <>

+ +
    +
  • <>
  • +
  • <>
  • +
  • <>
    + <>
    + <> <> +
  • +
  • <>
  • +
+
+

ITEM ON HOLD

+

<>

+
<>
+
    +
  • <>
  • +
  • <>
  • +
  • <>
  • +
+

Notes: +

<>
+

+', 1), +('circulation','TRANSFERSLIP','Transfer Slip','Transfer Slip', '
Date: <>
+ +

Transfer to <>

+ +

ITEM

+

<>

+
<>
+
    +
  • <>
  • +
  • <>
  • +
', 1); \ No newline at end of file diff --git a/installer/data/mysql/it-IT/necessari/userpermissions.sql b/installer/data/mysql/it-IT/necessari/userpermissions.sql index 926b47c..9a064a0 100644 --- a/installer/data/mysql/it-IT/necessari/userpermissions.sql +++ b/installer/data/mysql/it-IT/necessari/userpermissions.sql @@ -22,8 +22,8 @@ INSERT INTO permissions (module_bit, code, description) VALUES (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 gli avvisi'), - (13, 'edit_notice_status_triggers', 'Imposta il messaggio o lo stato degli avvisi per le copie in ritardo'), + (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'), @@ -38,7 +38,7 @@ INSERT INTO permissions (module_bit, code, description) VALUES (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', 'Upload local cover images'), + (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'), -- 1.7.3.1.msysgit.0