Bugzilla – Attachment 20170 Details for
Bug 10521
Add i18n function to German mysql files for webinstaller (de-DE)
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10521: Followup for relator terms and quotes
Bug-10521-Followup-for-relator-terms-and-quotes.patch (text/plain), 30.16 KB, created by
Marcel de Rooy
on 2013-08-08 13:17:55 UTC
(
hide
)
Description:
Bug 10521: Followup for relator terms and quotes
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2013-08-08 13:17:55 UTC
Size:
30.16 KB
patch
obsolete
>From 997ccc3f4048eae7d99fe9dbb052e725a661621c Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Date: Thu, 8 Aug 2013 15:05:36 +0200 >Subject: [PATCH] Bug 10521: Followup for relator terms and quotes >Content-Type: text/plain; charset=utf-8 > >These files were still missing in the German install. > >Test plan: >Select relator terms and quotes in German optional install. >Since nothing is translated yet, you should see English strings. >--- > .../de-DE/optional.i18n/marc21_relatorterms.sql | 905 ++++++++++++++++++++ > .../de-DE/optional.i18n/marc21_relatorterms.txt | 1 + > .../mysql/de-DE/optional.i18n/sample_quotes.sql | 103 +++ > .../mysql/de-DE/optional.i18n/sample_quotes.txt | 1 + > 4 files changed, 1010 insertions(+), 0 deletions(-) > create mode 100644 installer/data/mysql/de-DE/optional.i18n/marc21_relatorterms.sql > create mode 100644 installer/data/mysql/de-DE/optional.i18n/marc21_relatorterms.txt > create mode 100644 installer/data/mysql/de-DE/optional.i18n/sample_quotes.sql > create mode 100644 installer/data/mysql/de-DE/optional.i18n/sample_quotes.txt > >diff --git a/installer/data/mysql/de-DE/optional.i18n/marc21_relatorterms.sql b/installer/data/mysql/de-DE/optional.i18n/marc21_relatorterms.sql >new file mode 100644 >index 0000000..e1fa975 >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/marc21_relatorterms.sql >@@ -0,0 +1,905 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+ >+-- MARC code list for Relators, taken from >+-- http://www.loc.gov/marc/relators/relacode.html >+ >+-- Statement 1, PK:'RELTERMS','acp', lib >+WHEN 'Art copyist' >+THEN 'Art copyist' >+ >+-- Statement 2, PK:'RELTERMS','act', lib >+WHEN 'Actor' >+THEN 'Actor' >+ >+-- Statement 3, PK:'RELTERMS','adp', lib >+WHEN 'Adapter' >+THEN 'Adapter' >+ >+-- Statement 4, PK:'RELTERMS','aft', lib >+WHEN 'Author of afterword, colophon, etc.' >+THEN 'Author of afterword, colophon, etc.' >+ >+-- Statement 5, PK:'RELTERMS','anl', lib >+WHEN 'Analyst' >+THEN 'Analyst' >+ >+-- Statement 6, PK:'RELTERMS','anm', lib >+WHEN 'Animator' >+THEN 'Animator' >+ >+-- Statement 7, PK:'RELTERMS','ann', lib >+WHEN 'Annotator' >+THEN 'Annotator' >+ >+-- Statement 8, PK:'RELTERMS','ant', lib >+WHEN 'Bibliographic antecedent' >+THEN 'Bibliographic antecedent' >+ >+-- Statement 9, PK:'RELTERMS','app', lib >+WHEN 'Applicant' >+THEN 'Applicant' >+ >+-- Statement 10, PK:'RELTERMS','aqt', lib >+WHEN 'Author in quotations or text abstracts' >+THEN 'Author in quotations or text abstracts' >+ >+-- Statement 11, PK:'RELTERMS','arc', lib >+WHEN 'Architect' >+THEN 'Architect' >+ >+-- Statement 12, PK:'RELTERMS','ard', lib >+WHEN 'Artistic director' >+THEN 'Artistic director' >+ >+-- Statement 13, PK:'RELTERMS','arr', lib >+WHEN 'Arranger' >+THEN 'Arranger' >+ >+-- Statement 14, PK:'RELTERMS','art', lib >+WHEN 'Artist' >+THEN 'Artist' >+ >+-- Statement 15, PK:'RELTERMS','asg', lib >+WHEN 'Assignee' >+THEN 'Assignee' >+ >+-- Statement 16, PK:'RELTERMS','asn', lib >+WHEN 'Associated name' >+THEN 'Associated name' >+ >+-- Statement 17, PK:'RELTERMS','att', lib >+WHEN 'Attributed name' >+THEN 'Attributed name' >+ >+-- Statement 18, PK:'RELTERMS','auc', lib >+WHEN 'Auctioneer' >+THEN 'Auctioneer' >+ >+-- Statement 19, PK:'RELTERMS','aud', lib >+WHEN 'Author of dialog' >+THEN 'Author of dialog' >+ >+-- Statement 20, PK:'RELTERMS','aui', lib >+WHEN 'Author of introduction' >+THEN 'Author of introduction' >+ >+-- Statement 21, PK:'RELTERMS','aus', lib >+WHEN 'Author of screenplay' >+THEN 'Author of screenplay' >+ >+-- Statement 22, PK:'RELTERMS','aut', lib >+WHEN 'Author' >+THEN 'Author' >+ >+-- Statement 23, PK:'RELTERMS','bdd', lib >+WHEN 'Binding designer' >+THEN 'Binding designer' >+ >+-- Statement 24, PK:'RELTERMS','bjd', lib >+WHEN 'Bookjacket designer' >+THEN 'Bookjacket designer' >+ >+-- Statement 25, PK:'RELTERMS','bkd', lib >+WHEN 'Book designer' >+THEN 'Book designer' >+ >+-- Statement 26, PK:'RELTERMS','bkp', lib >+WHEN 'Book producer' >+THEN 'Book producer' >+ >+-- Statement 27, PK:'RELTERMS','blw', lib >+WHEN 'Blurb writer' >+THEN 'Blurb writer' >+ >+-- Statement 28, PK:'RELTERMS','bnd', lib >+WHEN 'Binder' >+THEN 'Binder' >+ >+-- Statement 29, PK:'RELTERMS','bpd', lib >+WHEN 'Bookplate designer' >+THEN 'Bookplate designer' >+ >+-- Statement 30, PK:'RELTERMS','bsl', lib >+WHEN 'Bookseller' >+THEN 'Bookseller' >+ >+-- Statement 31, PK:'RELTERMS','ccp', lib >+WHEN 'Conceptor' >+THEN 'Conceptor' >+ >+-- Statement 32, PK:'RELTERMS','chr', lib >+WHEN 'Choreographer' >+THEN 'Choreographer' >+ >+-- Statement 33, PK:'RELTERMS','clb', lib >+WHEN 'Collaborator' >+THEN 'Collaborator' >+ >+-- Statement 34, PK:'RELTERMS','cli', lib >+WHEN 'Client' >+THEN 'Client' >+ >+-- Statement 35, PK:'RELTERMS','cll', lib >+WHEN 'Calligrapher' >+THEN 'Calligrapher' >+ >+-- Statement 36, PK:'RELTERMS','clr', lib >+WHEN 'Colorist' >+THEN 'Colorist' >+ >+-- Statement 37, PK:'RELTERMS','clt', lib >+WHEN 'Collotyper' >+THEN 'Collotyper' >+ >+-- Statement 38, PK:'RELTERMS','cmm', lib >+WHEN 'Commentator' >+THEN 'Commentator' >+ >+-- Statement 39, PK:'RELTERMS','cmp', lib >+WHEN 'Composer' >+THEN 'Composer' >+ >+-- Statement 40, PK:'RELTERMS','cmt', lib >+WHEN 'Compositor' >+THEN 'Compositor' >+ >+-- Statement 41, PK:'RELTERMS','cng', lib >+WHEN 'Cinematographer' >+THEN 'Cinematographer' >+ >+-- Statement 42, PK:'RELTERMS','cnd', lib >+WHEN 'Conductor' >+THEN 'Conductor' >+ >+-- Statement 43, PK:'RELTERMS','cns', lib >+WHEN 'Censor' >+THEN 'Censor' >+ >+-- Statement 44, PK:'RELTERMS','coe', lib >+WHEN 'Contestant -appellee' >+THEN 'Contestant -appellee' >+ >+-- Statement 45, PK:'RELTERMS','col', lib >+WHEN 'Collector' >+THEN 'Collector' >+ >+-- Statement 46, PK:'RELTERMS','com', lib >+WHEN 'Compiler' >+THEN 'Compiler' >+ >+-- Statement 47, PK:'RELTERMS','con', lib >+WHEN 'Conservator' >+THEN 'Conservator' >+ >+-- Statement 48, PK:'RELTERMS','cos', lib >+WHEN 'Contestant' >+THEN 'Contestant' >+ >+-- Statement 49, PK:'RELTERMS','cot', lib >+WHEN 'Contestant -appellant' >+THEN 'Contestant -appellant' >+ >+-- Statement 50, PK:'RELTERMS','cov', lib >+WHEN 'Cover designer' >+THEN 'Cover designer' >+ >+-- Statement 51, PK:'RELTERMS','cpc', lib >+WHEN 'Copyright claimant' >+THEN 'Copyright claimant' >+ >+-- Statement 52, PK:'RELTERMS','cpe', lib >+WHEN 'Complainant-appellee' >+THEN 'Complainant-appellee' >+ >+-- Statement 53, PK:'RELTERMS','cph', lib >+WHEN 'Copyright holder' >+THEN 'Copyright holder' >+ >+-- Statement 54, PK:'RELTERMS','cpl', lib >+WHEN 'Complainant' >+THEN 'Complainant' >+ >+-- Statement 55, PK:'RELTERMS','cpt', lib >+WHEN 'Complainant-appellant' >+THEN 'Complainant-appellant' >+ >+-- Statement 56, PK:'RELTERMS','cre', lib >+WHEN 'Creator' >+THEN 'Creator' >+ >+-- Statement 57, PK:'RELTERMS','crp', lib >+WHEN 'Correspondent' >+THEN 'Correspondent' >+ >+-- Statement 58, PK:'RELTERMS','crr', lib >+WHEN 'Corrector' >+THEN 'Corrector' >+ >+-- Statement 59, PK:'RELTERMS','csl', lib >+WHEN 'Consultant' >+THEN 'Consultant' >+ >+-- Statement 60, PK:'RELTERMS','csp', lib >+WHEN 'Consultant to a project' >+THEN 'Consultant to a project' >+ >+-- Statement 61, PK:'RELTERMS','cst', lib >+WHEN 'Costume designer' >+THEN 'Costume designer' >+ >+-- Statement 62, PK:'RELTERMS','ctb', lib >+WHEN 'Contributor' >+THEN 'Contributor' >+ >+-- Statement 63, PK:'RELTERMS','cte', lib >+WHEN 'Contestee-appellee' >+THEN 'Contestee-appellee' >+ >+-- Statement 64, PK:'RELTERMS','ctg', lib >+WHEN 'Cartographer' >+THEN 'Cartographer' >+ >+-- Statement 65, PK:'RELTERMS','ctr', lib >+WHEN 'Contractor' >+THEN 'Contractor' >+ >+-- Statement 66, PK:'RELTERMS','cts', lib >+WHEN 'Contestee' >+THEN 'Contestee' >+ >+-- Statement 67, PK:'RELTERMS','ctt', lib >+WHEN 'Contestee-appellant' >+THEN 'Contestee-appellant' >+ >+-- Statement 68, PK:'RELTERMS','cur', lib >+WHEN 'Curator' >+THEN 'Curator' >+ >+-- Statement 69, PK:'RELTERMS','cwt', lib >+WHEN 'Commentator for written text' >+THEN 'Commentator for written text' >+ >+-- Statement 70, PK:'RELTERMS','dfd', lib >+WHEN 'Defendant' >+THEN 'Defendant' >+ >+-- Statement 71, PK:'RELTERMS','dfe', lib >+WHEN 'Defendant-appellee' >+THEN 'Defendant-appellee' >+ >+-- Statement 72, PK:'RELTERMS','dft', lib >+WHEN 'Defendant-appellant' >+THEN 'Defendant-appellant' >+ >+-- Statement 73, PK:'RELTERMS','dgg', lib >+WHEN 'Degree grantor' >+THEN 'Degree grantor' >+ >+-- Statement 74, PK:'RELTERMS','dis', lib >+WHEN 'Dissertant' >+THEN 'Dissertant' >+ >+-- Statement 75, PK:'RELTERMS','dln', lib >+WHEN 'Delineator' >+THEN 'Delineator' >+ >+-- Statement 76, PK:'RELTERMS','dnc', lib >+WHEN 'Dancer' >+THEN 'Dancer' >+ >+-- Statement 77, PK:'RELTERMS','dnr', lib >+WHEN 'Donor' >+THEN 'Donor' >+ >+-- Statement 78, PK:'RELTERMS','dpb', lib >+WHEN 'Distribution place' >+THEN 'Distribution place' >+ >+-- Statement 79, PK:'RELTERMS','dpc', lib >+WHEN 'Depicted' >+THEN 'Depicted' >+ >+-- Statement 80, PK:'RELTERMS','dpt', lib >+WHEN 'Depositor' >+THEN 'Depositor' >+ >+-- Statement 81, PK:'RELTERMS','drm', lib >+WHEN 'Draftsman' >+THEN 'Draftsman' >+ >+-- Statement 82, PK:'RELTERMS','drt', lib >+WHEN 'Director' >+THEN 'Director' >+ >+-- Statement 83, PK:'RELTERMS','dsr', lib >+WHEN 'Designer' >+THEN 'Designer' >+ >+-- Statement 84, PK:'RELTERMS','dst', lib >+WHEN 'Distributor' >+THEN 'Distributor' >+ >+-- Statement 85, PK:'RELTERMS','dtc', lib >+WHEN 'Data contributor' >+THEN 'Data contributor' >+ >+-- Statement 86, PK:'RELTERMS','dte', lib >+WHEN 'Dedicatee' >+THEN 'Dedicatee' >+ >+-- Statement 87, PK:'RELTERMS','dtm', lib >+WHEN 'Data manager' >+THEN 'Data manager' >+ >+-- Statement 88, PK:'RELTERMS','dto', lib >+WHEN 'Dedicator' >+THEN 'Dedicator' >+ >+-- Statement 89, PK:'RELTERMS','dub', lib >+WHEN 'Dubious author' >+THEN 'Dubious author' >+ >+-- Statement 90, PK:'RELTERMS','edt', lib >+WHEN 'Editor' >+THEN 'Editor' >+ >+-- Statement 91, PK:'RELTERMS','egr', lib >+WHEN 'Engraver' >+THEN 'Engraver' >+ >+-- Statement 92, PK:'RELTERMS','elg', lib >+WHEN 'Electrician' >+THEN 'Electrician' >+ >+-- Statement 93, PK:'RELTERMS','elt', lib >+WHEN 'Electrotyper' >+THEN 'Electrotyper' >+ >+-- Statement 94, PK:'RELTERMS','eng', lib >+WHEN 'Engineer' >+THEN 'Engineer' >+ >+-- Statement 95, PK:'RELTERMS','etr', lib >+WHEN 'Etcher' >+THEN 'Etcher' >+ >+-- Statement 96, PK:'RELTERMS','evp', lib >+WHEN 'Event place' >+THEN 'Event place' >+ >+-- Statement 97, PK:'RELTERMS','exp', lib >+WHEN 'Expert' >+THEN 'Expert' >+ >+-- Statement 98, PK:'RELTERMS','fac', lib >+WHEN 'Facsimilist' >+THEN 'Facsimilist' >+ >+-- Statement 99, PK:'RELTERMS','fld', lib >+WHEN 'Field director' >+THEN 'Field director' >+ >+-- Statement 100, PK:'RELTERMS','flm', lib >+WHEN 'Film editor' >+THEN 'Film editor' >+ >+-- Statement 101, PK:'RELTERMS','fmo', lib >+WHEN 'Former owner' >+THEN 'Former owner' >+ >+-- Statement 102, PK:'RELTERMS','fpy', lib >+WHEN 'First party' >+THEN 'First party' >+ >+-- Statement 103, PK:'RELTERMS','fnd', lib >+WHEN 'Funder' >+THEN 'Funder' >+ >+-- Statement 104, PK:'RELTERMS','frg', lib >+WHEN 'Forger' >+THEN 'Forger' >+ >+-- Statement 105, PK:'RELTERMS','gis', lib >+WHEN 'Geographic information specialist' >+THEN 'Geographic information specialist' >+ >+-- Statement 106, PK:'RELTERMS','-grt', lib >+WHEN 'Graphic technician' >+THEN 'Graphic technician' >+ >+-- Statement 107, PK:'RELTERMS','hnr', lib >+WHEN 'Honoree' >+THEN 'Honoree' >+ >+-- Statement 108, PK:'RELTERMS','hst', lib >+WHEN 'Host' >+THEN 'Host' >+ >+-- Statement 109, PK:'RELTERMS','ill', lib >+WHEN 'Illustrator' >+THEN 'Illustrator' >+ >+-- Statement 110, PK:'RELTERMS','ilu', lib >+WHEN 'Illuminator' >+THEN 'Illuminator' >+ >+-- Statement 111, PK:'RELTERMS','ins', lib >+WHEN 'Inscriber' >+THEN 'Inscriber' >+ >+-- Statement 112, PK:'RELTERMS','inv', lib >+WHEN 'Inventor' >+THEN 'Inventor' >+ >+-- Statement 113, PK:'RELTERMS','itr', lib >+WHEN 'Instrumentalist' >+THEN 'Instrumentalist' >+ >+-- Statement 114, PK:'RELTERMS','ive', lib >+WHEN 'Interviewee' >+THEN 'Interviewee' >+ >+-- Statement 115, PK:'RELTERMS','ivr', lib >+WHEN 'Interviewer' >+THEN 'Interviewer' >+ >+-- Statement 116, PK:'RELTERMS','lbr', lib >+WHEN 'Laboratory' >+THEN 'Laboratory' >+ >+-- Statement 117, PK:'RELTERMS','lbt', lib >+WHEN 'Librettist' >+THEN 'Librettist' >+ >+-- Statement 118, PK:'RELTERMS','ldr', lib >+WHEN 'Laboratory director' >+THEN 'Laboratory director' >+ >+-- Statement 119, PK:'RELTERMS','led', lib >+WHEN 'Lead' >+THEN 'Lead' >+ >+-- Statement 120, PK:'RELTERMS','lee', lib >+WHEN 'Libelee-appellee' >+THEN 'Libelee-appellee' >+ >+-- Statement 121, PK:'RELTERMS','lel', lib >+WHEN 'Libelee' >+THEN 'Libelee' >+ >+-- Statement 122, PK:'RELTERMS','len', lib >+WHEN 'Lender' >+THEN 'Lender' >+ >+-- Statement 123, PK:'RELTERMS','let', lib >+WHEN 'Libelee-appellant' >+THEN 'Libelee-appellant' >+ >+-- Statement 124, PK:'RELTERMS','lgd', lib >+WHEN 'Lighting designer' >+THEN 'Lighting designer' >+ >+-- Statement 125, PK:'RELTERMS','lie', lib >+WHEN 'Libelant-appellee' >+THEN 'Libelant-appellee' >+ >+-- Statement 126, PK:'RELTERMS','lil', lib >+WHEN 'Libelant' >+THEN 'Libelant' >+ >+-- Statement 127, PK:'RELTERMS','lit', lib >+WHEN 'Libelant-appellant' >+THEN 'Libelant-appellant' >+ >+-- Statement 128, PK:'RELTERMS','lsa', lib >+WHEN 'Landscape architect' >+THEN 'Landscape architect' >+ >+-- Statement 129, PK:'RELTERMS','lse', lib >+WHEN 'Licensee' >+THEN 'Licensee' >+ >+-- Statement 130, PK:'RELTERMS','lso', lib >+WHEN 'Licensor' >+THEN 'Licensor' >+ >+-- Statement 131, PK:'RELTERMS','ltg', lib >+WHEN 'Lithographer' >+THEN 'Lithographer' >+ >+-- Statement 132, PK:'RELTERMS','lyr', lib >+WHEN 'Lyricist' >+THEN 'Lyricist' >+ >+-- Statement 133, PK:'RELTERMS','mcp', lib >+WHEN 'Music copyist' >+THEN 'Music copyist' >+ >+-- Statement 134, PK:'RELTERMS','mfp', lib >+WHEN 'Manufacture place' >+THEN 'Manufacture place' >+ >+-- Statement 135, PK:'RELTERMS','mfr', lib >+WHEN 'Manufacturer' >+THEN 'Manufacturer' >+ >+-- Statement 136, PK:'RELTERMS','mdc', lib >+WHEN 'Metadata contact' >+THEN 'Metadata contact' >+ >+-- Statement 137, PK:'RELTERMS','mod', lib >+WHEN 'Moderator' >+THEN 'Moderator' >+ >+-- Statement 138, PK:'RELTERMS','mon', lib >+WHEN 'Monitor' >+THEN 'Monitor' >+ >+-- Statement 139, PK:'RELTERMS','mrb', lib >+WHEN 'Marbler' >+THEN 'Marbler' >+ >+-- Statement 140, PK:'RELTERMS','mrk', lib >+WHEN 'Markup editor' >+THEN 'Markup editor' >+ >+-- Statement 141, PK:'RELTERMS','msd', lib >+WHEN 'Musical director' >+THEN 'Musical director' >+ >+-- Statement 142, PK:'RELTERMS','mte', lib >+WHEN 'Metal-engraver' >+THEN 'Metal-engraver' >+ >+-- Statement 143, PK:'RELTERMS','mus', lib >+WHEN 'Musician' >+THEN 'Musician' >+ >+-- Statement 144, PK:'RELTERMS','nrt', lib >+WHEN 'Narrator' >+THEN 'Narrator' >+ >+-- Statement 145, PK:'RELTERMS','opn', lib >+WHEN 'Opponent' >+THEN 'Opponent' >+ >+-- Statement 146, PK:'RELTERMS','org', lib >+WHEN 'Originator' >+THEN 'Originator' >+ >+-- Statement 147, PK:'RELTERMS','orm', lib >+WHEN 'Organizer of meeting' >+THEN 'Organizer of meeting' >+ >+-- Statement 148, PK:'RELTERMS','oth', lib >+WHEN 'Other' >+THEN 'Other' >+ >+-- Statement 149, PK:'RELTERMS','own', lib >+WHEN 'Owner' >+THEN 'Owner' >+ >+-- Statement 150, PK:'RELTERMS','pat', lib >+WHEN 'Patron' >+THEN 'Patron' >+ >+-- Statement 151, PK:'RELTERMS','pbd', lib >+WHEN 'Publishing director' >+THEN 'Publishing director' >+ >+-- Statement 152, PK:'RELTERMS','pbl', lib >+WHEN 'Publisher' >+THEN 'Publisher' >+ >+-- Statement 153, PK:'RELTERMS','pdr', lib >+WHEN 'Project director' >+THEN 'Project director' >+ >+-- Statement 154, PK:'RELTERMS','pfr', lib >+WHEN 'Proofreader' >+THEN 'Proofreader' >+ >+-- Statement 155, PK:'RELTERMS','pht', lib >+WHEN 'Photographer' >+THEN 'Photographer' >+ >+-- Statement 156, PK:'RELTERMS','plt', lib >+WHEN 'Platemaker' >+THEN 'Platemaker' >+ >+-- Statement 157, PK:'RELTERMS','pma', lib >+WHEN 'Permitting agency' >+THEN 'Permitting agency' >+ >+-- Statement 158, PK:'RELTERMS','pmn', lib >+WHEN 'Production manager' >+THEN 'Production manager' >+ >+-- Statement 159, PK:'RELTERMS','pop', lib >+WHEN 'Printer of plates' >+THEN 'Printer of plates' >+ >+-- Statement 160, PK:'RELTERMS','ppm', lib >+WHEN 'Papermaker' >+THEN 'Papermaker' >+ >+-- Statement 161, PK:'RELTERMS','ppt', lib >+WHEN 'Puppeteer' >+THEN 'Puppeteer' >+ >+-- Statement 162, PK:'RELTERMS','prc', lib >+WHEN 'Process contact' >+THEN 'Process contact' >+ >+-- Statement 163, PK:'RELTERMS','prd', lib >+WHEN 'Production personnel' >+THEN 'Production personnel' >+ >+-- Statement 164, PK:'RELTERMS','prf', lib >+WHEN 'Performer' >+THEN 'Performer' >+ >+-- Statement 165, PK:'RELTERMS','prg', lib >+WHEN 'Programmer' >+THEN 'Programmer' >+ >+-- Statement 166, PK:'RELTERMS','prm', lib >+WHEN 'Printmaker' >+THEN 'Printmaker' >+ >+-- Statement 167, PK:'RELTERMS','pro', lib >+WHEN 'Producer' >+THEN 'Producer' >+ >+-- Statement 168, PK:'RELTERMS','prp', lib >+WHEN 'Production place' >+THEN 'Production place' >+ >+-- Statement 169, PK:'RELTERMS','prt', lib >+WHEN 'Printer' >+THEN 'Printer' >+ >+-- Statement 170, PK:'RELTERMS','pta', lib >+WHEN 'Patent applicant' >+THEN 'Patent applicant' >+ >+-- Statement 171, PK:'RELTERMS','pte', lib >+WHEN 'Plaintiff -appellee' >+THEN 'Plaintiff -appellee' >+ >+-- Statement 172, PK:'RELTERMS','ptf', lib >+WHEN 'Plaintiff' >+THEN 'Plaintiff' >+ >+-- Statement 173, PK:'RELTERMS','pth', lib >+WHEN 'Patent holder' >+THEN 'Patent holder' >+ >+-- Statement 174, PK:'RELTERMS','ptt', lib >+WHEN 'Plaintiff-appellant' >+THEN 'Plaintiff-appellant' >+ >+-- Statement 175, PK:'RELTERMS','pup', lib >+WHEN 'Publication place' >+THEN 'Publication place' >+ >+-- Statement 176, PK:'RELTERMS','rbr', lib >+WHEN 'Rubricator' >+THEN 'Rubricator' >+ >+-- Statement 177, PK:'RELTERMS','rce', lib >+WHEN 'Recording engineer' >+THEN 'Recording engineer' >+ >+-- Statement 178, PK:'RELTERMS','rcp', lib >+WHEN 'Recipient' >+THEN 'Recipient' >+ >+-- Statement 179, PK:'RELTERMS','red', lib >+WHEN 'Redactor' >+THEN 'Redactor' >+ >+-- Statement 180, PK:'RELTERMS','ren', lib >+WHEN 'Renderer' >+THEN 'Renderer' >+ >+-- Statement 181, PK:'RELTERMS','res', lib >+WHEN 'Researcher' >+THEN 'Researcher' >+ >+-- Statement 182, PK:'RELTERMS','rev', lib >+WHEN 'Reviewer' >+THEN 'Reviewer' >+ >+-- Statement 183, PK:'RELTERMS','rps', lib >+WHEN 'Repository' >+THEN 'Repository' >+ >+-- Statement 184, PK:'RELTERMS','rpt', lib >+WHEN 'Reporter' >+THEN 'Reporter' >+ >+-- Statement 185, PK:'RELTERMS','rpy', lib >+WHEN 'Responsible party' >+THEN 'Responsible party' >+ >+-- Statement 186, PK:'RELTERMS','rse', lib >+WHEN 'Respondent-appellee' >+THEN 'Respondent-appellee' >+ >+-- Statement 187, PK:'RELTERMS','rsg', lib >+WHEN 'Restager' >+THEN 'Restager' >+ >+-- Statement 188, PK:'RELTERMS','rsp', lib >+WHEN 'Respondent' >+THEN 'Respondent' >+ >+-- Statement 189, PK:'RELTERMS','rst', lib >+WHEN 'Respondent-appellant' >+THEN 'Respondent-appellant' >+ >+-- Statement 190, PK:'RELTERMS','rth', lib >+WHEN 'Research team head' >+THEN 'Research team head' >+ >+-- Statement 191, PK:'RELTERMS','rtm', lib >+WHEN 'Research team member' >+THEN 'Research team member' >+ >+-- Statement 192, PK:'RELTERMS','sad', lib >+WHEN 'Scientific advisor' >+THEN 'Scientific advisor' >+ >+-- Statement 193, PK:'RELTERMS','sce', lib >+WHEN 'Scenarist' >+THEN 'Scenarist' >+ >+-- Statement 194, PK:'RELTERMS','scl', lib >+WHEN 'Sculptor' >+THEN 'Sculptor' >+ >+-- Statement 195, PK:'RELTERMS','scr', lib >+WHEN 'Scribe' >+THEN 'Scribe' >+ >+-- Statement 196, PK:'RELTERMS','sds', lib >+WHEN 'Sound designer' >+THEN 'Sound designer' >+ >+-- Statement 197, PK:'RELTERMS','sec', lib >+WHEN 'Secretary' >+THEN 'Secretary' >+ >+-- Statement 198, PK:'RELTERMS','sgn', lib >+WHEN 'Signer' >+THEN 'Signer' >+ >+-- Statement 199, PK:'RELTERMS','sht', lib >+WHEN 'Supporting host' >+THEN 'Supporting host' >+ >+-- Statement 200, PK:'RELTERMS','sng', lib >+WHEN 'Singer' >+THEN 'Singer' >+ >+-- Statement 201, PK:'RELTERMS','spk', lib >+WHEN 'Speaker' >+THEN 'Speaker' >+ >+-- Statement 202, PK:'RELTERMS','spn', lib >+WHEN 'Sponsor' >+THEN 'Sponsor' >+ >+-- Statement 203, PK:'RELTERMS','spy', lib >+WHEN 'Second party' >+THEN 'Second party' >+ >+-- Statement 204, PK:'RELTERMS','srv', lib >+WHEN 'Surveyor' >+THEN 'Surveyor' >+ >+-- Statement 205, PK:'RELTERMS','std', lib >+WHEN 'Set designer' >+THEN 'Set designer' >+ >+-- Statement 206, PK:'RELTERMS','stl', lib >+WHEN 'Storyteller' >+THEN 'Storyteller' >+ >+-- Statement 207, PK:'RELTERMS','stm', lib >+WHEN 'Stage manager' >+THEN 'Stage manager' >+ >+-- Statement 208, PK:'RELTERMS','stn', lib >+WHEN 'Standards body' >+THEN 'Standards body' >+ >+-- Statement 209, PK:'RELTERMS','str', lib >+WHEN 'Stereotyper' >+THEN 'Stereotyper' >+ >+-- Statement 210, PK:'RELTERMS','tcd', lib >+WHEN 'Technical director' >+THEN 'Technical director' >+ >+-- Statement 211, PK:'RELTERMS','tch', lib >+WHEN 'Teacher' >+THEN 'Teacher' >+ >+-- Statement 212, PK:'RELTERMS','ths', lib >+WHEN 'Thesis advisor' >+THEN 'Thesis advisor' >+ >+-- Statement 213, PK:'RELTERMS','trc', lib >+WHEN 'Transcriber' >+THEN 'Transcriber' >+ >+-- Statement 214, PK:'RELTERMS','trl', lib >+WHEN 'Translator' >+THEN 'Translator' >+ >+-- Statement 215, PK:'RELTERMS','tyd', lib >+WHEN 'Type designer' >+THEN 'Type designer' >+ >+-- Statement 216, PK:'RELTERMS','tyg', lib >+WHEN 'Typographer' >+THEN 'Typographer' >+ >+-- Statement 217, PK:'RELTERMS','uvp', lib >+WHEN 'University place' >+THEN 'University place' >+ >+-- Statement 218, PK:'RELTERMS','vdg', lib >+WHEN 'Videographer' >+THEN 'Videographer' >+ >+-- Statement 219, PK:'RELTERMS','voc', lib >+WHEN 'Vocalist' >+THEN 'Vocalist' >+ >+-- Statement 220, PK:'RELTERMS','wam', lib >+WHEN 'Writer of accompanying material' >+THEN 'Writer of accompanying material' >+ >+-- Statement 221, PK:'RELTERMS','wdc', lib >+WHEN 'Woodcutter' >+THEN 'Woodcutter' >+ >+-- Statement 222, PK:'RELTERMS','wde', lib >+WHEN 'Wood-engraver' >+THEN 'Wood-engraver' >+ >+-- Statement 223, PK:'RELTERMS','wit', lib >+WHEN 'Witness' >+THEN 'Witness' >+ >+ELSE d >+END; >+END // >diff --git a/installer/data/mysql/de-DE/optional.i18n/marc21_relatorterms.txt b/installer/data/mysql/de-DE/optional.i18n/marc21_relatorterms.txt >new file mode 100644 >index 0000000..5cbf709 >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/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/de-DE/optional.i18n/sample_quotes.sql b/installer/data/mysql/de-DE/optional.i18n/sample_quotes.sql >new file mode 100644 >index 0000000..984731a >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/sample_quotes.sql >@@ -0,0 +1,103 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+-- Statement 1, PK:1, text >+WHEN 'To be prepared for war is one of the most effectual means of preserving peace.' >+THEN 'To be prepared for war is one of the most effectual means of preserving peace.' >+-- Statement 1, PK:2, text >+WHEN 'When angry, count ten, before you speak; if very angry, an hundred.' >+THEN 'When angry, count ten, before you speak; if very angry, an hundred.' >+-- Statement 1, PK:3, text >+WHEN 'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.' >+THEN 'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.' >+-- Statement 1, PK:4, text >+WHEN 'I have always found that mercy bears richer fruits than strict justice.' >+THEN 'I have always found that mercy bears richer fruits than strict justice.' >+-- Statement 1, PK:5, text >+WHEN 'I feel incompetent to perform duties...which have been so unexpectedly thrown upon me.' >+THEN 'I feel incompetent to perform duties...which have been so unexpectedly thrown upon me.' >+-- Statement 1, PK:6, text >+WHEN 'He serves his party best who serves his country best.' >+THEN 'He serves his party best who serves his country best.' >+-- Statement 1, PK:7, text >+WHEN 'No President has ever enjoyed himself as much as I?' >+THEN 'No President has ever enjoyed himself as much as I?' >+-- Statement 1, PK:8, text >+WHEN 'Speak softly and carry a big stick.' >+THEN 'Speak softly and carry a big stick.' >+-- Statement 1, PK:9, text >+WHEN 'I have come to the conclusion that the major part of the president is to increase the gate receipts of expositions and fairs and bring tourists to town.' >+THEN 'I have come to the conclusion that the major part of the president is to increase the gate receipts of expositions and fairs and bring tourists to town.' >+-- Statement 1, PK:11, text >+WHEN 'You cannot become thorough Americans if you think of yourselves in groups. America does not consist of groups. A man who thinks of himself as belonging to a particular national group in America has not yet become an American.' >+THEN 'You cannot become thorough Americans if you think of yourselves in groups. America does not consist of groups. A man who thinks of himself as belonging to a particular national group in America has not yet become an American.' >+-- Statement 1, PK:12, text >+WHEN 'If you don\'t say anything, you won\'t be called on to repeat it.' >+THEN 'If you don\'t say anything, you won\'t be called on to repeat it.' >+-- Statement 1, PK:13, text >+WHEN 'Four fifths of all our troubles in this life would disappear if we would only sit down and keep still.' >+THEN 'Four fifths of all our troubles in this life would disappear if we would only sit down and keep still.' >+-- Statement 1, PK:14, text >+WHEN 'The slogan of progress is changing from the full dinner pail to the full garage.' >+THEN 'The slogan of progress is changing from the full dinner pail to the full garage.' >+-- Statement 1, PK:15, text >+WHEN 'Let me assert my firm belief that the only thing we have to fear is fear itself.' >+THEN 'Let me assert my firm belief that the only thing we have to fear is fear itself.' >+-- Statement 1, PK:16, text >+WHEN 'If you can\'t stand the heat, get out of the kitchen.' >+THEN 'If you can\'t stand the heat, get out of the kitchen.' >+-- Statement 1, PK:17, text >+WHEN 'The atom bomb was no great decision. It was merely another powerful weapon in the arsenal of righteousness.' >+THEN 'The atom bomb was no great decision. It was merely another powerful weapon in the arsenal of righteousness.' >+-- Statement 1, PK:18, text >+WHEN 'The buck stops here.' >+THEN 'The buck stops here.' >+-- Statement 1, PK:19, text >+WHEN 'History does not long entrust the care of freedom to the weak or the timid.' >+THEN 'History does not long entrust the care of freedom to the weak or the timid.' >+-- Statement 1, PK:20, text >+WHEN 'My fellow Americans, ask not what your country can do for you; ask what you can do for your country.' >+THEN 'My fellow Americans, ask not what your country can do for you; ask what you can do for your country.' >+-- Statement 1, PK:22, text >+WHEN 'I do not think it altogether inappropriate to introduce myself to this audience. I am the man who accompanied Jacqueline Kennedy to Paris, and I have enjoyed it.' >+THEN 'I do not think it altogether inappropriate to introduce myself to this audience. I am the man who accompanied Jacqueline Kennedy to Paris, and I have enjoyed it.' >+-- Statement 1, PK:23, text >+WHEN 'The Great Society is a place where every child can find knowledge to enrich his mind and to enlarge his talents. It is a place where the city of man serves not only the needs of the body and the demands of commerce but the desire for beauty and the hunger for community. It is a place where men are more concerned with the quality of their goals than the quantity of their goods.' >+THEN 'The Great Society is a place where every child can find knowledge to enrich his mind and to enlarge his talents. It is a place where the city of man serves not only the needs of the body and the demands of commerce but the desire for beauty and the hunger for community. It is a place where men are more concerned with the quality of their goals than the quantity of their goods.' >+-- Statement 1, PK:24, text >+WHEN 'People have got to know whether or not their president is a crook. Well, I\'m not a crook.' >+THEN 'People have got to know whether or not their president is a crook. Well, I\'m not a crook.' >+-- Statement 1, PK:25, text >+WHEN 'When the President does it, that means that it is not illegal.' >+THEN 'When the President does it, that means that it is not illegal.' >+-- Statement 1, PK:26, text >+WHEN 'Our Long national nightmare is over.' >+THEN 'Our Long national nightmare is over.' >+-- Statement 1, PK:27, text >+WHEN 'Our constitution works. Our great republic is a government of laws, not of men.' >+THEN 'Our constitution works. Our great republic is a government of laws, not of men.' >+-- Statement 1, PK:28, text >+WHEN 'A strong nation, like a strong person, can afford to be gentle, firm, thoughtful, and restrained. It can afford to extend a helping hand to others. It\'s a weak nation, like a weak person, that must behave with bluster and boasting and rashness and other signs of insecurity.' >+THEN 'A strong nation, like a strong person, can afford to be gentle, firm, thoughtful, and restrained. It can afford to extend a helping hand to others. It\'s a weak nation, like a weak person, that must behave with bluster and boasting and rashness and other signs of insecurity.' >+-- Statement 1, PK:30, text >+WHEN 'It is not my intention to do away with government. It is rather to make it work -work with us, not over us; stand by our side, not ride on our back. Government can and must provide opportunity, not smother it; foster productivity, not stifle it. This Administration\'s objective will be a healthy, vigorous, growing economy.' >+THEN 'It is not my intention to do away with government. It is rather to make it work -work with us, not over us; stand by our side, not ride on our back. Government can and must provide opportunity, not smother it; foster productivity, not stifle it. This Administration\'s objective will be a healthy, vigorous, growing economy.' >+-- Statement 1, PK:31, text >+WHEN 'Each generation goes further than the generation preceding it because it stands on the shoulders of that generation. You will have opportunities beyond anything we\'ve ever known.' >+THEN 'Each generation goes further than the generation preceding it because it stands on the shoulders of that generation. You will have opportunities beyond anything we\'ve ever known.' >+-- Statement 1, PK:32, text >+WHEN 'We have ...drawn a line in the sand.' >+THEN 'We have ...drawn a line in the sand.' >+-- Statement 1, PK:33, text >+WHEN 'If America shows weakness and uncertainty, the world will drift toward tragedy. That will not happen on my watch.' >+THEN 'If America shows weakness and uncertainty, the world will drift toward tragedy. That will not happen on my watch.' >+-- Statement 1, PK:34, text >+WHEN 'Every nation in every region now has a decision to make. Either you are with us, or you are with the terrorists.' >+THEN 'Every nation in every region now has a decision to make. Either you are with us, or you are with the terrorists.' >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional.i18n/sample_quotes.txt b/installer/data/mysql/de-DE/optional.i18n/sample_quotes.txt >new file mode 100644 >index 0000000..18ac7cf >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/sample_quotes.txt >@@ -0,0 +1 @@ >+Sample quotes >-- >1.7.7.6
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10521
:
20166
|
20167
|
20168
|
20169
| 20170 |
20171
|
20172
|
20173