View | Details | Raw Unified | Return to bug 10521
Collapse All | Expand All

(-)a/installer/data/mysql/de-DE/optional.i18n/marc21_relatorterms.sql (+905 lines)
Line 0 Link Here
1
DELIMITER //
2
DROP FUNCTION IF EXISTS i18n//
3
CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
4
BEGIN
5
RETURN CASE d
6
WHEN '' THEN ''
7
8
-- MARC code list for Relators, taken from
9
-- http://www.loc.gov/marc/relators/relacode.html
10
11
-- Statement 1, PK:'RELTERMS','acp', lib
12
WHEN 'Art copyist'
13
THEN 'Art copyist'
14
15
-- Statement 2, PK:'RELTERMS','act', lib
16
WHEN 'Actor'
17
THEN 'Actor'
18
19
-- Statement 3, PK:'RELTERMS','adp', lib
20
WHEN 'Adapter'
21
THEN 'Adapter'
22
23
-- Statement 4, PK:'RELTERMS','aft', lib
24
WHEN 'Author of afterword, colophon, etc.'
25
THEN 'Author of afterword, colophon, etc.'
26
27
-- Statement 5, PK:'RELTERMS','anl', lib
28
WHEN 'Analyst'
29
THEN 'Analyst'
30
31
-- Statement 6, PK:'RELTERMS','anm', lib
32
WHEN 'Animator'
33
THEN 'Animator'
34
35
-- Statement 7, PK:'RELTERMS','ann', lib
36
WHEN 'Annotator'
37
THEN 'Annotator'
38
39
-- Statement 8, PK:'RELTERMS','ant', lib
40
WHEN 'Bibliographic antecedent'
41
THEN 'Bibliographic antecedent'
42
43
-- Statement 9, PK:'RELTERMS','app', lib
44
WHEN 'Applicant'
45
THEN 'Applicant'
46
47
-- Statement 10, PK:'RELTERMS','aqt', lib
48
WHEN 'Author in quotations or text abstracts'
49
THEN 'Author in quotations or text abstracts'
50
51
-- Statement 11, PK:'RELTERMS','arc', lib
52
WHEN 'Architect'
53
THEN 'Architect'
54
55
-- Statement 12, PK:'RELTERMS','ard', lib
56
WHEN 'Artistic director'
57
THEN 'Artistic director'
58
59
-- Statement 13, PK:'RELTERMS','arr', lib
60
WHEN 'Arranger'
61
THEN 'Arranger'
62
63
-- Statement 14, PK:'RELTERMS','art', lib
64
WHEN 'Artist'
65
THEN 'Artist'
66
67
-- Statement 15, PK:'RELTERMS','asg', lib
68
WHEN 'Assignee'
69
THEN 'Assignee'
70
71
-- Statement 16, PK:'RELTERMS','asn', lib
72
WHEN 'Associated name'
73
THEN 'Associated name'
74
75
-- Statement 17, PK:'RELTERMS','att', lib
76
WHEN 'Attributed name'
77
THEN 'Attributed name'
78
79
-- Statement 18, PK:'RELTERMS','auc', lib
80
WHEN 'Auctioneer'
81
THEN 'Auctioneer'
82
83
-- Statement 19, PK:'RELTERMS','aud', lib
84
WHEN 'Author of dialog'
85
THEN 'Author of dialog'
86
87
-- Statement 20, PK:'RELTERMS','aui', lib
88
WHEN 'Author of introduction'
89
THEN 'Author of introduction'
90
91
-- Statement 21, PK:'RELTERMS','aus', lib
92
WHEN 'Author of screenplay'
93
THEN 'Author of screenplay'
94
95
-- Statement 22, PK:'RELTERMS','aut', lib
96
WHEN 'Author'
97
THEN 'Author'
98
99
-- Statement 23, PK:'RELTERMS','bdd', lib
100
WHEN 'Binding designer'
101
THEN 'Binding designer'
102
103
-- Statement 24, PK:'RELTERMS','bjd', lib
104
WHEN 'Bookjacket designer'
105
THEN 'Bookjacket designer'
106
107
-- Statement 25, PK:'RELTERMS','bkd', lib
108
WHEN 'Book designer'
109
THEN 'Book designer'
110
111
-- Statement 26, PK:'RELTERMS','bkp', lib
112
WHEN 'Book producer'
113
THEN 'Book producer'
114
115
-- Statement 27, PK:'RELTERMS','blw', lib
116
WHEN 'Blurb writer'
117
THEN 'Blurb writer'
118
119
-- Statement 28, PK:'RELTERMS','bnd', lib
120
WHEN 'Binder'
121
THEN 'Binder'
122
123
-- Statement 29, PK:'RELTERMS','bpd', lib
124
WHEN 'Bookplate designer'
125
THEN 'Bookplate designer'
126
127
-- Statement 30, PK:'RELTERMS','bsl', lib
128
WHEN 'Bookseller'
129
THEN 'Bookseller'
130
131
-- Statement 31, PK:'RELTERMS','ccp', lib
132
WHEN 'Conceptor'
133
THEN 'Conceptor'
134
135
-- Statement 32, PK:'RELTERMS','chr', lib
136
WHEN 'Choreographer'
137
THEN 'Choreographer'
138
139
-- Statement 33, PK:'RELTERMS','clb', lib
140
WHEN 'Collaborator'
141
THEN 'Collaborator'
142
143
-- Statement 34, PK:'RELTERMS','cli', lib
144
WHEN 'Client'
145
THEN 'Client'
146
147
-- Statement 35, PK:'RELTERMS','cll', lib
148
WHEN 'Calligrapher'
149
THEN 'Calligrapher'
150
151
-- Statement 36, PK:'RELTERMS','clr', lib
152
WHEN 'Colorist'
153
THEN 'Colorist'
154
155
-- Statement 37, PK:'RELTERMS','clt', lib
156
WHEN 'Collotyper'
157
THEN 'Collotyper'
158
159
-- Statement 38, PK:'RELTERMS','cmm', lib
160
WHEN 'Commentator'
161
THEN 'Commentator'
162
163
-- Statement 39, PK:'RELTERMS','cmp', lib
164
WHEN 'Composer'
165
THEN 'Composer'
166
167
-- Statement 40, PK:'RELTERMS','cmt', lib
168
WHEN 'Compositor'
169
THEN 'Compositor'
170
171
-- Statement 41, PK:'RELTERMS','cng', lib
172
WHEN 'Cinematographer'
173
THEN 'Cinematographer'
174
175
-- Statement 42, PK:'RELTERMS','cnd', lib
176
WHEN 'Conductor'
177
THEN 'Conductor'
178
179
-- Statement 43, PK:'RELTERMS','cns', lib
180
WHEN 'Censor'
181
THEN 'Censor'
182
183
-- Statement 44, PK:'RELTERMS','coe', lib
184
WHEN 'Contestant -appellee'
185
THEN 'Contestant -appellee'
186
187
-- Statement 45, PK:'RELTERMS','col', lib
188
WHEN 'Collector'
189
THEN 'Collector'
190
191
-- Statement 46, PK:'RELTERMS','com', lib
192
WHEN 'Compiler'
193
THEN 'Compiler'
194
195
-- Statement 47, PK:'RELTERMS','con', lib
196
WHEN 'Conservator'
197
THEN 'Conservator'
198
199
-- Statement 48, PK:'RELTERMS','cos', lib
200
WHEN 'Contestant'
201
THEN 'Contestant'
202
203
-- Statement 49, PK:'RELTERMS','cot', lib
204
WHEN 'Contestant -appellant'
205
THEN 'Contestant -appellant'
206
207
-- Statement 50, PK:'RELTERMS','cov', lib
208
WHEN 'Cover designer'
209
THEN 'Cover designer'
210
211
-- Statement 51, PK:'RELTERMS','cpc', lib
212
WHEN 'Copyright claimant'
213
THEN 'Copyright claimant'
214
215
-- Statement 52, PK:'RELTERMS','cpe', lib
216
WHEN 'Complainant-appellee'
217
THEN 'Complainant-appellee'
218
219
-- Statement 53, PK:'RELTERMS','cph', lib
220
WHEN 'Copyright holder'
221
THEN 'Copyright holder'
222
223
-- Statement 54, PK:'RELTERMS','cpl', lib
224
WHEN 'Complainant'
225
THEN 'Complainant'
226
227
-- Statement 55, PK:'RELTERMS','cpt', lib
228
WHEN 'Complainant-appellant'
229
THEN 'Complainant-appellant'
230
231
-- Statement 56, PK:'RELTERMS','cre', lib
232
WHEN 'Creator'
233
THEN 'Creator'
234
235
-- Statement 57, PK:'RELTERMS','crp', lib
236
WHEN 'Correspondent'
237
THEN 'Correspondent'
238
239
-- Statement 58, PK:'RELTERMS','crr', lib
240
WHEN 'Corrector'
241
THEN 'Corrector'
242
243
-- Statement 59, PK:'RELTERMS','csl', lib
244
WHEN 'Consultant'
245
THEN 'Consultant'
246
247
-- Statement 60, PK:'RELTERMS','csp', lib
248
WHEN 'Consultant to a project'
249
THEN 'Consultant to a project'
250
251
-- Statement 61, PK:'RELTERMS','cst', lib
252
WHEN 'Costume designer'
253
THEN 'Costume designer'
254
255
-- Statement 62, PK:'RELTERMS','ctb', lib
256
WHEN 'Contributor'
257
THEN 'Contributor'
258
259
-- Statement 63, PK:'RELTERMS','cte', lib
260
WHEN 'Contestee-appellee'
261
THEN 'Contestee-appellee'
262
263
-- Statement 64, PK:'RELTERMS','ctg', lib
264
WHEN 'Cartographer'
265
THEN 'Cartographer'
266
267
-- Statement 65, PK:'RELTERMS','ctr', lib
268
WHEN 'Contractor'
269
THEN 'Contractor'
270
271
-- Statement 66, PK:'RELTERMS','cts', lib
272
WHEN 'Contestee'
273
THEN 'Contestee'
274
275
-- Statement 67, PK:'RELTERMS','ctt', lib
276
WHEN 'Contestee-appellant'
277
THEN 'Contestee-appellant'
278
279
-- Statement 68, PK:'RELTERMS','cur', lib
280
WHEN 'Curator'
281
THEN 'Curator'
282
283
-- Statement 69, PK:'RELTERMS','cwt', lib
284
WHEN 'Commentator for written text'
285
THEN 'Commentator for written text'
286
287
-- Statement 70, PK:'RELTERMS','dfd', lib
288
WHEN 'Defendant'
289
THEN 'Defendant'
290
291
-- Statement 71, PK:'RELTERMS','dfe', lib
292
WHEN 'Defendant-appellee'
293
THEN 'Defendant-appellee'
294
295
-- Statement 72, PK:'RELTERMS','dft', lib
296
WHEN 'Defendant-appellant'
297
THEN 'Defendant-appellant'
298
299
-- Statement 73, PK:'RELTERMS','dgg', lib
300
WHEN 'Degree grantor'
301
THEN 'Degree grantor'
302
303
-- Statement 74, PK:'RELTERMS','dis', lib
304
WHEN 'Dissertant'
305
THEN 'Dissertant'
306
307
-- Statement 75, PK:'RELTERMS','dln', lib
308
WHEN 'Delineator'
309
THEN 'Delineator'
310
311
-- Statement 76, PK:'RELTERMS','dnc', lib
312
WHEN 'Dancer'
313
THEN 'Dancer'
314
315
-- Statement 77, PK:'RELTERMS','dnr', lib
316
WHEN 'Donor'
317
THEN 'Donor'
318
319
-- Statement 78, PK:'RELTERMS','dpb', lib
320
WHEN 'Distribution place'
321
THEN 'Distribution place'
322
323
-- Statement 79, PK:'RELTERMS','dpc', lib
324
WHEN 'Depicted'
325
THEN 'Depicted'
326
327
-- Statement 80, PK:'RELTERMS','dpt', lib
328
WHEN 'Depositor'
329
THEN 'Depositor'
330
331
-- Statement 81, PK:'RELTERMS','drm', lib
332
WHEN 'Draftsman'
333
THEN 'Draftsman'
334
335
-- Statement 82, PK:'RELTERMS','drt', lib
336
WHEN 'Director'
337
THEN 'Director'
338
339
-- Statement 83, PK:'RELTERMS','dsr', lib
340
WHEN 'Designer'
341
THEN 'Designer'
342
343
-- Statement 84, PK:'RELTERMS','dst', lib
344
WHEN 'Distributor'
345
THEN 'Distributor'
346
347
-- Statement 85, PK:'RELTERMS','dtc', lib
348
WHEN 'Data contributor'
349
THEN 'Data contributor'
350
351
-- Statement 86, PK:'RELTERMS','dte', lib
352
WHEN 'Dedicatee'
353
THEN 'Dedicatee'
354
355
-- Statement 87, PK:'RELTERMS','dtm', lib
356
WHEN 'Data manager'
357
THEN 'Data manager'
358
359
-- Statement 88, PK:'RELTERMS','dto', lib
360
WHEN 'Dedicator'
361
THEN 'Dedicator'
362
363
-- Statement 89, PK:'RELTERMS','dub', lib
364
WHEN 'Dubious author'
365
THEN 'Dubious author'
366
367
-- Statement 90, PK:'RELTERMS','edt', lib
368
WHEN 'Editor'
369
THEN 'Editor'
370
371
-- Statement 91, PK:'RELTERMS','egr', lib
372
WHEN 'Engraver'
373
THEN 'Engraver'
374
375
-- Statement 92, PK:'RELTERMS','elg', lib
376
WHEN 'Electrician'
377
THEN 'Electrician'
378
379
-- Statement 93, PK:'RELTERMS','elt', lib
380
WHEN 'Electrotyper'
381
THEN 'Electrotyper'
382
383
-- Statement 94, PK:'RELTERMS','eng', lib
384
WHEN 'Engineer'
385
THEN 'Engineer'
386
387
-- Statement 95, PK:'RELTERMS','etr', lib
388
WHEN 'Etcher'
389
THEN 'Etcher'
390
391
-- Statement 96, PK:'RELTERMS','evp', lib
392
WHEN 'Event place'
393
THEN 'Event place'
394
395
-- Statement 97, PK:'RELTERMS','exp', lib
396
WHEN 'Expert'
397
THEN 'Expert'
398
399
-- Statement 98, PK:'RELTERMS','fac', lib
400
WHEN 'Facsimilist'
401
THEN 'Facsimilist'
402
403
-- Statement 99, PK:'RELTERMS','fld', lib
404
WHEN 'Field director'
405
THEN 'Field director'
406
407
-- Statement 100, PK:'RELTERMS','flm', lib
408
WHEN 'Film editor'
409
THEN 'Film editor'
410
411
-- Statement 101, PK:'RELTERMS','fmo', lib
412
WHEN 'Former owner'
413
THEN 'Former owner'
414
415
-- Statement 102, PK:'RELTERMS','fpy', lib
416
WHEN 'First party'
417
THEN 'First party'
418
419
-- Statement 103, PK:'RELTERMS','fnd', lib
420
WHEN 'Funder'
421
THEN 'Funder'
422
423
-- Statement 104, PK:'RELTERMS','frg', lib
424
WHEN 'Forger'
425
THEN 'Forger'
426
427
-- Statement 105, PK:'RELTERMS','gis', lib
428
WHEN 'Geographic information specialist'
429
THEN 'Geographic information specialist'
430
431
-- Statement 106, PK:'RELTERMS','-grt', lib
432
WHEN 'Graphic technician'
433
THEN 'Graphic technician'
434
435
-- Statement 107, PK:'RELTERMS','hnr', lib
436
WHEN 'Honoree'
437
THEN 'Honoree'
438
439
-- Statement 108, PK:'RELTERMS','hst', lib
440
WHEN 'Host'
441
THEN 'Host'
442
443
-- Statement 109, PK:'RELTERMS','ill', lib
444
WHEN 'Illustrator'
445
THEN 'Illustrator'
446
447
-- Statement 110, PK:'RELTERMS','ilu', lib
448
WHEN 'Illuminator'
449
THEN 'Illuminator'
450
451
-- Statement 111, PK:'RELTERMS','ins', lib
452
WHEN 'Inscriber'
453
THEN 'Inscriber'
454
455
-- Statement 112, PK:'RELTERMS','inv', lib
456
WHEN 'Inventor'
457
THEN 'Inventor'
458
459
-- Statement 113, PK:'RELTERMS','itr', lib
460
WHEN 'Instrumentalist'
461
THEN 'Instrumentalist'
462
463
-- Statement 114, PK:'RELTERMS','ive', lib
464
WHEN 'Interviewee'
465
THEN 'Interviewee'
466
467
-- Statement 115, PK:'RELTERMS','ivr', lib
468
WHEN 'Interviewer'
469
THEN 'Interviewer'
470
471
-- Statement 116, PK:'RELTERMS','lbr', lib
472
WHEN 'Laboratory'
473
THEN 'Laboratory'
474
475
-- Statement 117, PK:'RELTERMS','lbt', lib
476
WHEN 'Librettist'
477
THEN 'Librettist'
478
479
-- Statement 118, PK:'RELTERMS','ldr', lib
480
WHEN 'Laboratory director'
481
THEN 'Laboratory director'
482
483
-- Statement 119, PK:'RELTERMS','led', lib
484
WHEN 'Lead'
485
THEN 'Lead'
486
487
-- Statement 120, PK:'RELTERMS','lee', lib
488
WHEN 'Libelee-appellee'
489
THEN 'Libelee-appellee'
490
491
-- Statement 121, PK:'RELTERMS','lel', lib
492
WHEN 'Libelee'
493
THEN 'Libelee'
494
495
-- Statement 122, PK:'RELTERMS','len', lib
496
WHEN 'Lender'
497
THEN 'Lender'
498
499
-- Statement 123, PK:'RELTERMS','let', lib
500
WHEN 'Libelee-appellant'
501
THEN 'Libelee-appellant'
502
503
-- Statement 124, PK:'RELTERMS','lgd', lib
504
WHEN 'Lighting designer'
505
THEN 'Lighting designer'
506
507
-- Statement 125, PK:'RELTERMS','lie', lib
508
WHEN 'Libelant-appellee'
509
THEN 'Libelant-appellee'
510
511
-- Statement 126, PK:'RELTERMS','lil', lib
512
WHEN 'Libelant'
513
THEN 'Libelant'
514
515
-- Statement 127, PK:'RELTERMS','lit', lib
516
WHEN 'Libelant-appellant'
517
THEN 'Libelant-appellant'
518
519
-- Statement 128, PK:'RELTERMS','lsa', lib
520
WHEN 'Landscape architect'
521
THEN 'Landscape architect'
522
523
-- Statement 129, PK:'RELTERMS','lse', lib
524
WHEN 'Licensee'
525
THEN 'Licensee'
526
527
-- Statement 130, PK:'RELTERMS','lso', lib
528
WHEN 'Licensor'
529
THEN 'Licensor'
530
531
-- Statement 131, PK:'RELTERMS','ltg', lib
532
WHEN 'Lithographer'
533
THEN 'Lithographer'
534
535
-- Statement 132, PK:'RELTERMS','lyr', lib
536
WHEN 'Lyricist'
537
THEN 'Lyricist'
538
539
-- Statement 133, PK:'RELTERMS','mcp', lib
540
WHEN 'Music copyist'
541
THEN 'Music copyist'
542
543
-- Statement 134, PK:'RELTERMS','mfp', lib
544
WHEN 'Manufacture place'
545
THEN 'Manufacture place'
546
547
-- Statement 135, PK:'RELTERMS','mfr', lib
548
WHEN 'Manufacturer'
549
THEN 'Manufacturer'
550
551
-- Statement 136, PK:'RELTERMS','mdc', lib
552
WHEN 'Metadata contact'
553
THEN 'Metadata contact'
554
555
-- Statement 137, PK:'RELTERMS','mod', lib
556
WHEN 'Moderator'
557
THEN 'Moderator'
558
559
-- Statement 138, PK:'RELTERMS','mon', lib
560
WHEN 'Monitor'
561
THEN 'Monitor'
562
563
-- Statement 139, PK:'RELTERMS','mrb', lib
564
WHEN 'Marbler'
565
THEN 'Marbler'
566
567
-- Statement 140, PK:'RELTERMS','mrk', lib
568
WHEN 'Markup editor'
569
THEN 'Markup editor'
570
571
-- Statement 141, PK:'RELTERMS','msd', lib
572
WHEN 'Musical director'
573
THEN 'Musical director'
574
575
-- Statement 142, PK:'RELTERMS','mte', lib
576
WHEN 'Metal-engraver'
577
THEN 'Metal-engraver'
578
579
-- Statement 143, PK:'RELTERMS','mus', lib
580
WHEN 'Musician'
581
THEN 'Musician'
582
583
-- Statement 144, PK:'RELTERMS','nrt', lib
584
WHEN 'Narrator'
585
THEN 'Narrator'
586
587
-- Statement 145, PK:'RELTERMS','opn', lib
588
WHEN 'Opponent'
589
THEN 'Opponent'
590
591
-- Statement 146, PK:'RELTERMS','org', lib
592
WHEN 'Originator'
593
THEN 'Originator'
594
595
-- Statement 147, PK:'RELTERMS','orm', lib
596
WHEN 'Organizer of meeting'
597
THEN 'Organizer of meeting'
598
599
-- Statement 148, PK:'RELTERMS','oth', lib
600
WHEN 'Other'
601
THEN 'Other'
602
603
-- Statement 149, PK:'RELTERMS','own', lib
604
WHEN 'Owner'
605
THEN 'Owner'
606
607
-- Statement 150, PK:'RELTERMS','pat', lib
608
WHEN 'Patron'
609
THEN 'Patron'
610
611
-- Statement 151, PK:'RELTERMS','pbd', lib
612
WHEN 'Publishing director'
613
THEN 'Publishing director'
614
615
-- Statement 152, PK:'RELTERMS','pbl', lib
616
WHEN 'Publisher'
617
THEN 'Publisher'
618
619
-- Statement 153, PK:'RELTERMS','pdr', lib
620
WHEN 'Project director'
621
THEN 'Project director'
622
623
-- Statement 154, PK:'RELTERMS','pfr', lib
624
WHEN 'Proofreader'
625
THEN 'Proofreader'
626
627
-- Statement 155, PK:'RELTERMS','pht', lib
628
WHEN 'Photographer'
629
THEN 'Photographer'
630
631
-- Statement 156, PK:'RELTERMS','plt', lib
632
WHEN 'Platemaker'
633
THEN 'Platemaker'
634
635
-- Statement 157, PK:'RELTERMS','pma', lib
636
WHEN 'Permitting agency'
637
THEN 'Permitting agency'
638
639
-- Statement 158, PK:'RELTERMS','pmn', lib
640
WHEN 'Production manager'
641
THEN 'Production manager'
642
643
-- Statement 159, PK:'RELTERMS','pop', lib
644
WHEN 'Printer of plates'
645
THEN 'Printer of plates'
646
647
-- Statement 160, PK:'RELTERMS','ppm', lib
648
WHEN 'Papermaker'
649
THEN 'Papermaker'
650
651
-- Statement 161, PK:'RELTERMS','ppt', lib
652
WHEN 'Puppeteer'
653
THEN 'Puppeteer'
654
655
-- Statement 162, PK:'RELTERMS','prc', lib
656
WHEN 'Process contact'
657
THEN 'Process contact'
658
659
-- Statement 163, PK:'RELTERMS','prd', lib
660
WHEN 'Production personnel'
661
THEN 'Production personnel'
662
663
-- Statement 164, PK:'RELTERMS','prf', lib
664
WHEN 'Performer'
665
THEN 'Performer'
666
667
-- Statement 165, PK:'RELTERMS','prg', lib
668
WHEN 'Programmer'
669
THEN 'Programmer'
670
671
-- Statement 166, PK:'RELTERMS','prm', lib
672
WHEN 'Printmaker'
673
THEN 'Printmaker'
674
675
-- Statement 167, PK:'RELTERMS','pro', lib
676
WHEN 'Producer'
677
THEN 'Producer'
678
679
-- Statement 168, PK:'RELTERMS','prp', lib
680
WHEN 'Production place'
681
THEN 'Production place'
682
683
-- Statement 169, PK:'RELTERMS','prt', lib
684
WHEN 'Printer'
685
THEN 'Printer'
686
687
-- Statement 170, PK:'RELTERMS','pta', lib
688
WHEN 'Patent applicant'
689
THEN 'Patent applicant'
690
691
-- Statement 171, PK:'RELTERMS','pte', lib
692
WHEN 'Plaintiff -appellee'
693
THEN 'Plaintiff -appellee'
694
695
-- Statement 172, PK:'RELTERMS','ptf', lib
696
WHEN 'Plaintiff'
697
THEN 'Plaintiff'
698
699
-- Statement 173, PK:'RELTERMS','pth', lib
700
WHEN 'Patent holder'
701
THEN 'Patent holder'
702
703
-- Statement 174, PK:'RELTERMS','ptt', lib
704
WHEN 'Plaintiff-appellant'
705
THEN 'Plaintiff-appellant'
706
707
-- Statement 175, PK:'RELTERMS','pup', lib
708
WHEN 'Publication place'
709
THEN 'Publication place'
710
711
-- Statement 176, PK:'RELTERMS','rbr', lib
712
WHEN 'Rubricator'
713
THEN 'Rubricator'
714
715
-- Statement 177, PK:'RELTERMS','rce', lib
716
WHEN 'Recording engineer'
717
THEN 'Recording engineer'
718
719
-- Statement 178, PK:'RELTERMS','rcp', lib
720
WHEN 'Recipient'
721
THEN 'Recipient'
722
723
-- Statement 179, PK:'RELTERMS','red', lib
724
WHEN 'Redactor'
725
THEN 'Redactor'
726
727
-- Statement 180, PK:'RELTERMS','ren', lib
728
WHEN 'Renderer'
729
THEN 'Renderer'
730
731
-- Statement 181, PK:'RELTERMS','res', lib
732
WHEN 'Researcher'
733
THEN 'Researcher'
734
735
-- Statement 182, PK:'RELTERMS','rev', lib
736
WHEN 'Reviewer'
737
THEN 'Reviewer'
738
739
-- Statement 183, PK:'RELTERMS','rps', lib
740
WHEN 'Repository'
741
THEN 'Repository'
742
743
-- Statement 184, PK:'RELTERMS','rpt', lib
744
WHEN 'Reporter'
745
THEN 'Reporter'
746
747
-- Statement 185, PK:'RELTERMS','rpy', lib
748
WHEN 'Responsible party'
749
THEN 'Responsible party'
750
751
-- Statement 186, PK:'RELTERMS','rse', lib
752
WHEN 'Respondent-appellee'
753
THEN 'Respondent-appellee'
754
755
-- Statement 187, PK:'RELTERMS','rsg', lib
756
WHEN 'Restager'
757
THEN 'Restager'
758
759
-- Statement 188, PK:'RELTERMS','rsp', lib
760
WHEN 'Respondent'
761
THEN 'Respondent'
762
763
-- Statement 189, PK:'RELTERMS','rst', lib
764
WHEN 'Respondent-appellant'
765
THEN 'Respondent-appellant'
766
767
-- Statement 190, PK:'RELTERMS','rth', lib
768
WHEN 'Research team head'
769
THEN 'Research team head'
770
771
-- Statement 191, PK:'RELTERMS','rtm', lib
772
WHEN 'Research team member'
773
THEN 'Research team member'
774
775
-- Statement 192, PK:'RELTERMS','sad', lib
776
WHEN 'Scientific advisor'
777
THEN 'Scientific advisor'
778
779
-- Statement 193, PK:'RELTERMS','sce', lib
780
WHEN 'Scenarist'
781
THEN 'Scenarist'
782
783
-- Statement 194, PK:'RELTERMS','scl', lib
784
WHEN 'Sculptor'
785
THEN 'Sculptor'
786
787
-- Statement 195, PK:'RELTERMS','scr', lib
788
WHEN 'Scribe'
789
THEN 'Scribe'
790
791
-- Statement 196, PK:'RELTERMS','sds', lib
792
WHEN 'Sound designer'
793
THEN 'Sound designer'
794
795
-- Statement 197, PK:'RELTERMS','sec', lib
796
WHEN 'Secretary'
797
THEN 'Secretary'
798
799
-- Statement 198, PK:'RELTERMS','sgn', lib
800
WHEN 'Signer'
801
THEN 'Signer'
802
803
-- Statement 199, PK:'RELTERMS','sht', lib
804
WHEN 'Supporting host'
805
THEN 'Supporting host'
806
807
-- Statement 200, PK:'RELTERMS','sng', lib
808
WHEN 'Singer'
809
THEN 'Singer'
810
811
-- Statement 201, PK:'RELTERMS','spk', lib
812
WHEN 'Speaker'
813
THEN 'Speaker'
814
815
-- Statement 202, PK:'RELTERMS','spn', lib
816
WHEN 'Sponsor'
817
THEN 'Sponsor'
818
819
-- Statement 203, PK:'RELTERMS','spy', lib
820
WHEN 'Second party'
821
THEN 'Second party'
822
823
-- Statement 204, PK:'RELTERMS','srv', lib
824
WHEN 'Surveyor'
825
THEN 'Surveyor'
826
827
-- Statement 205, PK:'RELTERMS','std', lib
828
WHEN 'Set designer'
829
THEN 'Set designer'
830
831
-- Statement 206, PK:'RELTERMS','stl', lib
832
WHEN 'Storyteller'
833
THEN 'Storyteller'
834
835
-- Statement 207, PK:'RELTERMS','stm', lib
836
WHEN 'Stage manager'
837
THEN 'Stage manager'
838
839
-- Statement 208, PK:'RELTERMS','stn', lib
840
WHEN 'Standards body'
841
THEN 'Standards body'
842
843
-- Statement 209, PK:'RELTERMS','str', lib
844
WHEN 'Stereotyper'
845
THEN 'Stereotyper'
846
847
-- Statement 210, PK:'RELTERMS','tcd', lib
848
WHEN 'Technical director'
849
THEN 'Technical director'
850
851
-- Statement 211, PK:'RELTERMS','tch', lib
852
WHEN 'Teacher'
853
THEN 'Teacher'
854
855
-- Statement 212, PK:'RELTERMS','ths', lib
856
WHEN 'Thesis advisor'
857
THEN 'Thesis advisor'
858
859
-- Statement 213, PK:'RELTERMS','trc', lib
860
WHEN 'Transcriber'
861
THEN 'Transcriber'
862
863
-- Statement 214, PK:'RELTERMS','trl', lib
864
WHEN 'Translator'
865
THEN 'Translator'
866
867
-- Statement 215, PK:'RELTERMS','tyd', lib
868
WHEN 'Type designer'
869
THEN 'Type designer'
870
871
-- Statement 216, PK:'RELTERMS','tyg', lib
872
WHEN 'Typographer'
873
THEN 'Typographer'
874
875
-- Statement 217, PK:'RELTERMS','uvp', lib
876
WHEN 'University place'
877
THEN 'University place'
878
879
-- Statement 218, PK:'RELTERMS','vdg', lib
880
WHEN 'Videographer'
881
THEN 'Videographer'
882
883
-- Statement 219, PK:'RELTERMS','voc', lib
884
WHEN 'Vocalist'
885
THEN 'Vocalist'
886
887
-- Statement 220, PK:'RELTERMS','wam', lib
888
WHEN 'Writer of accompanying material'
889
THEN 'Writer of accompanying material'
890
891
-- Statement 221, PK:'RELTERMS','wdc', lib
892
WHEN 'Woodcutter'
893
THEN 'Woodcutter'
894
895
-- Statement 222, PK:'RELTERMS','wde', lib
896
WHEN 'Wood-engraver'
897
THEN 'Wood-engraver'
898
899
-- Statement 223, PK:'RELTERMS','wit', lib
900
WHEN 'Witness'
901
THEN 'Witness'
902
903
ELSE d
904
END;
905
END //
(-)a/installer/data/mysql/de-DE/optional.i18n/marc21_relatorterms.txt (+1 lines)
Line 0 Link Here
1
MARC code list for relators, as of http://www.loc.gov/marc/relators/relaterm.html
(-)a/installer/data/mysql/de-DE/optional.i18n/sample_quotes.sql (+103 lines)
Line 0 Link Here
1
DELIMITER //
2
DROP FUNCTION IF EXISTS i18n//
3
CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
4
BEGIN
5
RETURN CASE d
6
WHEN '' THEN ''
7
-- Statement 1, PK:1, text
8
WHEN 'To be prepared for war is one of the most effectual means of preserving peace.'
9
THEN 'To be prepared for war is one of the most effectual means of preserving peace.'
10
-- Statement 1, PK:2, text
11
WHEN 'When angry, count ten, before you speak; if very angry, an hundred.'
12
THEN 'When angry, count ten, before you speak; if very angry, an hundred.'
13
-- Statement 1, PK:3, text
14
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.'
15
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.'
16
-- Statement 1, PK:4, text
17
WHEN 'I have always found that mercy bears richer fruits than strict justice.'
18
THEN 'I have always found that mercy bears richer fruits than strict justice.'
19
-- Statement 1, PK:5, text
20
WHEN 'I feel incompetent to perform duties...which have been so unexpectedly thrown upon me.'
21
THEN 'I feel incompetent to perform duties...which have been so unexpectedly thrown upon me.'
22
-- Statement 1, PK:6, text
23
WHEN 'He serves his party best who serves his country best.'
24
THEN 'He serves his party best who serves his country best.'
25
-- Statement 1, PK:7, text
26
WHEN 'No President has ever enjoyed himself as much as I?'
27
THEN 'No President has ever enjoyed himself as much as I?'
28
-- Statement 1, PK:8, text
29
WHEN 'Speak softly and carry a big stick.'
30
THEN 'Speak softly and carry a big stick.'
31
-- Statement 1, PK:9, text
32
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.'
33
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.'
34
-- Statement 1, PK:11, text
35
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.'
36
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.'
37
-- Statement 1, PK:12, text
38
WHEN 'If you don\'t say anything, you won\'t be called on to repeat it.'
39
THEN 'If you don\'t say anything, you won\'t be called on to repeat it.'
40
-- Statement 1, PK:13, text
41
WHEN 'Four fifths of all our troubles in this life would disappear if we would only sit down and keep still.'
42
THEN 'Four fifths of all our troubles in this life would disappear if we would only sit down and keep still.'
43
-- Statement 1, PK:14, text
44
WHEN 'The slogan of progress is changing from the full dinner pail to the full garage.'
45
THEN 'The slogan of progress is changing from the full dinner pail to the full garage.'
46
-- Statement 1, PK:15, text
47
WHEN 'Let me assert my firm belief that the only thing we have to fear is fear itself.'
48
THEN 'Let me assert my firm belief that the only thing we have to fear is fear itself.'
49
-- Statement 1, PK:16, text
50
WHEN 'If you can\'t stand the heat, get out of the kitchen.'
51
THEN 'If you can\'t stand the heat, get out of the kitchen.'
52
-- Statement 1, PK:17, text
53
WHEN 'The atom bomb was no great decision. It was merely another powerful weapon in the arsenal of righteousness.'
54
THEN 'The atom bomb was no great decision. It was merely another powerful weapon in the arsenal of righteousness.'
55
-- Statement 1, PK:18, text
56
WHEN 'The buck stops here.'
57
THEN 'The buck stops here.'
58
-- Statement 1, PK:19, text
59
WHEN 'History does not long entrust the care of freedom to the weak or the timid.'
60
THEN 'History does not long entrust the care of freedom to the weak or the timid.'
61
-- Statement 1, PK:20, text
62
WHEN 'My fellow Americans, ask not what your country can do for you; ask what you can do for your country.'
63
THEN 'My fellow Americans, ask not what your country can do for you; ask what you can do for your country.'
64
-- Statement 1, PK:22, text
65
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.'
66
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.'
67
-- Statement 1, PK:23, text
68
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.'
69
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.'
70
-- Statement 1, PK:24, text
71
WHEN 'People have got to know whether or not their president is a crook. Well, I\'m not a crook.'
72
THEN 'People have got to know whether or not their president is a crook. Well, I\'m not a crook.'
73
-- Statement 1, PK:25, text
74
WHEN 'When the President does it, that means that it is not illegal.'
75
THEN 'When the President does it, that means that it is not illegal.'
76
-- Statement 1, PK:26, text
77
WHEN 'Our Long national nightmare is over.'
78
THEN 'Our Long national nightmare is over.'
79
-- Statement 1, PK:27, text
80
WHEN 'Our constitution works. Our great republic is a government of laws, not of men.'
81
THEN 'Our constitution works. Our great republic is a government of laws, not of men.'
82
-- Statement 1, PK:28, text
83
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.'
84
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.'
85
-- Statement 1, PK:30, text
86
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.'
87
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.'
88
-- Statement 1, PK:31, text
89
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.'
90
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.'
91
-- Statement 1, PK:32, text
92
WHEN 'We have ...drawn a line in the sand.'
93
THEN 'We have ...drawn a line in the sand.'
94
-- Statement 1, PK:33, text
95
WHEN 'If America shows weakness and uncertainty, the world will drift toward tragedy. That will not happen on my watch.'
96
THEN 'If America shows weakness and uncertainty, the world will drift toward tragedy. That will not happen on my watch.'
97
-- Statement 1, PK:34, text
98
WHEN 'Every nation in every region now has a decision to make. Either you are with us, or you are with the terrorists.'
99
THEN 'Every nation in every region now has a decision to make. Either you are with us, or you are with the terrorists.'
100
101
ELSE d
102
END;
103
END //
(-)a/installer/data/mysql/de-DE/optional.i18n/sample_quotes.txt (-1 / +1 lines)
Line 0 Link Here
0
- 
1
Sample quotes

Return to bug 10521