From b65997f84f290f2eada1a6030d9930d043df2f80 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Tue, 7 Jun 2011 11:27:37 -0300 Subject: [PATCH] Bug 6299 - Provide a list of authorized values for Relator terms Content-Type: text/plain; charset="utf-8" That's it. I was not sure about fr-FR, please let me know if it is not correct so I fix it. Regards To+ --- .../mysql/de-DE/optional/marc21_relatorterms.sql | 227 ++++++++++++++++++++ .../mysql/de-DE/optional/marc21_relatorterms.txt | 1 + .../data/mysql/en/optional/marc21_relatorterms.sql | 227 ++++++++++++++++++++ .../data/mysql/en/optional/marc21_relatorterms.txt | 1 + .../mysql/fr-FR/2-Optionel/marc21_relatorterms.sql | 227 ++++++++++++++++++++ .../mysql/fr-FR/2-Optionel/marc21_relatorterms.txt | 1 + .../nb-NO/2-Valgfritt/marc21_relatorterms.sql | 227 ++++++++++++++++++++ .../nb-NO/2-Valgfritt/marc21_relatorterms.txt | 1 + .../mysql/pl-PL/optional/marc21_relatorterms.sql | 227 ++++++++++++++++++++ .../mysql/pl-PL/optional/marc21_relatorterms.txt | 1 + .../mysql/ru-RU/optional/marc21_relatorterms.sql | 227 ++++++++++++++++++++ .../mysql/ru-RU/optional/marc21_relatorterms.txt | 1 + .../mysql/uk-UA/optional/marc21_relatorterms.sql | 227 ++++++++++++++++++++ .../mysql/uk-UA/optional/marc21_relatorterms.txt | 1 + 14 files changed, 1596 insertions(+), 0 deletions(-) create mode 100644 installer/data/mysql/de-DE/optional/marc21_relatorterms.sql create mode 100644 installer/data/mysql/de-DE/optional/marc21_relatorterms.txt create mode 100644 installer/data/mysql/en/optional/marc21_relatorterms.sql create mode 100644 installer/data/mysql/en/optional/marc21_relatorterms.txt create mode 100644 installer/data/mysql/fr-FR/2-Optionel/marc21_relatorterms.sql create mode 100644 installer/data/mysql/fr-FR/2-Optionel/marc21_relatorterms.txt create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/marc21_relatorterms.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/marc21_relatorterms.txt create mode 100644 installer/data/mysql/pl-PL/optional/marc21_relatorterms.sql create mode 100644 installer/data/mysql/pl-PL/optional/marc21_relatorterms.txt create mode 100644 installer/data/mysql/ru-RU/optional/marc21_relatorterms.sql create mode 100644 installer/data/mysql/ru-RU/optional/marc21_relatorterms.txt create mode 100644 installer/data/mysql/uk-UA/optional/marc21_relatorterms.sql create mode 100644 installer/data/mysql/uk-UA/optional/marc21_relatorterms.txt diff --git a/installer/data/mysql/de-DE/optional/marc21_relatorterms.sql b/installer/data/mysql/de-DE/optional/marc21_relatorterms.sql new file mode 100644 index 0000000..c5b5365 --- /dev/null +++ b/installer/data/mysql/de-DE/optional/marc21_relatorterms.sql @@ -0,0 +1,227 @@ +-- MARC code list for Relators, taken from +-- http://www.loc.gov/marc/relators/relacode.html + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness'); + diff --git a/installer/data/mysql/de-DE/optional/marc21_relatorterms.txt b/installer/data/mysql/de-DE/optional/marc21_relatorterms.txt new file mode 100644 index 0000000..ef8264b --- /dev/null +++ b/installer/data/mysql/de-DE/optional/marc21_relatorterms.txt @@ -0,0 +1 @@ +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.sql b/installer/data/mysql/en/optional/marc21_relatorterms.sql new file mode 100644 index 0000000..c5b5365 --- /dev/null +++ b/installer/data/mysql/en/optional/marc21_relatorterms.sql @@ -0,0 +1,227 @@ +-- MARC code list for Relators, taken from +-- http://www.loc.gov/marc/relators/relacode.html + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness'); + diff --git a/installer/data/mysql/en/optional/marc21_relatorterms.txt b/installer/data/mysql/en/optional/marc21_relatorterms.txt new file mode 100644 index 0000000..ef8264b --- /dev/null +++ b/installer/data/mysql/en/optional/marc21_relatorterms.txt @@ -0,0 +1 @@ +MARC Code List for Relators, as of http://www.loc.gov/marc/relators/relaterm.html diff --git a/installer/data/mysql/fr-FR/2-Optionel/marc21_relatorterms.sql b/installer/data/mysql/fr-FR/2-Optionel/marc21_relatorterms.sql new file mode 100644 index 0000000..c5b5365 --- /dev/null +++ b/installer/data/mysql/fr-FR/2-Optionel/marc21_relatorterms.sql @@ -0,0 +1,227 @@ +-- MARC code list for Relators, taken from +-- http://www.loc.gov/marc/relators/relacode.html + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness'); + diff --git a/installer/data/mysql/fr-FR/2-Optionel/marc21_relatorterms.txt b/installer/data/mysql/fr-FR/2-Optionel/marc21_relatorterms.txt new file mode 100644 index 0000000..ef8264b --- /dev/null +++ b/installer/data/mysql/fr-FR/2-Optionel/marc21_relatorterms.txt @@ -0,0 +1 @@ +MARC Code List for Relators, as of http://www.loc.gov/marc/relators/relaterm.html diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/marc21_relatorterms.sql b/installer/data/mysql/nb-NO/2-Valgfritt/marc21_relatorterms.sql new file mode 100644 index 0000000..c5b5365 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/marc21_relatorterms.sql @@ -0,0 +1,227 @@ +-- MARC code list for Relators, taken from +-- http://www.loc.gov/marc/relators/relacode.html + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness'); + diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/marc21_relatorterms.txt b/installer/data/mysql/nb-NO/2-Valgfritt/marc21_relatorterms.txt new file mode 100644 index 0000000..ef8264b --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/marc21_relatorterms.txt @@ -0,0 +1 @@ +MARC Code List for Relators, as of http://www.loc.gov/marc/relators/relaterm.html diff --git a/installer/data/mysql/pl-PL/optional/marc21_relatorterms.sql b/installer/data/mysql/pl-PL/optional/marc21_relatorterms.sql new file mode 100644 index 0000000..c5b5365 --- /dev/null +++ b/installer/data/mysql/pl-PL/optional/marc21_relatorterms.sql @@ -0,0 +1,227 @@ +-- MARC code list for Relators, taken from +-- http://www.loc.gov/marc/relators/relacode.html + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness'); + diff --git a/installer/data/mysql/pl-PL/optional/marc21_relatorterms.txt b/installer/data/mysql/pl-PL/optional/marc21_relatorterms.txt new file mode 100644 index 0000000..ef8264b --- /dev/null +++ b/installer/data/mysql/pl-PL/optional/marc21_relatorterms.txt @@ -0,0 +1 @@ +MARC Code List for Relators, as of http://www.loc.gov/marc/relators/relaterm.html diff --git a/installer/data/mysql/ru-RU/optional/marc21_relatorterms.sql b/installer/data/mysql/ru-RU/optional/marc21_relatorterms.sql new file mode 100644 index 0000000..c5b5365 --- /dev/null +++ b/installer/data/mysql/ru-RU/optional/marc21_relatorterms.sql @@ -0,0 +1,227 @@ +-- MARC code list for Relators, taken from +-- http://www.loc.gov/marc/relators/relacode.html + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness'); + diff --git a/installer/data/mysql/ru-RU/optional/marc21_relatorterms.txt b/installer/data/mysql/ru-RU/optional/marc21_relatorterms.txt new file mode 100644 index 0000000..ef8264b --- /dev/null +++ b/installer/data/mysql/ru-RU/optional/marc21_relatorterms.txt @@ -0,0 +1 @@ +MARC Code List for Relators, as of http://www.loc.gov/marc/relators/relaterm.html diff --git a/installer/data/mysql/uk-UA/optional/marc21_relatorterms.sql b/installer/data/mysql/uk-UA/optional/marc21_relatorterms.sql new file mode 100644 index 0000000..c5b5365 --- /dev/null +++ b/installer/data/mysql/uk-UA/optional/marc21_relatorterms.sql @@ -0,0 +1,227 @@ +-- MARC code list for Relators, taken from +-- http://www.loc.gov/marc/relators/relacode.html + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness'); + diff --git a/installer/data/mysql/uk-UA/optional/marc21_relatorterms.txt b/installer/data/mysql/uk-UA/optional/marc21_relatorterms.txt new file mode 100644 index 0000000..ef8264b --- /dev/null +++ b/installer/data/mysql/uk-UA/optional/marc21_relatorterms.txt @@ -0,0 +1 @@ +MARC Code List for Relators, as of http://www.loc.gov/marc/relators/relaterm.html -- 1.7.4.1