--
-- Table structure for table `countries`
--
CREATE TABLE IF NOT EXISTS `countries` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Country_Name` varchar(250) NOT NULL,
`Country_Code` varchar(100) NOT NULL,
`status` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
PRIMARY KEY (`id`),
UNIQUE KEY `Country_Code` (`Country_Code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=251 ;
--
-- Dumping data for table `countries`
--
INSERT INTO `countries` (`id`, `Country_Name`, `Country_Code`, `status`) VALUES
(1, 'Afghanistan', 'AF', 'ACTIVE'),
(2, 'Aland Islands', 'AX', 'ACTIVE'),
(3, 'Albania', 'AL', 'ACTIVE'),
(4, 'Algeria', 'DZ', 'ACTIVE'),
(5, 'American Samoa', 'AS', 'ACTIVE'),
(6, 'Andorra', 'AD', 'ACTIVE'),
(7, 'Angola', 'AO', 'ACTIVE'),
(8, 'Anguilla', 'AI', 'ACTIVE'),
(9, 'Antarctica', 'AQ', 'ACTIVE'),
(10, 'Antigua and Barbuda', 'AG', 'ACTIVE'),
(11, 'Argentina', 'AR', 'ACTIVE'),
(12, 'Armenia', 'AM', 'ACTIVE'),
(13, 'Aruba', 'AW', 'ACTIVE'),
(14, 'Australia', 'AU', 'ACTIVE'),
(15, 'Austria', 'AT', 'ACTIVE'),
(16, 'Azerbaijan', 'AZ', 'ACTIVE'),
(17, 'Bahamas', 'BS', 'ACTIVE'),
(18, 'Bahrain', 'BH', 'ACTIVE'),
(19, 'Bangladesh', 'BD', 'ACTIVE'),
(20, 'Barbados', 'BB', 'ACTIVE'),
(21, 'Belarus', 'BY', 'ACTIVE'),
(22, 'Belgium', 'BE', 'ACTIVE'),
(23, 'Belize', 'BZ', 'ACTIVE'),
(24, 'Benin', 'BJ', 'ACTIVE'),
(25, 'Bermuda', 'BM', 'ACTIVE'),
(26, 'Bhutan', 'BT', 'ACTIVE'),
(27, 'Bolivia', 'BO', 'ACTIVE'),
(28, 'Bosnia and Herzegovina', 'BA', 'ACTIVE'),
(29, 'Botswana', 'BW', 'ACTIVE'),
(30, 'Bouvet Island', 'BV', 'ACTIVE'),
(31, 'Brazil', 'BR', 'ACTIVE'),
(32, 'British Indian Ocean Territory', 'IO', 'ACTIVE'),
(33, 'British Virgin Islands', 'VG', 'ACTIVE'),
(34, 'Brunei', 'BN', 'ACTIVE'),
(35, 'Bulgaria', 'BG', 'ACTIVE'),
(36, 'Burkina Faso', 'BF', 'ACTIVE'),
(37, 'Burundi', 'BI', 'ACTIVE'),
(38, 'Cambodia', 'KH', 'ACTIVE'),
(39, 'Cameroon', 'CM', 'ACTIVE'),
(40, 'Canada', 'CA', 'ACTIVE'),
(41, 'Cape Verde', 'CV', 'ACTIVE'),
(42, 'Caribbean Netherlands', 'BQ', 'ACTIVE'),
(43, 'Cayman Islands', 'KY', 'ACTIVE'),
(44, 'Central African Republic', 'CF', 'ACTIVE'),
(45, 'Chad', 'TD', 'ACTIVE'),
(46, 'Chile', 'CL', 'ACTIVE'),
(47, 'China', 'CN', 'ACTIVE'),
(48, 'Christmas Island', 'CX', 'ACTIVE'),
(49, 'Cocos (Keeling) Islands', 'CC', 'ACTIVE'),
(50, 'Colombia', 'CO', 'ACTIVE'),
(51, 'Comoros', 'KM', 'ACTIVE'),
(52, 'Congo (Brazzaville)', 'CG', 'ACTIVE'),
(53, 'Congo (Kinshasa)', 'CD', 'ACTIVE'),
(54, 'Cook Islands', 'CK', 'ACTIVE'),
(55, 'Costa Rica', 'CR', 'ACTIVE'),
(56, 'Croatia', 'HR', 'ACTIVE'),
(57, 'Cuba', 'CU', 'ACTIVE'),
(58, 'Curaçao', 'CW', 'ACTIVE'),
(59, 'Cyprus', 'CY', 'ACTIVE'),
(60, 'Czech Republic', 'CZ', 'ACTIVE'),
(61, 'Denmark', 'DK', 'ACTIVE'),
(62, 'Djibouti', 'DJ', 'ACTIVE'),
(63, 'Dominica', 'DM', 'ACTIVE'),
(64, 'Dominican Republic', 'DO', 'ACTIVE'),
(65, 'Ecuador', 'EC', 'ACTIVE'),
(66, 'Egypt', 'EG', 'ACTIVE'),
(67, 'El Salvador', 'SV', 'ACTIVE'),
(68, 'Equatorial Guinea', 'GQ', 'ACTIVE'),
(69, 'Eritrea', 'ER', 'ACTIVE'),
(70, 'Estonia', 'EE', 'ACTIVE'),
(71, 'Ethiopia', 'ET', 'ACTIVE'),
(72, 'Falkland Islands', 'FK', 'ACTIVE'),
(73, 'Faroe Islands', 'FO', 'ACTIVE'),
(74, 'Fiji', 'FJ', 'ACTIVE'),
(75, 'Finland', 'FI', 'ACTIVE'),
(76, 'France', 'FR', 'ACTIVE'),
(77, 'French Guiana', 'GF', 'ACTIVE'),
(78, 'French Polynesia', 'PF', 'ACTIVE'),
(79, 'French Southern Territories', 'TF', 'ACTIVE'),
(80, 'Gabon', 'GA', 'ACTIVE'),
(81, 'Gambia', 'GM', 'ACTIVE'),
(82, 'Georgia', 'GE', 'ACTIVE'),
(83, 'Germany', 'DE', 'ACTIVE'),
(84, 'Ghana', 'GH', 'ACTIVE'),
(85, 'Gibraltar', 'GI', 'ACTIVE'),
(86, 'Greece', 'GR', 'ACTIVE'),
(87, 'Greenland', 'GL', 'ACTIVE'),
(88, 'Grenada', 'GD', 'ACTIVE'),
(89, 'Guadeloupe', 'GP', 'ACTIVE'),
(90, 'Guam', 'GU', 'ACTIVE'),
(91, 'Guatemala', 'GT', 'ACTIVE'),
(92, 'Guernsey', 'GG', 'ACTIVE'),
(93, 'Guinea', 'GN', 'ACTIVE'),
(94, 'Guinea-Bissau', 'GW', 'ACTIVE'),
(95, 'Guyana', 'GY', 'ACTIVE'),
(96, 'Haiti', 'HT', 'ACTIVE'),
(97, 'Heard Island and McDonald Islands', 'HM', 'ACTIVE'),
(98, 'Honduras', 'HN', 'ACTIVE'),
(99, 'Hong Kong S.A.R., China', 'HK', 'ACTIVE'),
(100, 'Hungary', 'HU', 'ACTIVE'),
(101, 'Iceland', 'IS', 'ACTIVE'),
(102, 'India', 'IN', 'ACTIVE'),
(103, 'Indonesia', 'ID', 'ACTIVE'),
(104, 'Iran', 'IR', 'ACTIVE'),
(105, 'Iraq', 'IQ', 'ACTIVE'),
(106, 'Ireland', 'IE', 'ACTIVE'),
(107, 'Isle of Man', 'IM', 'ACTIVE'),
(108, 'Israel', 'IL', 'ACTIVE'),
(109, 'Italy', 'IT', 'ACTIVE'),
(110, 'Ivory Coast', 'CI', 'ACTIVE'),
(111, 'Jamaica', 'JM', 'ACTIVE'),
(112, 'Japan', 'JP', 'ACTIVE'),
(113, 'Jersey', 'JE', 'ACTIVE'),
(114, 'Jordan', 'JO', 'ACTIVE'),
(115, 'Kazakhstan', 'KZ', 'ACTIVE'),
(116, 'Kenya', 'KE', 'ACTIVE'),
(117, 'Kiribati', 'KI', 'ACTIVE'),
(118, 'Kuwait', 'KW', 'ACTIVE'),
(119, 'Kyrgyzstan', 'KG', 'ACTIVE'),
(120, 'Laos', 'LA', 'ACTIVE'),
(121, 'Latvia', 'LV', 'ACTIVE'),
(122, 'Lebanon', 'LB', 'ACTIVE'),
(123, 'Lesotho', 'LS', 'ACTIVE'),
(124, 'Liberia', 'LR', 'ACTIVE'),
(125, 'Libya', 'LY', 'ACTIVE'),
(126, 'Liechtenstein', 'LI', 'ACTIVE'),
(127, 'Lithuania', 'LT', 'ACTIVE'),
(128, 'Luxembourg', 'LU', 'ACTIVE'),
(129, 'Macao S.A.R., China', 'MO', 'ACTIVE'),
(130, 'Macedonia', 'MK', 'ACTIVE'),
(131, 'Madagascar', 'MG', 'ACTIVE'),
(132, 'Malawi', 'MW', 'ACTIVE'),
(133, 'Malaysia', 'MY', 'ACTIVE'),
(134, 'Maldives', 'MV', 'ACTIVE'),
(135, 'Mali', 'ML', 'ACTIVE'),
(136, 'Malta', 'MT', 'ACTIVE'),
(137, 'Marshall Islands', 'MH', 'ACTIVE'),
(138, 'Martinique', 'MQ', 'ACTIVE'),
(139, 'Mauritania', 'MR', 'ACTIVE'),
(140, 'Mauritius', 'MU', 'ACTIVE'),
(141, 'Mayotte', 'YT', 'ACTIVE'),
(142, 'Mexico', 'MX', 'ACTIVE'),
(143, 'Micronesia', 'FM', 'ACTIVE'),
(144, 'Moldova', 'MD', 'ACTIVE'),
(145, 'Monaco', 'MC', 'ACTIVE'),
(146, 'Mongolia', 'MN', 'ACTIVE'),
(147, 'Montenegro', 'ME', 'ACTIVE'),
(148, 'Montserrat', 'MS', 'ACTIVE'),
(149, 'Morocco', 'MA', 'ACTIVE'),
(150, 'Mozambique', 'MZ', 'ACTIVE'),
(151, 'Myanmar', 'MM', 'ACTIVE'),
(152, 'Namibia', 'NA', 'ACTIVE'),
(153, 'Nauru', 'NR', 'ACTIVE'),
(154, 'Nepal', 'NP', 'ACTIVE'),
(155, 'Netherlands', 'NL', 'ACTIVE'),
(156, 'Netherlands Antilles', 'AN', 'ACTIVE'),
(157, 'New Caledonia', 'NC', 'ACTIVE'),
(158, 'New Zealand', 'NZ', 'ACTIVE'),
(159, 'Nicaragua', 'NI', 'ACTIVE'),
(160, 'Niger', 'NE', 'ACTIVE'),
(161, 'Nigeria', 'NG', 'ACTIVE'),
(162, 'Niue', 'NU', 'ACTIVE'),
(163, 'Norfolk Island', 'NF', 'ACTIVE'),
(164, 'Northern Mariana Islands', 'MP', 'ACTIVE'),
(165, 'North Korea', 'KP', 'ACTIVE'),
(166, 'Norway', 'NO', 'ACTIVE'),
(167, 'Oman', 'OM', 'ACTIVE'),
(168, 'Pakistan', 'PK', 'ACTIVE'),
(169, 'Palau', 'PW', 'ACTIVE'),
(170, 'Palestinian Territory', 'PS', 'ACTIVE'),
(171, 'Panama', 'PA', 'ACTIVE'),
(172, 'Papua New Guinea', 'PG', 'ACTIVE'),
(173, 'Paraguay', 'PY', 'ACTIVE'),
(174, 'Peru', 'PE', 'ACTIVE'),
(175, 'Philippines', 'PH', 'ACTIVE'),
(176, 'Pitcairn', 'PN', 'ACTIVE'),
(177, 'Poland', 'PL', 'ACTIVE'),
(178, 'Portugal', 'PT', 'ACTIVE'),
(179, 'Puerto Rico', 'PR', 'ACTIVE'),
(180, 'Qatar', 'QA', 'ACTIVE'),
(181, 'Reunion', 'RE', 'ACTIVE'),
(182, 'Romania', 'RO', 'ACTIVE'),
(183, 'Russia', 'RU', 'ACTIVE'),
(184, 'Rwanda', 'RW', 'ACTIVE'),
(185, 'Saint Barthélemy', 'BL', 'ACTIVE'),
(186, 'Saint Helena', 'SH', 'ACTIVE'),
(187, 'Saint Kitts and Nevis', 'KN', 'ACTIVE'),
(188, 'Saint Lucia', 'LC', 'ACTIVE'),
(189, 'Saint Martin (French part)', 'MF', 'ACTIVE'),
(190, 'Saint Pierre and Miquelon', 'PM', 'ACTIVE'),
(191, 'Saint Vincent and the Grenadines', 'VC', 'ACTIVE'),
(192, 'Samoa', 'WS', 'ACTIVE'),
(193, 'San Marino', 'SM', 'ACTIVE'),
(194, 'Sao Tome and Principe', 'ST', 'ACTIVE'),
(195, 'Saudi Arabia', 'SA', 'ACTIVE'),
(196, 'Senegal', 'SN', 'ACTIVE'),
(197, 'Serbia', 'RS', 'ACTIVE'),
(198, 'Seychelles', 'SC', 'ACTIVE'),
(199, 'Sierra Leone', 'SL', 'ACTIVE'),
(200, 'Singapore', 'SG', 'ACTIVE'),
(201, 'Sint Maarten', 'SX', 'ACTIVE'),
(202, 'Slovakia', 'SK', 'ACTIVE'),
(203, 'Slovenia', 'SI', 'ACTIVE'),
(204, 'Solomon Islands', 'SB', 'ACTIVE'),
(205, 'Somalia', 'SO', 'ACTIVE'),
(206, 'South Africa', 'ZA', 'ACTIVE'),
(207, 'South Georgia and the South Sandwich Islands', 'GS', 'ACTIVE'),
(208, 'South Korea', 'KR', 'ACTIVE'),
(209, 'South Sudan', 'SS', 'ACTIVE'),
(210, 'Spain', 'ES', 'ACTIVE'),
(211, 'Sri Lanka', 'LK', 'ACTIVE'),
(212, 'Sudan', 'SD', 'ACTIVE'),
(213, 'Suriname', 'SR', 'ACTIVE'),
(214, 'Svalbard and Jan Mayen', 'SJ', 'ACTIVE'),
(215, 'Swaziland', 'SZ', 'ACTIVE'),
(216, 'Sweden', 'SE', 'ACTIVE'),
(217, 'Switzerland', 'CH', 'ACTIVE'),
(218, 'Syria', 'SY', 'ACTIVE'),
(219, 'Taiwan', 'TW', 'ACTIVE'),
(220, 'Tajikistan', 'TJ', 'ACTIVE'),
(221, 'Tanzania', 'TZ', 'ACTIVE'),
(222, 'Thailand', 'TH', 'ACTIVE'),
(223, 'Timor-Leste', 'TL', 'ACTIVE'),
(224, 'Togo', 'TG', 'ACTIVE'),
(225, 'Tokelau', 'TK', 'ACTIVE'),
(226, 'Tonga', 'TO', 'ACTIVE'),
(227, 'Trinidad and Tobago', 'TT', 'ACTIVE'),
(228, 'Tunisia', 'TN', 'ACTIVE'),
(229, 'Turkey', 'TR', 'ACTIVE'),
(230, 'Turkmenistan', 'TM', 'ACTIVE'),
(231, 'Turks and Caicos Islands', 'TC', 'ACTIVE'),
(232, 'Tuvalu', 'TV', 'ACTIVE'),
(233, 'U.S. Virgin Islands', 'VI', 'ACTIVE'),
(234, 'Uganda', 'UG', 'ACTIVE'),
(235, 'Ukraine', 'UA', 'ACTIVE'),
(236, 'United Arab Emirates', 'AE', 'ACTIVE'),
(237, 'United Kingdom', 'GB', 'ACTIVE'),
(238, 'United States', 'US', 'ACTIVE'),
(239, 'United States Minor Outlying Islands', 'UM', 'ACTIVE'),
(240, 'Uruguay', 'UY', 'ACTIVE'),
(241, 'Uzbekistan', 'UZ', 'ACTIVE'),
(242, 'Vanuatu', 'VU', 'ACTIVE'),
(243, 'Vatican', 'VA', 'ACTIVE'),
(244, 'Venezuela', 'VE', 'ACTIVE'),
(245, 'Vietnam', 'VN', 'ACTIVE'),
(246, 'Wallis and Futuna', 'WF', 'ACTIVE'),
(247, 'Western Sahara', 'EH', 'ACTIVE'),
(248, 'Yemen', 'YE', 'ACTIVE'),
(249, 'Zambia', 'ZM', 'ACTIVE'),
(250, 'Zimbabwe', 'ZW', 'ACTIVE');
0 comments:
Post a Comment