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

(-)a/installer/data/mysql/atomicupdate/bug_15067-add_newlanguages.sql (+19 lines)
Lines 1-15 Link Here
1
-- Estonian
2
1
INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('et', 'language', 'Estonian', now());
3
INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('et', 'language', 'Estonian', now());
2
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('et', 'language', 'en', 'Estonian');
4
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('et', 'language', 'en', 'Estonian');
5
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('et', 'language', 'et', 'Eesti');
3
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('et', 'est');
6
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('et', 'est');
7
8
-- Latvian
9
4
INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('lv', 'language', 'Latvian', now());
10
INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('lv', 'language', 'Latvian', now());
5
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('lv', 'language', 'en', 'Latvian');
11
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('lv', 'language', 'en', 'Latvian');
12
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('lv', 'language', 'lv', 'Latvija');
6
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('lv', 'lav');
13
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('lv', 'lav');
14
15
-- Lithuanian
16
7
INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('lt', 'language', 'Lithuanian', now());
17
INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('lt', 'language', 'Lithuanian', now());
8
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('lt', 'language', 'en', 'Lithuanian');
18
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('lt', 'language', 'en', 'Lithuanian');
19
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('lt', 'language', 'lt', 'Lietuvių');
9
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('lt', 'lit');
20
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('lt', 'lit');
21
22
-- Inuktitut
23
10
INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('iu', 'language', 'Inuktitut', now());
24
INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('iu', 'language', 'Inuktitut', now());
11
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('iu', 'language', 'en', 'Inuktitut');
25
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('iu', 'language', 'en', 'Inuktitut');
26
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('iu', 'language', 'iu', 'ᐃᓄᒃᑎᑐᑦ');
12
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('iu', 'iku');
27
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('iu', 'iku');
28
29
-- Inupiaq
30
13
INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('ik', 'language', 'Inupiaq', now());
31
INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('ik', 'language', 'Inupiaq', now());
14
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('ik', 'language', 'en', 'Inupiaq');
32
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('ik', 'language', 'en', 'Inupiaq');
33
INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('ik', 'language', 'ik', 'Iñupiaq');
15
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('ik', 'ipk');
34
INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('ik', 'ipk');
(-)a/installer/data/mysql/mandatory/subtag_registry.sql (-1 / +15 lines)
Lines 1810-1815 VALUES ( 'VN', 'region', 'vi', 'Việt Nam'); Link Here
1810
INSERT INTO language_descriptions (subtag, type, lang, description)
1810
INSERT INTO language_descriptions (subtag, type, lang, description)
1811
VALUES ('et', 'language', 'en', 'Estonian');
1811
VALUES ('et', 'language', 'en', 'Estonian');
1812
1812
1813
INSERT INTO language_descriptions (subtag, type, lang, description)
1814
VALUES ('et', 'language', 'et', 'Eesti');
1815
1813
INSERT INTO language_subtag_registry (subtag, type, description, added)
1816
INSERT INTO language_subtag_registry (subtag, type, description, added)
1814
VALUES ('et', 'language', 'Estonian', now());
1817
VALUES ('et', 'language', 'Estonian', now());
1815
1818
Lines 1821-1826 VALUES ('et', 'est'); Link Here
1821
INSERT INTO language_descriptions (subtag, type, lang, description)
1824
INSERT INTO language_descriptions (subtag, type, lang, description)
1822
VALUES ('lv', 'language', 'en', 'Latvian');
1825
VALUES ('lv', 'language', 'en', 'Latvian');
1823
1826
1827
INSERT INTO language_descriptions (subtag, type, lang, description)
1828
VALUES ('lv', 'language', 'lv', 'Latvija');
1829
1824
INSERT INTO language_subtag_registry (subtag, type, description, added)
1830
INSERT INTO language_subtag_registry (subtag, type, description, added)
1825
VALUES ('lv', 'language', 'Latvian', now());
1831
VALUES ('lv', 'language', 'Latvian', now());
1826
1832
Lines 1832-1837 VALUES ('lv', 'lav'); Link Here
1832
INSERT INTO language_descriptions (subtag, type, lang, description)
1838
INSERT INTO language_descriptions (subtag, type, lang, description)
1833
VALUES ('lt', 'language', 'en', 'Lithuanian');
1839
VALUES ('lt', 'language', 'en', 'Lithuanian');
1834
1840
1841
INSERT INTO language_descriptions (subtag, type, lang, description)
1842
VALUES ('lt', 'language', 'lt', 'Lietuvių');
1843
1835
INSERT INTO language_subtag_registry (subtag, type, description, added)
1844
INSERT INTO language_subtag_registry (subtag, type, description, added)
1836
VALUES ('lt', 'language', 'Lithuanian', now());
1845
VALUES ('lt', 'language', 'Lithuanian', now());
1837
1846
Lines 1843-1848 VALUES ('lt', 'lit'); Link Here
1843
INSERT INTO language_descriptions (subtag, type, lang, description)
1852
INSERT INTO language_descriptions (subtag, type, lang, description)
1844
VALUES ('iu', 'language', 'en', 'Inuktitut');
1853
VALUES ('iu', 'language', 'en', 'Inuktitut');
1845
1854
1855
INSERT INTO language_descriptions (subtag, type, lang, description)
1856
VALUES ('iu', 'language', 'iu', 'ᐃᓄᒃᑎᑐᑦ');
1857
1846
INSERT INTO language_subtag_registry (subtag, type, description, added)
1858
INSERT INTO language_subtag_registry (subtag, type, description, added)
1847
VALUES ('iu', 'language', 'Inuktitut', now());
1859
VALUES ('iu', 'language', 'Inuktitut', now());
1848
1860
Lines 1854-1859 VALUES ('iu', 'iku'); Link Here
1854
INSERT INTO language_descriptions (subtag, type, lang, description)
1866
INSERT INTO language_descriptions (subtag, type, lang, description)
1855
VALUES ('ik', 'language', 'en', 'Inupiaq');
1867
VALUES ('ik', 'language', 'en', 'Inupiaq');
1856
1868
1869
INSERT INTO language_descriptions (subtag, type, lang, description)
1870
VALUES ('ik', 'language', 'ik', 'Iñupiaq');
1871
1857
INSERT INTO language_subtag_registry (subtag, type, description, added)
1872
INSERT INTO language_subtag_registry (subtag, type, description, added)
1858
VALUES ('ik', 'language', 'Inupiaq', now());
1873
VALUES ('ik', 'language', 'Inupiaq', now());
1859
1874
1860
- 

Return to bug 15067