-- phpMyAdmin SQL Dump
-- version 3.3.2deb1ubuntu1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 24, 2018 at 08:04 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.10-1~lucid+2uwsgi2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `metro_global`
--

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

--
-- Table structure for table `countries`
--

CREATE TABLE IF NOT EXISTS `countries` (
  `country_id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
  `dig2_code` char(2) DEFAULT NULL,
  `dig3_code` char(3) DEFAULT NULL,
  `num_code` float(3,0) DEFAULT NULL,
  `usps_code` varchar(255) DEFAULT NULL,
  `country` varchar(255) NOT NULL DEFAULT '',
  `country_name` varchar(255) NOT NULL,
  `usps_only` enum('yes','no') NOT NULL DEFAULT 'no',
  `usps_alias` varchar(255) NOT NULL DEFAULT '',
  `us_possession` enum('yes','no') NOT NULL DEFAULT 'no',
  `usps_rtrn_sig_allowed` enum('yes','no') NOT NULL DEFAULT 'yes',
  `active` enum('yes','no') NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`country_id`),
  UNIQUE KEY `country` (`country`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=529 ;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`country_id`, `dig2_code`, `dig3_code`, `num_code`, `usps_code`, `country`, `country_name`, `usps_only`, `usps_alias`, `us_possession`, `usps_rtrn_sig_allowed`, `active`) VALUES
(1, '', '', 0, '10440', 'ABU DHABI (U.A. EMIRATES)', 'Abu Dhabi (U.A. Emirates)', 'yes', 'Abu Dhabi (United Arab Emirates)', 'no', 'no', 'yes'),
(2, '', '', 0, '10345', 'ADMIRALTY ISL (P.N. GUINEA)', 'Admiralty Island (P.N. Guinea)', 'yes', 'Admiralty Islands', 'no', 'no', 'yes'),
(3, 'AF', 'AFG', 4, '10000', 'AFGHANISTAN', 'Afghanistan', 'no', '', 'no', 'no', 'yes'),
(4, '', '', 0, '10441', 'AJMAN (U.A. EMIRATES)', 'Ajman (U.A. Emirates)', 'yes', 'Ajman', 'no', 'no', 'yes'),
(5, '', '', 0, '10110', 'ALAND ISL (FINLAND)', 'Aland Island (Finland)', 'yes', 'Aland Island', 'no', 'no', 'yes'),
(6, 'AL', 'ALB', 8, '10001', 'ALBANIA', 'Albania', 'no', '', 'no', 'no', 'yes'),
(7, '', '', 0, '12134', 'ALDERNEY', 'Alderney', 'yes', '', 'no', 'no', 'yes'),
(8, '', '', 0, '10140', 'ALDERNEY, CHANNEL ISL (G.B.)', 'Alderney, Channel Island (G.B.)', 'yes', 'Alderney', 'no', 'no', 'no'),
(9, 'DZ', 'DZA', 12, '10002', 'ALGERIA', 'Algeria', 'no', '', 'no', 'no', 'yes'),
(10, '', '', 0, '10309', 'ALOFI ISL (NEW ZEALAND)', 'Alofi Island (New Zealand)', 'yes', 'Alofi Island', 'no', 'no', 'yes'),
(11, 'AS', 'ASM', 16, '', 'AMERICAN SAMOA', 'American Samoa', 'no', '', 'no', 'no', 'yes'),
(12, '', '', 0, '10193', 'ANDAMAN ISL (INDIA)', 'Andaman Island (India)', 'yes', 'Andaman Islands', 'no', 'no', 'yes'),
(13, 'AD', 'AND', 20, '10003', 'ANDORRA', 'Andorra', 'no', '', 'no', 'no', 'yes'),
(14, 'AO', 'AND', 24, '10004', 'ANGOLA', 'Angola', 'no', '', 'no', 'no', 'yes'),
(15, 'AI', 'AIA', 660, '10005', 'ANGUILLA', 'Anguilla', 'no', '', 'no', 'no', 'yes'),
(16, '', '', 0, '10068', 'ANJOUAN (COMOROS)', 'Anjouan (Comoros)', 'yes', 'Anjouan', 'no', 'no', 'yes'),
(17, '', '', 0, '10097', 'ANNOBON ISL (EQUATORIAL GUINEA)', 'Annobon Island (Equatorial Guinea)', 'yes', 'Annobon Island', 'no', 'no', 'yes'),
(18, 'AQ', 'ATA', 10, '', 'ANTARCTICA', 'Antarctica', 'no', '', 'no', 'no', 'no'),
(19, 'AG', 'ATG', 28, '10006', 'ANTIGUA AND BARBUDA', 'Antigua And Barbuda', 'no', '', 'no', 'no', 'yes'),
(20, 'AR', 'ARG', 32, '10009', 'ARGENTINA', 'Argentina', 'no', '', 'no', 'no', 'yes'),
(21, 'AM', 'ARM', 51, '10010', 'ARMENIA', 'Armenia', 'no', '', 'no', 'no', 'yes'),
(22, 'AW', 'ABW', 533, '10011', 'ARUBA', 'Aruba', 'no', '', 'no', 'no', 'yes'),
(23, '', '', 0, '10012', 'ASCENSION', 'Ascension', 'yes', '', 'no', 'no', 'yes'),
(24, '', '', 0, '10152', 'ASTYPALAIA (GREECE)', 'Astypalaia (Greece)', 'yes', 'Astypalaia', 'no', 'no', 'yes'),
(25, '', '', 0, '10505', 'ATAFU (WESTERN SAMOA)', 'Atafu (Western Samoa)', 'yes', 'Atafu', 'no', 'no', 'yes'),
(26, '', '', 0, '12026', 'ATIU (COOK ISL, NEW ZEALAND)', 'Atiu (Cook Island, New Zealand)', 'yes', 'Atiu', 'no', 'no', 'no'),
(27, 'AU', 'AUS', 36, '10013', 'AUSTRALIA', 'Australia', 'no', '', 'no', 'no', 'yes'),
(28, 'AT', 'AUT', 40, '10026', 'AUSTRIA', 'Austria', 'no', '', 'no', 'no', 'yes'),
(29, '', '', 0, '10315', 'AVARUA (NEW ZEALAND)', 'Avarua (New Zealand)', 'yes', 'Avarua', 'no', 'no', 'yes'),
(30, 'AZ', 'AZE', 31, '10027', 'AZERBAIJAN', 'Azerbaijan', 'no', '', 'no', 'no', 'yes'),
(31, 'AP', '', 0, '10359', 'AZORES (PORTUGAL)', 'Azores (Portugal)', 'yes', 'Azores', 'no', 'no', 'yes'),
(32, 'BS', 'BHS', 44, '10028', 'BAHAMAS', 'Bahamas', 'no', '', 'no', 'no', 'yes'),
(33, 'BH', 'BHR', 48, '10029', 'BAHRAIN', 'Bahrain', 'no', '', 'no', 'no', 'yes'),
(34, '', '', 0, 'US_BI', 'BAKER ISL (U.S.)', 'Baker Island (U.S.)', 'yes', 'Baker Island', 'yes', 'no', 'yes'),
(35, '', '', 0, '10389', 'BALEARIC ISL (SPAIN)', 'Balearic Island (Spain)', 'yes', 'Balearic Islands', 'no', 'no', 'yes'),
(36, '', '', 0, '10342', 'BALUCHISTAN (PAKISTAN)', 'Baluchistan (Pakistan)', 'yes', 'Baluchistan', 'no', 'no', 'yes'),
(37, 'BD', 'BGD', 50, '10030', 'BANGLADESH', 'Bangladesh', 'no', '', 'no', 'no', 'yes'),
(38, '', '', 0, '10496', 'BANKS ISL (VANUATU)', 'Banks Island (Vanuatu)', 'yes', '', 'no', 'no', 'yes'),
(39, 'BB', 'BRB', 52, '10031', 'BARBADOS', 'Barbados', 'no', '', 'no', 'no', 'yes'),
(40, 'BC', '', 0, '12115', 'BARBUDA', 'Barbuda', 'no', '', 'no', 'no', 'no'),
(41, '', '', 0, '10007', 'BARBUDA (ANTIGUA AND BARBUDA)', 'Barbuda (Antigua And Barbuda)', 'yes', 'Barbuda', 'no', 'no', 'yes'),
(42, '', '', 0, '10171', 'BARTHELEMY (GUADELOUPE)', 'Barthelemy (Guadeloupe)', 'yes', 'Barthelemy', 'no', 'no', 'yes'),
(43, 'BY', '', 0, '10032', 'BELARUS', 'Belarus', 'no', '', 'no', 'no', 'yes'),
(44, 'BE', 'BEL', 56, '10033', 'BELGIUM', 'Belgium', 'no', '', 'no', 'no', 'yes'),
(45, 'BZ', 'BLZ', 84, '10034', 'BELIZE', 'Belize', 'no', '', 'no', 'no', 'yes'),
(46, 'BJ', 'BEN', 204, '10036', 'BENIN', 'Benin', 'no', '', 'no', 'no', 'yes'),
(47, 'BM', 'BMU', 60, '10038', 'BERMUDA', 'Bermuda', 'no', '', 'no', 'no', 'yes'),
(48, 'BT', 'BTN', 64, '10039', 'BHUTAN', 'Bhutan', 'no', '', 'no', 'no', 'yes'),
(49, '', '', 0, '10346', 'BISMARK ARCHIPELAGO (P.N. GUINEA)', 'Bismark Archipelago (P.N. Guinea)', 'yes', 'Bismark Archipelago', 'no', 'no', 'yes'),
(50, 'BO', 'BOL', 68, '10040', 'BOLIVIA', 'Bolivia', 'no', '', 'no', 'no', 'yes'),
(51, 'BL', '', 0, '12118', 'BONAIRE', 'Bonaire', 'no', '', 'no', 'no', 'yes'),
(52, '', '', 0, '10200', 'BORNEO (KALIMANTAN, INDONESIA)', 'Borneo (Kalimantan, Indonesia)', 'yes', 'Borneo (Kalimantan) (Indonesia)', 'no', 'no', 'yes'),
(53, '', '', 0, '10258', 'BORNEO (NORTH, MALAYSIA)', 'Borneo (North, Malaysia)', 'yes', 'Borneo (North) (Malaysia)', 'no', 'no', 'yes'),
(54, 'BA', 'BIH', 70, '10041', 'BOSNIA-HERZEGOVINA', 'Bosnia-herzegovina', 'no', '', 'no', 'no', 'yes'),
(55, 'BW', 'BWA', 72, '10042', 'BOTSWANA', 'Botswana', 'no', '', 'no', 'no', 'yes'),
(56, '', '', 0, '10347', 'BOUGAINVILLE (PAPUA NEW GUINEA)', 'Bougainville (Papua New Guinea)', 'yes', 'Bougainville', 'no', 'no', 'yes'),
(57, '', '', 0, '12122', 'BOURBON (REUNION)', 'Bourbon (Reunion)', 'yes', 'Bourbon', 'no', 'no', 'yes'),
(58, 'BV', 'BVT', 74, '', 'BOUVET ISL', 'Bouvet Island', 'no', '', 'no', 'no', 'no'),
(59, 'BR', 'BRA', 76, '10043', 'BRAZIL', 'Brazil', 'no', '', 'no', 'no', 'yes'),
(60, '', '', 0, '12124', 'BRITISH GUIANA (GUYANA)', 'British Guiana (Guyana)', 'yes', 'British Guiana', 'no', 'no', 'yes'),
(61, '', '', 0, '10035', 'BRITISH HONDURAS (BELIZE)', 'British Honduras (Belize)', 'yes', 'British Honduras', 'no', 'no', 'yes'),
(62, 'IO', 'IOT', 86, '', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', 'no', '', 'no', 'no', 'no'),
(63, 'VG', 'VGB', 92, '10044', 'VIRGIN ISL (BRITISH)', 'Virgin Island (British)', 'no', 'British Virgin Islands', 'no', 'no', 'yes'),
(64, 'BN', 'BRN', 96, '10045', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'no', '', 'no', 'no', 'yes'),
(65, 'BG', 'BGR', 100, '10046', 'BULGARIA', 'Bulgaria', 'no', '', 'no', 'no', 'yes'),
(66, 'BF', 'BFA', 854, '10047', 'BURKINA FASO', 'Burkina Faso', 'no', '', 'no', 'no', 'yes'),
(67, '', '', 0, '10048', 'BURMA', 'Burma', 'yes', '', 'no', 'no', 'yes'),
(68, 'BI', 'BDI', 108, '10050', 'BURUNDI', 'Burundi', 'no', '', 'no', 'no', 'yes'),
(69, '', '', 0, '10434', 'CAICOS ISL (TURKS, CAICOS ISL)', 'Caicos Island (Turks, Caicos Island)', 'yes', 'Caicos Islands', 'no', 'no', 'yes'),
(70, 'KH', 'KHM', 116, '10051', 'CAMBODIA', 'Cambodia', 'no', '', 'no', 'no', 'yes'),
(71, 'CM', 'CMR', 120, '10053', 'CAMEROON', 'Cameroon', 'no', '', 'no', 'no', 'yes'),
(72, 'CA', 'CAN', 124, '10054', 'CANADA', 'Canada', 'no', '', 'no', 'no', 'yes'),
(73, 'CE', '', 0, '12147', 'CANARY ISL', 'Canary Island', 'no', 'Canary Islands', 'no', 'no', 'yes'),
(74, '', '', 0, '10225', 'CANTON ISL (KIRIBATI)', 'Canton Island (Kiribati)', 'yes', 'Canton Island', 'no', 'no', 'yes'),
(75, 'CV', 'CPV', 132, '1057', 'CAPE VERDE', 'Cape Verde', 'no', '', 'no', 'no', 'yes'),
(76, 'KY', 'CYM', 136, '10058', 'CAYMAN ISL', 'Cayman Island', 'no', 'Cayman Islands', 'no', 'no', 'yes'),
(77, 'CF', 'CAF', 140, '10059', 'CENTRAL AFRICAN REP', 'Central African Rep', 'no', 'Central African Republic', 'no', 'no', 'yes'),
(78, '', '', 0, '10391', 'CEUTA (SPAIN)', 'Ceuta (Spain)', 'yes', 'Ceuta', 'no', 'no', 'yes'),
(79, '', '', 0, '10397', 'CEYLON (SRI LANKA)', 'Ceylon (Sri Lanka)', 'yes', 'Ceylon', 'no', 'no', 'yes'),
(80, 'TD', 'TCD', 148, '10060', 'CHAD', 'Chad', 'no', '', 'no', 'no', 'yes'),
(81, '', '', 0, '10392', 'CHAFERINAS ISL (SPAIN)', 'Chaferinas Island (Spain)', 'yes', 'Chaferinas Islands', 'no', 'no', 'yes'),
(82, '', '', 0, '10153', 'CHALKI (GREECE)', 'Chalki (Greece)', 'yes', 'Chalki', 'no', 'no', 'yes'),
(83, 'NN', '', 0, '12168', 'CHANNEL ISL', 'Channel Island', 'no', 'Channel Islands', 'no', 'no', 'yes'),
(84, '', '', 0, '10141', 'CHANNEL ISL (JERSEY, GUERNSEY...)', 'Channel Island (Jersey, Guernsey...)', 'yes', 'Channel Islands', 'no', 'no', 'no'),
(85, 'CL', 'CHL', 152, '10062', 'CHILE', 'Chile', 'no', '', 'no', 'no', 'yes'),
(86, 'CN', 'CHN', 156, '10063', 'CHINA', 'China', 'no', '', 'no', 'no', 'yes'),
(87, '', '', 0, 'US_CH', 'CHRISTIANSTED (U.S.)', 'Christiansted (U.S.)', 'yes', 'Christiansted, U.S. Virgin Islands', 'yes', 'no', 'yes'),
(88, 'CX', 'CXR', 162, '', 'CHRISTMAS ISL', 'Christmas Island', 'no', 'Christmas Island', 'no', 'no', 'no'),
(89, '', '', 0, '10014', 'CHRISTMAS ISL (AUSTRALIA)', 'Christmas Island (Australia)', 'yes', 'Christmas Island (Australia)', 'no', 'no', 'yes'),
(90, '', '', 0, '10226', 'CHRISTMAS ISL (KIRIBATI)', 'Christmas Island (Kiribati)', 'yes', 'Christmas Island (Kiribati)', 'no', 'no', 'yes'),
(91, '', '', 0, 'US_CM', 'CHUUK (TRUK), MICRONESIA (U.S.)', 'Chuuk (Truk), Micronesia (U.S.)', 'yes', 'Chuuk (Truk), Micronesia', 'yes', 'no', 'yes'),
(92, 'CC', 'CCK', 166, '', 'COCOS (KEELING) ISL', 'Cocos (Keeling) Island', 'no', 'Cocos (Keeling) Islands', 'no', 'no', 'no'),
(93, 'CO', 'COL', 170, '', 'COLOMBIA', 'Colombia', 'no', '', 'no', 'no', 'yes'),
(94, 'KM', 'COM', 174, '10069', 'COMOROS', 'Comoros', 'no', '', 'no', 'no', 'yes'),
(96, 'CD', 'COD', 180, '10073', 'CONGO, THE DEM REP (ZAIRE)', 'Congo, The Dem Rep (Zaire)', 'no', 'Congo, Democratic Republic of the', 'no', 'no', 'yes'),
(97, 'CK', 'COK', 184, '12163', 'COOK ISL', 'Cook Island', 'no', 'Cook Islands', 'no', 'no', 'yes'),
(98, '', '', 0, '10098', 'CORISCO ISL (EQUATORIAL GUINEA)', 'Corisco Island (Equatorial Guinea)', 'yes', 'Corisco Island (Equatorial Guinea)', 'no', 'no', 'yes'),
(99, '', '', 0, '10112', 'CORSICA (FRANCE)', 'Corsica (France)', 'yes', '', 'no', 'no', 'yes'),
(100, 'CR', 'CRI', 188, '10080', 'COSTA RICA', 'Costa Rica', 'no', '', 'no', 'no', 'yes'),
(102, '', '', 0, '10154', 'CRETE (GREECE)', 'Crete (Greece)', 'yes', '', 'no', 'no', 'yes'),
(103, 'HR', '', 0, '10082', 'CROATIA', 'Croatia', 'no', '', 'no', 'no', 'yes'),
(104, 'CU', 'CUB', 192, '10083', 'CUBA', 'Cuba', 'no', '', 'no', 'no', 'yes'),
(105, '', '', 0, '10280', 'CUMINO ISL (MALTA)', 'Cumino Island (Malta)', 'yes', 'Cumino Island (Malta)', 'no', 'no', 'yes'),
(106, 'CB', '', 0, '12177', 'CURACAO', 'Curacao', 'no', '', 'no', 'no', 'yes'),
(107, '', '', 0, '10300', 'CURACAO (NETHERLANDS ANTILLES)', 'Curacao (Netherlands Antilles)', 'yes', '', 'no', 'no', 'yes'),
(108, '', '', 0, '10243', 'CYJRENAICA (LIBYA)', 'Cyjrenaica (Libya)', 'yes', '', 'no', 'no', 'yes'),
(109, 'CY', 'CYP', 196, '10085', 'CYPRUS', 'Cyprus', 'no', '', 'no', 'no', 'yes'),
(110, 'CZ', 'CZE', 203, '10086', 'CZECH REP', 'Czech Rep', 'no', 'Czech Republic', 'no', 'no', 'yes'),
(111, '', '', 0, '10037', 'DAHOMEY (BENIN)', 'Dahomey (Benin)', 'yes', '', 'no', 'no', 'yes'),
(112, '', '', 0, '10194', 'DAMAO (INDIA)', 'Damao (India)', 'yes', '', 'no', 'no', 'yes'),
(113, '', '', 0, '10317', 'DANGER ISL (NEW ZEALAND)', 'Danger Island (New Zealand)', 'yes', 'Danger Islands (New Zealand)', 'no', 'no', 'yes'),
(114, 'DK', 'DNK', 208, '10087', 'DENMARK', 'Denmark', 'no', '', 'no', 'no', 'yes'),
(115, '', '', 0, '10172', 'DESIRADE ISL (GUADELOUPE)', 'Desirade Island (Guadeloupe)', 'yes', 'Desirade Island (Guadeloupe)', 'no', 'no', 'yes'),
(116, '', '', 0, '10195', 'DIU (INDIA)', 'Diu (India)', 'yes', '', 'no', 'no', 'yes'),
(117, 'DJ', 'DJI', 262, '10088', 'DJIBOUTI', 'Djibouti', 'no', '', 'no', 'no', 'yes'),
(118, '', '', 0, '10155', 'DODECANESE ISL (GREECE)', 'Dodecanese Island (Greece)', 'yes', 'Dodecanese Islands (Greece)', 'no', 'no', 'yes'),
(119, '', '', 0, '10363', 'DOHA (QATAR)', 'Doha (Qatar)', 'yes', '', 'no', 'no', 'yes'),
(120, 'DM', 'DMA', 212, '10091', 'DOMINICA', 'Dominica', 'no', '', 'no', 'no', 'yes'),
(121, 'DO', 'DOM', 214, '10092', 'DOMINICAN REP', 'Dominican Rep', 'no', 'Dominican Republic', 'no', 'no', 'yes'),
(122, '', '', 0, '10442', 'DUBAI (U.A. EMIRATES)', 'Dubai (U.A. Emirates)', 'yes', 'Dubai (United Arab Emirates)', 'no', 'no', 'yes'),
(123, '', '', 0, 'US_EI', 'EASTERN ISL, MIDWAY ISL (U.S.)', 'Eastern Island, Midway Island (U.S.)', 'yes', 'Eastern Island, Midway Islands', 'yes', 'no', 'yes'),
(124, '', '', 0, 'US_EM', 'EBEYE, MARSHALL ISLANDS (U.S.)', 'Ebeye, Marshall Islandands (U.S.)', 'yes', 'Ebeye, Marshall Islands', 'yes', 'no', 'yes'),
(125, 'EC', 'ECU', 218, '10093', 'ECUADOR', 'Ecuador', 'no', '', 'no', 'no', 'yes'),
(126, 'EG', 'EGY', 818, '10094', 'EGYPT', 'Egypt', 'no', '', 'no', 'no', 'yes'),
(127, '', '', 0, '10209', 'EIRE (IRELAND)', 'Eire (Ireland)', 'yes', '', 'no', 'no', 'yes'),
(128, 'SV', 'SLV', 222, '10095', 'EL SALVADOR', 'El Salvador', 'no', 'Salvador (El Salvador)', 'no', 'no', 'yes'),
(129, '', '', 0, '10436', 'ELLICE ISLANDS (TUVALU)', 'Ellice Islandands (Tuvalu)', 'yes', '', 'no', 'no', 'yes'),
(130, '', '', 0, '10099', 'ELOBEY ISLANDS (EQUATORIAL GUINEA)', 'Elobey Islandands (Equatorial Guinea)', 'yes', '', 'no', 'no', 'yes'),
(131, '', '', 0, '10227', 'ENDERBURY ISLAND (KIRIBATI)', 'Enderbury Islandand (Kiribati)', 'yes', '', 'no', 'no', 'yes'),
(132, 'EN', '', 0, '10142', 'ENGLAND (GREAT BRITAIN, N. IRELAND)', 'England (Great Britain, N. Ireland)', 'no', 'England (Great Britain and Northern Ireland)', 'no', 'no', 'yes'),
(133, 'GQ', 'GNQ', 226, '10100', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'no', '', 'no', 'no', 'yes'),
(134, 'ER', 'ERI', 232, '10103', 'ERITREA', 'Eritrea', 'no', '', 'no', 'no', 'yes'),
(135, 'EE', 'EST', 233, '10104', 'ESTONIA', 'Estonia', 'no', '', 'no', 'no', 'yes'),
(136, 'ET', 'ETH', 231, '10105', 'ETHIOPIA', 'Ethiopia', 'no', '', 'no', 'no', 'yes'),
(137, 'FO', 'FRO', 234, '', 'FAEROE ISLANDS', 'Faeroe Islandands', 'no', '', 'no', 'no', 'yes'),
(138, '', '', 0, '10506', 'FAKAOFO (WESTERN SAMOA)', 'Fakaofo (Western Samoa)', 'yes', '', 'no', 'no', 'yes'),
(139, 'FK', 'FLK', 238, '', 'FALK ISLANDS (MALVINAS)', 'Falk Islandands (Malvinas)', 'no', '', 'no', 'no', 'no'),
(140, '', '', 0, '10106', 'FALKLAND ISLANDS', 'Falkland Islandands', 'yes', '', 'no', 'no', 'yes'),
(141, '', '', 0, '10228', 'FANNING ISLAND (KIRIBATI)', 'Fanning Islandand (Kiribati)', 'yes', '', 'no', 'no', 'yes'),
(142, '', '', 0, '10101', 'FERNANDO PO (EQUATORIAL GUINEA)', 'Fernando Po (Equatorial Guinea)', 'yes', '', 'no', 'no', 'yes'),
(143, '', '', 0, '10244', 'FEZZAN (LIBYA)', 'Fezzan (Libya)', 'yes', '', 'no', 'no', 'yes'),
(144, 'FJ', 'FJI', 242, '10109', 'FIJI', 'Fiji', 'no', '', 'no', 'no', 'yes'),
(145, 'FI', 'FIN', 246, '10111', 'FINLAND', 'Finland', 'no', '', 'no', 'no', 'yes'),
(146, '', '', 0, '10414', 'FORMOSA (TAIWAN)', 'Formosa (Taiwan)', 'yes', '', 'no', 'no', 'yes'),
(147, 'FR', 'FRA', 250, '10113', 'FRANCE', 'France', 'no', '', 'no', 'no', 'yes'),
(148, 'FX', '', 0, '', 'FRANCE, METROPOLITAN', 'France, Metropolitan', 'no', 'France, Metropolitan (France)', 'no', 'no', 'yes'),
(149, '', '', 0, 'US_FR', 'FREDERIKSTED  (U.S.)', 'Frederiksted  (U.S.)', 'yes', 'Frederiksted, U.S. Virgin Islands', 'yes', 'no', 'yes'),
(150, 'GF', 'GUF', 245, '10117', 'FRENCH GUIANA', 'French Guiana', 'no', '', 'no', 'no', 'yes'),
(151, '', '', 0, '10119', 'FRENCH OCEANIA (FRENCH POLYNESIA)', 'French Oceania (French Polynesia)', 'yes', '', 'no', 'no', 'yes'),
(152, 'PF', 'PYF', 258, '10120', 'FRENCH POLYNESIA', 'French Polynesia', 'no', '', 'no', 'no', 'yes'),
(153, 'TF', 'ATF', 260, '', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', 'no', '', 'no', 'no', 'no'),
(154, '', '', 0, '10090', 'FRENCH TERR, AFARS &AMP; ISSAS (DJIBOUTI)', 'French Terr, Afars &amp; Issas (Djibouti)', 'yes', 'French Territory of the Afars and Issas (Djibouti)', 'no', 'no', 'yes'),
(155, '', '', 0, '10173', 'FRENCH W. INDIES (GUADELOUPE ...)', 'French W. Indies (Guadeloupe ...)', 'yes', 'French West Indies (Guadeloupe or Martinique)', 'no', 'no', 'yes'),
(156, '', '', 0, '10426', 'FRIENDLY ISLANDS (TONGA)', 'Friendly Islandands (Tonga)', 'yes', '', 'no', 'no', 'yes'),
(157, '', '', 0, '10443', 'FUJAIRAH (U.A. EMIRATES)', 'Fujairah (U.A. Emirates)', 'yes', 'Fujairah (United Arab Emirates)', 'no', 'no', 'yes'),
(158, '', '', 0, '12071', 'FUTUNA (WALLIS AND FUTUNA ISLANDS)', 'Futuna (Wallis And Futuna Islandands)', 'yes', '', 'no', 'no', 'yes'),
(159, 'GA', 'GAB', 999, '10134', 'GABON', 'Gabon', 'no', '', 'no', 'no', 'yes'),
(160, 'GM', 'GMB', 270, '10135', 'GAMBIA', 'Gambia', 'no', '', 'no', 'no', 'yes'),
(161, '', '', 0, '10121', 'GAMBIER (FRENCH POLYNESIA)', 'Gambier (French Polynesia)', 'yes', '', 'no', 'no', 'yes'),
(162, 'GE', 'GEO', 268, '10136', 'GEORGIA, REP OF', 'Georgia, Rep Of', 'no', 'Georgia, Republic of', 'no', 'no', 'yes'),
(163, 'DE', 'DEU', 276, '10137', 'GERMANY', 'Germany', 'no', '', 'no', 'no', 'yes'),
(164, 'GH', 'GHA', 288, '10138', 'GHANA', 'Ghana', 'no', '', 'no', 'no', 'yes'),
(165, 'GI', 'GIB', 292, '10139', 'GIBRALTAR', 'Gibraltar', 'no', '', 'no', 'no', 'yes'),
(166, '', '', 0, '10229', 'GILBERT ISLANDS (KIRIBATI)', 'Gilbert Islandands (Kiribati)', 'yes', '', 'no', 'no', 'yes'),
(167, '', '', 0, '10196', 'GOA (INDIA)', 'Goa (India)', 'yes', '', 'no', 'no', 'yes'),
(168, '', '', 0, '10281', 'GOZO ISLAND (MALTA)', 'Gozo Islandand (Malta)', 'yes', '', 'no', 'no', 'yes'),
(169, '', '', 0, '10070', 'GRAND COMORO (COMOROS)', 'Grand Comoro (Comoros)', 'yes', '', 'no', 'no', 'yes'),
(170, '', '', 0, '10143', 'GREAT BRITAIN &AMP; NORTHERN IRELAND', 'Great Britain &amp; Northern Ireland', 'yes', 'Great Britain and Northern Ireland', 'no', 'no', 'yes'),
(171, 'GR', 'GRC', 300, '10156', 'GREECE', 'Greece', 'no', '', 'no', 'no', 'yes'),
(172, 'GL', 'GRL', 304, '10169', 'GREENLAND', 'Greenland', 'no', '', 'no', 'no', 'yes'),
(173, 'GD', 'GRD', 308, '10170', 'GRENADA', 'Grenada', 'no', '', 'no', 'no', 'yes'),
(174, '', '', 0, '10406', 'GRENADINES (ST. VINCENT ...)', 'Grenadines (St. Vincent ...)', 'yes', 'Grenadines (St. Vincent and the Grenadines)', 'no', 'no', 'no'),
(175, 'GP', 'GLP', 312, '10174', 'GUADELOUPE', 'Guadeloupe', 'no', '', 'no', 'no', 'yes'),
(176, 'GU', 'GUM', 316, 'US_GM', 'GUAM (U.S.)', 'Guam (U.S.)', 'no', 'Guam', 'yes', 'no', 'yes'),
(177, 'GT', 'GTM', 320, '10181', 'GUATEMALA', 'Guatemala', 'no', '', 'no', 'no', 'yes'),
(178, '', '', 0, '12003', 'GUERNSEY, CHANNEL ISLANDS (G.B.)', 'Guernsey, Channel Islandands (G.B.)', 'yes', 'Guernsey, Channel Islands (Great Britain)', 'no', 'no', 'yes'),
(179, 'GN', 'GIN', 324, '10182', 'GUINEA', 'Guinea', 'no', '', 'no', 'no', 'yes'),
(180, 'GW', 'GNB', 624, '10183', 'GUINEA-BISSAU', 'Guinea-bissau', 'no', '', 'no', 'no', 'yes'),
(181, 'GY', 'GUY', 328, '10185', 'GUYANA', 'Guyana', 'no', '', 'no', 'no', 'yes'),
(182, '', '', 0, '10064', 'HAINAN ISLAND (CHINA)', 'Hainan Islandand (China)', 'yes', '', 'no', 'no', 'yes'),
(183, 'HT', 'HTI', 332, '10186', 'HAITI', 'Haiti', 'no', '', 'no', 'no', 'yes'),
(184, '', '', 0, '10220', 'HASHEMITE KINGDOM (JORDAN)', 'Hashemite Kingdom (Jordan)', 'yes', '', 'no', 'no', 'yes'),
(185, 'HM', 'HMD', 334, '', 'HEARD &AMP; MCDONALD ISLANDS', 'Heard &amp; Mcdonald Islandands', 'no', 'Heard and McDonald Islands', 'no', 'no', 'no'),
(186, '', '', 0, '10318', 'HERVEY (COOK ISLANDS, N. ZEALAND)', 'Hervey (Cook Islandands, N. Zealand)', 'yes', 'Hervey (Cook Islands) (New Zealand)', 'no', 'no', 'no'),
(187, '', '', 0, '10122', 'HIVAOA (FRENCH POLYNESIA)', 'Hivaoa (French Polynesia)', 'yes', '', 'no', 'no', 'yes'),
(188, 'HO', '', 0, '12099', 'HOLLAND', 'Holland', 'no', '', 'no', 'no', 'yes'),
(189, 'HN', 'HND', 340, '10187', 'HONDURAS', 'Honduras', 'no', '', 'no', 'no', 'yes'),
(190, 'HK', 'HKG', 344, '10189', 'HONG KONG', 'Hong Kong', 'no', '', 'no', 'no', 'yes'),
(191, '', '', 0, 'US_HI', 'HOWLAND ISLAND (U.S.)', 'Howland Islandand (U.S.)', 'yes', 'Howland Island (U.S. Possession)', 'yes', 'no', 'yes'),
(192, '', '', 0, '10123', 'HUAHINE (FRENCH POLYNESIA)', 'Huahine (French Polynesia)', 'yes', '', 'no', 'no', 'yes'),
(193, '', '', 0, '10310', 'HUAN ISLAND (NEW CALEDONIA)', 'Huan Islandand (New Caledonia)', 'yes', '', 'no', 'no', 'yes'),
(194, 'HU', 'HUN', 191, '10191', 'HUNGARY', 'Hungary', 'no', '', 'no', 'no', 'yes'),
(195, 'IS', 'ISL', 352, '10192', 'ICELAND', 'Iceland', 'no', '', 'no', 'no', 'yes'),
(196, 'IN', 'IND', 356, '10197', 'INDIA', 'India', 'no', '', 'no', 'no', 'yes'),
(197, 'ID', 'IND', 360, '10202', 'INDONESIA', 'Indonesia', 'no', '', 'no', 'no', 'yes'),
(198, 'IR', 'IRN', 364, '10206', 'IRAN', 'Iran', 'no', '', 'no', 'no', 'yes'),
(199, 'IQ', 'IRQ', 368, '10208', 'IRAQ', 'Iraq', 'no', '', 'no', 'no', 'yes'),
(200, 'IE', 'IRL', 372, '10210', 'IRELAND', 'Ireland', 'no', '', 'no', 'no', 'yes'),
(201, '', '', 0, '10203', 'IRIAN BARAT (INDONESIA)', 'Irian Barat (Indonesia)', 'yes', '', 'no', 'no', 'yes'),
(202, '', '', 0, '10145', 'ISLE OF MAN (GREAT BRITAIN)', 'Isle Of Man (Great Britain)', 'yes', '', 'no', 'no', 'yes'),
(203, '', '', 0, '10311', 'ISLE OF PINES (NEW CALEDONIA)', 'Isle Of Pines (New Caledonia)', 'yes', '', 'no', 'no', 'yes'),
(204, '', '', 0, '10084', 'ISLE OF PINES, W. INDIES (CUBA)', 'Isle Of Pines, W. Indies (Cuba)', 'yes', 'Isle of Pines, West Indies (Cuba)', 'no', 'no', 'no'),
(205, 'IL', 'ISR', 376, '10211', 'ISRAEL', 'Israel', 'no', '', 'no', 'no', 'yes'),
(206, 'IT', 'ITA', 380, '10212', 'ITALY', 'Italy', 'no', '', 'no', 'no', 'yes'),
(207, 'JM', 'JAM', 388, '10213', 'JAMAICA', 'Jamaica', 'no', '', 'no', 'no', 'yes'),
(208, 'JP', 'JPN', 392, '10214', 'JAPAN', 'Japan', 'no', '', 'no', 'no', 'yes'),
(209, '', '', 0, 'US_JI', 'JARVIS ISLAND (U.S.)', 'Jarvis Islandand (U.S.)', 'yes', 'Jarvis Island', 'yes', 'no', 'yes'),
(210, '', '', 0, '10146', 'JERSEY (CHANNEL ISL, G.B.)', 'Jersey (Channel Island, G.B.)', 'yes', 'Jersey (Channel Islands) (Great Britain)', 'no', 'no', 'yes'),
(211, '', '', 0, 'US_JL', 'JOHNSTON ISLAND (U.S.)', 'Johnston Islandand (U.S.)', 'yes', 'Johnston Island (U.S. Possession)', 'yes', 'no', 'yes'),
(212, '', '', 0, '10259', 'JOHORE (MALAYSIA)', 'Johore (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(213, 'JO', 'JOR', 400, '10221', 'JORDAN', 'Jordan', 'no', '', 'no', 'no', 'yes'),
(214, '', '', 0, '10157', 'KALYMNOS (GREECE)', 'Kalymnos (Greece)', 'yes', '', 'no', 'no', 'yes'),
(215, '', '', 0, '10052', 'KAMPUCHEA (CAMBODIA)', 'Kampuchea (Cambodia)', 'yes', '', 'no', 'no', 'yes'),
(216, '', '', 0, '10158', 'KARPATHOS (GREECE)', 'Karpathos (Greece)', 'yes', '', 'no', 'no', 'yes'),
(217, '', '', 0, '10159', 'KASSOS (GREECE)', 'Kassos (Greece)', 'yes', '', 'no', 'no', 'yes'),
(218, '', '', 0, '10160', 'KASTELLORIZON (GREECE)', 'Kastellorizon (Greece)', 'yes', '', 'no', 'no', 'yes'),
(219, 'KZ', 'KAZ', 398, '10223', 'KAZAKHSTAN', 'Kazakhstan', 'no', '', 'no', 'no', 'yes'),
(220, '', '', 0, '10260', 'KEDAH (MALAYSIA)', 'Kedah (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(221, '', '', 0, '10016', 'KEELING ISLANDS (AUSTRALIA)', 'Keeling Islandands (Australia)', 'yes', '', 'no', 'no', 'yes'),
(222, '', '', 0, '10261', 'KELANTAN (MALAYSIA)', 'Kelantan (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(223, 'KE', 'KEN', 404, '10224', 'KENYA', 'Kenya', 'no', '', 'no', 'no', 'yes'),
(224, '', '', 0, 'US_RF', 'KINGMAN REEF (U.S.)', 'Kingman Reef (U.S.)', 'yes', 'Kingman Reef (U.S. Possession)', 'yes', 'no', 'yes'),
(225, '', '', 0, 'US_KH', 'KINGSHILL (U.S.)', 'Kingshill (U.S.)', 'yes', 'Kingshill, U.S. Virgin Islands', 'yes', 'no', 'yes'),
(226, 'KI', 'KIR', 296, '10230', 'KIRIBATI', 'Kiribati', 'no', '', 'no', 'no', 'yes'),
(228, 'KR', 'PRK', 408, '10234', 'KOREA, REP (SOUTH)', 'Korea, Rep (South)', 'no', 'South Korea (Korea, Republic of)', 'no', 'no', 'yes'),
(229, '', '', 0, 'US_KR', 'KOROR (U.S.)', 'Koror (U.S.)', 'yes', 'Koror', 'yes', 'no', 'yes'),
(230, '', '', 0, '10161', 'KOS (GREECE)', 'Kos (Greece)', 'yes', '', 'no', 'no', 'yes'),
(231, 'KO', '', 0, '', 'KOSRAE', 'Kosrae', 'no', '', 'no', 'no', 'yes'),
(232, '', '', 0, 'US_KM', 'KOSRAE, MICRONESIA (U.S.)', 'Kosrae, Micronesia (U.S.)', 'yes', 'Kosrae, Micronesia', 'yes', 'no', 'yes'),
(233, '', '', 0, '10190', 'KOWLOON (HONG KONG)', 'Kowloon (Hong Kong)', 'yes', '', 'no', 'no', 'yes'),
(234, 'KW', 'KWT', 414, '10236', 'KUWAIT', 'Kuwait', 'no', '', 'no', 'no', 'yes'),
(235, '', '', 0, 'US_MI', 'KWAJALEIN, MARSHALL ISLANDS (U.S.)', 'Kwajalein, Marshall Islandands (U.S.)', 'yes', 'Kwajalein, Marshall Islands', 'yes', 'no', 'yes'),
(236, 'KG', '', 0, '10237', 'KYRGYZSTAN', 'Kyrgyzstan', 'no', '', 'no', 'no', 'yes'),
(237, '', '', 0, '10055', 'LABRADOR (CANADA)', 'Labrador (Canada)', 'yes', '', 'no', 'no', 'no'),
(238, '', '', 0, '10262', 'LABUAN (MALAYSIA)', 'Labuan (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(240, 'LV', 'LVA', 428, '10239', 'LATVIA', 'Latvia', 'no', '', 'no', 'no', 'yes'),
(241, 'LB', 'LBN', 422, '10240', 'LEBANON', 'Lebanon', 'no', '', 'no', 'no', 'yes'),
(242, '', '', 0, '10162', 'LEIPSOS (GREECE)', 'Leipsos (Greece)', 'yes', '', 'no', 'no', 'yes'),
(243, '', '', 0, '10163', 'LEROS (GREECE)', 'Leros (Greece)', 'yes', '', 'no', 'no', 'yes'),
(244, '', '', 0, '10175', 'LES ST. ISLAND (GUADELOUPE)', 'Les St. Islandand (Guadeloupe)', 'yes', 'Les Saints Island (Guadeloupe)', 'no', 'no', 'yes'),
(245, 'LS', 'LSO', 426, '10241', 'LESOTHO', 'Lesotho', 'no', '', 'no', 'no', 'yes'),
(246, 'LR', 'LBR', 430, '10242', 'LIBERIA', 'Liberia', 'no', '', 'no', 'no', 'yes'),
(247, 'LY', 'LBY', 434, '10245', 'LIBYAN ARAB JAMAHIRIYA (LIBYA)', 'Libyan Arab Jamahiriya (Libya)', 'no', 'Libya', 'no', 'no', 'yes'),
(248, 'LI', 'LIE', 438, '10247', 'LIECHTENSTEIN', 'Liechtenstein', 'no', '', 'no', 'no', 'yes'),
(249, 'LT', 'LTU', 440, '10248', 'LITHUANIA', 'Lithuania', 'no', '', 'no', 'no', 'yes'),
(250, '', '', 0, '10017', 'LORD HOWE ISLAND (AUSTRALIA)', 'Lord Howe Islandand (Australia)', 'yes', '', 'no', 'no', 'yes'),
(251, '', '', 0, '10312', 'LOYALTY ISLANDS (NEW CALEDONIA)', 'Loyalty Islandands (New Caledonia)', 'no', 'Loyalty Islands (New Caledonia)', 'no', 'no', 'yes'),
(252, 'LU', 'LUX', 442, '10249', 'LUXEMBOURG', 'Luxembourg', 'no', '', 'no', 'no', 'yes'),
(253, 'MO', 'MAC', 0, '10250', 'MACAO', 'Macao', 'no', '', 'no', 'no', 'yes'),
(254, '', '', 0, '10251', 'MACAU (MACAO)', 'Macau (Macao)', 'yes', '', 'no', 'no', 'yes'),
(255, 'MK', 'MKD', 807, '10252', 'MACEDONIA, REPUBLIC OF', 'Macedonia, Republic Of', 'no', '', 'no', 'no', 'yes'),
(256, 'MG', 'MDG', 450, '10253', 'MADAGASCAR', 'Madagascar', 'no', '', 'no', 'no', 'yes'),
(257, 'ME', '', 0, '', 'MADEIRA', 'Madeira', 'no', '', 'no', 'no', 'no'),
(258, '', '', 0, '10360', 'MADEIRA ISLANDS (PORTUGAL)', 'Madeira Islandands (Portugal)', 'yes', '', 'no', 'no', 'yes'),
(259, '', '', 0, 'US_MM', 'MAJURO, MARSHALL ISLANDS (U.S.)', 'Majuro, Marshall Islandands (U.S.)', 'yes', 'Majuro, Marshall Islands', 'yes', 'no', 'yes'),
(260, '', '', 0, '10263', 'MALACCA (MALAYSIA)', 'Malacca (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(261, '', '', 0, '10254', 'MALAGASY REP (MADAGASCAR)', 'Malagasy Rep (Madagascar)', 'yes', 'Malagasy Republic (Madagascar)', 'no', 'no', 'yes'),
(262, 'MW', 'MWI', 454, '10256', 'MALAWI', 'Malawi', 'no', '', 'no', 'no', 'yes'),
(263, '', '', 0, '12264', 'MALAYA (MALAYSIA)', 'Malaya (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(264, 'MY', 'MYS', 458, '10265', 'MALAYSIA', 'Malaysia', 'no', '', 'no', 'no', 'yes'),
(265, 'MV', 'MDV', 462, '10278', 'MALDIVES', 'Maldives', 'no', '', 'no', 'no', 'yes'),
(266, 'ML', 'MLI', 466, '10279', 'MALI', 'Mali', 'no', '', 'no', 'no', 'yes'),
(267, 'MT', 'MLT', 470, '10282', 'MALTA', 'Malta', 'no', '', 'no', 'no', 'yes'),
(268, '', '', 0, '10319', 'MANAHIKI (NEW ZEALAND)', 'Manahiki (New Zealand)', 'yes', '', 'no', 'no', 'yes'),
(269, '', '', 0, '10065', 'MANCHURIA (CHINA)', 'Manchuria (China)', 'yes', '', 'no', 'no', 'yes'),
(270, '', '', 0, '10320', 'MANGAIA (COOK ISLANDS, N. ZEALAND)', 'Mangaia (Cook Islandands, N. Zealand)', 'yes', 'Mangaia (Cook Islands) (New Zealand)', 'no', 'no', 'no'),
(271, '', '', 0, 'US_ML', 'MANUA ISLANDS, AMER SAMOA (U.S)', 'Manua Islandands, Amer Samoa (U.s)', 'yes', 'Manua Islands, American Samoa (U.S. Possession)', 'yes', 'no', 'yes'),
(272, '', '', 0, '10176', 'MARIE GALANTE (GUADELOUPE)', 'Marie Galante (Guadeloupe)', 'yes', '', 'no', 'no', 'yes'),
(273, '', '', 0, '10124', 'MARQUESAS ISL (FRENCH POLYNESIA)', 'Marquesas Island (French Polynesia)', 'yes', 'Marquesas Islands (French Polynesia)', 'no', 'no', 'yes'),
(274, 'MH', 'MHL', 584, '', 'MARSHALL ISLANDS (U.S.)', 'Marshall Islandands (U.S.)', 'no', 'Marshall Islands', 'yes', 'no', 'yes'),
(275, 'MQ', 'MTQ', 474, '10283', 'MARTINIQUE', 'Martinique', 'no', '', 'no', 'no', 'yes'),
(276, '', '', 0, '10322', 'MAUKE (COOK ISL N. ZEALAND)', 'Mauke (Cook Island N. Zealand)', 'yes', 'Mauke (Cook Islands) (New Zealand)', 'no', 'no', 'no'),
(277, 'MR', 'MRT', 478, '10284', 'MAURITANIA, ISLAMIC REP', 'Mauritania, Islandamic Rep', 'no', 'Mauritania', 'no', 'no', 'yes'),
(278, 'MU', 'MUS', 480, '10285', 'MAURITIUS', 'Mauritius', 'no', '', 'no', 'no', 'yes'),
(279, '', '', 0, '10115', 'MAYOTTE (FRANCE)', 'Mayotte (France)', 'yes', '', 'no', 'no', 'yes'),
(280, '', '', 0, '10393', 'MELILLA (SPAIN)', 'Melilla (Spain)', 'no', '', 'no', 'no', 'yes'),
(281, 'MX', 'MEX', 484, '10287', 'MEXICO', 'Mexico', 'no', '', 'no', 'no', 'yes'),
(282, 'FM', 'FSM', 583, '', 'MICRONESIA (U.S.)', 'Micronesia (U.S.)', 'no', 'Micronesia, Federated States of', 'yes', 'no', 'yes'),
(283, '', '', 0, 'US_MA', 'MIDWAY ISL (U.S.)', 'Midway Island (U.S.)', 'yes', 'Midway Islands (U.S. Possession)', 'yes', 'no', 'yes'),
(284, '', '', 0, '10404', 'MIQUELON (ST. PIERRE AND MIQUELON)', 'Miquelon (St. Pierre And Miquelon)', 'yes', '', 'no', 'no', 'yes'),
(285, '', '', 0, '10323', 'MITIARO (COOK ISL, N. ZEALAND)', 'Mitiaro (Cook Island, N. Zealand)', 'yes', 'Mitiaro (Cook Islands) (New Zealand)', 'no', 'no', 'no'),
(286, '', '', 0, '10071', 'MOHELI (COMOROS)', 'Moheli (Comoros)', 'yes', '', 'no', 'no', 'yes'),
(287, '', '', 0, '10288', 'MOLDOVA', 'Moldova', 'yes', '', 'no', 'no', 'yes'),
(288, 'MD', 'MDA', 498, '', 'MOLDOVA, REP', 'Moldova, Rep', 'no', 'Moldova', 'no', 'no', 'yes'),
(289, 'MC', 'MCO', 492, '12276', 'MONACO', 'Monaco', 'no', '', 'no', 'no', 'yes'),
(290, '', '', 0, '10116', 'MONACO (FRANCE)', 'Monaco (France)', 'yes', '', 'no', 'no', 'yes'),
(291, 'MN', 'MNG', 496, '10289', 'MONGOLIA', 'Mongolia', 'no', '', 'no', 'no', 'yes'),
(292, 'MS', 'MSR', 500, '10290', 'MONTSERRAT', 'Montserrat', 'no', '', 'no', 'no', 'yes'),
(293, '', '', 0, '10125', 'MOOREA (FRENCH POLYNESIA)', 'Moorea (French Polynesia)', 'yes', '', 'no', 'no', 'yes'),
(294, 'MA', 'MAR', 504, '10291', 'MOROCCO', 'Morocco', 'no', '', 'no', 'no', 'yes'),
(295, 'MZ', 'MOZ', 508, '10292', 'MOZAMBIQUE', 'Mozambique', 'no', '', 'no', 'no', 'yes'),
(296, '', '', 0, '10340', 'MUSCAT (OMAN)', 'Muscat (Oman)', 'yes', '', 'no', 'no', 'yes'),
(297, 'MM', 'MMR', 104, '10049', 'MYANMAR (BURMA)', 'Myanmar (Burma)', 'no', '', 'no', 'no', 'yes'),
(298, 'NA', 'NAM', 516, '10293', 'NAMIBIA', 'Namibia', 'no', 'South-West Africa (Namibia)', 'no', 'no', 'yes'),
(299, '', '', 0, '10215', 'NANSIL ISLANDS (RYUKYU ISL) (JAPAN)', 'Nansil Islandands (Ryukyu Island) (japan)', 'yes', 'Nansil Islands (Ryukyu Islands) (Japan)', 'no', 'no', 'yes'),
(300, 'NR', 'NRU', 520, '10295', 'NAURU', 'Nauru', 'no', '', 'no', 'no', 'yes'),
(301, '', '', 0, 'US_NI', 'NAVASSA ISL (U.S.)', 'Navassa Island (U.S.)', 'yes', 'Navassa Island (U.S. Possession)', 'yes', 'no', 'yes'),
(302, '', '', 0, '12248', 'NEGRI SEMBILAN (MALAYSIA)', 'Negri Sembilan (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(303, 'NP', 'NPL', 524, '10296', 'NEPAL', 'Nepal', 'no', '', 'no', 'no', 'yes'),
(304, 'AN', 'ANT', 530, '10301', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'no', '', 'no', 'no', 'yes'),
(305, '', '', 0, '10302', 'NETHERLANDS W. INDIES (N. ANTILLES)', 'Netherlands W. Indies (N. Antilles)', 'yes', 'Netherlands West Indies (Netherlands Antilles)', 'no', 'no', 'yes'),
(306, 'NL', 'NLD', 528, '', 'NETHERLANDS', 'Netherlands', 'no', '', 'no', 'no', 'yes'),
(307, 'NV', '', 0, '12250', 'NEVIS', 'Nevis', 'no', '', 'no', 'no', 'no'),
(308, 'KN', '', 0, '10399', 'NEVIS (ST. CHRISTOPHER &AMP; NEVIS)', 'Nevis (St. Christopher &amp; Nevis)', 'no', 'Nevis (St. Christopher and Nevis)', 'no', 'no', 'yes'),
(309, '', '', 0, '10349', 'NEW BRITAIN (PAPUA NEW GUINEA)', 'New Britain (Papua New Guinea)', 'yes', '', 'no', 'no', 'yes'),
(310, 'NC', 'NCL', 540, '10313', 'NEW CALEDONIA', 'New Caledonia', 'no', '', 'no', 'no', 'yes'),
(311, '', '', 0, '10350', 'NEW HANOVER (PAPUA NEW GUINEA)', 'New Hanover (Papua New Guinea)', 'yes', '', 'no', 'no', 'yes'),
(312, '', '', 0, '10497', 'NEW HEBRIDES (VANUATU)', 'New Hebrides (Vanuatu)', 'yes', '', 'no', 'no', 'yes'),
(313, '', '', 0, '10351', 'NEW IRELAND (PAPUA NEW GUINEA)', 'New Ireland (Papua New Guinea)', 'yes', '', 'no', 'no', 'yes'),
(314, '', '', 0, '10018', 'NEW SOUTH WALES (AUSTRALIA)', 'New South Wales (Australia)', 'yes', '', 'no', 'no', 'yes'),
(315, 'NZ', 'NZL', 554, '10324', 'NEW ZEALAND', 'New Zealand', 'no', '', 'no', 'no', 'yes'),
(316, '', '', 0, '10056', 'NEWFOUNDLAND (CANADA)', 'Newfoundland (Canada)', 'yes', '', 'no', 'no', 'no'),
(317, 'NI', 'NIC', 558, '10335', 'NICARAGUA', 'Nicaragua', 'no', '', 'no', 'no', 'yes'),
(318, 'NE', 'NER', 562, '10336', 'NIGER', 'Niger', 'no', '', 'no', 'no', 'yes'),
(319, 'NG', 'NGA', 566, '10337', 'NIGERIA', 'Nigeria', 'no', '', 'no', 'no', 'yes'),
(320, '', '', 0, '10164', 'NISSIROS (GREECE)', 'Nissiros (Greece)', 'yes', '', 'no', 'no', 'yes'),
(321, 'NU', 'NIU', 570, '12258', 'NIUE', 'Niue', 'no', '', 'no', 'no', 'yes'),
(322, '', '', 0, '10325', 'NIUE (NEW ZEALAND)', 'Niue (New Zealand)', 'yes', '', 'no', 'no', 'yes'),
(323, 'NF', 'NFK', 574, '12259', 'NORFOLK ISL', 'Norfolk Island', 'no', 'Norfolk Island', 'no', 'no', 'yes'),
(324, '', '', 0, '10267', 'NORTH BORNEO (MALAYSIA)', 'North Borneo (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(325, 'NB', '', 0, '1227', 'NORTHERN IRELAND', 'Northern Ireland', 'no', '', 'no', 'no', 'yes'),
(326, 'MP', 'MNP', 580, '', 'NORTHERN MARIANA ISL (U.S.)', 'Northern Mariana Island (U.S.)', 'no', 'Northern Mariana Islands, Commonwealth of', 'yes', 'no', 'yes'),
(327, 'NO', 'NOR', 578, '10338', 'NORWAY', 'Norway', 'no', '', 'no', 'no', 'yes'),
(328, '', '', 0, '10126', 'NUKAHIVA (FRENCH POLYNESIA)', 'Nukahiva (French Polynesia)', 'yes', '', 'no', 'no', 'yes'),
(329, '', '', 0, '10507', 'NUKUNONU (WESTERN SAMOA)', 'Nukunonu (Western Samoa)', 'yes', '', 'no', 'no', 'yes'),
(330, '', '', 0, '10257', 'NYASALAND (MALAWI)', 'Nyasaland (Malawi)', 'yes', '', 'no', 'no', 'yes'),
(331, '', '', 0, '10231', 'OCEAN ISL (KIRIBATI)', 'Ocean Island (Kiribati)', 'yes', 'Ocean Island (Kiribati)', 'no', 'no', 'yes'),
(332, '', '', 0, '10217', 'OKINAWA (RYUKYU ISL, JAPAN)', 'Okinawa (Ryukyu Island, Japan)', 'yes', 'Okinawa (Ryukyu Islands) (Japan)', 'no', 'no', 'yes'),
(333, 'OM', 'OMN', 512, '10341', 'OMAN', 'Oman', 'no', '', 'no', 'no', 'yes'),
(334, '', '', 0, 'US_PP', 'PAGO PAGO, AMERICAN SAMOA (U.S.)', 'Pago Pago, American Samoa (U.S.)', 'yes', 'Pago Pago, American Samoa (U.S. Possession)', 'yes', 'no', 'yes'),
(335, '', '', 0, '10268', 'PAHANG (MALAYSIA)', 'Pahang (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(336, 'PK', 'PAK', 586, '10343', 'PAKISTAN', 'Pakistan', 'no', '', 'no', 'no', 'yes'),
(337, 'PW', 'PLW', 585, '', 'PALAU (U.S.)', 'Palau (U.S.)', 'no', 'Palau', 'yes', 'no', 'yes'),
(338, 'PS', 'PSE', 275, '', 'PALESTINIAN TERRITORY', 'Palestinian Territory', 'no', '', 'no', 'no', 'no'),
(339, '', '', 0, '10326', 'PALMERSTON (AVARUA, N. ZEALAND)', 'Palmerston (Avarua, N. Zealand)', 'yes', 'Palmerston (Avarua) (New Zealand)', 'no', 'no', 'yes'),
(340, '', '', 0, 'US_PI', 'PALMYRA ISL (U.S.)', 'Palmyra Island (U.S.)', 'yes', 'Palmyra Island (U.S. Possession)', 'yes', 'no', 'yes'),
(341, 'PA', 'PAN', 591, '10344', 'PANAMA', 'Panama', 'no', '', 'no', 'no', 'yes'),
(342, 'PG', 'PNG', 598, '10352', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'no', '', 'no', 'no', 'yes'),
(343, 'PY', 'PRY', 600, '10353', 'PARAGUAY', 'Paraguay', 'no', '', 'no', 'no', 'yes'),
(344, '', '', 0, '10327', 'PARRY (COOK ISL, N. ZEALAND)', 'Parry (Cook Island, N. Zealand)', 'yes', 'Parry (Cook Islands) (New Zealand)', 'no', 'no', 'no'),
(345, '', '', 0, '10165', 'PATMOS (GREECE)', 'Patmos (Greece)', 'yes', '', 'no', 'no', 'yes'),
(346, '', '', 0, '10420', 'PEMBA (TANZANIA)', 'Pemba (Tanzania)', 'yes', '', 'no', 'no', 'yes'),
(347, '', '', 0, '10269', 'PENANG (MALAYSIA)', 'Penang (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(348, '', '', 0, '10415', 'PENGHU ISL (TAIWAN)', 'Penghu Island (Taiwan)', 'yes', 'Penghu Islands (Taiwan)', 'no', 'no', 'yes'),
(349, '', '', 0, '12308', 'PENON DE VELEZ DE LA GOMERA (SPAIN)', 'Penon De Velez De La Gomera (Spain)', 'yes', '', 'no', 'no', 'yes'),
(350, '', '', 0, '10328', 'PENRHYN (TONGAREVA, N. ZEALAND)', 'Penrhyn (Tongareva, N. Zealand)', 'yes', 'Penrhyn (Tongareva) (New Zealand)', 'no', 'no', 'yes'),
(351, '', '', 0, '10270', 'PERAK (MALAYSIA)', 'Perak (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(352, '', '', 0, '10271', 'PERLIS (MALAYSIA)', 'Perlis (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(353, '', '', 0, '12302', 'PERSIA (IRAN)', 'Persia (Iran)', 'yes', '', 'no', 'no', 'yes'),
(354, 'PE', 'PER', 604, '10354', 'PERU', 'Peru', 'no', '', 'no', 'no', 'yes'),
(355, '', '', 0, '10416', 'PESCADORES ISL (TAIWAN)', 'Pescadores Island (Taiwan)', 'yes', 'Pescadores Islands (Taiwan)', 'no', 'no', 'yes'),
(356, '', '', 0, '10177', 'PETITE TERRE (GUADELOUPE)', 'Petite Terre (Guadeloupe)', 'yes', '', 'no', 'no', 'yes'),
(357, 'PH', 'PHL', 608, '10355', 'PHILIPPINES', 'Philippines', 'no', '', 'no', 'no', 'yes'),
(358, '', '', 0, '10356', 'PITCAIRN ISL', 'Pitcairn Island', 'yes', 'Pitcairn Island', 'no', 'no', 'yes'),
(359, '', '', 0, 'US_PM', 'POHNPEI, MICRONESIA (U.S.)', 'Pohnpei, Micronesia (U.S.)', 'yes', 'Pohnpei, Micronesia', 'yes', 'no', 'yes'),
(360, 'PL', 'POL', 616, '10357', 'POLAND', 'Poland', 'no', '', 'no', 'no', 'yes'),
(361, 'PO', '', 0, '', 'PONAPE', 'Ponape', 'no', '', 'no', 'no', 'yes'),
(362, 'PT', 'PRT', 620, '10362', 'PORTUGAL', 'Portugal', 'no', '', 'no', 'no', 'yes'),
(363, '', '', 0, '10272', 'PROVINCE WELLESLEY (MALAYSIA)', 'Province Wellesley (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(364, 'PR', 'PRI', 630, 'US_PR', 'PUERTO RICO (U.S.)', 'Puerto Rico (U.S.)', 'no', 'Puerto Rico', 'yes', 'no', 'yes'),
(365, '', '', 0, '10329', 'PUKAPUKA (NEW ZEALAND)', 'Pukapuka (New Zealand)', 'yes', '', 'no', 'no', 'yes'),
(366, 'QA', 'QAT', 634, '10364', 'QATAR', 'Qatar', 'no', '', 'no', 'no', 'yes'),
(367, '', '', 0, '10020', 'QUEENSLAND (AUSTRALIA)', 'Queensland (Australia)', 'yes', '', 'no', 'no', 'yes'),
(368, '', '', 0, '10417', 'QUEMOY (TAIWAN)', 'Quemoy (Taiwan)', 'yes', '', 'no', 'no', 'yes'),
(369, '', '', 0, '10127', 'RAIATEA (FRENCH POLYNESIA)', 'Raiatea (French Polynesia)', 'yes', '', 'no', 'no', 'yes'),
(370, '', '', 0, '10330', 'RAKAANGA (NEW ZEALAND)', 'Rakaanga (New Zealand)', 'yes', '', 'no', 'no', 'yes'),
(371, '', '', 0, '10128', 'RAPA (FRENCH POLYNESIA)', 'Rapa (French Polynesia)', 'yes', '', 'no', 'no', 'yes'),
(372, '', '', 0, '10331', 'RAROTONGA (COOK ISL, N. ZEALAND)', 'Rarotonga (Cook Island, N. Zealand)', 'yes', 'Rarotonga (Cook Islands) (New Zealand)', 'no', 'no', 'no'),
(373, '', '', 0, '10444', 'RAS AL KAIMAH (U.A. EMIRATES)', 'Ras Al Kaimah (U.A. Emirates)', 'yes', 'Ras al Kaimah (United Arab Emirates)', 'no', 'no', 'yes'),
(374, '', '', 0, '10008', 'REDONDA (ANTIGUA AND BARBUDA)', 'Redonda (Antigua And Barbuda)', 'yes', '', 'no', 'no', 'yes'),
(375, 'RE', '638', 0, '10367', 'REUNION', 'Reunion', 'no', '', 'no', 'no', 'yes'),
(376, '', '', 0, '10102', 'RIO MUNI (EQUATORIAL GUINEA)', 'Rio Muni (Equatorial Guinea)', 'yes', '', 'no', 'no', 'yes'),
(377, '', '', 0, '10166', 'RODOS (GREECE)', 'Rodos (Greece)', 'yes', '', 'no', 'no', 'yes'),
(378, '', '', 0, '10286', 'RODRIGUES (MAURITIUS)', 'Rodrigues (Mauritius)', 'no', '', 'no', 'no', 'yes'),
(379, 'RO', 'ROU', 642, '10368', 'ROMANIA', 'Romania', 'no', '', 'no', 'no', 'yes'),
(380, 'RT', '', 0, '', 'ROTA', 'Rota', 'no', '', 'no', 'no', 'yes'),
(381, '', '', 0, 'US_RT', 'ROTA, N. MARIANA ISL (U.S.)', 'Rota, N. Mariana Island (U.S.)', 'no', 'Rota, Northern Mariana Islands', 'yes', 'no', 'yes'),
(382, 'RU', 'RUS', 643, '10369', 'RUSSIA', 'Russia', 'no', '', 'no', 'no', 'yes'),
(383, 'RW', 'RWA', 646, '10370', 'RWANDA', 'Rwanda', 'no', '', 'no', 'no', 'yes'),
(384, 'GS', 'SGS', 239, '', 'S. GEORGIA &AMP; S. SANDWICH ISL', 'S. Georgia &amp; S. Sandwich Island', 'no', 'S. Georgia &amp; S. Sandwich Islands', 'no', 'no', 'no'),
(385, 'SS', '', 0, '12260', 'SABA', 'Saba', 'no', '', 'no', 'no', 'yes'),
(386, '', '', 0, '10273', 'SABAH (MALAYSIA)', 'Sabah (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(387, 'SP', '', 0, '', 'SAIPAN', 'Saipan', 'no', '', 'no', 'no', 'yes'),
(388, '', '', 0, 'US_SN', 'SAIPAN, N. MARIANA ISL (U.S)', 'Saipan, N. Mariana Island (U.s)', 'yes', 'Saipan, Northern Mariana Islands (U.S. Possession)', 'yes', 'no', 'yes'),
(389, 'WS', '', 0, '', 'SAMOA (WESTERN SAMOA)', 'Samoa (Western Samoa)', 'no', '', 'no', 'no', 'yes'),
(390, '', '', 0, 'US_SA', 'SAMOA, AMERICA (U.S)', 'Samoa, America (U.s)', 'yes', 'Samoa, America', 'yes', 'no', 'yes'),
(391, 'SM', 'SMR', 674, '10371', 'SAN MARINO', 'San Marino', 'no', '', 'no', 'no', 'yes'),
(392, '', '', 0, 'US_SD', 'SAND ISL, MIDWAY ISL (U.S.)', 'Sand Island, Midway Island (U.S.)', 'yes', 'Sand Island, Midway Islands (U.S. Possession)', 'yes', 'no', 'yes'),
(393, '', '', 0, '10381', 'SANTA CRUZ ISL (SOLOMON ISL)', 'Santa Cruz Island (Solomon Island)', 'yes', 'Santa Cruz Islands (Solomon Island)', 'no', 'no', 'yes'),
(394, 'ST', 'STP', 678, '10372', 'SAO TOME &AMP; PRINCIPLE', 'Sao Tome &amp; Principle', 'no', 'Sao Tome and Principe', 'no', 'no', 'yes'),
(395, '', '', 0, '10274', 'SARAWAK (MALAYSIA)', 'Sarawak (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(396, '', '', 0, '10148', 'SARK, CHANNEL ISL (G.B.)', 'Sark, Channel Island (G.B.)', 'yes', 'Sark, Channel Islands (Great Britain)', 'no', 'no', 'yes'),
(397, 'SA', 'SAU', 682, '10373', 'SAUDI ARABIA', 'Saudi Arabia', 'no', '', 'no', 'no', 'yes'),
(398, '', '', 0, '10332', 'SAVAGE ISL (NIUE, N. ZEALAND)', 'Savage Island (Niue, N. Zealand)', 'yes', 'Savage Island (Niue) (New Zealand)', 'no', 'no', 'yes'),
(399, '', '', 0, '10508', 'SAVAII ISL (BRITISH W. SAMOA)', 'Savaii Island (British W. Samoa)', 'yes', 'Savaii Island (British) (Western Samoa)', 'no', 'no', 'yes'),
(400, 'SF', '', 0, '12205', 'SCOTLAND', 'Scotland', 'no', '', 'no', 'no', 'yes'),
(401, '', '', 0, '10275', 'SELANGOR (MALAYSIA)', 'Selangor (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(402, 'SN', 'SEN', 686, '10374', 'SENEGAL', 'Senegal', 'no', '', 'no', 'no', 'yes'),
(403, 'CS', 'SCG', 891, '10375', 'SERBIA &AMP; MONTENEGRO', 'Serbia &amp; Montenegro', 'no', 'Serbia-Montenegro', 'no', 'no', 'yes'),
(404, 'SC', 'SYC', 690, '10376', 'SEYCHELLES', 'Seychelles', 'no', '', 'no', 'no', 'yes'),
(405, '', '', 0, '10445', 'SHARJA (U.A. EMIRATES)', 'Sharja (U.A. Emirates)', 'yes', 'Sharja (United Arab Emirates)', 'no', 'no', 'yes'),
(406, '', '', 0, '10218', 'SHIKOKU (JAPAN)', 'Shikoku (Japan)', 'yes', '', 'no', 'no', 'yes'),
(407, '', '', 0, '10423', 'SIAM (THAILAND)', 'Siam (Thailand)', 'yes', '', 'no', 'no', 'yes'),
(408, 'SL', 'SLE', 694, '10377', 'SIERRA LEONE', 'Sierra Leone', 'no', '', 'no', 'no', 'yes'),
(409, '', '', 0, '10198', 'SIKKIM (INDIA)', 'Sikkim (India)', 'yes', '', 'no', 'no', 'yes'),
(410, 'SG', 'SGP', 702, '10378', 'SINGAPORE', 'Singapore', 'no', '', 'no', 'no', 'yes'),
(411, '', '', 0, '10379', 'SLOVAK REPUBLIC', 'Slovak Republic', 'no', '', 'no', 'no', 'yes'),
(412, 'SK', 'SVK', 703, '', 'SLOVAKIA', 'Slovakia', 'no', '', 'no', 'no', 'yes'),
(413, 'SI', 'SVN', 705, '10380', 'SLOVENIA', 'Slovenia', 'no', '', 'no', 'no', 'yes'),
(414, '', '', 0, '10129', 'SOCIETY ISL (FRENCH POLYNESIA)', 'Society Island (French Polynesia)', 'yes', 'Society Islands (French Polynesia)', 'no', 'no', 'yes'),
(415, 'SB', 'SLB', 90, '10382', 'SOLOMON ISL', 'Solomon Island', 'no', 'Solomon Islands', 'no', 'no', 'yes'),
(416, 'SO', 'SOM', 706, '10383', 'SOMALIA', 'Somalia', 'no', 'Somalia Democratic Republic', 'no', 'no', 'yes'),
(417, 'ZA', 'ZAF', 710, '10386', 'SOUTH AFRICA', 'South Africa', 'no', '', 'no', 'no', 'yes'),
(418, '', '', 0, '10021', 'SOUTH AUSTRALIA (AUSTRALIA)', 'South Australia (Australia)', 'yes', '', 'no', 'no', 'yes'),
(419, '', '', 0, '10107', 'SOUTH GEORGIA (FALKLAND ISL)', 'South Georgia (Falkland Island)', 'yes', 'South Georgia (Falkland Islands)', 'no', 'no', 'yes'),
(420, '', '', 0, '10294', 'SOUTH-WEST AFRICA (NAMIBIA)', 'South-west Africa (Namibia)', 'yes', '', 'no', 'no', 'yes'),
(421, 'ES', 'ESP', 724, '10395', 'SPAIN', 'Spain', 'no', '', 'no', 'no', 'yes'),
(422, '', '', 0, '10339', 'SPITZBERGEN (NORWAY)', 'Spitzbergen (Norway)', 'yes', '', 'no', 'no', 'yes'),
(423, 'LK', 'LKA', 144, '10398', 'SRI LANKA', 'Sri Lanka', 'no', '', 'no', 'no', 'yes'),
(424, 'NT', '', 0, '12019', 'ST. BARTHELEMY', 'St. Barthelemy', 'no', '', 'no', 'no', 'yes'),
(425, '', '', 0, '10178', 'ST. BARTHOLOMEW (GUADELOUPE)', 'St. Bartholomew (Guadeloupe)', 'yes', 'Saint Bartholomew (Guadeloupe)', 'no', 'no', 'yes'),
(426, 'SW', '', 0, '', 'ST. CHRISTOPHER', 'St. Christopher', 'no', '', 'no', 'no', 'yes'),
(427, '', '', 0, '12200', 'ST. CHRISTOPHER &AMP; NEVIS', 'St. Christopher &amp; Nevis', 'yes', 'Saint Christopher (St. Kitts) and Nevis', 'no', 'no', 'no'),
(428, 'SX', '', 0, '', 'ST. CROIX (U.S.)', 'St. Croix (U.S.)', 'no', 'Saint Croix', 'yes', 'no', 'yes'),
(429, 'EU', '', 0, '', 'ST. EUSTATIUS', 'St. Eustatius', 'no', 'Saint Eustatius', 'no', 'no', 'yes'),
(430, 'SH', 'SHN', 654, '', 'ST. HELENA', 'St. Helena', 'no', 'Saint Helena', 'no', 'no', 'yes'),
(431, 'UV', '', 0, 'US_SJ', 'ST. JOHN (U.S.)', 'St. John (U.S.)', 'no', 'Saint John, U.S. Virgin Islands', 'yes', 'no', 'yes'),
(432, 'KN', 'KNA', 659, '', 'ST. KITTS &AMP; NEVIS', 'St. Kitts &amp; Nevis', 'no', 'Saint Christopher (St. Kitts) and Nevis', 'no', 'no', 'yes'),
(433, 'LC', 'LCA', 662, '12021', 'ST. LUCIA', 'St. Lucia', 'no', '', 'no', 'no', 'yes'),
(434, '', '', 0, '12193', 'ST. M.D. MADAGASCAR (MADAGASCAR)', 'St. M.D. Madagascar (Madagascar)', 'yes', 'Ste. Marie de Madagascar (Madagascar)', 'no', 'no', 'yes'),
(435, 'MB', '', 0, '10308', 'ST. MAARTEN', 'St. Maarten', 'no', 'Saint Maarten (Netherlands Antilles)', 'no', 'no', 'yes'),
(436, 'TB', '', 0, '', 'ST. MARTIN', 'St. Martin', 'no', 'St. Martin (Guadeloupe)', 'no', 'no', 'yes'),
(437, 'PM', 'SPM', 666, '', 'ST. PIERRE &AMP; MIQUELON', 'St. Pierre &amp; Miquelon', 'no', 'Saint Pierre and Miquelon', 'no', 'no', 'yes'),
(438, 'VL', '', 0, '', 'ST. THOMAS (U.S.)', 'St. Thomas (U.S.)', 'no', 'Saint Thomas, U.S. Virgin Islands', 'yes', 'no', 'yes'),
(439, 'VC', 'VCT', 670, '', 'ST. VINCENT &AMP; GRENADINES', 'St. Vincent &amp; Grenadines', 'no', 'Saint Vincent and the Grenadines', 'no', 'no', 'yes'),
(440, 'SD', 'SDN', 736, '10408', 'SUDAN', 'Sudan', 'no', '', 'no', 'no', 'yes'),
(441, 'SR', 'SUR', 740, '10409', 'SURINAME', 'Suriname', 'no', '', 'no', 'no', 'yes'),
(442, '', '', 0, '12219', 'SUWARROW ISL (N. ZEALAND)', 'Suwarrow Island (N. Zealand)', 'yes', 'Suwarrow Islands (New Zealand)', 'no', 'no', 'yes'),
(443, 'SJ', 'SJM', 744, '', 'SVALBARD &AMP; JAN MAYEN ISLANDS', 'Svalbard &amp; Jan Mayen Islandands', 'no', '', 'no', 'no', 'no'),
(445, '', '', 0, '10188', 'SWAN ISL (HONDURAS)', 'Swan Island (Honduras)', 'yes', 'Swan Islands (Honduras)', 'no', 'no', 'yes'),
(446, 'SZ', 'SWZ', 748, '10410', 'SWAZILAND', 'Swaziland', 'no', '', 'no', 'no', 'yes'),
(447, 'SE', 'SWE', 752, '10411', 'SWEDEN', 'Sweden', 'no', '', 'no', 'no', 'yes'),
(448, 'CH', 'CHE', 756, '10412', 'SWITZERLAND', 'Switzerland', 'no', '', 'no', 'no', 'yes'),
(449, '', '', 0, '10167', 'SYMI (GREECE)', 'Symi (Greece)', 'yes', '', 'no', 'no', 'yes'),
(450, 'SY', 'SYR', 760, '10413', 'SYRIA', 'Syria', 'no', 'Syrian Arab Republic', 'no', 'no', 'yes'),
(451, '', '', 0, '10130', 'TAHAA (FRENCH POLYNESIA)', 'Tahaa (French Polynesia)', 'yes', '', 'no', 'no', 'yes'),
(452, 'TA', '', 0, '12231', 'TAHITI', 'Tahiti', 'no', 'Tahiti (French Polynesia)', 'no', 'no', 'yes'),
(453, 'TW', 'TWN', 158, '10418', 'TAIWAN', 'Taiwan', 'no', '', 'no', 'no', 'yes'),
(454, 'TJ', 'TJK', 762, '10419', 'TAJIKISTAN', 'Tajikistan', 'no', '', 'no', 'no', 'yes'),
(455, 'TZ', 'TZA', 834, '', 'TANZANIA', 'Tanzania', 'no', '', 'no', 'no', 'yes'),
(456, '', '', 0, '10022', 'TASMANIA (AUSTRALIA)', 'Tasmania (Australia)', 'yes', '', 'no', 'no', 'yes'),
(457, '', '', 0, '10061', 'TCHAD (CHAD)', 'Tchad (Chad)', 'yes', '', 'no', 'no', 'yes'),
(458, 'TH', 'THA', 764, '10424', 'THAILAND', 'Thailand', 'no', '', 'no', 'no', 'yes'),
(459, '', '', 0, '12234', 'THURSDAY ISL (AUSTRALIA)', 'Thursday Island (Australia)', 'yes', 'Thursday Island (Australia)', 'no', 'no', 'yes'),
(460, '', '', 0, '12235', 'TIBET (CHINA)', 'Tibet (China)', 'yes', '', 'no', 'no', 'yes'),
(461, '', '', 0, '10168', 'TILOS (GREECE)', 'Tilos (Greece)', 'yes', '', 'no', 'no', 'yes'),
(462, '', '', 0, '10204', 'TIMOR (INDONESIA)', 'Timor (Indonesia)', 'yes', '', 'no', 'no', 'yes'),
(463, 'TL', 'TLS', 626, '', 'TIMOR-LESTE, DEM REP', 'Timor-leste, Dem Rep', 'no', '', 'no', 'no', 'no'),
(464, 'TI', '', 0, '', 'TINIAN', 'Tinian', 'no', '', 'no', 'no', 'yes'),
(465, '', '', 0, 'US_TN', 'TINIAN, N. MARIANA ISL (U.S.)', 'Tinian, N. Mariana Island (U.S.)', 'yes', 'Tinian, Northern Mariana Islands (U.S. Possession)', 'yes', 'no', 'yes'),
(466, '', '', 0, '10428', 'TOBAGO (TRINIDAD AND TOBAGO)', 'Tobago (Trinidad And Tobago)', 'yes', '', 'no', 'no', 'yes'),
(467, 'TG', 'TGO', 768, '10425', 'TOGO', 'Togo', 'no', '', 'no', 'no', 'yes'),
(468, 'TK', 'TKL', 772, '12239', 'TOKELAU (TOKELAU ISL)', 'Tokelau (Tokelau Island)', 'no', 'Tokelau (Tokelau Islands)', 'no', 'no', 'no'),
(469, '', '', 0, '10509', 'TOKELAU (UNION) GROUP (W. SAMOA)', 'Tokelau (Union) Group (w. Samoa)', 'no', 'Tokelau (Union) Group (Western Samoa)', 'no', 'no', 'yes'),
(470, 'TO', 'TON', 776, '10427', 'TONGA', 'Tonga', 'no', '', 'no', 'no', 'yes'),
(471, '', '', 0, '10334', 'TONGAREVA (NEW ZEALAND)', 'Tongareva (New Zealand)', 'no', '', 'no', 'no', 'yes');
INSERT INTO `countries` (`country_id`, `dig2_code`, `dig3_code`, `num_code`, `usps_code`, `country`, `country_name`, `usps_only`, `usps_alias`, `us_possession`, `usps_rtrn_sig_allowed`, `active`) VALUES
(472, '', '', 0, '10219', 'TORI SHIMA (RYUKYU ISL, JAPAN)', 'Tori Shima (Ryukyu Island, Japan)', 'yes', 'Tori Shima (Ryukyu Islands) (Japan)', 'no', 'no', 'yes'),
(473, '', '', 0, '10498', 'TORRES ISL (VANUATU)', 'Torres Island (Vanuatu)', 'yes', 'Torres Island (Vanuatu)', 'no', 'no', 'yes'),
(474, '', '', 0, '10222', 'TRANS-JORDAN (JORDAN)', 'Trans-jordan (Jordan)', 'no', 'Trans-Jordan (Hashemite Kingdom) (Jordan)', 'no', 'no', 'yes'),
(475, '', '', 0, '10387', 'TRANSKEI (SOUTH AFRICA)', 'Transkei (South Africa)', 'no', '', 'no', 'no', 'yes'),
(476, '', '', 0, '12238', 'TRENGGANU (MALAYSIA)', 'Trengganu (Malaysia)', 'no', '', 'no', 'no', 'yes'),
(477, 'TT', 'TTO', 780, '10429', 'TRINIDAD &AMP; TOBAGO', 'Trinidad &amp; Tobago', 'no', 'Trinidad and Tobago', 'no', 'no', 'yes'),
(478, '', '', 0, '10246', 'TRIPOLITANIA (LIBYA)', 'Tripolitania (Libya)', 'yes', '', 'no', 'no', 'yes'),
(479, '', '', 0, '10430', 'TRISTAN DA CUNHA', 'Tristan Da Cunha', 'yes', '', 'no', 'no', 'yes'),
(480, '', '', 0, '10446', 'TRUCIAL STATES (U.A. EMIRATES)', 'Trucial States (U.A. Emirates)', 'yes', 'Trucial States (United Arab Emirates)', 'no', 'no', 'yes'),
(481, 'TU', '', 0, 'US_TK', 'TRUK', 'Truk', 'no', '', 'no', 'no', 'no'),
(482, '', '', 0, '10132', 'TUAMOTOU (FRENCH POLYNESIA)', 'Tuamotou (French Polynesia)', 'yes', '', 'no', 'no', 'yes'),
(483, '', '', 0, '10133', 'TUBUAI (FRENCH POLYNESIA)', 'Tubuai (French Polynesia)', 'no', '', 'no', 'no', 'yes'),
(484, 'TN', 'TUN', 788, '10431', 'TUNISIA', 'Tunisia', 'no', '', 'no', 'no', 'yes'),
(485, 'TR', 'TUR', 792, '10432', 'TURKEY', 'Turkey', 'no', '', 'no', 'no', 'yes'),
(486, 'TM', 'TKM', 795, '10433', 'TURKMENISTAN', 'Turkmenistan', 'no', '', 'no', 'no', 'yes'),
(487, 'TC', 'TCA', 796, '10435', 'TURKS &AMP; CAICOS ISL', 'Turks &amp; Caicos Island', 'no', 'Turks and Caicos Islands', 'no', 'no', 'yes'),
(488, '', '', 0, 'US_TI', 'TUTULIA ISL AMERICAN SAMOA (U.S.)', 'Tutulia Island American Samoa (U.S.)', 'yes', 'Tutulia Island American Samoa', 'yes', 'no', 'yes'),
(489, 'TV', 'TUV', 798, '10437', 'TUVALU', 'Tuvalu', 'no', '', 'no', 'no', 'yes'),
(490, 'UM', 'UMI', 581, '', 'U.S. MINOR OUTLAYING ISL', 'U.S. Minor Outlaying Island', 'no', 'U.S. Minor Outlaying Islands', 'yes', 'no', 'no'),
(491, 'VI', 'VIR', 850, '', 'U.S. VIRGIN ISL', 'U.S. Virgin Island', 'no', 'Virgin Islands', 'yes', 'no', 'no'),
(492, 'UG', 'UGA', 800, '10438', 'UGANDA', 'Uganda', 'no', '', 'no', 'no', 'yes'),
(493, 'UA', 'UKR', 804, '10439', 'UKRAINE', 'Ukraine', 'no', '', 'no', 'no', 'yes'),
(494, '', '', 0, '10447', 'UMM AL QUAIWAIN (U.A. EMIRATES)', 'Umm Al Quaiwain (U.A. Emirates)', 'no', 'Umm al Quaiwain (United Arab Emirates)', 'no', 'no', 'yes'),
(495, '', '', 0, '10365', 'UMM SAID (QATAR)', 'Umm Said (Qatar)', 'no', '', 'no', 'no', 'yes'),
(496, '', '', 0, '10510', 'UNION GROUP (WESTERN SAMOA)', 'Union Group (Western Samoa)', 'no', '', 'no', 'no', 'yes'),
(497, 'UI', '', 0, '', 'UNION ISL', 'Union Island', 'no', 'Union Island', 'no', 'no', 'yes'),
(498, 'AE', 'ARE', 784, '10448', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'no', '', 'no', 'no', 'yes'),
(499, 'GB', '', 0, '10150', 'UNITED KINGDOM (GREAT BRITAIN)', 'United Kingdom (Great Britain)', 'yes', '', 'no', 'no', 'yes'),
(500, 'GB', 'GBR', 826, '', 'UNITED KINGDOM (G.B. &AMP; N.L.)', 'United Kingdom (G.B. &amp; N.l.)', 'no', 'United Kingdom Great Britain and North Ireland', 'no', 'no', 'no'),
(501, 'US', 'USA', 840, '', 'UNITED STATES', 'United States', 'no', 'United States of America', 'yes', 'no', 'yes'),
(502, '', '', 0, '10511', 'UPOLU ISL (WESTERN SAMOA)', 'Upolu Island (Western Samoa)', 'yes', 'Upolu Island (Western Samoa)', 'no', 'no', 'yes'),
(503, 'UY', 'URY', 858, '10449', 'URUGUAY', 'Uruguay', 'no', '', 'no', 'no', 'yes'),
(504, 'UZ', 'UZB', 860, '10495', 'UZBEKISTAN', 'Uzbekistan', 'no', '', 'no', 'no', 'yes'),
(505, 'VU', 'VUT', 548, '10499', 'VANUATU', 'Vanuatu', 'no', '', 'no', 'no', 'yes'),
(506, 'VA', 'VAT', 336, '10500', 'VATICAN CITY STATE', 'Vatican City State', 'no', 'Vatican City', 'no', 'no', 'yes'),
(507, 'VE', 'VEN', 862, '10501', 'VENEZUELA', 'Venezuela', 'no', '', 'no', 'no', 'yes'),
(508, '', '', 0, '10024', 'VICTORIA (AUSTRALIA)', 'Victoria (Australia)', 'yes', '', 'no', 'no', 'yes'),
(509, 'VN', 'VNM', 704, '10502', 'VIETNAM', 'Vietnam', 'no', '', 'no', 'no', 'yes'),
(510, 'VR', '', 0, '', 'VIRGIN GORDA', 'Virgin Gorda', 'no', '', 'no', 'no', 'yes'),
(511, 'VI', 'VIR', 850, 'US_VI', 'VIRGIN ISL (U.S.)', 'Virgin Island (U.S.)', 'no', 'Virgin Islands', 'yes', 'no', 'yes'),
(512, 'WK', '', 0, '', 'WAKE ISL', 'Wake Island', 'no', 'Wake Island', 'yes', 'no', 'yes'),
(513, 'WL', '', 0, '12222', 'WALES', 'Wales', 'no', '', 'no', 'no', 'yes'),
(514, '', '', 0, '10151', 'WALES (G.B. &AMP; N. IRELAND)', 'Wales (G.B. &amp; N. Ireland)', 'no', 'Wales (Great Britain and Northern Ireland)', 'no', 'no', 'yes'),
(515, 'WF', 'WLF', 876, '10504', 'WALLIS &AMP; FUTUNA ISL', 'Wallis &amp; Futuna Island', 'no', 'Wallis and Futuna Islands', 'no', 'no', 'yes'),
(516, '', '', 0, '10277', 'WELLESLEY, PROVINCE (MALAYSIA)', 'Wellesley, Province (Malaysia)', 'yes', '', 'no', 'no', 'yes'),
(517, '', '', 0, '10205', 'WEST NEW GUINEA (INDONESIA)', 'West New Guinea (Indonesia)', 'yes', '', 'no', 'no', 'yes'),
(518, '', '', 0, '10025', 'WESTERN AUSTRALIA (AUSTRALIA)', 'Western Australia (Australia)', 'yes', '', 'no', 'no', 'yes'),
(519, 'EH', 'ESH', 732, '', 'WESTERN SAHARA (SPANISH SAHARA)', 'Western Sahara (Spanish Sahara)', 'no', '', 'no', 'no', 'no'),
(520, '', '', 0, '10512', 'WESTERN SAMOA', 'Western Samoa', 'yes', '', 'no', 'no', 'yes'),
(521, 'YA', '', 0, '', 'YAP', 'Yap', 'no', '', 'no', 'no', 'yes'),
(522, '', '', 0, 'US_YM', 'YAP, MICRONESIA (U.S.)', 'Yap, Micronesia (U.S.)', 'yes', 'Yap, Micronesia', 'yes', 'no', 'yes'),
(523, 'YE', 'YEM', 887, '10513', 'YEMEN', 'Yemen', 'no', '', 'no', 'no', 'yes'),
(524, '', '', 0, '10396', 'ZAFARANI ISL (SPAIN)', 'Zafarani Island (Spain)', 'no', 'Zafarani Islands (Spain)', 'no', 'no', 'yes'),
(525, 'ZR', '', 0, '12025', 'ZAIRE', 'Zaire', 'no', 'Zaire (Congo Dem Rep)', 'no', 'no', 'yes'),
(526, 'ZM', 'ZMB', 894, '10514', 'ZAMBIA', 'Zambia', 'no', '', 'no', 'no', 'yes'),
(527, 'ZW', 'ZWE', 716, '10516', 'ZIMBABWE', 'Zimbabwe', 'no', '', 'no', 'no', 'yes'),
(528, NULL, NULL, NULL, '12169', 'COCOS ISL', 'Cocos Island', 'yes', 'Cocos Island', 'no', 'no', 'yes');

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

--
-- Table structure for table `evironment_types`
--

CREATE TABLE IF NOT EXISTS `evironment_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `backend` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `evironment_types`
--


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

--
-- Table structure for table `global_status`
--

CREATE TABLE IF NOT EXISTS `global_status` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `global_status`
--

INSERT INTO `global_status` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-08-11 00:21:16', 0, 0, 1, 5, 'Activate', 'change_status', 0, 1, 1),
(2, 'Deleted', 1, '2011-08-11 00:23:51', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1),
(3, 'Inactive', 1, '2011-08-11 00:23:40', 0, 0, 1, 7, 'Deactivate', 'change_status', 0, 2, 1),
(4, 'Delete Forever', 1, '2011-08-11 00:23:59', 0, 0, 1, 15, 'Delete Forever', 'delete', 0, 4, 1);

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

--
-- Table structure for table `global_status_con`
--

CREATE TABLE IF NOT EXISTS `global_status_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `global_status_con`
--

INSERT INTO `global_status_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(3, 2),
(5, 2),
(1, 3),
(5, 3),
(1, 4),
(2, 4),
(3, 4);

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

--
-- Table structure for table `icons`
--

CREATE TABLE IF NOT EXISTS `icons` (
  `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `status` int(11) unsigned NOT NULL,
  `submitter` bigint(11) unsigned NOT NULL,
  `date_submitted` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=87 ;

--
-- Dumping data for table `icons`
--

INSERT INTO `icons` (`id`, `name`, `path`, `status`, `submitter`, `date_submitted`) VALUES
(1, 'New', 'icons/new', 1, 1, '2010-11-20 05:58:03'),
(3, 'Delete', 'icons/delete', 1, 1, '2010-11-20 05:57:24'),
(4, 'tick', 'icons/tick', 1, 1, '2011-08-11 21:14:25'),
(5, 'restore', 'icons/reactivate', 1, 1, '2010-11-20 05:58:16'),
(6, 'save', 'icons/save', 1, 1, '2010-11-20 05:58:24'),
(7, 'lock', 'icons/lock', 1, 1, '2010-11-20 05:57:44'),
(8, 'lock2', 'icons/lock2', 1, 1, '2010-11-20 05:57:53'),
(9, 'star', 'icons/star', 1, 1, '2010-11-20 05:58:35'),
(10, 'cross', 'icons/cross', 1, 1, '2010-11-20 05:57:15'),
(11, 'lock3', 'icons/lock3', 1, 1, '2010-11-20 05:57:58'),
(12, 'send', 'icons/send', 1, 1, '2010-11-20 05:58:30'),
(13, 'paid', 'icons/paid', 1, 1, '2010-11-20 05:58:08'),
(14, 'back', 'icons/back', 1, 1, '2010-11-20 05:56:58'),
(15, 'Delete2', 'icons/delete2', 1, 1, '2010-11-20 05:57:29'),
(16, 'Delete3', 'icons/delete3', 1, 1, '2010-11-20 05:57:34'),
(17, 'dollars', 'icons/dollar', 1, 1, '2010-11-20 05:57:40'),
(18, 'pay', 'icons/pay', 1, 1, '2010-11-20 05:58:12'),
(19, 'clock', 'icons/clock', 1, 1, '2010-11-20 05:57:07'),
(20, 'waiting', 'icons/waiting', 1, 1, '2010-11-20 05:58:39'),
(21, 'time', 'icons/time', 1, 1, '2010-11-22 02:06:02'),
(22, 'Support', 'icons/support', 1, 1, '2010-11-22 10:47:42'),
(23, 'emergency', 'icons/emergency', 1, 1, '2010-11-23 22:44:12'),
(24, 'shield blue ', 'icons/blue_shield', 1, 1, '2011-02-02 03:54:09'),
(25, 'shield red', 'icons/red_shield', 1, 1, '2011-02-02 03:54:21'),
(26, 'Shield Orange ', 'icons/orange_shield', 1, 1, '2011-02-02 03:54:31'),
(27, 'shield green ', 'icons/green_shield', 1, 1, '2011-02-02 03:54:44'),
(28, 'Gears', 'icons/setup', 1, 1, '2011-02-02 03:51:20'),
(29, 'Support', 'icons/support2', 1, 1, '2011-02-02 03:51:47'),
(30, 'Warning', 'icons/warning', 1, 1, '2011-02-02 03:52:19'),
(31, 'Tools', 'icons/tools', 1, 1, '2011-02-02 03:52:42'),
(32, 'Task', 'icons/task', 1, 1, '2011-02-02 03:53:02'),
(33, 'people', 'icons/staff', 1, 1, '2011-02-02 03:53:24'),
(34, 'My Account', 'icons/my_account', 1, 1, '2011-02-02 03:55:24'),
(35, 'Leaf', 'icons/leaf', 1, 1, '2011-02-02 03:55:50'),
(36, 'Phone', 'icons/jobs', 1, 1, '2011-02-02 03:56:32'),
(37, 'invoice', 'icons/invoice', 1, 1, '2011-02-02 03:56:49'),
(38, 'home', 'icons/home', 1, 1, '2011-02-02 03:57:03'),
(39, 'help', 'icons/help', 1, 1, '2011-02-02 03:57:14'),
(40, 'setup', 'icons/gear_green', 1, 1, '2011-02-02 03:57:32'),
(41, 'Error', 'icons/error', 1, 1, '2011-02-02 03:57:48'),
(42, 'Erase', 'icons/erase', 1, 1, '2011-02-02 03:57:59'),
(43, 'Email', 'icons/email_invoice', 1, 1, '2011-02-02 03:58:22'),
(44, 'recycle', 'icons/recycle', 1, 1, '2011-08-11 21:13:51'),
(45, 'Development', 'icons/development', 1, 1, '2011-02-02 03:58:56'),
(46, 'Cut', 'icons/cut', 1, 1, '2011-02-02 03:59:22'),
(47, 'Contacts', 'icons/contacts', 1, 1, '2011-02-02 03:59:37'),
(48, 'Magic', 'icons/cms', 1, 1, '2011-02-02 03:59:55'),
(49, 'Clients', 'icons/clients', 1, 1, '2011-02-02 04:00:25'),
(50, 'Calendar', 'icons/calendar', 1, 1, '2011-08-01 16:49:41'),
(51, 'New', 'icons/add', 1, 1, '2011-02-02 04:01:17'),
(52, 'help', 'icons/help2', 1, 1, '2011-02-02 04:06:37'),
(53, 'build', 'icons/build', 1, 1, '2011-03-30 00:06:51'),
(54, 'Demo', 'icons/demo', 1, 1, '2011-03-30 00:07:17'),
(55, 'Finish', 'icons/finish', 1, 1, '2011-03-30 00:08:34'),
(56, 'filer', 'icons/filer', 1, 1, '2011-08-04 17:07:13'),
(57, 'draft', 'icons/draft', 1, 1, '2011-08-11 21:12:43'),
(58, 'search', 'icons/search', 1, 1, '2011-08-11 21:14:09'),
(59, 'hard_hat', 'icons/hard_hat', 1, 1, '2011-08-11 21:15:23'),
(60, 'filer', 'icons/filer', 1, 1, '2011-08-11 21:15:35'),
(61, 'business', 'icons/business', 1, 1, '2011-08-11 21:15:56'),
(62, 'action', 'icons/action', 1, 1, '2011-08-11 21:16:07'),
(63, 'add', 'icons/add', 1, 1, '2011-08-11 21:16:14'),
(64, 'billing', 'icons/billing', 1, 1, '2011-08-11 21:16:30'),
(65, 'blue_plus', 'icons/blue_plus', 1, 1, '2011-08-11 21:16:44'),
(66, 'blue_shield', 'icons/blue_shield', 1, 1, '2011-08-11 21:16:56'),
(67, 'cal', 'icons/cal', 1, 1, '2011-08-11 21:17:11'),
(68, 'cart', 'icons/cart', 1, 1, '2011-08-11 21:17:19'),
(69, 'cash', 'icons/cash', 1, 1, '2011-08-11 21:17:28'),
(70, 'chat', 'icons/chat', 1, 1, '2011-08-11 21:17:37'),
(71, 'cms', 'icons/cms', 1, 1, '2011-08-11 21:18:04'),
(72, 'database', 'icons/database', 1, 1, '2011-08-11 21:18:25'),
(73, 'delete', 'icons/delete', 1, 1, '2011-08-11 21:18:36'),
(74, 'details', 'icons/details', 1, 1, '2011-08-11 21:18:58'),
(75, 'blue_dollar', 'icons/dollar', 1, 1, '2011-08-11 21:19:22'),
(76, 'draft', 'icons/draft', 1, 1, '2011-08-11 21:19:33'),
(77, 'email_invoice', 'icons/email_invoice', 1, 1, '2011-08-11 21:19:58'),
(78, 'exit', 'icons/exit', 1, 1, '2011-08-11 21:20:29'),
(79, 'expense', 'icons/expense', 1, 1, '2011-08-11 21:21:01'),
(80, 'flag', 'icons/finish', 1, 1, '2011-08-11 21:21:19'),
(81, 'gear', 'icons/gear_green', 1, 1, '2011-08-11 21:21:54'),
(82, 'clock_orange', 'icons/clock_orange', 1, 1, '2011-08-11 22:42:47'),
(83, 'certificate', 'icons/certificate', 1, 1, '2011-08-19 14:30:20'),
(84, 'run', 'icons/run', 1, 1, '2011-08-19 14:31:53'),
(85, '', '', 1, 1, '2011-08-26 16:28:03'),
(86, 'star', 'icons/star2', 1, 1, '2012-01-05 11:26:55');

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

--
-- Table structure for table `states`
--

CREATE TABLE IF NOT EXISTS `states` (
  `state_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `state` varchar(50) NOT NULL,
  `state_abbr` varchar(10) NOT NULL,
  `country_id` int(11) NOT NULL,
  PRIMARY KEY (`state_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=73 ;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`state_id`, `state`, `state_abbr`, `country_id`) VALUES
(1, 'Alabama', 'AL', 501),
(2, 'Alaska', 'AK', 501),
(3, 'Arizona', 'AZ', 501),
(4, 'Arkansas', 'AR', 501),
(5, 'California', 'CA', 501),
(6, 'Colorado', 'CO', 501),
(7, 'Connecticut', 'CT', 501),
(8, 'Delaware', 'DE', 501),
(9, 'District of Columbia', 'DC', 501),
(10, 'Florida', 'FL', 501),
(11, 'Georgia', 'GA', 501),
(12, 'Hawaii', 'HI', 501),
(13, 'Idaho', 'ID', 501),
(14, 'Illinois', 'IL', 501),
(15, 'Indiana', 'IN', 501),
(16, 'Iowa', 'IA', 501),
(17, 'Kansas', 'KS', 501),
(18, 'Kentucky', 'KY', 501),
(19, 'Louisiana', 'LA', 501),
(20, 'Maine', 'ME', 501),
(21, 'Maryland', 'MD', 501),
(22, 'Massachusetts', 'MA', 501),
(23, 'Michigan', 'MI', 501),
(24, 'Minnesota', 'MN', 501),
(25, 'Mississippi', 'MS', 501),
(26, 'Missouri', 'MO', 501),
(27, 'Montana', 'MT', 501),
(28, 'Nebraska', 'NE', 501),
(29, 'Nevada', 'NV', 501),
(30, 'New Hampshire', 'NH', 501),
(31, 'New Jersey', 'NJ', 501),
(32, 'New Mexico', 'NM', 501),
(33, 'New York', 'NY', 501),
(34, 'North Carolina', 'NC', 501),
(35, 'North Dakota', 'ND', 501),
(36, 'Ohio', 'OH', 501),
(37, 'Oklahoma', 'OK', 501),
(38, 'Oregon', 'OR', 501),
(39, 'Pennsylvania', 'PA', 501),
(40, 'Rhode Island', 'RI', 501),
(41, 'South Carolina', 'SC', 501),
(42, 'South Dakota', 'SD', 501),
(43, 'Tennessee', 'TN', 501),
(44, 'Texas', 'TX', 501),
(45, 'Utah', 'UT', 501),
(46, 'Vermont', 'VT', 501),
(47, 'Virginia', 'VA', 501),
(48, 'Washington', 'WA', 501),
(49, 'West Virginia', 'WV', 501),
(50, 'Wisconsin', 'WI', 501),
(51, 'Wyoming', 'WY', 501),
(52, 'Alberta', 'AB', 72),
(53, 'British Columbia', 'BC', 72),
(54, 'Manitoba', 'MB', 72),
(55, 'New Brunswick', 'NB', 72),
(56, 'Newfoundland and Labrador', 'NL', 72),
(57, 'Northwest Territories', 'NT', 72),
(58, 'Nova Scotia', 'NS', 72),
(59, 'Nunavut', 'NU', 72),
(60, 'Ontario', 'ON', 72),
(61, 'Prince Edward Island', 'PE', 72),
(62, 'Quebec', 'QC', 72),
(63, 'Saskatchewan', 'SK', 72),
(64, 'Yukon', 'YT', 72),
(65, 'Australian Capital Territory', 'ACT', 27),
(66, 'New South Wales', 'NSW', 27),
(67, 'Northern Territory', 'NT', 27),
(68, 'Queensland', 'QLD', 27),
(69, 'South Australia', 'SA', 27),
(70, 'Tasmania', 'TAS', 27),
(71, 'Victoria', 'VIC', 27),
(72, 'Western Australia', 'WA', 27);

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

--
-- Table structure for table `status_states`
--

CREATE TABLE IF NOT EXISTS `status_states` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `status_states`
--

INSERT INTO `status_states` (`id`, `name`) VALUES
(1, 'change_status'),
(3, 'delete');

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

--
-- Table structure for table `time_zones`
--

CREATE TABLE IF NOT EXISTS `time_zones` (
  `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(255) NOT NULL,
  `time_zones_php` bigint(11) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=76 ;

--
-- Dumping data for table `time_zones`
--

INSERT INTO `time_zones` (`id`, `name`, `time_zones_php`) VALUES
(1, '(GMT-12:00) International Date Line West', 489),
(2, '(GMT-11:00) Midway Island Samoa', 456),
(3, '(GMT-10:00) Hawaii', 478),
(4, '(GMT-09:00) Alaska', 565),
(5, '(GMT-08:00) Pacific Time (US &amp; Canada); Tijuana', 210),
(6, '(GMT-07:00) Arizona', 500),
(7, '(GMT-07:00) Chihuahua', 62),
(8, '(GMT-07:00) Mountain Time (US &amp; Canada)', 60),
(9, '(GMT-06:00) Central America', 85),
(10, '(GMT-06:00) Central Time (US &amp; Canada)', 85),
(11, '(GMT-06:00) Guadalajara', 106),
(12, '(GMT-06:00) Saskatchewan', 482),
(13, '(GMT-05:00) Bogota', 186),
(14, '(GMT-05:00) Eastern Time (US &amp; Canada)', 504),
(15, '(GMT-05:00) Indiana (East)', 544),
(16, '(GMT-04:30) Caracas', 61),
(17, '(GMT-04:00) Atlantic Time (Canada)', 150),
(18, '(GMT-04:00) Caracas', 61),
(19, '(GMT-04:00) Santiago', 207),
(20, '(GMT-03:30) Newfoundland', 82),
(21, '(GMT-03:00) Brasilia', 129),
(22, '(GMT-03:00) Buenos Aires', 92),
(23, '(GMT-03:00) Greenland', 192),
(24, '(GMT-02:00) Mid-Atlantic', 140),
(25, '(GMT-01:00) Azores', 312),
(26, '(GMT-01:00) Cape Verde Is.', 320),
(27, '(GMT) Casablanca', 46),
(28, '(GMT) Greenwich Mean Time : Dublin', 373),
(29, '(GMT+01:00) Amsterdam', 347),
(30, '(GMT+01:00) Belgrade', 394),
(31, '(GMT+01:00) Brussels', 372),
(32, '(GMT+01:00) Sarajevo', 355),
(33, '(GMT+01:00) West Central Africa', 32),
(34, '(GMT+02:00) Athens', 371),
(35, '(GMT+02:00) Bucharest', 384),
(36, '(GMT+02:00) Cairo', 36),
(37, '(GMT+02:00) Harare', 48),
(38, '(GMT+02:00) Helsinki', 350),
(39, '(GMT+02:00) Jerusalem', 231),
(40, '(GMT+03:00) Baghdad', 279),
(41, '(GMT+03:00) Kuwait', 251),
(42, '(GMT+03:00) Moscow', 353),
(43, '(GMT+03:00) Nairobi', 31),
(44, '(GMT+03:30) Tehran', 309),
(45, '(GMT+04:00) Abu Dhabi', 299),
(46, '(GMT+04:00) Baku', 226),
(47, '(GMT+04:30) Kabul', 249),
(48, '(GMT+05:00) Yekaterinburg', 259),
(49, '(GMT+05:00) Islamabad', 285),
(50, '(GMT+05:30) Chennai', 227),
(51, '(GMT+05:45) Kathmandu', 232),
(52, '(GMT+06:00) Almaty', 242),
(53, '(GMT+06:00) Astana', 280),
(54, '(GMT+06:00) Sri Jayawardenepura', 408),
(55, '(GMT+06:30) Rangoon', 290),
(56, '(GMT+07:00) Bangkok', 244),
(57, '(GMT+07:00) Krasnoyarsk', 286),
(58, '(GMT+08:00) Beijing', 308),
(59, '(GMT+08:00) Irkutsk', 248),
(60, '(GMT+08:00) Kuala Lumpur', 303),
(61, '(GMT+08:00) Perth', 327),
(62, '(GMT+08:00) Taipei', 256),
(63, '(GMT+09:00) Osaka', 293),
(64, '(GMT+09:00) Seoul', 291),
(65, '(GMT+09:00) Yakutsk', 241),
(66, '(GMT+09:30) Adelaide', 329),
(67, '(GMT+09:30) Darwin', 330),
(68, '(GMT+10:00) Brisbane', 334),
(69, '(GMT+10:00) Canberra', 343),
(70, '(GMT+10:00) Guam', 444),
(71, '(GMT+10:00) Hobart', 340),
(72, '(GMT+10:00) Vladivostok', 311),
(73, '(GMT+11:00) Magadan', 304),
(74, '(GMT+12:00) Auckland', 425),
(75, '(GMT+12:00) Fiji', 443);

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

--
-- Table structure for table `time_zones_php`
--

CREATE TABLE IF NOT EXISTS `time_zones_php` (
  `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
  `php_zone` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=569 ;

--
-- Dumping data for table `time_zones_php`
--

INSERT INTO `time_zones_php` (`id`, `php_zone`) VALUES
(1, 'Africa/Abidjan'),
(2, 'Africa/Asmera'),
(3, 'Africa/Blantyre'),
(4, 'Africa/Ceuta'),
(5, 'Africa/Douala'),
(6, 'Africa/Johannesburg'),
(7, 'Africa/Lagos'),
(8, 'Africa/Lusaka'),
(9, 'Africa/Mogadishu'),
(10, 'Africa/Nouakchott'),
(11, 'Africa/Tripoli'),
(12, 'Africa/Accra'),
(13, 'Africa/Bamako'),
(14, 'Africa/Brazzaville'),
(15, 'Africa/Conakry'),
(16, 'Africa/El_Aaiun'),
(17, 'Africa/Kampala'),
(18, 'Africa/Libreville'),
(19, 'Africa/Malabo'),
(20, 'Africa/Monrovia'),
(21, 'Africa/Ouagadougou'),
(22, 'Africa/Tunis'),
(23, 'Africa/Addis_Ababa'),
(24, 'Africa/Bangui'),
(25, 'Africa/Bujumbura'),
(26, 'Africa/Dakar'),
(27, 'Africa/Freetown'),
(28, 'Africa/Khartoum'),
(29, 'Africa/Lome'),
(30, 'Africa/Maputo'),
(31, 'Africa/Nairobi'),
(32, 'Africa/Porto-Novo'),
(33, 'Africa/Windhoek'),
(34, 'Africa/Algiers'),
(35, 'Africa/Banjul'),
(36, 'Africa/Cairo'),
(37, 'Africa/Dar_es_Salaam'),
(38, 'Africa/Gaborone'),
(39, 'Africa/Kigali'),
(40, 'Africa/Luanda'),
(41, 'Africa/Maseru'),
(42, 'Africa/Ndjamena'),
(43, 'Africa/Sao_Tome'),
(44, 'Africa/Asmara'),
(45, 'Africa/Bissau'),
(46, 'Africa/Casablanca'),
(47, 'Africa/Djibouti'),
(48, 'Africa/Harare'),
(49, 'Africa/Kinshasa'),
(50, 'Africa/Lubumbashi'),
(51, 'Africa/Mbabane'),
(52, 'Africa/Niamey'),
(53, 'Africa/Timbuktu'),
(54, 'America/Adak'),
(55, 'America/Argentina/Buenos_Aires'),
(56, 'America/Argentina/La_Rioja'),
(57, 'America/Argentina/San_Luis'),
(58, 'America/Atikokan'),
(59, 'America/Belem'),
(60, 'America/Boise'),
(61, 'America/Caracas'),
(62, 'America/Chihuahua'),
(63, 'America/Curacao'),
(64, 'America/Detroit'),
(65, 'America/Ensenada'),
(66, 'America/Goose_Bay'),
(67, 'America/Guayaquil'),
(68, 'America/Indiana/Indianapolis'),
(69, 'America/Indiana/Vevay'),
(70, 'America/Iqaluit'),
(71, 'America/Kentucky/Monticello'),
(72, 'America/Louisville'),
(73, 'America/Martinique'),
(74, 'America/Merida'),
(75, 'America/Montevideo'),
(76, 'America/Nipigon'),
(77, 'America/Ojinaga'),
(78, 'America/Port-au-Prince'),
(79, 'America/Rainy_River'),
(80, 'America/Rio_Branco'),
(81, 'America/Santo_Domingo'),
(82, 'America/St_Johns'),
(83, 'America/Swift_Current'),
(84, 'America/Toronto'),
(85, 'America/Winnipeg'),
(86, 'America/Anchorage'),
(87, 'America/Argentina/Catamarca'),
(88, 'America/Argentina/Mendoza'),
(89, 'America/Argentina/Tucuman'),
(90, 'America/Atka'),
(91, 'America/Belize'),
(92, 'America/Buenos_Aires'),
(93, 'America/Catamarca'),
(94, 'America/Coral_Harbour'),
(95, 'America/Danmarkshavn'),
(96, 'America/Dominica'),
(97, 'America/Fort_Wayne'),
(98, 'America/Grand_Turk'),
(99, 'America/Guyana'),
(100, 'America/Indiana/Knox'),
(101, 'America/Indiana/Vincennes'),
(102, 'America/Jamaica'),
(103, 'America/Knox_IN'),
(104, 'America/Maceio'),
(105, 'America/Matamoros'),
(106, 'America/Mexico_City'),
(107, 'America/Montreal'),
(108, 'America/Nome'),
(109, 'America/Panama'),
(110, 'America/Port_of_Spain'),
(111, 'America/Rankin_Inlet'),
(112, 'America/Rosario'),
(113, 'America/Sao_Paulo'),
(114, 'America/St_Kitts'),
(115, 'America/Tegucigalpa'),
(116, 'America/Tortola'),
(117, 'America/Yakutat'),
(118, 'America/Anguilla'),
(119, 'America/Argentina/ComodRivadavia'),
(120, 'America/Argentina/Rio_Gallegos'),
(121, 'America/Argentina/Ushuaia'),
(122, 'America/Bahia'),
(123, 'America/Blanc-Sablon'),
(124, 'America/Cambridge_Bay'),
(125, 'America/Cayenne'),
(126, 'America/Cordoba'),
(127, 'America/Dawson'),
(128, 'America/Edmonton'),
(129, 'America/Fortaleza'),
(130, 'America/Grenada'),
(131, 'America/Halifax'),
(132, 'America/Indiana/Marengo'),
(133, 'America/Indiana/Winamac'),
(134, 'America/Jujuy'),
(135, 'America/La_Paz'),
(136, 'America/Managua'),
(137, 'America/Mazatlan'),
(138, 'America/Miquelon'),
(139, 'America/Montserrat'),
(140, 'America/Noronha'),
(141, 'America/Pangnirtung'),
(142, 'America/Porto_Acre'),
(143, 'America/Recife'),
(144, 'America/Santa_Isabel'),
(145, 'America/Scoresbysund'),
(146, 'America/St_Lucia'),
(147, 'America/Thule'),
(148, 'America/Vancouver'),
(149, 'America/Yellowknife'),
(150, 'America/Antigua'),
(151, 'America/Argentina/Cordoba'),
(152, 'America/Argentina/Salta'),
(153, 'America/Aruba'),
(154, 'America/Bahia_Banderas'),
(155, 'America/Boa_Vista'),
(156, 'America/Campo_Grande'),
(157, 'America/Cayman'),
(158, 'America/Costa_Rica'),
(159, 'America/Dawson_Creek'),
(160, 'America/Eirunepe'),
(161, 'America/Glace_Bay'),
(162, 'America/Guadeloupe'),
(163, 'America/Havana'),
(164, 'America/Indiana/Petersburg'),
(165, 'America/Indianapolis'),
(166, 'America/Juneau'),
(167, 'America/Lima'),
(168, 'America/Manaus'),
(169, 'America/Mendoza'),
(170, 'America/Moncton'),
(171, 'America/Nassau'),
(172, 'America/North_Dakota/Center'),
(173, 'America/Paramaribo'),
(174, 'America/Porto_Velho'),
(175, 'America/Regina'),
(176, 'America/Santarem'),
(177, 'America/Shiprock'),
(178, 'America/St_Thomas'),
(179, 'America/Thunder_Bay'),
(180, 'America/Virgin'),
(181, 'America/Araguaina'),
(182, 'America/Argentina/Jujuy'),
(183, 'America/Argentina/San_Juan'),
(184, 'America/Asuncion'),
(185, 'America/Barbados'),
(186, 'America/Bogota'),
(187, 'America/Cancun'),
(188, 'America/Chicago'),
(189, 'America/Cuiaba'),
(190, 'America/Denver'),
(191, 'America/El_Salvador'),
(192, 'America/Godthab'),
(193, 'America/Guatemala'),
(194, 'America/Hermosillo'),
(195, 'America/Indiana/Tell_City'),
(196, 'America/Inuvik'),
(197, 'America/Kentucky/Louisville'),
(198, 'America/Los_Angeles'),
(199, 'America/Marigot'),
(200, 'America/Menominee'),
(201, 'America/Monterrey'),
(202, 'America/New_York'),
(203, 'America/North_Dakota/New_Salem'),
(204, 'America/Phoenix'),
(205, 'America/Puerto_Rico'),
(206, 'America/Resolute'),
(207, 'America/Santiago'),
(208, 'America/St_Barthelemy'),
(209, 'America/St_Vincent'),
(210, 'America/Tijuana'),
(211, 'America/Whitehorse'),
(212, 'Antarctica/Casey'),
(213, 'Antarctica/McMurdo'),
(214, 'Antarctica/Vostok'),
(215, 'Antarctica/Davis'),
(216, 'Antarctica/Palmer'),
(217, 'Antarctica/DumontDUrville'),
(218, 'Antarctica/Rothera'),
(219, 'Antarctica/Macquarie'),
(220, 'Antarctica/South_Pole'),
(221, 'Antarctica/Mawson'),
(222, 'Antarctica/Syowa'),
(223, 'Arctic/Longyearbyen'),
(224, 'Asia/Aden'),
(225, 'Asia/Aqtobe'),
(226, 'Asia/Baku'),
(227, 'Asia/Calcutta'),
(228, 'Asia/Dacca'),
(229, 'Asia/Dushanbe'),
(230, 'Asia/Hovd'),
(231, 'Asia/Jerusalem'),
(232, 'Asia/Kathmandu'),
(233, 'Asia/Kuching'),
(234, 'Asia/Makassar'),
(235, 'Asia/Novosibirsk'),
(236, 'Asia/Pyongyang'),
(237, 'Asia/Saigon'),
(238, 'Asia/Singapore'),
(239, 'Asia/Tel_Aviv'),
(240, 'Asia/Ulaanbaatar'),
(241, 'Asia/Yakutsk'),
(242, 'Asia/Almaty'),
(243, 'Asia/Ashgabat'),
(244, 'Asia/Bangkok'),
(245, 'Asia/Choibalsan'),
(246, 'Asia/Damascus'),
(247, 'Asia/Gaza'),
(248, 'Asia/Irkutsk'),
(249, 'Asia/Kabul'),
(250, 'Asia/Katmandu'),
(251, 'Asia/Kuwait'),
(252, 'Asia/Manila'),
(253, 'Asia/Omsk'),
(254, 'Asia/Qatar'),
(255, 'Asia/Sakhalin'),
(256, 'Asia/Taipei'),
(257, 'Asia/Thimbu'),
(258, 'Asia/Ulan_Bator'),
(259, 'Asia/Yekaterinburg'),
(260, 'Asia/Amman'),
(261, 'Asia/Ashkhabad'),
(262, 'Asia/Beirut'),
(263, 'Asia/Chongqing'),
(264, 'Asia/Dhaka'),
(265, 'Asia/Harbin'),
(266, 'Asia/Istanbul'),
(267, 'Asia/Kamchatka'),
(268, 'Asia/Kolkata'),
(269, 'Asia/Macao'),
(270, 'Asia/Muscat'),
(271, 'Asia/Oral'),
(272, 'Asia/Qyzylorda'),
(273, 'Asia/Samarkand'),
(274, 'Asia/Tashkent'),
(275, 'Asia/Thimphu'),
(276, 'Asia/Urumqi'),
(277, 'Asia/Yerevan'),
(278, 'Asia/Anadyr'),
(279, 'Asia/Baghdad'),
(280, 'Asia/Bishkek'),
(281, 'Asia/Chungking'),
(282, 'Asia/Dili'),
(283, 'Asia/Ho_Chi_Minh'),
(284, 'Asia/Jakarta'),
(285, 'Asia/Karachi'),
(286, 'Asia/Krasnoyarsk'),
(287, 'Asia/Macau'),
(288, 'Asia/Nicosia'),
(289, 'Asia/Phnom_Penh'),
(290, 'Asia/Rangoon'),
(291, 'Asia/Seoul'),
(292, 'Asia/Tbilisi'),
(293, 'Asia/Tokyo'),
(294, 'Asia/Vientiane'),
(295, 'Asia/Aqtau'),
(296, 'Asia/Bahrain'),
(297, 'Asia/Brunei'),
(298, 'Asia/Colombo'),
(299, 'Asia/Dubai'),
(300, 'Asia/Hong_Kong'),
(301, 'Asia/Jayapura'),
(302, 'Asia/Kashgar'),
(303, 'Asia/Kuala_Lumpur'),
(304, 'Asia/Magadan'),
(305, 'Asia/Novokuznetsk'),
(306, 'Asia/Pontianak'),
(307, 'Asia/Riyadh'),
(308, 'Asia/Shanghai'),
(309, 'Asia/Tehran'),
(310, 'Asia/Ujung_Pandang'),
(311, 'Asia/Vladivostok'),
(312, 'Atlantic/Azores'),
(313, 'Atlantic/Faroe'),
(314, 'Atlantic/St_Helena'),
(315, 'Atlantic/Bermuda'),
(316, 'Atlantic/Jan_Mayen'),
(317, 'Atlantic/Stanley'),
(318, 'Atlantic/Canary'),
(319, 'Atlantic/Madeira'),
(320, 'Atlantic/Cape_Verde'),
(321, 'Atlantic/Reykjavik'),
(322, 'Atlantic/Faeroe'),
(323, 'Atlantic/South_Georgia'),
(324, 'Australia/ACT'),
(325, 'Australia/Currie'),
(326, 'Australia/Lindeman'),
(327, 'Australia/Perth'),
(328, 'Australia/Victoria'),
(329, 'Australia/Adelaide'),
(330, 'Australia/Darwin'),
(331, 'Australia/Lord_Howe'),
(332, 'Australia/Queensland'),
(333, 'Australia/West'),
(334, 'Australia/Brisbane'),
(335, 'Australia/Eucla'),
(336, 'Australia/Melbourne'),
(337, 'Australia/South'),
(338, 'Australia/Yancowinna'),
(339, 'Australia/Broken_Hill'),
(340, 'Australia/Hobart'),
(341, 'Australia/North'),
(342, 'Australia/Sydney'),
(343, 'Australia/Canberra'),
(344, 'Australia/LHI'),
(345, 'Australia/NSW'),
(346, 'Australia/Tasmania'),
(347, 'Europe/Amsterdam'),
(348, 'Europe/Berlin'),
(349, 'Europe/Chisinau'),
(350, 'Europe/Helsinki'),
(351, 'Europe/Kiev'),
(352, 'Europe/Madrid'),
(353, 'Europe/Moscow'),
(354, 'Europe/Prague'),
(355, 'Europe/Sarajevo'),
(356, 'Europe/Tallinn'),
(357, 'Europe/Vatican'),
(358, 'Europe/Zagreb'),
(359, 'Europe/Andorra'),
(360, 'Europe/Bratislava'),
(361, 'Europe/Copenhagen'),
(362, 'Europe/Isle_of_Man'),
(363, 'Europe/Lisbon'),
(364, 'Europe/Malta'),
(365, 'Europe/Nicosia'),
(366, 'Europe/Riga'),
(367, 'Europe/Simferopol'),
(368, 'Europe/Tirane'),
(369, 'Europe/Vienna'),
(370, 'Europe/Zaporozhye'),
(371, 'Europe/Athens'),
(372, 'Europe/Brussels'),
(373, 'Europe/Dublin'),
(374, 'Europe/Istanbul'),
(375, 'Europe/Ljubljana'),
(376, 'Europe/Mariehamn'),
(377, 'Europe/Oslo'),
(378, 'Europe/Rome'),
(379, 'Europe/Skopje'),
(380, 'Europe/Tiraspol'),
(381, 'Europe/Vilnius'),
(382, 'Europe/Zurich'),
(383, 'Europe/Belfast'),
(384, 'Europe/Bucharest'),
(385, 'Europe/Gibraltar'),
(386, 'Europe/Jersey'),
(387, 'Europe/London'),
(388, 'Europe/Minsk'),
(389, 'Europe/Paris'),
(390, 'Europe/Samara'),
(391, 'Europe/Sofia'),
(392, 'Europe/Uzhgorod'),
(393, 'Europe/Volgograd'),
(394, 'Europe/Belgrade'),
(395, 'Europe/Budapest'),
(396, 'Europe/Guernsey'),
(397, 'Europe/Kaliningrad'),
(398, 'Europe/Luxembourg'),
(399, 'Europe/Monaco'),
(400, 'Europe/Podgorica'),
(401, 'Europe/San_Marino'),
(402, 'Europe/Stockholm'),
(403, 'Europe/Vaduz'),
(404, 'Europe/Warsaw'),
(405, 'Indian/Antananarivo'),
(406, 'Indian/Kerguelen'),
(407, 'Indian/Reunion'),
(408, 'Indian/Chagos'),
(409, 'Indian/Mahe'),
(410, 'Indian/Christmas'),
(411, 'Indian/Maldives'),
(412, 'Indian/Cocos'),
(413, 'Indian/Mauritius'),
(414, 'Indian/Comoro'),
(415, 'Indian/Mayotte'),
(416, 'Pacific/Apia'),
(417, 'Pacific/Efate'),
(418, 'Pacific/Galapagos'),
(419, 'Pacific/Johnston'),
(420, 'Pacific/Marquesas'),
(421, 'Pacific/Noumea'),
(422, 'Pacific/Ponape'),
(423, 'Pacific/Tahiti'),
(424, 'Pacific/Wallis'),
(425, 'Pacific/Auckland'),
(426, 'Pacific/Enderbury'),
(427, 'Pacific/Gambier'),
(428, 'Pacific/Kiritimati'),
(429, 'Pacific/Midway'),
(430, 'Pacific/Pago_Pago'),
(431, 'Pacific/Port_Moresby'),
(432, 'Pacific/Tarawa'),
(433, 'Pacific/Yap'),
(434, 'Pacific/Chatham'),
(435, 'Pacific/Fakaofo'),
(436, 'Pacific/Guadalcanal'),
(437, 'Pacific/Kosrae'),
(438, 'Pacific/Nauru'),
(439, 'Pacific/Palau'),
(440, 'Pacific/Rarotonga'),
(441, 'Pacific/Tongatapu'),
(442, 'Pacific/Chuuk'),
(443, 'Pacific/Fiji'),
(444, 'Pacific/Guam'),
(445, 'Pacific/Kwajalein'),
(446, 'Pacific/Niue'),
(447, 'Pacific/Pitcairn'),
(448, 'Pacific/Saipan'),
(449, 'Pacific/Truk'),
(450, 'Pacific/Easter'),
(451, 'Pacific/Funafuti'),
(452, 'Pacific/Honolulu'),
(453, 'Pacific/Majuro'),
(454, 'Pacific/Norfolk'),
(455, 'Pacific/Pohnpei'),
(456, 'Pacific/Samoa'),
(457, 'Pacific/Wake'),
(458, 'Brazil/Acre'),
(459, 'Canada/Central'),
(460, 'Canada/Pacific'),
(461, 'Chile/EasterIsland'),
(462, 'Eire'),
(463, 'Etc/GMT+1'),
(464, 'Etc/GMT+3'),
(465, 'Etc/GMT+8'),
(466, 'Etc/GMT-11'),
(467, 'Etc/GMT-3'),
(468, 'Etc/GMT-8'),
(469, 'Etc/Universal'),
(470, 'GB-Eire'),
(471, 'Greenwich'),
(472, 'Israel'),
(473, 'MET'),
(474, 'MST7MDT'),
(475, 'Portugal'),
(476, 'Singapore'),
(477, 'US/Aleutian'),
(478, 'US/Hawaii'),
(479, 'US/Pacific-New'),
(480, 'Zulu'),
(481, 'Brazil/DeNoronha'),
(482, 'Canada/East-Saskatchewan'),
(483, 'Canada/Saskatchewan'),
(484, 'CST6CDT'),
(485, 'EST'),
(486, 'Etc/GMT+10'),
(487, 'Etc/GMT+4'),
(488, 'Etc/GMT+9'),
(489, 'Etc/GMT-12'),
(490, 'Etc/GMT-4'),
(491, 'Etc/GMT-9'),
(492, 'Etc/UTC'),
(493, 'GMT'),
(494, 'Hongkong'),
(495, 'Jamaica'),
(496, 'Mexico/BajaNorte'),
(497, 'Navajo'),
(498, 'PRC'),
(499, 'Turkey'),
(500, 'US/Arizona'),
(501, 'US/Indiana-Starke'),
(502, 'US/Samoa'),
(503, 'Brazil/East'),
(504, 'Canada/Eastern'),
(505, 'Canada/Yukon'),
(506, 'Cuba'),
(507, 'EST5EDT'),
(508, 'Etc/GMT+11'),
(509, 'Etc/GMT+5'),
(510, 'Etc/GMT-0'),
(511, 'Etc/GMT-13'),
(512, 'Etc/GMT-5'),
(513, 'Etc/GMT0'),
(514, 'Etc/Zulu'),
(515, 'GMT+0'),
(516, 'HST'),
(517, 'Japan'),
(518, 'Mexico/BajaSur'),
(519, 'NZ'),
(520, 'PST8PDT'),
(521, 'UCT'),
(522, 'US/Central'),
(523, 'US/Michigan'),
(524, 'UTC'),
(525, 'Brazil/West'),
(526, 'Canada/Mountain'),
(527, 'CET'),
(528, 'EET'),
(529, 'Etc/GMT'),
(530, 'Etc/GMT+12'),
(531, 'Etc/GMT+6'),
(532, 'Etc/GMT-1'),
(533, 'Etc/GMT-14'),
(534, 'Etc/GMT-6'),
(535, 'Etc/Greenwich'),
(536, 'Factory'),
(537, 'GMT-0'),
(538, 'Iceland'),
(539, 'Kwajalein'),
(540, 'Mexico/General'),
(541, 'NZ-CHAT'),
(542, 'ROC'),
(543, 'Universal'),
(544, 'US/East-Indiana'),
(545, 'US/Mountain'),
(546, 'W-SU'),
(547, 'Canada/Atlantic'),
(548, 'Canada/Newfoundland'),
(549, 'Chile/Continental'),
(550, 'Egypt'),
(551, 'Etc/GMT+0'),
(552, 'Etc/GMT+2'),
(553, 'Etc/GMT+7'),
(554, 'Etc/GMT-10'),
(555, 'Etc/GMT-2'),
(556, 'Etc/GMT-7'),
(557, 'Etc/UCT'),
(558, 'GB'),
(559, 'GMT0'),
(560, 'Iran'),
(561, 'Libya'),
(562, 'MST'),
(563, 'Poland'),
(564, 'ROK'),
(565, 'US/Alaska'),
(566, 'US/Eastern'),
(567, 'US/Pacific'),
(568, 'WET');
