1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
--
-- Taginfo
--
-- languages.sql
--
.bail ON
--
-- Contains all the languages Taginfo knows about.
--
DROP TABLE IF EXISTS languages;
CREATE TABLE languages (
code VARCHAR,
iso639_1 VARCHAR, -- official ISO 639-1 code (if available)
english_name VARCHAR,
native_name VARCHAR,
wiki_key_pages INTEGER, -- count of wiki pages with the title "code:Key:*" (or "Key:*" for code='en')
wiki_tag_pages INTEGER -- count of wiki pages with the title "code:Tag:*" (or "Tag:*" for code='en')
);
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('ar', 'ar', 'Arabic', 'العربية');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('az', 'az', 'Azerbaijani', 'Azərbaycan dili');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('bg', 'bg', 'Bulgarian', 'Български език');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('ca', 'ca', 'Catalan', 'Català');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('cs', 'cs', 'Czech', 'Čeština');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('cz', 'cz', 'Czech', 'Česky');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('da', 'da', 'Danish', 'Dansk');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('de', 'de', 'German', 'Deutsch');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('el', 'el', 'Greek', 'Ελληνικά');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('en', 'en', 'English', 'English');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('es', 'es', 'Spanish', 'Español');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('et', 'et', 'Estonian', 'Eesti');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('fi', 'fi', 'Finish', 'Suomi');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('fr', 'fr', 'French', 'Français');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('he', 'he', 'Hebrew', 'עברית');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('hr', 'hr', 'Croatian', 'Hrvatski');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('ht', 'ht', 'Haitian Creole', 'Kreyòl ayisyen');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('hu', 'hu', 'Hungarian', 'Magyar');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('it', 'it', 'Italian', 'Italiano');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('ja', 'ja', 'Japanese', '日本語');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('ko', 'ko', 'Korean', '한국어 (韓國語)');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('lt', 'lt', 'Lithuanian', 'Lietuvių Kalba');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('lv', 'lv', 'Latvian', 'Latviešu Valoda');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('nl', 'nl', 'Dutch', 'Nederlands');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('no', 'no', 'Norwegian', 'Norsk');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('pl', 'pl', 'Polish', 'Polski');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('pt', 'pt', 'Portuguese', 'Português');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('pt-BR', NULL, 'Brazilian Portuguese', 'Português do Brasil');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('ro', 'ro', 'Romanian', 'Română');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('ro-md', NULL, 'Moldovan', 'Română (Moldova)');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('ru', 'ru', 'Russian', 'Русский');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('sk', 'sk', 'Slovak', 'Slovenský');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('sq', 'sq', 'Albanian', 'Shqip');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('sv', 'sv', 'Swedish', 'Svenska');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('tr', 'tr', 'Turkish', 'Türkçe');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('uk', 'uk', 'Ukrainian', 'Українська');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('vi', 'vi', 'Vietnamese', 'Tiếng Việt');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('zh', 'zh', 'Chinese', '中文');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('zh-hans', NULL, 'Simplified Chinese', '简体中文');
INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('zh-hant', NULL, 'Traditional Chinese', '繁體中文');
-- INSERT INTO languages (code, iso639_1, english_name, native_name) VALUES ('', '', '', '');
|