-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcountries.sql
265 lines (258 loc) · 26.2 KB
/
countries.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
create column table countries
(ID int not null primary key generated by default as IDENTITY,
CODE NVARCHAR(10),
NAME_EN nvarchar(50),
NAME_DE nvarchar(50)
);
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AD', 'Andorra', 'Andorra');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AE', 'United Arab Emirates', 'Vereinigte Arabische Emirate');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AF', 'Afghanistan', 'Afghanistan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AG', 'Antigua and Barbuda', 'Antigua und Barbuda');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AI', 'Anguilla', 'Anguilla');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AL', 'Albania', 'Albanien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AM', 'Armenia', 'Armenien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AN', 'Netherlands Antilles', 'Niederländische Antillen');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AO', 'Angola', 'Angola');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AQ', 'Antarctica', 'Antarktis');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AR', 'Argentina', 'Argentinien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AS', 'American Samoa', 'Amerikanisch-Samoa');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AT', 'Austria', 'Österreich');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AU', 'Australia', 'Australien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AW', 'Aruba', 'Aruba');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AX', 'Aland Islands', 'Åland');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('AZ', 'Azerbaijan', 'Aserbaidschan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BA', 'Bosnia and Herzegovina', 'Bosnien und Herzegowina');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BB', 'Barbados', 'Barbados');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BD', 'Bangladesh', 'Bangladesch');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BE', 'Belgium', 'Belgien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BF', 'Burkina Faso', 'Burkina Faso');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BG', 'Bulgaria', 'Bulgarien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BH', 'Bahrain', 'Bahrain');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BI', 'Burundi', 'Burundi');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BJ', 'Benin', 'Benin');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BL', 'Saint Barthelemy !Saint Barthélemy', 'Saint-Barthélemy');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BM', 'Bermuda', 'Bermuda');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BN', 'Brunei', 'Brunei Darussalam');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BO', 'Bolivia', 'Bolivien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BQ', 'Bonaire, Sint Eustatius and Saba', 'Bonaire, Sint Eustatius und Saba');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BR', 'Brazil', 'Brasilien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BS', 'Bahamas', 'Bahamas');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BT', 'Bhutan', 'Bhutan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BV', 'Bouvet Island', 'Bouvetinsel');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BW', 'Botswana', 'Botswana');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BY', 'Belarus', 'Belarus (Weißrussland)');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('BZ', 'Belize', 'Belize');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CA', 'Canada', 'Kanada');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CC', 'Cocos (Keeling) Islands', 'Kokosinseln (Keelinginseln)');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CD', 'Congo (Kinshasa)', 'Kongo');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CF', 'Central African Republic', 'Zentralafrikanische Republik');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CG', 'Congo (Brazzaville)', 'Republik Kongo');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CH', 'Switzerland', 'Schweiz');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CI', 'Ivory Coast', 'Elfenbeinküste');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CK', 'Cook Islands', 'Cookinseln');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CL', 'Chile', 'Chile');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CM', 'Cameroon', 'Kamerun');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CN', 'China', 'China, Volksrepublik');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CO', 'Colombia', 'Kolumbien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CR', 'Costa Rica', 'Costa Rica');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CU', 'Cuba', 'Kuba');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CV', 'Cape Verde', 'Kap Verde');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CW', 'Curacao !Curaçao', 'Curaçao');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CX', 'Christmas Island', 'Weihnachtsinsel');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CY', 'Cyprus', 'Zypern');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('CZ', 'Czech Republic', 'Tschechische Republik');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('DE', 'Germany', 'Deutschland');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('DJ', 'Djibouti', 'Dschibuti');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('DK', 'Denmark', 'Dänemark');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('DM', 'Dominica', 'Dominica');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('DO', 'Dominican Republic', 'Dominikanische Republik');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('DZ', 'Algeria', 'Algerien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('EC', 'Ecuador', 'Ecuador');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('EE', 'Estonia', 'Estland (Reval)');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('EG', 'Egypt', 'Ägypten');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('EH', 'Western Sahara', 'Westsahara');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('ER', 'Eritrea', 'Eritrea');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('ES', 'Spain', 'Spanien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('ET', 'Ethiopia', 'Äthiopien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('FI', 'Finland', 'Finnland');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('FJ', 'Fiji', 'Fidschi');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('FK', 'Falkland Islands', 'Falklandinseln (Malwinen)');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('FM', 'Micronesia', 'Mikronesien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('FO', 'Faroe Islands', 'Färöer');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('FR', 'France', 'Frankreich');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GA', 'Gabon', 'Gabun');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GB', 'United Kingdom', 'Großbritannien und Nordirland');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GD', 'Grenada', 'Grenada');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GE', 'Georgia', 'Georgien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GF', 'French Guiana', 'Französisch-Guayana');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GG', 'Guernsey', 'Guernsey (Kanalinsel)');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GH', 'Ghana', 'Ghana');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GI', 'Gibraltar', 'Gibraltar');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GL', 'Greenland', 'Grönland');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GM', 'Gambia', 'Gambia');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GN', 'Guinea', 'Guinea');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GP', 'Guadeloupe', 'Guadeloupe');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GQ', 'Equatorial Guinea', 'Äquatorialguinea');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GR', 'Greece', 'Griechenland');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GS', 'South Georgia and the South Sandwich Islands', 'Südgeorgien und die Südl. Sandwichinseln');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GT', 'Guatemala', 'Guatemala');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GU', 'Guam', 'Guam');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GW', 'Guinea-Bissau', 'Guinea-Bissau');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('GY', 'Guyana', 'Guyana');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('HK', 'Hong Kong S.A.R., China', 'Hongkong');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('HM', 'Heard Island and McDonald Islands', 'Heard- und McDonald-Inseln');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('HN', 'Honduras', 'Honduras');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('HR', 'Croatia', 'Kroatien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('HT', 'Haiti', 'Haiti');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('HU', 'Hungary', 'Ungarn');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('ID', 'Indonesia', 'Indonesien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('IE', 'Ireland', 'Irland');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('IL', 'Israel', 'Israel');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('IM', 'Isle of Man', 'Insel Man');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('IN', 'India', 'Indien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('IO', 'British Indian Ocean Territory', 'Britisches Territorium im Indischen Ozean');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('IQ', 'Iraq', 'Irak');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('IR', 'Iran', 'Iran');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('IS', 'Iceland', 'Island');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('IT', 'Italy', 'Italien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('JE', 'Jersey', 'Jersey (Kanalinsel)');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('JM', 'Jamaica', 'Jamaika');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('JO', 'Jordan', 'Jordanien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('JP', 'Japan', 'Japan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('KE', 'Kenya', 'Kenia');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('KG', 'Kyrgyzstan', 'Kirgisistan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('KH', 'Cambodia', 'Kambodscha');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('KI', 'Kiribati', 'Kiribati');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('KM', 'Comoros', 'Komoren');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('KN', 'Saint Kitts and Nevis', 'St. Kitts und Nevis');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('KP', 'North Korea', 'Nordkorea');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('KR', 'South Korea', 'Südkorea');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('KW', 'Kuwait', 'Kuwait');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('KY', 'Cayman Islands', 'Kaimaninseln');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('KZ', 'Kazakhstan', 'Kasachstan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('LA', 'Laos', 'Laos');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('LB', 'Lebanon', 'Libanon');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('LC', 'Saint Lucia', 'St. Lucia');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('LI', 'Liechtenstein', 'Liechtenstein');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('LK', 'Sri Lanka', 'Sri Lanka');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('LR', 'Liberia', 'Liberia');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('LS', 'Lesotho', 'Lesotho');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('LT', 'Lithuania', 'Litauen');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('LU', 'Luxembourg', 'Luxemburg');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('LV', 'Latvia', 'Lettland');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('LY', 'Libya', 'Libyen');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MA', 'Morocco', 'Marokko');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MC', 'Monaco', 'Monaco');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MD', 'Moldova', 'Moldawien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('ME', 'Montenegro', 'Montenegro');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MF', 'Saint Martin (French part)', 'Saint-Martin (franz. Teil)');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MG', 'Madagascar', 'Madagaskar');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MH', 'Marshall Islands', 'Marshallinseln');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MK', 'Macedonia', 'Mazedonien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('ML', 'Mali', 'Mali');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MM', 'Myanmar', 'Myanmar (Burma)');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MN', 'Mongolia', 'Mongolei');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MO', 'Macao S.A.R., China', 'Macau');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MP', 'Northern Mariana Islands', 'Nördliche Marianen');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MQ', 'Martinique', 'Martinique');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MR', 'Mauritania', 'Mauretanien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MS', 'Montserrat', 'Montserrat');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MT', 'Malta', 'Malta');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MU', 'Mauritius', 'Mauritius');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MV', 'Maldives', 'Malediven');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MW', 'Malawi', 'Malawi');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MX', 'Mexico', 'Mexiko');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MY', 'Malaysia', 'Malaysia');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('MZ', 'Mozambique', 'Mosambik');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('NA', 'Namibia', 'Namibia');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('NC', 'New Caledonia', 'Neukaledonien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('NE', 'Niger', 'Niger');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('NF', 'Norfolk Island', 'Norfolkinsel');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('NG', 'Nigeria', 'Nigeria');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('NI', 'Nicaragua', 'Nicaragua');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('NL', 'Netherlands', 'Niederlande');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('NO', 'Norway', 'Norwegen');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('NP', 'Nepal', 'Nepal');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('NR', 'Nauru', 'Nauru');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('NU', 'Niue', 'Niue');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('NZ', 'New Zealand', 'Neuseeland');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('OM', 'Oman', 'Oman');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PA', 'Panama', 'Panama');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PE', 'Peru', 'Peru');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PF', 'French Polynesia', 'Französisch-Polynesien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PG', 'Papua New Guinea', 'Papua-Neuguinea');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PH', 'Philippines', 'Philippinen');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PK', 'Pakistan', 'Pakistan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PL', 'Poland', 'Polen');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PM', 'Saint Pierre and Miquelon', 'St. Pierre und Miquelon');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PN', 'Pitcairn', 'Pitcairninseln');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PR', 'Puerto Rico', 'Puerto Rico');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PS', 'Palestine', 'Palästina');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PT', 'Portugal', 'Portugal');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PW', 'Palau', 'Palau');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('PY', 'Paraguay', 'Paraguay');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('QA', 'Qatar', 'Katar');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('RE', 'Reunion', 'Réunion');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('RO', 'Romania', 'Rumänien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('RS', 'Serbia', 'Serbien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('RU', 'Russia', 'Russische Föderation');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('RW', 'Rwanda', 'Ruanda');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SA', 'Saudi Arabia', 'Saudi-Arabien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SB', 'Solomon Islands', 'Salomonen');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SC', 'Seychelles', 'Seychellen');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SD', 'Sudan', 'Sudan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SE', 'Sweden', 'Schweden');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SG', 'Singapore', 'Singapur');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SH', 'Saint Helena', 'St. Helena');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SI', 'Slovenia', 'Slowenien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SJ', 'Svalbard and Jan Mayen', 'Svalbard und Jan Mayen');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SK', 'Slovakia', 'Slowakei');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SL', 'Sierra Leone', 'Sierra Leone');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SM', 'San Marino', 'San Marino');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SN', 'Senegal', 'Senegal');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SO', 'Somalia', 'Somalia');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SR', 'Suriname', 'Suriname');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SS', 'South Sudan', 'Sudsudan!Südsudan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('ST', 'Sao Tome and Principe', 'São Tomé und Príncipe');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SV', 'El Salvador', 'El Salvador');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SX', 'Sint Maarten (Dutch part)', 'Sint Maarten (niederl. Teil)');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SY', 'Syria', 'Syrien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('SZ', 'Swaziland', 'Swasiland');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TC', 'Turks and Caicos Islands', 'Turks- und Caicosinseln');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TD', 'Chad', 'Tschad');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TF', 'French Southern Territories', 'Französische Süd- und Antarktisgebiete');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TG', 'Togo', 'Togo');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TH', 'Thailand', 'Thailand');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TJ', 'Tajikistan', 'Tadschikistan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TK', 'Tokelau', 'Tokelau');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TL', 'East Timor', 'Timor-Leste');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TM', 'Turkmenistan', 'Turkmenistan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TN', 'Tunisia', 'Tunesien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TO', 'Tonga', 'Tonga');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TR', 'Turkey', 'Türkei');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TT', 'Trinidad and Tobago', 'Trinidad und Tobago');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TV', 'Tuvalu', 'Tuvalu');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TW', 'Taiwan', 'Taiwan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('TZ', 'Tanzania', 'Tansania');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('UA', 'Ukraine', 'Ukraine');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('UG', 'Uganda', 'Uganda');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('UM', 'United States Minor Outlying Islands', 'Amerikanisch-Ozeanien');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('US', 'United States', 'Vereinigte Staaten von Amerika');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('UY', 'Uruguay', 'Uruguay');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('UZ', 'Uzbekistan', 'Usbekistan');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('VA', 'Vatican', 'Vatikanstadt');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('VC', 'Saint Vincent and the Grenadines', 'St. Vincent und die Grenadinen');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('VE', 'Venezuela', 'Venezuela');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('VG', 'British Virgin Islands', 'Britische Jungferninseln');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('VI', 'U.S. Virgin Islands', 'Amerikanische Jungferninseln');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('VN', 'Vietnam', 'Vietnam');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('VU', 'Vanuatu', 'Vanuatu');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('WF', 'Wallis and Futuna', 'Wallis und Futuna');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('WS', 'Samoa', 'Samoa');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('XK', 'Kosovo', 'Kosovo');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('YE', 'Yemen', 'Jemen');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('YT', 'Mayotte', 'Mayotte');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('ZA', 'South Africa', 'Südafrika');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('ZM', 'Zambia', 'Sambia');
insert into "TEST"."COUNTRIES"("CODE","NAME_EN","NAME_DE") values ('ZW', 'Zimbabwe', 'Simbabwe');