From 6ddfd95376611be60125f623998f577eb82e853d Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Tue, 4 Feb 2020 21:17:00 -0300 Subject: [PATCH] Bug 24584: Rewrite optional/marc21_relatorterms to YAML YAML version of optional marc21_relatorterms To test: 1) Same test plan of first patch, only check table authorised_values Signed-off-by: Martin Renvoize --- .../mysql/en/optional/marc21_relatorterms.sql | 226 ----- .../mysql/en/optional/marc21_relatorterms.txt | 1 - .../mysql/en/optional/marc21_relatorterms.yml | 919 ++++++++++++++++++ 3 files changed, 919 insertions(+), 227 deletions(-) delete mode 100644 installer/data/mysql/en/optional/marc21_relatorterms.sql delete mode 100644 installer/data/mysql/en/optional/marc21_relatorterms.txt create mode 100644 installer/data/mysql/en/optional/marc21_relatorterms.yml diff --git a/installer/data/mysql/en/optional/marc21_relatorterms.sql b/installer/data/mysql/en/optional/marc21_relatorterms.sql deleted file mode 100644 index 485bbedfa0..0000000000 --- a/installer/data/mysql/en/optional/marc21_relatorterms.sql +++ /dev/null @@ -1,226 +0,0 @@ --- 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/en/optional/marc21_relatorterms.txt b/installer/data/mysql/en/optional/marc21_relatorterms.txt deleted file mode 100644 index 5cbf709a58..0000000000 --- a/installer/data/mysql/en/optional/marc21_relatorterms.txt +++ /dev/null @@ -1 +0,0 @@ -MARC code list for relators, as of http://www.loc.gov/marc/relators/relaterm.html diff --git a/installer/data/mysql/en/optional/marc21_relatorterms.yml b/installer/data/mysql/en/optional/marc21_relatorterms.yml new file mode 100644 index 0000000000..0698acd1dc --- /dev/null +++ b/installer/data/mysql/en/optional/marc21_relatorterms.yml @@ -0,0 +1,919 @@ +--- +# +# Copyright 2020 Koha Development Team +# +# 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., +# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. +# + +description: + - "MARC code list for relators, as of http://www.loc.gov/marc/relators/relaterm.html" + +tables: + - authorised_values: + translatable: [ lib ] + multiline: [] + rows: + - category: "RELTERMS" + authorised_value: "acp" + lib: "Art copyist" + + - category: "RELTERMS" + authorised_value: "act" + lib: "Actor" + + - category: "RELTERMS" + authorised_value: "adp" + lib: "Adapter" + + - category: "RELTERMS" + authorised_value: "aft" + lib: "Author of afterword, colophon, etc." + + - category: "RELTERMS" + authorised_value: "anl" + lib: "Analyst" + + - category: "RELTERMS" + authorised_value: "anm" + lib: "Animator" + + - category: "RELTERMS" + authorised_value: "ann" + lib: "Annotator" + + - category: "RELTERMS" + authorised_value: "ant" + lib: "Bibliographic antecedent" + + - category: "RELTERMS" + authorised_value: "app" + lib: "Applicant" + + - category: "RELTERMS" + authorised_value: "aqt" + lib: "Author in quotations or text abstracts" + + - category: "RELTERMS" + authorised_value: "arc" + lib: "Architect" + + - category: "RELTERMS" + authorised_value: "ard" + lib: "Artistic director" + + - category: "RELTERMS" + authorised_value: "arr" + lib: "Arranger" + + - category: "RELTERMS" + authorised_value: "art" + lib: "Artist" + + - category: "RELTERMS" + authorised_value: "asg" + lib: "Assignee" + + - category: "RELTERMS" + authorised_value: "asn" + lib: "Associated name" + + - category: "RELTERMS" + authorised_value: "att" + lib: "Attributed name" + + - category: "RELTERMS" + authorised_value: "auc" + lib: "Auctioneer" + + - category: "RELTERMS" + authorised_value: "aud" + lib: "Author of dialog" + + - category: "RELTERMS" + authorised_value: "aui" + lib: "Author of introduction" + + - category: "RELTERMS" + authorised_value: "aus" + lib: "Author of screenplay" + + - category: "RELTERMS" + authorised_value: "aut" + lib: "Author" + + - category: "RELTERMS" + authorised_value: "bdd" + lib: "Binding designer" + + - category: "RELTERMS" + authorised_value: "bjd" + lib: "Bookjacket designer" + + - category: "RELTERMS" + authorised_value: "bkd" + lib: "Book designer" + + - category: "RELTERMS" + authorised_value: "bkp" + lib: "Book producer" + + - category: "RELTERMS" + authorised_value: "blw" + lib: "Blurb writer" + + - category: "RELTERMS" + authorised_value: "bnd" + lib: "Binder" + + - category: "RELTERMS" + authorised_value: "bpd" + lib: "Bookplate designer" + + - category: "RELTERMS" + authorised_value: "bsl" + lib: "Bookseller" + + - category: "RELTERMS" + authorised_value: "ccp" + lib: "Conceptor" + + - category: "RELTERMS" + authorised_value: "chr" + lib: "Choreographer" + + - category: "RELTERMS" + authorised_value: "clb" + lib: "Collaborator" + + - category: "RELTERMS" + authorised_value: "cli" + lib: "Client" + + - category: "RELTERMS" + authorised_value: "cll" + lib: "Calligrapher" + + - category: "RELTERMS" + authorised_value: "clr" + lib: "Colorist" + + - category: "RELTERMS" + authorised_value: "clt" + lib: "Collotyper" + + - category: "RELTERMS" + authorised_value: "cmm" + lib: "Commentator" + + - category: "RELTERMS" + authorised_value: "cmp" + lib: "Composer" + + - category: "RELTERMS" + authorised_value: "cmt" + lib: "Compositor" + + - category: "RELTERMS" + authorised_value: "cng" + lib: "Cinematographer" + + - category: "RELTERMS" + authorised_value: "cnd" + lib: "Conductor" + + - category: "RELTERMS" + authorised_value: "cns" + lib: "Censor" + + - category: "RELTERMS" + authorised_value: "coe" + lib: "Contestant -appellee" + + - category: "RELTERMS" + authorised_value: "col" + lib: "Collector" + + - category: "RELTERMS" + authorised_value: "com" + lib: "Compiler" + + - category: "RELTERMS" + authorised_value: "con" + lib: "Conservator" + + - category: "RELTERMS" + authorised_value: "cos" + lib: "Contestant" + + - category: "RELTERMS" + authorised_value: "cot" + lib: "Contestant -appellant" + + - category: "RELTERMS" + authorised_value: "cov" + lib: "Cover designer" + + - category: "RELTERMS" + authorised_value: "cpc" + lib: "Copyright claimant" + + - category: "RELTERMS" + authorised_value: "cpe" + lib: "Complainant-appellee" + + - category: "RELTERMS" + authorised_value: "cph" + lib: "Copyright holder" + + - category: "RELTERMS" + authorised_value: "cpl" + lib: "Complainant" + + - category: "RELTERMS" + authorised_value: "cpt" + lib: "Complainant-appellant" + + - category: "RELTERMS" + authorised_value: "cre" + lib: "Creator" + + - category: "RELTERMS" + authorised_value: "crp" + lib: "Correspondent" + + - category: "RELTERMS" + authorised_value: "crr" + lib: "Corrector" + + - category: "RELTERMS" + authorised_value: "csl" + lib: "Consultant" + + - category: "RELTERMS" + authorised_value: "csp" + lib: "Consultant to a project" + + - category: "RELTERMS" + authorised_value: "cst" + lib: "Costume designer" + + - category: "RELTERMS" + authorised_value: "ctb" + lib: "Contributor" + + - category: "RELTERMS" + authorised_value: "cte" + lib: "Contestee-appellee" + + - category: "RELTERMS" + authorised_value: "ctg" + lib: "Cartographer" + + - category: "RELTERMS" + authorised_value: "ctr" + lib: "Contractor" + + - category: "RELTERMS" + authorised_value: "cts" + lib: "Contestee" + + - category: "RELTERMS" + authorised_value: "ctt" + lib: "Contestee-appellant" + + - category: "RELTERMS" + authorised_value: "cur" + lib: "Curator" + + - category: "RELTERMS" + authorised_value: "cwt" + lib: "Commentator for written text" + + - category: "RELTERMS" + authorised_value: "dfd" + lib: "Defendant" + + - category: "RELTERMS" + authorised_value: "dfe" + lib: "Defendant-appellee" + + - category: "RELTERMS" + authorised_value: "dft" + lib: "Defendant-appellant" + + - category: "RELTERMS" + authorised_value: "dgg" + lib: "Degree grantor" + + - category: "RELTERMS" + authorised_value: "dis" + lib: "Dissertant" + + - category: "RELTERMS" + authorised_value: "dln" + lib: "Delineator" + + - category: "RELTERMS" + authorised_value: "dnc" + lib: "Dancer" + + - category: "RELTERMS" + authorised_value: "dnr" + lib: "Donor" + + - category: "RELTERMS" + authorised_value: "dpb" + lib: "Distribution place" + + - category: "RELTERMS" + authorised_value: "dpc" + lib: "Depicted" + + - category: "RELTERMS" + authorised_value: "dpt" + lib: "Depositor" + + - category: "RELTERMS" + authorised_value: "drm" + lib: "Draftsman" + + - category: "RELTERMS" + authorised_value: "drt" + lib: "Director" + + - category: "RELTERMS" + authorised_value: "dsr" + lib: "Designer" + + - category: "RELTERMS" + authorised_value: "dst" + lib: "Distributor" + + - category: "RELTERMS" + authorised_value: "dtc" + lib: "Data contributor" + + - category: "RELTERMS" + authorised_value: "dte" + lib: "Dedicatee" + + - category: "RELTERMS" + authorised_value: "dtm" + lib: "Data manager" + + - category: "RELTERMS" + authorised_value: "dto" + lib: "Dedicator" + + - category: "RELTERMS" + authorised_value: "dub" + lib: "Dubious author" + + - category: "RELTERMS" + authorised_value: "edt" + lib: "Editor" + + - category: "RELTERMS" + authorised_value: "egr" + lib: "Engraver" + + - category: "RELTERMS" + authorised_value: "elg" + lib: "Electrician" + + - category: "RELTERMS" + authorised_value: "elt" + lib: "Electrotyper" + + - category: "RELTERMS" + authorised_value: "eng" + lib: "Engineer" + + - category: "RELTERMS" + authorised_value: "etr" + lib: "Etcher" + + - category: "RELTERMS" + authorised_value: "evp" + lib: "Event place" + + - category: "RELTERMS" + authorised_value: "exp" + lib: "Expert" + + - category: "RELTERMS" + authorised_value: "fac" + lib: "Facsimilist" + + - category: "RELTERMS" + authorised_value: "fld" + lib: "Field director" + + - category: "RELTERMS" + authorised_value: "flm" + lib: "Film editor" + + - category: "RELTERMS" + authorised_value: "fmo" + lib: "Former owner" + + - category: "RELTERMS" + authorised_value: "fpy" + lib: "First party" + + - category: "RELTERMS" + authorised_value: "fnd" + lib: "Funder" + + - category: "RELTERMS" + authorised_value: "frg" + lib: "Forger" + + - category: "RELTERMS" + authorised_value: "gis" + lib: "Geographic information specialist" + + - category: "RELTERMS" + authorised_value: "-grt" + lib: "Graphic technician" + + - category: "RELTERMS" + authorised_value: "hnr" + lib: "Honoree" + + - category: "RELTERMS" + authorised_value: "hst" + lib: "Host" + + - category: "RELTERMS" + authorised_value: "ill" + lib: "Illustrator" + + - category: "RELTERMS" + authorised_value: "ilu" + lib: "Illuminator" + + - category: "RELTERMS" + authorised_value: "ins" + lib: "Inscriber" + + - category: "RELTERMS" + authorised_value: "inv" + lib: "Inventor" + + - category: "RELTERMS" + authorised_value: "itr" + lib: "Instrumentalist" + + - category: "RELTERMS" + authorised_value: "ive" + lib: "Interviewee" + + - category: "RELTERMS" + authorised_value: "ivr" + lib: "Interviewer" + + - category: "RELTERMS" + authorised_value: "lbr" + lib: "Laboratory" + + - category: "RELTERMS" + authorised_value: "lbt" + lib: "Librettist" + + - category: "RELTERMS" + authorised_value: "ldr" + lib: "Laboratory director" + + - category: "RELTERMS" + authorised_value: "led" + lib: "Lead" + + - category: "RELTERMS" + authorised_value: "lee" + lib: "Libelee-appellee" + + - category: "RELTERMS" + authorised_value: "lel" + lib: "Libelee" + + - category: "RELTERMS" + authorised_value: "len" + lib: "Lender" + + - category: "RELTERMS" + authorised_value: "let" + lib: "Libelee-appellant" + + - category: "RELTERMS" + authorised_value: "lgd" + lib: "Lighting designer" + + - category: "RELTERMS" + authorised_value: "lie" + lib: "Libelant-appellee" + + - category: "RELTERMS" + authorised_value: "lil" + lib: "Libelant" + + - category: "RELTERMS" + authorised_value: "lit" + lib: "Libelant-appellant" + + - category: "RELTERMS" + authorised_value: "lsa" + lib: "Landscape architect" + + - category: "RELTERMS" + authorised_value: "lse" + lib: "Licensee" + + - category: "RELTERMS" + authorised_value: "lso" + lib: "Licensor" + + - category: "RELTERMS" + authorised_value: "ltg" + lib: "Lithographer" + + - category: "RELTERMS" + authorised_value: "lyr" + lib: "Lyricist" + + - category: "RELTERMS" + authorised_value: "mcp" + lib: "Music copyist" + + - category: "RELTERMS" + authorised_value: "mfp" + lib: "Manufacture place" + + - category: "RELTERMS" + authorised_value: "mfr" + lib: "Manufacturer" + + - category: "RELTERMS" + authorised_value: "mdc" + lib: "Metadata contact" + + - category: "RELTERMS" + authorised_value: "mod" + lib: "Moderator" + + - category: "RELTERMS" + authorised_value: "mon" + lib: "Monitor" + + - category: "RELTERMS" + authorised_value: "mrb" + lib: "Marbler" + + - category: "RELTERMS" + authorised_value: "mrk" + lib: "Markup editor" + + - category: "RELTERMS" + authorised_value: "msd" + lib: "Musical director" + + - category: "RELTERMS" + authorised_value: "mte" + lib: "Metal-engraver" + + - category: "RELTERMS" + authorised_value: "mus" + lib: "Musician" + + - category: "RELTERMS" + authorised_value: "nrt" + lib: "Narrator" + + - category: "RELTERMS" + authorised_value: "opn" + lib: "Opponent" + + - category: "RELTERMS" + authorised_value: "org" + lib: "Originator" + + - category: "RELTERMS" + authorised_value: "orm" + lib: "Organizer of meeting" + + - category: "RELTERMS" + authorised_value: "oth" + lib: "Other" + + - category: "RELTERMS" + authorised_value: "own" + lib: "Owner" + + - category: "RELTERMS" + authorised_value: "pat" + lib: "Patron" + + - category: "RELTERMS" + authorised_value: "pbd" + lib: "Publishing director" + + - category: "RELTERMS" + authorised_value: "pbl" + lib: "Publisher" + + - category: "RELTERMS" + authorised_value: "pdr" + lib: "Project director" + + - category: "RELTERMS" + authorised_value: "pfr" + lib: "Proofreader" + + - category: "RELTERMS" + authorised_value: "pht" + lib: "Photographer" + + - category: "RELTERMS" + authorised_value: "plt" + lib: "Platemaker" + + - category: "RELTERMS" + authorised_value: "pma" + lib: "Permitting agency" + + - category: "RELTERMS" + authorised_value: "pmn" + lib: "Production manager" + + - category: "RELTERMS" + authorised_value: "pop" + lib: "Printer of plates" + + - category: "RELTERMS" + authorised_value: "ppm" + lib: "Papermaker" + + - category: "RELTERMS" + authorised_value: "ppt" + lib: "Puppeteer" + + - category: "RELTERMS" + authorised_value: "prc" + lib: "Process contact" + + - category: "RELTERMS" + authorised_value: "prd" + lib: "Production personnel" + + - category: "RELTERMS" + authorised_value: "prf" + lib: "Performer" + + - category: "RELTERMS" + authorised_value: "prg" + lib: "Programmer" + + - category: "RELTERMS" + authorised_value: "prm" + lib: "Printmaker" + + - category: "RELTERMS" + authorised_value: "pro" + lib: "Producer" + + - category: "RELTERMS" + authorised_value: "prp" + lib: "Production place" + + - category: "RELTERMS" + authorised_value: "prt" + lib: "Printer" + + - category: "RELTERMS" + authorised_value: "pta" + lib: "Patent applicant" + + - category: "RELTERMS" + authorised_value: "pte" + lib: "Plaintiff -appellee" + + - category: "RELTERMS" + authorised_value: "ptf" + lib: "Plaintiff" + + - category: "RELTERMS" + authorised_value: "pth" + lib: "Patent holder" + + - category: "RELTERMS" + authorised_value: "ptt" + lib: "Plaintiff-appellant" + + - category: "RELTERMS" + authorised_value: "pup" + lib: "Publication place" + + - category: "RELTERMS" + authorised_value: "rbr" + lib: "Rubricator" + + - category: "RELTERMS" + authorised_value: "rce" + lib: "Recording engineer" + + - category: "RELTERMS" + authorised_value: "rcp" + lib: "Recipient" + + - category: "RELTERMS" + authorised_value: "red" + lib: "Redactor" + + - category: "RELTERMS" + authorised_value: "ren" + lib: "Renderer" + + - category: "RELTERMS" + authorised_value: "res" + lib: "Researcher" + + - category: "RELTERMS" + authorised_value: "rev" + lib: "Reviewer" + + - category: "RELTERMS" + authorised_value: "rps" + lib: "Repository" + + - category: "RELTERMS" + authorised_value: "rpt" + lib: "Reporter" + + - category: "RELTERMS" + authorised_value: "rpy" + lib: "Responsible party" + + - category: "RELTERMS" + authorised_value: "rse" + lib: "Respondent-appellee" + + - category: "RELTERMS" + authorised_value: "rsg" + lib: "Restager" + + - category: "RELTERMS" + authorised_value: "rsp" + lib: "Respondent" + + - category: "RELTERMS" + authorised_value: "rst" + lib: "Respondent-appellant" + + - category: "RELTERMS" + authorised_value: "rth" + lib: "Research team head" + + - category: "RELTERMS" + authorised_value: "rtm" + lib: "Research team member" + + - category: "RELTERMS" + authorised_value: "sad" + lib: "Scientific advisor" + + - category: "RELTERMS" + authorised_value: "sce" + lib: "Scenarist" + + - category: "RELTERMS" + authorised_value: "scl" + lib: "Sculptor" + + - category: "RELTERMS" + authorised_value: "scr" + lib: "Scribe" + + - category: "RELTERMS" + authorised_value: "sds" + lib: "Sound designer" + + - category: "RELTERMS" + authorised_value: "sec" + lib: "Secretary" + + - category: "RELTERMS" + authorised_value: "sgn" + lib: "Signer" + + - category: "RELTERMS" + authorised_value: "sht" + lib: "Supporting host" + + - category: "RELTERMS" + authorised_value: "sng" + lib: "Singer" + + - category: "RELTERMS" + authorised_value: "spk" + lib: "Speaker" + + - category: "RELTERMS" + authorised_value: "spn" + lib: "Sponsor" + + - category: "RELTERMS" + authorised_value: "spy" + lib: "Second party" + + - category: "RELTERMS" + authorised_value: "srv" + lib: "Surveyor" + + - category: "RELTERMS" + authorised_value: "std" + lib: "Set designer" + + - category: "RELTERMS" + authorised_value: "stl" + lib: "Storyteller" + + - category: "RELTERMS" + authorised_value: "stm" + lib: "Stage manager" + + - category: "RELTERMS" + authorised_value: "stn" + lib: "Standards body" + + - category: "RELTERMS" + authorised_value: "str" + lib: "Stereotyper" + + - category: "RELTERMS" + authorised_value: "tcd" + lib: "Technical director" + + - category: "RELTERMS" + authorised_value: "tch" + lib: "Teacher" + + - category: "RELTERMS" + authorised_value: "ths" + lib: "Thesis advisor" + + - category: "RELTERMS" + authorised_value: "trc" + lib: "Transcriber" + + - category: "RELTERMS" + authorised_value: "trl" + lib: "Translator" + + - category: "RELTERMS" + authorised_value: "tyd" + lib: "Type designer" + + - category: "RELTERMS" + authorised_value: "tyg" + lib: "Typographer" + + - category: "RELTERMS" + authorised_value: "uvp" + lib: "University place" + + - category: "RELTERMS" + authorised_value: "vdg" + lib: "Videographer" + + - category: "RELTERMS" + authorised_value: "voc" + lib: "Vocalist" + + - category: "RELTERMS" + authorised_value: "wam" + lib: "Writer of accompanying material" + + - category: "RELTERMS" + authorised_value: "wdc" + lib: "Woodcutter" + + - category: "RELTERMS" + authorised_value: "wde" + lib: "Wood-engraver" + + - category: "RELTERMS" + authorised_value: "wit" + lib: "Witness" -- 2.20.1