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

(-)a/installer/data/mysql/de-DE/optional/marc21_relatorterms.sql (+227 lines)
Line 0 Link Here
1
-- MARC code list for Relators, taken from
2
-- http://www.loc.gov/marc/relators/relacode.html
3
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor');
6
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter');
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author');
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst');
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator');
10
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator');
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic');
12
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant');
13
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author');
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect');
15
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic');
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger');
17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist');
18
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee');
19
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated');
20
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed');
21
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer');
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author');
23
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author');
24
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author');
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding');
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket');
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book');
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book');
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb');
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder');
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate');
33
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller');
34
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor');
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer');
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator');
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client');
38
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher');
39
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist');
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper');
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator');
42
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer');
43
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor');
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer');
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor');
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor');
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant');
48
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector');
49
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler');
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator');
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant');
52
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant');
53
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover');
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright');
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee');
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright');
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant');
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant');
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator');
60
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent');
61
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector');
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer');
68
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor');
69
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee');
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted');
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor');
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data');
89
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee');
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data');
91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator');
92
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious');
93
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor');
94
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver');
95
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician');
96
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper');
97
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer');
98
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher');
99
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event');
100
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert');
101
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist');
102
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field');
103
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film');
104
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former');
105
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First');
106
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder');
107
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger');
108
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic');
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic');
110
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree');
111
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host');
112
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator');
113
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator');
114
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber');
115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor');
116
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist');
117
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee');
118
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer');
119
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory');
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist');
121
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory');
122
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead');
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee');
124
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee');
125
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender');
126
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant');
127
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting');
128
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee');
129
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant');
130
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant');
131
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape');
132
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee');
133
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor');
134
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer');
135
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist');
136
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music');
137
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture');
138
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer');
139
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata');
140
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator');
141
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor');
142
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler');
143
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup');
144
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical');
145
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver');
146
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician');
147
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator');
148
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent');
149
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator');
150
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer');
151
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other');
152
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner');
153
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron');
154
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing');
155
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher');
156
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project');
157
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader');
158
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer');
159
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker');
160
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting');
161
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production');
162
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer');
163
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker');
164
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer');
165
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process');
166
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production');
167
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer');
168
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer');
169
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker');
170
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer');
171
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production');
172
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer');
173
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent');
174
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff');
175
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff');
176
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent');
177
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant');
178
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication');
179
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator');
180
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording');
181
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient');
182
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor');
183
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer');
184
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher');
185
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer');
186
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository');
187
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter');
188
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible');
189
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee');
190
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager');
191
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent');
192
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant');
193
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research');
194
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research');
195
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific');
196
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist');
197
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor');
198
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe');
199
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound');
200
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary');
201
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer');
202
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting');
203
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer');
204
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker');
205
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor');
206
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second');
207
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor');
208
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set');
209
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller');
210
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage');
211
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards');
212
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper');
213
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical');
214
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher');
215
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis');
216
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber');
217
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator');
218
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type');
219
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer');
220
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University');
221
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer');
222
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist');
223
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer');
224
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter');
225
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver');
226
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness');
227
(-)a/installer/data/mysql/de-DE/optional/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/en/optional/marc21_relatorterms.sql (+227 lines)
Line 0 Link Here
1
-- MARC code list for Relators, taken from
2
-- http://www.loc.gov/marc/relators/relacode.html
3
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor');
6
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter');
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author');
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst');
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator');
10
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator');
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic');
12
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant');
13
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author');
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect');
15
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic');
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger');
17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist');
18
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee');
19
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated');
20
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed');
21
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer');
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author');
23
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author');
24
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author');
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding');
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket');
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book');
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book');
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb');
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder');
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate');
33
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller');
34
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor');
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer');
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator');
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client');
38
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher');
39
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist');
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper');
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator');
42
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer');
43
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor');
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer');
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor');
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor');
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant');
48
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector');
49
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler');
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator');
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant');
52
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant');
53
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover');
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright');
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee');
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright');
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant');
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant');
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator');
60
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent');
61
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector');
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer');
68
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor');
69
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee');
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted');
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor');
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data');
89
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee');
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data');
91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator');
92
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious');
93
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor');
94
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver');
95
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician');
96
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper');
97
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer');
98
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher');
99
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event');
100
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert');
101
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist');
102
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field');
103
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film');
104
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former');
105
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First');
106
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder');
107
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger');
108
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic');
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic');
110
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree');
111
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host');
112
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator');
113
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator');
114
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber');
115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor');
116
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist');
117
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee');
118
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer');
119
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory');
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist');
121
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory');
122
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead');
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee');
124
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee');
125
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender');
126
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant');
127
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting');
128
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee');
129
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant');
130
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant');
131
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape');
132
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee');
133
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor');
134
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer');
135
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist');
136
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music');
137
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture');
138
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer');
139
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata');
140
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator');
141
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor');
142
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler');
143
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup');
144
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical');
145
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver');
146
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician');
147
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator');
148
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent');
149
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator');
150
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer');
151
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other');
152
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner');
153
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron');
154
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing');
155
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher');
156
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project');
157
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader');
158
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer');
159
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker');
160
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting');
161
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production');
162
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer');
163
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker');
164
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer');
165
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process');
166
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production');
167
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer');
168
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer');
169
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker');
170
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer');
171
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production');
172
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer');
173
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent');
174
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff');
175
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff');
176
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent');
177
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant');
178
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication');
179
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator');
180
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording');
181
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient');
182
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor');
183
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer');
184
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher');
185
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer');
186
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository');
187
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter');
188
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible');
189
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee');
190
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager');
191
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent');
192
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant');
193
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research');
194
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research');
195
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific');
196
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist');
197
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor');
198
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe');
199
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound');
200
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary');
201
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer');
202
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting');
203
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer');
204
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker');
205
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor');
206
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second');
207
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor');
208
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set');
209
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller');
210
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage');
211
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards');
212
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper');
213
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical');
214
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher');
215
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis');
216
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber');
217
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator');
218
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type');
219
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer');
220
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University');
221
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer');
222
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist');
223
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer');
224
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter');
225
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver');
226
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness');
227
(-)a/installer/data/mysql/en/optional/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/fr-FR/2-Optionel/marc21_relatorterms.sql (+227 lines)
Line 0 Link Here
1
-- MARC code list for Relators, taken from
2
-- http://www.loc.gov/marc/relators/relacode.html
3
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor');
6
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter');
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author');
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst');
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator');
10
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator');
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic');
12
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant');
13
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author');
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect');
15
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic');
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger');
17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist');
18
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee');
19
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated');
20
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed');
21
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer');
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author');
23
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author');
24
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author');
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding');
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket');
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book');
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book');
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb');
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder');
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate');
33
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller');
34
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor');
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer');
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator');
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client');
38
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher');
39
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist');
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper');
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator');
42
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer');
43
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor');
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer');
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor');
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor');
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant');
48
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector');
49
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler');
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator');
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant');
52
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant');
53
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover');
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright');
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee');
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright');
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant');
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant');
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator');
60
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent');
61
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector');
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer');
68
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor');
69
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee');
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted');
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor');
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data');
89
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee');
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data');
91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator');
92
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious');
93
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor');
94
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver');
95
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician');
96
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper');
97
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer');
98
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher');
99
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event');
100
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert');
101
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist');
102
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field');
103
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film');
104
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former');
105
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First');
106
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder');
107
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger');
108
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic');
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic');
110
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree');
111
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host');
112
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator');
113
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator');
114
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber');
115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor');
116
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist');
117
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee');
118
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer');
119
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory');
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist');
121
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory');
122
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead');
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee');
124
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee');
125
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender');
126
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant');
127
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting');
128
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee');
129
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant');
130
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant');
131
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape');
132
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee');
133
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor');
134
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer');
135
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist');
136
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music');
137
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture');
138
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer');
139
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata');
140
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator');
141
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor');
142
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler');
143
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup');
144
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical');
145
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver');
146
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician');
147
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator');
148
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent');
149
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator');
150
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer');
151
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other');
152
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner');
153
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron');
154
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing');
155
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher');
156
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project');
157
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader');
158
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer');
159
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker');
160
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting');
161
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production');
162
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer');
163
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker');
164
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer');
165
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process');
166
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production');
167
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer');
168
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer');
169
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker');
170
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer');
171
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production');
172
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer');
173
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent');
174
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff');
175
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff');
176
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent');
177
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant');
178
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication');
179
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator');
180
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording');
181
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient');
182
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor');
183
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer');
184
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher');
185
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer');
186
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository');
187
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter');
188
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible');
189
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee');
190
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager');
191
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent');
192
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant');
193
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research');
194
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research');
195
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific');
196
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist');
197
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor');
198
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe');
199
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound');
200
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary');
201
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer');
202
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting');
203
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer');
204
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker');
205
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor');
206
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second');
207
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor');
208
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set');
209
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller');
210
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage');
211
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards');
212
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper');
213
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical');
214
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher');
215
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis');
216
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber');
217
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator');
218
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type');
219
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer');
220
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University');
221
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer');
222
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist');
223
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer');
224
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter');
225
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver');
226
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness');
227
(-)a/installer/data/mysql/fr-FR/2-Optionel/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/nb-NO/2-Valgfritt/marc21_relatorterms.sql (+227 lines)
Line 0 Link Here
1
-- MARC code list for Relators, taken from
2
-- http://www.loc.gov/marc/relators/relacode.html
3
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor');
6
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter');
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author');
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst');
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator');
10
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator');
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic');
12
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant');
13
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author');
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect');
15
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic');
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger');
17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist');
18
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee');
19
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated');
20
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed');
21
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer');
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author');
23
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author');
24
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author');
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding');
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket');
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book');
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book');
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb');
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder');
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate');
33
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller');
34
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor');
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer');
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator');
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client');
38
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher');
39
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist');
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper');
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator');
42
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer');
43
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor');
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer');
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor');
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor');
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant');
48
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector');
49
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler');
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator');
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant');
52
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant');
53
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover');
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright');
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee');
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright');
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant');
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant');
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator');
60
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent');
61
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector');
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer');
68
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor');
69
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee');
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted');
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor');
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data');
89
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee');
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data');
91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator');
92
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious');
93
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor');
94
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver');
95
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician');
96
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper');
97
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer');
98
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher');
99
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event');
100
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert');
101
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist');
102
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field');
103
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film');
104
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former');
105
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First');
106
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder');
107
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger');
108
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic');
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic');
110
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree');
111
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host');
112
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator');
113
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator');
114
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber');
115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor');
116
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist');
117
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee');
118
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer');
119
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory');
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist');
121
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory');
122
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead');
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee');
124
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee');
125
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender');
126
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant');
127
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting');
128
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee');
129
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant');
130
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant');
131
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape');
132
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee');
133
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor');
134
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer');
135
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist');
136
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music');
137
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture');
138
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer');
139
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata');
140
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator');
141
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor');
142
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler');
143
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup');
144
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical');
145
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver');
146
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician');
147
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator');
148
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent');
149
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator');
150
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer');
151
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other');
152
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner');
153
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron');
154
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing');
155
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher');
156
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project');
157
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader');
158
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer');
159
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker');
160
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting');
161
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production');
162
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer');
163
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker');
164
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer');
165
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process');
166
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production');
167
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer');
168
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer');
169
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker');
170
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer');
171
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production');
172
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer');
173
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent');
174
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff');
175
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff');
176
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent');
177
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant');
178
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication');
179
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator');
180
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording');
181
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient');
182
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor');
183
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer');
184
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher');
185
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer');
186
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository');
187
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter');
188
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible');
189
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee');
190
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager');
191
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent');
192
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant');
193
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research');
194
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research');
195
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific');
196
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist');
197
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor');
198
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe');
199
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound');
200
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary');
201
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer');
202
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting');
203
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer');
204
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker');
205
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor');
206
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second');
207
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor');
208
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set');
209
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller');
210
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage');
211
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards');
212
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper');
213
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical');
214
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher');
215
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis');
216
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber');
217
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator');
218
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type');
219
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer');
220
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University');
221
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer');
222
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist');
223
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer');
224
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter');
225
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver');
226
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness');
227
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/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/pl-PL/optional/marc21_relatorterms.sql (+227 lines)
Line 0 Link Here
1
-- MARC code list for Relators, taken from
2
-- http://www.loc.gov/marc/relators/relacode.html
3
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor');
6
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter');
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author');
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst');
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator');
10
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator');
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic');
12
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant');
13
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author');
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect');
15
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic');
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger');
17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist');
18
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee');
19
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated');
20
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed');
21
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer');
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author');
23
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author');
24
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author');
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding');
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket');
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book');
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book');
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb');
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder');
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate');
33
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller');
34
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor');
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer');
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator');
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client');
38
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher');
39
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist');
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper');
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator');
42
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer');
43
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor');
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer');
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor');
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor');
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant');
48
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector');
49
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler');
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator');
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant');
52
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant');
53
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover');
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright');
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee');
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright');
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant');
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant');
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator');
60
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent');
61
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector');
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer');
68
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor');
69
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee');
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted');
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor');
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data');
89
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee');
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data');
91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator');
92
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious');
93
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor');
94
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver');
95
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician');
96
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper');
97
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer');
98
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher');
99
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event');
100
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert');
101
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist');
102
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field');
103
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film');
104
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former');
105
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First');
106
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder');
107
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger');
108
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic');
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic');
110
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree');
111
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host');
112
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator');
113
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator');
114
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber');
115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor');
116
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist');
117
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee');
118
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer');
119
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory');
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist');
121
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory');
122
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead');
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee');
124
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee');
125
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender');
126
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant');
127
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting');
128
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee');
129
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant');
130
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant');
131
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape');
132
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee');
133
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor');
134
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer');
135
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist');
136
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music');
137
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture');
138
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer');
139
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata');
140
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator');
141
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor');
142
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler');
143
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup');
144
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical');
145
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver');
146
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician');
147
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator');
148
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent');
149
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator');
150
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer');
151
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other');
152
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner');
153
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron');
154
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing');
155
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher');
156
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project');
157
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader');
158
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer');
159
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker');
160
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting');
161
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production');
162
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer');
163
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker');
164
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer');
165
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process');
166
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production');
167
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer');
168
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer');
169
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker');
170
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer');
171
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production');
172
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer');
173
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent');
174
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff');
175
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff');
176
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent');
177
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant');
178
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication');
179
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator');
180
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording');
181
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient');
182
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor');
183
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer');
184
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher');
185
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer');
186
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository');
187
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter');
188
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible');
189
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee');
190
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager');
191
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent');
192
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant');
193
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research');
194
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research');
195
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific');
196
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist');
197
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor');
198
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe');
199
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound');
200
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary');
201
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer');
202
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting');
203
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer');
204
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker');
205
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor');
206
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second');
207
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor');
208
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set');
209
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller');
210
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage');
211
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards');
212
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper');
213
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical');
214
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher');
215
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis');
216
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber');
217
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator');
218
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type');
219
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer');
220
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University');
221
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer');
222
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist');
223
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer');
224
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter');
225
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver');
226
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness');
227
(-)a/installer/data/mysql/pl-PL/optional/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/ru-RU/optional/marc21_relatorterms.sql (+227 lines)
Line 0 Link Here
1
-- MARC code list for Relators, taken from
2
-- http://www.loc.gov/marc/relators/relacode.html
3
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor');
6
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter');
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author');
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst');
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator');
10
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator');
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic');
12
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant');
13
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author');
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect');
15
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic');
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger');
17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist');
18
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee');
19
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated');
20
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed');
21
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer');
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author');
23
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author');
24
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author');
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding');
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket');
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book');
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book');
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb');
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder');
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate');
33
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller');
34
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor');
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer');
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator');
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client');
38
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher');
39
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist');
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper');
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator');
42
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer');
43
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor');
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer');
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor');
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor');
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant');
48
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector');
49
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler');
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator');
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant');
52
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant');
53
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover');
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright');
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee');
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright');
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant');
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant');
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator');
60
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent');
61
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector');
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer');
68
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor');
69
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee');
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted');
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor');
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data');
89
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee');
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data');
91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator');
92
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious');
93
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor');
94
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver');
95
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician');
96
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper');
97
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer');
98
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher');
99
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event');
100
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert');
101
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist');
102
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field');
103
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film');
104
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former');
105
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First');
106
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder');
107
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger');
108
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic');
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic');
110
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree');
111
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host');
112
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator');
113
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator');
114
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber');
115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor');
116
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist');
117
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee');
118
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer');
119
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory');
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist');
121
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory');
122
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead');
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee');
124
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee');
125
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender');
126
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant');
127
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting');
128
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee');
129
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant');
130
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant');
131
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape');
132
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee');
133
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor');
134
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer');
135
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist');
136
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music');
137
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture');
138
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer');
139
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata');
140
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator');
141
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor');
142
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler');
143
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup');
144
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical');
145
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver');
146
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician');
147
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator');
148
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent');
149
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator');
150
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer');
151
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other');
152
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner');
153
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron');
154
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing');
155
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher');
156
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project');
157
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader');
158
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer');
159
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker');
160
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting');
161
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production');
162
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer');
163
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker');
164
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer');
165
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process');
166
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production');
167
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer');
168
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer');
169
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker');
170
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer');
171
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production');
172
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer');
173
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent');
174
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff');
175
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff');
176
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent');
177
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant');
178
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication');
179
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator');
180
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording');
181
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient');
182
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor');
183
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer');
184
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher');
185
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer');
186
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository');
187
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter');
188
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible');
189
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee');
190
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager');
191
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent');
192
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant');
193
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research');
194
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research');
195
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific');
196
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist');
197
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor');
198
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe');
199
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound');
200
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary');
201
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer');
202
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting');
203
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer');
204
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker');
205
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor');
206
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second');
207
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor');
208
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set');
209
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller');
210
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage');
211
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards');
212
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper');
213
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical');
214
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher');
215
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis');
216
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber');
217
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator');
218
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type');
219
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer');
220
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University');
221
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer');
222
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist');
223
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer');
224
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter');
225
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver');
226
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness');
227
(-)a/installer/data/mysql/ru-RU/optional/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/uk-UA/optional/marc21_relatorterms.sql (+227 lines)
Line 0 Link Here
1
-- MARC code list for Relators, taken from
2
-- http://www.loc.gov/marc/relators/relacode.html
3
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','acp','Art');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','act','Actor');
6
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','adp','Adapter');
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aft','Author');
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anl','Analyst');
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','anm','Animator');
10
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ann','Annotator');
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ant','Bibliographic');
12
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','app','Applicant');
13
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aqt','Author');
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arc','Architect');
15
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ard','Artistic');
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','arr','Arranger');
17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','art','Artist');
18
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asg','Assignee');
19
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','asn','Associated');
20
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','att','Attributed');
21
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','auc','Auctioneer');
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aud','Author');
23
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aui','Author');
24
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aus','Author');
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','aut','Author');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bdd','Binding');
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bjd','Bookjacket');
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkd','Book');
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bkp','Book');
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','blw','Blurb');
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bnd','Binder');
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bpd','Bookplate');
33
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','bsl','Bookseller');
34
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ccp','Conceptor');
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','chr','Choreographer');
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clb','Collaborator');
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cli','Client');
38
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cll','Calligrapher');
39
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clr','Colorist');
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','clt','Collotyper');
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmm','Commentator');
42
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmp','Composer');
43
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cmt','Compositor');
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cng','Cinematographer');
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cnd','Conductor');
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cns','Censor');
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','coe','Contestant');
48
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','col','Collector');
49
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','com','Compiler');
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','con','Conservator');
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cos','Contestant');
52
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cot','Contestant');
53
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cov','Cover');
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpc','Copyright');
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpe','Complainant-appellee');
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cph','Copyright');
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpl','Complainant');
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cpt','Complainant-appellant');
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cre','Creator');
60
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crp','Correspondent');
61
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','crr','Corrector');
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csl','Consultant');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','csp','Consultant');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cst','Costume');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctb','Contributor');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cte','Contestee-appellee');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctg','Cartographer');
68
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctr','Contractor');
69
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cts','Contestee');
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ctt','Contestee-appellant');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cur','Curator');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','cwt','Commentator');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfd','Defendant');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dfe','Defendant-appellee');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dft','Defendant-appellant');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dgg','Degree');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dis','Dissertant');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dln','Delineator');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnc','Dancer');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dnr','Donor');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpb','Distribution');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpc','Depicted');
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dpt','Depositor');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drm','Draftsman');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','drt','Director');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dsr','Designer');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dst','Distributor');
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtc','Data');
89
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dte','Dedicatee');
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dtm','Data');
91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dto','Dedicator');
92
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','dub','Dubious');
93
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','edt','Editor');
94
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','egr','Engraver');
95
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elg','Electrician');
96
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','elt','Electrotyper');
97
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','eng','Engineer');
98
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','etr','Etcher');
99
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','evp','Event');
100
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','exp','Expert');
101
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fac','Facsimilist');
102
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fld','Field');
103
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','flm','Film');
104
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fmo','Former');
105
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fpy','First');
106
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','fnd','Funder');
107
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','frg','Forger');
108
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','gis','Geographic');
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','-grt','Graphic');
110
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hnr','Honoree');
111
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','hst','Host');
112
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ill','Illustrator');
113
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ilu','Illuminator');
114
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ins','Inscriber');
115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','inv','Inventor');
116
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','itr','Instrumentalist');
117
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ive','Interviewee');
118
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ivr','Interviewer');
119
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbr','Laboratory');
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lbt','Librettist');
121
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ldr','Laboratory');
122
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','led','Lead');
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lee','Libelee-appellee');
124
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lel','Libelee');
125
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','len','Lender');
126
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','let','Libelee-appellant');
127
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lgd','Lighting');
128
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lie','Libelant-appellee');
129
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lil','Libelant');
130
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lit','Libelant-appellant');
131
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lsa','Landscape');
132
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lse','Licensee');
133
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lso','Licensor');
134
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ltg','Lithographer');
135
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','lyr','Lyricist');
136
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mcp','Music');
137
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfp','Manufacture');
138
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mfr','Manufacturer');
139
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mdc','Metadata');
140
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mod','Moderator');
141
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mon','Monitor');
142
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrb','Marbler');
143
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mrk','Markup');
144
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','msd','Musical');
145
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mte','Metal-engraver');
146
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','mus','Musician');
147
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','nrt','Narrator');
148
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','opn','Opponent');
149
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','org','Originator');
150
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','orm','Organizer');
151
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','oth','Other');
152
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','own','Owner');
153
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pat','Patron');
154
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbd','Publishing');
155
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pbl','Publisher');
156
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pdr','Project');
157
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pfr','Proofreader');
158
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pht','Photographer');
159
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','plt','Platemaker');
160
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pma','Permitting');
161
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pmn','Production');
162
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pop','Printer');
163
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppm','Papermaker');
164
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ppt','Puppeteer');
165
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prc','Process');
166
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prd','Production');
167
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prf','Performer');
168
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prg','Programmer');
169
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prm','Printmaker');
170
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pro','Producer');
171
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prp','Production');
172
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','prt','Printer');
173
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pta','Patent');
174
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pte','Plaintiff');
175
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptf','Plaintiff');
176
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pth','Patent');
177
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ptt','Plaintiff-appellant');
178
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','pup','Publication');
179
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rbr','Rubricator');
180
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rce','Recording');
181
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rcp','Recipient');
182
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','red','Redactor');
183
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ren','Renderer');
184
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','res','Researcher');
185
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rev','Reviewer');
186
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rps','Repository');
187
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpt','Reporter');
188
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rpy','Responsible');
189
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rse','Respondent-appellee');
190
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsg','Restager');
191
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rsp','Respondent');
192
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rst','Respondent-appellant');
193
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rth','Research');
194
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','rtm','Research');
195
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sad','Scientific');
196
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sce','Scenarist');
197
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scl','Sculptor');
198
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','scr','Scribe');
199
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sds','Sound');
200
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sec','Secretary');
201
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sgn','Signer');
202
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sht','Supporting');
203
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','sng','Singer');
204
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spk','Speaker');
205
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spn','Sponsor');
206
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','spy','Second');
207
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','srv','Surveyor');
208
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','std','Set');
209
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stl','Storyteller');
210
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stm','Stage');
211
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','stn','Standards');
212
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','str','Stereotyper');
213
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tcd','Technical');
214
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tch','Teacher');
215
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','ths','Thesis');
216
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trc','Transcriber');
217
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','trl','Translator');
218
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyd','Type');
219
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','tyg','Typographer');
220
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','uvp','University');
221
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','vdg','Videographer');
222
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','voc','Vocalist');
223
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wam','Writer');
224
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wdc','Woodcutter');
225
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wde','Wood-engraver');
226
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('MARCRELATOR','wit','Witness');
227
(-)a/installer/data/mysql/uk-UA/optional/marc21_relatorterms.txt (-1 / +1 lines)
Line 0 Link Here
0
- 
1
MARC Code List for Relators, as of http://www.loc.gov/marc/relators/relaterm.html

Return to bug 6299