[Koha-patches] [PATCH] Bug 6299 - Provide a list of authorized values for Relator terms

Tomas Cohen Arazi tomascohen at gmail.com
Thu Jul 7 19:31:49 CEST 2011


That's it. I was not sure about fr-FR, please let me know if it is not correct so
I fix it.

This version  changes the category name so it fits in the 10 chars limit the field has.

Regards
To+

Bug 6299 - Provide a list of authorized values for relator terms

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



More information about the Koha-patches mailing list