HQ3H3wPj

1CREATE TABLE IF NOT EXISTS `country_multilingual` (
2  `lang` varchar(5) COLLATE utf8_bin DEFAULT NULL,
3  `lang_name` varchar(50) COLLATE utf8_bin DEFAULT NULL,
4  `country_alpha2_code` char(2) COLLATE utf8_bin DEFAULT NULL,
5  `country_alpha3_code` char(3) COLLATE utf8_bin DEFAULT NULL,
6  `country_numeric_code` char(3) COLLATE utf8_bin DEFAULT NULL,
7  `country_name` varchar(200) COLLATE utf8_bin DEFAULT NULL,
8  UNIQUE KEY `lang` (`lang`,`country_numeric_code`),
9  KEY `idx_lang` (`lang`),
10  KEY `idx_country_alpha2_code` (`country_alpha2_code`)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 
12     
13{"items:[{"id":%country_numeric_code%,"lang":%lang%,"name":%country_name%},...],"data":{"status":200,"code":0,"message":"OK"}}