· 8 years ago · May 29, 2018, 02:18 AM
1--
2-- Table structure for table `country`
3--
4
5DROP TABLE IF EXISTS `country`;
6CREATE TABLE IF NOT EXISTS `country` (
7 `CountryId` int(11) NOT NULL AUTO_INCREMENT,
8 `CountryName` varchar(900) NOT NULL,
9 `CountryCode` varchar(100) NOT NULL,
10 PRIMARY KEY (`CountryId`)
11) ENGINE=MyISAM AUTO_INCREMENT=200 DEFAULT CHARSET=latin1;
12
13--
14-- Dumping data for table `country`
15--
16
17INSERT INTO `country` (`CountryId`, `CountryName`, `CountryCode`) VALUES
18(1, 'Albania', 'AL'),
19(2, 'Algeria', 'DZ'),
20(3, 'American Samoa', 'AS'),
21(4, 'Andorra', 'AD'),
22(5, 'Angola', 'AO'),
23(6, 'Anguilla', 'AI'),
24(7, 'Antigua', 'AG'),
25(8, 'Argentina', 'AR'),
26(9, 'Armenia', 'AM'),
27(10, 'Aruba', 'AW'),
28(11, 'Australia', 'AU'),
29(12, 'Austria', 'AT'),
30(13, 'Azerbaijan', 'AZ'),
31(14, 'Bahamas', 'BS'),
32(15, 'Bahrain', 'BH'),
33(16, 'Bangladesh', 'BD'),
34(17, 'Barbados', 'BB'),
35(18, 'Belarus', 'BY'),
36(19, 'Belgium', 'BE'),
37(20, 'Belize', 'BZ'),
38(21, 'Benin', 'BJ'),
39(22, 'Bermuda', 'BM'),
40(23, 'Bhutan', 'BT'),
41(24, 'Bolivia', 'BO'),
42(25, 'Botswana', 'BW'),
43(26, 'Brazil', 'BR'),
44(27, 'British Virgin Is.', 'VG'),
45(28, 'Brunei', 'BN'),
46(29, 'Bulgaria', 'BG'),
47(30, 'Burkino Faso', 'BF'),
48(31, 'Burma', 'MM'),
49(32, 'Burundi', 'BI'),
50(33, 'Cambodia', 'KH'),
51(34, 'Cameroon', 'CM'),
52(35, 'Canada', 'CA'),
53(36, 'Cape Verde', 'CV'),
54(37, 'Cayman Islands', 'KY'),
55(38, 'Central African', 'CF'),
56(39, 'Chad', 'TD'),
57(40, 'Chile', 'CL'),
58(41, 'China', 'CN'),
59(42, 'Colombia', 'CO'),
60(43, 'Congo', 'CG'),
61(44, 'Congo, The Republic of', 'CD'),
62(45, 'Cook Islands', 'CK'),
63(46, 'Costa Rica', 'CR'),
64(47, 'Cote D\'Ivoire', 'CI'),
65(48, 'Croatia', 'HR'),
66(49, 'Cyprus', 'CY'),
67(50, 'Czech Republic', 'CZ'),
68(51, 'Denmark', 'DK'),
69(52, 'Djibouti', 'DJ'),
70(53, 'Dominica', 'DM'),
71(54, 'Dominican Republic', 'DO'),
72(55, 'Ecuador', 'EC'),
73(56, 'Egypt', 'EG'),
74(57, 'El Salvador', 'SV'),
75(58, 'Equatorial Guinea', 'GQ'),
76(59, 'Eritrea', 'ER'),
77(60, 'Estonia', 'EE'),
78(61, 'Ethiopia', 'ET'),
79(62, 'Faeroe Islands', 'FO'),
80(63, 'Fiji', 'FJ'),
81(64, 'Finland', 'FI'),
82(65, 'France', 'FR'),
83(66, 'French Guiana', 'GF'),
84(67, 'French Polynesia', 'PF'),
85(68, 'Gabon', 'GA'),
86(69, 'Gambia', 'GM'),
87(70, 'Georgia, Republic of', 'GE'),
88(71, 'Germany', 'DE'),
89(72, 'Ghana', 'GH'),
90(73, 'Gibraltar', 'GI'),
91(74, 'Greece', 'GR'),
92(75, 'Greenland', 'GL'),
93(76, 'Grenada', 'GD'),
94(77, 'Guadeloupe', 'GP'),
95(78, 'Guam', 'GU'),
96(79, 'Guatemala', 'GT'),
97(80, 'Guinea', 'GN'),
98(81, 'Guinea-Bissau', 'GW'),
99(82, 'Guyana', 'GY'),
100(83, 'Haiti', 'HT'),
101(84, 'Honduras', 'HN'),
102(85, 'Hong Kong', 'HK'),
103(86, 'Hungary', 'HU'),
104(87, 'Iceland', 'IS'),
105(88, 'India', 'IN'),
106(89, 'Indonesia', 'ID'),
107(90, 'Ireland', 'IE'),
108(91, 'Israel', 'IL'),
109(92, 'Italy', 'IT'),
110(93, 'Ivory Coast', 'CI'),
111(94, 'Jamaica', 'JM'),
112(95, 'Japan', 'JP'),
113(96, 'Jordan', 'JO'),
114(97, 'Kazakhstan', 'KZ'),
115(98, 'Kenya', 'KE'),
116(99, 'Kuwait', 'KW'),
117(100, 'Kyrgyzstan', 'KG'),
118(101, 'Latvia', 'LV'),
119(102, 'Lebanon', 'LB'),
120(103, 'Lesotho', 'LS'),
121(104, 'Liechtenstein', 'LI'),
122(105, 'Lithuania', 'LT'),
123(106, 'Luxembourg', 'LU'),
124(107, 'Macau', 'MO'),
125(108, 'Macedonia', 'MK'),
126(109, 'Madagascar', 'MG'),
127(110, 'Malawi', 'MW'),
128(111, 'Malaysia', 'MY'),
129(112, 'Maldives', 'MV'),
130(113, 'Mali', 'ML'),
131(114, 'Malta', 'MT'),
132(115, 'Marshall Islands', 'MH'),
133(116, 'Martinique', 'MQ'),
134(117, 'Mauritania', 'MR'),
135(118, 'Mauritius', 'MU'),
136(119, 'Mexico', 'MX'),
137(120, 'Micronesia', 'FM'),
138(121, 'Moldova', 'MD'),
139(122, 'Monaco', 'MC'),
140(123, 'Mongolia', 'MN'),
141(124, 'Montserrat', 'MS'),
142(125, 'Morocco', 'MA'),
143(126, 'Mozambique', 'MZ'),
144(127, 'Myanmar', 'MM'),
145(128, 'Namibia', 'NA'),
146(129, 'Nepal', 'NP'),
147(130, 'Netherlands', 'NL'),
148(131, 'Netherlands Antilles', 'AN'),
149(132, 'New Caledonia', 'NC'),
150(133, 'New Zealand', 'NZ'),
151(134, 'Nicaragua', 'NI'),
152(135, 'Niger', 'NE'),
153(136, 'Nigeria', 'NG'),
154(137, 'Norway', 'NO'),
155(138, 'Oman', 'OM'),
156(139, 'Pakistan', 'PK'),
157(140, 'Palau', 'PW'),
158(141, 'Panama', 'PA'),
159(142, 'Papua New Guinea', 'PG'),
160(143, 'Paraguay', 'PY'),
161(144, 'Peru', 'PE'),
162(145, 'Philippines', 'PH'),
163(146, 'Poland', 'PL'),
164(147, 'Portugal', 'PT'),
165(148, 'Puerto Rico', 'US'),
166(149, 'Qatar', 'QA'),
167(150, 'Reunion Island', 'RE'),
168(151, 'Romania', 'RO'),
169(152, 'Russia', 'RU'),
170(153, 'Rwanda', 'RW'),
171(154, 'Saipan', 'MP'),
172(155, 'San Marino', 'SM'),
173(156, 'Saudi Arabia', 'SA'),
174(157, 'Senegal', 'SN'),
175(158, 'Seychelles', 'SC'),
176(159, 'Sierra Leone', 'SL'),
177(160, 'Singapore', 'SG'),
178(161, 'Slovak Republic', 'SK'),
179(162, 'Slovenia', 'SI'),
180(163, 'South Africa', 'ZA'),
181(164, 'South Korea', 'KR'),
182(165, 'Spain', 'ES'),
183(166, 'Sri Lanka', 'LK'),
184(167, 'St. Kitts & Nevis', 'KN'),
185(168, 'St. Lucia', 'LC'),
186(169, 'St. Vincent', 'VC'),
187(170, 'Suriname', 'SR'),
188(171, 'Swaziland', 'SZ'),
189(172, 'Sweden', 'SE'),
190(173, 'Switzerland', 'CH'),
191(174, 'Syria', 'SY'),
192(175, 'Taiwan', 'TW'),
193(176, 'Tanzania', 'TZ'),
194(177, 'Thailand', 'TH'),
195(178, 'Togo', 'TG'),
196(179, 'Trinidad & Tobago', 'TT'),
197(180, 'Tunisia', 'TN'),
198(181, 'Turkey', 'TR'),
199(182, 'Turkmenistan, Republic of', 'TM'),
200(183, 'Turks & Caicos Is.', 'TC'),
201(184, 'U.A.E.', 'AE'),
202(185, 'U.S. Virgin Islands', 'VI'),
203(186, 'U.S.A.', 'US'),
204(187, 'Uganda', 'UG'),
205(188, 'Ukraine', 'UA'),
206(189, 'United Kingdom', 'GB'),
207(190, 'Uruguay', 'UY'),
208(191, 'Uzbekistan', 'UZ'),
209(192, 'Vanuatu', 'VU'),
210(193, 'Vatican City', 'VA'),
211(194, 'Venezuela', 'VE'),
212(195, 'Vietnam', 'VN'),
213(196, 'Wallis & Futuna Islands', 'WF'),
214(197, 'Yemen', 'YE'),
215(198, 'Zambia', 'ZM'),
216(199, 'Zimbabwe', 'ZW');