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

(-)a/installer/data/mysql/atomicupdate/Bug-18493-Add-new-searchable-languages.perl (+187 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    # Standard Tibetan
5
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'bo', 'language', 'Standard Tibetan', '2017-04-21')");
6
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'bo', 'tib')");
7
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bo', 'language', 'en', 'Standard Tibetan')");
8
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bo', 'language', 'bo', 'ལྷ་སའི་སྐད་')");
9
    # Bosnian
10
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'bs', 'language', 'Bosnian', '2017-04-21')");
11
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'bs', 'bos')");
12
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bs', 'language', 'en', 'Bosnian')");
13
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bs', 'language', 'bn', 'Bosanski')");
14
    # Welsh
15
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'cy', 'language', 'Welsh', '2017-04-21')");
16
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'cy', 'wel')");
17
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'cy', 'language', 'en', 'Welsh')");
18
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'cy', 'language', 'cy', 'Cymraeg')");
19
    # Esperanto
20
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'eo', 'language', 'Esperanto', '2017-04-21')");
21
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'eo', 'epo')");
22
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eo', 'language', 'en', 'Esperanto')");
23
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eo', 'language', 'eo', 'Esperanto')");
24
    # Estonian
25
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'et', 'language', 'Estonian', '2017-04-21')");
26
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'et', 'est')");
27
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'et', 'language', 'et', 'Eesti')");
28
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'et', 'language', 'en', 'Estonian')");
29
    # Irish Gaelic
30
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ga', 'language', 'Irish', '2017-04-21')");
31
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ga', 'gle')");
32
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ga', 'language', 'en', 'Irish')");
33
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ga', 'language', 'ga', 'Gaeilge')");
34
    # Scottish Gaelic
35
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'gd', 'language', 'Scottish Gaelic', '2017-04-21')");
36
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'gd', 'gla')");
37
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic')");
38
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'gd', 'language', 'gd', 'Gàidhlig')");
39
    # Ancient Greek
40
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'grc', 'language', 'Greek, Ancient', '2017-04-21')");
41
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'grc', 'grc')");
42
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'grc', 'language', 'en', 'Greek, Ancient')");
43
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'grc', 'language', 'grc', 'Ἑλληνική')");
44
    # Kazakh
45
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kk', 'language', 'Kazakh', '2017-04-21')");
46
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kk', 'kaz')");
47
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kk', 'language', 'en', 'Kazakh')");
48
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kk', 'language', 'kk', 'қазақ тілі')");
49
    # Greenlandic
50
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kl', 'language', 'Greenlandic', '2017-04-21')");
51
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kl', 'kal')");
52
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kl', 'language', 'en', 'Greenlandic')");
53
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kl', 'language', 'kl', 'Kalaallisut')");
54
    # Karelian
55
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'krl', 'language', 'Karelian', '2017-04-21')");
56
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'krl', 'krl')");
57
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'krl', 'language', 'en', 'Karelian')");
58
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'krl', 'language', 'krl', 'Karjala')");
59
    # Cornish
60
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kw', 'language', 'Cornish', '2017-04-21')");
61
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kw', 'cor')");
62
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kw', 'language', 'en', 'Cornish')");
63
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kw', 'language', 'kw', 'Kernowek')");
64
    # Lithuanian
65
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'lt', 'language', 'Lithuanian', '2017-04-21')");
66
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'lt', 'lit')");
67
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lt', 'language', 'en', 'Lithuanian')");
68
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lt', 'language', 'lt', 'lietuvių kalba')");
69
    # Latvian
70
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'lv', 'language', 'Latvian', '2017-04-21')");
71
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'lv', 'lav')");
72
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lv', 'language', 'en', 'Latvian')");
73
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lv', 'language', 'lv', 'Latviešu valoda')");
74
    # Burmese
75
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'my', 'language', 'Burmese', '2017-04-21')");
76
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'my', 'bur')");
77
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'my', 'language', 'en', 'Burmese')");
78
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'my', 'language', 'my', 'မြန်မာစာ')");
79
    # Punjabi
80
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'pa', 'language', 'Punjabi', '2017-04-21')");
81
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'pa', 'pan')");
82
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pa', 'language', 'en', 'Punjabi')");
83
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pa', 'language', 'pa', 'پنجابی')");
84
    # Pashto
85
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ps', 'language', 'Pashto', '2017-04-21')");
86
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ps', 'pus')");
87
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ps', 'language', 'en', 'Pashto')");
88
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ps', 'language', 'ps', 'پښتو')");
89
    # Finnish Kalo
90
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'rmf', 'rmf')");
91
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'en', 'Finnish Kalo')");
92
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'fi', 'Suomen romanikieli')");
93
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'rmf', 'Fíntika Rómma')");
94
    # Sanskrit
95
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sa', 'language', 'Sanskrit', '2017-04-21')");
96
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sa', 'san')");
97
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sa', 'language', 'en', 'Sanskrit')");
98
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sa', 'language', 'sa', 'saṃskṛtam')");
99
    # Akkala Sami
100
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sia', 'language', 'Akkala Sami', '2017-04-21')");
101
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sia', 'sia')");
102
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sia', 'language', 'en', 'Akkala Sami')");
103
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sia', 'language', 'sia', 'ču´kksuâlis')");
104
    # Kildin Sami
105
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjd', 'language', 'Kildin Sami', '2017-04-21')");
106
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjd', 'sjd')");
107
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjd', 'language', 'en', 'Kildin Sami')");
108
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjd', 'language', 'sjd', 'Кӣллт са̄мь кӣлл')");
109
    # Ter Sami
110
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjt', 'language', 'Ter Sami', '2017-04-21')");
111
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjt', 'sjt')");
112
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjt', 'language', 'en', 'Ter Sami')");
113
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjt', 'language', 'sjt', 'saa´mekiill')");
114
    # Pite Sami
115
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sje', 'language', 'Pite Sami', '2017-04-21')");
116
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sje', 'sje')");
117
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sje', 'language', 'en', 'Pite Sami')");
118
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sje', 'language', 'sje', 'Bidumsámegiella')");
119
    # Kemi Sami
120
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjk', 'language', 'Kemi Sami', '2017-04-21')");
121
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjk', 'sjk')");
122
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjk', 'language', 'en', 'Kemi Sami')");
123
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjk', 'language', 'sjk', 'samääškiela')");
124
    # Ume Sami
125
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sju', 'language', 'Ume Sami', '2017-04-21')");
126
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sju', 'sju')");
127
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sju', 'language', 'en', 'Ume Sami')");
128
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sju', 'language', 'sju', 'Ubmejensámien giella')");
129
    # Southern Sami
130
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sma', 'language', 'Southern Sami', '2017-04-21')");
131
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sma', 'sma')");
132
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sma', 'language', 'en', 'Southern Sami')");
133
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sma', 'language', 'sma', 'Åarjelsaemien gïele')");
134
    # Northern Sami
135
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sme', 'language', 'Northern Sami', '2017-04-21')");
136
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sme', 'sme')");
137
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'en', 'Northern Sami')");
138
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'fi', 'pohjoissaame')");
139
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'sv', 'Nordsamiska')");
140
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'sme', 'davvisámegiella')");
141
    # Sami languages
142
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smi', 'language', 'Sami languages', '2017-04-21')");
143
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smi', 'smi')");
144
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'en', 'Sami languages')");
145
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'fi', 'saamelaiskielet')");
146
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'sv', 'Samiska')");
147
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'smi', 'Saami')");
148
    # Lule Sami
149
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smj', 'language', 'Lule Sami', '2017-04-21')");
150
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smj', 'smj')");
151
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smj', 'language', 'en', 'Lule Sami')");
152
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smj', 'language', 'smj', 'julevsámegiella')");
153
    # Inari Sami
154
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smn', 'language', 'Inari Sami', '2017-04-21')");
155
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smn', 'smn')");
156
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smn', 'language', 'en', 'Inari Sami')");
157
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smn', 'language', 'smn', 'anarâškielâ')");
158
    # Skolt Sami
159
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sms', 'language', 'Skolt Sami', '2017-04-21')");
160
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sms', 'sms')");
161
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sms', 'language', 'en', 'Skolt Sami')");
162
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sms', 'language', 'sms', 'sääʹmǩiõll')");
163
    # Somali
164
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'so', 'language', 'Somali', '2017-04-21')");
165
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'so', 'som')");
166
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'so', 'language', 'en', 'Somali')");
167
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'so', 'language', 'so', 'Af-Soomaali')");
168
    # Sotho
169
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'st', 'language', 'Sotho', '2017-04-21')");
170
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'st', 'sot')");
171
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'st', 'language', 'en', 'Sotho')");
172
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'st', 'language', 'st', 'Sesotho')");
173
    # Votic
174
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'vot', 'language', 'Votic', '2017-04-21')");
175
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'vot', 'vot')");
176
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vot', 'language', 'en', 'Votic')");
177
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vot', 'language', 'vot', 'vađđa ceeli')");
178
    # Yiddish
179
    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'yi', 'language', 'Yiddish', '2017-04-21')");
180
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'yi', 'yid')");
181
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'yi', 'language', 'en', 'Yiddish')");
182
    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'yi', 'language', 'yi', 'יידיש')");
183
184
    # Always end with this (adjust the bug info)
185
    SetVersion( $DBversion );
186
    print "Upgrade to $DBversion done (Bug XXXXX - description)\n";
187
}
(-)a/installer/data/mysql/mandatory/subtag_registry.sql (-1 / +467 lines)
Lines 146-151 VALUES ( 'bg', 'language', 'fr', 'Bulgare'); Link Here
146
INSERT INTO language_descriptions(subtag, type, lang, description)
146
INSERT INTO language_descriptions(subtag, type, lang, description)
147
VALUES ( 'bg', 'language', 'de', 'Bulgarisch');
147
VALUES ( 'bg', 'language', 'de', 'Bulgarisch');
148
148
149
-- Standard Tibetan
150
INSERT INTO language_subtag_registry( subtag, type, description, added)
151
VALUES ( 'bo', 'language', 'Standard Tibetan', '2017-04-21');
152
153
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
154
VALUES ( 'bo', 'tib');
155
156
INSERT INTO language_descriptions(subtag, type, lang, description)
157
VALUES ( 'bo', 'language', 'en', 'Standard Tibetan');
158
159
INSERT INTO language_descriptions(subtag, type, lang, description)
160
VALUES ( 'bo', 'language', 'bo', 'ལྷ་སའི་སྐད་');
161
162
-- Bosnian
163
INSERT INTO language_subtag_registry( subtag, type, description, added)
164
VALUES ( 'bs', 'language', 'Bosnian', '2017-04-21');
165
166
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
167
VALUES ( 'bs', 'bos');
168
169
INSERT INTO language_descriptions(subtag, type, lang, description)
170
VALUES ( 'bs', 'language', 'en', 'Bosnian');
171
172
INSERT INTO language_descriptions(subtag, type, lang, description)
173
VALUES ( 'bs', 'language', 'bn', 'Bosanski');
174
149
-- Catalan
175
-- Catalan
150
INSERT INTO language_subtag_registry( subtag, type, description, added)
176
INSERT INTO language_subtag_registry( subtag, type, description, added)
151
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
177
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
Lines 187-192 VALUES ( 'cs', 'language', 'fr', 'Tchèque'); Link Here
187
INSERT INTO language_descriptions(subtag, type, lang, description)
213
INSERT INTO language_descriptions(subtag, type, lang, description)
188
VALUES ( 'cs', 'language', 'de', 'Tschechisch');
214
VALUES ( 'cs', 'language', 'de', 'Tschechisch');
189
215
216
-- Welsh
217
INSERT INTO language_subtag_registry( subtag, type, description, added)
218
VALUES ( 'cy', 'language', 'Welsh', '2017-04-21');
219
220
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
221
VALUES ( 'cy', 'wel');
222
223
INSERT INTO language_descriptions(subtag, type, lang, description)
224
VALUES ( 'cy', 'language', 'en', 'Welsh');
225
226
INSERT INTO language_descriptions(subtag, type, lang, description)
227
VALUES ( 'cy', 'language', 'cy', 'Cymraeg');
228
190
-- Danish
229
-- Danish
191
INSERT INTO language_subtag_registry( subtag, type, description, added)
230
INSERT INTO language_subtag_registry( subtag, type, description, added)
192
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
231
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
Lines 257-262 VALUES ( 'en', 'language', 'fr', 'Anglais'); Link Here
257
INSERT INTO language_descriptions(subtag, type, lang, description)
296
INSERT INTO language_descriptions(subtag, type, lang, description)
258
VALUES ( 'en', 'language', 'de', 'Englisch');
297
VALUES ( 'en', 'language', 'de', 'Englisch');
259
298
299
-- Esperanto
300
INSERT INTO language_subtag_registry( subtag, type, description, added)
301
VALUES ( 'eo', 'language', 'Esperanto', '2017-04-21');
302
303
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
304
VALUES ( 'eo', 'epo');
305
306
INSERT INTO language_descriptions(subtag, type, lang, description)
307
VALUES ( 'eo', 'language', 'en', 'Esperanto');
308
309
INSERT INTO language_descriptions(subtag, type, lang, description)
310
VALUES ( 'eo', 'language', 'eo', 'Esperanto');
311
260
-- Spanish, Castilian
312
-- Spanish, Castilian
261
INSERT INTO language_subtag_registry( subtag, type, description, added)
313
INSERT INTO language_subtag_registry( subtag, type, description, added)
262
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
314
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
Lines 276-281 VALUES ( 'es', 'language', 'fr', 'Espagnol'); Link Here
276
INSERT INTO language_descriptions(subtag, type, lang, description)
328
INSERT INTO language_descriptions(subtag, type, lang, description)
277
VALUES ( 'es', 'language', 'de', 'Spanisch');
329
VALUES ( 'es', 'language', 'de', 'Spanisch');
278
330
331
-- Estonian
332
INSERT INTO language_subtag_registry( subtag, type, description, added)
333
VALUES ( 'et', 'language', 'Estonian', '2017-04-21');
334
335
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
336
VALUES ( 'et', 'est');
337
338
INSERT INTO language_descriptions(subtag, type, lang, description)
339
VALUES ( 'et', 'language', 'et', 'Eesti');
340
341
INSERT INTO language_descriptions(subtag, type, lang, description)
342
VALUES ( 'et', 'language', 'en', 'Estonian');
343
279
-- Basque
344
-- Basque
280
INSERT INTO language_subtag_registry( subtag, type, description, added)
345
INSERT INTO language_subtag_registry( subtag, type, description, added)
281
VALUES ( 'eu', 'language', 'Basque','2014-10-30');
346
VALUES ( 'eu', 'language', 'Basque','2014-10-30');
Lines 353-358 VALUES ( 'fr', 'language', 'fr', 'Français'); Link Here
353
INSERT INTO language_descriptions(subtag, type, lang, description)
418
INSERT INTO language_descriptions(subtag, type, lang, description)
354
VALUES ( 'fr', 'language', 'de', 'Französisch');
419
VALUES ( 'fr', 'language', 'de', 'Französisch');
355
420
421
-- Irish Gaelic
422
INSERT INTO language_subtag_registry( subtag, type, description, added)
423
VALUES ( 'ga', 'language', 'Irish', '2017-04-21');
424
425
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
426
VALUES ( 'ga', 'gle');
427
428
INSERT INTO language_descriptions(subtag, type, lang, description)
429
VALUES ( 'ga', 'language', 'en', 'Irish');
430
431
INSERT INTO language_descriptions(subtag, type, lang, description)
432
VALUES ( 'ga', 'language', 'ga', 'Gaeilge');
433
434
-- Scottish Gaelic
435
INSERT INTO language_subtag_registry( subtag, type, description, added)
436
VALUES ( 'gd', 'language', 'Scottish Gaelic', '2017-04-21');
437
438
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
439
VALUES ( 'gd', 'gla');
440
441
INSERT INTO language_descriptions(subtag, type, lang, description)
442
VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic');
443
444
INSERT INTO language_descriptions(subtag, type, lang, description)
445
VALUES ( 'gd', 'language', 'gd', 'Gàidhlig');
446
356
-- Galician
447
-- Galician
357
INSERT INTO language_subtag_registry( subtag, type, description, added)
448
INSERT INTO language_subtag_registry( subtag, type, description, added)
358
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
449
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
Lines 372-377 VALUES ( 'gl', 'language', 'fr', 'Galicien'); Link Here
372
INSERT INTO language_descriptions(subtag, type, lang, description)
463
INSERT INTO language_descriptions(subtag, type, lang, description)
373
VALUES ( 'gl', 'language', 'de', 'Galicisch');
464
VALUES ( 'gl', 'language', 'de', 'Galicisch');
374
465
466
-- Ancient Greek
467
INSERT INTO language_subtag_registry( subtag, type, description, added)
468
VALUES ( 'grc', 'language', 'Greek, Ancient', '2017-04-21');
469
470
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
471
VALUES ( 'grc', 'grc');
472
473
INSERT INTO language_descriptions(subtag, type, lang, description)
474
VALUES ( 'grc', 'language', 'en', 'Greek, Ancient');
475
476
INSERT INTO language_descriptions(subtag, type, lang, description)
477
VALUES ( 'grc', 'language', 'grc', 'Ἑλληνική');
478
375
-- Hebrew
479
-- Hebrew
376
INSERT INTO language_subtag_registry( subtag, type, description, added)
480
INSERT INTO language_subtag_registry( subtag, type, description, added)
377
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
481
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
Lines 559-564 VALUES ( 'ka', 'language', 'de', 'Georgisch'); Link Here
559
INSERT INTO language_descriptions(subtag, type, lang, description)
663
INSERT INTO language_descriptions(subtag, type, lang, description)
560
VALUES ( 'ka', 'language', 'es', 'Georgiano');
664
VALUES ( 'ka', 'language', 'es', 'Georgiano');
561
665
666
-- Kazakh
667
INSERT INTO language_subtag_registry( subtag, type, description, added)
668
VALUES ( 'kk', 'language', 'Kazakh', '2017-04-21');
669
670
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
671
VALUES ( 'kk', 'kaz');
672
673
INSERT INTO language_descriptions(subtag, type, lang, description)
674
VALUES ( 'kk', 'language', 'en', 'Kazakh');
675
676
INSERT INTO language_descriptions(subtag, type, lang, description)
677
VALUES ( 'kk', 'language', 'kk', 'қазақ тілі');
678
679
-- Greenlandic
680
INSERT INTO language_subtag_registry( subtag, type, description, added)
681
VALUES ( 'kl', 'language', 'Greenlandic', '2017-04-21');
682
683
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
684
VALUES ( 'kl', 'kal');
685
686
INSERT INTO language_descriptions(subtag, type, lang, description)
687
VALUES ( 'kl', 'language', 'en', 'Greenlandic');
688
689
INSERT INTO language_descriptions(subtag, type, lang, description)
690
VALUES ( 'kl', 'language', 'kl', 'Kalaallisut');
691
562
-- Kannada
692
-- Kannada
563
INSERT INTO language_subtag_registry( subtag, type, description, added)
693
INSERT INTO language_subtag_registry( subtag, type, description, added)
564
VALUES ( 'kn', 'language', 'Kannada','2014-10-30');
694
VALUES ( 'kn', 'language', 'Kannada','2014-10-30');
Lines 604-609 VALUES ( 'ko', 'language', 'fr', 'Coréen'); Link Here
604
INSERT INTO language_descriptions(subtag, type, lang, description)
734
INSERT INTO language_descriptions(subtag, type, lang, description)
605
VALUES ( 'ko', 'language', 'de', 'Koreanisch');
735
VALUES ( 'ko', 'language', 'de', 'Koreanisch');
606
736
737
-- Karelian
738
INSERT INTO language_subtag_registry( subtag, type, description, added)
739
VALUES ( 'krl', 'language', 'Karelian', '2017-04-21');
740
741
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
742
VALUES ( 'krl', 'krl');
743
744
INSERT INTO language_descriptions(subtag, type, lang, description)
745
VALUES ( 'krl', 'language', 'en', 'Karelian');
746
747
INSERT INTO language_descriptions(subtag, type, lang, description)
748
VALUES ( 'krl', 'language', 'krl', 'Karjala');
749
607
-- Kurdish
750
-- Kurdish
608
INSERT INTO language_subtag_registry( subtag, type, description, added)
751
INSERT INTO language_subtag_registry( subtag, type, description, added)
609
VALUES ( 'ku', 'language', 'Kurdish','2014-05-13');
752
VALUES ( 'ku', 'language', 'Kurdish','2014-05-13');
Lines 626-631 VALUES ( 'ku', 'language', 'de', 'Kurdisch'); Link Here
626
INSERT INTO language_descriptions(subtag, type, lang, description)
769
INSERT INTO language_descriptions(subtag, type, lang, description)
627
VALUES ( 'ku', 'language', 'es', 'Kurdo');
770
VALUES ( 'ku', 'language', 'es', 'Kurdo');
628
771
772
-- Cornish
773
INSERT INTO language_subtag_registry( subtag, type, description, added)
774
VALUES ( 'kw', 'language', 'Cornish', '2017-04-21');
775
776
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
777
VALUES ( 'kw', 'cor');
778
779
INSERT INTO language_descriptions(subtag, type, lang, description)
780
VALUES ( 'kw', 'language', 'en', 'Cornish');
781
782
INSERT INTO language_descriptions(subtag, type, lang, description)
783
VALUES ( 'kw', 'language', 'kw', 'Kernowek');
784
629
-- Latin
785
-- Latin
630
INSERT INTO language_subtag_registry( subtag, type, description, added)
786
INSERT INTO language_subtag_registry( subtag, type, description, added)
631
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
787
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
Lines 664-669 VALUES ( 'lo', 'language', 'fr', 'Laotien'); Link Here
664
INSERT INTO language_descriptions(subtag, type, lang, description)
820
INSERT INTO language_descriptions(subtag, type, lang, description)
665
VALUES ( 'lo', 'language', 'de', 'Laotisch');
821
VALUES ( 'lo', 'language', 'de', 'Laotisch');
666
822
823
-- Lithuanian
824
INSERT INTO language_subtag_registry( subtag, type, description, added)
825
VALUES ( 'lt', 'language', 'Lithuanian', '2017-04-21');
826
827
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
828
VALUES ( 'lt', 'lit');
829
830
INSERT INTO language_descriptions(subtag, type, lang, description)
831
VALUES ( 'lt', 'language', 'en', 'Lithuanian');
832
833
INSERT INTO language_descriptions(subtag, type, lang, description)
834
VALUES ( 'lt', 'language', 'lt', 'lietuvių kalba');
835
836
-- Latvian
837
INSERT INTO language_subtag_registry( subtag, type, description, added)
838
VALUES ( 'lv', 'language', 'Latvian', '2017-04-21');
839
840
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
841
VALUES ( 'lv', 'lav');
842
843
INSERT INTO language_descriptions(subtag, type, lang, description)
844
VALUES ( 'lv', 'language', 'en', 'Latvian');
845
846
INSERT INTO language_descriptions(subtag, type, lang, description)
847
VALUES ( 'lv', 'language', 'lv', 'Latviešu valoda');
848
667
-- Maori
849
-- Maori
668
INSERT INTO language_subtag_registry( subtag, type, description, added)
850
INSERT INTO language_subtag_registry( subtag, type, description, added)
669
VALUES ( 'mi', 'language', 'Maori','2014-10-30');
851
VALUES ( 'mi', 'language', 'Maori','2014-10-30');
Lines 716-721 VALUES ( 'ms', 'language', 'ms', 'Bahasa melayu'); Link Here
716
INSERT INTO language_descriptions(subtag, type, lang, description)
898
INSERT INTO language_descriptions(subtag, type, lang, description)
717
VALUES ( 'ms', 'language', 'en', 'Malay');
899
VALUES ( 'ms', 'language', 'en', 'Malay');
718
900
901
-- Burmese
902
INSERT INTO language_subtag_registry( subtag, type, description, added)
903
VALUES ( 'my', 'language', 'Burmese', '2017-04-21');
904
905
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
906
VALUES ( 'my', 'bur');
907
908
INSERT INTO language_descriptions(subtag, type, lang, description)
909
VALUES ( 'my', 'language', 'en', 'Burmese');
910
911
INSERT INTO language_descriptions(subtag, type, lang, description)
912
VALUES ( 'my', 'language', 'my', 'မြန်မာစာ');
913
719
-- Norwegian (bokmål)
914
-- Norwegian (bokmål)
720
INSERT INTO language_subtag_registry( subtag, type, description, added)
915
INSERT INTO language_subtag_registry( subtag, type, description, added)
721
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
916
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
Lines 789-794 VALUES ( 'nn', 'language', 'fr', 'Norvégien nynorsk'); Link Here
789
INSERT INTO language_descriptions(subtag, type, lang, description)
984
INSERT INTO language_descriptions(subtag, type, lang, description)
790
VALUES ( 'nn', 'language', 'de', 'Norwegisch nynorsk');
985
VALUES ( 'nn', 'language', 'de', 'Norwegisch nynorsk');
791
986
987
-- Punjabi
988
INSERT INTO language_subtag_registry( subtag, type, description, added)
989
VALUES ( 'pa', 'language', 'Punjabi', '2017-04-21');
990
991
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
992
VALUES ( 'pa', 'pan');
993
994
INSERT INTO language_descriptions(subtag, type, lang, description)
995
VALUES ( 'pa', 'language', 'en', 'Punjabi');
996
997
INSERT INTO language_descriptions(subtag, type, lang, description)
998
VALUES ( 'pa', 'language', 'pa', 'پنجابی');
999
792
-- Pangwa
1000
-- Pangwa
793
INSERT INTO language_subtag_registry( subtag, type, description, added)
1001
INSERT INTO language_subtag_registry( subtag, type, description, added)
794
VALUES ( 'pbr', 'language', 'Pangwa','2014-10-30');
1002
VALUES ( 'pbr', 'language', 'Pangwa','2014-10-30');
Lines 834-839 VALUES ( 'prs', 'language', 'prs', 'درى'); Link Here
834
INSERT INTO language_descriptions(subtag, type, lang, description)
1042
INSERT INTO language_descriptions(subtag, type, lang, description)
835
VALUES ( 'prs', 'language', 'en', 'Dari');
1043
VALUES ( 'prs', 'language', 'en', 'Dari');
836
1044
1045
-- Pashto
1046
INSERT INTO language_subtag_registry( subtag, type, description, added)
1047
VALUES ( 'ps', 'language', 'Pashto', '2017-04-21');
1048
1049
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1050
VALUES ( 'ps', 'pus');
1051
1052
INSERT INTO language_descriptions(subtag, type, lang, description)
1053
VALUES ( 'ps', 'language', 'en', 'Pashto');
1054
1055
INSERT INTO language_descriptions(subtag, type, lang, description)
1056
VALUES ( 'ps', 'language', 'ps', 'پښتو');
1057
837
-- Portuguese
1058
-- Portuguese
838
INSERT INTO language_subtag_registry( subtag, type, description, added)
1059
INSERT INTO language_subtag_registry( subtag, type, description, added)
839
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
1060
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
Lines 853-858 VALUES ( 'pt', 'language', 'fr', 'Portugais'); Link Here
853
INSERT INTO language_descriptions(subtag, type, lang, description)
1074
INSERT INTO language_descriptions(subtag, type, lang, description)
854
VALUES ( 'pt', 'language', 'de', 'Portugiesisch');
1075
VALUES ( 'pt', 'language', 'de', 'Portugiesisch');
855
1076
1077
-- Finnish Kalo
1078
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1079
VALUES( 'rmf', 'rmf');
1080
1081
INSERT INTO language_descriptions(subtag, type, lang, description)
1082
VALUES( 'rmf', 'language', 'en', 'Finnish Kalo');
1083
1084
INSERT INTO language_descriptions(subtag, type, lang, description)
1085
VALUES( 'rmf', 'language', 'fi', 'Suomen romanikieli');
1086
1087
INSERT INTO language_descriptions(subtag, type, lang, description)
1088
VALUES( 'rmf', 'language', 'rmf', 'Fíntika Rómma');
1089
856
-- Romanian
1090
-- Romanian
857
INSERT INTO language_subtag_registry( subtag, type, description, added)
1091
INSERT INTO language_subtag_registry( subtag, type, description, added)
858
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
1092
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
Lines 904-909 VALUES ( 'rw', 'language', 'rw', 'Ikinyarwanda'); Link Here
904
INSERT INTO language_descriptions(subtag, type, lang, description)
1138
INSERT INTO language_descriptions(subtag, type, lang, description)
905
VALUES ( 'rw', 'language', 'en', 'Kinyarwanda');
1139
VALUES ( 'rw', 'language', 'en', 'Kinyarwanda');
906
1140
1141
-- Sanskrit
1142
INSERT INTO language_subtag_registry( subtag, type, description, added)
1143
VALUES ( 'sa', 'language', 'Sanskrit', '2017-04-21');
1144
1145
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1146
VALUES ( 'sa', 'san');
1147
1148
INSERT INTO language_descriptions(subtag, type, lang, description)
1149
VALUES ( 'sa', 'language', 'en', 'Sanskrit');
1150
1151
INSERT INTO language_descriptions(subtag, type, lang, description)
1152
VALUES ( 'sa', 'language', 'sa', 'saṃskṛtam');
1153
907
-- Sindhi
1154
-- Sindhi
908
INSERT INTO language_subtag_registry( subtag, type, description, added)
1155
INSERT INTO language_subtag_registry( subtag, type, description, added)
909
VALUES ( 'sd', 'language', 'Sindhi','2014-10-30');
1156
VALUES ( 'sd', 'language', 'Sindhi','2014-10-30');
Lines 943-948 VALUES ( 'sl', 'language', 'sl', 'Slovenščina'); Link Here
943
INSERT INTO language_descriptions(subtag, type, lang, description)
1190
INSERT INTO language_descriptions(subtag, type, lang, description)
944
VALUES ( 'sl', 'language', 'en', 'Slovene');
1191
VALUES ( 'sl', 'language', 'en', 'Slovene');
945
1192
1193
-- Akkala Sami
1194
INSERT INTO language_subtag_registry( subtag, type, description, added)
1195
VALUES ( 'sia', 'language', 'Akkala Sami', '2017-04-21');
1196
1197
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1198
VALUES ( 'sia', 'sia');
1199
1200
INSERT INTO language_descriptions(subtag, type, lang, description)
1201
VALUES ( 'sia', 'language', 'en', 'Akkala Sami');
1202
1203
INSERT INTO language_descriptions(subtag, type, lang, description)
1204
VALUES ( 'sia', 'language', 'sia', 'ču´kksuâlis');
1205
1206
-- Kildin Sami
1207
INSERT INTO language_subtag_registry( subtag, type, description, added)
1208
VALUES ( 'sjd', 'language', 'Kildin Sami', '2017-04-21');
1209
1210
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1211
VALUES ( 'sjd', 'sjd');
1212
1213
INSERT INTO language_descriptions(subtag, type, lang, description)
1214
VALUES ( 'sjd', 'language', 'en', 'Kildin Sami');
1215
1216
INSERT INTO language_descriptions(subtag, type, lang, description)
1217
VALUES ( 'sjd', 'language', 'sjd', 'Кӣллт са̄мь кӣлл');
1218
1219
-- Ter Sami
1220
INSERT INTO language_subtag_registry( subtag, type, description, added)
1221
VALUES ( 'sjt', 'language', 'Ter Sami', '2017-04-21');
1222
1223
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1224
VALUES ( 'sjt', 'sjt');
1225
1226
INSERT INTO language_descriptions(subtag, type, lang, description)
1227
VALUES ( 'sjt', 'language', 'en', 'Ter Sami');
1228
1229
INSERT INTO language_descriptions(subtag, type, lang, description)
1230
VALUES ( 'sjt', 'language', 'sjt', 'saa´mekiill');
1231
1232
-- Pite Sami
1233
INSERT INTO language_subtag_registry( subtag, type, description, added)
1234
VALUES ( 'sje', 'language', 'Pite Sami', '2017-04-21');
1235
1236
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1237
VALUES ( 'sje', 'sje');
1238
1239
INSERT INTO language_descriptions(subtag, type, lang, description)
1240
VALUES ( 'sje', 'language', 'en', 'Pite Sami');
1241
1242
INSERT INTO language_descriptions(subtag, type, lang, description)
1243
VALUES ( 'sje', 'language', 'sje', 'Bidumsámegiella');
1244
1245
-- Kemi Sami
1246
INSERT INTO language_subtag_registry( subtag, type, description, added)
1247
VALUES ( 'sjk', 'language', 'Kemi Sami', '2017-04-21');
1248
1249
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1250
VALUES ( 'sjk', 'sjk');
1251
1252
INSERT INTO language_descriptions(subtag, type, lang, description)
1253
VALUES ( 'sjk', 'language', 'en', 'Kemi Sami');
1254
1255
INSERT INTO language_descriptions(subtag, type, lang, description)
1256
VALUES ( 'sjk', 'language', 'sjk', 'samääškiela');
1257
1258
-- Ume Sami
1259
INSERT INTO language_subtag_registry( subtag, type, description, added)
1260
VALUES ( 'sju', 'language', 'Ume Sami', '2017-04-21');
1261
1262
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1263
VALUES ( 'sju', 'sju');
1264
1265
INSERT INTO language_descriptions(subtag, type, lang, description)
1266
VALUES ( 'sju', 'language', 'en', 'Ume Sami');
1267
1268
INSERT INTO language_descriptions(subtag, type, lang, description)
1269
VALUES ( 'sju', 'language', 'sju', 'Ubmejensámien giella');
1270
1271
-- Southern Sami
1272
INSERT INTO language_subtag_registry( subtag, type, description, added)
1273
VALUES ( 'sma', 'language', 'Southern Sami', '2017-04-21');
1274
1275
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1276
VALUES ( 'sma', 'sma');
1277
1278
INSERT INTO language_descriptions(subtag, type, lang, description)
1279
VALUES ( 'sma', 'language', 'en', 'Southern Sami');
1280
1281
INSERT INTO language_descriptions(subtag, type, lang, description)
1282
VALUES ( 'sma', 'language', 'sma', 'Åarjelsaemien gïele');
1283
1284
-- Northern Sami
1285
INSERT INTO language_subtag_registry( subtag, type, description, added)
1286
VALUES ( 'sme', 'language', 'Northern Sami', '2017-04-21');
1287
1288
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1289
VALUES ( 'sme', 'sme');
1290
1291
INSERT INTO language_descriptions(subtag, type, lang, description)
1292
VALUES ( 'sme', 'language', 'en', 'Northern Sami');
1293
1294
INSERT INTO language_descriptions(subtag, type, lang, description)
1295
VALUES ( 'sme', 'language', 'fi', 'pohjoissaame');
1296
1297
INSERT INTO language_descriptions(subtag, type, lang, description)
1298
VALUES ( 'sme', 'language', 'sv', 'Nordsamiska');
1299
1300
INSERT INTO language_descriptions(subtag, type, lang, description)
1301
VALUES ( 'sme', 'language', 'sme', 'davvisámegiella');
1302
1303
-- Sami languages
1304
INSERT INTO language_subtag_registry( subtag, type, description, added)
1305
VALUES ( 'smi', 'language', 'Sami languages', '2017-04-21');
1306
1307
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1308
VALUES ( 'smi', 'smi');
1309
1310
INSERT INTO language_descriptions(subtag, type, lang, description)
1311
VALUES ( 'smi', 'language', 'en', 'Sami languages');
1312
1313
INSERT INTO language_descriptions(subtag, type, lang, description)
1314
VALUES ( 'smi', 'language', 'fi', 'saamelaiskielet');
1315
1316
INSERT INTO language_descriptions(subtag, type, lang, description)
1317
VALUES ( 'smi', 'language', 'sv', 'Samiska');
1318
1319
INSERT INTO language_descriptions(subtag, type, lang, description)
1320
VALUES ( 'smi', 'language', 'smi', 'Saami');
1321
1322
-- Lule Sami
1323
INSERT INTO language_subtag_registry( subtag, type, description, added)
1324
VALUES ( 'smj', 'language', 'Lule Sami', '2017-04-21');
1325
1326
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1327
VALUES ( 'smj', 'smj');
1328
1329
INSERT INTO language_descriptions(subtag, type, lang, description)
1330
VALUES ( 'smj', 'language', 'en', 'Lule Sami');
1331
1332
INSERT INTO language_descriptions(subtag, type, lang, description)
1333
VALUES ( 'smj', 'language', 'smj', 'julevsámegiella');
1334
1335
-- Inari Sami
1336
INSERT INTO language_subtag_registry( subtag, type, description, added)
1337
VALUES ( 'smn', 'language', 'Inari Sami', '2017-04-21');
1338
1339
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1340
VALUES ( 'smn', 'smn');
1341
1342
INSERT INTO language_descriptions(subtag, type, lang, description)
1343
VALUES ( 'smn', 'language', 'en', 'Inari Sami');
1344
1345
INSERT INTO language_descriptions(subtag, type, lang, description)
1346
VALUES ( 'smn', 'language', 'smn', 'anarâškielâ');
1347
1348
-- Skolt Sami
1349
INSERT INTO language_subtag_registry( subtag, type, description, added)
1350
VALUES ( 'sms', 'language', 'Skolt Sami', '2017-04-21');
1351
1352
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1353
VALUES ( 'sms', 'sms');
1354
1355
INSERT INTO language_descriptions(subtag, type, lang, description)
1356
VALUES ( 'sms', 'language', 'en', 'Skolt Sami');
1357
1358
INSERT INTO language_descriptions(subtag, type, lang, description)
1359
VALUES ( 'sms', 'language', 'sms', 'sääʹmǩiõll');
1360
1361
-- Somali
1362
INSERT INTO language_subtag_registry( subtag, type, description, added)
1363
VALUES ( 'so', 'language', 'Somali', '2017-04-21');
1364
1365
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1366
VALUES ( 'so', 'som');
1367
1368
INSERT INTO language_descriptions(subtag, type, lang, description)
1369
VALUES ( 'so', 'language', 'en', 'Somali');
1370
1371
INSERT INTO language_descriptions(subtag, type, lang, description)
1372
VALUES ( 'so', 'language', 'so', 'Af-Soomaali');
1373
946
-- Albanian
1374
-- Albanian
947
INSERT INTO language_subtag_registry( subtag, type, description, added)
1375
INSERT INTO language_subtag_registry( subtag, type, description, added)
948
VALUES ( 'sq', 'language', 'Albanian','2014-10-30');
1376
VALUES ( 'sq', 'language', 'Albanian','2014-10-30');
Lines 975-980 VALUES ( 'sr', 'language', 'fr', 'Serbe'); Link Here
975
INSERT INTO language_descriptions(subtag, type, lang, description)
1403
INSERT INTO language_descriptions(subtag, type, lang, description)
976
VALUES ( 'sr', 'language', 'de', 'Serbisch');
1404
VALUES ( 'sr', 'language', 'de', 'Serbisch');
977
1405
1406
-- Sotho
1407
INSERT INTO language_subtag_registry( subtag, type, description, added)
1408
VALUES ( 'st', 'language', 'Sotho', '2017-04-21');
1409
1410
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1411
VALUES ( 'st', 'sot');
1412
1413
INSERT INTO language_descriptions(subtag, type, lang, description)
1414
VALUES ( 'st', 'language', 'en', 'Sotho');
1415
1416
INSERT INTO language_descriptions(subtag, type, lang, description)
1417
VALUES ( 'st', 'language', 'st', 'Sesotho');
1418
978
-- Swedish
1419
-- Swedish
979
INSERT INTO language_subtag_registry( subtag, type, description, added)
1420
INSERT INTO language_subtag_registry( subtag, type, description, added)
980
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
1421
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
Lines 1141-1146 VALUES ( 'vi', 'language', 'vi', '㗂越'); Link Here
1141
INSERT INTO language_descriptions(subtag, type, lang, description)
1582
INSERT INTO language_descriptions(subtag, type, lang, description)
1142
VALUES ( 'vi', 'language', 'en', 'Vietnamese');
1583
VALUES ( 'vi', 'language', 'en', 'Vietnamese');
1143
1584
1585
-- Votic
1586
INSERT INTO language_subtag_registry( subtag, type, description, added)
1587
VALUES ( 'vot', 'language', 'Votic', '2017-04-21');
1588
1589
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1590
VALUES ( 'vot', 'vot');
1591
1592
INSERT INTO language_descriptions(subtag, type, lang, description)
1593
VALUES ( 'vot', 'language', 'en', 'Votic');
1594
1595
INSERT INTO language_descriptions(subtag, type, lang, description)
1596
VALUES ( 'vot', 'language', 'vot', 'vađđa ceeli');
1597
1598
-- Yiddish
1599
INSERT INTO language_subtag_registry( subtag, type, description, added)
1600
VALUES ( 'yi', 'language', 'Yiddish', '2017-04-21');
1601
1602
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1603
VALUES ( 'yi', 'yid');
1604
1605
INSERT INTO language_descriptions(subtag, type, lang, description)
1606
VALUES ( 'yi', 'language', 'en', 'Yiddish');
1607
1608
INSERT INTO language_descriptions(subtag, type, lang, description)
1609
VALUES ( 'yi', 'language', 'yi', 'יידיש');
1610
1144
-- Chinese
1611
-- Chinese
1145
INSERT INTO language_subtag_registry( subtag, type, description, added)
1612
INSERT INTO language_subtag_registry( subtag, type, description, added)
1146
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
1613
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
1147
- 

Return to bug 18493