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