From a596987eed112fec761f63489e6b12ebaeddc39d Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Wed, 10 Aug 2011 11:46:17 -0300 Subject: [PATCH] Bug 6299 - add es-ES Content-Type: text/plain; charset="UTF-8" Signed-off-by: Jared Camins-Esakov Confirmed that the RELTERMS authorised values category is populated. Not knowing Spanish I can't comment on the translations, but any errors can be corrected at a later date. --- .../mysql/es-ES/optional/marc21_relatorterms.sql | 226 ++++++++++++++++++++ .../mysql/es-ES/optional/marc21_relatorterms.txt | 1 + installer/data/mysql/updatedatabase.pl | 2 +- 3 files changed, 228 insertions(+), 1 deletions(-) create mode 100644 installer/data/mysql/es-ES/optional/marc21_relatorterms.sql create mode 100644 installer/data/mysql/es-ES/optional/marc21_relatorterms.txt diff --git a/installer/data/mysql/es-ES/optional/marc21_relatorterms.sql b/installer/data/mysql/es-ES/optional/marc21_relatorterms.sql new file mode 100644 index 0000000..3f1ac31 --- /dev/null +++ b/installer/data/mysql/es-ES/optional/marc21_relatorterms.sql @@ -0,0 +1,226 @@ +-- Listado de códigos MARC21 de Designaciones de funciòn, según +-- http://www.loc.gov/marc/relators/relacode.html + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','acp','Copiador artístico'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','act','Actor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','adp','Adaptador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aft','Autor de epílogos, colofón, etc.'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anl','Analista'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anm','Animador, dibujante de dibujos animados'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ann','Anotador, comentador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ant','Antecedente bibliográfico'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','app','Solicitante, postulante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aqt','Autor en citas o extractos de textos'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arc','Arquitecto'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ard','Director artístico'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arr','Arreglador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','art','Artista'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asg','Cesionario, apoderado, beneficiario'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asn','Nombre asociado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','att','Nombre atribuido'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','auc','Subastador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aud','Autor de diálogo'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aui','Autor de introducción'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aus','Autor de guión'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aut','Autor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bdd','Diseñador de encuadernación'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bjd','Diseñador de cubierta o funda'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkd','Diseñador del libro'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkp','Productor del libro'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','blw','Escritor de contracubierta'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bnd','Encuadernador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bpd','Diseñador de ex libris'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bsl','Librero'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ccp','Creador, que concibió la idea'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','chr','Coreógrafo'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clb','Colaborador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cli','Cliente'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cll','Calígrafo'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clr','Colorista'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clt','Productor de impresiones fotográficas'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmm','Comentarista'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmp','Compositor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmt','Tipógrafo'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cng','Camarógrafo'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cnd','Director de intérpretes'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cns','Censor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','coe','Contendiente -apelado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','col','Coleccionista'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','com','Compilador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','con','Conservador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cos','Contendiente'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cot','Contendiente-apelante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cov','Diseñador gráfico de cubiertas, tapas'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpc','Reclamante de autoría o derechos de autor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpe','Demandante-demandado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cph','Titular, poseedor de los derechos de autor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpl','Demandante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpt','Demandante -apelante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cre','Creador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','crp','Corresponsal'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','crr','Corrector'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csl','Consultor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csp','Consultor de proyecto'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cst','Diseñador de vestuario'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctb','Contribuyente'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cte','Litigado-demandado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctg','Cartógrafo'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctr','Contratista'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cts','Litigado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctt','Litigado-demandado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cur','Curador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cwt','Comentarista de textos escritos'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfd','Defendido'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfe','Defendido-demandado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dft','Defendido-demandante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dgg','Otorgante de grado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dis','Disertante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dln','Dibujante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnc','Bailarín/a'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnr','Donante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpb','Lugar de distribución'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpc','Retratado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpt','Depositante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drm','Dibujante artístico o técnico'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drt','Director'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dsr','Diseñador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dst','Distribuidor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtc','Contribuyente de datos'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dte','Dedicatario'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtm','Gestor, administrador de datos'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dto','Dedicante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dub','Autor dudoso, discutible'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','edt','Editor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','egr','Grabador, tallador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elg','Electricista'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elt','Electrotipador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','eng','Ingeniero'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','etr','Grabador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','evp','Lugar del evento'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','exp','Experto'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fac','Editor de facsímiles'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fld','Director de campo'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','flm','Editor de película'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fmo','Propietario anterior'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fpy','Primera parte'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fnd','Patrocinador, financiador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','frg','Falsificador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','gis','Especialista en información geográfica'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','-grt','Técnico gráfico'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hnr','Galardonado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hst','Presentador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ill','Ilustador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ilu','Iluminador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ins','Inscriptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','inv','Inventor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','itr','Instrumentalista'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ive','Entrevistado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ivr','Entrevistador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbr','Laboratorio'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbt','Libretista'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ldr','Director de laboratorio'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','led','Dirección, mando'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lee','Difamante-demandado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lel','Difamante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','len','Prestador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','let','Difamante-demandante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lgd','Diseñador de iluminación'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lie','Difamado-demandado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lil','Difamado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lit','Difamado-demandante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lsa','Arquitecto paisajista'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lse','Licenciatario'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lso','Licenciante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ltg','Litógrafo'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lyr','Letrista, escritor de la letra de una canción'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mcp','Copista de música'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfp','Lugar de fabricación'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfr','Fabricante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mdc','Contacto para (la obtención de) metadatos'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mod','Moderador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mon','Monitor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrb','Jaspeador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrk','Editor de la sobremarcación'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','msd','Director musical'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mte','Grabador de metales'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mus','Músico'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','nrt','Narrador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','opn','Oponente'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','org','Originador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','orm','Organizador de reunión'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','oth','Otro'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','own','Propietario'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pat','Patrocinador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbd','Director de publicación'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbl','Editor comercial'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pdr','Director de proyecto'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pfr','Corrector de pruebas'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pht','Fotógrafo'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','plt','Grabador de placas'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pma','Agencia de autorizaciones'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pmn','Gerente de producción'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pop','Impresor de placas'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppm','Fabricante de papel'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppt','Marionetista, titiritero'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prc','Contacto de proceso'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prd','Personal de producción'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prf','Intérprete'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prg','Programador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prm','Grabador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pro','Productor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prp','Lugar de producción'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prt','Impresor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pta','Solicitante de patente'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pte','Denunciante-demandado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptf','Denunciante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pth','Titular de patente'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptt','Denunciante-demandante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pup','Lugar de publicación'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rbr','Rubricante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rce','Ingeniero de grabación'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rcp','Receptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','red','Redactor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ren','Autor de renders'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','res','Investigador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rev','Revisor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rps','Repositorio'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpt','Reportero'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpy','Parte responsable'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rse','Acusado-demandado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsg','Responsable de reorganización de evento'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsp','Demandado'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rst','Demandado-demandante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rth','Director de equipo de investigación'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rtm','Miembro de equipo de investigación'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sad','Asesor científico'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sce','Guionista'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scl','Escultor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scr','Escriba'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sds','Diseñador de sonido'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sec','Secretario/a'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sgn','Signatario'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sht','Anfitrión que apoya'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sng','Cantante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spk','Conferencista, ponente'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spn','Auspiciante'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spy','Segunda parte'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','srv','Agrimensor, topógrafo'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','std','Diseñador de escenarios, decorados'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stl','Narrador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stm','Director de escena'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stn','Organismo de estandarización'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','str','Estereotipador'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tcd','Director técnico'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tch','Docente, enseñanate'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ths','Director de tesis'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trc','Transcriptor'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trl','Traductor (de textos escritos)'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyd','Diseñador de tipos'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyg','Tipógrafo'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','uvp','Lugar de la universidad'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','vdg','Productor de video'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','voc','Vocalista'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wam','Autor de los escritos que acompañan material audiovisual'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wdc','Grabador de madera'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wde','Xilógrafo'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wit','Testigo'); diff --git a/installer/data/mysql/es-ES/optional/marc21_relatorterms.txt b/installer/data/mysql/es-ES/optional/marc21_relatorterms.txt new file mode 100644 index 0000000..7fafc34 --- /dev/null +++ b/installer/data/mysql/es-ES/optional/marc21_relatorterms.txt @@ -0,0 +1 @@ +Listado de códigos MARC21 de Designaciones de funciòn, según http://www.loc.gov/marc/relators/relaterm.html diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index abca7bc..4d45750 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -4665,7 +4665,7 @@ ENDOFRENEWAL $DBversion = "3.07.00.XXX"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - print "RELTERMS category available for English- and French-language relator terms. They are not loaded during upgrade but can be easily inserted using the provided marc21_relatorterms.sql SQL script (currently available for en and fr only).\n"; + print "RELTERMS category available for English-, French-, and Spanish-language relator terms. They are not loaded during upgrade but can be easily inserted using the provided marc21_relatorterms.sql SQL script (currently available for en, es, and fr only).\n"; SetVersion($DBversion); } -- 1.7.2.5