· 5 years ago · Jul 09, 2020, 06:32 AM
1
2DROP TABLE IF EXISTS `wp_icl_languages`;
3CREATE TABLE `wp_icl_languages` (
4 `id` int(11) NOT NULL AUTO_INCREMENT,
5 `code` varchar(7) NOT NULL,
6 `english_name` varchar(128) NOT NULL,
7 `major` tinyint(4) NOT NULL DEFAULT '0',
8 `active` tinyint(4) NOT NULL,
9 `default_locale` varchar(35) DEFAULT NULL,
10 `tag` varchar(35) DEFAULT NULL,
11 `encode_url` tinyint(1) NOT NULL DEFAULT '0',
12 PRIMARY KEY (`id`),
13 UNIQUE KEY `code` (`code`),
14 UNIQUE KEY `english_name` (`english_name`)
15) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;
16
17INSERT INTO `wp_icl_languages` (`id`, `code`, `english_name`, `major`, `active`, `default_locale`, `tag`, `encode_url`) VALUES
18(1, 'en', 'English', 1, 1, 'en_US', 'en', 0),
19(2, 'es', 'Spanish', 1, 0, 'es_ES', 'es', 0),
20(3, 'de', 'German', 1, 0, 'de_DE', 'de', 0),
21(4, 'fr', 'French', 1, 0, 'fr_FR', 'fr', 0),
22(5, 'ar', 'Arabic', 0, 0, 'ar', 'ar', 0),
23(6, 'bs', 'Bosnian', 0, 0, 'bs_BA', 'bs', 0),
24(7, 'bg', 'Bulgarian', 0, 0, 'bg_BG', 'bg', 0),
25(8, 'ca', 'Catalan', 0, 0, 'ca', 'ca', 0),
26(9, 'cs', 'Czech', 0, 0, 'cs_CZ', 'cs', 0),
27(10, 'sk', 'Slovak', 0, 0, 'sk_SK', 'sk', 0),
28(11, 'cy', 'Welsh', 0, 0, 'cy_GB', 'cy', 0),
29(12, 'da', 'Danish', 1, 0, 'da_DK', 'da', 0),
30(13, 'el', 'Greek', 0, 0, 'el', 'el', 0),
31(14, 'eo', 'Esperanto', 0, 0, 'eo_UY', 'eo', 0),
32(15, 'et', 'Estonian', 0, 0, 'et', 'et', 0),
33(16, 'eu', 'Basque', 0, 0, 'eu_ES', 'eu', 0),
34(17, 'fa', 'Persian', 0, 0, 'fa_IR', 'fa', 0),
35(18, 'fi', 'Finnish', 0, 0, 'fi', 'fi', 0),
36(19, 'ga', 'Irish', 0, 0, 'ga_IE', 'ga', 0),
37(20, 'he', 'Hebrew', 0, 0, 'he_IL', 'he', 0),
38(21, 'hi', 'Hindi', 0, 0, 'hi_IN', 'hi', 0),
39(22, 'hr', 'Croatian', 0, 0, 'hr', 'hr', 0),
40(23, 'hu', 'Hungarian', 0, 0, 'hu_HU', 'hu', 0),
41(24, 'hy', 'Armenian', 0, 0, 'hy_AM', 'hy', 0),
42(25, 'id', 'Indonesian', 0, 0, 'id_ID', 'id', 0),
43(26, 'is', 'Icelandic', 0, 0, 'is_IS', 'is', 0),
44(27, 'it', 'Italian', 1, 0, 'it_IT', 'it', 0),
45(28, 'ja', 'Japanese', 1, 0, 'ja', 'ja', 0),
46(29, 'ko', 'Korean', 0, 0, 'ko_KR', 'ko', 0),
47(30, 'ku', 'Kurdish', 0, 0, 'ckb', 'ku', 0),
48(31, 'lv', 'Latvian', 0, 0, 'lv_LV', 'lv', 0),
49(32, 'lt', 'Lithuanian', 0, 0, 'lt_LT', 'lt', 0),
50(33, 'mk', 'Macedonian', 0, 0, 'mk_MK', 'mk', 0),
51(34, 'mt', 'Maltese', 0, 0, 'mt_MT', 'mt', 0),
52(35, 'mn', 'Mongolian', 0, 0, 'mn_MN', 'mn', 0),
53(36, 'ne', 'Nepali', 0, 0, 'ne', 'ne', 0),
54(37, 'nl', 'Dutch', 1, 0, 'nl_NL', 'nl', 0),
55(38, 'no', 'Norwegian Bokmål', 0, 0, 'nb_NO', 'no', 0),
56(39, 'pa', 'Punjabi', 0, 0, '', 'pa', 0),
57(40, 'pl', 'Polish', 0, 0, 'pl_PL', 'pl', 0),
58(41, 'pt-pt', 'Portuguese, Portugal', 0, 0, 'pt_PT', 'pt-pt', 0),
59(42, 'pt-br', 'Portuguese, Brazil', 0, 0, 'pt_BR', 'pt-br', 0),
60(43, 'qu', 'Quechua', 0, 0, 'quz_PE', 'qu', 0),
61(44, 'ro', 'Romanian', 0, 0, 'ro_RO', 'ro', 0),
62(45, 'ru', 'Russian', 1, 0, 'ru_RU', 'ru', 0),
63(46, 'sl', 'Slovenian', 0, 0, 'sl_SI', 'sl', 0),
64(47, 'so', 'Somali', 0, 0, 'so_SO', 'so', 0),
65(48, 'sq', 'Albanian', 0, 0, 'sq_AL', 'sq', 0),
66(49, 'sr', 'Serbian', 0, 0, 'sr_RS', 'sr', 0),
67(50, 'sv', 'Swedish', 0, 0, 'sv_SE', 'sv', 0),
68(51, 'ta', 'Tamil', 0, 0, 'ta_IN', 'ta', 0),
69(52, 'th', 'Thai', 0, 0, 'th', 'th', 0),
70(53, 'tr', 'Turkish', 0, 0, 'tr_TR', 'tr', 0),
71(54, 'uk', 'Ukrainian', 0, 0, 'uk', 'uk', 0),
72(55, 'ur', 'Urdu', 0, 0, 'uz_UZ', 'ur', 0),
73(56, 'uz', 'Uzbek', 0, 0, 'uz_UZ', 'uz', 0),
74(57, 'vi', 'Vietnamese', 0, 0, 'vi_VN', 'vi', 0),
75(58, 'yi', 'Yiddish', 0, 0, '', 'yi', 0),
76(59, 'zh-hans', 'Chinese (Simplified)', 1, 0, 'zh_CN', 'zh-hans', 0),
77(60, 'zu', 'Zulu', 0, 0, '', 'zu', 0),
78(61, 'zh-hant', 'Chinese (Traditional)', 1, 1, 'zh_TW', 'zh-hant', 0),
79(62, 'ms', 'Malay', 0, 0, 'ms_MY', 'ms', 0),
80(63, 'gl', 'Galician', 0, 0, 'gl_ES', 'gl', 0),
81(64, 'bn', 'Bengali', 0, 0, 'bn_BD', 'bn', 0);