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

(-)a/installer/data/mysql/mandatory/subtag_registry.sql (-344 / +1161 lines)
Lines 2-16 Link Here
2
2
3
-- BIDI Stuff, Arabic and Hebrew
3
-- BIDI Stuff, Arabic and Hebrew
4
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
4
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
5
VALUES( 'Arab', 'rtl');
5
VALUES ( 'Arab', 'rtl');
6
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
6
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
7
VALUES( 'Hebr', 'rtl');
7
VALUES ( 'Hebr', 'rtl');
8
8
9
-- Default mappings between script and language subcodes
9
-- Default mappings between script and language subcodes
10
INSERT INTO language_script_mapping(language_subtag,script_subtag)
10
INSERT INTO language_script_mapping(language_subtag,script_subtag)
11
VALUES( 'ar', 'Arab');
11
VALUES ( 'ar', 'Arab');
12
INSERT INTO language_script_mapping(language_subtag,script_subtag)
12
INSERT INTO language_script_mapping(language_subtag,script_subtag)
13
VALUES( 'he', 'Hebr');
13
VALUES ( 'he', 'Hebr');
14
14
15
-- EXTENSIONS
15
-- EXTENSIONS
16
-- Interface (i)
16
-- Interface (i)
Lines 20-954 INSERT INTO language_subtag_registry( subtag, type, description, added) Link Here
20
VALUES ( 'opac', 'i', 'OPAC','2005-10-16');
20
VALUES ( 'opac', 'i', 'OPAC','2005-10-16');
21
21
22
INSERT INTO language_descriptions(subtag, type, lang, description)
22
INSERT INTO language_descriptions(subtag, type, lang, description)
23
VALUES( 'opac', 'i', 'en', 'OPAC');
23
VALUES ( 'opac', 'i', 'en', 'OPAC');
24
24
25
INSERT INTO language_descriptions(subtag, type, lang, description)
25
INSERT INTO language_descriptions(subtag, type, lang, description)
26
VALUES( 'opac', 'i', 'fr', 'OPAC');
26
VALUES ( 'opac', 'i', 'fr', 'OPAC');
27
27
28
INSERT INTO language_descriptions(subtag, type, lang, description)
28
INSERT INTO language_descriptions(subtag, type, lang, description)
29
VALUES( 'opac', 'i', 'de', 'OPAC');
29
VALUES ( 'opac', 'i', 'de', 'OPAC');
30
30
31
-- Staff Client
31
-- Staff Client
32
INSERT INTO language_subtag_registry( subtag, type, description, added)
32
INSERT INTO language_subtag_registry( subtag, type, description, added)
33
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
33
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
34
34
35
INSERT INTO language_descriptions(subtag, type, lang, description)
35
INSERT INTO language_descriptions(subtag, type, lang, description)
36
VALUES( 'intranet', 'i', 'en', 'Staff Client');
36
VALUES ( 'intranet', 'i', 'en', 'Staff Client');
37
37
38
INSERT INTO language_descriptions(subtag, type, lang, description)
38
INSERT INTO language_descriptions(subtag, type, lang, description)
39
VALUES( 'intranet', 'i', 'fr', '????');
39
VALUES ( 'intranet', 'i', 'fr', 'Client personnel');
40
40
41
INSERT INTO language_descriptions(subtag, type, lang, description)
41
INSERT INTO language_descriptions(subtag, type, lang, description)
42
VALUES( 'intranet', 'i', 'de', 'Dienstoberfläche');
42
VALUES ( 'intranet', 'i', 'de', 'Dienstoberfläche');
43
43
44
-- Theme (t)
44
-- Theme (t)
45
INSERT INTO language_subtag_registry( subtag, type, description, added)
45
INSERT INTO language_subtag_registry( subtag, type, description, added)
46
VALUES ( 'prog', 't', 'Prog','2005-10-16');
46
VALUES ( 'prog', 't', 'Prog','2005-10-16');
47
47
48
INSERT INTO language_descriptions(subtag, type, lang, description)
48
INSERT INTO language_descriptions(subtag, type, lang, description)
49
VALUES( 'prog', 't', 'en', 'Prog');
49
VALUES ( 'prog', 't', 'en', 'Prog');
50
50
51
INSERT INTO language_descriptions(subtag, type, lang, description)
51
INSERT INTO language_descriptions(subtag, type, lang, description)
52
VALUES( 'prog', 't', 'fr', 'Prog');
52
VALUES ( 'prog', 't', 'fr', 'Prog');
53
53
54
INSERT INTO language_descriptions(subtag, type, lang, description)
54
INSERT INTO language_descriptions(subtag, type, lang, description)
55
VALUES( 'prog', 't', 'de', 'Prog');
55
VALUES ( 'prog', 't', 'de', 'Prog');
56
56
57
-- LANGUAGES
57
-- LANGUAGES
58
58
59
-- Amharic
60
INSERT INTO language_subtag_registry( subtag, type, description, added)
61
VALUES ( 'am', 'language', 'Amharic','2014-10-29');
62
63
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
64
VALUES ( 'am','amh');
65
66
INSERT INTO language_descriptions(subtag, type, lang, description)
67
VALUES ( 'am', 'language', 'am', 'አማርኛ');
68
69
INSERT INTO language_descriptions(subtag, type, lang, description)
70
VALUES ( 'am', 'language', 'en', 'Amharic');
71
59
-- Arabic
72
-- Arabic
60
INSERT INTO language_subtag_registry( subtag, type, description, added)
73
INSERT INTO language_subtag_registry( subtag, type, description, added)
61
VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
74
VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
62
75
63
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
76
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
64
VALUES( 'ar','ara');
77
VALUES ( 'ar','ara');
65
78
66
INSERT INTO language_descriptions(subtag, type, lang, description)
79
INSERT INTO language_descriptions(subtag, type, lang, description)
67
VALUES ( 'ar', 'language', 'ar', 'العربية');
80
VALUES ( 'ar', 'language', 'ar', 'لعربية');
68
81
69
INSERT INTO language_descriptions(subtag, type, lang, description)
82
INSERT INTO language_descriptions(subtag, type, lang, description)
70
VALUES( 'ar', 'language', 'en', 'Arabic');
83
VALUES ( 'ar', 'language', 'en', 'Arabic');
71
84
72
INSERT INTO language_descriptions(subtag, type, lang, description)
85
INSERT INTO language_descriptions(subtag, type, lang, description)
73
VALUES( 'ar', 'language', 'fr', 'Arabe');
86
VALUES ( 'ar', 'language', 'fr', 'Arabe');
74
87
75
INSERT INTO language_descriptions(subtag, type, lang, description)
88
INSERT INTO language_descriptions(subtag, type, lang, description)
76
VALUES( 'ar', 'language', 'de', 'Arabisch');
89
VALUES ( 'ar', 'language', 'de', 'Arabisch');
77
90
78
-- Armenian
91
-- Azerbaijani
79
INSERT INTO language_subtag_registry( subtag, type, description, added)
92
INSERT INTO language_subtag_registry( subtag, type, description, added)
80
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
93
VALUES ( 'az', 'language', 'Azerbaijani','2014-10-30');
81
94
82
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
95
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
83
VALUES( 'hy','arm');
96
VALUES ( 'az','aze');
84
97
85
INSERT INTO language_descriptions(subtag, type, lang, description)
98
INSERT INTO language_descriptions(subtag, type, lang, description)
86
VALUES ( 'hy', 'language', 'hy', 'Հայերեն');
99
VALUES ( 'az', 'language', 'az', 'Azərbaycan dili');
100
101
INSERT INTO language_descriptions(subtag, type, lang, description)
102
VALUES ( 'az', 'language', 'en', 'Azerbaijani');
103
104
-- Byelorussian
105
INSERT INTO language_subtag_registry( subtag, type, description, added)
106
VALUES ( 'be', 'language', 'Byelorussian','2014-10-30');
107
108
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
109
VALUES ( 'be','bel');
110
111
INSERT INTO language_descriptions(subtag, type, lang, description)
112
VALUES ( 'be', 'language', 'be', 'Беларуская мова');
87
113
88
INSERT INTO language_descriptions(subtag, type, lang, description)
114
INSERT INTO language_descriptions(subtag, type, lang, description)
89
VALUES( 'hy', 'language', 'en', 'Armenian');
115
VALUES ( 'be', 'language', 'en', 'Byelorussian');
116
117
-- Bengali
118
INSERT INTO language_subtag_registry( subtag, type, description, added)
119
VALUES ( 'bn', 'language', 'Bengali','2014-10-30');
120
121
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
122
VALUES ( 'bn','ben');
90
123
91
INSERT INTO language_descriptions(subtag, type, lang, description)
124
INSERT INTO language_descriptions(subtag, type, lang, description)
92
VALUES( 'hy', 'language', 'fr', 'Armenian');
125
VALUES ( 'bn', 'language', 'bn', 'বাংলা');
93
126
94
INSERT INTO language_descriptions(subtag, type, lang, description)
127
INSERT INTO language_descriptions(subtag, type, lang, description)
95
VALUES( 'hy', 'language', 'de', 'Armenisch');
128
VALUES ( 'bn', 'language', 'en', 'Bengali');
96
129
97
-- Bulgarian
130
-- Bulgarian
98
INSERT INTO language_subtag_registry( subtag, type, description, added)
131
INSERT INTO language_subtag_registry( subtag, type, description, added)
99
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
132
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
100
133
101
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
134
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
102
VALUES( 'bg','bul');
135
VALUES ( 'bg','bul');
103
136
104
INSERT INTO language_descriptions(subtag, type, lang, description)
137
INSERT INTO language_descriptions(subtag, type, lang, description)
105
VALUES ( 'bg', 'language', 'bg', 'Български');
138
VALUES ( 'bg', 'language', 'bg', 'Български');
106
139
107
INSERT INTO language_descriptions(subtag, type, lang, description)
140
INSERT INTO language_descriptions(subtag, type, lang, description)
108
VALUES( 'bg', 'language', 'en', 'Bulgarian');
141
VALUES ( 'bg', 'language', 'en', 'Bulgarian');
109
142
110
INSERT INTO language_descriptions(subtag, type, lang, description)
143
INSERT INTO language_descriptions(subtag, type, lang, description)
111
VALUES( 'bg', 'language', 'fr', 'Bulgare');
144
VALUES ( 'bg', 'language', 'fr', 'Bulgare');
112
145
113
INSERT INTO language_descriptions(subtag, type, lang, description)
146
INSERT INTO language_descriptions(subtag, type, lang, description)
114
VALUES( 'bg', 'language', 'de', 'Bulgarisch');
147
VALUES ( 'bg', 'language', 'de', 'Bulgarisch');
115
148
116
-- Chinese
149
-- Catalan
117
INSERT INTO language_subtag_registry( subtag, type, description, added)
150
INSERT INTO language_subtag_registry( subtag, type, description, added)
118
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
151
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
119
152
120
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
153
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
121
VALUES( 'zh','chi');
154
VALUES ( 'ca','cat');
155
156
INSERT INTO language_descriptions(subtag, type, lang, description)
157
VALUES ( 'ca', 'language', 'es', 'Catalán');
122
158
123
INSERT INTO language_descriptions(subtag, type, lang, description)
159
INSERT INTO language_descriptions(subtag, type, lang, description)
124
VALUES ( 'zh', 'language', 'zh', '中文');
160
VALUES ( 'ca', 'language', 'en', 'Catalan');
125
161
126
INSERT INTO language_descriptions(subtag, type, lang, description)
162
INSERT INTO language_descriptions(subtag, type, lang, description)
127
VALUES( 'zh', 'language', 'en', 'Chinese');
163
VALUES ( 'ca', 'language', 'fr', 'Catalan');
128
164
129
INSERT INTO language_descriptions(subtag, type, lang, description)
165
INSERT INTO language_descriptions(subtag, type, lang, description)
130
VALUES( 'zh', 'language', 'fr', 'Chinois');
166
VALUES ( 'ca', 'language', 'ca', 'Català');
131
167
132
INSERT INTO language_descriptions(subtag, type, lang, description)
168
INSERT INTO language_descriptions(subtag, type, lang, description)
133
VALUES( 'zh', 'language', 'de', 'Chinesisch');
169
VALUES ( 'ca', 'language', 'de', 'Katalanisch');
134
170
135
-- Czech
171
-- Czech
136
INSERT INTO language_subtag_registry( subtag, type, description, added)
172
INSERT INTO language_subtag_registry( subtag, type, description, added)
137
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
173
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
138
174
139
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
175
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
140
VALUES( 'cs','cze');
176
VALUES ( 'cs','cze');
141
177
142
INSERT INTO language_descriptions(subtag, type, lang, description)
178
INSERT INTO language_descriptions(subtag, type, lang, description)
143
VALUES ( 'cs', 'language', 'cs', 'čeština');
179
VALUES ( 'cs', 'language', 'cs', 'Ceština');
144
180
145
INSERT INTO language_descriptions(subtag, type, lang, description)
181
INSERT INTO language_descriptions(subtag, type, lang, description)
146
VALUES( 'cs', 'language', 'en', 'Czech');
182
VALUES ( 'cs', 'language', 'en', 'Czech');
147
183
148
INSERT INTO language_descriptions(subtag, type, lang, description)
184
INSERT INTO language_descriptions(subtag, type, lang, description)
149
VALUES( 'cs', 'language', 'fr', 'Tchèque');
185
VALUES ( 'cs', 'language', 'fr', 'Tchèque');
150
186
151
INSERT INTO language_descriptions(subtag, type, lang, description)
187
INSERT INTO language_descriptions(subtag, type, lang, description)
152
VALUES( 'cs', 'language', 'de', 'Tschechisch');
188
VALUES ( 'cs', 'language', 'de', 'Tschechisch');
153
189
154
-- Danish
190
-- Danish
155
INSERT INTO language_subtag_registry( subtag, type, description, added)
191
INSERT INTO language_subtag_registry( subtag, type, description, added)
156
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
192
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
157
193
158
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
194
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
159
VALUES( 'da','dan');
195
VALUES ( 'da','dan');
160
196
161
INSERT INTO language_descriptions(subtag, type, lang, description)
197
INSERT INTO language_descriptions(subtag, type, lang, description)
162
VALUES ( 'da', 'language', 'da', 'Dansk');
198
VALUES ( 'da', 'language', 'da', 'Dansk');
163
199
164
INSERT INTO language_descriptions(subtag, type, lang, description)
200
INSERT INTO language_descriptions(subtag, type, lang, description)
165
VALUES( 'da', 'language', 'en', 'Danish');
201
VALUES ( 'da', 'language', 'en', 'Danish');
166
202
167
INSERT INTO language_descriptions(subtag, type, lang, description)
203
INSERT INTO language_descriptions(subtag, type, lang, description)
168
VALUES( 'da', 'language', 'fr', 'Danois');
204
VALUES ( 'da', 'language', 'fr', 'Danois');
169
205
170
INSERT INTO language_descriptions(subtag, type, lang, description)
206
INSERT INTO language_descriptions(subtag, type, lang, description)
171
VALUES( 'da', 'language', 'de', 'Dänisch');
207
VALUES ( 'da', 'language', 'de', 'Dänisch');
172
208
173
-- Dutch, Flemish
209
-- German
174
INSERT INTO language_subtag_registry( subtag, type, description, added)
210
INSERT INTO language_subtag_registry( subtag, type, description, added)
175
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
211
VALUES ( 'de', 'language', 'German','2005-10-16' );
176
212
177
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
213
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
178
VALUES( 'nl','dut');
214
VALUES ( 'de','ger');
179
215
180
INSERT INTO language_descriptions(subtag, type, lang, description)
216
INSERT INTO language_descriptions(subtag, type, lang, description)
181
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
217
VALUES ( 'de', 'language', 'de', 'Deutsch');
182
218
183
INSERT INTO language_descriptions(subtag, type, lang, description)
219
INSERT INTO language_descriptions(subtag, type, lang, description)
184
VALUES( 'nl', 'language', 'en', 'Dutch');
220
VALUES ( 'de', 'language', 'en', 'German');
185
221
186
INSERT INTO language_descriptions(subtag, type, lang, description)
222
INSERT INTO language_descriptions(subtag, type, lang, description)
187
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
223
VALUES ( 'de', 'language', 'fr', 'Allemand');
224
225
-- Greek
226
INSERT INTO language_subtag_registry( subtag, type, description, added)
227
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
228
229
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
230
VALUES ( 'el','gre');
231
232
INSERT INTO language_descriptions(subtag, type, lang, description)
233
VALUES ( 'el', 'language', 'el', 'Eλληνικά');
188
234
189
INSERT INTO language_descriptions(subtag, type, lang, description)
235
INSERT INTO language_descriptions(subtag, type, lang, description)
190
VALUES( 'nl', 'language', 'de', 'Niederländisch');
236
VALUES ( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
237
238
INSERT INTO language_descriptions(subtag, type, lang, description)
239
VALUES ( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
240
241
INSERT INTO language_descriptions(subtag, type, lang, description)
242
VALUES ( 'el', 'language', 'de', 'Griechisch (Moern [1453- ]');
191
243
192
-- English
244
-- English
193
INSERT INTO language_subtag_registry( subtag, type, description, added)
245
INSERT INTO language_subtag_registry( subtag, type, description, added)
194
VALUES ( 'en', 'language', 'English','2005-10-16' );
246
VALUES ( 'en', 'language', 'English','2005-10-16' );
195
247
196
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
248
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
197
VALUES( 'en','eng');
249
VALUES ( 'en','eng');
198
250
199
INSERT INTO language_descriptions(subtag, type, lang, description)
251
INSERT INTO language_descriptions(subtag, type, lang, description)
200
VALUES( 'en', 'language', 'en', 'English');
252
VALUES ( 'en', 'language', 'en', 'English');
201
253
202
INSERT INTO language_descriptions(subtag, type, lang, description)
254
INSERT INTO language_descriptions(subtag, type, lang, description)
203
VALUES( 'en', 'language', 'fr', 'Anglais');
255
VALUES ( 'en', 'language', 'fr', 'Anglais');
204
256
205
INSERT INTO language_descriptions(subtag, type, lang, description)
257
INSERT INTO language_descriptions(subtag, type, lang, description)
206
VALUES( 'en', 'language', 'de', 'Englisch');
258
VALUES ( 'en', 'language', 'de', 'Englisch');
207
259
208
-- Finnish
260
-- Spanish, Castilian
209
INSERT INTO language_subtag_registry( subtag, type, description, added)
261
INSERT INTO language_subtag_registry( subtag, type, description, added)
210
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
262
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
211
263
212
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
264
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
213
VALUES( 'fi','fin');
265
VALUES ( 'es','spa');
214
266
215
INSERT INTO language_descriptions(subtag, type, lang, description)
267
INSERT INTO language_descriptions(subtag, type, lang, description)
216
VALUES( 'fi', 'language', 'fi', 'suomi');
268
VALUES ( 'es', 'language', 'es', 'Español');
217
269
218
INSERT INTO language_descriptions(subtag, type, lang, description)
270
INSERT INTO language_descriptions(subtag, type, lang, description)
219
VALUES( 'fi', 'language', 'en', 'Finnish');
271
VALUES ( 'es', 'language', 'en', 'Spanish');
220
272
221
INSERT INTO language_descriptions(subtag, type, lang, description)
273
INSERT INTO language_descriptions(subtag, type, lang, description)
222
VALUES( 'fi', 'language', 'de', 'Finnisch');
274
VALUES ( 'es', 'language', 'fr', 'Espagnol');
223
275
224
-- French
276
INSERT INTO language_descriptions(subtag, type, lang, description)
277
VALUES ( 'es', 'language', 'de', 'Spanisch');
278
279
-- Basque
225
INSERT INTO language_subtag_registry( subtag, type, description, added)
280
INSERT INTO language_subtag_registry( subtag, type, description, added)
226
VALUES ( 'fr', 'language', 'French','2005-10-16' );
281
VALUES ( 'eu', 'language', 'Basque','2014-10-30');
282
283
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
284
VALUES ( 'eu','eus');
285
286
INSERT INTO language_descriptions(subtag, type, lang, description)
287
VALUES ( 'eu', 'language', 'eu', 'Euskera');
288
289
INSERT INTO language_descriptions(subtag, type, lang, description)
290
VALUES ( 'eu', 'language', 'en', 'Basque');
291
292
-- Persian
293
INSERT INTO language_subtag_registry( subtag, type, description, added)
294
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
227
295
228
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
296
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
229
VALUES( 'fr','fre');
297
VALUES ( 'fa','per');
230
298
231
INSERT INTO language_descriptions(subtag, type, lang, description)
299
INSERT INTO language_descriptions(subtag, type, lang, description)
232
VALUES( 'fr', 'language', 'en', 'French');
300
VALUES ( 'fa', 'language', 'fa', 'فارسى');
233
301
234
INSERT INTO language_descriptions(subtag, type, lang, description)
302
INSERT INTO language_descriptions(subtag, type, lang, description)
235
VALUES( 'fr', 'language', 'fr', 'Français');
303
VALUES ( 'fa', 'language', 'en', 'Persian');
236
304
237
INSERT INTO language_descriptions(subtag, type, lang, description)
305
INSERT INTO language_descriptions(subtag, type, lang, description)
238
VALUES( 'fr', 'language', 'de', 'Französisch');
306
VALUES ( 'fa', 'language', 'fr', 'Persan');
239
307
240
-- INSERT INTO language_descriptions(subtag, type, lang, description)
308
INSERT INTO language_descriptions(subtag, type, lang, description)
241
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
309
VALUES ( 'fa', 'language', 'de', 'Persisch');
242
310
243
-- Lao
311
-- Finnish
244
INSERT INTO language_subtag_registry( subtag, type, description, added)
312
INSERT INTO language_subtag_registry( subtag, type, description, added)
245
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
313
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
246
314
247
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
315
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
248
VALUES( 'lo','lao');
316
VALUES ( 'fi','fin');
249
317
250
INSERT INTO language_descriptions(subtag, type, lang, description)
318
INSERT INTO language_descriptions(subtag, type, lang, description)
251
VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ');
319
VALUES ( 'fi', 'language', 'fi', 'Suomi');
252
320
253
INSERT INTO language_descriptions(subtag, type, lang, description)
321
INSERT INTO language_descriptions(subtag, type, lang, description)
254
VALUES( 'lo', 'language', 'en', 'Lao');
322
VALUES ( 'fi', 'language', 'en', 'Finnish');
255
323
256
INSERT INTO language_descriptions(subtag, type, lang, description)
324
INSERT INTO language_descriptions(subtag, type, lang, description)
257
VALUES( 'lo', 'language', 'fr', 'Laotien');
325
VALUES ( 'fi', 'language', 'de', 'Finnisch');
326
327
-- Faroese
328
INSERT INTO language_subtag_registry( subtag, type, description, added)
329
VALUES ( 'fo', 'language', 'Faroese','2014-10-30');
330
331
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
332
VALUES ( 'fo','fao');
258
333
259
INSERT INTO language_descriptions(subtag, type, lang, description)
334
INSERT INTO language_descriptions(subtag, type, lang, description)
260
VALUES( 'lo', 'language', 'de', 'Laotisch');
335
VALUES ( 'fo', 'language', 'fo', 'Føroyskt');
261
336
262
-- German
337
INSERT INTO language_descriptions(subtag, type, lang, description)
338
VALUES ( 'fo', 'language', 'en', 'Faroese');
339
340
-- French
263
INSERT INTO language_subtag_registry( subtag, type, description, added)
341
INSERT INTO language_subtag_registry( subtag, type, description, added)
264
VALUES ( 'de', 'language', 'German','2005-10-16' );
342
VALUES ( 'fr', 'language', 'French','2005-10-16' );
265
343
266
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
344
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
267
VALUES( 'de','ger');
345
VALUES ( 'fr','fre');
268
346
269
INSERT INTO language_descriptions(subtag, type, lang, description)
347
INSERT INTO language_descriptions(subtag, type, lang, description)
270
VALUES( 'de', 'language', 'de', 'Deutsch');
348
VALUES ( 'fr', 'language', 'en', 'French');
271
349
272
INSERT INTO language_descriptions(subtag, type, lang, description)
350
INSERT INTO language_descriptions(subtag, type, lang, description)
273
VALUES( 'de', 'language', 'en', 'German');
351
VALUES ( 'fr', 'language', 'fr', 'Français');
274
352
275
INSERT INTO language_descriptions(subtag, type, lang, description)
353
INSERT INTO language_descriptions(subtag, type, lang, description)
276
VALUES( 'de', 'language', 'fr', 'Allemand');
354
VALUES ( 'fr', 'language', 'de', 'Französisch');
277
355
278
-- Greek
356
-- Galician
279
INSERT INTO language_subtag_registry( subtag, type, description, added)
357
INSERT INTO language_subtag_registry( subtag, type, description, added)
280
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
358
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
281
359
282
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
360
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
283
VALUES( 'el','gre');
361
VALUES ( 'gl','glg');
284
362
285
INSERT INTO language_descriptions(subtag, type, lang, description)
363
INSERT INTO language_descriptions(subtag, type, lang, description)
286
VALUES( 'el', 'language', 'el', 'ελληνικά');
364
VALUES ( 'gl', 'language', 'gl', 'Galego');
287
365
288
INSERT INTO language_descriptions(subtag, type, lang, description)
366
INSERT INTO language_descriptions(subtag, type, lang, description)
289
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
367
VALUES ( 'gl', 'language', 'en', 'Galician');
290
368
291
INSERT INTO language_descriptions(subtag, type, lang, description)
369
INSERT INTO language_descriptions(subtag, type, lang, description)
292
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
370
VALUES ( 'gl', 'language', 'fr', 'Galicien');
293
371
294
INSERT INTO language_descriptions(subtag, type, lang, description)
372
INSERT INTO language_descriptions(subtag, type, lang, description)
295
VALUES( 'el', 'language', 'de', 'Griechisch (Moern [1453- ]');
373
VALUES ( 'gl', 'language', 'de', 'Galicisch');
296
374
297
-- Hebrew
375
-- Hebrew
298
INSERT INTO language_subtag_registry( subtag, type, description, added)
376
INSERT INTO language_subtag_registry( subtag, type, description, added)
299
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
377
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
300
378
301
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
379
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
302
VALUES( 'he','heb');
380
VALUES ( 'he','heb');
303
381
304
INSERT INTO language_descriptions(subtag, type, lang, description)
382
INSERT INTO language_descriptions(subtag, type, lang, description)
305
VALUES( 'he', 'language', 'he', 'עברית');
383
VALUES ( 'he', 'language', 'he', 'עִבְרִית');
306
384
307
INSERT INTO language_descriptions(subtag, type, lang, description)
385
INSERT INTO language_descriptions(subtag, type, lang, description)
308
VALUES( 'he', 'language', 'en', 'Hebrew');
386
VALUES ( 'he', 'language', 'en', 'Hebrew');
309
387
310
INSERT INTO language_descriptions(subtag, type, lang, description)
388
INSERT INTO language_descriptions(subtag, type, lang, description)
311
VALUES( 'he', 'language', 'fr', 'Hébreu');
389
VALUES ( 'he', 'language', 'fr', 'Hébreu');
312
390
313
INSERT INTO language_descriptions(subtag, type, lang, description)
391
INSERT INTO language_descriptions(subtag, type, lang, description)
314
VALUES( 'he', 'language', 'de', 'Hebräisch');
392
VALUES ( 'he', 'language', 'de', 'Hebräisch');
315
393
316
-- Hindi
394
-- Hindi
317
INSERT INTO language_subtag_registry( subtag, type, description, added)
395
INSERT INTO language_subtag_registry( subtag, type, description, added)
318
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
396
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
319
397
320
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
398
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
321
VALUES( 'hi','hin');
399
VALUES ( 'hi','hin');
322
400
323
INSERT INTO language_descriptions(subtag, type, lang, description)
401
INSERT INTO language_descriptions(subtag, type, lang, description)
324
VALUES( 'hi', 'language', 'hi', 'हिन्दी');
402
VALUES ( 'hi', 'language', 'hi', 'हिन्दी');
325
403
326
INSERT INTO language_descriptions(subtag, type, lang, description)
404
INSERT INTO language_descriptions(subtag, type, lang, description)
327
VALUES( 'hi', 'language', 'en', 'Hindi');
405
VALUES ( 'hi', 'language', 'en', 'Hindi');
328
406
329
INSERT INTO language_descriptions(subtag, type, lang, description)
407
INSERT INTO language_descriptions(subtag, type, lang, description)
330
VALUES( 'hi', 'language', 'fr', 'Hindi');
408
VALUES ( 'hi', 'language', 'fr', 'Hindi');
331
409
332
INSERT INTO language_descriptions(subtag, type, lang, description)
410
INSERT INTO language_descriptions(subtag, type, lang, description)
333
VALUES( 'hi', 'language', 'de', 'Hindi');
411
VALUES ( 'hi', 'language', 'de', 'Hindi');
334
412
335
-- Hungarian
413
-- Croatian
336
INSERT INTO language_subtag_registry( subtag, type, description, added)
414
INSERT INTO language_subtag_registry( subtag, type, description, added)
337
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
415
VALUES ( 'hr', 'language', 'Croatian','2014-07-24' );
338
416
339
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
417
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
340
VALUES( 'hu','hun');
418
VALUES ( 'hr','hrv');
341
419
342
INSERT INTO language_descriptions(subtag, type, lang, description)
420
INSERT INTO language_descriptions(subtag, type, lang, description)
343
VALUES( 'hu', 'language', 'hu', 'Magyar');
421
VALUES ( 'hr', 'language', 'hr', 'Hrvatski');
344
422
345
INSERT INTO language_descriptions(subtag, type, lang, description)
423
INSERT INTO language_descriptions(subtag, type, lang, description)
346
VALUES( 'hu', 'language', 'en', 'Hungarian');
424
VALUES ( 'hr', 'language', 'en', 'Croatian');
347
425
348
INSERT INTO language_descriptions(subtag, type, lang, description)
426
INSERT INTO language_descriptions(subtag, type, lang, description)
349
VALUES( 'hu', 'language', 'fr', 'Hongrois');
427
VALUES ( 'hr', 'language', 'fr', 'Croate');
350
428
351
INSERT INTO language_descriptions(subtag, type, lang, description)
429
INSERT INTO language_descriptions(subtag, type, lang, description)
352
VALUES( 'hu', 'language', 'de', 'Ungarisch');
430
VALUES ( 'hr', 'language', 'de', 'Kroatisch');
353
431
354
-- Indonesian
432
-- Hungarian
355
INSERT INTO language_subtag_registry( subtag, type, description, added)
433
INSERT INTO language_subtag_registry( subtag, type, description, added)
356
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
434
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
357
435
358
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
436
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
359
VALUES( 'id','ind');
437
VALUES ( 'hu','hun');
360
438
361
INSERT INTO language_descriptions(subtag, type, lang, description)
439
INSERT INTO language_descriptions(subtag, type, lang, description)
362
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
440
VALUES ( 'hu', 'language', 'hu', 'Magyar');
363
441
364
INSERT INTO language_descriptions(subtag, type, lang, description)
442
INSERT INTO language_descriptions(subtag, type, lang, description)
365
VALUES( 'id', 'language', 'en', 'Indonesian');
443
VALUES ( 'hu', 'language', 'en', 'Hungarian');
366
444
367
INSERT INTO language_descriptions(subtag, type, lang, description)
445
INSERT INTO language_descriptions(subtag, type, lang, description)
368
VALUES( 'id', 'language', 'fr', 'Indonésien');
446
VALUES ( 'hu', 'language', 'fr', 'Hongrois');
369
447
370
INSERT INTO language_descriptions(subtag, type, lang, description)
448
INSERT INTO language_descriptions(subtag, type, lang, description)
371
VALUES( 'id', 'language', 'de', 'Indonesisch');
449
VALUES ( 'hu', 'language', 'de', 'Ungarisch');
372
450
373
-- Italian
451
-- Armenian
374
INSERT INTO language_subtag_registry( subtag, type, description, added)
452
INSERT INTO language_subtag_registry( subtag, type, description, added)
375
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
453
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
376
454
377
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
455
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
378
VALUES( 'it','ita');
456
VALUES ( 'hy','arm');
379
457
380
INSERT INTO language_descriptions(subtag, type, lang, description)
458
INSERT INTO language_descriptions(subtag, type, lang, description)
381
VALUES( 'it', 'language', 'it', 'Italiano');
459
VALUES ( 'hy', 'language', 'hy', 'Հայերեն');
382
460
383
INSERT INTO language_descriptions(subtag, type, lang, description)
461
INSERT INTO language_descriptions(subtag, type, lang, description)
384
VALUES( 'it', 'language', 'en', 'Italian');
462
VALUES ( 'hy', 'language', 'en', 'Armenian');
385
463
386
INSERT INTO language_descriptions(subtag, type, lang, description)
464
INSERT INTO language_descriptions(subtag, type, lang, description)
387
VALUES( 'it', 'language', 'fr', 'Italien');
465
VALUES ( 'hy', 'language', 'fr', 'Armenian');
388
466
389
INSERT INTO language_descriptions(subtag, type, lang, description)
467
INSERT INTO language_descriptions(subtag, type, lang, description)
390
VALUES( 'it', 'language', 'de', 'Italienisch');
468
VALUES ( 'hy', 'language', 'de', 'Armenisch');
391
469
392
-- Japanese
470
-- Indonesian
393
INSERT INTO language_subtag_registry( subtag, type, description, added)
471
INSERT INTO language_subtag_registry( subtag, type, description, added)
394
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
472
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
395
473
396
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
474
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
397
VALUES( 'ja','jpn');
475
VALUES ( 'id','ind');
398
476
399
INSERT INTO language_descriptions(subtag, type, lang, description)
477
INSERT INTO language_descriptions(subtag, type, lang, description)
400
VALUES( 'ja', 'language', 'ja', '日本語');
478
VALUES ( 'id', 'language', 'id', 'Bahasa Indonesia');
401
479
402
INSERT INTO language_descriptions(subtag, type, lang, description)
480
INSERT INTO language_descriptions(subtag, type, lang, description)
403
VALUES( 'ja', 'language', 'en', 'Japanese');
481
VALUES ( 'id', 'language', 'en', 'Indonesian');
404
482
405
INSERT INTO language_descriptions(subtag, type, lang, description)
483
INSERT INTO language_descriptions(subtag, type, lang, description)
406
VALUES( 'ja', 'language', 'fr', 'Japonais');
484
VALUES ( 'id', 'language', 'fr', 'Indonésien');
407
485
408
INSERT INTO language_descriptions(subtag, type, lang, description)
486
INSERT INTO language_descriptions(subtag, type, lang, description)
409
VALUES( 'ja', 'language', 'de', 'Japanisch');
487
VALUES ( 'id', 'language', 'de', 'Indonesisch');
410
488
411
-- Korean
489
-- Icelandic
412
INSERT INTO language_subtag_registry( subtag, type, description, added)
490
INSERT INTO language_subtag_registry( subtag, type, description, added)
413
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
491
VALUES ( 'is', 'language', 'Icelandic','2014-10-30');
492
493
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
494
VALUES ( 'is','ice');
495
496
INSERT INTO language_descriptions(subtag, type, lang, description)
497
VALUES ( 'is', 'language', 'is', 'Íslenska');
498
499
INSERT INTO language_descriptions(subtag, type, lang, description)
500
VALUES ( 'is', 'language', 'en', 'Icelandic');
501
502
-- Italian
503
INSERT INTO language_subtag_registry( subtag, type, description, added)
504
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
414
505
415
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
506
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
416
VALUES( 'ko','kor');
507
VALUES ( 'it','ita');
417
508
418
INSERT INTO language_descriptions(subtag, type, lang, description)
509
INSERT INTO language_descriptions(subtag, type, lang, description)
419
VALUES( 'ko', 'language', 'ko', '한국어');
510
VALUES ( 'it', 'language', 'it', 'Italiano');
420
511
421
INSERT INTO language_descriptions(subtag, type, lang, description)
512
INSERT INTO language_descriptions(subtag, type, lang, description)
422
VALUES( 'ko', 'language', 'en', 'Korean');
513
VALUES ( 'it', 'language', 'en', 'Italian');
423
514
424
INSERT INTO language_descriptions(subtag, type, lang, description)
515
INSERT INTO language_descriptions(subtag, type, lang, description)
425
VALUES( 'ko', 'language', 'fr', 'Coréen');
516
VALUES ( 'it', 'language', 'fr', 'Italien');
426
517
427
INSERT INTO language_descriptions(subtag, type, lang, description)
518
INSERT INTO language_descriptions(subtag, type, lang, description)
428
VALUES( 'ko', 'language', 'de', 'Koreanisch');
519
VALUES ( 'it', 'language', 'de', 'Italienisch');
429
520
430
-- Latin
521
-- Japanese
431
INSERT INTO language_subtag_registry( subtag, type, description, added)
522
INSERT INTO language_subtag_registry( subtag, type, description, added)
432
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
523
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
433
524
434
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
525
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
435
VALUES( 'la','lat');
526
VALUES ( 'ja','jpn');
436
527
437
INSERT INTO language_descriptions(subtag, type, lang, description)
528
INSERT INTO language_descriptions(subtag, type, lang, description)
438
VALUES( 'la', 'language', 'la', 'Latina');
529
VALUES ( 'ja', 'language', 'ja', '日本語');
439
530
440
INSERT INTO language_descriptions(subtag, type, lang, description)
531
INSERT INTO language_descriptions(subtag, type, lang, description)
441
VALUES( 'la', 'language', 'en', 'Latin');
532
VALUES ( 'ja', 'language', 'en', 'Japanese');
442
533
443
INSERT INTO language_descriptions(subtag, type, lang, description)
534
INSERT INTO language_descriptions(subtag, type, lang, description)
444
VALUES( 'la', 'language', 'fr', 'Latin');
535
VALUES ( 'ja', 'language', 'fr', 'Japonais');
445
536
446
INSERT INTO language_descriptions(subtag, type, lang, description)
537
INSERT INTO language_descriptions(subtag, type, lang, description)
447
VALUES( 'la', 'language', 'de', 'Latein');
538
VALUES ( 'ja', 'language', 'de', 'Japanisch');
448
449
-- Galician
450
539
540
-- Kannada
451
INSERT INTO language_subtag_registry( subtag, type, description, added)
541
INSERT INTO language_subtag_registry( subtag, type, description, added)
452
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
542
VALUES ( 'ka', 'language', 'Kannada','2014-10-30');
453
543
454
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
544
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
455
VALUES( 'gl','glg');
545
VALUES ( 'ka','kan');
456
546
457
INSERT INTO language_descriptions(subtag, type, lang, description)
547
INSERT INTO language_descriptions(subtag, type, lang, description)
458
VALUES( 'gl', 'language', 'gl', 'Galego');
548
VALUES ( 'ka', 'language', 'ka', 'ಕನ್ನಡ');
459
549
460
INSERT INTO language_descriptions(subtag, type, lang, description)
550
INSERT INTO language_descriptions(subtag, type, lang, description)
461
VALUES( 'gl', 'language', 'en', 'Galician');
551
VALUES ( 'ka', 'language', 'en', 'Kannada');
462
552
463
INSERT INTO language_descriptions(subtag, type, lang, description)
553
-- Khmer
464
VALUES( 'gl', 'language', 'fr', 'Galicien');
554
INSERT INTO language_subtag_registry( subtag, type, description, added)
555
VALUES ( 'km', 'language', 'Khmer','2014-10-30');
556
557
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
558
VALUES( 'km','khm');
465
559
466
INSERT INTO language_descriptions(subtag, type, lang, description)
560
INSERT INTO language_descriptions(subtag, type, lang, description)
467
VALUES( 'gl', 'language', 'de', 'Galicisch');
561
VALUES ( 'km', 'language', 'km', 'ភាសាខ្មែរ');
468
562
563
INSERT INTO language_descriptions(subtag, type, lang, description)
564
VALUES( 'km', 'language', 'en', 'Khmer');
469
565
470
-- Norwegian (bokmål)
566
-- Korean
471
INSERT INTO language_subtag_registry( subtag, type, description, added)
567
INSERT INTO language_subtag_registry( subtag, type, description, added)
472
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
568
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
473
474
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
475
VALUES( 'nb','nor');
476
569
477
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
570
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
478
VALUES( 'nb','nob');
571
VALUES ( 'ko','kor');
479
572
480
INSERT INTO language_descriptions(subtag, type, lang, description)
573
INSERT INTO language_descriptions(subtag, type, lang, description)
481
VALUES( 'nb', 'language', 'nb', 'Norsk bokmål');
574
VALUES ( 'ko', 'language', 'ko', '한국어');
482
575
483
INSERT INTO language_descriptions(subtag, type, lang, description)
576
INSERT INTO language_descriptions(subtag, type, lang, description)
484
VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
577
VALUES ( 'ko', 'language', 'en', 'Korean');
485
578
486
INSERT INTO language_descriptions(subtag, type, lang, description)
579
INSERT INTO language_descriptions(subtag, type, lang, description)
487
VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
580
VALUES ( 'ko', 'language', 'fr', 'Coréen');
488
581
489
INSERT INTO language_descriptions(subtag, type, lang, description)
582
INSERT INTO language_descriptions(subtag, type, lang, description)
490
VALUES( 'nb', 'language', 'de', 'Norwegisch bokmål');
583
VALUES ( 'ko', 'language', 'de', 'Koreanisch');
491
584
492
-- Norwegian (nynorsk)
585
-- Kurdish
493
INSERT INTO language_subtag_registry( subtag, type, description, added)
586
INSERT INTO language_subtag_registry( subtag, type, description, added)
494
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
587
VALUES ( 'ku', 'language', 'Kurdish','2014-05-13');
495
588
496
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
589
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
497
VALUES( 'nn','nno');
590
VALUES ( 'ku','kur');
498
591
499
INSERT INTO language_descriptions(subtag, type, lang, description)
592
INSERT INTO language_descriptions(subtag, type, lang, description)
500
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
593
VALUES ( 'ku', 'language', 'ku', 'کوردی');
501
594
502
INSERT INTO language_descriptions(subtag, type, lang, description)
595
INSERT INTO language_descriptions(subtag, type, lang, description)
503
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
596
VALUES ( 'ku', 'language', 'en', 'Kurdish');
504
597
505
INSERT INTO language_descriptions(subtag, type, lang, description)
598
INSERT INTO language_descriptions(subtag, type, lang, description)
506
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
599
VALUES ( 'ku', 'language', 'fr', 'Kurde');
507
600
508
INSERT INTO language_descriptions(subtag, type, lang, description)
601
INSERT INTO language_descriptions(subtag, type, lang, description)
509
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
602
VALUES ( 'ku', 'language', 'de', 'Kurdisch');
510
603
511
INSERT INTO language_descriptions(subtag, type, lang, description)
604
INSERT INTO language_descriptions(subtag, type, lang, description)
512
VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk');
605
VALUES ( 'ku', 'language', 'es', 'Kurdo');
513
606
514
-- Persian
607
-- Latin
515
INSERT INTO language_subtag_registry( subtag, type, description, added)
608
INSERT INTO language_subtag_registry( subtag, type, description, added)
516
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
609
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
517
610
518
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
611
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
519
VALUES( 'fa','per');
612
VALUES ( 'la','lat');
520
613
521
INSERT INTO language_descriptions(subtag, type, lang, description)
614
INSERT INTO language_descriptions(subtag, type, lang, description)
522
VALUES( 'fa', 'language', 'fa', 'فارسى');
615
VALUES ( 'la', 'language', 'la', 'Latina');
523
616
524
INSERT INTO language_descriptions(subtag, type, lang, description)
617
INSERT INTO language_descriptions(subtag, type, lang, description)
525
VALUES( 'fa', 'language', 'en', 'Persian');
618
VALUES ( 'la', 'language', 'en', 'Latin');
526
619
527
INSERT INTO language_descriptions(subtag, type, lang, description)
620
INSERT INTO language_descriptions(subtag, type, lang, description)
528
VALUES( 'fa', 'language', 'fr', 'Persan');
621
VALUES ( 'la', 'language', 'fr', 'Latin');
529
622
530
INSERT INTO language_descriptions(subtag, type, lang, description)
623
INSERT INTO language_descriptions(subtag, type, lang, description)
531
VALUES( 'fa', 'language', 'de', 'Persisch');
624
VALUES ( 'la', 'language', 'de', 'Latein');
532
625
533
-- Polish
626
-- Lao
534
INSERT INTO language_subtag_registry( subtag, type, description, added)
627
INSERT INTO language_subtag_registry( subtag, type, description, added)
535
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
628
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
536
629
537
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
630
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
538
VALUES( 'pl','pol');
631
VALUES ( 'lo','lao');
539
632
540
INSERT INTO language_descriptions(subtag, type, lang, description)
633
INSERT INTO language_descriptions(subtag, type, lang, description)
541
VALUES( 'pl', 'language', 'pl', 'Polski');
634
VALUES ( 'lo', 'language', 'lo', 'ພາສາລາວ');
542
635
543
INSERT INTO language_descriptions(subtag, type, lang, description)
636
INSERT INTO language_descriptions(subtag, type, lang, description)
544
VALUES( 'pl', 'language', 'en', 'Polish');
637
VALUES ( 'lo', 'language', 'en', 'Lao');
545
638
546
INSERT INTO language_descriptions(subtag, type, lang, description)
639
INSERT INTO language_descriptions(subtag, type, lang, description)
547
VALUES( 'pl', 'language', 'fr', 'Polonais');
640
VALUES ( 'lo', 'language', 'fr', 'Laotien');
548
641
549
INSERT INTO language_descriptions(subtag, type, lang, description)
642
INSERT INTO language_descriptions(subtag, type, lang, description)
550
VALUES( 'pl', 'language', 'de', 'Polnisch');
643
VALUES ( 'lo', 'language', 'de', 'Laotisch');
551
644
552
-- Portuguese
645
-- Maori
553
INSERT INTO language_subtag_registry( subtag, type, description, added)
646
INSERT INTO language_subtag_registry( subtag, type, description, added)
554
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
647
VALUES ( 'mi', 'language', 'Maori','2014-10-30');
555
648
556
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
649
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
557
VALUES( 'pt','por');
650
VALUES ( 'mi','mri');
558
651
559
INSERT INTO language_descriptions(subtag, type, lang, description)
652
INSERT INTO language_descriptions(subtag, type, lang, description)
560
VALUES( 'pt', 'language', 'pt', 'Português');
653
VALUES ( 'mi', 'language', 'mi', 'Te Reo Māori');
561
654
562
INSERT INTO language_descriptions(subtag, type, lang, description)
655
INSERT INTO language_descriptions(subtag, type, lang, description)
563
VALUES( 'pt', 'language', 'en', 'Portuguese');
656
VALUES ( 'mi', 'language', 'en', 'Maori');
657
658
-- Mongolian
659
INSERT INTO language_subtag_registry( subtag, type, description, added)
660
VALUES ( 'mn', 'language', 'Mongolian','2014-10-30');
661
662
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
663
VALUES ( 'mn','mon');
564
664
565
INSERT INTO language_descriptions(subtag, type, lang, description)
665
INSERT INTO language_descriptions(subtag, type, lang, description)
566
VALUES( 'pt', 'language', 'fr', 'Portugais');
666
VALUES ( 'mn', 'language', 'mn', 'Mонгол');
567
667
568
INSERT INTO language_descriptions(subtag, type, lang, description)
668
INSERT INTO language_descriptions(subtag, type, lang, description)
569
VALUES( 'pt', 'language', 'de', 'Portugiesisch');
669
VALUES ( 'mn', 'language', 'en', 'Mongolian');
570
670
571
-- Romanian
671
-- Marathi
572
INSERT INTO language_subtag_registry( subtag, type, description, added)
672
INSERT INTO language_subtag_registry( subtag, type, description, added)
573
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
673
VALUES ( 'mr', 'language', 'Marathi','2014-10-30');
574
674
575
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
675
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
576
VALUES( 'ro','rum');
676
VALUES ( 'mr','mar');
577
677
578
INSERT INTO language_descriptions(subtag, type, lang, description)
678
INSERT INTO language_descriptions(subtag, type, lang, description)
579
VALUES( 'ro', 'language', 'ro', 'Română');
679
VALUES ( 'mr', 'language', 'mr', 'मराठी');
580
680
581
INSERT INTO language_descriptions(subtag, type, lang, description)
681
INSERT INTO language_descriptions(subtag, type, lang, description)
582
VALUES( 'ro', 'language', 'en', 'Romanian');
682
VALUES ( 'mr', 'language', 'en', 'Marathi');
683
684
-- Malay
685
INSERT INTO language_subtag_registry( subtag, type, description, added)
686
VALUES ( 'ms', 'language', 'Malay','2014-10-30');
687
688
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
689
VALUES ( 'ms','may');
583
690
584
INSERT INTO language_descriptions(subtag, type, lang, description)
691
INSERT INTO language_descriptions(subtag, type, lang, description)
585
VALUES( 'ro', 'language', 'fr', 'Roumain');
692
VALUES ( 'ms', 'language', 'ms', 'Bahasa melayu');
586
693
587
INSERT INTO language_descriptions(subtag, type, lang, description)
694
INSERT INTO language_descriptions(subtag, type, lang, description)
588
VALUES( 'ro', 'language', 'de', 'Rumänisch');
695
VALUES ( 'ms', 'language', 'en', 'Malay');
589
696
590
-- Russian
697
-- Norwegian (bokmål)
591
INSERT INTO language_subtag_registry( subtag, type, description, added)
698
INSERT INTO language_subtag_registry( subtag, type, description, added)
592
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
699
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
593
700
594
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
701
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
595
VALUES( 'ru','rus');
702
VALUES ( 'nb','nob');
596
703
597
INSERT INTO language_descriptions(subtag, type, lang, description)
704
INSERT INTO language_descriptions(subtag, type, lang, description)
598
VALUES( 'ru', 'language', 'ru', 'Русский');
705
VALUES ( 'nb', 'language', 'nb', 'Norsk bokmål');
599
706
600
INSERT INTO language_descriptions(subtag, type, lang, description)
707
INSERT INTO language_descriptions(subtag, type, lang, description)
601
VALUES( 'ru', 'language', 'en', 'Russian');
708
VALUES ( 'nb', 'language', 'en', 'Norwegian bokmål');
602
709
603
INSERT INTO language_descriptions(subtag, type, lang, description)
710
INSERT INTO language_descriptions(subtag, type, lang, description)
604
VALUES( 'ru', 'language', 'fr', 'Russe');
711
VALUES ( 'nb', 'language', 'fr', 'Norvégien bokmål');
605
712
606
INSERT INTO language_descriptions(subtag, type, lang, description)
713
INSERT INTO language_descriptions(subtag, type, lang, description)
607
VALUES( 'ru', 'language', 'de', 'Russisch');
714
VALUES ( 'nb', 'language', 'de', 'Norwegisch bokmål');
608
715
609
-- Serbian
716
-- Nepali
610
INSERT INTO language_subtag_registry( subtag, type, description, added)
717
INSERT INTO language_subtag_registry( subtag, type, description, added)
611
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
718
VALUES ( 'ne', 'language', 'Nepali','2014-10-30');
612
719
613
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
720
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
614
VALUES( 'sr','srp');
721
VALUES ( 'ne','nep');
615
616
INSERT INTO language_descriptions(subtag, type, lang, description)
617
VALUES( 'sr', 'language', 'sr', 'српски');
618
722
619
INSERT INTO language_descriptions(subtag, type, lang, description)
723
INSERT INTO language_descriptions(subtag, type, lang, description)
620
VALUES( 'sr', 'language', 'en', 'Serbian');
724
VALUES ( 'ne', 'language', 'ne', 'नेपाली');
621
725
622
INSERT INTO language_descriptions(subtag, type, lang, description)
726
INSERT INTO language_descriptions(subtag, type, lang, description)
623
VALUES( 'sr', 'language', 'fr', 'Serbe');
727
VALUES ( 'ne', 'language', 'en', 'Nepali');
624
728
625
INSERT INTO language_descriptions(subtag, type, lang, description)
729
-- Dutch
626
VALUES( 'sr', 'language', 'de', 'Serbisch');
627
628
-- Spanish, Castilian
629
INSERT INTO language_subtag_registry( subtag, type, description, added)
730
INSERT INTO language_subtag_registry( subtag, type, description, added)
630
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
731
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
631
732
632
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
733
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
633
VALUES( 'es','spa');
734
VALUES ( 'nl','dut');
634
735
635
INSERT INTO language_descriptions(subtag, type, lang, description)
736
INSERT INTO language_descriptions(subtag, type, lang, description)
636
VALUES( 'es', 'language', 'es', 'Español');
737
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
637
738
638
INSERT INTO language_descriptions(subtag, type, lang, description)
739
INSERT INTO language_descriptions(subtag, type, lang, description)
639
VALUES( 'es', 'language', 'en', 'Spanish');
740
VALUES ( 'nl', 'language', 'en', 'Dutch');
640
741
641
INSERT INTO language_descriptions(subtag, type, lang, description)
742
INSERT INTO language_descriptions(subtag, type, lang, description)
642
VALUES( 'es', 'language', 'fr', 'Espagnol');
743
VALUES ( 'nl', 'language', 'fr', 'Néerlandais');
643
744
644
INSERT INTO language_descriptions(subtag, type, lang, description)
745
INSERT INTO language_descriptions(subtag, type, lang, description)
645
VALUES( 'es', 'language', 'de', 'Spanisch');
746
VALUES ( 'nl', 'language', 'de', 'Niederländisch');
646
747
647
-- Spanish, Catalan
748
-- Norwegian (nynorsk)
648
INSERT INTO language_subtag_registry( subtag, type, description, added)
749
INSERT INTO language_subtag_registry( subtag, type, description, added)
649
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
750
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
650
751
651
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
752
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
652
VALUES( 'ca','cat');
753
VALUES ( 'nn','nno');
653
754
654
INSERT INTO language_descriptions(subtag, type, lang, description)
755
INSERT INTO language_descriptions(subtag, type, lang, description)
655
VALUES( 'ca', 'language', 'es', 'Catalán');
756
VALUES ( 'nn', 'language', 'nb', 'Norsk nynorsk');
656
757
657
INSERT INTO language_descriptions(subtag, type, lang, description)
758
INSERT INTO language_descriptions(subtag, type, lang, description)
658
VALUES( 'ca', 'language', 'en', 'Catalan');
759
VALUES ( 'nn', 'language', 'nn', 'Norsk nynorsk');
659
760
660
INSERT INTO language_descriptions(subtag, type, lang, description)
761
INSERT INTO language_descriptions(subtag, type, lang, description)
661
VALUES( 'ca', 'language', 'fr', 'Catalan');
762
VALUES ( 'nn', 'language', 'en', 'Norwegian nynorsk');
662
763
663
INSERT INTO language_descriptions(subtag, type, lang, description)
764
INSERT INTO language_descriptions(subtag, type, lang, description)
664
VALUES( 'ca', 'language', 'ca', 'Català');
765
VALUES ( 'nn', 'language', 'fr', 'Norvégien nynorsk');
665
766
666
INSERT INTO language_descriptions(subtag, type, lang, description)
767
INSERT INTO language_descriptions(subtag, type, lang, description)
667
VALUES( 'ca', 'language', 'de', 'Katalanisch');
768
VALUES ( 'nn', 'language', 'de', 'Norwegisch nynorsk');
668
769
669
-- Swedish
770
-- Pangwa
670
INSERT INTO language_subtag_registry( subtag, type, description, added)
771
INSERT INTO language_subtag_registry( subtag, type, description, added)
671
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
772
VALUES ( 'pbr', 'language', 'Pangwa','2014-10-30');
672
773
673
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
774
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
674
VALUES( 'sv','swe');
775
VALUES ( 'pbr','pbr');
675
676
INSERT INTO language_descriptions(subtag, type, lang, description)
677
VALUES( 'sv', 'language', 'sv', 'Svenska');
678
679
INSERT INTO language_descriptions(subtag, type, lang, description)
680
VALUES( 'sv', 'language', 'en', 'Swedish');   
681
776
682
INSERT INTO language_descriptions(subtag, type, lang, description)
777
INSERT INTO language_descriptions(subtag, type, lang, description)
683
VALUES( 'sv', 'language', 'fr', 'Suédois');
778
VALUES ( 'pbr', 'language', 'pbr', 'Ekipangwa');
684
779
685
INSERT INTO language_descriptions(subtag, type, lang, description)
780
INSERT INTO language_descriptions(subtag, type, lang, description)
686
VALUES( 'sv', 'language', 'de', 'Schwedisch');
781
VALUES ( 'pbr', 'language', 'en', 'Pangwa');
687
782
688
-- Tetum
783
-- Polish
689
INSERT INTO language_subtag_registry( subtag, type, description, added)
784
INSERT INTO language_subtag_registry( subtag, type, description, added)
690
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
785
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
691
786
692
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
787
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
693
VALUES( 'tet','tet');
788
VALUES ( 'pl','pol');
694
789
695
INSERT INTO language_descriptions(subtag, type, lang, description)
790
INSERT INTO language_descriptions(subtag, type, lang, description)
696
VALUES( 'tet', 'language', 'tet', 'tetun');
791
VALUES ( 'pl', 'language', 'pl', 'Polski');
697
792
698
INSERT INTO language_descriptions(subtag, type, lang, description)
793
INSERT INTO language_descriptions(subtag, type, lang, description)
699
VALUES( 'tet', 'language', 'en', 'Tetum');
794
VALUES ( 'pl', 'language', 'en', 'Polish');
700
795
701
INSERT INTO language_descriptions(subtag, type, lang, description)
796
INSERT INTO language_descriptions(subtag, type, lang, description)
702
VALUES( 'tet', 'language', 'fr', 'Tétoum');
797
VALUES ( 'pl', 'language', 'fr', 'Polonais');
703
798
704
INSERT INTO language_descriptions(subtag, type, lang, description)
799
INSERT INTO language_descriptions(subtag, type, lang, description)
705
VALUES( 'tet', 'language', 'de', 'Tetum');
800
VALUES ( 'pl', 'language', 'de', 'Polnisch');
706
801
707
-- Thai
802
-- Dari
708
INSERT INTO language_subtag_registry( subtag, type, description, added)
803
INSERT INTO language_subtag_registry( subtag, type, description, added)
709
VALUES ( 'th', 'language', 'Thai','2005-10-16');
804
VALUES ( 'prs', 'language', 'Dari','2014-10-30');
710
805
711
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
806
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
712
VALUES( 'th','tha');
807
VALUES ( 'prs','prs');
713
714
INSERT INTO language_descriptions(subtag, type, lang, description)
715
VALUES( 'th', 'language', 'th', 'ภาษาไทย');
716
717
INSERT INTO language_descriptions(subtag, type, lang, description)
718
VALUES( 'th', 'language', 'en', 'Thai');   
719
808
720
INSERT INTO language_descriptions(subtag, type, lang, description)
809
INSERT INTO language_descriptions(subtag, type, lang, description)
721
VALUES( 'th', 'language', 'fr', 'Thaï');
810
VALUES ( 'prs', 'language', 'prs', 'درى');
722
811
723
INSERT INTO language_descriptions(subtag, type, lang, description)
812
INSERT INTO language_descriptions(subtag, type, lang, description)
724
VALUES( 'th', 'language', 'de', 'Thailändisch');
813
VALUES ( 'prs', 'language', 'en', 'Dari');
725
814
726
-- Turkish
815
-- Portuguese
727
INSERT INTO language_subtag_registry( subtag, type, description, added)
816
INSERT INTO language_subtag_registry( subtag, type, description, added)
728
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
817
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
729
818
730
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
819
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
731
VALUES( 'tr','tur');
820
VALUES ( 'pt','por');
732
821
733
INSERT INTO language_descriptions(subtag, type, lang, description)
822
INSERT INTO language_descriptions(subtag, type, lang, description)
734
VALUES( 'tr', 'language', 'tr', 'Türkçe');
823
VALUES ( 'pt', 'language', 'pt', 'Português');
735
824
736
INSERT INTO language_descriptions(subtag, type, lang, description)
825
INSERT INTO language_descriptions(subtag, type, lang, description)
737
VALUES( 'tr', 'language', 'en', 'Turkish');   
826
VALUES ( 'pt', 'language', 'en', 'Portuguese');
738
827
739
INSERT INTO language_descriptions(subtag, type, lang, description)
828
INSERT INTO language_descriptions(subtag, type, lang, description)
740
VALUES( 'tr', 'language', 'fr', 'Turc');
829
VALUES ( 'pt', 'language', 'fr', 'Portugais');
741
830
742
INSERT INTO language_descriptions(subtag, type, lang, description)
831
INSERT INTO language_descriptions(subtag, type, lang, description)
743
VALUES( 'tr', 'language', 'de', 'Türkisch');
832
VALUES ( 'pt', 'language', 'de', 'Portugiesisch');
744
833
745
-- Ukranian
834
-- Romanian
746
INSERT INTO language_subtag_registry( subtag, type, description, added)
835
INSERT INTO language_subtag_registry( subtag, type, description, added)
747
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
836
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
748
837
749
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
838
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
750
VALUES( 'uk','ukr');
839
VALUES ( 'ro','rum');
751
840
752
INSERT INTO language_descriptions(subtag, type, lang, description)
841
INSERT INTO language_descriptions(subtag, type, lang, description)
753
VALUES( 'uk', 'language', 'uk', 'Українська');
842
VALUES ( 'ro', 'language', 'ro', 'Român');
754
843
755
INSERT INTO language_descriptions(subtag, type, lang, description)
844
INSERT INTO language_descriptions(subtag, type, lang, description)
756
VALUES( 'uk', 'language', 'en', 'Ukranian');
845
VALUES ( 'ro', 'language', 'en', 'Romanian');
757
846
758
INSERT INTO language_descriptions(subtag, type, lang, description)
847
INSERT INTO language_descriptions(subtag, type, lang, description)
759
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
848
VALUES ( 'ro', 'language', 'fr', 'Roumain');
760
849
761
INSERT INTO language_descriptions(subtag, type, lang, description)
850
INSERT INTO language_descriptions(subtag, type, lang, description)
762
VALUES( 'uk', 'language', 'de', 'Ukrainisch');
851
VALUES ( 'ro', 'language', 'de', 'Rumänisch');
763
852
764
-- Urdu
853
-- Russian
765
INSERT INTO language_subtag_registry( subtag, type, description, added)
854
INSERT INTO language_subtag_registry( subtag, type, description, added)
766
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
855
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
767
856
768
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
857
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
769
VALUES( 'ur','urd');
858
VALUES ( 'ru','rus');
770
859
771
INSERT INTO language_descriptions(subtag, type, lang, description)
860
INSERT INTO language_descriptions(subtag, type, lang, description)
772
VALUES( 'ur', 'language', 'en', 'Urdu');
861
VALUES ( 'ru', 'language', 'ru', 'Русский');
773
862
774
INSERT INTO language_descriptions(subtag, type, lang, description)
863
INSERT INTO language_descriptions(subtag, type, lang, description)
775
VALUES( 'ur', 'language', 'ur', 'اردو');
864
VALUES ( 'ru', 'language', 'en', 'Russian');
776
865
777
INSERT INTO language_descriptions(subtag, type, lang, description)
866
INSERT INTO language_descriptions(subtag, type, lang, description)
778
VALUES( 'ur', 'language', 'fr', 'Ourdou');
867
VALUES ( 'ru', 'language', 'fr', 'Russe');
779
868
780
INSERT INTO language_descriptions(subtag, type, lang, description)
869
INSERT INTO language_descriptions(subtag, type, lang, description)
781
VALUES( 'ur', 'language', 'de', 'Urdu');
870
VALUES ( 'ru', 'language', 'de', 'Russisch');
782
871
783
-- SCRIPTS
872
-- Kinyarwanda
784
-- Arabic
785
INSERT INTO language_subtag_registry( subtag, type, description, added)
873
INSERT INTO language_subtag_registry( subtag, type, description, added)
786
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
874
VALUES ( 'rw', 'language', 'Kinyarwanda','2014-10-30');
875
876
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
877
VALUES ( 'rw','kin');
787
878
788
INSERT INTO language_descriptions(subtag, type, lang, description)
879
INSERT INTO language_descriptions(subtag, type, lang, description)
789
VALUES ( 'Arab','script', 'Arab', 'العربية');
880
VALUES ( 'rw', 'language', 'rw', 'Ikinyarwanda');
790
881
791
INSERT INTO language_descriptions(subtag, type, lang, description)
882
INSERT INTO language_descriptions(subtag, type, lang, description)
792
VALUES( 'Arab', 'script','en', 'Arabic');
883
VALUES ( 'rw', 'language', 'en', 'Kinyarwanda');
884
885
-- Sindhi
886
INSERT INTO language_subtag_registry( subtag, type, description, added)
887
VALUES ( 'sd', 'language', 'Sindhi','2014-10-30');
888
889
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
890
VALUES ( 'sd','snd');
793
891
794
INSERT INTO language_descriptions(subtag, type, lang, description)
892
INSERT INTO language_descriptions(subtag, type, lang, description)
795
VALUES( 'Arab', 'script','fr', 'Arabic');
893
VALUES ( 'sd', 'language', 'sd', 'سنڌي');
796
894
797
INSERT INTO language_descriptions(subtag, type, lang, description)
895
INSERT INTO language_descriptions(subtag, type, lang, description)
798
VALUES( 'Arab', 'script', 'de', 'Arabisch');
896
VALUES ( 'sd', 'language', 'en', 'Sindhi');
799
897
800
-- Cyrillic
898
-- Slovak
801
INSERT INTO language_subtag_registry( subtag, type, description, added)
899
INSERT INTO language_subtag_registry( subtag, type, description, added)
802
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
900
VALUES ( 'sk', 'language', 'Slovak','2014-10-30');
803
901
804
INSERT INTO language_descriptions(subtag, type, lang, description)
902
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
805
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
903
VALUES ( 'sk','slk');
806
904
807
INSERT INTO language_descriptions(subtag, type, lang, description)
905
INSERT INTO language_descriptions(subtag, type, lang, description)
808
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
906
VALUES ( 'sk', 'language', 'sk', 'Slovenčina');
809
907
810
INSERT INTO language_descriptions(subtag, type, lang, description)
908
INSERT INTO language_descriptions(subtag, type, lang, description)
811
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
909
VALUES ( 'sk', 'language', 'en', 'Slovak');
910
911
-- Slovene
912
INSERT INTO language_subtag_registry( subtag, type, description, added)
913
VALUES ( 'sl', 'language', 'Slovene','2014-10-30');
914
915
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
916
VALUES ( 'sl','slv');
812
917
813
INSERT INTO language_descriptions(subtag, type, lang, description)
918
INSERT INTO language_descriptions(subtag, type, lang, description)
814
VALUES( 'Cyrl', 'script', 'de', 'Kyrillisch');
919
VALUES ( 'sl', 'language', 'sl', 'Slovenščina');
815
920
921
INSERT INTO language_descriptions(subtag, type, lang, description)
922
VALUES ( 'sl', 'language', 'en', 'Slovene');
816
923
817
-- Greek
924
-- Albanian
818
INSERT INTO language_subtag_registry( subtag, type, description, added)
925
INSERT INTO language_subtag_registry( subtag, type, description, added)
819
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
926
VALUES ( 'sq', 'language', 'Albanian','2014-10-30');
927
928
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
929
VALUES ( 'sq','sqi');
820
930
821
INSERT INTO language_descriptions(subtag, type, lang, description)
931
INSERT INTO language_descriptions(subtag, type, lang, description)
822
VALUES ( 'Grek', 'script', 'Grek', '????');
932
VALUES ( 'sq', 'language', 'sq', 'Shqip');
823
933
824
INSERT INTO language_descriptions(subtag, type, lang, description)
934
INSERT INTO language_descriptions(subtag, type, lang, description)
825
VALUES( 'Grek', 'script', 'en', 'Greek');
935
VALUES ( 'sq', 'language', 'en', 'Albanian');
936
937
-- Serbian
938
INSERT INTO language_subtag_registry( subtag, type, description, added)
939
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
940
941
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
942
VALUES ( 'sr','srp');
826
943
827
INSERT INTO language_descriptions(subtag, type, lang, description)
944
INSERT INTO language_descriptions(subtag, type, lang, description)
828
VALUES( 'Grek', 'script', 'fr', 'Greek');
945
VALUES ( 'sr', 'language', 'sr', 'Cрпски');
829
946
830
INSERT INTO language_descriptions(subtag, type, lang, description)
947
INSERT INTO language_descriptions(subtag, type, lang, description)
831
VALUES( 'Grek', 'script', 'de', 'Griechisch');
948
VALUES ( 'sr', 'language', 'en', 'Serbian');
832
949
950
INSERT INTO language_descriptions(subtag, type, lang, description)
951
VALUES ( 'sr', 'language', 'fr', 'Serbe');
833
952
834
-- Han - Simplified
953
INSERT INTO language_descriptions(subtag, type, lang, description)
954
VALUES ( 'sr', 'language', 'de', 'Serbisch');
955
956
-- Swedish
835
INSERT INTO language_subtag_registry( subtag, type, description, added)
957
INSERT INTO language_subtag_registry( subtag, type, description, added)
836
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
958
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
837
959
838
INSERT INTO language_descriptions(subtag, type, lang, description)
960
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
839
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
961
VALUES ( 'sv','swe');
840
962
841
INSERT INTO language_descriptions(subtag, type, lang, description)
963
INSERT INTO language_descriptions(subtag, type, lang, description)
842
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
964
VALUES ( 'sv', 'language', 'sv', 'Svenska');
843
965
844
INSERT INTO language_descriptions(subtag, type, lang, description)
966
INSERT INTO language_descriptions(subtag, type, lang, description)
845
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
967
VALUES ( 'sv', 'language', 'en', 'Swedish');
846
968
847
INSERT INTO language_descriptions(subtag, type, lang, description)
969
INSERT INTO language_descriptions(subtag, type, lang, description)
848
VALUES( 'Hans', 'script', 'de', 'Han (Vereinfachte Variante)');
970
VALUES ( 'sv', 'language', 'fr', 'Suédois');
849
971
972
INSERT INTO language_descriptions(subtag, type, lang, description)
973
VALUES ( 'sv', 'language', 'de', 'Schwedisch');
850
974
851
-- Han - Traditional
975
-- Swahili
852
INSERT INTO language_subtag_registry( subtag, type, description, added)
976
INSERT INTO language_subtag_registry( subtag, type, description, added)
853
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
977
VALUES ( 'sw', 'language', 'Swahili','2014-10-30');
854
978
855
INSERT INTO language_descriptions(subtag, type, lang, description)
979
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
856
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
980
VALUES ( 'sw','swa');
857
981
858
INSERT INTO language_descriptions(subtag, type, lang, description)
982
INSERT INTO language_descriptions(subtag, type, lang, description)
859
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
983
VALUES ( 'sw', 'language', 'sw', 'Kiswahili');
860
984
861
INSERT INTO language_descriptions(subtag, type, lang, description)
985
INSERT INTO language_descriptions(subtag, type, lang, description)
862
VALUES( 'Hant', 'script', 'de', 'Han (Traditionelle Variante)');
986
VALUES ( 'sw', 'language', 'en', 'Swahili');
863
987
864
-- Hebrew
988
-- Tamil
865
INSERT INTO language_subtag_registry( subtag, type, description, added)
989
INSERT INTO language_subtag_registry( subtag, type, description, added)
866
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
990
VALUES ( 'ta', 'language', 'Tamil','2014-10-30');
867
991
868
INSERT INTO language_descriptions(subtag, type, lang, description)
992
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
869
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
993
VALUES ( 'ta','tam');
870
994
871
INSERT INTO language_descriptions(subtag, type, lang, description)
995
INSERT INTO language_descriptions(subtag, type, lang, description)
872
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
996
VALUES ( 'ta', 'language', 'ta', 'தமிழ்');
873
997
874
INSERT INTO language_descriptions(subtag, type, lang, description)
998
INSERT INTO language_descriptions(subtag, type, lang, description)
875
VALUES( 'Hebr', 'script', 'de', 'Hebräisch');
999
VALUES ( 'ta', 'language', 'en', 'Tamil');
876
1000
877
-- Lao
1001
-- Tetum
878
INSERT INTO language_subtag_registry( subtag, type, description, added)
1002
INSERT INTO language_subtag_registry( subtag, type, description, added)
879
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
1003
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
1004
1005
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1006
VALUES ( 'tet','tet');
880
1007
881
INSERT INTO language_descriptions(subtag, type, lang, description)
1008
INSERT INTO language_descriptions(subtag, type, lang, description)
882
VALUES ( 'Laoo', 'script', 'lo', 'Lao');
1009
VALUES ( 'tet', 'language', 'tet', 'Tetun');
883
1010
884
INSERT INTO language_descriptions(subtag, type, lang, description)
1011
INSERT INTO language_descriptions(subtag, type, lang, description)
885
VALUES( 'Laoo', 'script', 'en', 'Lao');
1012
VALUES ( 'tet', 'language', 'en', 'Tetum');
886
1013
887
INSERT INTO language_descriptions(subtag, type, lang, description)
1014
INSERT INTO language_descriptions(subtag, type, lang, description)
888
VALUES( 'Laoo', 'script', 'de', 'Laotisch');
1015
VALUES ( 'tet', 'language', 'fr', 'Tétoum');
889
1016
890
-- Croatian
1017
INSERT INTO language_descriptions(subtag, type, lang, description)
1018
VALUES ( 'tet', 'language', 'de', 'Tetum');
1019
1020
-- Thai
891
INSERT INTO language_subtag_registry( subtag, type, description, added)
1021
INSERT INTO language_subtag_registry( subtag, type, description, added)
892
VALUES ( 'hr', 'language', 'Croatian','2014-07-24' );
1022
VALUES ( 'th', 'language', 'Thai','2005-10-16');
893
1023
894
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1024
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
895
VALUES( 'hr','hrv');
1025
VALUES ( 'th','tha');
896
1026
897
INSERT INTO language_descriptions(subtag, type, lang, description)
1027
INSERT INTO language_descriptions(subtag, type, lang, description)
898
VALUES( 'hr', 'language', 'hr', 'Hrvatski');
1028
VALUES ( 'th', 'language', 'th', 'ภาษาไทย');
899
1029
900
INSERT INTO language_descriptions(subtag, type, lang, description)
1030
INSERT INTO language_descriptions(subtag, type, lang, description)
901
VALUES( 'hr', 'language', 'en', 'Croatian');
1031
VALUES ( 'th', 'language', 'en', 'Thai');
902
1032
903
INSERT INTO language_descriptions(subtag, type, lang, description)
1033
INSERT INTO language_descriptions(subtag, type, lang, description)
904
VALUES( 'hr', 'language', 'fr', 'Croate');
1034
VALUES ( 'th', 'language', 'fr', 'Thaï');
905
1035
906
INSERT INTO language_descriptions(subtag, type, lang, description)
1036
INSERT INTO language_descriptions(subtag, type, lang, description)
907
VALUES( 'hr', 'language', 'de', 'Kroatisch');
1037
VALUES ( 'th', 'language', 'de', 'Thailändisch');
908
909
1038
910
-- REGIONS
1039
-- Tagalog
911
-- Canada
912
INSERT INTO language_subtag_registry( subtag, type, description, added)
1040
INSERT INTO language_subtag_registry( subtag, type, description, added)
913
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
1041
VALUES ( 'tl', 'language', 'Tagalog','2014-10-30');
1042
1043
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1044
VALUES ( 'tl','tgl');
914
1045
915
INSERT INTO language_descriptions(subtag, type, lang, description)
1046
INSERT INTO language_descriptions(subtag, type, lang, description)
916
VALUES( 'CA', 'region', 'en', 'Canada');
1047
VALUES ( 'tl', 'language', 'tl', 'Tagalog');
1048
1049
INSERT INTO language_descriptions(subtag, type, lang, description)
1050
VALUES ( 'tl', 'language', 'en', 'Tagalog');
1051
1052
-- Turkish
1053
INSERT INTO language_subtag_registry( subtag, type, description, added)
1054
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
1055
1056
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1057
VALUES ( 'tr','tur');
1058
1059
INSERT INTO language_descriptions(subtag, type, lang, description)
1060
VALUES ( 'tr', 'language', 'tr', 'Türkçe');
1061
1062
INSERT INTO language_descriptions(subtag, type, lang, description)
1063
VALUES ( 'tr', 'language', 'en', 'Turkish');
1064
1065
INSERT INTO language_descriptions(subtag, type, lang, description)
1066
VALUES ( 'tr', 'language', 'fr', 'Turc');
1067
1068
INSERT INTO language_descriptions(subtag, type, lang, description)
1069
VALUES ( 'tr', 'language', 'de', 'Türkisch');
1070
1071
-- Ukranian
1072
INSERT INTO language_subtag_registry( subtag, type, description, added)
1073
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
1074
1075
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1076
VALUES ( 'uk','ukr');
1077
1078
INSERT INTO language_descriptions(subtag, type, lang, description)
1079
VALUES ( 'uk', 'language', 'uk', 'Українська');
1080
1081
INSERT INTO language_descriptions(subtag, type, lang, description)
1082
VALUES ( 'uk', 'language', 'en', 'Ukranian');
1083
1084
INSERT INTO language_descriptions(subtag, type, lang, description)
1085
VALUES ( 'uk', 'language', 'fr', 'Ukrainien');
1086
1087
INSERT INTO language_descriptions(subtag, type, lang, description)
1088
VALUES ( 'uk', 'language', 'de', 'Ukrainisch');
1089
1090
-- Urdu
1091
INSERT INTO language_subtag_registry( subtag, type, description, added)
1092
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
1093
1094
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1095
VALUES ( 'ur','urd');
1096
1097
INSERT INTO language_descriptions(subtag, type, lang, description)
1098
VALUES ( 'ur', 'language', 'en', 'Urdu');
1099
1100
INSERT INTO language_descriptions(subtag, type, lang, description)
1101
VALUES ( 'ur', 'language', 'ur', 'اردو');
1102
1103
INSERT INTO language_descriptions(subtag, type, lang, description)
1104
VALUES ( 'ur', 'language', 'fr', 'Ourdou');
1105
1106
INSERT INTO language_descriptions(subtag, type, lang, description)
1107
VALUES ( 'ur', 'language', 'de', 'Urdu');
1108
1109
-- Vietnamese
1110
INSERT INTO language_subtag_registry( subtag, type, description, added)
1111
VALUES ( 'vi', 'language', 'Vietnamese','2014-10-30');
1112
1113
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1114
VALUES ( 'vi','vie');
1115
1116
INSERT INTO language_descriptions(subtag, type, lang, description)
1117
VALUES ( 'vi', 'language', 'vi', '㗂越');
1118
1119
INSERT INTO language_descriptions(subtag, type, lang, description)
1120
VALUES ( 'vi', 'language', 'en', 'Vietnamese');
1121
1122
-- Chinese
1123
INSERT INTO language_subtag_registry( subtag, type, description, added)
1124
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
1125
1126
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1127
VALUES ( 'zh','chi');
1128
1129
INSERT INTO language_descriptions(subtag, type, lang, description)
1130
VALUES ( 'zh', 'language', 'zh', '中文');
1131
1132
INSERT INTO language_descriptions(subtag, type, lang, description)
1133
VALUES ( 'zh', 'language', 'en', 'Chinese');
1134
1135
INSERT INTO language_descriptions(subtag, type, lang, description)
1136
VALUES ( 'zh', 'language', 'fr', 'Chinois');
1137
1138
INSERT INTO language_descriptions(subtag, type, lang, description)
1139
VALUES ( 'zh', 'language', 'de', 'Chinesisch');
1140
1141
-- SCRIPTS
1142
-- Arabic
1143
INSERT INTO language_subtag_registry( subtag, type, description, added)
1144
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
1145
1146
INSERT INTO language_descriptions(subtag, type, lang, description)
1147
VALUES ( 'Arab','script', 'Arab', 'العربية');
1148
1149
INSERT INTO language_descriptions(subtag, type, lang, description)
1150
VALUES ( 'Arab', 'script','en', 'Arabic');
1151
1152
INSERT INTO language_descriptions(subtag, type, lang, description)
1153
VALUES ( 'Arab', 'script','fr', 'Arabic');
1154
1155
INSERT INTO language_descriptions(subtag, type, lang, description)
1156
VALUES ( 'Arab', 'script', 'de', 'Arabisch');
1157
1158
-- Armenian
1159
INSERT INTO language_subtag_registry( subtag, type, description, added)
1160
VALUES ( 'Armn', 'script', 'Armenian','2014-10-30');
1161
1162
INSERT INTO language_descriptions(subtag, type, lang, description)
1163
VALUES ( 'Armn', 'script', 'Armn', 'Հայոց այբուբեն');
1164
1165
INSERT INTO language_descriptions(subtag, type, lang, description)
1166
VALUES( 'Armn', 'script', 'en', 'Armenian');
1167
1168
-- Cyrillic
1169
INSERT INTO language_subtag_registry( subtag, type, description, added)
1170
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
1171
1172
INSERT INTO language_descriptions(subtag, type, lang, description)
1173
VALUES ( 'Cyrl', 'script', 'Cyrl', 'Кирилица');
1174
1175
INSERT INTO language_descriptions(subtag, type, lang, description)
1176
VALUES ( 'Cyrl', 'script', 'en', 'Cyrillic');
1177
1178
INSERT INTO language_descriptions(subtag, type, lang, description)
1179
VALUES ( 'Cyrl', 'script', 'fr', 'Cyrillic');
1180
1181
INSERT INTO language_descriptions(subtag, type, lang, description)
1182
VALUES ( 'Cyrl', 'script', 'de', 'Kyrillisch');
1183
1184
-- Ethiopic
1185
INSERT INTO language_subtag_registry( subtag, type, description, added)
1186
VALUES ( 'Ethi', 'script', 'Ethiopic','2014-10-30');
1187
1188
INSERT INTO language_descriptions(subtag, type, lang, description)
1189
VALUES ( 'Ethi', 'script', 'Ethi', 'ግዕዝ');
1190
1191
INSERT INTO language_descriptions(subtag, type, lang, description)
1192
VALUES( 'Ethi', 'script', 'en', 'Ethiopic');
1193
1194
-- Greek
1195
INSERT INTO language_subtag_registry( subtag, type, description, added)
1196
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
1197
1198
INSERT INTO language_descriptions(subtag, type, lang, description)
1199
VALUES ( 'Grek', 'script', 'Grek', 'Ελληνικό αλφάβητο');
1200
1201
INSERT INTO language_descriptions(subtag, type, lang, description)
1202
VALUES ( 'Grek', 'script', 'en', 'Greek');
1203
1204
INSERT INTO language_descriptions(subtag, type, lang, description)
1205
VALUES ( 'Grek', 'script', 'fr', 'Greek');
1206
1207
INSERT INTO language_descriptions(subtag, type, lang, description)
1208
VALUES ( 'Grek', 'script', 'de', 'Griechisch');
1209
1210
1211
-- Han - Simplified
1212
INSERT INTO language_subtag_registry( subtag, type, description, added)
1213
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
1214
1215
INSERT INTO language_descriptions(subtag, type, lang, description)
1216
VALUES ( 'Hans', 'script', 'Hans', '简体字');
1217
1218
INSERT INTO language_descriptions(subtag, type, lang, description)
1219
VALUES ( 'Hans', 'script', 'en', 'Han (Simplified variant)');
1220
1221
INSERT INTO language_descriptions(subtag, type, lang, description)
1222
VALUES ( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
1223
1224
INSERT INTO language_descriptions(subtag, type, lang, description)
1225
VALUES ( 'Hans', 'script', 'de', 'Han (Vereinfachte Variante)');
1226
1227
1228
-- Han - Traditional
1229
INSERT INTO language_subtag_registry( subtag, type, description, added)
1230
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
1231
1232
INSERT INTO language_descriptions(subtag, type, lang, description)
1233
VALUES ( 'Hant', 'script', 'Hant', '繁體字');
1234
1235
INSERT INTO language_descriptions(subtag, type, lang, description)
1236
VALUES ( 'Hant', 'script', 'en', 'Han (Traditional variant)');
1237
1238
INSERT INTO language_descriptions(subtag, type, lang, description)
1239
VALUES ( 'Hant', 'script', 'de', 'Han (Traditionelle Variante)');
1240
1241
-- Hebrew
1242
INSERT INTO language_subtag_registry( subtag, type, description, added)
1243
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
1244
1245
INSERT INTO language_descriptions(subtag, type, lang, description)
1246
VALUES ( 'Hebr', 'script', 'Hebr', 'אָלֶף־בֵּית עִבְרִי');
1247
1248
INSERT INTO language_descriptions(subtag, type, lang, description)
1249
VALUES ( 'Hebr', 'script', 'en', 'Hebrew');
1250
1251
INSERT INTO language_descriptions(subtag, type, lang, description)
1252
VALUES ( 'Hebr', 'script', 'de', 'Hebräisch');
1253
1254
-- Japanese
1255
INSERT INTO language_subtag_registry( subtag, type, description, added)
1256
VALUES ( 'Jpan', 'script', 'Japanese','2014-10-30');
1257
1258
INSERT INTO language_descriptions(subtag, type, lang, description)
1259
VALUES ( 'Jpan', 'script', 'Jpan', '漢字');
1260
1261
INSERT INTO language_descriptions(subtag, type, lang, description)
1262
VALUES( 'Jpan', 'script', 'en', 'Japanese');
1263
1264
-- Kannada
1265
INSERT INTO language_subtag_registry( subtag, type, description, added)
1266
VALUES ( 'Knda', 'script', 'Kannada','2014-10-30');
1267
1268
INSERT INTO language_descriptions(subtag, type, lang, description)
1269
VALUES ( 'Knda', 'script', 'Knda', 'ಕನ್ನಡ ಲಿಪಿ');
1270
1271
INSERT INTO language_descriptions(subtag, type, lang, description)
1272
VALUES( 'Knda', 'script', 'en', 'Kannada');
1273
1274
-- Korean
1275
INSERT INTO language_subtag_registry( subtag, type, description, added)
1276
VALUES ( 'Kore', 'script', 'Korean','2014-10-30');
1277
1278
INSERT INTO language_descriptions(subtag, type, lang, description)
1279
VALUES ( 'Kore', 'script', 'Kore', '한글');
1280
1281
INSERT INTO language_descriptions(subtag, type, lang, description)
1282
VALUES( 'Kore', 'script', 'en', 'Korean');
1283
1284
-- Lao
1285
INSERT INTO language_subtag_registry( subtag, type, description, added)
1286
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
1287
1288
INSERT INTO language_descriptions(subtag, type, lang, description)
1289
VALUES ( 'Laoo', 'script', 'Laoo', 'ອັກສອນລາວ');
1290
1291
INSERT INTO language_descriptions(subtag, type, lang, description)
1292
VALUES ( 'Laoo', 'script', 'en', 'Lao');
1293
1294
INSERT INTO language_descriptions(subtag, type, lang, description)
1295
VALUES ( 'Laoo', 'script', 'de', 'Laotisch');
1296
1297
1298
-- REGIONS - Order by country code
1299
-- Albania
1300
INSERT INTO language_subtag_registry( subtag, type, description, added)
1301
VALUES ( 'AL', 'region', 'Albania','2014-10-30');
1302
1303
INSERT INTO language_descriptions(subtag, type, lang, description)
1304
VALUES ( 'AL', 'region', 'en', 'Albania');
1305
1306
INSERT INTO language_descriptions(subtag, type, lang, description)
1307
VALUES ( 'AL', 'region', 'sq', 'Shqipërisë');
1308
1309
-- Azerbaijan
1310
INSERT INTO language_subtag_registry( subtag, type, description, added)
1311
VALUES ( 'AZ', 'region', 'Azerbaijan','2014-10-30');
1312
1313
INSERT INTO language_descriptions(subtag, type, lang, description)
1314
VALUES ( 'AZ', 'region', 'en', 'Azerbaijan');
1315
1316
INSERT INTO language_descriptions(subtag, type, lang, description)
1317
VALUES ( 'AZ', 'region', 'az', 'Azərbaycan');
1318
1319
-- Belgium
1320
INSERT INTO language_subtag_registry( subtag, type, description, added)
1321
VALUES ( 'BE', 'region', 'Belgium','2014-10-30');
1322
1323
INSERT INTO language_descriptions(subtag, type, lang, description)
1324
VALUES ( 'BE', 'region', 'en', 'Belgium');
1325
1326
INSERT INTO language_descriptions(subtag, type, lang, description)
1327
VALUES ( 'BE', 'region', 'nl', 'België');
1328
1329
-- Brazil
1330
INSERT INTO language_subtag_registry( subtag, type, description, added)
1331
VALUES ( 'BR', 'region', 'Brazil','2014-10-30');
1332
1333
INSERT INTO language_descriptions(subtag, type, lang, description)
1334
VALUES ( 'BR', 'region', 'en', 'Brazil');
1335
1336
INSERT INTO language_descriptions(subtag, type, lang, description)
1337
VALUES ( 'BR', 'region', 'pt', 'Brasil');
1338
1339
-- Belarus
1340
INSERT INTO language_subtag_registry( subtag, type, description, added)
1341
VALUES ( 'BY', 'region', 'Belarus','2014-10-30');
1342
1343
INSERT INTO language_descriptions(subtag, type, lang, description)
1344
VALUES ( 'BY', 'region', 'en', 'Belarus');
1345
1346
INSERT INTO language_descriptions(subtag, type, lang, description)
1347
VALUES ( 'BY', 'region', 'be', 'Беларусь');
1348
1349
-- Canada
1350
INSERT INTO language_subtag_registry( subtag, type, description, added)
1351
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
1352
1353
INSERT INTO language_descriptions(subtag, type, lang, description)
1354
VALUES ( 'CA', 'region', 'en', 'Canada');
1355
1356
INSERT INTO language_descriptions(subtag, type, lang, description)
1357
VALUES ( 'CA', 'region', 'fr', 'Canada');
1358
1359
-- Switzerland
1360
INSERT INTO language_subtag_registry( subtag, type, description, added)
1361
VALUES ( 'CH', 'region', 'Switzerland','2014-10-30');
1362
1363
INSERT INTO language_descriptions(subtag, type, lang, description)
1364
VALUES ( 'CH', 'region', 'en', 'Switzerland');
1365
1366
INSERT INTO language_descriptions(subtag, type, lang, description)
1367
VALUES ( 'CH', 'region', 'de', 'Schweiz');
1368
1369
-- China
1370
INSERT INTO language_subtag_registry( subtag, type, description, added)
1371
VALUES ( 'CN', 'region', 'China','2014-10-30');
1372
1373
INSERT INTO language_descriptions(subtag, type, lang, description)
1374
VALUES ( 'CN', 'region', 'en', 'China');
1375
1376
INSERT INTO language_descriptions(subtag, type, lang, description)
1377
VALUES ( 'CN', 'region', 'zh', '中国');
1378
1379
-- Czech Republic
1380
INSERT INTO language_subtag_registry( subtag, type, description, added)
1381
VALUES ( 'CZ', 'region', 'Czech Republic','2014-10-30');
1382
1383
INSERT INTO language_descriptions(subtag, type, lang, description)
1384
VALUES ( 'CZ', 'region', 'en', 'Czech Republic');
1385
1386
INSERT INTO language_descriptions(subtag, type, lang, description)
1387
VALUES ( 'CZ', 'region', 'cs', 'Česká republika');
1388
1389
-- Germany
1390
INSERT INTO language_subtag_registry( subtag, type, description, added)
1391
VALUES ( 'DE', 'region', 'Germany','2014-10-30');
1392
1393
INSERT INTO language_descriptions(subtag, type, lang, description)
1394
VALUES ( 'DE', 'region', 'en', 'Germany');
1395
1396
INSERT INTO language_descriptions(subtag, type, lang, description)
1397
VALUES ( 'DE', 'region', 'de', 'Deutschland');
917
1398
918
-- Denmark
1399
-- Denmark
919
INSERT INTO language_subtag_registry( subtag, type, description, added)
1400
INSERT INTO language_subtag_registry( subtag, type, description, added)
920
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
1401
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
921
1402
922
INSERT INTO language_descriptions(subtag, type, lang, description)
1403
INSERT INTO language_descriptions(subtag, type, lang, description)
923
VALUES( 'DK', 'region', 'dk', 'Danmark');
1404
VALUES ( 'DK', 'region', 'en', 'Denmark');
1405
1406
INSERT INTO language_descriptions(subtag, type, lang, description)
1407
VALUES ( 'DK', 'region', 'dk', 'Danmark');
1408
1409
-- Spain
1410
INSERT INTO language_subtag_registry( subtag, type, description, added)
1411
VALUES ( 'ES', 'region', 'Spain','2014-10-30');
1412
1413
INSERT INTO language_descriptions(subtag, type, lang, description)
1414
VALUES ( 'ES', 'region', 'en', 'Spain');
1415
1416
INSERT INTO language_descriptions(subtag, type, lang, description)
1417
VALUES ( 'ES', 'region', 'es', 'España');
1418
1419
-- Finland
1420
INSERT INTO language_subtag_registry( subtag, type, description, added)
1421
VALUES ( 'FI', 'region', 'Finland','2014-10-30');
1422
1423
INSERT INTO language_descriptions(subtag, type, lang, description)
1424
VALUES ( 'FI', 'region', 'en', 'Finland');
1425
1426
INSERT INTO language_descriptions(subtag, type, lang, description)
1427
VALUES ( 'FI', 'region', 'fi', 'Suomi');
1428
1429
-- Faroe Islands
1430
INSERT INTO language_subtag_registry( subtag, type, description, added)
1431
VALUES ( 'FO', 'region', 'Faroe Islands','2014-10-30');
1432
1433
INSERT INTO language_descriptions(subtag, type, lang, description)
1434
VALUES ( 'FO', 'region', 'en', 'Faroe Islands');
1435
1436
INSERT INTO language_descriptions(subtag, type, lang, description)
1437
VALUES ( 'FO', 'region', 'fo', 'Føroyar');
924
1438
925
-- France
1439
-- France
926
INSERT INTO language_subtag_registry( subtag, type, description, added)
1440
INSERT INTO language_subtag_registry( subtag, type, description, added)
927
VALUES ( 'FR', 'region', 'France','2005-10-16');
1441
VALUES ( 'FR', 'region', 'France','2005-10-16');
928
1442
929
INSERT INTO language_descriptions(subtag, type, lang, description)
1443
INSERT INTO language_descriptions(subtag, type, lang, description)
1444
VALUES ( 'FR', 'region', 'en', 'France');
1445
1446
INSERT INTO language_descriptions(subtag, type, lang, description)
930
VALUES ( 'FR', 'region', 'fr', 'France');
1447
VALUES ( 'FR', 'region', 'fr', 'France');
931
1448
1449
-- United Kingdom
1450
INSERT INTO language_subtag_registry( subtag, type, description, added)
1451
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
1452
1453
INSERT INTO language_descriptions(subtag, type, lang, description)
1454
VALUES ( 'GB', 'region', 'en', 'United Kingdom');
1455
1456
-- Greece
1457
INSERT INTO language_subtag_registry( subtag, type, description, added)
1458
VALUES ( 'GR', 'region', 'Greece','2014-10-30');
1459
1460
INSERT INTO language_descriptions(subtag, type, lang, description)
1461
VALUES ( 'GR', 'region', 'en', 'Greece');
1462
1463
INSERT INTO language_descriptions(subtag, type, lang, description)
1464
VALUES ( 'GR', 'region', 'el', 'Ελλάδα');
1465
1466
-- Croatia
1467
INSERT INTO language_subtag_registry( subtag, type, description, added)
1468
VALUES ( 'HR', 'region', 'Croatia','2014-10-30');
1469
1470
INSERT INTO language_descriptions(subtag, type, lang, description)
1471
VALUES ( 'HR', 'region', 'en', 'Croatia');
1472
1473
INSERT INTO language_descriptions(subtag, type, lang, description)
1474
VALUES ( 'HR', 'region', 'hr', 'Hrvatska');
1475
1476
-- Hungary
1477
INSERT INTO language_subtag_registry( subtag, type, description, added)
1478
VALUES ( 'HU', 'region', 'Hungary','2014-10-30');
1479
1480
INSERT INTO language_descriptions(subtag, type, lang, description)
1481
VALUES ( 'HU', 'region', 'en', 'Hungary');
1482
1483
INSERT INTO language_descriptions(subtag, type, lang, description)
1484
VALUES ( 'HU', 'region', 'hu', 'Magyarország');
1485
1486
-- Indonesia
1487
INSERT INTO language_subtag_registry( subtag, type, description, added)
1488
VALUES ( 'ID', 'region', 'Indonesia','2014-10-30');
1489
1490
INSERT INTO language_descriptions(subtag, type, lang, description)
1491
VALUES ( 'ID', 'region', 'en', 'Indonesia');
1492
1493
INSERT INTO language_descriptions(subtag, type, lang, description)
1494
VALUES ( 'ID', 'region', 'id', 'Indonesia');
1495
1496
-- Iceland
1497
INSERT INTO language_subtag_registry( subtag, type, description, added)
1498
VALUES ( 'IS', 'region', 'Iceland','2014-10-30');
1499
1500
INSERT INTO language_descriptions(subtag, type, lang, description)
1501
VALUES ( 'IS', 'region', 'en', 'Iceland');
1502
1503
INSERT INTO language_descriptions(subtag, type, lang, description)
1504
VALUES ( 'IS', 'region', 'is', 'Ísland');
1505
1506
-- Italy
1507
INSERT INTO language_subtag_registry( subtag, type, description, added)
1508
VALUES ( 'IT', 'region', 'Italy','2014-10-30');
1509
1510
INSERT INTO language_descriptions(subtag, type, lang, description)
1511
VALUES ( 'IT', 'region', 'en', 'Italy');
1512
1513
INSERT INTO language_descriptions(subtag, type, lang, description)
1514
VALUES ( 'IT', 'region', 'it', 'Italia');
1515
1516
-- Japan
1517
INSERT INTO language_subtag_registry( subtag, type, description, added)
1518
VALUES ( 'JP', 'region', 'Japan','2014-10-30');
1519
1520
INSERT INTO language_descriptions(subtag, type, lang, description)
1521
VALUES ( 'JP', 'region', 'en', 'Japan');
1522
1523
INSERT INTO language_descriptions(subtag, type, lang, description)
1524
VALUES ( 'JP', 'region', 'ja', '日本');
1525
1526
-- Kenya
1527
INSERT INTO language_subtag_registry( subtag, type, description, added)
1528
VALUES ( 'KE', 'region', 'Kenya','2014-10-30');
1529
1530
INSERT INTO language_descriptions(subtag, type, lang, description)
1531
VALUES ( 'KE', 'region', 'en', 'Kenya');
1532
1533
INSERT INTO language_descriptions(subtag, type, lang, description)
1534
VALUES ( 'KE', 'region', 'rw', 'Kenya');
1535
1536
-- Cambodia
1537
INSERT INTO language_subtag_registry( subtag, type, description, added)
1538
VALUES ( 'KH', 'region', 'Cambodia','2014-10-30');
1539
1540
INSERT INTO language_descriptions(subtag, type, lang, description)
1541
VALUES ( 'KH', 'region', 'en', 'Cambodia');
1542
1543
INSERT INTO language_descriptions(subtag, type, lang, description)
1544
VALUES ( 'KH', 'region', 'km', 'កម្ពុជា');
1545
1546
-- North Korea
1547
INSERT INTO language_subtag_registry( subtag, type, description, added)
1548
VALUES ( 'KP', 'region', 'North Korea','2014-10-30');
1549
1550
INSERT INTO language_descriptions(subtag, type, lang, description)
1551
VALUES ( 'KP', 'region', 'en', 'North Korea');
1552
1553
INSERT INTO language_descriptions(subtag, type, lang, description)
1554
VALUES ( 'KP', 'region', 'ko', '조선민주주의인민공화국');
1555
1556
-- Sri Lanka
1557
INSERT INTO language_subtag_registry( subtag, type, description, added)
1558
VALUES ( 'LK', 'region', 'Sri Lanka','2014-10-30');
1559
1560
INSERT INTO language_descriptions(subtag, type, lang, description)
1561
VALUES ( 'LK', 'region', 'en', 'Sri Lanka');
1562
1563
INSERT INTO language_descriptions(subtag, type, lang, description)
1564
VALUES ( 'LK', 'region', 'ta', 'இலங்கை');
1565
1566
-- Malaysia
1567
INSERT INTO language_subtag_registry( subtag, type, description, added)
1568
VALUES ( 'MY', 'region', 'Malaysia','2014-10-30');
1569
1570
INSERT INTO language_descriptions(subtag, type, lang, description)
1571
VALUES ( 'MY', 'region', 'en', 'Malaysia');
1572
1573
INSERT INTO language_descriptions(subtag, type, lang, description)
1574
VALUES ( 'MY', 'region', 'ms', 'Malaysia');
1575
1576
-- Niger
1577
INSERT INTO language_subtag_registry( subtag, type, description, added)
1578
VALUES ( 'NE', 'region', 'Niger','2014-10-30');
1579
1580
INSERT INTO language_descriptions(subtag, type, lang, description)
1581
VALUES ( 'NE', 'region', 'en', 'Niger');
1582
1583
INSERT INTO language_descriptions(subtag, type, lang, description)
1584
VALUES ( 'NE', 'region', 'ne', 'Niger');
1585
1586
-- Netherlands
1587
INSERT INTO language_subtag_registry( subtag, type, description, added)
1588
VALUES ( 'NL', 'region', 'Netherlands','2014-10-30');
1589
932
INSERT INTO language_descriptions(subtag, type, lang, description)
1590
INSERT INTO language_descriptions(subtag, type, lang, description)
933
VALUES( 'FR', 'region', 'en', 'France');
1591
VALUES ( 'NL', 'region', 'en', 'Netherlands');
1592
1593
INSERT INTO language_descriptions(subtag, type, lang, description)
1594
VALUES ( 'NL', 'region', 'nl', 'Nederland');
1595
1596
-- Norway
1597
INSERT INTO language_subtag_registry( subtag, type, description, added)
1598
VALUES ( 'NO', 'region', 'Norway','2014-10-30');
1599
1600
INSERT INTO language_descriptions(subtag, type, lang, description)
1601
VALUES ( 'NO', 'region', 'en', 'Norway');
1602
1603
INSERT INTO language_descriptions(subtag, type, lang, description)
1604
VALUES ( 'NO', 'region', 'ne', 'Noreg');
1605
1606
INSERT INTO language_descriptions(subtag, type, lang, description)
1607
VALUES ( 'NO', 'region', 'nn', 'Noreg');
934
1608
935
-- New Zealand
1609
-- New Zealand
936
INSERT INTO language_subtag_registry( subtag, type, description, added)
1610
INSERT INTO language_subtag_registry( subtag, type, description, added)
937
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
1611
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
938
1612
939
INSERT INTO language_descriptions(subtag, type, lang, description)
1613
INSERT INTO language_descriptions(subtag, type, lang, description)
940
VALUES( 'NZ', 'region', 'en', 'New Zealand');
1614
VALUES ( 'NZ', 'region', 'en', 'New Zealand');
941
1615
942
-- United Kingdom
1616
-- Philippines
943
INSERT INTO language_subtag_registry( subtag, type, description, added)
1617
INSERT INTO language_subtag_registry( subtag, type, description, added)
944
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
1618
VALUES ( 'PH', 'region', 'Philippines','2014-10-30');
1619
1620
INSERT INTO language_descriptions(subtag, type, lang, description)
1621
VALUES ( 'PH', 'region', 'en', 'Philippines');
1622
1623
INSERT INTO language_descriptions(subtag, type, lang, description)
1624
VALUES ( 'PH', 'region', 'tl', 'Pilipinas');
1625
1626
-- Pakistan
1627
INSERT INTO language_subtag_registry( subtag, type, description, added)
1628
VALUES ( 'PK', 'region', 'Pakistan','2014-10-30');
1629
1630
INSERT INTO language_descriptions(subtag, type, lang, description)
1631
VALUES ( 'PK', 'region', 'en', 'Pakistan');
1632
1633
INSERT INTO language_descriptions(subtag, type, lang, description)
1634
VALUES ( 'PK', 'region', 'sd', 'پاكستان');
1635
1636
-- Poland
1637
INSERT INTO language_subtag_registry( subtag, type, description, added)
1638
VALUES ( 'PL', 'region', 'Poland','2014-10-30');
1639
1640
INSERT INTO language_descriptions(subtag, type, lang, description)
1641
VALUES ( 'PL', 'region', 'en', 'Poland');
1642
1643
INSERT INTO language_descriptions(subtag, type, lang, description)
1644
VALUES ( 'PL', 'region', 'pl', 'Polska');
1645
1646
-- Portugal
1647
INSERT INTO language_subtag_registry( subtag, type, description, added)
1648
VALUES ( 'PT', 'region', 'Portugal','2014-10-30');
1649
1650
INSERT INTO language_descriptions(subtag, type, lang, description)
1651
VALUES ( 'PT', 'region', 'en', 'Portugal');
1652
1653
INSERT INTO language_descriptions(subtag, type, lang, description)
1654
VALUES ( 'PT', 'region', 'pt', 'Portugal');
1655
1656
-- Romania
1657
INSERT INTO language_subtag_registry( subtag, type, description, added)
1658
VALUES ( 'RO', 'region', 'Romania','2014-10-30');
1659
1660
INSERT INTO language_descriptions(subtag, type, lang, description)
1661
VALUES ( 'RO', 'region', 'en', 'Romania');
1662
1663
INSERT INTO language_descriptions(subtag, type, lang, description)
1664
VALUES ( 'RO', 'region', 'ro', 'România');
1665
1666
-- Russia
1667
INSERT INTO language_subtag_registry( subtag, type, description, added)
1668
VALUES ( 'RU', 'region', 'Russia','2014-10-30');
945
1669
946
INSERT INTO language_descriptions(subtag, type, lang, description)
1670
INSERT INTO language_descriptions(subtag, type, lang, description)
947
VALUES( 'GB', 'region', 'en', 'United Kingdom');
1671
VALUES ( 'RU', 'region', 'en', 'Russia');
1672
1673
INSERT INTO language_descriptions(subtag, type, lang, description)
1674
VALUES ( 'RU', 'region', 'ru', 'Россия');
1675
1676
-- Rwanda
1677
INSERT INTO language_subtag_registry( subtag, type, description, added)
1678
VALUES ( 'RW', 'region', 'Rwanda','2014-10-30');
1679
1680
INSERT INTO language_descriptions(subtag, type, lang, description)
1681
VALUES ( 'RW', 'region', 'en', 'Rwanda');
1682
1683
INSERT INTO language_descriptions(subtag, type, lang, description)
1684
VALUES ( 'RW', 'region', 'rw', 'Rwanda');
1685
1686
-- Sweden
1687
INSERT INTO language_subtag_registry( subtag, type, description, added)
1688
VALUES ( 'SE', 'region', 'Sweden','2014-10-30');
1689
1690
INSERT INTO language_descriptions(subtag, type, lang, description)
1691
VALUES ( 'SE', 'region', 'en', 'Sweden');
1692
1693
INSERT INTO language_descriptions(subtag, type, lang, description)
1694
VALUES ( 'SE', 'region', 'sv', 'Sverige');
1695
1696
-- Slovenia
1697
INSERT INTO language_subtag_registry( subtag, type, description, added)
1698
VALUES ( 'SI', 'region', 'Slovenia','2014-10-30');
1699
1700
INSERT INTO language_descriptions(subtag, type, lang, description)
1701
VALUES ( 'SI', 'region', 'en', 'Slovenia');
1702
1703
INSERT INTO language_descriptions(subtag, type, lang, description)
1704
VALUES ( 'SI', 'region', 'sl', 'Slovenija');
1705
1706
-- Slovakia
1707
INSERT INTO language_subtag_registry( subtag, type, description, added)
1708
VALUES ( 'SK', 'region', 'Slovakia','2014-10-30');
1709
1710
INSERT INTO language_descriptions(subtag, type, lang, description)
1711
VALUES ( 'SK', 'region', 'en', 'Slovakia');
1712
1713
INSERT INTO language_descriptions(subtag, type, lang, description)
1714
VALUES ( 'SK', 'region', 'sk', 'Slovensko');
1715
1716
-- Thailand
1717
INSERT INTO language_subtag_registry( subtag, type, description, added)
1718
VALUES ( 'TH', 'region', 'Thailand','2014-10-30');
1719
1720
INSERT INTO language_descriptions(subtag, type, lang, description)
1721
VALUES ( 'TH', 'region', 'en', 'Thailand');
1722
1723
INSERT INTO language_descriptions(subtag, type, lang, description)
1724
VALUES ( 'TH', 'region', 'th', 'ประเทศไทย');
1725
1726
-- Turkey
1727
INSERT INTO language_subtag_registry( subtag, type, description, added)
1728
VALUES ( 'TR', 'region', 'Turkey','2014-10-30');
1729
1730
INSERT INTO language_descriptions(subtag, type, lang, description)
1731
VALUES ( 'TR', 'region', 'en', 'Turkey');
1732
1733
INSERT INTO language_descriptions(subtag, type, lang, description)
1734
VALUES ( 'TR', 'region', 'tr', 'Türkiye');
1735
1736
-- Taiwan
1737
INSERT INTO language_subtag_registry( subtag, type, description, added)
1738
VALUES ( 'TW', 'region', 'Taiwan','2014-10-30');
1739
1740
INSERT INTO language_descriptions(subtag, type, lang, description)
1741
VALUES ( 'TW', 'region', 'en', 'Taiwan');
1742
1743
INSERT INTO language_descriptions(subtag, type, lang, description)
1744
VALUES ( 'TW', 'region', 'zh', '台灣');
1745
1746
-- Ukraine
1747
INSERT INTO language_subtag_registry( subtag, type, description, added)
1748
VALUES ( 'UA', 'region', 'Ukraine','2014-10-30');
1749
1750
INSERT INTO language_descriptions(subtag, type, lang, description)
1751
VALUES ( 'UA', 'region', 'en', 'Ukraine');
1752
1753
INSERT INTO language_descriptions(subtag, type, lang, description)
1754
VALUES ( 'UA', 'region', 'uk', 'Україна');
948
1755
949
-- United States
1756
-- United States
950
INSERT INTO language_subtag_registry( subtag, type, description, added)
1757
INSERT INTO language_subtag_registry( subtag, type, description, added)
951
VALUES ( 'US', 'region', 'United States','2005-10-16');
1758
VALUES ( 'US', 'region', 'United States','2005-10-16');
952
1759
953
INSERT INTO language_descriptions(subtag, type, lang, description)
1760
INSERT INTO language_descriptions(subtag, type, lang, description)
954
VALUES( 'US', 'region', 'en', 'United States');
1761
VALUES ( 'US', 'region', 'en', 'United States');
1762
1763
-- Vietnam
1764
INSERT INTO language_subtag_registry( subtag, type, description, added)
1765
VALUES ( 'VN', 'region', 'Vietnam','2014-10-30');
1766
1767
INSERT INTO language_descriptions(subtag, type, lang, description)
1768
VALUES ( 'VN', 'region', 'en', 'Vietnam');
1769
1770
INSERT INTO language_descriptions(subtag, type, lang, description)
1771
VALUES ( 'VN', 'region', 'vi', 'Việt Nam');
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +382 lines)
Lines 9005-9010 if ( CheckVersion($DBversion) ) { Link Here
9005
    SetVersion($DBversion);
9005
    SetVersion($DBversion);
9006
}
9006
}
9007
9007
9008
$DBversion = "3.17.00.XXX";
9009
if ( CheckVersion($DBversion) ) {
9010
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'am', 'language', 'Amharic','2014-10-29')");
9011
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'am','amh')");
9012
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'am', 'language', 'am', 'አማርኛ')");
9013
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'am', 'language', 'en', 'Amharic')");
9014
9015
    $dbh->do("UPDATE language_descriptions SET description = 'لعربية' WHERE subtag = 'ar' AND type = 'language' AND lang = 'ar'");
9016
9017
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'az', 'language', 'Azerbaijani','2014-10-30')");
9018
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'az','aze')");
9019
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'az', 'language', 'az', 'Azərbaycan dili')");
9020
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'az', 'language', 'en', 'Azerbaijani')");
9021
9022
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'be', 'language', 'Byelorussian','2014-10-30')");
9023
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'be','bel')");
9024
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'be', 'language', 'be', 'Беларуская мова')");
9025
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'be', 'language', 'en', 'Byelorussian')");
9026
9027
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'bn', 'language', 'Bengali','2014-10-30')");
9028
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'bn','ben')");
9029
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bn', 'language', 'bn', 'বাংলা')");
9030
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bn', 'language', 'en', 'Bengali')");
9031
9032
    $dbh->do("UPDATE language_descriptions SET description = 'Български' WHERE subtag = 'bg' AND type = 'language' AND lang = 'bg'");
9033
    $dbh->do("UPDATE language_descriptions SET description = 'Ceština' WHERE subtag = 'cs' AND type = 'language' AND lang = 'cs'");
9034
    $dbh->do("UPDATE language_descriptions SET description = 'Ελληνικά' WHERE subtag = 'el' AND type = 'language' AND lang = 'el'");
9035
    $dbh->do("UPDATE language_descriptions SET description = 'Español' WHERE subtag = 'es' AND type = 'language' AND lang = 'es'");
9036
9037
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'eu', 'language', 'Basque','2014-10-30')");
9038
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'eu','eus')");
9039
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eu', 'language', 'eu', 'Euskera')");
9040
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eu', 'language', 'en', 'Basque')");
9041
9042
    $dbh->do("UPDATE language_descriptions SET description = 'فارسى' WHERE subtag = 'fa' AND type = 'language' AND lang = 'fa'");
9043
    $dbh->do("UPDATE language_descriptions SET description = 'Suomi' WHERE subtag = 'fi' AND type = 'language' AND lang = 'fi'");
9044
9045
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'fo', 'language', 'Faroese','2014-10-30')");
9046
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'fo','fao')");
9047
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'fo', 'language', 'fo', 'Føroyskt')");
9048
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'fo', 'language', 'en', 'Faroese')");
9049
9050
    $dbh->do("UPDATE language_descriptions SET description = 'Français' WHERE subtag = 'fr' AND type = 'language' AND lang = 'fr'");
9051
    $dbh->do("UPDATE language_descriptions SET description = 'עִבְרִית' WHERE subtag = 'he' AND type = 'language' AND lang = 'he'");
9052
    $dbh->do("UPDATE language_descriptions SET description = 'हिन्दी' WHERE subtag = 'hi' AND type = 'language' AND lang = 'hi'");
9053
9054
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'is', 'language', 'Icelandic','2014-10-30')");
9055
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'is','ice')");
9056
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'is', 'language', 'is', 'Íslenska')");
9057
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'is', 'language', 'en', 'Icelandic')");
9058
9059
    $dbh->do("UPDATE language_descriptions SET description = '日本語' WHERE subtag = 'ja' AND type = 'language' AND lang = 'ja'");
9060
9061
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ka', 'language', 'Kannada','2014-10-30')");
9062
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ka','kan')");
9063
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'ka', 'ಕನ್ನಡ')");
9064
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'en', 'Kannada')");
9065
9066
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'km', 'language', 'Khmer','2014-10-30')");
9067
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'km','khm')");
9068
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'km', 'language', 'km', 'ភាសាខ្មែរ')");
9069
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'km', 'language', 'en', 'Khmer')");
9070
9071
    $dbh->do("UPDATE language_descriptions SET description = '한국어' WHERE subtag = 'ko' AND type = 'language' AND lang = 'ko'");
9072
9073
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ku', 'language', 'Kurdish','2014-05-13')");
9074
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ku','kur')");
9075
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ku', 'language', 'ku', 'کوردی')");
9076
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ku', 'language', 'en', 'Kurdish')");
9077
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ku', 'language', 'fr', 'Kurde')");
9078
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ku', 'language', 'de', 'Kurdisch')");
9079
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ku', 'language', 'es', 'Kurdo')");
9080
9081
    $dbh->do("UPDATE language_descriptions SET description = 'ພາສາລາວ' WHERE subtag = 'lo' AND type = 'language' AND lang = 'lo'");
9082
9083
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'mi', 'language', 'Maori','2014-10-30')");
9084
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'mi','mri')");
9085
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'mi', 'language', 'mi', 'Te Reo Māori')");
9086
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'mi', 'language', 'en', 'Maori')");
9087
9088
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'mn', 'language', 'Mongolian','2014-10-30')");
9089
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'mn','mon')");
9090
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'mn', 'language', 'mn', 'Mонгол')");
9091
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'mn', 'language', 'en', 'Mongolian')");
9092
9093
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'mr', 'language', 'Marathi','2014-10-30')");
9094
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'mr','mar')");
9095
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'mr', 'language', 'mr', 'मराठी')");
9096
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'mr', 'language', 'en', 'Marathi')");
9097
9098
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ms', 'language', 'Malay','2014-10-30')");
9099
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ms','may')");
9100
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ms', 'language', 'ms', 'Bahasa melayu')");
9101
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ms', 'language', 'en', 'Malay')");
9102
9103
    $dbh->do("UPDATE language_descriptions SET description = 'Norsk bokmål' WHERE subtag = 'nb' AND type = 'language' AND lang = 'nb'");
9104
    $dbh->do("UPDATE language_descriptions SET description = 'Norwegian bokmål' WHERE subtag = 'nb' AND type = 'language' AND lang = 'en'");
9105
    $dbh->do("UPDATE language_descriptions SET description = 'Norvégien bokmål' WHERE subtag = 'nb' AND type = 'language' AND lang = 'fr'");
9106
    $dbh->do("UPDATE language_descriptions SET description = 'Norwegisch bokmål' WHERE subtag = 'nb' AND type = 'language' AND lang = 'de'");
9107
9108
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ne', 'language', 'Nepali','2014-10-30')");
9109
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ne','nep')");
9110
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)VALUES ( 'ne', 'language', 'ne', 'नेपाली')");
9111
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ne', 'language', 'en', 'Nepali')");
9112
9113
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'pbr', 'language', 'Pangwa','2014-10-30')");
9114
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'pbr','pbr')");
9115
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pbr', 'language', 'pbr', 'Ekipangwa')");
9116
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pbr', 'language', 'en', 'Pangwa')");
9117
9118
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'prs', 'language', 'Dari','2014-10-30')");
9119
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'prs','prs')");
9120
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'prs', 'language', 'prs', 'درى')");
9121
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'prs', 'language', 'en', 'Dari')");
9122
9123
    $dbh->do("UPDATE language_descriptions SET description = 'Português' WHERE subtag = 'pt' AND type = 'language' AND lang = 'pt'");
9124
    $dbh->do("UPDATE language_descriptions SET description = 'Român' WHERE subtag = 'ro' AND type = 'language' AND lang = 'ro'");
9125
    $dbh->do("UPDATE language_descriptions SET description = 'Русский' WHERE subtag = 'ru' AND type = 'language' AND lang = 'ru'");
9126
9127
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'rw', 'language', 'Kinyarwanda','2014-10-30')");
9128
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'rw','kin')");
9129
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'rw', 'language', 'rw', 'Ikinyarwanda')");
9130
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'rw', 'language', 'en', 'Kinyarwanda')");
9131
9132
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sd', 'language', 'Sindhi','2014-10-30')");
9133
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sd','snd')");
9134
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sd', 'language', 'sd', 'سنڌي')");
9135
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sd', 'language', 'en', 'Sindhi')");
9136
9137
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sk', 'language', 'Slovak','2014-10-30')");
9138
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sk','slk')");
9139
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sk', 'language', 'sk', 'Slovenčina')");
9140
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sk', 'language', 'en', 'Slovak')");
9141
9142
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sl', 'language', 'Slovene','2014-10-30')");
9143
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sl','slv')");
9144
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sl', 'language', 'sl', 'Slovenščina')");
9145
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sl', 'language', 'en', 'Slovene')");
9146
9147
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sq', 'language', 'Albanian','2014-10-30')");
9148
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sq','sqi')");
9149
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sq', 'language', 'sq', 'Shqip')");
9150
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sq', 'language', 'en', 'Albanian')");
9151
9152
    $dbh->do("UPDATE language_descriptions SET description = 'Cрпски' WHERE subtag = 'sr' AND type = 'language' AND lang = 'sr'");
9153
9154
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sw', 'language', 'Swahili','2014-10-30')");
9155
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sw','swa')");
9156
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sw', 'language', 'sw', 'Kiswahili')");
9157
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sw', 'language', 'en', 'Swahili')");
9158
9159
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ta', 'language', 'Tamil','2014-10-30')");
9160
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ta','tam')");
9161
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ta', 'language', 'ta', 'தமிழ்')");
9162
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ta', 'language', 'en', 'Tamil')");
9163
9164
    $dbh->do("UPDATE language_descriptions SET description = 'Tetun' WHERE subtag = 'tet' AND type = 'language' AND lang = 'tet'");
9165
    $dbh->do("UPDATE language_descriptions SET description = 'ภาษาไทย' WHERE subtag = 'th' AND type = 'language' AND lang = 'th'");
9166
9167
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'tl', 'language', 'Tagalog','2014-10-30')");
9168
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'tl','tgl')");
9169
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'tl', 'language', 'tl', 'Tagalog')");
9170
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'tl', 'language', 'en', 'Tagalog')");
9171
9172
    $dbh->do("UPDATE language_descriptions SET description = 'Türkçe' WHERE subtag = 'tr' AND type = 'language' AND lang = 'tr'");
9173
    $dbh->do("UPDATE language_descriptions SET description = 'Українська' WHERE subtag = 'uk' AND type = 'language' AND lang = 'uk'");
9174
    $dbh->do("UPDATE language_descriptions SET description = 'اردو' WHERE subtag = 'ur' AND type = 'language' AND lang = 'ur'");
9175
9176
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'vi', 'language', 'Vietnamese','2014-10-30')");
9177
    $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'vi','vie')");
9178
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vi', 'language', 'vi', '㗂越')");
9179
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vi', 'language', 'en', 'Vietnamese')");
9180
9181
    $dbh->do("UPDATE language_descriptions SET description = '中文' WHERE subtag = 'zh' AND type = 'language' AND lang = 'zh'");
9182
    $dbh->do("UPDATE language_descriptions SET description = '' WHERE subtag = 'Arab,script' AND type = 'Arab' AND lang = 'العربية'");
9183
9184
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Armn', 'script', 'Armenian','2014-10-30')");
9185
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'Armn', 'script', 'Armn', 'Հայոց այբուբեն')");
9186
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'Armn', 'script', 'en', 'Armenian')");
9187
9188
    $dbh->do("UPDATE language_descriptions SET description = 'Кирилица' WHERE subtag = 'Cyrl' AND type = 'script' AND lang = 'Cyrl'");
9189
9190
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Ethi', 'script', 'Ethiopic','2014-10-30')");
9191
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'Ethi', 'script', 'Ethi', 'ግዕዝ')");
9192
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'Ethi', 'script', 'en', 'Ethiopic')");
9193
9194
    $dbh->do("UPDATE language_descriptions SET description = 'Ελληνικό αλφάβητο' WHERE subtag = 'Grek' AND type = 'script' AND lang = 'Grek'");
9195
    $dbh->do("UPDATE language_descriptions SET description = '简体字' WHERE subtag = 'Hans' AND type = 'script' AND lang = 'Hans'");
9196
    $dbh->do("UPDATE language_descriptions SET description = '繁體字' WHERE subtag = 'Hant' AND type = 'script' AND lang = 'Hant'");
9197
    $dbh->do("UPDATE language_descriptions SET description = 'אָלֶף־בֵּית עִבְרִי' WHERE subtag = 'Hebr' AND type = 'script' AND lang = 'Hebr'");
9198
9199
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Jpan', 'script', 'Japanese','2014-10-30')");
9200
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'Jpan', 'script', 'Jpan', '漢字')");
9201
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'Jpan', 'script', 'en', 'Japanese')");
9202
9203
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Knda', 'script', 'Kannada','2014-10-30')");
9204
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'Knda', 'script', 'Knda', 'ಕನ್ನಡ ಲಿಪಿ')");
9205
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'Knda', 'script', 'en', 'Kannada')");
9206
9207
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Kore', 'script', 'Korean','2014-10-30')");
9208
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'Kore', 'script', 'Kore', '한글')");
9209
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'Kore', 'script', 'en', 'Korean')");
9210
9211
    $dbh->do("UPDATE language_descriptions SET description = 'ອັກສອນລາວ' WHERE subtag = 'Laoo' AND type = 'script' AND lang = 'Laoo'");
9212
9213
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'AL', 'region', 'Albania','2014-10-30')");
9214
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'AL', 'region', 'en', 'Albania')");
9215
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'AL', 'region', 'sq', 'Shqipërisë')");
9216
9217
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'AZ', 'region', 'Azerbaijan','2014-10-30')");
9218
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'AZ', 'region', 'en', 'Azerbaijan')");
9219
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'AZ', 'region', 'az', 'Azərbaycan')");
9220
9221
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'BE', 'region', 'Belgium','2014-10-30')");
9222
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'BE', 'region', 'en', 'Belgium')");
9223
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'BE', 'region', 'nl', 'België')");
9224
9225
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'BR', 'region', 'Brazil','2014-10-30')");
9226
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'BR', 'region', 'en', 'Brazil')");
9227
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'BR', 'region', 'pt', 'Brasil')");
9228
9229
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'BY', 'region', 'Belarus','2014-10-30')");
9230
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'BY', 'region', 'en', 'Belarus')");
9231
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'BY', 'region', 'be', 'Беларусь')");
9232
9233
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CA', 'region', 'fr', 'Canada')");
9234
9235
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'CH', 'region', 'Switzerland','2014-10-30')");
9236
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CH', 'region', 'en', 'Switzerland')");
9237
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CH', 'region', 'de', 'Schweiz')");
9238
9239
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'CN', 'region', 'China','2014-10-30')");
9240
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CN', 'region', 'en', 'China')");
9241
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CN', 'region', 'zh', '中国')");
9242
9243
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'CZ', 'region', 'Czech Republic','2014-10-30')");
9244
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CZ', 'region', 'en', 'Czech Republic')");
9245
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CZ', 'region', 'cs', 'Česká republika')");
9246
9247
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'DE', 'region', 'Germany','2014-10-30')");
9248
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'DE', 'region', 'en', 'Germany')");
9249
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'DE', 'region', 'de', 'Deutschland')");
9250
9251
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'DK', 'region', 'en', 'Denmark')");
9252
9253
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ES', 'region', 'Spain','2014-10-30')");
9254
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ES', 'region', 'en', 'Spain')");
9255
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ES', 'region', 'es', 'España')");
9256
9257
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'FI', 'region', 'Finland','2014-10-30')");
9258
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'FI', 'region', 'en', 'Finland')");
9259
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'FI', 'region', 'fi', 'Suomi')");
9260
9261
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'FO', 'region', 'Faroe Islands','2014-10-30')");
9262
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'FO', 'region', 'en', 'Faroe Islands')");
9263
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'FO', 'region', 'fo', 'Føroyar')");
9264
9265
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'GR', 'region', 'Greece','2014-10-30')");
9266
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'GR', 'region', 'en', 'Greece')");
9267
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'GR', 'region', 'el', 'Ελλάδα')");
9268
9269
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'HR', 'region', 'Croatia','2014-10-30')");
9270
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'HR', 'region', 'en', 'Croatia')");
9271
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'HR', 'region', 'hr', 'Hrvatska')");
9272
9273
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'HU', 'region', 'Hungary','2014-10-30')");
9274
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'HU', 'region', 'en', 'Hungary')");
9275
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'HU', 'region', 'hu', 'Magyarország')");
9276
9277
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ID', 'region', 'Indonesia','2014-10-30')");
9278
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ID', 'region', 'en', 'Indonesia')");
9279
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ID', 'region', 'id', 'Indonesia')");
9280
9281
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'IS', 'region', 'Iceland','2014-10-30')");
9282
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'IS', 'region', 'en', 'Iceland')");
9283
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'IS', 'region', 'is', 'Ísland')");
9284
9285
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'IT', 'region', 'Italy','2014-10-30')");
9286
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'IT', 'region', 'en', 'Italy')");
9287
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'IT', 'region', 'it', 'Italia')");
9288
9289
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'JP', 'region', 'Japan','2014-10-30')");
9290
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'JP', 'region', 'en', 'Japan')");
9291
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'JP', 'region', 'ja', '日本')");
9292
9293
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'KE', 'region', 'Kenya','2014-10-30')");
9294
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'KE', 'region', 'en', 'Kenya')");
9295
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'KE', 'region', 'rw', 'Kenya')");
9296
9297
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'KH', 'region', 'Cambodia','2014-10-30')");
9298
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'KH', 'region', 'en', 'Cambodia')");
9299
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'KH', 'region', 'km', 'កម្ពុជា')");
9300
9301
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'KP', 'region', 'North Korea','2014-10-30')");
9302
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'KP', 'region', 'en', 'North Korea')");
9303
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'KP', 'region', 'ko', '조선민주주의인민공화국')");
9304
9305
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'LK', 'region', 'Sri Lanka','2014-10-30')");
9306
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'LK', 'region', 'en', 'Sri Lanka')");
9307
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'LK', 'region', 'ta', 'இலங்கை')");
9308
9309
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'MY', 'region', 'Malaysia','2014-10-30')");
9310
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'MY', 'region', 'en', 'Malaysia')");
9311
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'MY', 'region', 'ms', 'Malaysia')");
9312
9313
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'NE', 'region', 'Niger','2014-10-30')");
9314
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NE', 'region', 'en', 'Niger')");
9315
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NE', 'region', 'ne', 'Niger')");
9316
9317
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'NL', 'region', 'Netherlands','2014-10-30')");
9318
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NL', 'region', 'en', 'Netherlands')");
9319
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NL', 'region', 'nl', 'Nederland')");
9320
9321
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'NO', 'region', 'Norway','2014-10-30')");
9322
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NO', 'region', 'en', 'Norway')");
9323
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NO', 'region', 'ne', 'Noreg')");
9324
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NO', 'region', 'nn', 'Noreg')");
9325
9326
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'PH', 'region', 'Philippines','2014-10-30')");
9327
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PH', 'region', 'en', 'Philippines')");
9328
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PH', 'region', 'tl', 'Pilipinas')");
9329
9330
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'PK', 'region', 'Pakistan','2014-10-30')");
9331
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PK', 'region', 'en', 'Pakistan')");
9332
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PK', 'region', 'sd', 'پاكستان')");
9333
9334
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'PL', 'region', 'Poland','2014-10-30')");
9335
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PL', 'region', 'en', 'Poland')");
9336
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PL', 'region', 'pl', 'Polska')");
9337
9338
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'PT', 'region', 'Portugal','2014-10-30')");
9339
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PT', 'region', 'en', 'Portugal')");
9340
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PT', 'region', 'pt', 'Portugal')");
9341
9342
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'RO', 'region', 'Romania','2014-10-30')");
9343
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'RO', 'region', 'en', 'Romania')");
9344
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'RO', 'region', 'ro', 'România')");
9345
9346
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'RU', 'region', 'Russia','2014-10-30')");
9347
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'RU', 'region', 'en', 'Russia')");
9348
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'RU', 'region', 'ru', 'Россия')");
9349
9350
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'RW', 'region', 'Rwanda','2014-10-30')");
9351
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'RW', 'region', 'en', 'Rwanda')");
9352
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'RW', 'region', 'rw', 'Rwanda')");
9353
9354
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'SE', 'region', 'Sweden','2014-10-30')");
9355
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'SE', 'region', 'en', 'Sweden')");
9356
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'SE', 'region', 'sv', 'Sverige')");
9357
9358
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'SI', 'region', 'Slovenia','2014-10-30')");
9359
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'SI', 'region', 'en', 'Slovenia')");
9360
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'SI', 'region', 'sl', 'Slovenija')");
9361
9362
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'SK', 'region', 'Slovakia','2014-10-30')");
9363
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'SK', 'region', 'en', 'Slovakia')");
9364
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'SK', 'region', 'sk', 'Slovensko')");
9365
9366
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'TH', 'region', 'Thailand','2014-10-30')");
9367
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'TH', 'region', 'en', 'Thailand')");
9368
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'TH', 'region', 'th', 'ประเทศไทย')");
9369
9370
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'TR', 'region', 'Turkey','2014-10-30')");
9371
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'TR', 'region', 'en', 'Turkey')");
9372
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'TR', 'region', 'tr', 'Türkiye')");
9373
9374
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'TW', 'region', 'Taiwan','2014-10-30')");
9375
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'TW', 'region', 'en', 'Taiwan')");
9376
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'TW', 'region', 'zh', '台灣')");
9377
9378
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'UA', 'region', 'Ukraine','2014-10-30')");
9379
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'UA', 'region', 'en', 'Ukraine')");
9380
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'UA', 'region', 'uk', 'Україна')");
9381
9382
    $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'VN', 'region', 'Vietnam','2014-10-30')");
9383
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'VN', 'region', 'en', 'Vietnam')");
9384
    $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'VN', 'region', 'vi', 'Việt Nam')");
9385
9386
    print "Upgrade to $DBversion done (Bug 12250: Update descriptions for languages, scripts and regions)\n";
9387
    SetVersion($DBversion);
9388
}
9389
9008
=head1 FUNCTIONS
9390
=head1 FUNCTIONS
9009
9391
9010
=head2 TableExists($table)
9392
=head2 TableExists($table)
9011
- 

Return to bug 12250