-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jul 07, 2020 at 06:11 PM
-- Server version: 5.7.30
-- PHP Version: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `developm_pace`
--

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

--
-- Table structure for table `Countries`
--

CREATE TABLE `Countries` (
  `country_nbr` int(11) NOT NULL,
  `country_name` text NOT NULL,
  `country_abbr_1` text NOT NULL,
  `country_abbr_2` text NOT NULL,
  `country_abbr_3` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Countries`
--

INSERT INTO `Countries` (`country_nbr`, `country_name`, `country_abbr_1`, `country_abbr_2`, `country_abbr_3`) VALUES
(1, 'Afghanistan', 'AFN', 'AF', 'AFG'),
(2, 'Albania', 'ALL', 'AL', 'ALB'),
(3, 'Algeria', 'DZD', 'DZ', 'DZA'),
(4, 'Andorra', 'EUR', 'AD', 'AND'),
(5, 'Angola', 'AOA', 'AO', 'AGO'),
(6, 'Antigua and Barbuda', 'XCD', 'AG', 'ATG'),
(7, 'Argentina', 'ARS', 'AR', 'ARG'),
(8, 'Armenia', 'AMD', 'AM', 'ARM'),
(9, 'Australia', 'AUD', 'AU', 'AUS'),
(10, 'Austria', 'EUR', 'AT', 'AUT'),
(11, 'Azerbaijan', 'AZN', 'AZ', 'AZE'),
(12, 'Bahamas, The', 'BSD', 'BS', 'BHS'),
(13, 'Bahrain', 'BHD', 'BH', 'BHR'),
(14, 'Bangladesh', 'BDT', 'BD', 'BGD'),
(15, 'Barbados', 'BBD', 'BB', 'BRB'),
(16, 'Belarus', 'BYR', 'BY', 'BLR'),
(17, 'Belgium', 'EUR', 'BE', 'BEL'),
(18, 'Belize', 'BZD', 'BZ', 'BLZ'),
(19, 'Benin', 'XOF', 'BJ', 'BEN'),
(20, 'Bhutan', 'BTN', 'BT', 'BTN'),
(21, 'Bolivia', 'BOB', 'BO', 'BOL'),
(22, 'Bosnia and Herzegovina', 'BAM', 'BA', 'BIH'),
(23, 'Botswana', 'BWP', 'BW', 'BWA'),
(24, 'Brazil', 'BRL', 'BR', 'BRA'),
(25, 'Brunei', 'BND', 'BN', 'BRN'),
(26, 'Bulgaria', 'BGN', 'BG', 'BGR'),
(27, 'Burkina Faso', 'XOF', 'BF', 'BFA'),
(28, 'Burundi', 'BIF', 'BI', 'BDI'),
(29, 'Cambodia', 'KHR', 'KH', 'KHM'),
(30, 'Cameroon', 'XAF', 'CM', 'CMR'),
(31, 'Canada', 'CAD', 'CA', 'CAN'),
(32, 'Cape Verde', 'CVE', 'CV', 'CPV'),
(33, 'Central African Republic', 'XAF', 'CF', 'CAF'),
(34, 'Chad', 'XAF', 'TD', 'TCD'),
(35, 'Chile', 'CLP', 'CL', 'CHL'),
(36, 'China, People\'s Republic of', 'CNY', 'CN', 'CHN'),
(37, 'Colombia', 'COP', 'CO', 'COL'),
(38, 'Comoros', 'KMF', 'KM', 'COM'),
(39, 'Congo, (Congo ? Kinshasa)', 'CDF', 'CD', 'COD'),
(40, 'Congo, (Congo ? Brazzaville)', 'XAF', 'CG', 'COG'),
(41, 'Costa Rica', 'CRC', 'CR', 'CRI'),
(42, 'Cote d\'Ivoire (Ivory Coast)', 'XOF', 'CI', 'CIV'),
(43, 'Croatia', 'HRK', 'HR', 'HRV'),
(44, 'Cuba', 'CUP', 'CU', 'CUB'),
(45, 'Cyprus', 'CYP', 'CY', 'CYP'),
(46, 'Czech Republic', 'CZK', 'CZ', 'CZE'),
(47, 'Denmark', 'DKK', 'DK', 'DNK'),
(48, 'Djibouti', 'DJF', 'DJ', 'DJI'),
(49, 'Dominica', 'XCD', 'DM', 'DMA'),
(50, 'Dominican Republic', 'DOP', 'DO', 'DOM'),
(51, 'Ecuador', 'USD', 'EC', 'ECU'),
(52, 'Egypt', 'EGP', 'EG', 'EGY'),
(53, 'El Salvador', 'USD', 'SV', 'SLV'),
(54, 'Equatorial Guinea', 'XAF', 'GQ', 'GNQ'),
(55, 'Eritrea', 'ERN', 'ER', 'ERI'),
(56, 'Estonia', 'EEK', 'EE', 'EST'),
(57, 'Ethiopia', 'ETB', 'ET', 'ETH'),
(58, 'Fiji', 'FJD', 'FJ', 'FJI'),
(59, 'Finland', 'EUR', 'FI', 'FIN'),
(60, 'France', 'EUR', 'FR', 'FRA'),
(61, 'Gabon', 'XAF', 'GA', 'GAB'),
(62, 'Gambia, The', 'GMD', 'GM', 'GMB'),
(63, 'Georgia', 'GEL', 'GE', 'GEO'),
(64, 'Germany', 'EUR', 'DE', 'DEU'),
(65, 'Ghana', 'GHC', 'GH', 'GHA'),
(66, 'Greece', 'EUR', 'GR', 'GRC'),
(67, 'Grenada', 'XCD', 'GD', 'GRD'),
(68, 'Guatemala', 'GTQ', 'GT', 'GTM'),
(69, 'Guinea', 'GNF', 'GN', 'GIN'),
(70, 'Guinea-Bissau', 'XOF', 'GW', 'GNB'),
(71, 'Guyana', 'GYD', 'GY', 'GUY'),
(72, 'Haiti', 'HTG', 'HT', 'HTI'),
(73, 'Honduras', 'HNL', 'HN', 'HND'),
(74, 'Hungary', 'HUF', 'HU', 'HUN'),
(75, 'Iceland', 'ISK', 'IS', 'ISL'),
(76, 'India', 'INR', 'IN', 'IND'),
(77, 'Indonesia', 'IDR', 'ID', 'IDN'),
(78, 'Iran', 'IRR', 'IR', 'IRN'),
(79, 'Iraq', 'IQD', 'IQ', 'IRQ'),
(80, 'Ireland', 'EUR', 'IE', 'IRL'),
(81, 'Israel', 'ILS', 'IL', 'ISR'),
(82, 'Italy', 'EUR', 'IT', 'ITA'),
(83, 'Jamaica', 'JMD', 'JM', 'JAM'),
(84, 'Japan', 'JPY', 'JP', 'JPN'),
(85, 'Jordan', 'JOD', 'JO', 'JOR'),
(86, 'Kazakhstan', 'KZT', 'KZ', 'KAZ'),
(87, 'Kenya', 'KES', 'KE', 'KEN'),
(88, 'Kiribati', 'AUD', 'KI', 'KIR'),
(89, 'Korea, North', 'KPW', 'KP', 'PRK'),
(90, 'Korea, South', 'KRW', 'KR', 'KOR'),
(91, 'Kuwait', 'KWD', 'KW', 'KWT'),
(92, 'Kyrgyzstan', 'KGS', 'KG', 'KGZ'),
(93, 'Laos', 'LAK', 'LA', 'LAO'),
(94, 'Latvia', 'LVL', 'LV', 'LVA'),
(95, 'Lebanon', 'LBP', 'LB', 'LBN'),
(96, 'Lesotho', 'LSL', 'LS', 'LSO'),
(97, 'Liberia', 'LRD', 'LR', 'LBR'),
(98, 'Libya', 'LYD', 'LY', 'LBY'),
(99, 'Liechtenstein', 'CHF', 'LI', 'LIE'),
(100, 'Lithuania', 'LTL', 'LT', 'LTU'),
(101, 'Luxembourg', 'EUR', 'LU', 'LUX'),
(102, 'Macedonia', 'MKD', 'MK', 'MKD'),
(103, 'Madagascar', 'MGA', 'MG', 'MDG'),
(104, 'Malawi', 'MWK', 'MW', 'MWI'),
(105, 'Malaysia', 'MYR', 'MY', 'MYS'),
(106, 'Maldives', 'MVR', 'MV', 'MDV'),
(107, 'Mali', 'XOF', 'ML', 'MLI'),
(108, 'Malta', 'MTL', 'MT', 'MLT'),
(109, 'Marshall Islands', 'USD', 'MH', 'MHL'),
(110, 'Mauritania', 'MRO', 'MR', 'MRT'),
(111, 'Mauritius', 'MUR', 'MU', 'MUS'),
(112, 'Mexico', 'MXN', 'MX', 'MEX'),
(113, 'Micronesia', 'USD', 'FM', 'FSM'),
(114, 'Moldova', 'MDL', 'MD', 'MDA'),
(115, 'Monaco', 'EUR', 'MC', 'MCO'),
(116, 'Mongolia', 'MNT', 'MN', 'MNG'),
(117, 'Montenegro', 'EUR', 'ME', 'MNE'),
(118, 'Morocco', 'MAD', 'MA', 'MAR'),
(119, 'Mozambique', 'MZM', 'MZ', 'MOZ'),
(120, 'Myanmar (Burma)', 'MMK', 'MM', 'MMR'),
(121, 'Namibia', 'NAD', 'NA', 'NAM'),
(122, 'Nauru', 'AUD', 'NR', 'NRU'),
(123, 'Nepal', 'NPR', 'NP', 'NPL'),
(124, 'Netherlands', 'EUR', 'NL', 'NLD'),
(125, 'New Zealand', 'NZD', 'NZ', 'NZL'),
(126, 'Nicaragua', 'NIO', 'NI', 'NIC'),
(127, 'Niger', 'XOF', 'NE', 'NER'),
(128, 'Nigeria', 'NGN', 'NG', 'NGA'),
(129, 'Norway', 'NOK', 'NO', 'NOR'),
(130, 'Oman', 'OMR', 'OM', 'OMN'),
(131, 'Pakistan', 'PKR', 'PK', 'PAK'),
(132, 'Palau', 'USD', 'PW', 'PLW'),
(133, 'Panama', 'PAB', 'PA', 'PAN'),
(134, 'Papua New Guinea', 'PGK', 'PG', 'PNG'),
(135, 'Paraguay', 'PYG', 'PY', 'PRY'),
(136, 'Peru', 'PEN', 'PE', 'PER'),
(137, 'Philippines', 'PHP', 'PH', 'PHL'),
(138, 'Poland', 'PLN', 'PL', 'POL'),
(139, 'Portugal', 'EUR', 'PT', 'PRT'),
(140, 'Qatar', 'QAR', 'QA', 'QAT'),
(141, 'Romania', 'RON', 'RO', 'ROU'),
(142, 'Russia', 'RUB', 'RU', 'RUS'),
(143, 'Rwanda', 'RWF', 'RW', 'RWA'),
(144, 'Saint Kitts and Nevis', 'XCD', 'KN', 'KNA'),
(145, 'Saint Lucia', 'XCD', 'LC', 'LCA'),
(146, 'Saint Vincent and the Grenadines', 'XCD', 'VC', 'VCT'),
(147, 'Samoa', 'WST', 'WS', 'WSM'),
(148, 'San Marino', 'EUR', 'SM', 'SMR'),
(149, 'Sao Tome and Principe', 'STD', 'ST', 'STP'),
(150, 'Saudi Arabia', 'SAR', 'SA', 'SAU'),
(151, 'Senegal', 'XOF', 'SN', 'SEN'),
(152, 'Serbia', 'RSD', 'RS', 'SRB'),
(153, 'Seychelles', 'SCR', 'SC', 'SYC'),
(154, 'Sierra Leone', 'SLL', 'SL', 'SLE'),
(155, 'Singapore', 'SGD', 'SG', 'SGP'),
(156, 'Slovakia', 'SKK', 'SK', 'SVK'),
(157, 'Slovenia', 'EUR', 'SI', 'SVN'),
(158, 'Solomon Islands', 'SBD', 'SB', 'SLB'),
(159, 'Somalia', 'SOS', 'SO', 'SOM'),
(160, 'South Africa', 'ZAR', 'ZA', 'ZAF'),
(161, 'Spain', 'EUR', 'ES', 'ESP'),
(162, 'Sri Lanka', 'LKR', 'LK', 'LKA'),
(163, 'Sudan', 'SDD', 'SD', 'SDN'),
(164, 'Suriname', 'SRD', 'SR', 'SUR'),
(165, 'Swaziland', 'SZL', 'SZ', 'SWZ'),
(166, 'Sweden', 'SEK', 'SE', 'SWE'),
(167, 'Switzerland', 'CHF', 'CH', 'CHE'),
(168, 'Syria', 'SYP', 'SY', 'SYR'),
(169, 'Tajikistan', 'TJS', 'TJ', 'TJK'),
(170, 'Tanzania', 'TZS', 'TZ', 'TZA'),
(171, 'Thailand', 'THB', 'TH', 'THA'),
(172, 'Timor-Leste (East Timor)', 'USD', 'TL', 'TLS'),
(173, 'Togo', 'XOF', 'TG', 'TGO'),
(174, 'Tonga', 'TOP', 'TO', 'TON'),
(175, 'Trinidad and Tobago', 'TTD', 'TT', 'TTO'),
(176, 'Tunisia', 'TND', 'TN', 'TUN'),
(177, 'Turkey', 'TRY', 'TR', 'TUR'),
(178, 'Turkmenistan', 'TMM', 'TM', 'TKM'),
(179, 'Tuvalu', 'AUD', 'TV', 'TUV'),
(180, 'Uganda', 'UGX', 'UG', 'UGA'),
(181, 'Ukraine', 'UAH', 'UA', 'UKR'),
(182, 'United Arab Emirates', 'AED', 'AE', 'ARE'),
(183, 'United Kingdom', 'GBP', 'GB', 'GBR'),
(184, 'United States', 'USD', 'US', 'USA'),
(185, 'Uruguay', 'UYU', 'UY', 'URY'),
(186, 'Uzbekistan', 'UZS', 'UZ', 'UZB'),
(187, 'Vanuatu', 'VUV', 'VU', 'VUT'),
(188, 'Vatican City', 'EUR', 'VA', 'VAT'),
(189, 'Venezuela', 'VEB', 'VE', 'VEN'),
(190, 'Vietnam', 'VND', 'VN', 'VNM'),
(191, 'Yemen', 'YER', 'YE', 'YEM'),
(192, 'Zambia', 'ZMK', 'ZM', 'ZMB'),
(193, 'Zimbabwe', 'ZWD', 'ZW', 'ZWE');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Countries`
--
ALTER TABLE `Countries`
  ADD PRIMARY KEY (`country_nbr`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `Countries`
--
ALTER TABLE `Countries`
  MODIFY `country_nbr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=194;
COMMIT;

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