-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 09, 2022 at 10:49 AM
-- Server version: 8.0.18
-- PHP Version: 7.4.0

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: `cool_and_handy`
--

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

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

-- DROP TABLE IF EXISTS `countries`;
-- CREATE TABLE IF NOT EXISTS `countries` (
--   `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
--   `call_code` varchar(6) DEFAULT NULL,
--   `code` varchar(3) DEFAULT NULL,
--   `iso_code` varchar(5) DEFAULT NULL,
--   `status` tinyint(1) NOT NULL DEFAULT '0',
--   `image` varchar(200) DEFAULT NULL,
--   `created_at` timestamp NULL DEFAULT NULL,
--   `updated_at` timestamp NULL DEFAULT NULL,
--   `deleted_at` timestamp NULL DEFAULT NULL,
--   PRIMARY KEY (`id`)
-- ) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=utf8;

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

INSERT INTO `countries` (`id`, `call_code`, `code`, `iso_code`, `status`, `image`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '376', 'AD', 'AND', 0, NULL, '2022-01-09 08:48:10', '2022-01-09 08:48:10', NULL),
(2, '971', 'AE', 'ARE', 0, NULL, '2022-01-09 08:48:10', '2022-01-09 08:48:10', NULL),
(3, '93', 'AF', 'AFG', 0, NULL, '2022-01-09 08:48:10', '2022-01-09 08:48:10', NULL),
(4, '1', 'AG', 'ATG', 0, NULL, '2022-01-09 08:48:10', '2022-01-09 08:48:10', NULL),
(5, '1', 'AI', 'AIA', 0, NULL, '2022-01-09 08:48:10', '2022-01-09 08:48:10', NULL),
(6, '355', 'AL', 'ALB', 0, NULL, '2022-01-09 08:48:10', '2022-01-09 08:48:10', NULL),
(7, '374', 'AM', 'ARM', 0, NULL, '2022-01-09 08:48:10', '2022-01-09 08:48:10', NULL),
(8, '599', 'AN', 'ANT', 0, NULL, '2022-01-09 08:48:10', '2022-01-09 08:48:10', NULL),
(9, '244', 'AO', 'AGO', 0, NULL, '2022-01-09 08:48:10', '2022-01-09 08:48:10', NULL),
(10, '54', 'AR', 'ARG', 0, NULL, '2022-01-09 08:48:10', '2022-01-09 08:48:10', NULL),
(11, '1', 'AS', 'ASM', 0, NULL, '2022-01-09 08:48:11', '2022-01-09 08:48:11', NULL),
(12, '43', 'AT', 'AUT', 0, NULL, '2022-01-09 08:48:11', '2022-01-09 08:48:11', NULL),
(13, '61', 'AU', 'AUS', 0, NULL, '2022-01-09 08:48:11', '2022-01-09 08:48:11', NULL),
(14, '297', 'AW', 'ABW', 0, NULL, '2022-01-09 08:48:11', '2022-01-09 08:48:11', NULL),
(15, '994', 'AZ', 'AZE', 0, NULL, '2022-01-09 08:48:11', '2022-01-09 08:48:11', NULL),
(16, '387', 'BA', 'BIH', 0, NULL, '2022-01-09 08:48:11', '2022-01-09 08:48:11', NULL),
(17, '1', 'BB', 'BRB', 0, NULL, '2022-01-09 08:48:11', '2022-01-09 08:48:11', NULL),
(18, '880', 'BD', 'BGD', 0, NULL, '2022-01-09 08:48:11', '2022-01-09 08:48:11', NULL),
(19, '32', 'BE', 'BEL', 0, NULL, '2022-01-09 08:48:12', '2022-01-09 08:48:12', NULL),
(20, '226', 'BF', 'BFA', 0, NULL, '2022-01-09 08:48:12', '2022-01-09 08:48:12', NULL),
(21, '359', 'BG', 'BGR', 0, NULL, '2022-01-09 08:48:12', '2022-01-09 08:48:12', NULL),
(22, '973', 'BH', 'BHR', 0, NULL, '2022-01-09 08:48:12', '2022-01-09 08:48:12', NULL),
(23, '257', 'BI', 'BDI', 0, NULL, '2022-01-09 08:48:12', '2022-01-09 08:48:12', NULL),
(24, '229', 'BJ', 'BEN', 0, NULL, '2022-01-09 08:48:12', '2022-01-09 08:48:12', NULL),
(25, '1', 'BM', 'BMU', 0, NULL, '2022-01-09 08:48:12', '2022-01-09 08:48:12', NULL),
(26, '673', 'BN', 'BRN', 0, NULL, '2022-01-09 08:48:12', '2022-01-09 08:48:12', NULL),
(27, '591', 'BO', 'BOL', 0, NULL, '2022-01-09 08:48:12', '2022-01-09 08:48:12', NULL),
(28, '55', 'BR', 'BRA', 0, NULL, '2022-01-09 08:48:12', '2022-01-09 08:48:12', NULL),
(29, '1', 'BS', 'BHS', 0, NULL, '2022-01-09 08:48:13', '2022-01-09 08:48:13', NULL),
(30, '975', 'BT', 'BTN', 0, NULL, '2022-01-09 08:48:13', '2022-01-09 08:48:13', NULL),
(31, '267', 'BW', 'BWA', 0, NULL, '2022-01-09 08:48:13', '2022-01-09 08:48:13', NULL),
(32, '375', 'BY', 'BLR', 0, NULL, '2022-01-09 08:48:13', '2022-01-09 08:48:13', NULL),
(33, '501', 'BZ', 'BLZ', 0, NULL, '2022-01-09 08:48:13', '2022-01-09 08:48:13', NULL),
(34, '1', 'CA', 'CAN', 0, NULL, '2022-01-09 08:48:13', '2022-01-09 08:48:13', NULL),
(35, '61', 'CC', 'CCK', 0, NULL, '2022-01-09 08:48:13', '2022-01-09 08:48:13', NULL),
(36, '243', 'CD', 'COD', 0, NULL, '2022-01-09 08:48:13', '2022-01-09 08:48:13', NULL),
(37, '236', 'CF', 'CAF', 0, NULL, '2022-01-09 08:48:13', '2022-01-09 08:48:13', NULL),
(38, '242', 'CG', 'COG', 0, NULL, '2022-01-09 08:48:13', '2022-01-09 08:48:13', NULL),
(39, '41', 'CH', 'CHE', 0, NULL, '2022-01-09 08:48:14', '2022-01-09 08:48:14', NULL),
(40, '225', 'CI', 'CIV', 0, NULL, '2022-01-09 08:48:14', '2022-01-09 08:48:14', NULL),
(41, '682', 'CK', 'COK', 0, NULL, '2022-01-09 08:48:14', '2022-01-09 08:48:14', NULL),
(42, '56', 'CL', 'CHL', 0, NULL, '2022-01-09 08:48:14', '2022-01-09 08:48:14', NULL),
(43, '237', 'CM', 'CMR', 0, NULL, '2022-01-09 08:48:14', '2022-01-09 08:48:14', NULL),
(44, '86', 'CN', 'CHN', 0, NULL, '2022-01-09 08:48:14', '2022-01-09 08:48:14', NULL),
(45, '57', 'CO', 'COL', 0, NULL, '2022-01-09 08:48:14', '2022-01-09 08:48:14', NULL),
(46, '506', 'CR', 'CRI', 0, NULL, '2022-01-09 08:48:14', '2022-01-09 08:48:14', NULL),
(47, '53', 'CU', 'CUB', 0, NULL, '2022-01-09 08:48:14', '2022-01-09 08:48:14', NULL),
(48, '238', 'CV', 'CPV', 0, NULL, '2022-01-09 08:48:15', '2022-01-09 08:48:15', NULL),
(49, '61', 'CX', 'CXR', 0, NULL, '2022-01-09 08:48:15', '2022-01-09 08:48:15', NULL),
(50, '357', 'CY', 'CYP', 0, NULL, '2022-01-09 08:48:15', '2022-01-09 08:48:15', NULL),
(51, '420', 'CZ', 'CZE', 0, NULL, '2022-01-09 08:48:15', '2022-01-09 08:48:15', NULL),
(52, '49', 'DE', 'DEU', 0, NULL, '2022-01-09 08:48:15', '2022-01-09 08:48:15', NULL),
(53, '253', 'DJ', 'DJI', 0, NULL, '2022-01-09 08:48:15', '2022-01-09 08:48:15', NULL),
(54, '45', 'DK', 'DNK', 0, NULL, '2022-01-09 08:48:15', '2022-01-09 08:48:15', NULL),
(55, '1', 'DM', 'DMA', 0, NULL, '2022-01-09 08:48:15', '2022-01-09 08:48:15', NULL),
(56, '1', 'DO', 'DOM', 0, NULL, '2022-01-09 08:48:15', '2022-01-09 08:48:15', NULL),
(57, '213', 'DZ', 'DZA', 0, NULL, '2022-01-09 08:48:15', '2022-01-09 08:48:15', NULL),
(58, '593', 'EC', 'ECU', 0, NULL, '2022-01-09 08:48:15', '2022-01-09 08:48:15', NULL),
(59, '372', 'EE', 'EST', 0, NULL, '2022-01-09 08:48:15', '2022-01-09 08:48:15', NULL),
(60, '20', 'EG', 'EGY', 0, NULL, '2022-01-09 08:48:16', '2022-01-09 08:48:16', NULL),
(61, '212', 'EH', 'ESH', 0, NULL, '2022-01-09 08:48:16', '2022-01-09 08:48:16', NULL),
(62, '291', 'ER', 'ERI', 0, NULL, '2022-01-09 08:48:16', '2022-01-09 08:48:16', NULL),
(63, '34', 'ES', 'ESP', 0, NULL, '2022-01-09 08:48:16', '2022-01-09 08:48:16', NULL),
(64, '251', 'ET', 'ETH', 0, NULL, '2022-01-09 08:48:16', '2022-01-09 08:48:16', NULL),
(65, '358', 'FI', 'FIN', 0, NULL, '2022-01-09 08:48:16', '2022-01-09 08:48:16', NULL),
(66, '679', 'FJ', 'FJI', 0, NULL, '2022-01-09 08:48:16', '2022-01-09 08:48:16', NULL),
(67, '500', 'FK', 'FLK', 0, NULL, '2022-01-09 08:48:16', '2022-01-09 08:48:16', NULL),
(68, '691', 'FM', 'FSM', 0, NULL, '2022-01-09 08:48:17', '2022-01-09 08:48:17', NULL),
(69, '298', 'FO', 'FRO', 0, NULL, '2022-01-09 08:48:17', '2022-01-09 08:48:17', NULL),
(70, '33', 'FR', 'FRA', 0, NULL, '2022-01-09 08:48:17', '2022-01-09 08:48:17', NULL),
(71, '241', 'GA', 'GAB', 0, NULL, '2022-01-09 08:48:17', '2022-01-09 08:48:17', NULL),
(72, '44', 'GB', 'GBR', 0, NULL, '2022-01-09 08:48:17', '2022-01-09 08:48:17', NULL),
(73, '1', 'GD', 'GRD', 0, NULL, '2022-01-09 08:48:17', '2022-01-09 08:48:17', NULL),
(74, '995', 'GE', 'GEO', 0, NULL, '2022-01-09 08:48:17', '2022-01-09 08:48:17', NULL),
(75, '594', 'GF', 'GUF', 0, NULL, '2022-01-09 08:48:17', '2022-01-09 08:48:17', NULL),
(76, '233', 'GH', 'GHA', 0, NULL, '2022-01-09 08:48:17', '2022-01-09 08:48:17', NULL),
(77, '350', 'GI', 'GIB', 0, NULL, '2022-01-09 08:48:17', '2022-01-09 08:48:17', NULL),
(78, '299', 'GL', 'GRL', 0, NULL, '2022-01-09 08:48:17', '2022-01-09 08:48:17', NULL),
(79, '220', 'GM', 'GMB', 0, NULL, '2022-01-09 08:48:18', '2022-01-09 08:48:18', NULL),
(80, '224', 'GN', 'GIN', 0, NULL, '2022-01-09 08:48:18', '2022-01-09 08:48:18', NULL),
(81, '590', 'GP', 'GLP', 0, NULL, '2022-01-09 08:48:18', '2022-01-09 08:48:18', NULL),
(82, '240', 'GQ', 'GNQ', 0, NULL, '2022-01-09 08:48:18', '2022-01-09 08:48:18', NULL),
(83, '30', 'GR', 'GRC', 0, NULL, '2022-01-09 08:48:18', '2022-01-09 08:48:18', NULL),
(84, '502', 'GT', 'GTM', 0, NULL, '2022-01-09 08:48:18', '2022-01-09 08:48:18', NULL),
(85, '1', 'GU', 'GUM', 0, NULL, '2022-01-09 08:48:18', '2022-01-09 08:48:18', NULL),
(86, '245', 'GW', 'GNB', 0, NULL, '2022-01-09 08:48:18', '2022-01-09 08:48:18', NULL),
(87, '592', 'GY', 'GUY', 0, NULL, '2022-01-09 08:48:18', '2022-01-09 08:48:18', NULL),
(88, '852', 'HK', 'HKG', 0, NULL, '2022-01-09 08:48:18', '2022-01-09 08:48:18', NULL),
(89, '0', 'HM', 'HMD', 0, NULL, '2022-01-09 08:48:18', '2022-01-09 08:48:18', NULL),
(90, '504', 'HN', 'HND', 0, NULL, '2022-01-09 08:48:18', '2022-01-09 08:48:18', NULL),
(91, '385', 'HR', 'HRV', 0, NULL, '2022-01-09 08:48:19', '2022-01-09 08:48:19', NULL),
(92, '509', 'HT', 'HTI', 0, NULL, '2022-01-09 08:48:19', '2022-01-09 08:48:19', NULL),
(93, '36', 'HU', 'HUN', 0, NULL, '2022-01-09 08:48:19', '2022-01-09 08:48:19', NULL),
(94, '34', 'IC', '   ', 0, NULL, '2022-01-09 08:48:19', '2022-01-09 08:48:19', NULL),
(95, '62', 'ID', 'IDN', 0, NULL, '2022-01-09 08:48:19', '2022-01-09 08:48:19', NULL),
(96, '353', 'IE', 'IRL', 0, NULL, '2022-01-09 08:48:19', '2022-01-09 08:48:19', NULL),
(97, '972', 'IL', 'ISR', 0, NULL, '2022-01-09 08:48:19', '2022-01-09 08:48:19', NULL),
(98, '44', 'IM', 'IMN', 0, NULL, '2022-01-09 08:48:19', '2022-01-09 08:48:19', NULL),
(99, '91', 'IN', 'IND', 0, NULL, '2022-01-09 08:48:19', '2022-01-09 08:48:19', NULL),
(100, '246', 'IO', 'IOT', 0, NULL, '2022-01-09 08:48:19', '2022-01-09 08:48:19', NULL),
(101, '964', 'IQ', 'IRQ', 0, NULL, '2022-01-09 08:48:19', '2022-01-09 08:48:19', NULL),
(102, '98', 'IR', 'IRN', 0, NULL, '2022-01-09 08:48:19', '2022-01-09 08:48:19', NULL),
(103, '354', 'IS', 'ISL', 0, NULL, '2022-01-09 08:48:20', '2022-01-09 08:48:20', NULL),
(104, '39', 'IT', 'ITA', 0, NULL, '2022-01-09 08:48:20', '2022-01-09 08:48:20', NULL),
(105, '44', 'JE', 'JEY', 0, NULL, '2022-01-09 08:48:20', '2022-01-09 08:48:20', NULL),
(106, '1', 'JM', 'JAM', 0, NULL, '2022-01-09 08:48:20', '2022-01-09 08:48:20', NULL),
(107, '962', 'JO', 'JOR', 0, NULL, '2022-01-09 08:48:20', '2022-01-09 08:48:20', NULL),
(108, '81', 'JP', 'JPN', 0, NULL, '2022-01-09 08:48:20', '2022-01-09 08:48:20', NULL),
(109, '254', 'KE', 'KEN', 0, NULL, '2022-01-09 08:48:21', '2022-01-09 08:48:21', NULL),
(110, '996', 'KG', 'KGZ', 0, NULL, '2022-01-09 08:48:21', '2022-01-09 08:48:21', NULL),
(111, '855', 'KH', 'KHM', 0, NULL, '2022-01-09 08:48:21', '2022-01-09 08:48:21', NULL),
(112, '686', 'KI', 'KIR', 0, NULL, '2022-01-09 08:48:21', '2022-01-09 08:48:21', NULL),
(113, '269', 'KM', 'COM', 0, NULL, '2022-01-09 08:48:21', '2022-01-09 08:48:21', NULL),
(114, '1', 'KN', 'KNA', 0, NULL, '2022-01-09 08:48:21', '2022-01-09 08:48:21', NULL),
(115, '850', 'KP', 'PRK', 0, NULL, '2022-01-09 08:48:22', '2022-01-09 08:48:22', NULL),
(116, '82', 'KR', 'KOR', 0, NULL, '2022-01-09 08:48:22', '2022-01-09 08:48:22', NULL),
(117, '965', 'KW', 'KWT', 0, NULL, '2022-01-09 08:48:22', '2022-01-09 08:48:22', NULL),
(118, '1', 'KY', 'CYM', 0, NULL, '2022-01-09 08:48:22', '2022-01-09 08:48:22', NULL),
(119, '7', 'KZ', 'KAZ', 0, NULL, '2022-01-09 08:48:22', '2022-01-09 08:48:22', NULL),
(120, '856', 'LA', 'LAO', 0, NULL, '2022-01-09 08:48:22', '2022-01-09 08:48:22', NULL),
(121, '961', 'LB', 'LBN', 0, NULL, '2022-01-09 08:48:22', '2022-01-09 08:48:22', NULL),
(122, '1', 'LC', 'LCA', 0, NULL, '2022-01-09 08:48:22', '2022-01-09 08:48:22', NULL),
(123, '423', 'LI', 'LIE', 0, NULL, '2022-01-09 08:48:22', '2022-01-09 08:48:22', NULL),
(124, '94', 'LK', 'LKA', 0, NULL, '2022-01-09 08:48:22', '2022-01-09 08:48:22', NULL),
(125, '231', 'LR', 'LBR', 0, NULL, '2022-01-09 08:48:22', '2022-01-09 08:48:22', NULL),
(126, '266', 'LS', 'LSO', 0, NULL, '2022-01-09 08:48:23', '2022-01-09 08:48:23', NULL),
(127, '370', 'LT', 'LTU', 0, NULL, '2022-01-09 08:48:23', '2022-01-09 08:48:23', NULL),
(128, '352', 'LU', 'LUX', 0, NULL, '2022-01-09 08:48:23', '2022-01-09 08:48:23', NULL),
(129, '371', 'LV', 'LVA', 0, NULL, '2022-01-09 08:48:23', '2022-01-09 08:48:23', NULL),
(130, '218', 'LY', 'LBY', 0, NULL, '2022-01-09 08:48:23', '2022-01-09 08:48:23', NULL),
(131, '212', 'MA', 'MAR', 0, NULL, '2022-01-09 08:48:23', '2022-01-09 08:48:23', NULL),
(132, '377', 'MC', 'MCO', 0, NULL, '2022-01-09 08:48:23', '2022-01-09 08:48:23', NULL),
(133, '373', 'MD', 'MDA', 0, NULL, '2022-01-09 08:48:23', '2022-01-09 08:48:23', NULL),
(134, '382', 'ME', 'MNE', 0, NULL, '2022-01-09 08:48:23', '2022-01-09 08:48:23', NULL),
(135, '261', 'MG', 'MDG', 0, NULL, '2022-01-09 08:48:23', '2022-01-09 08:48:23', NULL),
(136, '692', 'MH', 'MHL', 0, NULL, '2022-01-09 08:48:23', '2022-01-09 08:48:23', NULL),
(137, '389', 'MK', 'MKD', 0, NULL, '2022-01-09 08:48:23', '2022-01-09 08:48:23', NULL),
(138, '223', 'ML', 'MLI', 0, NULL, '2022-01-09 08:48:24', '2022-01-09 08:48:24', NULL),
(139, '95', 'MM', 'MMR', 0, NULL, '2022-01-09 08:48:24', '2022-01-09 08:48:24', NULL),
(140, '976', 'MN', 'MNG', 0, NULL, '2022-01-09 08:48:24', '2022-01-09 08:48:24', NULL),
(141, '853', 'MO', 'MAC', 0, NULL, '2022-01-09 08:48:24', '2022-01-09 08:48:24', NULL),
(142, '1', 'MP', 'MNP', 0, NULL, '2022-01-09 08:48:24', '2022-01-09 08:48:24', NULL),
(143, '596', 'MQ', 'MTQ', 0, NULL, '2022-01-09 08:48:24', '2022-01-09 08:48:24', NULL),
(144, '222', 'MR', 'MRT', 0, NULL, '2022-01-09 08:48:24', '2022-01-09 08:48:24', NULL),
(145, '1', 'MS', 'MSR', 0, NULL, '2022-01-09 08:48:24', '2022-01-09 08:48:24', NULL),
(146, '356', 'MT', 'MLT', 0, NULL, '2022-01-09 08:48:25', '2022-01-09 08:48:25', NULL),
(147, '230', 'MU', 'MUS', 0, NULL, '2022-01-09 08:48:25', '2022-01-09 08:48:25', NULL),
(148, '960', 'MV', 'MDV', 0, NULL, '2022-01-09 08:48:25', '2022-01-09 08:48:25', NULL),
(149, '265', 'MW', 'MWI', 0, NULL, '2022-01-09 08:48:25', '2022-01-09 08:48:25', NULL),
(150, '52', 'MX', 'MEX', 0, NULL, '2022-01-09 08:48:25', '2022-01-09 08:48:25', NULL),
(151, '60', 'MY', 'MYS', 0, NULL, '2022-01-09 08:48:25', '2022-01-09 08:48:25', NULL),
(152, '258', 'MZ', 'MOZ', 0, NULL, '2022-01-09 08:48:25', '2022-01-09 08:48:25', NULL),
(153, '264', 'NA', 'NAM', 0, NULL, '2022-01-09 08:48:25', '2022-01-09 08:48:25', NULL),
(154, '687', 'NC', 'NCL', 0, NULL, '2022-01-09 08:48:25', '2022-01-09 08:48:25', NULL),
(155, '227', 'NE', 'NER', 0, NULL, '2022-01-09 08:48:25', '2022-01-09 08:48:25', NULL),
(156, '672', 'NF', 'NFK', 0, NULL, '2022-01-09 08:48:25', '2022-01-09 08:48:25', NULL),
(157, '234', 'NG', 'NGA', 0, NULL, '2022-01-09 08:48:26', '2022-01-09 08:48:26', NULL),
(158, '505', 'NI', 'NIC', 0, NULL, '2022-01-09 08:48:26', '2022-01-09 08:48:26', NULL),
(159, '31', 'NL', 'NLD', 0, NULL, '2022-01-09 08:48:26', '2022-01-09 08:48:26', NULL),
(160, '47', 'NO', 'NOR', 0, NULL, '2022-01-09 08:48:26', '2022-01-09 08:48:26', NULL),
(161, '977', 'NP', 'NPL', 0, NULL, '2022-01-09 08:48:26', '2022-01-09 08:48:26', NULL),
(162, '674', 'NR', 'NRU', 0, NULL, '2022-01-09 08:48:26', '2022-01-09 08:48:26', NULL),
(163, '683', 'NU', 'NIU', 0, NULL, '2022-01-09 08:48:26', '2022-01-09 08:48:26', NULL),
(164, '64', 'NZ', 'NZL', 0, NULL, '2022-01-09 08:48:26', '2022-01-09 08:48:26', NULL),
(165, '968', 'OM', 'OMN', 0, NULL, '2022-01-09 08:48:26', '2022-01-09 08:48:26', NULL),
(166, '507', 'PA', 'PAN', 0, NULL, '2022-01-09 08:48:26', '2022-01-09 08:48:26', NULL),
(167, '51', 'PE', 'PER', 0, NULL, '2022-01-09 08:48:27', '2022-01-09 08:48:27', NULL),
(168, '689', 'PF', 'PYF', 0, NULL, '2022-01-09 08:48:27', '2022-01-09 08:48:27', NULL),
(169, '675', 'PG', 'PNG', 0, NULL, '2022-01-09 08:48:27', '2022-01-09 08:48:27', NULL),
(170, '63', 'PH', 'PHL', 0, NULL, '2022-01-09 08:48:27', '2022-01-09 08:48:27', NULL),
(171, '92', 'PK', 'PAK', 0, NULL, '2022-01-09 08:48:27', '2022-01-09 08:48:27', NULL),
(172, '48', 'PL', 'POL', 0, NULL, '2022-01-09 08:48:27', '2022-01-09 08:48:27', NULL),
(173, '508', 'PM', 'SPM', 0, NULL, '2022-01-09 08:48:27', '2022-01-09 08:48:27', NULL),
(174, '64', 'PN', 'PCN', 0, NULL, '2022-01-09 08:48:27', '2022-01-09 08:48:27', NULL),
(175, '1', 'PR', 'PRI', 0, NULL, '2022-01-09 08:48:27', '2022-01-09 08:48:27', NULL),
(176, '970', 'PS', 'PSE', 0, NULL, '2022-01-09 08:48:27', '2022-01-09 08:48:27', NULL),
(177, '351', 'PT', 'PRT', 0, NULL, '2022-01-09 08:48:28', '2022-01-09 08:48:28', NULL),
(178, '680', 'PW', 'PLW', 0, NULL, '2022-01-09 08:48:28', '2022-01-09 08:48:28', NULL),
(179, '595', 'PY', 'PRY', 0, NULL, '2022-01-09 08:48:28', '2022-01-09 08:48:28', NULL),
(180, '974', 'QA', 'QAT', 0, NULL, '2022-01-09 08:48:28', '2022-01-09 08:48:28', NULL),
(181, '262', 'RE', 'REU', 0, NULL, '2022-01-09 08:48:28', '2022-01-09 08:48:28', NULL),
(182, '40', 'RO', 'ROU', 0, NULL, '2022-01-09 08:48:28', '2022-01-09 08:48:28', NULL),
(183, '381', 'RS', 'SRB', 0, NULL, '2022-01-09 08:48:28', '2022-01-09 08:48:28', NULL),
(184, '7', 'RU', 'RUS', 0, NULL, '2022-01-09 08:48:28', '2022-01-09 08:48:28', NULL),
(185, '250', 'RW', 'RWA', 0, NULL, '2022-01-09 08:48:28', '2022-01-09 08:48:28', NULL),
(186, '34', 'RY', '   ', 0, NULL, '2022-01-09 08:48:28', '2022-01-09 08:48:28', NULL),
(187, '966', 'SA', 'SAU', 0, NULL, '2022-01-09 08:48:28', '2022-01-09 08:48:28', NULL),
(188, '677', 'SB', 'SLB', 0, NULL, '2022-01-09 08:48:29', '2022-01-09 08:48:29', NULL),
(189, '248', 'SC', 'SYC', 0, NULL, '2022-01-09 08:48:29', '2022-01-09 08:48:29', NULL),
(190, '249', 'SD', 'SDN', 0, NULL, '2022-01-09 08:48:29', '2022-01-09 08:48:29', NULL),
(191, '46', 'SE', 'SWE', 0, NULL, '2022-01-09 08:48:29', '2022-01-09 08:48:29', NULL),
(192, '65', 'SG', 'SGP', 0, NULL, '2022-01-09 08:48:29', '2022-01-09 08:48:29', NULL),
(193, '386', 'SI', 'SVN', 0, NULL, '2022-01-09 08:48:29', '2022-01-09 08:48:29', NULL),
(194, '47', 'SJ', 'SJM', 0, NULL, '2022-01-09 08:48:29', '2022-01-09 08:48:29', NULL),
(195, '421', 'SK', 'SVK', 0, NULL, '2022-01-09 08:48:29', '2022-01-09 08:48:29', NULL),
(196, '232', 'SL', 'SLE', 0, NULL, '2022-01-09 08:48:29', '2022-01-09 08:48:29', NULL),
(197, '378', 'SM', 'SMR', 0, NULL, '2022-01-09 08:48:29', '2022-01-09 08:48:29', NULL),
(198, '221', 'SN', 'SEN', 0, NULL, '2022-01-09 08:48:30', '2022-01-09 08:48:30', NULL),
(199, '252', 'SO', 'SOM', 0, NULL, '2022-01-09 08:48:30', '2022-01-09 08:48:30', NULL),
(200, '597', 'SR', 'SUR', 0, NULL, '2022-01-09 08:48:30', '2022-01-09 08:48:30', NULL),
(201, '211', 'SS', 'SSD', 0, NULL, '2022-01-09 08:48:30', '2022-01-09 08:48:30', NULL),
(202, '239', 'ST', 'STP', 0, NULL, '2022-01-09 08:48:30', '2022-01-09 08:48:30', NULL),
(203, '503', 'SV', 'SLV', 0, NULL, '2022-01-09 08:48:30', '2022-01-09 08:48:30', NULL),
(204, '963', 'SY', 'SYR', 0, NULL, '2022-01-09 08:48:30', '2022-01-09 08:48:30', NULL),
(205, '268', 'SZ', 'SWZ', 0, NULL, '2022-01-09 08:48:30', '2022-01-09 08:48:30', NULL),
(206, '1', 'TC', 'TCA', 0, NULL, '2022-01-09 08:48:30', '2022-01-09 08:48:30', NULL),
(207, '235', 'TD', 'TCD', 0, NULL, '2022-01-09 08:48:30', '2022-01-09 08:48:30', NULL),
(208, '228', 'TG', 'TGO', 0, NULL, '2022-01-09 08:48:30', '2022-01-09 08:48:30', NULL),
(209, '66', 'TH', 'THA', 0, NULL, '2022-01-09 08:48:30', '2022-01-09 08:48:30', NULL),
(210, '992', 'TJ', 'TJK', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(211, '690', 'TK', 'TKL', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(212, '670', 'TL', 'TLS', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(213, '993', 'TM', 'TKM', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(214, '216', 'TN', 'TUN', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(215, '676', 'TO', 'TON', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(216, '0', 'TP', '   ', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(217, '90', 'TR', 'TUR', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(218, '1', 'TT', 'TTO', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(219, '688', 'TV', 'TUV', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(220, '886', 'TW', 'TWN', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(221, '255', 'TZ', 'TZA', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(222, '380', 'UA', 'UKR', 0, NULL, '2022-01-09 08:48:31', '2022-01-09 08:48:31', NULL),
(223, '256', 'UG', 'UGA', 0, NULL, '2022-01-09 08:48:32', '2022-01-09 08:48:32', NULL),
(224, '1', 'US', 'USA', 0, NULL, '2022-01-09 08:48:32', '2022-01-09 08:48:32', NULL),
(225, '598', 'UY', 'URY', 0, NULL, '2022-01-09 08:48:32', '2022-01-09 08:48:32', NULL),
(226, '998', 'UZ', 'UZB', 0, NULL, '2022-01-09 08:48:32', '2022-01-09 08:48:32', NULL),
(227, '39', 'VA', 'VAT', 0, NULL, '2022-01-09 08:48:32', '2022-01-09 08:48:32', NULL),
(228, '1', 'VC', 'VCT', 0, NULL, '2022-01-09 08:48:32', '2022-01-09 08:48:32', NULL),
(229, '58', 'VE', 'VEN', 0, NULL, '2022-01-09 08:48:32', '2022-01-09 08:48:32', NULL),
(230, '1', 'VG', 'VGB', 0, NULL, '2022-01-09 08:48:32', '2022-01-09 08:48:32', NULL),
(231, '1', 'VI', 'VIR', 0, NULL, '2022-01-09 08:48:32', '2022-01-09 08:48:32', NULL),
(232, '84', 'VN', 'VNM', 0, NULL, '2022-01-09 08:48:33', '2022-01-09 08:48:33', NULL),
(233, '678', 'VU', 'VUT', 0, NULL, '2022-01-09 08:48:33', '2022-01-09 08:48:33', NULL),
(234, '681', 'WF', 'WLF', 0, NULL, '2022-01-09 08:48:33', '2022-01-09 08:48:33', NULL),
(235, '685', 'WS', 'WSM', 0, NULL, '2022-01-09 08:48:33', '2022-01-09 08:48:33', NULL),
(236, '381', 'XZ', '   ', 0, NULL, '2022-01-09 08:48:33', '2022-01-09 08:48:33', NULL),
(237, '967', 'YE', 'YEM', 0, NULL, '2022-01-09 08:48:33', '2022-01-09 08:48:33', NULL),
(238, '262', 'YT', 'MYT', 0, NULL, '2022-01-09 08:48:33', '2022-01-09 08:48:33', NULL),
(239, '27', 'ZA', 'ZAF', 0, NULL, '2022-01-09 08:48:33', '2022-01-09 08:48:33', NULL),
(240, '260', 'ZM', 'ZMB', 0, NULL, '2022-01-09 08:48:33', '2022-01-09 08:48:33', NULL),
(241, '263', 'ZW', 'ZWE', 0, NULL, '2022-01-09 08:48:33', '2022-01-09 08:48:33', NULL);

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

--
-- Table structure for table `country_descriptions`
--

-- DROP TABLE IF EXISTS `country_descriptions`;
-- CREATE TABLE IF NOT EXISTS `country_descriptions` (
--   `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
--   `name` varchar(50) NOT NULL,
--   `country_id` bigint(20) UNSIGNED NOT NULL,
--   `language_id` bigint(20) UNSIGNED NOT NULL,
--   PRIMARY KEY (`id`),
--   KEY `country_descriptions_country_id_language_id_index` (`country_id`,`language_id`)
-- ) ENGINE=InnoDB AUTO_INCREMENT=483 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `country_descriptions`
--

INSERT INTO `country_descriptions` (`id`, `name`, `country_id`, `language_id`) VALUES
(1, 'Andorra', 1, 1),
(2, 'Andorra', 1, 2),
(3, 'United Arab Emirates', 2, 1),
(4, 'United Arab Emirates', 2, 2),
(5, 'Afghanistan', 3, 1),
(6, 'Afghanistan', 3, 2),
(7, 'Antigua and Barbuda', 4, 1),
(8, 'Antigua and Barbuda', 4, 2),
(9, 'Anguilla', 5, 1),
(10, 'Anguilla', 5, 2),
(11, 'Albania', 6, 1),
(12, 'Albania', 6, 2),
(13, 'Armenia', 7, 1),
(14, 'Armenia', 7, 2),
(15, 'Netherland Antilles', 8, 1),
(16, 'Netherland Antilles', 8, 2),
(17, 'Angola', 9, 1),
(18, 'Angola', 9, 2),
(19, 'Argentina', 10, 1),
(20, 'Argentina', 10, 2),
(21, 'American Samoa', 11, 1),
(22, 'American Samoa', 11, 2),
(23, 'Austria', 12, 1),
(24, 'Austria', 12, 2),
(25, 'Australia', 13, 1),
(26, 'Australia', 13, 2),
(27, 'Aruba', 14, 1),
(28, 'Aruba', 14, 2),
(29, 'Azerbaijan', 15, 1),
(30, 'Azerbaijan', 15, 2),
(31, 'Bosnia and Herzegovina', 16, 1),
(32, 'Bosnia and Herzegovina', 16, 2),
(33, 'Barbados', 17, 1),
(34, 'Barbados', 17, 2),
(35, 'Bangladesh', 18, 1),
(36, 'Bangladesh', 18, 2),
(37, 'Belgium', 19, 1),
(38, 'Belgium', 19, 2),
(39, 'Burkina Faso', 20, 1),
(40, 'Burkina Faso', 20, 2),
(41, 'Bulgaria', 21, 1),
(42, 'Bulgaria', 21, 2),
(43, 'Bahrain', 22, 1),
(44, 'Bahrain', 22, 2),
(45, 'Burundi', 23, 1),
(46, 'Burundi', 23, 2),
(47, 'Benin', 24, 1),
(48, 'Benin', 24, 2),
(49, 'Bermuda', 25, 1),
(50, 'Bermuda', 25, 2),
(51, 'Brunei', 26, 1),
(52, 'Brunei', 26, 2),
(53, 'Bolivia', 27, 1),
(54, 'Bolivia', 27, 2),
(55, 'Brazil', 28, 1),
(56, 'Brazil', 28, 2),
(57, 'Bahamas', 29, 1),
(58, 'Bahamas', 29, 2),
(59, 'Bhutan', 30, 1),
(60, 'Bhutan', 30, 2),
(61, 'Botswana', 31, 1),
(62, 'Botswana', 31, 2),
(63, 'Belarus', 32, 1),
(64, 'Belarus', 32, 2),
(65, 'Belize', 33, 1),
(66, 'Belize', 33, 2),
(67, 'Canada', 34, 1),
(68, 'Canada', 34, 2),
(69, 'Cocos Keeling IS', 35, 1),
(70, 'Cocos Keeling IS', 35, 2),
(71, 'Dem Republic of the Congo', 36, 1),
(72, 'Dem Republic of the Congo', 36, 2),
(73, 'Central African Republic', 37, 1),
(74, 'Central African Republic', 37, 2),
(75, 'Congo', 38, 1),
(76, 'Congo', 38, 2),
(77, 'Switzerland', 39, 1),
(78, 'Switzerland', 39, 2),
(79, 'Ivory Coast', 40, 1),
(80, 'Ivory Coast', 40, 2),
(81, 'Cook IS', 41, 1),
(82, 'Cook IS', 41, 2),
(83, 'Chile', 42, 1),
(84, 'Chile', 42, 2),
(85, 'Cameroon', 43, 1),
(86, 'Cameroon', 43, 2),
(87, 'China', 44, 1),
(88, 'China', 44, 2),
(89, 'Colombia', 45, 1),
(90, 'Colombia', 45, 2),
(91, 'Costa Rica', 46, 1),
(92, 'Costa Rica', 46, 2),
(93, 'Cuba', 47, 1),
(94, 'Cuba', 47, 2),
(95, 'Cape Verde', 48, 1),
(96, 'Cape Verde', 48, 2),
(97, 'Christmas IS', 49, 1),
(98, 'Christmas IS', 49, 2),
(99, 'Cyprus', 50, 1),
(100, 'Cyprus', 50, 2),
(101, 'Czech Republic', 51, 1),
(102, 'Czech Republic', 51, 2),
(103, 'Germany', 52, 1),
(104, 'Germany', 52, 2),
(105, 'Djibouti', 53, 1),
(106, 'Djibouti', 53, 2),
(107, 'Denmark', 54, 1),
(108, 'Denmark', 54, 2),
(109, 'Dominica', 55, 1),
(110, 'Dominica', 55, 2),
(111, 'Dominican Republic', 56, 1),
(112, 'Dominican Republic', 56, 2),
(113, 'Algeria', 57, 1),
(114, 'Algeria', 57, 2),
(115, 'Ecuador', 58, 1),
(116, 'Ecuador', 58, 2),
(117, 'Estonia', 59, 1),
(118, 'Estonia', 59, 2),
(119, 'Egypt', 60, 1),
(120, 'Egypt', 60, 2),
(121, 'Western Sahara', 61, 1),
(122, 'Western Sahara', 61, 2),
(123, 'Eritrea', 62, 1),
(124, 'Eritrea', 62, 2),
(125, 'Spain', 63, 1),
(126, 'Spain', 63, 2),
(127, 'Ethiopia', 64, 1),
(128, 'Ethiopia', 64, 2),
(129, 'Finland', 65, 1),
(130, 'Finland', 65, 2),
(131, 'Fiji', 66, 1),
(132, 'Fiji', 66, 2),
(133, 'Falkland IS', 67, 1),
(134, 'Falkland IS', 67, 2),
(135, 'Micronesia', 68, 1),
(136, 'Micronesia', 68, 2),
(137, 'Faroe IS', 69, 1),
(138, 'Faroe IS', 69, 2),
(139, 'France', 70, 1),
(140, 'France', 70, 2),
(141, 'Gabon', 71, 1),
(142, 'Gabon', 71, 2),
(143, 'United Kingdom', 72, 1),
(144, 'United Kingdom', 72, 2),
(145, 'Grenada', 73, 1),
(146, 'Grenada', 73, 2),
(147, 'Georgia', 74, 1),
(148, 'Georgia', 74, 2),
(149, 'French Guiana', 75, 1),
(150, 'French Guiana', 75, 2),
(151, 'Ghana', 76, 1),
(152, 'Ghana', 76, 2),
(153, 'Gibraltar', 77, 1),
(154, 'Gibraltar', 77, 2),
(155, 'Greenland', 78, 1),
(156, 'Greenland', 78, 2),
(157, 'Gambia', 79, 1),
(158, 'Gambia', 79, 2),
(159, 'Guinea', 80, 1),
(160, 'Guinea', 80, 2),
(161, 'Guadeloupe', 81, 1),
(162, 'Guadeloupe', 81, 2),
(163, 'Equatorial Guinea', 82, 1),
(164, 'Equatorial Guinea', 82, 2),
(165, 'Greece', 83, 1),
(166, 'Greece', 83, 2),
(167, 'Guatemala', 84, 1),
(168, 'Guatemala', 84, 2),
(169, 'Guam', 85, 1),
(170, 'Guam', 85, 2),
(171, 'Guinea Bissau', 86, 1),
(172, 'Guinea Bissau', 86, 2),
(173, 'Guyana', 87, 1),
(174, 'Guyana', 87, 2),
(175, 'Hong Kong', 88, 1),
(176, 'Hong Kong', 88, 2),
(177, 'Heard & McDonald Islands', 89, 1),
(178, 'Heard & McDonald Islands', 89, 2),
(179, 'Honduras', 90, 1),
(180, 'Honduras', 90, 2),
(181, 'Croatia', 91, 1),
(182, 'Croatia', 91, 2),
(183, 'Haiti', 92, 1),
(184, 'Haiti', 92, 2),
(185, 'Hungary', 93, 1),
(186, 'Hungary', 93, 2),
(187, 'Canary IS', 94, 1),
(188, 'Canary IS', 94, 2),
(189, 'Indonesia', 95, 1),
(190, 'Indonesia', 95, 2),
(191, 'Ireland', 96, 1),
(192, 'Ireland', 96, 2),
(193, 'Israel', 97, 1),
(194, 'Israel', 97, 2),
(195, 'Isle of Man', 98, 1),
(196, 'Isle of Man', 98, 2),
(197, 'India', 99, 1),
(198, 'India', 99, 2),
(199, '', 100, 1),
(200, '', 100, 2),
(201, 'Iraq', 101, 1),
(202, 'Iraq', 101, 2),
(203, 'Iran', 102, 1),
(204, 'Iran', 102, 2),
(205, 'Iceland', 103, 1),
(206, 'Iceland', 103, 2),
(207, 'Italy', 104, 1),
(208, 'Italy', 104, 2),
(209, 'Channel Islands', 105, 1),
(210, 'Channel Islands', 105, 2),
(211, 'Jamaica', 106, 1),
(212, 'Jamaica', 106, 2),
(213, 'Jordan', 107, 1),
(214, 'Jordan', 107, 2),
(215, 'Japan', 108, 1),
(216, 'Japan', 108, 2),
(217, 'Kenya', 109, 1),
(218, 'Kenya', 109, 2),
(219, 'Kyrgyzstan', 110, 1),
(220, 'Kyrgyzstan', 110, 2),
(221, 'Cambodia', 111, 1),
(222, 'Cambodia', 111, 2),
(223, 'Kiribati', 112, 1),
(224, 'Kiribati', 112, 2),
(225, 'Comoros', 113, 1),
(226, 'Comoros', 113, 2),
(227, 'St Kitts and Nevis', 114, 1),
(228, 'St Kitts and Nevis', 114, 2),
(229, 'Korea North', 115, 1),
(230, 'Korea North', 115, 2),
(231, 'Korea South', 116, 1),
(232, 'Korea South', 116, 2),
(233, 'Kuwait', 117, 1),
(234, 'Kuwait', 117, 2),
(235, 'Cayman IS', 118, 1),
(236, 'Cayman IS', 118, 2),
(237, 'Kazakhstan', 119, 1),
(238, 'Kazakhstan', 119, 2),
(239, 'Laos', 120, 1),
(240, 'Laos', 120, 2),
(241, 'Lebanon', 121, 1),
(242, 'Lebanon', 121, 2),
(243, 'St Lucia', 122, 1),
(244, 'St Lucia', 122, 2),
(245, 'Liechtenstein', 123, 1),
(246, 'Liechtenstein', 123, 2),
(247, 'Sri Lanka', 124, 1),
(248, 'Sri Lanka', 124, 2),
(249, 'Liberia', 125, 1),
(250, 'Liberia', 125, 2),
(251, 'Lesotho', 126, 1),
(252, 'Lesotho', 126, 2),
(253, 'Lithuania', 127, 1),
(254, 'Lithuania', 127, 2),
(255, 'Luxembourg', 128, 1),
(256, 'Luxembourg', 128, 2),
(257, 'Latvia', 129, 1),
(258, 'Latvia', 129, 2),
(259, 'Libya', 130, 1),
(260, 'Libya', 130, 2),
(261, 'Morocco', 131, 1),
(262, 'Morocco', 131, 2),
(263, 'Monaco', 132, 1),
(264, 'Monaco', 132, 2),
(265, 'Moldova', 133, 1),
(266, 'Moldova', 133, 2),
(267, 'Montenegro', 134, 1),
(268, 'Montenegro', 134, 2),
(269, 'Madagascar', 135, 1),
(270, 'Madagascar', 135, 2),
(271, 'Marshall IS', 136, 1),
(272, 'Marshall IS', 136, 2),
(273, 'Macedonia', 137, 1),
(274, 'Macedonia', 137, 2),
(275, 'Mali', 138, 1),
(276, 'Mali', 138, 2),
(277, 'Myanmar', 139, 1),
(278, 'Myanmar', 139, 2),
(279, 'Mongolia', 140, 1),
(280, 'Mongolia', 140, 2),
(281, 'Macau', 141, 1),
(282, 'Macau', 141, 2),
(283, 'Northern Mariana IS', 142, 1),
(284, 'Northern Mariana IS', 142, 2),
(285, 'Martinique', 143, 1),
(286, 'Martinique', 143, 2),
(287, 'Mauritania', 144, 1),
(288, 'Mauritania', 144, 2),
(289, 'Montserrat', 145, 1),
(290, 'Montserrat', 145, 2),
(291, 'Malta', 146, 1),
(292, 'Malta', 146, 2),
(293, 'Mauritius', 147, 1),
(294, 'Mauritius', 147, 2),
(295, 'Maldives', 148, 1),
(296, 'Maldives', 148, 2),
(297, 'Malawi', 149, 1),
(298, 'Malawi', 149, 2),
(299, 'Mexico', 150, 1),
(300, 'Mexico', 150, 2),
(301, 'Malaysia', 151, 1),
(302, 'Malaysia', 151, 2),
(303, 'Mozambique', 152, 1),
(304, 'Mozambique', 152, 2),
(305, 'Namibia', 153, 1),
(306, 'Namibia', 153, 2),
(307, 'New Caledonia', 154, 1),
(308, 'New Caledonia', 154, 2),
(309, 'Niger', 155, 1),
(310, 'Niger', 155, 2),
(311, 'Norfolk Island', 156, 1),
(312, 'Norfolk Island', 156, 2),
(313, 'Nigeria', 157, 1),
(314, 'Nigeria', 157, 2),
(315, 'Nicaragua', 158, 1),
(316, 'Nicaragua', 158, 2),
(317, 'Netherlands', 159, 1),
(318, 'Netherlands', 159, 2),
(319, 'Norway', 160, 1),
(320, 'Norway', 160, 2),
(321, 'Nepal', 161, 1),
(322, 'Nepal', 161, 2),
(323, 'Nauru', 162, 1),
(324, 'Nauru', 162, 2),
(325, 'Niue', 163, 1),
(326, 'Niue', 163, 2),
(327, 'New Zealand', 164, 1),
(328, 'New Zealand', 164, 2),
(329, 'Oman', 165, 1),
(330, 'Oman', 165, 2),
(331, 'Panama', 166, 1),
(332, 'Panama', 166, 2),
(333, 'Peru', 167, 1),
(334, 'Peru', 167, 2),
(335, 'French Polynesia', 168, 1),
(336, 'French Polynesia', 168, 2),
(337, 'Papua New Guinea', 169, 1),
(338, 'Papua New Guinea', 169, 2),
(339, 'Philippines', 170, 1),
(340, 'Philippines', 170, 2),
(341, 'Pakistan', 171, 1),
(342, 'Pakistan', 171, 2),
(343, 'Poland', 172, 1),
(344, 'Poland', 172, 2),
(345, 'St Pierre and Miquelon', 173, 1),
(346, 'St Pierre and Miquelon', 173, 2),
(347, 'Pitcairn IS', 174, 1),
(348, 'Pitcairn IS', 174, 2),
(349, 'Puerto Rico', 175, 1),
(350, 'Puerto Rico', 175, 2),
(351, 'Palestine', 176, 1),
(352, 'Palestine', 176, 2),
(353, 'Portugal', 177, 1),
(354, 'Portugal', 177, 2),
(355, 'Palau', 178, 1),
(356, 'Palau', 178, 2),
(357, 'Paraguay', 179, 1),
(358, 'Paraguay', 179, 2),
(359, 'Qatar', 180, 1),
(360, 'Qatar', 180, 2),
(361, 'Reunion IS', 181, 1),
(362, 'Reunion IS', 181, 2),
(363, 'Romania', 182, 1),
(364, 'Romania', 182, 2),
(365, 'Serbia', 183, 1),
(366, 'Serbia', 183, 2),
(367, 'Russia', 184, 1),
(368, 'Russia', 184, 2),
(369, 'Rwanda', 185, 1),
(370, 'Rwanda', 185, 2),
(371, 'Canary IS_Old', 186, 1),
(372, 'Canary IS_Old', 186, 2),
(373, 'Saudi Arabia', 187, 1),
(374, 'Saudi Arabia', 187, 2),
(375, 'Solomon IS', 188, 1),
(376, 'Solomon IS', 188, 2),
(377, 'Seychelles', 189, 1),
(378, 'Seychelles', 189, 2),
(379, 'Sudan', 190, 1),
(380, 'Sudan', 190, 2),
(381, 'Sweden', 191, 1),
(382, 'Sweden', 191, 2),
(383, 'Singapore', 192, 1),
(384, 'Singapore', 192, 2),
(385, 'Slovenia', 193, 1),
(386, 'Slovenia', 193, 2),
(387, 'Svalbard and Jan Mayen', 194, 1),
(388, 'Svalbard and Jan Mayen', 194, 2),
(389, 'Slovakia', 195, 1),
(390, 'Slovakia', 195, 2),
(391, 'Sierra Leone', 196, 1),
(392, 'Sierra Leone', 196, 2),
(393, 'San Marino', 197, 1),
(394, 'San Marino', 197, 2),
(395, 'Senegal', 198, 1),
(396, 'Senegal', 198, 2),
(397, 'Somalia', 199, 1),
(398, 'Somalia', 199, 2),
(399, 'Suriname', 200, 1),
(400, 'Suriname', 200, 2),
(401, 'South Sudan', 201, 1),
(402, 'South Sudan', 201, 2),
(403, 'Sao Tome and Principe', 202, 1),
(404, 'Sao Tome and Principe', 202, 2),
(405, 'El Salvador', 203, 1),
(406, 'El Salvador', 203, 2),
(407, 'Syria', 204, 1),
(408, 'Syria', 204, 2),
(409, 'Swaziland', 205, 1),
(410, 'Swaziland', 205, 2),
(411, 'Turks and Caicos IS', 206, 1),
(412, 'Turks and Caicos IS', 206, 2),
(413, 'Chad', 207, 1),
(414, 'Chad', 207, 2),
(415, 'Togo', 208, 1),
(416, 'Togo', 208, 2),
(417, 'Thailand', 209, 1),
(418, 'Thailand', 209, 2),
(419, 'Tajikistan', 210, 1),
(420, 'Tajikistan', 210, 2),
(421, 'Tokelau', 211, 1),
(422, 'Tokelau', 211, 2),
(423, 'Timor-Lestev', 212, 1),
(424, 'Timor-Lestev', 212, 2),
(425, 'Turkmenistan', 213, 1),
(426, 'Turkmenistan', 213, 2),
(427, 'Tunisia', 214, 1),
(428, 'Tunisia', 214, 2),
(429, 'Tonga', 215, 1),
(430, 'Tonga', 215, 2),
(431, 'East Timor', 216, 1),
(432, 'East Timor', 216, 2),
(433, 'Turkey', 217, 1),
(434, 'Turkey', 217, 2),
(435, 'Trinidad and Tobago', 218, 1),
(436, 'Trinidad and Tobago', 218, 2),
(437, 'Tuvalu', 219, 1),
(438, 'Tuvalu', 219, 2),
(439, 'Taiwan', 220, 1),
(440, 'Taiwan', 220, 2),
(441, 'Tanzania', 221, 1),
(442, 'Tanzania', 221, 2),
(443, 'Ukraine', 222, 1),
(444, 'Ukraine', 222, 2),
(445, 'Uganda', 223, 1),
(446, 'Uganda', 223, 2),
(447, 'United States', 224, 1),
(448, 'United States', 224, 2),
(449, 'Uruguay', 225, 1),
(450, 'Uruguay', 225, 2),
(451, 'Uzbekistan', 226, 1),
(452, 'Uzbekistan', 226, 2),
(453, 'Vatican City', 227, 1),
(454, 'Vatican City', 227, 2),
(455, 'St Vincent and Grenadine', 228, 1),
(456, 'St Vincent and Grenadine', 228, 2),
(457, 'Venezuela', 229, 1),
(458, 'Venezuela', 229, 2),
(459, 'Virgin IS - British', 230, 1),
(460, 'Virgin IS - British', 230, 2),
(461, 'Virgin Islands - US', 231, 1),
(462, 'Virgin Islands - US', 231, 2),
(463, 'Vietnam', 232, 1),
(464, 'Vietnam', 232, 2),
(465, 'Vanuatu', 233, 1),
(466, 'Vanuatu', 233, 2),
(467, 'Wallis and Futuna IS', 234, 1),
(468, 'Wallis and Futuna IS', 234, 2),
(469, 'Samoa', 235, 1),
(470, 'Samoa', 235, 2),
(471, 'Kosovo', 236, 1),
(472, 'Kosovo', 236, 2),
(473, 'Yemen', 237, 1),
(474, 'Yemen', 237, 2),
(475, 'Mayotte', 238, 1),
(476, 'Mayotte', 238, 2),
(477, 'South Africa', 239, 1),
(478, 'South Africa', 239, 2),
(479, 'Zambia', 240, 1),
(480, 'Zambia', 240, 2),
(481, 'Zimbabwe', 241, 1),
(482, 'Zimbabwe', 241, 2);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `country_descriptions`
--
ALTER TABLE `country_descriptions`
  ADD CONSTRAINT `country_descriptions_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE;
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 */;