
-- --------------------------------------------------------

--
-- Table structure for table `tbl_states`
--

DROP TABLE IF EXISTS `tbl_states`;
CREATE TABLE IF NOT EXISTS `tbl_states` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `un_code` varchar(4) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `ccode` varchar(5) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_states`
--

INSERT INTO `tbl_states` (`id`, `un_code`, `name`, `ccode`) VALUES
(1, '6', 'Afghanistan', 'AF'),
(2, '9', 'Albania', 'AL'),
(3, '12', 'Algeria', 'DZ'),
(4, '505', 'Andorra', 'AD'),
(5, '681', 'Angola', 'AO'),
(6, '', 'Antarctica', 'AQ'),
(7, '601', 'Antigua and Barbuda', 'AG'),
(8, '24', 'Argentina', 'AR'),
(9, '26', 'Armenia', 'AM'),
(10, '', 'Aruba', 'AW'),
(11, '27', 'Australia', 'AU'),
(12, '30', 'Austria', 'AT'),
(13, '31', 'Azerbaijan', 'AZ'),
(14, '603', 'Bahamas', 'BS'),
(15, '604', 'Bahrain', 'BH'),
(16, '507', 'Bangladesh', 'BG'),
(17, '42', 'Barbados', 'BB'),
(18, '63', 'Belarus', 'BY'),
(19, '48', 'Belgium', 'BE'),
(20, '611', 'Belize', 'BZ'),
(21, '117', 'Benin', 'BJ'),
(22, '', 'Bermuda', 'BM'),
(23, '49', 'Bhutan', 'BT'),
(24, '51', 'Bolivia', 'BO'),
(25, '53', 'Bosnia and Herzegovina', 'BA'),
(26, '52', 'Botswana', 'BW'),
(27, '54', 'Brazil', 'BR'),
(28, '602', 'Brunei Darussalam', 'BN'),
(29, '57', 'Bulgaria', 'BG'),
(30, '459', 'Burkina Faso', 'BF'),
(31, '61', 'Burundi', 'BI'),
(32, '66', 'Cambodia', 'KH'),
(33, '69', 'Cameroon', 'CM'),
(34, '72', 'Canada', 'CA'),
(35, '682', 'Cape Verde', 'CV'),
(36, '', 'Cayman Islands', 'KY'),
(37, '75', 'Central African Republic', 'CF'),
(38, '81', 'Chad', 'TD'),
(39, '84', 'Chile', 'CL'),
(40, '86', 'China', 'CN'),
(41, '', 'Christmans Islands', 'CX'),
(42, '', 'Cocos Island', 'CC'),
(43, '93', 'Colombia', 'CO'),
(44, '662', 'Comoros', 'KM'),
(45, '338', 'Congo', 'CD'),
(46, '99', 'Congo, Dem. Rep.', 'CG'),
(47, '', 'Cook Islands', 'CK'),
(48, '102', 'Costa Rica', 'CR'),
(49, '225', 'Cote d''Ivoire', 'CI'),
(50, '103', 'Croatia', 'HR'),
(51, '105', 'Cuba', 'CU'),
(52, '111', 'Cyprus', 'CY'),
(53, '113', 'Czech Republic', 'CZ'),
(54, '515', 'D.P.R  of Korea', 'KR'),
(55, '120', 'Denmark', 'DK'),
(56, '669', 'Djibouti', 'DJ'),
(57, '610', 'Dominica', 'DM'),
(58, '126', 'Dominican Republic', 'DO'),
(59, '706', 'East Timor', 'TP'),
(60, '135', 'Ecuador', 'EC'),
(61, '450', 'Egypt', 'EG'),
(62, '138', 'El Salvador', 'SV'),
(63, '139', 'Equatorial Guinea', 'GQ'),
(64, '142', 'Eritrea', 'ER'),
(65, '140', 'Estonia', 'EE'),
(66, '141', 'Ethiopia', 'ET'),
(67, '', 'Falkland Islands', 'FK'),
(68, '', 'Faroe Islands', 'FO'),
(69, '143', 'Fiji', 'FV'),
(70, '144', 'Finland', 'FI'),
(71, '147', 'France', 'FR'),
(72, '', 'French Guyana', 'GF'),
(73, '', 'French Polynesia', 'PF'),
(74, '153', 'Gabon', 'GA'),
(75, '156', 'Gambia', 'GM'),
(76, '160', 'Georgia', 'GE'),
(77, '525', 'Germany', 'DE'),
(78, '162', 'Ghana', 'GH'),
(79, '', 'Gibraltar', 'GI'),
(80, '165', 'Greece', 'GR'),
(81, '', 'Greenland', 'GL'),
(82, '616', 'Grenada', 'GD'),
(83, '', 'Guadeloupe', 'GP'),
(84, '168', 'Guatemala', 'GT'),
(85, '177', 'Guinea', 'GN'),
(86, '685', 'Guinea-Bissau', 'GW'),
(87, '180', 'Guyana', 'GY'),
(88, '183', 'Haiti', 'HT'),
(89, '535', 'Holy See', 'VA'),
(90, '186', 'Honduras', 'HN'),
(91, '195', 'Hungary', 'HU'),
(92, '198', 'Iceland', 'IS'),
(93, '204', 'India', 'IN'),
(94, '207', 'Indonesia', 'ID'),
(95, '210', 'Iran', 'IR'),
(96, '213', 'Iraq', 'IQ'),
(97, '216', 'Ireland', 'IE'),
(98, '219', 'Israel', 'IL'),
(99, '222', 'Italy', 'IT'),
(100, '228', 'Jamaica', 'JM'),
(101, '231', 'Japan', 'JP'),
(102, '234', 'Jordan', 'JO'),
(103, '239', 'Kazakhstan', 'KZ'),
(104, '240', 'Kenya', 'KE'),
(105, '617', 'Kiribati', 'KI'),
(106, '243', 'Kuwait', 'KW'),
(107, '245', 'Kyrgyzstan', 'KG'),
(108, '246', 'Lao Peoples Democratic Republic', 'LA'),
(109, '247', 'Latvia', 'LV'),
(200, '249', 'Lebanon', 'LB'),
(201, '252', 'Lesotho', 'LS'),
(202, '255', 'Liberia', 'LR'),
(203, '258', 'Libyan Arab Jamahiriya', 'LY'),
(204, '555', 'Liechtenstein', 'LI'),
(205, '260', 'Lithuania', 'LT'),
(206, '264', 'Luxembourg', 'LU'),
(207, '', 'Macedonia', 'MK'),
(209, '267', 'Madagascar', 'MG'),
(210, '269', 'Malawi', 'MW'),
(211, '270', 'Malaysia', 'MY'),
(212, '274', 'Maldives', 'MV'),
(213, '276', 'Mali', 'ML'),
(214, '279', 'Malta', 'MT'),
(215, '', 'Marocco', 'MA'),
(216, '692', 'Marshall Islands', 'MH'),
(217, '282', 'Mauritania', 'MR'),
(218, '283', 'Mauritius', 'MU'),
(219, '285', 'Mexico', 'MX'),
(220, '693', 'Micronesia', 'FM'),
(221, '', 'Moldavia', 'MD'),
(222, '565', 'Monaco', 'MC'),
(223, '288', 'Mongolia', 'MN'),
(224, '291', 'Morocco', 'MA'),
(225, '689', 'Mozambique', 'MZ'),
(226, '60', 'Myanmar', 'MM'),
(227, '698', 'Namibia', 'NA'),
(228, '648', 'Nauru', 'NR'),
(229, '297', 'Nepal', 'NP'),
(230, '300', 'Netherlands Antilles', 'AN'),
(231, '309', 'New Zealand', 'NZ'),
(232, '312', 'Nicaragua', 'NI'),
(233, '318', 'Niger', 'NE'),
(234, '321', 'Nigeria', 'NG'),
(235, '', 'Niue', 'NU'),
(236, '', 'North Korea', 'KP'),
(237, '324', 'Norway', 'NO'),
(238, '635', 'Oman', 'OM'),
(239, '330', 'Pakistan', 'PK'),
(240, '690', 'Palau, Republic of', 'PW'),
(241, '333', 'Panama', 'PA'),
(242, '649', 'Papua New Guinea', 'PG'),
(243, '336', 'Paraguay', 'PY'),
(244, '339', 'Peru', 'PE'),
(245, '342', 'Philippines', 'PH'),
(246, '345', 'Poland', 'PL'),
(247, '348', 'Portugal', 'PT'),
(248, '', 'Puerto Rico', 'PR'),
(249, '624', 'Qatar', 'QA'),
(250, '567', 'Korea, Republic of', 'KR'),
(251, '564', 'Moldova, Republic of', 'MD'),
(252, '895', 'Montenegro, Republic of', ''),
(253, '897', 'Serbia, Republic of', ''),
(254, '492', 'Yemen, Republic of', 'YE'),
(255, '366', 'Romania', 'RO'),
(256, '370', 'Russian Federation', 'RU'),
(257, '375', 'Rwanda', 'RW'),
(258, '', 'Saint Helena', 'SH'),
(259, '627', 'Saint Kitts and Nevis', 'KN'),
(260, '629', 'Saint Lucia', 'LC'),
(261, '590', 'Samoa', 'WS'),
(262, '570', 'San Marino', 'SM'),
(263, '683', 'Sao Tomé and Príncipe', 'ST'),
(264, '378', 'Saudi Arabia', 'SA'),
(265, '381', 'Senegal', 'SN'),
(266, '891', 'Serbia and Montenegro', ''),
(267, '628', 'Seychelles', 'SC'),
(268, '390', 'Sierra Leone', 'SL'),
(269, '391', 'Singapore', 'SG'),
(270, '395', 'Slovakia', 'SK'),
(271, '394', 'Slovenia', 'SI'),
(272, '631', 'Solomon Islands', 'SB'),
(273, '392', 'Somalia', 'SO'),
(274, '393', 'South Africa', 'ZA'),
(275, '399', 'Spain', 'EI'),
(276, '78', 'Sri Lanka', 'LK'),
(277, '', 'St.Pierre and Miquelon', 'PM'),
(278, '', 'Saint Vincent and the Grenadines', 'VC'),
(279, '402', 'Sudan', 'SD'),
(280, '678', 'Suriname', 'SR'),
(281, '403', 'Swaziland', 'SZ'),
(282, '411', 'Sweden', 'SE'),
(283, '575', 'Switzerland', 'CH'),
(284, '414', 'Syrian Arab Republic', 'SY'),
(285, '', 'Taiwan', 'TW'),
(286, '415', 'Tajikistan', ''),
(287, '455', 'Tanzania, United Republic of', 'TZ'),
(288, '420', 'Thailand', 'TH'),
(289, '423', 'Togo', 'TG'),
(290, '634', 'Tonga', 'TO'),
(291, '429', 'Trinidad and Tobago', 'TT'),
(292, '432', 'Tunisia', 'TN'),
(293, '435', 'Turkey', 'TR'),
(294, '436', 'Turkmenistan', 'TM'),
(295, '', 'Turks and Caicos Islands', 'TC'),
(296, '618', 'Tuvalu', 'TV'),
(297, '438', 'Uganda', 'UG'),
(298, '441', 'Ukraine', 'UA'),
(299, '449', 'United Arab Emirates', 'AE'),
(300, '453', 'United Kingdom', 'UK'),
(301, '456', 'United States of America', 'US'),
(302, '462', 'Uruguay', 'UY'),
(303, '463', 'Uzbekistan', 'UZ'),
(304, '655', 'Vanuatu', 'VU'),
(305, '', 'Vatican City', 'VA'),
(306, '471', 'Venezuela', 'VE'),
(307, '520', 'Viet Nam', 'VN'),
(308, '', 'Virgin Islands (GB)', 'VG'),
(309, '', 'Virgin Islands (U.S.)', 'VI'),
(310, '', 'Wallis and Futuna Islands', 'WF'),
(311, '495', 'Yugoslavia', 'YU'),
(312, '498', 'Zambia', 'ZM'),
(313, '626', 'Zimbabwe', 'ZW'),
(314, '', 'Southern Sudan', ''),
(9999, '9999', 'Other', 'ZZ'),
(337, '', 'Netherlands', 'EH');