XYYueqKM

1--
2-- Table structure for table `country`
3--
4
5CREATE TABLE IF NOT EXISTS `country` (
6  `country_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
7  `country_name` varchar(80) NOT NULL,
8  `country_nice_name` varchar(80) NOT NULL,
9  `country_iso` char(2) NOT NULL,
10  `country_iso3` char(3) DEFAULT NULL,
11  `country_number_code` smallint(6) DEFAULT NULL,
12  `country_phone_code` int(5) NOT NULL,
13  `country_date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
14  `country_date_updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
15  `country_deleted_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
16  PRIMARY KEY (`country_id`),
17  UNIQUE KEY `country_id` (`country_id`)
18) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=240 ;
19
20
21--
22-- Dumping data for table `country`
23--
24
25INSERT INTO `country` (`country_id`, `country_name`, `country_nice_name`, `country_iso`, `country_iso3`, `country_number_code`, `country_phone_code`, `country_date_created`, `country_date_updated`, `country_deleted_at`) VALUES
26(1, 'Afghanistan', 'Afghanistan', 'AF', 'AFG', 4, 93, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
27(2, 'Albania', 'Albania', 'AL', 'ALB', 8, 355, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
28(3, 'Algeria', 'Algeria', 'DZ', 'DZA', 12, 213, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
29(4, 'American Samoa', 'American Samoa', 'AS', 'ASM', 16, 1684, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
30(5, 'Andorra', 'Andorra', 'AD', 'AND', 20, 376, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
31(6, 'Angola', 'Angola', 'AO', 'AGO', 24, 244, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
32(7, 'Anguilla', 'Anguilla', 'AI', 'AIA', 660, 1264, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
33(8, 'Antarctica', 'Antarctica', 'AQ', NULL, NULL, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
34(9, 'Antigua and Barbuda', 'Antigua and Barbuda', 'AG', 'ATG', 28, 1268, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
35(10, 'Argentina', 'Argentina', 'AR', 'ARG', 32, 54, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
36(11, 'Armenia', 'Armenia', 'AM', 'ARM', 51, 374, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
37(12, 'Aruba', 'Aruba', 'AW', 'ABW', 533, 297, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
38(13, 'Australia', 'Australia', 'AU', 'AUS', 36, 61, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
39(14, 'Austria', 'Austria', 'AT', 'AUT', 40, 43, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
40(15, 'Azerbaijan', 'Azerbaijan', 'AZ', 'AZE', 31, 994, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
41(16, 'Bahamas', 'Bahamas', 'BS', 'BHS', 44, 1242, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
42(17, 'Bahrain', 'Bahrain', 'BH', 'BHR', 48, 973, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
43(18, 'Bangladesh', 'Bangladesh', 'BD', 'BGD', 50, 880, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
44(19, 'Barbados', 'Barbados', 'BB', 'BRB', 52, 1246, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
45(20, 'Belarus', 'Belarus', 'BY', 'BLR', 112, 375, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
46(21, 'Belgium', 'Belgium', 'BE', 'BEL', 56, 32, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
47(22, 'Belize', 'Belize', 'BZ', 'BLZ', 84, 501, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
48(23, 'Benin', 'Benin', 'BJ', 'BEN', 204, 229, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
49(24, 'Bermuda', 'Bermuda', 'BM', 'BMU', 60, 1441, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
50(25, 'Bhutan', 'Bhutan', 'BT', 'BTN', 64, 975, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
51(26, 'Bolivia', 'Bolivia', 'BO', 'BOL', 68, 591, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
52(27, 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 'BA', 'BIH', 70, 387, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
53(28, 'Botswana', 'Botswana', 'BW', 'BWA', 72, 267, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
54(29, 'Bouvet Island', 'Bouvet Island', 'BV', NULL, NULL, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
55(30, 'Brazil', 'Brazil', 'BR', 'BRA', 76, 55, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
56(31, 'British Indian Ocean Territory', 'British Indian Ocean Territory', 'IO', NULL, NULL, 246, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
57(32, 'Brunei Darussalam', 'Brunei Darussalam', 'BN', 'BRN', 96, 673, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
58(33, 'Bulgaria', 'Bulgaria', 'BG', 'BGR', 100, 359, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
59(34, 'Burkina Faso', 'Burkina Faso', 'BF', 'BFA', 854, 226, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
60(35, 'Burundi', 'Burundi', 'BI', 'BDI', 108, 257, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
61(36, 'Cambodia', 'Cambodia', 'KH', 'KHM', 116, 855, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
62(37, 'Cameroon', 'Cameroon', 'CM', 'CMR', 120, 237, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
63(38, 'Canada', 'Canada', 'CA', 'CAN', 124, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
64(39, 'Cape Verde', 'Cape Verde', 'CV', 'CPV', 132, 238, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
65(40, 'Cayman Islands', 'Cayman Islands', 'KY', 'CYM', 136, 1345, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
66(41, 'Central African Republic', 'Central African Republic', 'CF', 'CAF', 140, 236, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
67(42, 'Chad', 'Chad', 'TD', 'TCD', 148, 235, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
68(43, 'Chile', 'Chile', 'CL', 'CHL', 152, 56, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
69(44, 'China', 'China', 'CN', 'CHN', 156, 86, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
70(45, 'Christmas Island', 'Christmas Island', 'CX', NULL, NULL, 61, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
71(46, 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands', 'CC', NULL, NULL, 672, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
72(47, 'Colombia', 'Colombia', 'CO', 'COL', 170, 57, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
73(48, 'Comoros', 'Comoros', 'KM', 'COM', 174, 269, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
74(49, 'Congo', 'Congo', 'CG', 'COG', 178, 242, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
75(50, 'Congo, the Democratic Republic of the', 'Congo', 'CD', 'COD', 180, 242, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
76(51, 'Cook Islands', 'Cook Islands', 'CK', 'COK', 184, 682, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
77(52, 'Costa Rica', 'Costa Rica', 'CR', 'CRI', 188, 506, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
78(53, 'Cote D''Ivoire', 'Cote D''Ivoire', 'CI', 'CIV', 384, 225, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
79(54, 'Croatia', 'Croatia', 'HR', 'HRV', 191, 385, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
80(55, 'Cuba', 'Cuba', 'CU', 'CUB', 192, 53, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
81(56, 'Cyprus', 'Cyprus', 'CY', 'CYP', 196, 357, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
82(57, 'Czech Republic', 'Czech Republic', 'CZ', 'CZE', 203, 420, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
83(58, 'Denmark', 'Denmark', 'DK', 'DNK', 208, 45, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
84(59, 'Djibouti', 'Djibouti', 'DJ', 'DJI', 262, 253, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
85(60, 'Dominica', 'Dominica', 'DM', 'DMA', 212, 1767, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
86(61, 'Dominican Republic', 'Dominican Republic', 'DO', 'DOM', 214, 1809, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
87(62, 'Ecuador', 'Ecuador', 'EC', 'ECU', 218, 593, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
88(63, 'Egypt', 'Egypt', 'EG', 'EGY', 818, 20, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
89(64, 'El Salvador', 'El Salvador', 'SV', 'SLV', 222, 503, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
90(65, 'Equatorial Guinea', 'Equatorial Guinea', 'GQ', 'GNQ', 226, 240, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
91(66, 'Eritrea', 'Eritrea', 'ER', 'ERI', 232, 291, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
92(67, 'Estonia', 'Estonia', 'EE', 'EST', 233, 372, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
93(68, 'Ethiopia', 'Ethiopia', 'ET', 'ETH', 231, 251, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
94(69, 'Falkland Islands (Malvinas)', 'Falkland Islands (Malvinas)', 'FK', 'FLK', 238, 500, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
95(70, 'Faroe Islands', 'Faroe Islands', 'FO', 'FRO', 234, 298, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
96(71, 'Fiji', 'Fiji', 'FJ', 'FJI', 242, 679, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
97(72, 'Finland', 'Finland', 'FI', 'FIN', 246, 358, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
98(73, 'France', 'France', 'FR', 'FRA', 250, 33, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
99(74, 'French Guiana', 'French Guiana', 'GF', 'GUF', 254, 594, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
100(75, 'French Polynesia', 'French Polynesia', 'PF', 'PYF', 258, 689, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
101(76, 'French Southern Territories', 'French Southern Territories', 'TF', NULL, NULL, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
102(77, 'Gabon', 'Gabon', 'GA', 'GAB', 266, 241, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
103(78, 'Gambia', 'Gambia', 'GM', 'GMB', 270, 220, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
104(79, 'Georgia', 'Georgia', 'GE', 'GEO', 268, 995, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
105(80, 'Germany', 'Germany', 'DE', 'DEU', 276, 49, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
106(81, 'Ghana', 'Ghana', 'GH', 'GHA', 288, 233, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
107(82, 'Gibraltar', 'Gibraltar', 'GI', 'GIB', 292, 350, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
108(83, 'Greece', 'Greece', 'GR', 'GRC', 300, 30, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
109(84, 'Greenland', 'Greenland', 'GL', 'GRL', 304, 299, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
110(85, 'Grenada', 'Grenada', 'GD', 'GRD', 308, 1473, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
111(86, 'Guadeloupe', 'Guadeloupe', 'GP', 'GLP', 312, 590, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
112(87, 'Guam', 'Guam', 'GU', 'GUM', 316, 1671, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
113(88, 'Guatemala', 'Guatemala', 'GT', 'GTM', 320, 502, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
114(89, 'Guinea', 'Guinea', 'GN', 'GIN', 324, 224, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
115(90, 'Guinea-bissau', 'Guinea-Bissau', 'GW', 'GNB', 624, 245, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
116(91, 'Guyana', 'Guyana', 'GY', 'GUY', 328, 592, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
117(92, 'Haiti', 'Haiti', 'HT', 'HTI', 332, 509, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
118(93, 'Heard Island and Mcdonald Islands', 'Heard Island and Mcdonald Islands', 'HM', NULL, NULL, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
119(94, 'Holy See (Vatican City State)', 'Holy See (Vatican City State)', 'VA', 'VAT', 336, 39, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
120(95, 'Honduras', 'Honduras', 'HN', 'HND', 340, 504, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
121(96, 'Hong Kong', 'Hong Kong', 'HK', 'HKG', 344, 852, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
122(97, 'Hungary', 'Hungary', 'HU', 'HUN', 348, 36, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
123(98, 'Iceland', 'Iceland', 'IS', 'ISL', 352, 354, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
124(99, 'India', 'India', 'IN', 'IND', 356, 91, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
125(100, 'Indonesia', 'Indonesia', 'ID', 'IDN', 360, 62, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
126(101, 'Iran, Islamic Republic of', 'Iran', 'IR', 'IRN', 364, 98, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
127(102, 'Iraq', 'Iraq', 'IQ', 'IRQ', 368, 964, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
128(103, 'Ireland', 'Ireland', 'IE', 'IRL', 372, 353, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
129(104, 'Israel', 'Israel', 'IL', 'ISR', 376, 972, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
130(105, 'Italy', 'Italy', 'IT', 'ITA', 380, 39, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
131(106, 'Jamaica', 'Jamaica', 'JM', 'JAM', 388, 1876, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
132(107, 'Japan', 'Japan', 'JP', 'JPN', 392, 81, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
133(108, 'Jordan', 'Jordan', 'JO', 'JOR', 400, 962, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
134(109, 'Kazakhstan', 'Kazakhstan', 'KZ', 'KAZ', 398, 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
135(110, 'Kenya', 'Kenya', 'KE', 'KEN', 404, 254, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
136(111, 'Kiribati', 'Kiribati', 'KI', 'KIR', 296, 686, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
137(112, 'Korea, Democratic People''s Republic of', 'North Korea', 'KP', 'PRK', 408, 850, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
138(113, 'Korea, Republic of', 'South Korea', 'KR', 'KOR', 410, 82, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
139(114, 'Kuwait', 'Kuwait', 'KW', 'KWT', 414, 965, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
140(115, 'Kyrgyzstan', 'Kyrgyzstan', 'KG', 'KGZ', 417, 996, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
141(116, 'Lao People''s Democratic Republic', 'Laos', 'LA', 'LAO', 418, 856, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
142(117, 'Latvia', 'Latvia', 'LV', 'LVA', 428, 371, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
143(118, 'Lebanon', 'Lebanon', 'LB', 'LBN', 422, 961, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
144(119, 'Lesotho', 'Lesotho', 'LS', 'LSO', 426, 266, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
145(120, 'Liberia', 'Liberia', 'LR', 'LBR', 430, 231, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
146(121, 'Libyan Arab Jamahiriya', 'Libyan Arab Jamahiriya', 'LY', 'LBY', 434, 218, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
147(122, 'Liechtenstein', 'Liechtenstein', 'LI', 'LIE', 438, 423, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
148(123, 'Lithuania', 'Lithuania', 'LT', 'LTU', 440, 370, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
149(124, 'Luxembourg', 'Luxembourg', 'LU', 'LUX', 442, 352, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
150(125, 'Macao', 'Macao', 'MO', 'MAC', 446, 853, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
151(126, 'Macedonia, the Former Yugoslav Republic of', 'Macedonia', 'MK', 'MKD', 807, 389, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
152(127, 'Madagascar', 'Madagascar', 'MG', 'MDG', 450, 261, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
153(128, 'Malawi', 'Malawi', 'MW', 'MWI', 454, 265, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
154(129, 'Malaysia', 'Malaysia', 'MY', 'MYS', 458, 60, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
155(130, 'Maldives', 'Maldives', 'MV', 'MDV', 462, 960, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
156(131, 'Mali', 'Mali', 'ML', 'MLI', 466, 223, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
157(132, 'Malta', 'Malta', 'MT', 'MLT', 470, 356, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
158(133, 'Marshall Islands', 'Marshall Islands', 'MH', 'MHL', 584, 692, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
159(134, 'Martinique', 'Martinique', 'MQ', 'MTQ', 474, 596, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
160(135, 'Mauritania', 'Mauritania', 'MR', 'MRT', 478, 222, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
161(136, 'Mauritius', 'Mauritius', 'MU', 'MUS', 480, 230, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
162(137, 'Mayotte', 'Mayotte', 'YT', NULL, NULL, 269, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
163(138, 'Mexico', 'Mexico', 'MX', 'MEX', 484, 52, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
164(139, 'Micronesia, Federated States of', 'Micronesia', 'FM', 'FSM', 583, 691, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
165(140, 'Moldova, Republic of', 'Moldova', 'MD', 'MDA', 498, 373, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
166(141, 'Monaco', 'Monaco', 'MC', 'MCO', 492, 377, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
167(142, 'Mongolia', 'Mongolia', 'MN', 'MNG', 496, 976, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
168(143, 'Montserrat', 'Montserrat', 'MS', 'MSR', 500, 1664, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
169(144, 'Morocco', 'Morocco', 'MA', 'MAR', 504, 212, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
170(145, 'Mozambique', 'Mozambique', 'MZ', 'MOZ', 508, 258, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
171(146, 'Myanmar', 'Myanmar', 'MM', 'MMR', 104, 95, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
172(147, 'Namibia', 'Namibia', 'NA', 'NAM', 516, 264, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
173(148, 'Nauru', 'Nauru', 'NR', 'NRU', 520, 674, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
174(149, 'Nepal', 'Nepal', 'NP', 'NPL', 524, 977, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
175(150, 'Netherlands', 'Netherlands', 'NL', 'NLD', 528, 31, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
176(151, 'Netherlands Antilles', 'Netherlands Antilles', 'AN', 'ANT', 530, 599, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
177(152, 'New Caledonia', 'New Caledonia', 'NC', 'NCL', 540, 687, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
178(153, 'New Zealand', 'New Zealand', 'NZ', 'NZL', 554, 64, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
179(154, 'Nicaragua', 'Nicaragua', 'NI', 'NIC', 558, 505, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
180(155, 'Niger', 'Niger', 'NE', 'NER', 562, 227, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
181(156, 'Nigeria', 'Nigeria', 'NG', 'NGA', 566, 234, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
182(157, 'Niue', 'Niue', 'NU', 'NIU', 570, 683, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
183(158, 'Norfolk Island', 'Norfolk Island', 'NF', 'NFK', 574, 672, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
184(159, 'Northern Mariana Islands', 'Northern Mariana Islands', 'MP', 'MNP', 580, 1670, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
185(160, 'Norway', 'Norway', 'NO', 'NOR', 578, 47, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
186(161, 'Oman', 'Oman', 'OM', 'OMN', 512, 968, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
187(162, 'Pakistan', 'Pakistan', 'PK', 'PAK', 586, 92, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
188(163, 'Palau', 'Palau', 'PW', 'PLW', 585, 680, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
189(164, 'Palestinian Territory, Occupied', 'Palestinian Territory, Occupied', 'PS', NULL, NULL, 970, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
190(165, 'Panama', 'Panama', 'PA', 'PAN', 591, 507, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
191(166, 'Papua New Guinea', 'Papua New Guinea', 'PG', 'PNG', 598, 675, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
192(167, 'Paraguay', 'Paraguay', 'PY', 'PRY', 600, 595, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
193(168, 'Peru', 'Peru', 'PE', 'PER', 604, 51, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
194(169, 'Philippines', 'Philippines', 'PH', 'PHL', 608, 63, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
195(170, 'Pitcairn', 'Pitcairn', 'PN', 'PCN', 612, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
196(171, 'Poland', 'Poland', 'PL', 'POL', 616, 48, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
197(172, 'Portugal', 'Portugal', 'PT', 'PRT', 620, 351, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
198(173, 'Puerto Rico', 'Puerto Rico', 'PR', 'PRI', 630, 1787, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
199(174, 'Qatar', 'Qatar', 'QA', 'QAT', 634, 974, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
200(175, 'Reunion', 'Reunion', 'RE', 'REU', 638, 262, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
201(176, 'Romania', 'Romania', 'RO', 'ROM', 642, 40, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
202(177, 'Russian Federation', 'Russian Federation', 'RU', 'RUS', 643, 70, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
203(178, 'Rwanda', 'Rwanda', 'RW', 'RWA', 646, 250, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
204(179, 'Saint Helena', 'Saint Helena', 'SH', 'SHN', 654, 290, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
205(180, 'Saint Kitts and Nevis', 'Saint Kitts and Nevis', 'KN', 'KNA', 659, 1869, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
206(181, 'Saint Lucia', 'Saint Lucia', 'LC', 'LCA', 662, 1758, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
207(182, 'Saint Pierre and Miquelon', 'Saint Pierre and Miquelon', 'PM', 'SPM', 666, 508, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
208(183, 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 'VC', 'VCT', 670, 1784, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
209(184, 'Samoa', 'Samoa', 'WS', 'WSM', 882, 684, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
210(185, 'San Marino', 'San Marino', 'SM', 'SMR', 674, 378, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
211(186, 'Sao Tome and Principe', 'Sao Tome and Principe', 'ST', 'STP', 678, 239, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
212(187, 'Saudi Arabia', 'Saudi Arabia', 'SA', 'SAU', 682, 966, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
213(188, 'Senegal', 'Senegal', 'SN', 'SEN', 686, 221, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
214(189, 'Serbia and Montenegro', 'Serbia and Montenegro', 'CS', NULL, NULL, 381, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
215(190, 'Seychelles', 'Seychelles', 'SC', 'SYC', 690, 248, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
216(191, 'Sierra Leone', 'Sierra Leone', 'SL', 'SLE', 694, 232, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
217(192, 'Singapore', 'Singapore', 'SG', 'SGP', 702, 65, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
218(193, 'Slovakia', 'Slovakia', 'SK', 'SVK', 703, 421, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
219(194, 'Slovenia', 'Slovenia', 'SI', 'SVN', 705, 386, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
220(195, 'Solomon Islands', 'Solomon Islands', 'SB', 'SLB', 90, 677, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
221(196, 'Somalia', 'Somalia', 'SO', 'SOM', 706, 252, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
222(197, 'South Africa', 'South Africa', 'ZA', 'ZAF', 710, 27, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
223(198, 'South Georgia and the South Sandwich Islands', 'South Georgia and the South Sandwich Islands', 'GS', NULL, NULL, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
224(199, 'Spain', 'Spain', 'ES', 'ESP', 724, 34, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
225(200, 'Sri Lanka', 'Sri Lanka', 'LK', 'LKA', 144, 94, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
226(201, 'Sudan', 'Sudan', 'SD', 'SDN', 736, 249, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
227(202, 'Suriname', 'Suriname', 'SR', 'SUR', 740, 597, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
228(203, 'Svalbard and Jan Mayen', 'Svalbard and Jan Mayen', 'SJ', 'SJM', 744, 47, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
229(204, 'Swaziland', 'Swaziland', 'SZ', 'SWZ', 748, 268, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
230(205, 'Sweden', 'Sweden', 'SE', 'SWE', 752, 46, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
231(206, 'Switzerland', 'Switzerland', 'CH', 'CHE', 756, 41, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
232(207, 'Syrian Arab Republic', 'Syrian Arab Republic', 'SY', 'SYR', 760, 963, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
233(208, 'Taiwan, Province of China', 'Taiwan', 'TW', 'TWN', 158, 886, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
234(209, 'Tajikistan', 'Tajikistan', 'TJ', 'TJK', 762, 992, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
235(210, 'Tanzania, United Republic of', 'Tanzania', 'TZ', 'TZA', 834, 255, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
236(211, 'Thailand', 'Thailand', 'TH', 'THA', 764, 66, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
237(212, 'Timor-leste', 'Timor-Leste', 'TL', NULL, NULL, 670, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
238(213, 'Togo', 'Togo', 'TG', 'TGO', 768, 228, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
239(214, 'Tokelau', 'Tokelau', 'TK', 'TKL', 772, 690, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
240(215, 'Tonga', 'Tonga', 'TO', 'TON', 776, 676, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
241(216, 'Trinidad and Tobago', 'Trinidad and Tobago', 'TT', 'TTO', 780, 1868, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
242(217, 'Tunisia', 'Tunisia', 'TN', 'TUN', 788, 216, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
243(218, 'Turkey', 'Turkey', 'TR', 'TUR', 792, 90, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
244(219, 'Turkmenistan', 'Turkmenistan', 'TM', 'TKM', 795, 7370, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
245(220, 'Turks and Caicos Islands', 'Turks and Caicos Islands', 'TC', 'TCA', 796, 1649, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
246(221, 'Tuvalu', 'Tuvalu', 'TV', 'TUV', 798, 688, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
247(222, 'Uganda', 'Uganda', 'UG', 'UGA', 800, 256, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
248(223, 'Ukraine', 'Ukraine', 'UA', 'UKR', 804, 380, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
249(224, 'United Arab Emirates', 'United Arab Emirates', 'AE', 'ARE', 784, 971, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
250(225, 'United Kingdom', 'United Kingdom', 'GB', 'GBR', 826, 44, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
251(226, 'United States of America', 'United States', 'US', 'USA', 840, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
252(227, 'United States Minor Outlying Islands', 'United States Minor Outlying Islands', 'UM', NULL, NULL, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
253(228, 'Uruguay', 'Uruguay', 'UY', 'URY', 858, 598, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00')
254,
255(229, 'Uzbekistan', 'Uzbekistan', 'UZ', 'UZB', 860, 998, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
256(230, 'Vanuatu', 'Vanuatu', 'VU', 'VUT', 548, 678, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
257(231, 'Venezuela', 'Venezuela', 'VE', 'VEN', 862, 58, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
258(232, 'Vietnam', 'Vietnam', 'VN', 'VNM', 704, 84, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
259(233, 'Virgin Islands, British', 'Virgin Islands, British', 'VG', 'VGB', 92, 1284, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
260(234, 'Virgin Islands, U.S.', 'Virgin Islands, U.S.', 'VI', 'VIR', 850, 1340, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
261(235, 'Wallis and Futuna', 'Wallis and Futuna', 'WF', 'WLF', 876, 681, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
262(236, 'Western Sahara', 'Western Sahara', 'EH', 'ESH', 732, 212, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
263(237, 'Yemen', 'Yemen', 'YE', 'YEM', 887, 967, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
264(238, 'Zambia', 'Zambia', 'ZM', 'ZMB', 894, 260, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
265(239, 'Zimbabwe', 'Zimbabwe', 'ZW', 'ZWE', 716, 263, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');