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 (-24 / +340 lines)
Lines 693-698 VALUES ( 'ka', 'language', 'es', 'Georgiano'); Link Here
693
INSERT INTO language_descriptions(subtag, type, lang, description)
693
INSERT INTO language_descriptions(subtag, type, lang, description)
694
VALUES ( 'ka', 'language', 'pl', 'Gruziński');
694
VALUES ( 'ka', 'language', 'pl', 'Gruziński');
695
695
696
-- Greenlandic
697
INSERT INTO language_subtag_registry( subtag, type, description, added)
698
VALUES ( 'kl', 'language', 'Greenlandic', '2017-04-21');
699
700
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
701
VALUES ( 'kl', 'kal');
702
703
INSERT INTO language_descriptions(subtag, type, lang, description)
704
VALUES ( 'kl', 'language', 'en', 'Greenlandic');
705
706
INSERT INTO language_descriptions(subtag, type, lang, description)
707
VALUES ( 'kl', 'language', 'kl', 'Kalaallisut');
708
696
-- Kannada
709
-- Kannada
697
INSERT INTO language_subtag_registry( subtag, type, description, added)
710
INSERT INTO language_subtag_registry( subtag, type, description, added)
698
VALUES ( 'kn', 'language', 'Kannada','2014-10-30');
711
VALUES ( 'kn', 'language', 'Kannada','2014-10-30');
Lines 750-755 VALUES ( 'ko', 'language', 'de', 'Koreanisch'); Link Here
750
INSERT INTO language_descriptions(subtag, type, lang, description)
763
INSERT INTO language_descriptions(subtag, type, lang, description)
751
VALUES ( 'ko', 'language', 'pl', 'Koreański');
764
VALUES ( 'ko', 'language', 'pl', 'Koreański');
752
765
766
-- Karelian
767
INSERT INTO language_subtag_registry( subtag, type, description, added)
768
VALUES ( 'krl', 'language', 'Karelian', '2017-04-21');
769
770
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
771
VALUES ( 'krl', 'krl');
772
773
INSERT INTO language_descriptions(subtag, type, lang, description)
774
VALUES ( 'krl', 'language', 'en', 'Karelian');
775
776
INSERT INTO language_descriptions(subtag, type, lang, description)
777
VALUES ( 'krl', 'language', 'krl', 'Karjala');
778
753
-- Kurdish
779
-- Kurdish
754
INSERT INTO language_subtag_registry( subtag, type, description, added)
780
INSERT INTO language_subtag_registry( subtag, type, description, added)
755
VALUES ( 'ku', 'language', 'Kurdish','2014-05-13');
781
VALUES ( 'ku', 'language', 'Kurdish','2014-05-13');
Lines 775-780 VALUES ( 'ku', 'language', 'es', 'Kurdo'); Link Here
775
INSERT INTO language_descriptions(subtag, type, lang, description)
801
INSERT INTO language_descriptions(subtag, type, lang, description)
776
VALUES ( 'ku', 'language', 'pl', 'Kurdyjski');
802
VALUES ( 'ku', 'language', 'pl', 'Kurdyjski');
777
803
804
-- Cornish
805
INSERT INTO language_subtag_registry( subtag, type, description, added)
806
VALUES ( 'kw', 'language', 'Cornish', '2017-04-21');
807
808
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
809
VALUES ( 'kw', 'cor');
810
811
INSERT INTO language_descriptions(subtag, type, lang, description)
812
VALUES ( 'kw', 'language', 'en', 'Cornish');
813
814
INSERT INTO language_descriptions(subtag, type, lang, description)
815
VALUES ( 'kw', 'language', 'kw', 'Kernowek');
816
778
-- Latin
817
-- Latin
779
INSERT INTO language_subtag_registry( subtag, type, description, added)
818
INSERT INTO language_subtag_registry( subtag, type, description, added)
780
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
819
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
Lines 895-900 VALUES ( 'ms', 'language', 'de', 'Malaiisch'); Link Here
895
INSERT INTO language_descriptions(subtag, type, lang, description)
934
INSERT INTO language_descriptions(subtag, type, lang, description)
896
VALUES ( 'ms', 'language', 'pl', 'Malajski');
935
VALUES ( 'ms', 'language', 'pl', 'Malajski');
897
936
937
-- Burmese
938
INSERT INTO language_subtag_registry( subtag, type, description, added)
939
VALUES ( 'my', 'language', 'Burmese', '2017-04-21');
940
941
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
942
VALUES ( 'my', 'bur');
943
944
INSERT INTO language_descriptions(subtag, type, lang, description)
945
VALUES ( 'my', 'language', 'en', 'Burmese');
946
947
INSERT INTO language_descriptions(subtag, type, lang, description)
948
VALUES ( 'my', 'language', 'my', 'မြန်မာစာ');
949
898
-- Norwegian (bokmål)
950
-- Norwegian (bokmål)
899
INSERT INTO language_subtag_registry( subtag, type, description, added)
951
INSERT INTO language_subtag_registry( subtag, type, description, added)
900
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
952
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
Lines 983-988 VALUES ( 'nn', 'language', 'de', 'Norwegisch nynorsk'); Link Here
983
INSERT INTO language_descriptions(subtag, type, lang, description)
1035
INSERT INTO language_descriptions(subtag, type, lang, description)
984
VALUES ( 'nn', 'language', 'pl', 'Norweski nynorsk');
1036
VALUES ( 'nn', 'language', 'pl', 'Norweski nynorsk');
985
1037
1038
-- Punjabi
1039
INSERT INTO language_subtag_registry( subtag, type, description, added)
1040
VALUES ( 'pa', 'language', 'Punjabi', '2017-04-21');
1041
1042
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1043
VALUES ( 'pa', 'pan');
1044
1045
INSERT INTO language_descriptions(subtag, type, lang, description)
1046
VALUES ( 'pa', 'language', 'en', 'Punjabi');
1047
1048
INSERT INTO language_descriptions(subtag, type, lang, description)
1049
VALUES ( 'pa', 'language', 'pa', 'پنجابی');
1050
986
-- Pangwa
1051
-- Pangwa
987
INSERT INTO language_subtag_registry( subtag, type, description, added)
1052
INSERT INTO language_subtag_registry( subtag, type, description, added)
988
VALUES ( 'pbr', 'language', 'Pangwa','2014-10-30');
1053
VALUES ( 'pbr', 'language', 'Pangwa','2014-10-30');
Lines 1034-1039 VALUES ( 'prs', 'language', 'en', 'Dari'); Link Here
1034
INSERT INTO language_descriptions(subtag, type, lang, description)
1099
INSERT INTO language_descriptions(subtag, type, lang, description)
1035
VALUES ( 'prs', 'language', 'de', 'Dari');
1100
VALUES ( 'prs', 'language', 'de', 'Dari');
1036
1101
1102
-- Pashto
1103
INSERT INTO language_subtag_registry( subtag, type, description, added)
1104
VALUES ( 'ps', 'language', 'Pashto', '2017-04-21');
1105
1106
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1107
VALUES ( 'ps', 'pus');
1108
1109
INSERT INTO language_descriptions(subtag, type, lang, description)
1110
VALUES ( 'ps', 'language', 'en', 'Pashto');
1111
1112
INSERT INTO language_descriptions(subtag, type, lang, description)
1113
VALUES ( 'ps', 'language', 'ps', 'پښتو');
1114
1037
-- Portuguese
1115
-- Portuguese
1038
INSERT INTO language_subtag_registry( subtag, type, description, added)
1116
INSERT INTO language_subtag_registry( subtag, type, description, added)
1039
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
1117
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
Lines 1056-1061 VALUES ( 'pt', 'language', 'de', 'Portugiesisch'); Link Here
1056
INSERT INTO language_descriptions(subtag, type, lang, description)
1134
INSERT INTO language_descriptions(subtag, type, lang, description)
1057
VALUES ( 'pt', 'language', 'pl', 'Portugalski');
1135
VALUES ( 'pt', 'language', 'pl', 'Portugalski');
1058
1136
1137
-- Finnish Kalo
1138
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1139
VALUES( 'rmf', 'rmf');
1140
1141
INSERT INTO language_descriptions(subtag, type, lang, description)
1142
VALUES( 'rmf', 'language', 'en', 'Finnish Kalo');
1143
1144
INSERT INTO language_descriptions(subtag, type, lang, description)
1145
VALUES( 'rmf', 'language', 'fi', 'Suomen romanikieli');
1146
1147
INSERT INTO language_descriptions(subtag, type, lang, description)
1148
VALUES( 'rmf', 'language', 'rmf', 'Fíntika Rómma');
1149
1059
-- Romanian
1150
-- Romanian
1060
INSERT INTO language_subtag_registry( subtag, type, description, added)
1151
INSERT INTO language_subtag_registry( subtag, type, description, added)
1061
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
1152
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
Lines 1176-1181 VALUES ( 'sl', 'language', 'de', 'Slowenisch'); Link Here
1176
INSERT INTO language_descriptions(subtag, type, lang, description)
1267
INSERT INTO language_descriptions(subtag, type, lang, description)
1177
VALUES ( 'sl', 'language', 'pl', 'Słoweński');
1268
VALUES ( 'sl', 'language', 'pl', 'Słoweński');
1178
1269
1270
-- Akkala Sami
1271
INSERT INTO language_subtag_registry( subtag, type, description, added)
1272
VALUES ( 'sia', 'language', 'Akkala Sami', '2017-04-21');
1273
1274
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1275
VALUES ( 'sia', 'sia');
1276
1277
INSERT INTO language_descriptions(subtag, type, lang, description)
1278
VALUES ( 'sia', 'language', 'en', 'Akkala Sami');
1279
1280
INSERT INTO language_descriptions(subtag, type, lang, description)
1281
VALUES ( 'sia', 'language', 'sia', 'ču´kksuâlis');
1282
1283
-- Kildin Sami
1284
INSERT INTO language_subtag_registry( subtag, type, description, added)
1285
VALUES ( 'sjd', 'language', 'Kildin Sami', '2017-04-21');
1286
1287
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1288
VALUES ( 'sjd', 'sjd');
1289
1290
INSERT INTO language_descriptions(subtag, type, lang, description)
1291
VALUES ( 'sjd', 'language', 'en', 'Kildin Sami');
1292
1293
INSERT INTO language_descriptions(subtag, type, lang, description)
1294
VALUES ( 'sjd', 'language', 'sjd', 'Кӣллт са̄мь кӣлл');
1295
1296
-- Ter Sami
1297
INSERT INTO language_subtag_registry( subtag, type, description, added)
1298
VALUES ( 'sjt', 'language', 'Ter Sami', '2017-04-21');
1299
1300
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1301
VALUES ( 'sjt', 'sjt');
1302
1303
INSERT INTO language_descriptions(subtag, type, lang, description)
1304
VALUES ( 'sjt', 'language', 'en', 'Ter Sami');
1305
1306
INSERT INTO language_descriptions(subtag, type, lang, description)
1307
VALUES ( 'sjt', 'language', 'sjt', 'saa´mekiill');
1308
1309
-- Pite Sami
1310
INSERT INTO language_subtag_registry( subtag, type, description, added)
1311
VALUES ( 'sje', 'language', 'Pite Sami', '2017-04-21');
1312
1313
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1314
VALUES ( 'sje', 'sje');
1315
1316
INSERT INTO language_descriptions(subtag, type, lang, description)
1317
VALUES ( 'sje', 'language', 'en', 'Pite Sami');
1318
1319
INSERT INTO language_descriptions(subtag, type, lang, description)
1320
VALUES ( 'sje', 'language', 'sje', 'Bidumsámegiella');
1321
1322
-- Kemi Sami
1323
INSERT INTO language_subtag_registry( subtag, type, description, added)
1324
VALUES ( 'sjk', 'language', 'Kemi Sami', '2017-04-21');
1325
1326
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1327
VALUES ( 'sjk', 'sjk');
1328
1329
INSERT INTO language_descriptions(subtag, type, lang, description)
1330
VALUES ( 'sjk', 'language', 'en', 'Kemi Sami');
1331
1332
INSERT INTO language_descriptions(subtag, type, lang, description)
1333
VALUES ( 'sjk', 'language', 'sjk', 'samääškiela');
1334
1335
-- Ume Sami
1336
INSERT INTO language_subtag_registry( subtag, type, description, added)
1337
VALUES ( 'sju', 'language', 'Ume Sami', '2017-04-21');
1338
1339
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1340
VALUES ( 'sju', 'sju');
1341
1342
INSERT INTO language_descriptions(subtag, type, lang, description)
1343
VALUES ( 'sju', 'language', 'en', 'Ume Sami');
1344
1345
INSERT INTO language_descriptions(subtag, type, lang, description)
1346
VALUES ( 'sju', 'language', 'sju', 'Ubmejensámien giella');
1347
1348
-- Southern Sami
1349
INSERT INTO language_subtag_registry( subtag, type, description, added)
1350
VALUES ( 'sma', 'language', 'Southern Sami', '2017-04-21');
1351
1352
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1353
VALUES ( 'sma', 'sma');
1354
1355
INSERT INTO language_descriptions(subtag, type, lang, description)
1356
VALUES ( 'sma', 'language', 'en', 'Southern Sami');
1357
1358
INSERT INTO language_descriptions(subtag, type, lang, description)
1359
VALUES ( 'sma', 'language', 'sma', 'Åarjelsaemien gïele');
1360
1361
-- Northern Sami
1362
INSERT INTO language_subtag_registry( subtag, type, description, added)
1363
VALUES ( 'sme', 'language', 'Northern Sami', '2017-04-21');
1364
1365
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1366
VALUES ( 'sme', 'sme');
1367
1368
INSERT INTO language_descriptions(subtag, type, lang, description)
1369
VALUES ( 'sme', 'language', 'en', 'Northern Sami');
1370
1371
INSERT INTO language_descriptions(subtag, type, lang, description)
1372
VALUES ( 'sme', 'language', 'fi', 'pohjoissaame');
1373
1374
INSERT INTO language_descriptions(subtag, type, lang, description)
1375
VALUES ( 'sme', 'language', 'sv', 'Nordsamiska');
1376
1377
INSERT INTO language_descriptions(subtag, type, lang, description)
1378
VALUES ( 'sme', 'language', 'sme', 'davvisámegiella');
1379
1380
-- Sami languages
1381
INSERT INTO language_subtag_registry( subtag, type, description, added)
1382
VALUES ( 'smi', 'language', 'Sami languages', '2017-04-21');
1383
1384
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1385
VALUES ( 'smi', 'smi');
1386
1387
INSERT INTO language_descriptions(subtag, type, lang, description)
1388
VALUES ( 'smi', 'language', 'en', 'Sami languages');
1389
1390
INSERT INTO language_descriptions(subtag, type, lang, description)
1391
VALUES ( 'smi', 'language', 'fi', 'saamelaiskielet');
1392
1393
INSERT INTO language_descriptions(subtag, type, lang, description)
1394
VALUES ( 'smi', 'language', 'sv', 'Samiska');
1395
1396
INSERT INTO language_descriptions(subtag, type, lang, description)
1397
VALUES ( 'smi', 'language', 'smi', 'Saami');
1398
1399
-- Lule Sami
1400
INSERT INTO language_subtag_registry( subtag, type, description, added)
1401
VALUES ( 'smj', 'language', 'Lule Sami', '2017-04-21');
1402
1403
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1404
VALUES ( 'smj', 'smj');
1405
1406
INSERT INTO language_descriptions(subtag, type, lang, description)
1407
VALUES ( 'smj', 'language', 'en', 'Lule Sami');
1408
1409
INSERT INTO language_descriptions(subtag, type, lang, description)
1410
VALUES ( 'smj', 'language', 'smj', 'julevsámegiella');
1411
1412
-- Inari Sami
1413
INSERT INTO language_subtag_registry( subtag, type, description, added)
1414
VALUES ( 'smn', 'language', 'Inari Sami', '2017-04-21');
1415
1416
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1417
VALUES ( 'smn', 'smn');
1418
1419
INSERT INTO language_descriptions(subtag, type, lang, description)
1420
VALUES ( 'smn', 'language', 'en', 'Inari Sami');
1421
1422
INSERT INTO language_descriptions(subtag, type, lang, description)
1423
VALUES ( 'smn', 'language', 'smn', 'anarâškielâ');
1424
1425
-- Skolt Sami
1426
INSERT INTO language_subtag_registry( subtag, type, description, added)
1427
VALUES ( 'sms', 'language', 'Skolt Sami', '2017-04-21');
1428
1429
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1430
VALUES ( 'sms', 'sms');
1431
1432
INSERT INTO language_descriptions(subtag, type, lang, description)
1433
VALUES ( 'sms', 'language', 'en', 'Skolt Sami');
1434
1435
INSERT INTO language_descriptions(subtag, type, lang, description)
1436
VALUES ( 'sms', 'language', 'sms', 'sääʹmǩiõll');
1437
1438
-- Somali
1439
INSERT INTO language_subtag_registry( subtag, type, description, added)
1440
VALUES ( 'so', 'language', 'Somali', '2017-04-21');
1441
1442
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1443
VALUES ( 'so', 'som');
1444
1445
INSERT INTO language_descriptions(subtag, type, lang, description)
1446
VALUES ( 'so', 'language', 'en', 'Somali');
1447
1448
INSERT INTO language_descriptions(subtag, type, lang, description)
1449
VALUES ( 'so', 'language', 'so', 'Af-Soomaali');
1450
1179
-- Albanian
1451
-- Albanian
1180
INSERT INTO language_subtag_registry( subtag, type, description, added)
1452
INSERT INTO language_subtag_registry( subtag, type, description, added)
1181
VALUES ( 'sq', 'language', 'Albanian','2014-10-30');
1453
VALUES ( 'sq', 'language', 'Albanian','2014-10-30');
Lines 1217-1222 VALUES ( 'sr', 'language', 'de', 'Serbisch'); Link Here
1217
INSERT INTO language_descriptions(subtag, type, lang, description)
1489
INSERT INTO language_descriptions(subtag, type, lang, description)
1218
VALUES ( 'sr', 'language', 'pl', 'Serbski');
1490
VALUES ( 'sr', 'language', 'pl', 'Serbski');
1219
1491
1492
-- Sotho
1493
INSERT INTO language_subtag_registry( subtag, type, description, added)
1494
VALUES ( 'st', 'language', 'Sotho', '2017-04-21');
1495
1496
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1497
VALUES ( 'st', 'sot');
1498
1499
INSERT INTO language_descriptions(subtag, type, lang, description)
1500
VALUES ( 'st', 'language', 'en', 'Sotho');
1501
1502
INSERT INTO language_descriptions(subtag, type, lang, description)
1503
VALUES ( 'st', 'language', 'st', 'Sesotho');
1504
1220
-- Swedish
1505
-- Swedish
1221
INSERT INTO language_subtag_registry( subtag, type, description, added)
1506
INSERT INTO language_subtag_registry( subtag, type, description, added)
1222
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
1507
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
Lines 1425-1430 VALUES ( 'vi', 'language', 'de', 'Vietnamesisch'); Link Here
1425
INSERT INTO language_descriptions(subtag, type, lang, description)
1710
INSERT INTO language_descriptions(subtag, type, lang, description)
1426
VALUES ( 'vi', 'language', 'pl', 'Wietnamski');
1711
VALUES ( 'vi', 'language', 'pl', 'Wietnamski');
1427
1712
1713
-- Votic
1714
INSERT INTO language_subtag_registry( subtag, type, description, added)
1715
VALUES ( 'vot', 'language', 'Votic', '2017-04-21');
1716
1717
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1718
VALUES ( 'vot', 'vot');
1719
1720
INSERT INTO language_descriptions(subtag, type, lang, description)
1721
VALUES ( 'vot', 'language', 'en', 'Votic');
1722
1723
INSERT INTO language_descriptions(subtag, type, lang, description)
1724
VALUES ( 'vot', 'language', 'vot', 'vađđa ceeli');
1725
1428
-- Chinese
1726
-- Chinese
1429
INSERT INTO language_subtag_registry( subtag, type, description, added)
1727
INSERT INTO language_subtag_registry( subtag, type, description, added)
1430
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
1728
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
Lines 2116-2122 INSERT INTO language_descriptions (subtag, type, lang, description) Link Here
2116
VALUES ('et', 'language', 'de', 'Estnisch');
2414
VALUES ('et', 'language', 'de', 'Estnisch');
2117
2415
2118
INSERT INTO language_subtag_registry (subtag, type, description, added)
2416
INSERT INTO language_subtag_registry (subtag, type, description, added)
2119
VALUES ('et', 'language', 'Estonian', now());
2417
VALUES ('et', 'language', 'Estonian', NOW() );
2120
2418
2121
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
2419
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
2122
VALUES ('et', 'est');
2420
VALUES ('et', 'est');
Lines 2126-2133 VALUES ('et', 'est'); Link Here
2126
INSERT INTO language_descriptions (subtag, type, lang, description)
2424
INSERT INTO language_descriptions (subtag, type, lang, description)
2127
VALUES ('lv', 'language', 'en', 'Latvian');
2425
VALUES ('lv', 'language', 'en', 'Latvian');
2128
2426
2129
INSERT INTO language_descriptions (subtag, type, lang, description)
2427
INSERT INTO language_descriptionsn (subtag, type, lang, description)
2130
VALUES ('lv', 'language', 'lv', 'Latvija');
2428
VALUES ( 'lv', 'language', 'lv', 'Latviešu valoda');
2131
2429
2132
INSERT INTO language_descriptions (subtag, type, lang, description)
2430
INSERT INTO language_descriptions (subtag, type, lang, description)
2133
VALUES ('lv', 'language', 'de', 'Lettisch');
2431
VALUES ('lv', 'language', 'de', 'Lettisch');
Lines 2138-2150 VALUES ('lv', 'language', 'Latvian', now()); Link Here
2138
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
2436
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
2139
VALUES ('lv', 'lav');
2437
VALUES ('lv', 'lav');
2140
2438
2141
-- Lithianian
2439
-- Lithuanian
2142
2440
2143
INSERT INTO language_descriptions (subtag, type, lang, description)
2441
INSERT INTO language_descriptions (subtag, type, lang, description)
2144
VALUES ('lt', 'language', 'en', 'Lithuanian');
2442
VALUES ('lt', 'language', 'en', 'Lithuanian');
2145
2443
2146
INSERT INTO language_descriptions (subtag, type, lang, description)
2444
INSERT INTO language_descriptions (subtag, type, lang, description)
2147
VALUES ('lt', 'language', 'lt', 'Lietuvių');
2445
VALUES ('lt', 'language', 'lt', 'Lietuvių kalba');
2148
2446
2149
INSERT INTO language_descriptions (subtag, type, lang, description)
2447
INSERT INTO language_descriptions (subtag, type, lang, description)
2150
VALUES ('lt', 'language', 'de', 'Litauisch');
2448
VALUES ('lt', 'language', 'de', 'Litauisch');
Lines 2195-2216 INSERT INTO language_subtag_registry( subtag, type, description, added) Link Here
2195
VALUES ( 'yi', 'language', 'Yiddish', NOW() );
2493
VALUES ( 'yi', 'language', 'Yiddish', NOW() );
2196
2494
2197
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
2495
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
2198
VALUES ( 'yi','yid');
2496
VALUES ( 'yi', 'yid');
2199
2497
2200
INSERT INTO language_descriptions(subtag, type, lang, description)
2498
INSERT INTO language_descriptions(subtag, type, lang, description)
2201
VALUES ( 'yi', 'language', 'de', 'Jiddisch');
2499
VALUES ( 'yi', 'language', 'en', 'Yiddish');
2202
2500
2203
INSERT INTO language_descriptions(subtag, type, lang, description)
2501
INSERT INTO language_descriptions(subtag, type, lang, description)
2204
VALUES ( 'yi', 'language', 'en', 'Yiddish');
2502
VALUES ( 'yi', 'language', 'yi', 'יידיש');
2205
2503
2206
INSERT INTO language_descriptions(subtag, type, lang, description)
2504
INSERT INTO language_descriptions(subtag, type, lang, description)
2207
VALUES ( 'yi', 'language', 'es', 'Yidis');
2505
VALUES ( 'yi', 'language', 'de', 'Jiddisch');
2208
2506
2209
INSERT INTO language_descriptions(subtag, type, lang, description)
2507
INSERT INTO language_descriptions(subtag, type, lang, description)
2210
VALUES ( 'yi', 'language', 'fr', 'Yiddish');
2508
VALUES ( 'yi', 'language', 'es', 'Yidis');
2211
2509
2212
INSERT INTO language_descriptions(subtag, type, lang, description)
2510
INSERT INTO language_descriptions(subtag, type, lang, description)
2213
VALUES ( 'yi', 'language', 'yi', 'יידיש');
2511
VALUES ( 'yi', 'language', 'fr', 'Yiddish');
2214
2512
2215
INSERT INTO language_descriptions(subtag, type, lang, description)
2513
INSERT INTO language_descriptions(subtag, type, lang, description)
2216
VALUES ( 'yi', 'language', 'pl', 'Jidysz');
2514
VALUES ( 'yi', 'language', 'pl', 'Jidysz');
Lines 2327-2333 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) Link Here
2327
VALUES ( 'grc','grc');
2625
VALUES ( 'grc','grc');
2328
2626
2329
INSERT INTO language_descriptions(subtag, type, lang, description)
2627
INSERT INTO language_descriptions(subtag, type, lang, description)
2330
VALUES ( 'grc', 'language', 'en', 'Greek, Ancient (to 1453)');
2628
VALUES ( 'grc', 'language', 'en', 'Ancient Greek (to 1453)');
2629
2630
INSERT INTO language_descriptions(subtag, type, lang, description)
2631
VALUES ( 'grc', 'language', 'grc', 'Ἑλληνική');
2331
2632
2332
INSERT INTO language_descriptions(subtag, type, lang, description)
2633
INSERT INTO language_descriptions(subtag, type, lang, description)
2333
VALUES ( 'grc', 'language', 'pl', 'Grecki starożytny (do 1453)');
2634
VALUES ( 'grc', 'language', 'pl', 'Grecki starożytny (do 1453)');
Lines 2403-2409 INSERT INTO language_descriptions(subtag, type, lang, description) Link Here
2403
VALUES ( 'ang', 'language', 'pl', 'Staroangielski (ok. 450-1100)');
2704
VALUES ( 'ang', 'language', 'pl', 'Staroangielski (ok. 450-1100)');
2404
2705
2405
-- Esperanto
2706
-- Esperanto
2406
2407
INSERT INTO language_subtag_registry( subtag, type, description, added)
2707
INSERT INTO language_subtag_registry( subtag, type, description, added)
2408
VALUES ( 'eo', 'language', 'Esperanto', NOW() );
2708
VALUES ( 'eo', 'language', 'Esperanto', NOW() );
2409
2709
Lines 2413-2418 VALUES ( 'eo','epo'); Link Here
2413
INSERT INTO language_descriptions(subtag, type, lang, description)
2713
INSERT INTO language_descriptions(subtag, type, lang, description)
2414
VALUES ( 'eo', 'language', 'en', 'Esperanto');
2714
VALUES ( 'eo', 'language', 'en', 'Esperanto');
2415
2715
2716
INSERT INTO language_descriptions(subtag, type, lang, description)
2717
VALUES ( 'eo', 'language', 'eo', 'Esperanto');
2718
2416
INSERT INTO language_descriptions(subtag, type, lang, description)
2719
INSERT INTO language_descriptions(subtag, type, lang, description)
2417
VALUES ( 'eo', 'language', 'pl', 'Esperanto');
2720
VALUES ( 'eo', 'language', 'pl', 'Esperanto');
2418
2721
Lines 2459-2474 INSERT INTO language_descriptions(subtag, type, lang, description) Link Here
2459
VALUES ( 'sla', 'language', 'pl', 'Słowiańskie (inne)');
2762
VALUES ( 'sla', 'language', 'pl', 'Słowiańskie (inne)');
2460
2763
2461
-- Sanskrit
2764
-- Sanskrit
2462
2463
INSERT INTO language_subtag_registry( subtag, type, description, added)
2765
INSERT INTO language_subtag_registry( subtag, type, description, added)
2464
VALUES ( 'sa', 'language', 'Sanskrit', NOW() );
2766
VALUES ( 'sa', 'language', 'Sanskrit', NOW() );
2465
2767
2466
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
2768
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
2467
VALUES ( 'sa','san');
2769
VALUES ( 'sa', 'san');
2468
2770
2469
INSERT INTO language_descriptions(subtag, type, lang, description)
2771
INSERT INTO language_descriptions(subtag, type, lang, description)
2470
VALUES ( 'sa', 'language', 'en', 'Sanskrit');
2772
VALUES ( 'sa', 'language', 'en', 'Sanskrit');
2471
2773
2774
INSERT INTO language_descriptions(subtag, type, lang, description)
2775
VALUES ( 'sa', 'language', 'sa', 'saṃskṛtam');
2776
2472
INSERT INTO language_descriptions(subtag, type, lang, description)
2777
INSERT INTO language_descriptions(subtag, type, lang, description)
2473
VALUES ( 'sa', 'language', 'pl', 'Sanskryt');
2778
VALUES ( 'sa', 'language', 'pl', 'Sanskryt');
2474
2779
Lines 2542-2549 VALUES ( 'wen', 'language', 'en', 'Sorbian (Other)'); Link Here
2542
INSERT INTO language_descriptions(subtag, type, lang, description)
2847
INSERT INTO language_descriptions(subtag, type, lang, description)
2543
VALUES ( 'wen', 'language', 'pl', 'Łużyckie (inne)');
2848
VALUES ( 'wen', 'language', 'pl', 'Łużyckie (inne)');
2544
2849
2545
-- Irish
2850
-- Irish Gaelic
2546
2547
INSERT INTO language_subtag_registry( subtag, type, description, added)
2851
INSERT INTO language_subtag_registry( subtag, type, description, added)
2548
VALUES ( 'ga', 'language', 'Irish', NOW() );
2852
VALUES ( 'ga', 'language', 'Irish', NOW() );
2549
2853
Lines 2553-2558 VALUES ( 'ga','gle'); Link Here
2553
INSERT INTO language_descriptions(subtag, type, lang, description)
2857
INSERT INTO language_descriptions(subtag, type, lang, description)
2554
VALUES ( 'ga', 'language', 'en', 'Irish');
2858
VALUES ( 'ga', 'language', 'en', 'Irish');
2555
2859
2860
INSERT INTO language_descriptions(subtag, type, lang, description)
2861
VALUES ( 'ga', 'language', 'ga', 'Gaeilge');
2862
2556
INSERT INTO language_descriptions(subtag, type, lang, description)
2863
INSERT INTO language_descriptions(subtag, type, lang, description)
2557
VALUES ( 'ga', 'language', 'pl', 'Irlandzki');
2864
VALUES ( 'ga', 'language', 'pl', 'Irlandzki');
2558
2865
Lines 2685-2691 VALUES ( 'pi', 'language', 'pl', 'Pali'); Link Here
2685
-- Bosnian
2992
-- Bosnian
2686
2993
2687
INSERT INTO language_subtag_registry( subtag, type, description, added)
2994
INSERT INTO language_subtag_registry( subtag, type, description, added)
2688
VALUES ( 'bs', 'language', 'Bosnian', NOW() );
2995
VALUES ( 'bs', 'language', 'Bosnian', '2017-04-21');
2689
2996
2690
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
2997
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
2691
VALUES ( 'bs','bos');
2998
VALUES ( 'bs','bos');
Lines 2693-2698 VALUES ( 'bs','bos'); Link Here
2693
INSERT INTO language_descriptions(subtag, type, lang, description)
3000
INSERT INTO language_descriptions(subtag, type, lang, description)
2694
VALUES ( 'bs', 'language', 'en', 'Bosnian');
3001
VALUES ( 'bs', 'language', 'en', 'Bosnian');
2695
3002
3003
INSERT INTO language_descriptions(subtag, type, lang, description)
3004
VALUES ( 'bs', 'language', 'bn', 'Bosanski');
3005
2696
INSERT INTO language_descriptions(subtag, type, lang, description)
3006
INSERT INTO language_descriptions(subtag, type, lang, description)
2697
VALUES ( 'bs', 'language', 'pl', 'Bośniacki');
3007
VALUES ( 'bs', 'language', 'pl', 'Bośniacki');
2698
3008
Lines 2736-2753 INSERT INTO language_descriptions(subtag, type, lang, description) Link Here
2736
VALUES ( 'kk', 'language', 'en', 'Kazakh');
3046
VALUES ( 'kk', 'language', 'en', 'Kazakh');
2737
3047
2738
INSERT INTO language_descriptions(subtag, type, lang, description)
3048
INSERT INTO language_descriptions(subtag, type, lang, description)
2739
VALUES ( 'kk', 'language', 'pl', 'Kazachski');
3049
VALUES ( 'kk', 'language', 'kk', 'қазақ тілі');
2740
3050
2741
-- Tibetan
3051
INSERT INTO language_descriptions(subtag, type, lang, description)
3052
VALUES ( 'kk', 'language', 'pl', 'Kazachski');
2742
3053
3054
-- Standard Tibetan
2743
INSERT INTO language_subtag_registry( subtag, type, description, added)
3055
INSERT INTO language_subtag_registry( subtag, type, description, added)
2744
VALUES ( 'bo', 'language', 'Tibetan', NOW() );
3056
VALUES ( 'bo', 'language', 'Standard Tibetan', '2017-04-21');
2745
3057
2746
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
3058
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
2747
VALUES ( 'bo','tib');
3059
VALUES ( 'bo','tib');
2748
3060
2749
INSERT INTO language_descriptions(subtag, type, lang, description)
3061
INSERT INTO language_descriptions(subtag, type, lang, description)
2750
VALUES ( 'bo', 'language', 'en', 'Tibetan');
3062
VALUES ( 'bo', 'language', 'en', 'Standard Tibetan');
3063
3064
INSERT INTO language_descriptions(subtag, type, lang, description)
3065
VALUES ( 'bo', 'language', 'bo', 'ལྷ་སའི་སྐད་');
2751
3066
2752
INSERT INTO language_descriptions(subtag, type, lang, description)
3067
INSERT INTO language_descriptions(subtag, type, lang, description)
2753
VALUES ( 'bo', 'language', 'pl', 'Tybetański');
3068
VALUES ( 'bo', 'language', 'pl', 'Tybetański');
Lines 3184-3190 INSERT INTO language_descriptions(subtag, type, lang, description) Link Here
3184
VALUES ( 'tt', 'language', 'pl', 'Tatarski');
3499
VALUES ( 'tt', 'language', 'pl', 'Tatarski');
3185
3500
3186
-- Welsh
3501
-- Welsh
3187
3188
INSERT INTO language_subtag_registry( subtag, type, description, added)
3502
INSERT INTO language_subtag_registry( subtag, type, description, added)
3189
VALUES ( 'cy', 'language', 'Welsh', NOW() );
3503
VALUES ( 'cy', 'language', 'Welsh', NOW() );
3190
3504
Lines 3194-3199 VALUES ( 'cy','wel'); Link Here
3194
INSERT INTO language_descriptions(subtag, type, lang, description)
3508
INSERT INTO language_descriptions(subtag, type, lang, description)
3195
VALUES ( 'cy', 'language', 'en', 'Welsh');
3509
VALUES ( 'cy', 'language', 'en', 'Welsh');
3196
3510
3511
INSERT INTO language_descriptions(subtag, type, lang, description)
3512
VALUES ( 'cy', 'language', 'cy', 'Cymraeg');
3513
3197
INSERT INTO language_descriptions(subtag, type, lang, description)
3514
INSERT INTO language_descriptions(subtag, type, lang, description)
3198
VALUES ( 'cy', 'language', 'pl', 'Walijski');
3515
VALUES ( 'cy', 'language', 'pl', 'Walijski');
3199
3516
3200
- 

Return to bug 18493