-- http://www.phpmyadmin.net
--




--
-- Database: `laraclassified`
--

--
-- Truncate table before insert `advertising`
--

TRUNCATE TABLE `advertising`;
--
-- Dumping data for table `advertising`
--

INSERT INTO `advertising` (`id`, `slug`, `provider_name`, `tracking_code_large`, `tracking_code_medium`, `tracking_code_small`, `active`) VALUES
(1, 'top', 'Google AdSense', '<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>\r\n<!-- large970x90-visualText -->\r\n<ins class="adsbygoogle"\r\n	 style="display:inline-block;width:970px;height:90px"\r\n	 data-ad-client="ca-pub-2461204719026790"\r\n	 data-ad-slot="8943644949"></ins>\r\n<script>\r\n	(adsbygoogle = window.adsbygoogle || []).push({});\r\n</script>', '<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>\r\n<!-- medium728x90-visualText -->\r\n<ins class="adsbygoogle"\r\n	 style="display:inline-block;width:728px;height:90px"\r\n	 data-ad-client="ca-pub-2461204719026790"\r\n	 data-ad-slot="5818394949"></ins>\r\n<script>\r\n	(adsbygoogle = window.adsbygoogle || []).push({});\r\n</script>', '<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>\r\n<!-- mobile320x100-visualText -->\r\n<ins class="adsbygoogle"\r\n	 style="display:inline-block;width:320px;height:100px"\r\n	 data-ad-client="ca-pub-2461204719026790"\r\n	 data-ad-slot="2864928545"></ins>\r\n<script>\r\n	(adsbygoogle = window.adsbygoogle || []).push({});\r\n</script>', 0),
(2, 'bottom', 'Google AdSense', '<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>\r\n<!-- large970x90-visualText -->\r\n<ins class="adsbygoogle"\r\n	 style="display:inline-block;width:970px;height:90px"\r\n	 data-ad-client="ca-pub-2461204719026790"\r\n	 data-ad-slot="8943644949"></ins>\r\n<script>\r\n	(adsbygoogle = window.adsbygoogle || []).push({});\r\n</script>', '<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>\r\n<!-- medium728x90-visualText -->\r\n<ins class="adsbygoogle"\r\n	 style="display:inline-block;width:728px;height:90px"\r\n	 data-ad-client="ca-pub-2461204719026790"\r\n	 data-ad-slot="5818394949"></ins>\r\n<script>\r\n	(adsbygoogle = window.adsbygoogle || []).push({});\r\n</script>', '<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>\r\n<!-- mobile320x100-visualText -->\r\n<ins class="adsbygoogle"\r\n	 style="display:inline-block;width:320px;height:100px"\r\n	 data-ad-client="ca-pub-2461204719026790"\r\n	 data-ad-slot="2864928545"></ins>\r\n<script>\r\n	(adsbygoogle = window.adsbygoogle || []).push({});\r\n</script>', 0);

--
-- Truncate table before insert `ad_type`
--

TRUNCATE TABLE `ad_type`;
--
-- Dumping data for table `ad_type`
--

INSERT INTO `ad_type` (`id`, `translation_lang`, `translation_of`, `name`, `active`) VALUES
(1, 'en', 1, 'Private', 1),
(2, 'en', 2, 'Business', 1),
(3, 'fr', 1, 'Particulier', 1),
(4, 'fr', 2, 'Professionnel', 1),
(5, 'es', 1, 'Private', 1),
(6, 'de', 1, 'Private', 1),
(7, 'pt', 1, 'Private', 1),
(8, 'es', 2, 'Business', 1),
(9, 'de', 2, 'Business', 1),
(10, 'pt', 2, 'Business', 1);

--
-- Truncate table before insert `categories`
--

TRUNCATE TABLE `categories`;
--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `translation_lang`, `translation_of`, `parent_id`, `name`, `slug`, `description`, `picture`, `css_class`, `lft`, `rgt`, `depth`, `type`, `active`) VALUES
(1, 'en', 1, 0, 'Automobiles', 'automobiles', '', 'fa-car.png', 'fa fa-car', 26, 41, 1, 'classified', 1),
(2, 'en', 2, 1, 'Auto Parts, Accessories', 'auto-parts-accessories', NULL, NULL, NULL, 29, 30, 2, NULL, 1),
(3, 'en', 3, 1, 'Car, Motorcycle Rental', 'car-motorcycle-rental', NULL, NULL, NULL, 27, 28, 2, NULL, 1),
(4, 'en', 4, 1, 'Caravan and Boating', 'caravan-and-boating', NULL, NULL, NULL, 31, 32, 2, NULL, 1),
(5, 'en', 5, 1, 'Motorcycle parts, Accessories', 'motorcycle-parts-accessories', NULL, NULL, NULL, 33, 34, 2, NULL, 1),
(6, 'en', 6, 1, 'Motorcycles, Scooters, Quads', 'motorcycles-scooters-quads', NULL, NULL, NULL, 35, 36, 2, NULL, 1),
(7, 'en', 7, 1, 'Used Cars - New Cars', 'used-cars-new-cars', NULL, NULL, NULL, 37, 38, 2, NULL, 1),
(8, 'en', 8, 1, 'Utility Vehicles, Machinery', 'utility-vehicles-machinery', NULL, NULL, NULL, 39, 40, 2, NULL, 1),
(9, 'en', 9, 0, 'Real estate', 'real-estate', NULL, 'fa-home.png', 'icon-home', 42, 65, 1, 'classified', 1),
(10, 'en', 10, 9, 'Commercial Property - Offices - Premises', 'commercial-property-offices-premises', NULL, NULL, NULL, 47, 48, 2, NULL, 1),
(11, 'en', 11, 9, 'I''m looking for', 'im-looking-for', NULL, NULL, NULL, 51, 52, 2, NULL, 1),
(12, 'en', 12, 9, 'Roomates', 'roomates', NULL, NULL, NULL, 53, 54, 2, NULL, 1),
(13, 'en', 13, 9, 'Accommodation and Hotels', 'accommodation-and-hotels', NULL, NULL, NULL, 55, 56, 2, NULL, 1),
(14, 'en', 14, 9, 'Vacation Rental', 'vacation-rental', NULL, NULL, NULL, 57, 58, 2, NULL, 1),
(15, 'en', 15, 9, 'Garage, Parking, Farms', 'garage-parking-farms', NULL, NULL, NULL, 59, 60, 2, NULL, 1),
(16, 'en', 16, 9, 'Real Estate Services', 'real-estate-services', NULL, NULL, NULL, 61, 62, 2, NULL, 1),
(17, 'en', 17, 9, 'Rooms - Studio for Rent', 'rooms-studio-for-rent', NULL, NULL, NULL, 63, 64, 2, NULL, 1),
(18, 'en', 18, 9, 'Land for Sale, Rent', 'land-for-sale-rent', NULL, NULL, NULL, 49, 50, 2, NULL, 1),
(19, 'en', 19, 9, 'Property for sale', 'property-for-sale', NULL, NULL, NULL, 45, 46, 2, NULL, 1),
(20, 'en', 20, 9, 'Rentals', 'rentals', NULL, NULL, NULL, 43, 44, 2, NULL, 1),
(21, 'en', 21, 0, 'Services', 'services', NULL, 'ion-clipboard.png', 'fa fa-briefcase', 92, 127, 1, 'service', 1),
(22, 'en', 22, 21, 'Other services', 'other-services', NULL, NULL, NULL, 111, 112, 2, NULL, 1),
(23, 'en', 23, 21, 'Casting, Model, Photographer', 'casting-model-photographer', NULL, NULL, NULL, 123, 124, 2, NULL, 1),
(24, 'en', 24, 21, 'Carpooling', 'carpooling', NULL, NULL, NULL, 121, 122, 2, NULL, 1),
(25, 'en', 25, 21, 'Moving, Furniture Guard', 'moving-furniture-guard', NULL, NULL, NULL, 119, 120, 2, NULL, 1),
(26, 'en', 26, 21, 'Destocking - Commercial', 'destocking-commercial', NULL, NULL, NULL, 117, 118, 2, NULL, 1),
(27, 'en', 27, 21, 'Industrial Equipment', 'industrial-equipment', NULL, NULL, NULL, 115, 116, 2, NULL, 1),
(28, 'en', 28, 21, 'Aesthetics, Hairstyling', 'aesthetics-hairstyling', NULL, NULL, NULL, 93, 94, 2, NULL, 1),
(29, 'en', 29, 21, 'Horoscope - Tarot - Healers - Spell', 'horoscope-tarot-healers-spell', NULL, NULL, NULL, 113, 114, 2, NULL, 1),
(30, 'en', 30, 21, 'Materials and Equipment Pro', 'materials-and-equipment-pro', NULL, NULL, NULL, 109, 110, 2, NULL, 1),
(31, 'en', 31, 21, 'Event Organization Services', 'event-organization-services', NULL, NULL, NULL, 95, 96, 2, NULL, 1),
(32, 'en', 32, 21, 'Service Provision', 'service-provision', NULL, NULL, NULL, 107, 108, 2, NULL, 1),
(33, 'en', 33, 21, 'Health, Beauty', 'health-beauty', NULL, NULL, NULL, 105, 106, 2, NULL, 1),
(34, 'en', 34, 21, 'Artisan, Troubleshooting, Handyman', 'artisan-troubleshooting-handyman', NULL, NULL, NULL, 103, 104, 2, NULL, 1),
(35, 'en', 35, 21, 'Computing Services', 'computing-services', NULL, NULL, NULL, 101, 102, 2, NULL, 1),
(36, 'en', 36, 21, 'Tourism and Travel Services', 'tourism-and-travel-services', NULL, NULL, NULL, 99, 100, 2, NULL, 1),
(37, 'en', 37, 21, 'Translation, Writing', 'translation-writing', NULL, NULL, NULL, 125, 126, 2, NULL, 1),
(38, 'en', 38, 21, 'Construction - Renovation - Carpentry', 'construction-renovation-carpentry', NULL, NULL, NULL, 97, 98, 2, NULL, 1),
(39, 'en', 39, 0, 'Community', 'community', NULL, 'fa-users.png', 'icon-theatre', 266, 281, 1, 'classified', 1),
(40, 'en', 40, 39, 'Sporting goods, Exercise', 'sporting-goods-exercise', NULL, NULL, NULL, 267, 268, 2, NULL, 1),
(41, 'en', 41, 39, 'Artists, Musicians', 'artists-musicians', NULL, NULL, NULL, 269, 270, 2, NULL, 1),
(42, 'en', 42, 39, 'Associations, Voluntary', 'associations-voluntary', NULL, NULL, NULL, 271, 272, 2, NULL, 1),
(43, 'en', 43, 39, 'Friendships for Events', 'friendships-for-events', NULL, NULL, NULL, 273, 274, 2, NULL, 1),
(44, 'en', 44, 39, 'My neighborhood', 'my-neighborhood', NULL, NULL, NULL, 275, 276, 2, NULL, 1),
(45, 'en', 45, 39, 'Nightlife, Restaurant & Bar', 'nightlife-restaurant-bar', NULL, NULL, NULL, 277, 278, 2, NULL, 1),
(46, 'en', 46, 39, 'Outings, Entertainment', 'outings-entertainment', NULL, NULL, NULL, 279, 280, 2, NULL, 1),
(47, 'en', 47, 0, 'Multimedia', 'multimedia', NULL, 'fa-laptop.png', 'icon-laptop', 2, 25, 1, 'classified', 1),
(48, 'en', 48, 47, 'Multimedia & Phones Accessories', 'multimedia-phones-accessories', NULL, NULL, NULL, 5, 6, 2, NULL, 1),
(49, 'en', 49, 47, 'CD/DVD - Books - Movies', 'cddvd-books-movies', NULL, NULL, NULL, 7, 8, 2, NULL, 1),
(50, 'en', 50, 47, 'Consoles - Video Games', 'consoles-video-games', NULL, NULL, NULL, 11, 12, 2, NULL, 1),
(51, 'en', 51, 47, 'Computers - PC - Office Supplies', 'computers-pc-office-supplies', NULL, NULL, NULL, 13, 14, 2, NULL, 1),
(52, 'en', 52, 47, 'Wanted', 'wanted', NULL, NULL, NULL, 15, 16, 2, NULL, 1),
(53, 'en', 53, 47, 'Tablets - Touchscreens', 'tablets-touchscreens', NULL, NULL, NULL, 17, 18, 2, NULL, 1),
(54, 'en', 54, 47, 'Mobiles phones - Smartphones', 'mobiles-phones-smartphones', NULL, NULL, NULL, 19, 20, 2, NULL, 1),
(55, 'en', 55, 47, 'TV - Images - Sound', 'tv-images-sound', NULL, NULL, NULL, 21, 22, 2, NULL, 1),
(56, 'en', 56, 47, 'Clearance - Commercial', 'clearance-commercial', NULL, NULL, NULL, 23, 24, 2, NULL, 1),
(57, 'en', 57, 47, 'Industrial Equipment', 'industrial-equipment', NULL, NULL, NULL, 9, 10, 2, NULL, 1),
(58, 'en', 58, 47, 'Materials & Professional equipment', 'materials-professional-equipment', NULL, NULL, NULL, 3, 4, 2, NULL, 1),
(59, 'en', 59, 0, 'Fashion, Home & Garden', 'fashion-home-garden', NULL, 'fa-home.png', 'icon-basket-1', 66, 91, 1, 'classified', 1),
(60, 'en', 60, 59, 'Furniture - Tableware', 'furniture-tableware', NULL, NULL, NULL, 89, 90, 2, NULL, 1),
(61, 'en', 61, 59, 'Antiques - Art - Decoration', 'antiques-art-decoration', NULL, NULL, NULL, 69, 70, 2, NULL, 1),
(62, 'en', 62, 59, 'Appliances', 'appliances', NULL, NULL, NULL, 71, 72, 2, NULL, 1),
(63, 'en', 63, 59, 'Jewelry - Watches - Luggage', 'jewelry-watches-luggage', NULL, NULL, NULL, 73, 74, 2, NULL, 1),
(64, 'en', 64, 59, 'DIY - Gardening', 'diy-gardening', NULL, NULL, NULL, 75, 76, 2, NULL, 1),
(65, 'en', 65, 59, 'Various flea markets', 'various-flea-markets', NULL, NULL, NULL, 77, 78, 2, NULL, 1),
(66, 'en', 66, 59, 'Shoes', 'shoes', NULL, NULL, NULL, 79, 80, 2, NULL, 1),
(67, 'en', 67, 59, 'Toys - Games - Figurines', 'toys-games-figurines', NULL, NULL, NULL, 67, 68, 2, NULL, 1),
(68, 'en', 68, 59, 'Clothing, Fashion & Accessories', 'clothing-fashion-accessories', NULL, NULL, NULL, 81, 82, 2, NULL, 1),
(69, 'en', 69, 59, 'Stuffs for Baby and Child', 'stuffs-for-baby-and-child', NULL, NULL, NULL, 83, 84, 2, NULL, 1),
(70, 'en', 70, 59, 'Stuffs for Beauty and Health', 'stuffs-for-beauty-and-health', NULL, NULL, NULL, 85, 86, 2, NULL, 1),
(71, 'en', 71, 59, 'Wine & Gourmet - Recipes', 'wine-gourmet-recipes', NULL, NULL, NULL, 87, 88, 2, NULL, 1),
(72, 'en', 72, 0, 'Pets & Mascots', 'pets-mascots', NULL, 'map-icon-pet-store.png', 'icon-guidedog', 282, 287, 1, 'classified', 1),
(73, 'en', 73, 72, 'Accessories - Other Pets services', 'accessories-other-pets-services', NULL, NULL, NULL, 283, 284, 2, NULL, 1),
(74, 'en', 74, 72, 'Sales, Adoptions, Lost', 'sales-adoptions-lost', NULL, NULL, NULL, 285, 286, 2, NULL, 1),
(75, 'en', 75, 0, 'Free Dating', 'free-dating', NULL, 'ion-ios-heart.png', 'icon-heart', 288, 307, 1, 'classified', 1),
(76, 'en', 76, 75, 'Friendship - Friends', 'friendship-friends', NULL, NULL, NULL, 305, 306, 2, NULL, 1),
(77, 'en', 77, 75, 'Escorts - Adult Services', 'escorts-adult-services', NULL, NULL, NULL, 303, 304, 2, NULL, 1),
(78, 'en', 78, 75, 'Women Seeking Women', 'women-seeking-women', NULL, NULL, NULL, 299, 300, 2, NULL, 1),
(79, 'en', 79, 75, 'Women Seeking Men', 'women-seeking-men', NULL, NULL, NULL, 301, 302, 2, NULL, 1),
(80, 'en', 80, 75, 'Men Seeking Women', 'men-seeking-women', NULL, NULL, NULL, 289, 290, 2, NULL, 1),
(81, 'en', 81, 75, 'Men Seeking Men', 'men-seeking-men', NULL, NULL, NULL, 291, 292, 2, NULL, 1),
(82, 'en', 82, 75, 'Massage Services - Relaxation', 'massage-services-relaxation', NULL, NULL, NULL, 293, 294, 2, NULL, 1),
(83, 'en', 83, 75, 'Adults Products - Articles', 'adults-products-articles', NULL, NULL, NULL, 295, 296, 2, NULL, 1),
(84, 'en', 84, 75, 'Casual Encounter', 'casual-encounter', NULL, NULL, NULL, 297, 298, 2, NULL, 1),
(85, 'en', 85, 0, 'Jobs Offers', 'jobs-offers', NULL, 'mfglabs-users.png', 'icon-megaphone-1', 176, 223, 1, 'job-offer', 1),
(86, 'en', 86, 85, 'Agriculture - Environment', 'agriculture-environment', NULL, NULL, NULL, 197, 198, 2, NULL, 1),
(87, 'en', 87, 85, 'Assistantship - Secretariat - Helpdesk', 'assistantship-secretariat-helpdesk', NULL, NULL, NULL, 195, 196, 2, NULL, 1),
(88, 'en', 88, 85, 'Automotive - Mechanic', 'automotive-mechanic', NULL, NULL, NULL, 191, 192, 2, NULL, 1),
(89, 'en', 89, 85, 'Others Jobs Offer', 'others-jobs-offer', NULL, NULL, NULL, 189, 190, 2, NULL, 1),
(90, 'en', 90, 85, 'BTP - Construction - Building', 'btp-construction-building', NULL, NULL, NULL, 187, 188, 2, NULL, 1),
(91, 'en', 91, 85, 'Trade - Business Services', 'trade-business-services', NULL, NULL, NULL, 185, 186, 2, NULL, 1),
(92, 'en', 92, 85, 'Commercial - Sale Jobs Offer', 'commercial-sale-jobs-offer', NULL, NULL, NULL, 183, 184, 2, NULL, 1),
(93, 'en', 93, 85, 'Accounting - Management - Finance', 'accounting-management-finance', NULL, NULL, NULL, 181, 182, 2, NULL, 1),
(94, 'en', 94, 85, 'Steering - Manager', 'steering-manager', NULL, NULL, NULL, 221, 222, 2, NULL, 1),
(95, 'en', 95, 85, 'Aesthetics - Hair - Beauty', 'aesthetics-hair-beauty', NULL, NULL, NULL, 193, 194, 2, NULL, 1),
(96, 'en', 96, 85, 'Public Service Jobs Offer', 'public-service-jobs-offer', NULL, NULL, NULL, 179, 180, 2, NULL, 1),
(97, 'en', 97, 85, 'Real Estate Jobs Offer', 'real-estate-jobs-offer', NULL, NULL, NULL, 207, 208, 2, NULL, 1),
(98, 'en', 98, 85, 'Independent - Freelance - Telecommuting', 'independent-freelance-telecommuting', NULL, NULL, NULL, 199, 200, 2, NULL, 1),
(99, 'en', 99, 85, 'Computers - Internet - Telecommunications', 'computers-internet-telecommunications', NULL, NULL, NULL, 201, 202, 2, NULL, 1),
(100, 'en', 100, 85, 'Industry, Production & engineering', 'industry-production-engineering', NULL, NULL, NULL, 219, 220, 2, NULL, 1),
(101, 'en', 101, 85, 'Marketing - Communication', 'marketing-communication', NULL, NULL, NULL, 217, 218, 2, NULL, 1),
(102, 'en', 102, 85, 'Babysitting - Nanny Work', 'babysitting-nanny-work', NULL, NULL, NULL, 215, 216, 2, NULL, 1),
(103, 'en', 103, 85, 'HR - Training - Education', 'hr-training-education', NULL, NULL, NULL, 213, 214, 2, NULL, 1),
(104, 'en', 104, 85, 'Medical - Healthcare - Social', 'medical-healthcare-social', NULL, NULL, NULL, 211, 212, 2, NULL, 1),
(105, 'en', 105, 85, 'Security - Guarding', 'security-guarding', NULL, NULL, NULL, 177, 178, 2, NULL, 1),
(106, 'en', 106, 85, 'Household Services - Housekeeping', 'household-services-housekeeping', NULL, NULL, NULL, 209, 210, 2, NULL, 1),
(107, 'en', 107, 85, 'Tourism - Hotels - Restaurants - Leisure', 'tourism-hotels-restaurants-leisure', NULL, NULL, NULL, 205, 206, 2, NULL, 1),
(108, 'en', 108, 85, 'Transportation - Logistics', 'transportation-logistics', NULL, NULL, NULL, 203, 204, 2, NULL, 1),
(109, 'en', 109, 0, 'Job Search', 'job-search', NULL, 'fa-search.png', 'icon-search', 128, 175, 1, 'job-search', 1),
(110, 'en', 110, 109, 'Agriculture - Environment', 'agriculture-environment', NULL, NULL, NULL, 129, 130, 2, NULL, 1),
(111, 'en', 111, 109, 'Assistantship - Secretariat - Helpdesk', 'assistantship-secretariat-helpdesk', NULL, NULL, NULL, 153, 154, 2, NULL, 1),
(112, 'en', 112, 109, 'Automotive - Mechanic', 'automotive-mechanic', NULL, NULL, NULL, 171, 172, 2, NULL, 1),
(113, 'en', 113, 109, 'Others Jobs Search', 'others-jobs-search', NULL, NULL, NULL, 169, 170, 2, NULL, 1),
(114, 'en', 114, 109, 'BTP - Construction - Building', 'btp-construction-building', NULL, NULL, NULL, 165, 166, 2, NULL, 1),
(115, 'en', 115, 109, 'Trade - Business Services', 'trade-business-services', NULL, NULL, NULL, 167, 168, 2, NULL, 1),
(116, 'en', 116, 109, 'Commercial - Sale Jobs Search', 'commercial-sale-jobs-search', NULL, NULL, NULL, 163, 164, 2, NULL, 1),
(117, 'en', 117, 109, 'Accounting - Management - Finance', 'accounting-management-finance', NULL, NULL, NULL, 161, 162, 2, NULL, 1),
(118, 'en', 118, 109, 'Steering - Manager', 'steering-manager', NULL, NULL, NULL, 157, 158, 2, NULL, 1),
(119, 'en', 119, 109, 'Aesthetics - Hair - Beauty', 'aesthetics-hair-beauty', NULL, NULL, NULL, 155, 156, 2, NULL, 1),
(120, 'en', 120, 109, 'Public Service Jobs Search', 'public-service-jobs-search', NULL, NULL, NULL, 151, 152, 2, NULL, 1),
(121, 'en', 121, 109, 'Real Estate Jobs Search', 'real-estate-jobs-search', NULL, NULL, NULL, 131, 132, 2, NULL, 1),
(122, 'en', 122, 109, 'Independent - Freelance - Telecommuting', 'independent-freelance-telecommuting', NULL, NULL, NULL, 149, 150, 2, NULL, 1),
(123, 'en', 123, 109, 'Computers - Internet - Telecommunications', 'computers-internet-telecommunications', NULL, NULL, NULL, 147, 148, 2, NULL, 1),
(124, 'en', 124, 109, 'Industry, Production & engineering', 'industry-production-engineering', NULL, NULL, NULL, 145, 146, 2, NULL, 1),
(125, 'en', 125, 109, 'Marketing - Communication', 'marketing-communication', NULL, NULL, NULL, 159, 160, 2, NULL, 1),
(126, 'en', 126, 109, 'Babysitting - Nanny Work', 'babysitting-nanny-work', NULL, NULL, NULL, 143, 144, 2, NULL, 1),
(127, 'en', 127, 109, 'HR - Training - Education', 'hr-training-education', NULL, NULL, NULL, 141, 142, 2, NULL, 1),
(128, 'en', 128, 109, 'Medical - Healthcare - Social', 'medical-healthcare-social', NULL, NULL, NULL, 139, 140, 2, NULL, 1),
(129, 'en', 129, 109, 'Security - Guarding', 'security-guarding', NULL, NULL, NULL, 137, 138, 2, NULL, 1),
(130, 'en', 130, 109, 'Household Services - Housekeeping', 'household-services-housekeeping', NULL, NULL, NULL, 135, 136, 2, NULL, 1),
(131, 'en', 131, 109, 'Tourism - Hotels - Restaurants - Leisure', 'tourism-hotels-restaurants-leisure', NULL, NULL, NULL, 133, 134, 2, NULL, 1),
(132, 'en', 132, 109, 'Transportation - Logistics', 'transportation-logistics', NULL, NULL, NULL, 173, 174, 2, NULL, 1),
(133, 'en', 133, 0, 'Learning', 'learning', NULL, 'fa-graduation-cap.png', 'icon-book-open', 250, 265, 1, 'classified', 1),
(134, 'en', 134, 133, 'Language Classes', 'language-classes', NULL, NULL, NULL, 263, 264, 2, NULL, 1),
(135, 'en', 135, 133, 'Computer Courses', 'computer-courses', NULL, NULL, NULL, 261, 262, 2, NULL, 1),
(136, 'en', 136, 133, 'Tutoring, Private Lessons', 'tutoring-private-lessons', NULL, NULL, NULL, 257, 258, 2, NULL, 1),
(137, 'en', 137, 133, 'Vocational Training', 'vocational-training', NULL, NULL, NULL, 259, 260, 2, NULL, 1),
(138, 'en', 138, 133, 'Maths, Physics, Chemistry', 'maths-physics-chemistry', NULL, NULL, NULL, 251, 252, 2, NULL, 1),
(139, 'en', 139, 133, 'Music, Theatre, Dance', 'music-theatre-dance', NULL, NULL, NULL, 253, 254, 2, NULL, 1),
(140, 'en', 140, 133, 'School support', 'school-support', NULL, NULL, NULL, 255, 256, 2, NULL, 1),
(141, 'en', 141, 0, 'Local Events', 'local-events', NULL, 'fa-calendar.png', 'icon-megaphone-1', 224, 249, 1, 'classified', 1),
(142, 'en', 142, 141, 'Concerts & Festivals', 'concerts-festivals', NULL, NULL, NULL, 227, 228, 2, NULL, 1),
(143, 'en', 143, 141, 'Networking & Meetups', 'networking-meetups', NULL, NULL, NULL, 229, 230, 2, NULL, 1),
(144, 'en', 144, 141, 'Sports & Outdoors', 'sports-outdoors', NULL, NULL, NULL, 225, 226, 2, NULL, 1),
(145, 'en', 145, 141, 'Trade Shows & Conventions', 'trade-shows-conventions', NULL, NULL, NULL, 231, 232, 2, NULL, 1),
(146, 'en', 146, 141, 'Training & Seminars', 'training-seminars', NULL, NULL, NULL, 233, 234, 2, NULL, 1),
(147, 'en', 147, 141, 'Ceremonies', 'ceremonies', NULL, NULL, NULL, 235, 236, 2, NULL, 1),
(148, 'en', 148, 141, 'Conferences', 'conferences', NULL, NULL, NULL, 237, 238, 2, NULL, 1),
(149, 'en', 149, 141, 'Weddings', 'weddings', NULL, NULL, NULL, 239, 240, 2, NULL, 1),
(150, 'en', 150, 141, 'Birthdays', 'birthdays', NULL, NULL, NULL, 241, 242, 2, NULL, 1),
(151, 'en', 151, 141, 'Family Events', 'family-events', NULL, NULL, NULL, 243, 244, 2, NULL, 1),
(152, 'en', 152, 141, 'Nightlife', 'nightlife', NULL, NULL, NULL, 245, 246, 2, NULL, 1),
(153, 'en', 153, 141, 'All others events', 'all-others-events', NULL, NULL, NULL, 247, 248, 2, NULL, 1),
(154, 'fr', 1, 0, 'Auto - Moto', 'auto-moto', NULL, 'fa-car.png', 'fa fa-car', 8, 9, 1, 'classified', 1),
(155, 'fr', 2, 1, 'Caravane et Nautisme', 'caravane-et-nautisme', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(156, 'fr', 3, 1, 'Location Véhicule, Motos', 'location-vehicule-motos', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(157, 'fr', 4, 1, 'Motos, Quads - Scooters, Vélos', 'motos-quads-scooters-velos', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(158, 'fr', 5, 1, 'Pièces détachées auto', 'pieces-detachees-auto', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(159, 'fr', 6, 1, 'Pièces et accessoires moto', 'pieces-et-accessoires-moto', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(160, 'fr', 7, 1, 'Véhicules Utilitaires et Engins', 'vehicules-utilitaires-et-engins', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(161, 'fr', 8, 1, 'Voitures Occasion ou Neuves', 'voitures-occasion-ou-neuves', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(162, 'fr', 9, 0, 'Immobilier', 'immobilier', NULL, 'fa-home.png', 'icon-home', 4, 5, 1, NULL, 1),
(163, 'fr', 10, 9, 'Bureaux - Locaux commerciaux', 'bureaux-locaux-commerciaux', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(164, 'fr', 11, 9, 'Cherche Ã  louer ou acheter', 'cherche-a-louer-ou-acheter', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(165, 'fr', 12, 9, 'Colocations', 'colocations', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(166, 'fr', 13, 9, 'Hôtels et hébergements', 'hotels-et-hebergements', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(167, 'fr', 14, 9, 'Location Maison, Appartement', 'location-maison-appartement', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(168, 'fr', 15, 9, 'Location Vacances - Gîtes', 'location-vacances-gites', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(169, 'fr', 16, 9, 'Parkings, Garages, Fermes', 'parkings-garages-fermes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(170, 'fr', 17, 9, 'Services Immobiliers pro', 'services-immobiliers-pro', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(171, 'fr', 18, 9, 'Studio - Chambre Ã  louer', 'studio-chambre-a-louer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(172, 'fr', 19, 9, 'Terrains Ã  Vendre, Louer, Batir', 'terrains-a-vendre-louer-batir', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(173, 'fr', 20, 9, 'Ventes immobilières', 'ventes-immobilieres', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(174, 'fr', 21, 0, 'Services', 'services', NULL, 'ion-clipboard.png', 'fa fa-briefcase', 10, 11, 1, 'service', 1),
(175, 'fr', 22, 21, 'Autres services & Bons plans', 'autres-services-bons-plans', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(176, 'fr', 23, 21, 'Casting, Modèle, Photographe', 'casting-modele-photographe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(177, 'fr', 24, 21, 'Covoiturage - Auto-stop', 'covoiturage-auto-stop', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(178, 'fr', 25, 21, 'Déménagement, Garde-Meubles', 'demenagement-garde-meubles', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(179, 'fr', 26, 21, 'Déstockage - Fond de Commerce', 'destockage-fond-de-commerce', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(180, 'fr', 27, 21, 'Équipements Industriels', 'equipements-industriels', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(181, 'fr', 28, 21, 'Esthétique - Coiffure', 'esthetique-coiffure', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(182, 'fr', 29, 21, 'Horoscope - Voyance - Astrologie', 'horoscope-voyance-astrologie', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(183, 'fr', 30, 21, 'Matériaux et équipements pro', 'materiaux-et-equipements-pro', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(184, 'fr', 31, 21, 'Organisation Evènement', 'organisation-evenement', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(185, 'fr', 32, 21, 'Prestations de services', 'prestations-de-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(186, 'fr', 33, 21, 'Santé, Forme, Beauté', 'sante-forme-beaute', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(187, 'fr', 34, 21, 'Services Dépannage - Artisan', 'services-depannage-artisan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(188, 'fr', 35, 21, 'Services Informatiques', 'services-informatiques', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(189, 'fr', 36, 21, 'Services tourisme et voyage', 'services-tourisme-et-voyage', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(190, 'fr', 37, 21, 'Traduction - Rédaction', 'traduction-redaction', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(191, 'fr', 38, 21, 'Travaux - Rénovation - Menuiserie', 'travaux-renovation-menuiserie', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(192, 'fr', 39, 0, 'Loisirs', 'loisirs', NULL, 'fa-users.png', 'icon-theatre', 20, 21, 1, NULL, 1),
(193, 'fr', 40, 39, 'Articles de sport, Exercice', 'articles-de-sport-exercice', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(194, 'fr', 41, 39, 'Artistes, Musiciens', 'artistes-musiciens', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(195, 'fr', 42, 39, 'Association, Bénévoles', 'association-benevoles', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(196, 'fr', 43, 39, 'CD/DVD - Livres - Films', 'cddvd-livres-films', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(197, 'fr', 44, 39, 'Infos locales et Autres', 'infos-locales-et-autres', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(198, 'fr', 45, 39, 'Restaurants, Bars, Snack', 'restaurants-bars-snack', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(199, 'fr', 46, 39, 'Sorties - Loisirs - Soirée', 'sorties-loisirs-soiree', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(200, 'fr', 47, 0, 'Multimédia', 'multimedia', NULL, 'fa-laptop.png', 'icon-laptop', 2, 3, 1, NULL, 1),
(201, 'fr', 48, 47, 'Accessoires Multimédia et Informatique', 'accessoires-multimedia-et-informatique', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(202, 'fr', 49, 47, 'CD/DVD - Livres - Films', 'cddvd-livres-films', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(203, 'fr', 50, 47, 'Consoles - Jeux vidéos', 'consoles-jeux-videos', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(204, 'fr', 51, 47, 'Ordinateurs de bureau - Portables', 'ordinateurs-de-bureau-portables', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(205, 'fr', 52, 47, 'Recherche pour acheter', 'recherche-pour-acheter', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(206, 'fr', 53, 47, 'Tablettes - Ecrans tactiles', 'tablettes-ecrans-tactiles', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(207, 'fr', 54, 47, 'Téléphones mobiles - Smartphones', 'telephones-mobiles-smartphones', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(208, 'fr', 55, 47, 'TV, Images, Son, Appareils photo', 'tv-images-son-appareils-photo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(209, 'fr', 56, 47, 'Liquidation - Commercial', 'liquidation-commercial', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(210, 'fr', 57, 47, 'Equipement industriel', 'equipement-industriel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(211, 'fr', 58, 47, 'Matériaux et équipements professionnels', 'materiaux-et-equipements-professionnels', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(212, 'fr', 59, 0, 'Mode, Maison & Déco', 'mode-maison-deco', NULL, 'fa-home.png', 'icon-basket-1', 6, 7, 1, NULL, 1),
(213, 'fr', 60, 59, 'Ameublement - Art de la table', 'ameublement-art-de-la-table', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(214, 'fr', 61, 59, 'Antiquités - Art - Décoration', 'antiquites-art-decoration', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(215, 'fr', 62, 59, 'Appareils électroménagers', 'appareils-electromenagers', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(216, 'fr', 63, 59, 'Bijoux - Montres - Bagagerie', 'bijoux-montres-bagagerie', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(217, 'fr', 64, 59, 'Bricolage - Jardinage', 'bricolage-jardinage', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(218, 'fr', 65, 59, 'Brocantes divers', 'brocantes-divers', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(219, 'fr', 66, 59, 'Chaussures', 'chaussures', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(220, 'fr', 67, 59, 'Jeux - Jouets - Figurines', 'jeux-jouets-figurines', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(221, 'fr', 68, 59, 'Vêtements - Sacs - Accessoires Mode', 'vetements-sacs-accessoires-mode', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(222, 'fr', 69, 59, 'Puériculture et équipement Bébé', 'puericulture-et-equipement-bebe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(223, 'fr', 70, 59, 'Beauté, Santé', 'beaute-sante', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(224, 'fr', 71, 59, 'Vins & Gastronomie - Recettes', 'vins-gastronomie-recettes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(225, 'fr', 72, 0, 'Animaux, Mascottes', 'animaux-mascottes', NULL, 'map-icon-pet-store.png', 'icon-guidedog', 22, 23, 1, NULL, 1),
(226, 'fr', 73, 72, 'Services, Accessoires et Autres', 'services-accessoires-et-autres', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(227, 'fr', 74, 72, 'Ventes, Adoptions, Perdus', 'ventes-adoptions-perdus', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(228, 'fr', 75, 0, 'Rencontres', 'rencontres', NULL, 'ion-ios-heart.png', 'icon-heart', 24, 25, 1, NULL, 1),
(229, 'fr', 76, 75, 'Amitiés - Compagnons', 'amities-compagnons', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(230, 'fr', 77, 75, 'Escorts - Services Adultes', 'escorts-services-adultes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(231, 'fr', 78, 75, 'Femme cherche Femme', 'femme-cherche-femme', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(232, 'fr', 79, 75, 'Femme cherche Homme', 'femme-cherche-homme', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(233, 'fr', 80, 75, 'Homme cherche Femme', 'homme-cherche-femme', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(234, 'fr', 81, 75, 'Homme cherche Homme', 'homme-cherche-homme', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(235, 'fr', 82, 75, 'Massage - Relaxation', 'massage-relaxation', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(236, 'fr', 83, 75, 'Produits Adultes - Articles', 'produits-adultes-articles', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(237, 'fr', 84, 75, 'Rencontre Occasionnelle', 'rencontre-occasionnelle', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(238, 'fr', 85, 0, 'Offres Emploi', 'offres-emploi', NULL, 'mfglabs-users.png', 'icon-megaphone-1', 14, 15, 1, 'job-offer', 1),
(239, 'fr', 86, 85, 'Agriculture - Environnement', 'agriculture-environnement', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(240, 'fr', 87, 85, 'Assistanat - Secrétariat - Accueil', 'assistanat-secretariat-accueil', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(241, 'fr', 88, 85, 'Automobile - Mécanicien', 'automobile-mecanicien', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(242, 'fr', 89, 85, 'Autres offres d''emploi', 'autres-offres-demploi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(243, 'fr', 90, 85, 'BTP - Bâtiment Emplois', 'btp-batiment-emplois', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(244, 'fr', 91, 85, 'Commerce - Prestation de proximité', 'commerce-prestation-de-proximite', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(245, 'fr', 92, 85, 'Commercial - Vente - Distribution', 'commercial-vente-distribution', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(246, 'fr', 93, 85, 'Comptabilité - Gestion - Finance', 'comptabilite-gestion-finance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(247, 'fr', 94, 85, 'Direction - Responsable - Manager', 'direction-responsable-manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(248, 'fr', 95, 85, 'Esthétique - Coiffure - Beauté', 'esthetique-coiffure-beaute', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(249, 'fr', 96, 85, 'Fonction publique Emplois', 'fonction-publique-emplois', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(250, 'fr', 97, 85, 'Immobilier Emplois', 'immobilier-emplois', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(251, 'fr', 98, 85, 'Indépendant - Freelance - Télétravail', 'independant-freelance-teletravail', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(252, 'fr', 99, 85, 'Informatique - Internet - Télécom - IT', 'informatique-internet-telecom-it', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(253, 'fr', 100, 85, 'Ingénierie - Industrie - Production', 'ingenierie-industrie-production', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(254, 'fr', 101, 85, 'Marketing - Communication', 'marketing-communication', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(255, 'fr', 102, 85, 'Nounou - Garde d''enfants', 'nounou-garde-denfants', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(256, 'fr', 103, 85, 'RH - Formation - Enseignement', 'rh-formation-enseignement', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(257, 'fr', 104, 85, 'Santé - Paramédical - Social', 'sante-paramedical-social', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(258, 'fr', 105, 85, 'Sécurité - Gardiennage', 'securite-gardiennage', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(259, 'fr', 106, 85, 'Services Ménagers - Entretien Ménager', 'services-menagers-entretien-menager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(260, 'fr', 107, 85, 'Tourisme - Hôtellerie - Restauration - Loisirs', 'tourisme-hotellerie-restauration-loisirs', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(261, 'fr', 108, 85, 'Transport - Logistique', 'transport-logistique', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(262, 'fr', 109, 0, 'Recherche Emploi', 'recherche-emploi', NULL, 'fa-search.png', 'icon-search', 12, 13, 1, 'job-search', 1),
(263, 'fr', 110, 109, 'Agriculture - Environnement', 'agriculture-environnement', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(264, 'fr', 111, 109, 'Assistanat - Secrétariat - Accueil', 'assistanat-secretariat-accueil', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(265, 'fr', 112, 109, 'Automobile - Mécanicien', 'automobile-mecanicien', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(266, 'fr', 113, 109, 'Autres recherche d''emploi', 'autres-recherche-demploi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(267, 'fr', 114, 109, 'BTP - Bâtiment Emploi', 'btp-batiment-emploi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(268, 'fr', 115, 109, 'Commerce - Prestation de proximité', 'commerce-prestation-de-proximite', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(269, 'fr', 116, 109, 'Commercial - Vente - Distribution', 'commercial-vente-distribution', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(270, 'fr', 117, 109, 'Comptabilité - Gestion - Finance', 'comptabilite-gestion-finance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(271, 'fr', 118, 109, 'Direction - Responsable - Manager', 'direction-responsable-manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(272, 'fr', 119, 109, 'Esthétique - Coiffure - Beauté', 'esthetique-coiffure-beaute', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(273, 'fr', 120, 109, 'Fonction publique Emploi', 'fonction-publique-emploi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(274, 'fr', 121, 109, 'Immobilier Emploi', 'immobilier-emploi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(275, 'fr', 122, 109, 'Indépendant - Freelance - Télétravail', 'independant-freelance-teletravail', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(276, 'fr', 123, 109, 'Informatique - Internet - Télécom - IT', 'informatique-internet-telecom-it', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(277, 'fr', 124, 109, 'Ingénierie - Industrie - Production', 'ingenierie-industrie-production', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(278, 'fr', 125, 109, 'Marketing - Communication', 'marketing-communication', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(279, 'fr', 126, 109, 'Nounou - Garde d''enfants', 'nounou-garde-denfants', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(280, 'fr', 127, 109, 'RH - Formation - Enseignement', 'rh-formation-enseignement', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(281, 'fr', 128, 109, 'Santé - Paramédical - Social', 'sante-paramedical-social', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(282, 'fr', 129, 109, 'Sécurité - Gardiennage', 'securite-gardiennage', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(283, 'fr', 130, 109, 'Services Ménagers - Entretien Ménager', 'services-menagers-entretien-menager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(284, 'fr', 131, 109, 'Tourisme - Hôtellerie - Restauration - Loisirs', 'tourisme-hotellerie-restauration-loisirs', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(285, 'fr', 132, 109, 'Transport - Logistique', 'transport-logistique', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(286, 'fr', 133, 0, 'Formations', 'formations', NULL, 'fa-graduation-cap.png', 'icon-book-open', 18, 19, 1, NULL, 1),
(287, 'fr', 134, 133, 'Cours de Langues', 'cours-de-langues', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(288, 'fr', 135, 133, 'Cours Informatique', 'cours-informatique', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(289, 'fr', 136, 133, 'Cours Particuliers', 'cours-particuliers', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(290, 'fr', 137, 133, 'Formation Professionnelle', 'formation-professionnelle', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(291, 'fr', 138, 133, 'Maths, physique, chimie', 'maths-physique-chimie', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(292, 'fr', 139, 133, 'Musique, Théâtre, Danse', 'musique-theatre-danse', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(293, 'fr', 140, 133, 'Soutien scolaire', 'soutien-scolaire', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(294, 'fr', 141, 0, 'Evénements', 'evenements', NULL, 'fa-calendar.png', 'icon-megaphone-1', 16, 17, 1, NULL, 1),
(295, 'fr', 142, 141, 'Concerts et festivals', 'concerts-et-festivals', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(296, 'fr', 143, 141, 'Réseautage et Meetups', 'reseautage-et-meetups', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(297, 'fr', 144, 141, 'Sport et Loisirs', 'sport-et-loisirs', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(298, 'fr', 145, 141, 'Salons et Congrès', 'salons-et-congres', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(299, 'fr', 146, 141, 'Formations & Séminaires', 'formations-seminaires', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(300, 'fr', 147, 141, 'Cérémonies', 'ceremonies', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(301, 'fr', 148, 141, 'Conférences', 'conferences', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(302, 'fr', 149, 141, 'Mariages', 'mariages', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(303, 'fr', 150, 141, 'Anniversaires', 'anniversaires', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(304, 'fr', 151, 141, 'Les événements familiaux', 'les-evenements-familiaux', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(305, 'fr', 152, 141, 'Vie nocturne', 'vie-nocturne', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(306, 'fr', 153, 141, 'Autres événements', 'autres-evenements', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(307, 'es', 1, 0, 'Automovilismo', 'automovilismo', NULL, 'fa-car.png', 'fa fa-car', 4, 5, 1, NULL, 1),
(308, 'es', 2, 1, 'Auto Parts, Accessories', 'auto-parts-accessories', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(309, 'es', 3, 1, 'Car, Motorcycle Rental', 'car-motorcycle-rental', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(310, 'es', 4, 1, 'Caravan and Boating', 'caravan-and-boating', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(311, 'es', 5, 1, 'Motorcycle parts, Accessories', 'motorcycle-parts-accessories', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(312, 'es', 6, 1, 'Motorcycles, Scooters, Quads', 'motorcycles-scooters-quads', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(313, 'es', 7, 1, 'Used Cars - New Cars', 'used-cars-new-cars', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(314, 'es', 8, 1, 'Utility Vehicles, Machinery', 'utility-vehicles-machinery', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(315, 'es', 9, 0, 'Bienes raíces', 'bienes-raices', NULL, 'fa-home.png', 'icon-home', 6, 7, 1, NULL, 1),
(316, 'es', 10, 9, 'Commercial Property - Offices - Premises', 'commercial-property-offices-premises', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(317, 'es', 11, 9, 'I''m looking for', 'im-looking-for', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(318, 'es', 12, 9, 'Roomates', 'roomates', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(319, 'es', 13, 9, 'Accommodation and Hotels', 'accommodation-and-hotels', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(320, 'es', 14, 9, 'Vacation Rental', 'vacation-rental', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(321, 'es', 15, 9, 'Garage, Parking, Farms', 'garage-parking-farms', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(322, 'es', 16, 9, 'Real Estate Services', 'real-estate-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(323, 'es', 17, 9, 'Rooms - Studio for Rent', 'rooms-studio-for-rent', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(324, 'es', 18, 9, 'Land for Sale, Rent', 'land-for-sale-rent', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(325, 'es', 19, 9, 'Property for sale', 'property-for-sale', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(326, 'es', 20, 9, 'Rentals', 'rentals', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(327, 'es', 21, 0, 'Servicios', 'servicios', NULL, 'ion-clipboard.png', 'fa fa-briefcase', 10, 11, 1, 'service', 1),
(328, 'es', 22, 21, 'Other services', 'other-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(329, 'es', 23, 21, 'Casting, Model, Photographer', 'casting-model-photographer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(330, 'es', 24, 21, 'Carpooling', 'carpooling', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(331, 'es', 25, 21, 'Moving, Furniture Guard', 'moving-furniture-guard', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(332, 'es', 26, 21, 'Destocking - Commercial', 'destocking-commercial', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(333, 'es', 27, 21, 'Industrial Equipment', 'industrial-equipment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(334, 'es', 28, 21, 'Aesthetics, Hairstyling', 'aesthetics-hairstyling', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(335, 'es', 29, 21, 'Horoscope - Tarot - Healers - Spell', 'horoscope-tarot-healers-spell', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(336, 'es', 30, 21, 'Materials and Equipment Pro', 'materials-and-equipment-pro', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(337, 'es', 31, 21, 'Event Organization Services', 'event-organization-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(338, 'es', 32, 21, 'Service Provision', 'service-provision', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(339, 'es', 33, 21, 'Health, Beauty', 'health-beauty', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(340, 'es', 34, 21, 'Artisan, Troubleshooting, Handyman', 'artisan-troubleshooting-handyman', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(341, 'es', 35, 21, 'Computing Services', 'computing-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(342, 'es', 36, 21, 'Tourism and Travel Services', 'tourism-and-travel-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(343, 'es', 37, 21, 'Translation, Writing', 'translation-writing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(344, 'es', 38, 21, 'Construction - Renovation - Carpentry', 'construction-renovation-carpentry', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(345, 'es', 39, 0, 'Comunidad y Ocio', 'comunidad-ocio', NULL, 'fa-users.png', 'icon-theatre', 20, 21, 1, NULL, 1),
(346, 'es', 40, 39, 'Sporting goods, Exercise', 'sporting-goods-exercise', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(347, 'es', 41, 39, 'Artists, Musicians', 'artists-musicians', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(348, 'es', 42, 39, 'Associations, Voluntary', 'associations-voluntary', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(349, 'es', 43, 39, 'Friendships for Events', 'friendships-for-events', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(350, 'es', 44, 39, 'My neighborhood', 'my-neighborhood', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(351, 'es', 45, 39, 'Nightlife, Restaurant & Bar', 'nightlife-restaurant-bar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(352, 'es', 46, 39, 'Outings, Entertainment', 'outings-entertainment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(353, 'es', 47, 0, 'Multimedia', 'multimedia', NULL, 'fa-laptop.png', 'icon-laptop', 2, 3, 1, NULL, 1),
(354, 'es', 48, 47, 'Multimedia & Phones Accessories', 'multimedia-phones-accessories', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(355, 'es', 49, 47, 'CD/DVD - Books - Movies', 'cddvd-books-movies', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(356, 'es', 50, 47, 'Consoles - Video Games', 'consoles-video-games', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(357, 'es', 51, 47, 'Computers - PC - Office Supplies', 'computers-pc-office-supplies', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(358, 'es', 52, 47, 'Wanted', 'wanted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(359, 'es', 53, 47, 'Tablets - Touchscreens', 'tablets-touchscreens', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(360, 'es', 54, 47, 'Mobiles phones - Smartphones', 'mobiles-phones-smartphones', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(361, 'es', 55, 47, 'TV - Images - Sound', 'tv-images-sound', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(362, 'es', 56, 47, 'Clearance - Commercial', 'clearance-commercial', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(363, 'es', 57, 47, 'Industrial Equipment', 'industrial-equipment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(364, 'es', 58, 47, 'Materials & Professional equipment', 'materials-professional-equipment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(365, 'es', 59, 0, 'Moda, Hogar y Jardín', 'moda-hogar-jardin', NULL, 'fa-home.png', 'icon-basket-1', 8, 9, 1, NULL, 1),
(366, 'es', 60, 59, 'Furniture - Tableware', 'furniture-tableware', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(367, 'es', 61, 59, 'Antiques - Art - Decoration', 'antiques-art-decoration', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(368, 'es', 62, 59, 'Appliances', 'appliances', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(369, 'es', 63, 59, 'Jewelry - Watches - Luggage', 'jewelry-watches-luggage', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(370, 'es', 64, 59, 'DIY - Gardening', 'diy-gardening', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(371, 'es', 65, 59, 'Various flea markets', 'various-flea-markets', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(372, 'es', 66, 59, 'Shoes', 'shoes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(373, 'es', 67, 59, 'Toys - Games - Figurines', 'toys-games-figurines', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(374, 'es', 68, 59, 'Clothing, Fashion & Accessories', 'clothing-fashion-accessories', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(375, 'es', 69, 59, 'Stuffs for Baby and Child', 'stuffs-for-baby-and-child', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(376, 'es', 70, 59, 'Stuffs for Beauty and Health', 'stuffs-for-beauty-and-health', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(377, 'es', 71, 59, 'Wine & Gourmet - Recipes', 'wine-gourmet-recipes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(378, 'es', 72, 0, 'Animales y mascotas', 'animales-mascotas', NULL, 'map-icon-pet-store.png', 'icon-guidedog', 22, 23, 1, NULL, 1),
(379, 'es', 73, 72, 'Accessories - Other Pets services', 'accessories-other-pets-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(380, 'es', 74, 72, 'Sales, Adoptions, Lost', 'sales-adoptions-lost', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(381, 'es', 75, 0, 'Citas gratuito', 'citas-gratuito', NULL, 'ion-ios-heart.png', 'icon-heart', 24, 25, 1, NULL, 1),
(382, 'es', 76, 75, 'Friendship - Friends', 'friendship-friends', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(383, 'es', 77, 75, 'Escorts - Adult Services', 'escorts-adult-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(384, 'es', 78, 75, 'Women Seeking Women', 'women-seeking-women', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(385, 'es', 79, 75, 'Women Seeking Men', 'women-seeking-men', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(386, 'es', 80, 75, 'Men Seeking Women', 'men-seeking-women', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(387, 'es', 81, 75, 'Men Seeking Men', 'men-seeking-men', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(388, 'es', 82, 75, 'Massage Services - Relaxation', 'massage-services-relaxation', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(389, 'es', 83, 75, 'Adults Products - Articles', 'adults-products-articles', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(390, 'es', 84, 75, 'Casual Encounter', 'casual-encounter', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(391, 'es', 85, 0, 'Ofertas de empleo', 'ofertas-empleo', NULL, 'mfglabs-users.png', 'icon-megaphone-1', 14, 15, 1, 'job-offer', 1),
(392, 'es', 86, 85, 'Agriculture - Environment', 'agriculture-environment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(393, 'es', 87, 85, 'Assistantship - Secretariat - Helpdesk', 'assistantship-secretariat-helpdesk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(394, 'es', 88, 85, 'Automotive - Mechanic', 'automotive-mechanic', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(395, 'es', 89, 85, 'Others Jobs Offer', 'others-jobs-offer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(396, 'es', 90, 85, 'BTP - Construction - Building', 'btp-construction-building', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(397, 'es', 91, 85, 'Trade - Business Services', 'trade-business-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(398, 'es', 92, 85, 'Commercial - Sale Jobs Offer', 'commercial-sale-jobs-offer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(399, 'es', 93, 85, 'Accounting - Management - Finance', 'accounting-management-finance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(400, 'es', 94, 85, 'Steering - Manager', 'steering-manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(401, 'es', 95, 85, 'Aesthetics - Hair - Beauty', 'aesthetics-hair-beauty', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(402, 'es', 96, 85, 'Public Service Jobs Offer', 'public-service-jobs-offer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(403, 'es', 97, 85, 'Real Estate Jobs Offer', 'real-estate-jobs-offer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(404, 'es', 98, 85, 'Independent - Freelance - Telecommuting', 'independent-freelance-telecommuting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(405, 'es', 99, 85, 'Computers - Internet - Telecommunications', 'computers-internet-telecommunications', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(406, 'es', 100, 85, 'Industry, Production & engineering', 'industry-production-engineering', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(407, 'es', 101, 85, 'Marketing - Communication', 'marketing-communication', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(408, 'es', 102, 85, 'Babysitting - Nanny Work', 'babysitting-nanny-work', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(409, 'es', 103, 85, 'HR - Training - Education', 'hr-training-education', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(410, 'es', 104, 85, 'Medical - Healthcare - Social', 'medical-healthcare-social', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(411, 'es', 105, 85, 'Security - Guarding', 'security-guarding', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(412, 'es', 106, 85, 'Household Services - Housekeeping', 'household-services-housekeeping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(413, 'es', 107, 85, 'Tourism - Hotels - Restaurants - Leisure', 'tourism-hotels-restaurants-leisure', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(414, 'es', 108, 85, 'Transportation - Logistics', 'transportation-logistics', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(415, 'es', 109, 0, 'Búsqueda de trabajo', 'busqueda-trabajo', NULL, 'fa-search.png', 'icon-search', 12, 13, 1, 'job-search', 1),
(416, 'es', 110, 109, 'Agriculture - Environment', 'agriculture-environment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(417, 'es', 111, 109, 'Assistantship - Secretariat - Helpdesk', 'assistantship-secretariat-helpdesk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(418, 'es', 112, 109, 'Automotive - Mechanic', 'automotive-mechanic', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(419, 'es', 113, 109, 'Others Jobs Search', 'others-jobs-search', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(420, 'es', 114, 109, 'BTP - Construction - Building', 'btp-construction-building', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(421, 'es', 115, 109, 'Trade - Business Services', 'trade-business-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(422, 'es', 116, 109, 'Commercial - Sale Jobs Search', 'commercial-sale-jobs-search', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(423, 'es', 117, 109, 'Accounting - Management - Finance', 'accounting-management-finance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(424, 'es', 118, 109, 'Steering - Manager', 'steering-manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(425, 'es', 119, 109, 'Aesthetics - Hair - Beauty', 'aesthetics-hair-beauty', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(426, 'es', 120, 109, 'Public Service Jobs Search', 'public-service-jobs-search', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(427, 'es', 121, 109, 'Real Estate Jobs Search', 'real-estate-jobs-search', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(428, 'es', 122, 109, 'Independent - Freelance - Telecommuting', 'independent-freelance-telecommuting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(429, 'es', 123, 109, 'Computers - Internet - Telecommunications', 'computers-internet-telecommunications', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(430, 'es', 124, 109, 'Industry, Production & engineering', 'industry-production-engineering', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(431, 'es', 125, 109, 'Marketing - Communication', 'marketing-communication', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(432, 'es', 126, 109, 'Babysitting - Nanny Work', 'babysitting-nanny-work', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(433, 'es', 127, 109, 'HR - Training - Education', 'hr-training-education', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(434, 'es', 128, 109, 'Medical - Healthcare - Social', 'medical-healthcare-social', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(435, 'es', 129, 109, 'Security - Guarding', 'security-guarding', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(436, 'es', 130, 109, 'Household Services - Housekeeping', 'household-services-housekeeping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(437, 'es', 131, 109, 'Tourism - Hotels - Restaurants - Leisure', 'tourism-hotels-restaurants-leisure', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(438, 'es', 132, 109, 'Transportation - Logistics', 'transportation-logistics', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(439, 'es', 133, 0, 'Aprendizaje', 'aprendizaje', NULL, 'fa-graduation-cap.png', 'icon-book-open', 18, 19, 1, NULL, 1),
(440, 'es', 134, 133, 'Language Classes', 'language-classes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(441, 'es', 135, 133, 'Computer Courses', 'computer-courses', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(442, 'es', 136, 133, 'Tutoring, Private Lessons', 'tutoring-private-lessons', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(443, 'es', 137, 133, 'Vocational Training', 'vocational-training', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(444, 'es', 138, 133, 'Maths, Physics, Chemistry', 'maths-physics-chemistry', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(445, 'es', 139, 133, 'Music, Theatre, Dance', 'music-theatre-dance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(446, 'es', 140, 133, 'School support', 'school-support', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(447, 'es', 141, 0, 'Eventos locales', 'eventos-locales', NULL, 'fa-calendar.png', 'icon-megaphone-1', 16, 17, 1, NULL, 1),
(448, 'es', 142, 141, 'Concerts & Festivals', 'concerts-festivals', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(449, 'es', 143, 141, 'Networking & Meetups', 'networking-meetups', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(450, 'es', 144, 141, 'Sports & Outdoors', 'sports-outdoors', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(451, 'es', 145, 141, 'Trade Shows & Conventions', 'trade-shows-conventions', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(452, 'es', 146, 141, 'Training & Seminars', 'training-seminars', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(453, 'es', 147, 141, 'Ceremonies', 'ceremonies', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(454, 'es', 148, 141, 'Conferences', 'conferences', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(455, 'es', 149, 141, 'Weddings', 'weddings', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(456, 'es', 150, 141, 'Birthdays', 'birthdays', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(457, 'es', 151, 141, 'Family Events', 'family-events', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(458, 'es', 152, 141, 'Nightlife', 'nightlife', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(459, 'es', 153, 141, 'All others events', 'all-others-events', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(460, 'pt', 1, 0, 'Automobiles', 'automobiles', NULL, 'fa-car.png', 'fa fa-car', 8, 9, 1, NULL, 1),
(461, 'pt', 2, 1, 'Auto Parts, Accessories', 'auto-parts-accessories', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(462, 'pt', 3, 1, 'Car, Motorcycle Rental', 'car-motorcycle-rental', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(463, 'pt', 4, 1, 'Caravan and Boating', 'caravan-and-boating', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(464, 'pt', 5, 1, 'Motorcycle parts, Accessories', 'motorcycle-parts-accessories', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(465, 'pt', 6, 1, 'Motorcycles, Scooters, Quads', 'motorcycles-scooters-quads', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(466, 'pt', 7, 1, 'Used Cars - New Cars', 'used-cars-new-cars', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(467, 'pt', 8, 1, 'Utility Vehicles, Machinery', 'utility-vehicles-machinery', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(468, 'pt', 9, 0, 'Property', 'property', NULL, 'fa-home.png', 'icon-home', 4, 5, 1, NULL, 1),
(469, 'pt', 10, 9, 'Commercial Property - Offices - Premises', 'commercial-property-offices-premises', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(470, 'pt', 11, 9, 'I''m looking for', 'im-looking-for', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(471, 'pt', 12, 9, 'Roomates', 'roomates', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(472, 'pt', 13, 9, 'Accommodation and Hotels', 'accommodation-and-hotels', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(473, 'pt', 14, 9, 'Vacation Rental', 'vacation-rental', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(474, 'pt', 15, 9, 'Garage, Parking, Farms', 'garage-parking-farms', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(475, 'pt', 16, 9, 'Real Estate Services', 'real-estate-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(476, 'pt', 17, 9, 'Rooms - Studio for Rent', 'rooms-studio-for-rent', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(477, 'pt', 18, 9, 'Land for Sale, Rent', 'land-for-sale-rent', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(478, 'pt', 19, 9, 'Property for sale', 'property-for-sale', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(479, 'pt', 20, 9, 'Rentals', 'rentals', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(480, 'pt', 21, 0, 'Services', 'services', NULL, 'ion-clipboard.png', 'fa fa-briefcase', 10, 11, 1, 'service', 1),
(481, 'pt', 22, 21, 'Other services', 'other-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(482, 'pt', 23, 21, 'Casting, Model, Photographer', 'casting-model-photographer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(483, 'pt', 24, 21, 'Carpooling', 'carpooling', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(484, 'pt', 25, 21, 'Moving, Furniture Guard', 'moving-furniture-guard', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(485, 'pt', 26, 21, 'Destocking - Commercial', 'destocking-commercial', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(486, 'pt', 27, 21, 'Industrial Equipment', 'industrial-equipment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(487, 'pt', 28, 21, 'Aesthetics, Hairstyling', 'aesthetics-hairstyling', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(488, 'pt', 29, 21, 'Horoscope - Tarot - Healers - Spell', 'horoscope-tarot-healers-spell', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(489, 'pt', 30, 21, 'Materials and Equipment Pro', 'materials-and-equipment-pro', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(490, 'pt', 31, 21, 'Event Organization Services', 'event-organization-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(491, 'pt', 32, 21, 'Service Provision', 'service-provision', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(492, 'pt', 33, 21, 'Health, Beauty', 'health-beauty', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(493, 'pt', 34, 21, 'Artisan, Troubleshooting, Handyman', 'artisan-troubleshooting-handyman', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(494, 'pt', 35, 21, 'Computing Services', 'computing-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(495, 'pt', 36, 21, 'Tourism and Travel Services', 'tourism-and-travel-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(496, 'pt', 37, 21, 'Translation, Writing', 'translation-writing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(497, 'pt', 38, 21, 'Construction - Renovation - Carpentry', 'construction-renovation-carpentry', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(498, 'pt', 39, 0, 'Community', 'community', NULL, 'fa-users.png', 'icon-theatre', 20, 21, 1, NULL, 1),
(499, 'pt', 40, 39, 'Sporting goods, Exercise', 'sporting-goods-exercise', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(500, 'pt', 41, 39, 'Artists, Musicians', 'artists-musicians', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(501, 'pt', 42, 39, 'Associations, Voluntary', 'associations-voluntary', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(502, 'pt', 43, 39, 'Friendships for Events', 'friendships-for-events', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(503, 'pt', 44, 39, 'My neighborhood', 'my-neighborhood', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(504, 'pt', 45, 39, 'Nightlife, Restaurant & Bar', 'nightlife-restaurant-bar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(505, 'pt', 46, 39, 'Outings, Entertainment', 'outings-entertainment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(506, 'pt', 47, 0, 'Multimedia', 'multimedia', NULL, 'fa-laptop.png', 'icon-laptop', 2, 3, 1, NULL, 1),
(507, 'pt', 48, 47, 'Multimedia & Phones Accessories', 'multimedia-phones-accessories', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(508, 'pt', 49, 47, 'CD/DVD - Books - Movies', 'cddvd-books-movies', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(509, 'pt', 50, 47, 'Consoles - Video Games', 'consoles-video-games', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(510, 'pt', 51, 47, 'Computers - PC - Office Supplies', 'computers-pc-office-supplies', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(511, 'pt', 52, 47, 'Wanted', 'wanted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(512, 'pt', 53, 47, 'Tablets - Touchscreens', 'tablets-touchscreens', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(513, 'pt', 54, 47, 'Mobiles phones - Smartphones', 'mobiles-phones-smartphones', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(514, 'pt', 55, 47, 'TV - Images - Sound', 'tv-images-sound', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(515, 'pt', 56, 47, 'Clearance - Commercial', 'clearance-commercial', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(516, 'pt', 57, 47, 'Industrial Equipment', 'industrial-equipment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(517, 'pt', 58, 47, 'Materials & Professional equipment', 'materials-professional-equipment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(518, 'pt', 59, 0, 'Fashion, Home & Garden', 'fashion-home-garden', NULL, 'fa-home.png', 'icon-basket-1', 6, 7, 1, NULL, 1),
(519, 'pt', 60, 59, 'Furniture - Tableware', 'furniture-tableware', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(520, 'pt', 61, 59, 'Antiques - Art - Decoration', 'antiques-art-decoration', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(521, 'pt', 62, 59, 'Appliances', 'appliances', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(522, 'pt', 63, 59, 'Jewelry - Watches - Luggage', 'jewelry-watches-luggage', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(523, 'pt', 64, 59, 'DIY - Gardening', 'diy-gardening', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(524, 'pt', 65, 59, 'Various flea markets', 'various-flea-markets', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(525, 'pt', 66, 59, 'Shoes', 'shoes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(526, 'pt', 67, 59, 'Toys - Games - Figurines', 'toys-games-figurines', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(527, 'pt', 68, 59, 'Clothing, Fashion & Accessories', 'clothing-fashion-accessories', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(528, 'pt', 69, 59, 'Stuffs for Baby and Child', 'stuffs-for-baby-and-child', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(529, 'pt', 70, 59, 'Stuffs for Beauty and Health', 'stuffs-for-beauty-and-health', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(530, 'pt', 71, 59, 'Wine & Gourmet - Recipes', 'wine-gourmet-recipes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(531, 'pt', 72, 0, 'Pets & Mascots', 'pets-mascots', NULL, 'map-icon-pet-store.png', 'icon-guidedog', 22, 23, 1, NULL, 1),
(532, 'pt', 73, 72, 'Accessories - Other Pets services', 'accessories-other-pets-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(533, 'pt', 74, 72, 'Sales, Adoptions, Lost', 'sales-adoptions-lost', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(534, 'pt', 75, 0, 'Free Dating', 'free-dating', NULL, 'ion-ios-heart.png', 'icon-heart', 24, 25, 1, NULL, 1),
(535, 'pt', 76, 75, 'Friendship - Friends', 'friendship-friends', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(536, 'pt', 77, 75, 'Escorts - Adult Services', 'escorts-adult-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(537, 'pt', 78, 75, 'Women Seeking Women', 'women-seeking-women', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(538, 'pt', 79, 75, 'Women Seeking Men', 'women-seeking-men', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(539, 'pt', 80, 75, 'Men Seeking Women', 'men-seeking-women', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(540, 'pt', 81, 75, 'Men Seeking Men', 'men-seeking-men', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(541, 'pt', 82, 75, 'Massage Services - Relaxation', 'massage-services-relaxation', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(542, 'pt', 83, 75, 'Adults Products - Articles', 'adults-products-articles', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(543, 'pt', 84, 75, 'Casual Encounter', 'casual-encounter', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(544, 'pt', 85, 0, 'Jobs Offers', 'jobs-offers', NULL, 'mfglabs-users.png', 'icon-megaphone-1', 14, 15, 1, 'job-offer', 1),
(545, 'pt', 86, 85, 'Agriculture - Environment', 'agriculture-environment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(546, 'pt', 87, 85, 'Assistantship - Secretariat - Helpdesk', 'assistantship-secretariat-helpdesk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(547, 'pt', 88, 85, 'Automotive - Mechanic', 'automotive-mechanic', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(548, 'pt', 89, 85, 'Others Jobs Offer', 'others-jobs-offer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(549, 'pt', 90, 85, 'BTP - Construction - Building', 'btp-construction-building', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(550, 'pt', 91, 85, 'Trade - Business Services', 'trade-business-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(551, 'pt', 92, 85, 'Commercial - Sale Jobs Offer', 'commercial-sale-jobs-offer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(552, 'pt', 93, 85, 'Accounting - Management - Finance', 'accounting-management-finance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(553, 'pt', 94, 85, 'Steering - Manager', 'steering-manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(554, 'pt', 95, 85, 'Aesthetics - Hair - Beauty', 'aesthetics-hair-beauty', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(555, 'pt', 96, 85, 'Public Service Jobs Offer', 'public-service-jobs-offer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(556, 'pt', 97, 85, 'Real Estate Jobs Offer', 'real-estate-jobs-offer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(557, 'pt', 98, 85, 'Independent - Freelance - Telecommuting', 'independent-freelance-telecommuting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(558, 'pt', 99, 85, 'Computers - Internet - Telecommunications', 'computers-internet-telecommunications', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(559, 'pt', 100, 85, 'Industry, Production & engineering', 'industry-production-engineering', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(560, 'pt', 101, 85, 'Marketing - Communication', 'marketing-communication', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(561, 'pt', 102, 85, 'Babysitting - Nanny Work', 'babysitting-nanny-work', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(562, 'pt', 103, 85, 'HR - Training - Education', 'hr-training-education', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(563, 'pt', 104, 85, 'Medical - Healthcare - Social', 'medical-healthcare-social', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(564, 'pt', 105, 85, 'Security - Guarding', 'security-guarding', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(565, 'pt', 106, 85, 'Household Services - Housekeeping', 'household-services-housekeeping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(566, 'pt', 107, 85, 'Tourism - Hotels - Restaurants - Leisure', 'tourism-hotels-restaurants-leisure', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(567, 'pt', 108, 85, 'Transportation - Logistics', 'transportation-logistics', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(568, 'pt', 109, 0, 'Job Search', 'job-search', NULL, 'fa-search.png', 'icon-search', 12, 13, 1, 'job-search', 1),
(569, 'pt', 110, 109, 'Agriculture - Environment', 'agriculture-environment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(570, 'pt', 111, 109, 'Assistantship - Secretariat - Helpdesk', 'assistantship-secretariat-helpdesk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(571, 'pt', 112, 109, 'Automotive - Mechanic', 'automotive-mechanic', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(572, 'pt', 113, 109, 'Others Jobs Search', 'others-jobs-search', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(573, 'pt', 114, 109, 'BTP - Construction - Building', 'btp-construction-building', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(574, 'pt', 115, 109, 'Trade - Business Services', 'trade-business-services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(575, 'pt', 116, 109, 'Commercial - Sale Jobs Search', 'commercial-sale-jobs-search', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(576, 'pt', 117, 109, 'Accounting - Management - Finance', 'accounting-management-finance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(577, 'pt', 118, 109, 'Steering - Manager', 'steering-manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(578, 'pt', 119, 109, 'Aesthetics - Hair - Beauty', 'aesthetics-hair-beauty', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(579, 'pt', 120, 109, 'Public Service Jobs Search', 'public-service-jobs-search', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(580, 'pt', 121, 109, 'Real Estate Jobs Search', 'real-estate-jobs-search', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(581, 'pt', 122, 109, 'Independent - Freelance - Telecommuting', 'independent-freelance-telecommuting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(582, 'pt', 123, 109, 'Computers - Internet - Telecommunications', 'computers-internet-telecommunications', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(583, 'pt', 124, 109, 'Industry, Production & engineering', 'industry-production-engineering', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(584, 'pt', 125, 109, 'Marketing - Communication', 'marketing-communication', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(585, 'pt', 126, 109, 'Babysitting - Nanny Work', 'babysitting-nanny-work', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(586, 'pt', 127, 109, 'HR - Training - Education', 'hr-training-education', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(587, 'pt', 128, 109, 'Medical - Healthcare - Social', 'medical-healthcare-social', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(588, 'pt', 129, 109, 'Security - Guarding', 'security-guarding', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(589, 'pt', 130, 109, 'Household Services - Housekeeping', 'household-services-housekeeping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(590, 'pt', 131, 109, 'Tourism - Hotels - Restaurants - Leisure', 'tourism-hotels-restaurants-leisure', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(591, 'pt', 132, 109, 'Transportation - Logistics', 'transportation-logistics', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(592, 'pt', 133, 0, 'Learning', 'learning', NULL, 'fa-graduation-cap.png', 'icon-book-open', 18, 19, 1, NULL, 1),
(593, 'pt', 134, 133, 'Language Classes', 'language-classes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(594, 'pt', 135, 133, 'Computer Courses', 'computer-courses', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(595, 'pt', 136, 133, 'Tutoring, Private Lessons', 'tutoring-private-lessons', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(596, 'pt', 137, 133, 'Vocational Training', 'vocational-training', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(597, 'pt', 138, 133, 'Maths, Physics, Chemistry', 'maths-physics-chemistry', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(598, 'pt', 139, 133, 'Music, Theatre, Dance', 'music-theatre-dance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(599, 'pt', 140, 133, 'School support', 'school-support', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(600, 'pt', 141, 0, 'Local Events', 'local-events', NULL, 'fa-calendar.png', 'icon-megaphone-1', 16, 17, 1, NULL, 1),
(601, 'pt', 142, 141, 'Concerts & Festivals', 'concerts-festivals', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(602, 'pt', 143, 141, 'Networking & Meetups', 'networking-meetups', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(603, 'pt', 144, 141, 'Sports & Outdoors', 'sports-outdoors', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(604, 'pt', 145, 141, 'Trade Shows & Conventions', 'trade-shows-conventions', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(605, 'pt', 146, 141, 'Training & Seminars', 'training-seminars', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(606, 'pt', 147, 141, 'Ceremonies', 'ceremonies', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(607, 'pt', 148, 141, 'Conferences', 'conferences', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(608, 'pt', 149, 141, 'Weddings', 'weddings', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(609, 'pt', 150, 141, 'Birthdays', 'birthdays', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(610, 'pt', 151, 141, 'Family Events', 'family-events', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(611, 'pt', 152, 141, 'Nightlife', 'nightlife', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(612, 'pt', 153, 141, 'All others events', 'all-others-events', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1);

--
-- Truncate table before insert `continents`
--

TRUNCATE TABLE `continents`;
--
-- Dumping data for table `continents`
--

INSERT INTO `continents` (`id`, `code`, `name`, `active`) VALUES
(1, 'AF', 'Africa', 1),
(2, 'AN', 'Antarctica', 1),
(3, 'AS', 'Asia', 1),
(4, 'EU', 'Europe', 1),
(5, 'NA', 'North America', 1),
(6, 'OC', 'Oceania', 1),
(7, 'SA', 'South America', 1);

--
-- Truncate table before insert `countries`
--

TRUNCATE TABLE `countries`;
--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `code`, `iso3`, `iso_numeric`, `fips`, `name`, `asciiname`, `capital`, `area`, `population`, `continent_code`, `tld`, `currency_code`, `phone`, `postal_code_format`, `postal_code_regex`, `languages`, `neighbours`, `equivalent_fips_code`, `active`, `created_at`, `updated_at`) VALUES
(1, 'AD', 'AND', 20, 'AN', 'Andorra', 'Andorra', 'Andorra la Vella', 468, 84000, 'EU', '.ad', 'EUR', '376', 'AD###', '^(?:AD)*(d{3})$', 'ca', 'ES,FR', '', 1, NULL, '2016-05-26 00:27:06'),
(2, 'AE', 'ARE', 784, 'AE', 'al-ImÄrÄt', 'United Arab Emirates', 'Abu Dhabi', 82880, 4975593, 'AS', '.ae', 'AED', '971', '', '', 'ar-AE,fa,en,hi,ur', 'SA,OM', '', 1, NULL, NULL),
(3, 'AF', 'AFG', 4, 'AF', 'AfġÄnistÄn', 'Afghanistan', 'Kabul', 647500, 29121286, 'AS', '.af', 'AFN', '93', '', '', 'fa-AF,ps,uz-AF,tk', 'TM,CN,IR,TJ,PK,UZ', '', 1, NULL, NULL),
(4, 'AG', 'ATG', 28, 'AC', 'Antigua and Barbuda', 'Antigua and Barbuda', 'St. John''s', 443, 86754, 'NA', '.ag', 'XCD', '+1-268', '', '', 'en-AG', '', '', 1, NULL, NULL),
(5, 'AI', 'AIA', 660, 'AV', 'Anguilla', 'Anguilla', 'The Valley', 102, 13254, 'NA', '.ai', 'XCD', '+1-264', '', '', 'en-AI', '', '', 1, NULL, NULL),
(6, 'AL', 'ALB', 8, 'AL', 'Shqipëria', 'Albania', 'Tirana', 28748, 2986952, 'EU', '.al', 'ALL', '355', '', '', 'sq,el', 'MK,GR,ME,RS,XK', '', 1, NULL, NULL),
(7, 'AM', 'ARM', 51, 'AM', 'Hayastan', 'Armenia', 'Yerevan', 29800, 2968000, 'AS', '.am', 'AMD', '374', '######', '^(d{6})$', 'hy', 'GE,IR,AZ,TR', '', 1, NULL, NULL),
(8, 'AN', 'ANT', 530, 'NT', 'Netherlands Antilles', 'Netherlands Antilles', 'Willemstad', 960, 136197, 'NA', '.an', 'ANG', '599', '', '', 'nl-AN,en,es', 'GP', '', 0, NULL, NULL),
(9, 'AO', 'AGO', 24, 'AO', 'Angola', 'Angola', 'Luanda', 1246700, 13068161, 'AF', '.ao', 'AOA', '244', '', '', 'pt-AO', 'CD,NA,ZM,CG', '', 1, NULL, NULL),
(10, 'AQ', 'ATA', 10, 'AY', 'Antarctica', 'Antarctica', '', 14000000, 0, 'AN', '.aq', '', '', '', '', '', '', '', 0, NULL, NULL),
(11, 'AR', 'ARG', 32, 'AR', 'Argentina', 'Argentina', 'Buenos Aires', 2766890, 41343201, 'SA', '.ar', 'ARS', '54', '@####@@@', '^([A-Z]d{4}[A-Z]{3})$', 'es-AR,en,it,de,fr,gn', 'CL,BO,UY,PY,BR', '', 1, NULL, NULL),
(12, 'AS', 'ASM', 16, 'AQ', 'American Samoa', 'American Samoa', 'Pago Pago', 199, 57881, 'OC', '.as', 'USD', '+1-684', '', '', 'en-AS,sm,to', '', '', 1, NULL, NULL),
(13, 'AT', 'AUT', 40, 'AU', 'Österreich', 'Austria', 'Vienna', 83858, 8205000, 'EU', '.at', 'EUR', '43', '####', '^(d{4})$', 'de-AT,hr,hu,sl', 'CH,DE,HU,SK,CZ,IT,SI,LI', '', 1, NULL, NULL),
(14, 'AU', 'AUS', 36, 'AS', 'Australia', 'Australia', 'Canberra', 7686850, 21515754, 'OC', '.au', 'AUD', '61', '####', '^(d{4})$', 'en-AU', '', '', 1, NULL, NULL),
(15, 'AW', 'ABW', 533, 'AA', 'Aruba', 'Aruba', 'Oranjestad', 193, 71566, 'NA', '.aw', 'AWG', '297', '', '', 'nl-AW,es,en', '', '', 1, NULL, NULL),
(16, 'AX', 'ALA', 248, '', 'Aland Islands', 'Aland Islands', 'Mariehamn', 1580, 26711, 'EU', '.ax', 'EUR', '+358-18', '#####', '^(?:FI)*(d{5})$', 'sv-AX', '', 'FI', 0, NULL, NULL),
(17, 'AZ', 'AZE', 31, 'AJ', 'Azərbaycan', 'Azerbaijan', 'Baku', 86600, 8303512, 'AS', '.az', 'AZN', '994', 'AZ ####', '^(?:AZ)*(d{4})$', 'az,ru,hy', 'GE,IR,AM,TR,RU', '', 1, NULL, NULL),
(18, 'BA', 'BIH', 70, 'BK', 'Bosna i Hercegovina', 'Bosnia and Herzegovina', 'Sarajevo', 51129, 4590000, 'EU', '.ba', 'BAM', '387', '#####', '^(d{5})$', 'bs,hr-BA,sr-BA', 'HR,ME,RS', '', 1, NULL, NULL),
(19, 'BB', 'BRB', 52, 'BB', 'Barbados', 'Barbados', 'Bridgetown', 431, 285653, 'NA', '.bb', 'BBD', '+1-246', 'BB#####', '^(?:BB)*(d{5})$', 'en-BB', '', '', 1, NULL, NULL),
(20, 'BD', 'BGD', 50, 'BG', 'BāṅlādēsÌ', 'Bangladesh', 'Dhaka', 144000, 156118464, 'AS', '.bd', 'BDT', '880', '####', '^(d{4})$', 'bn-BD,en', 'MM,IN', '', 1, NULL, NULL),
(21, 'BE', 'BEL', 56, 'BE', 'Belgique', 'Belgium', 'Brussels', 30510, 10403000, 'EU', '.be', 'EUR', '32', '####', '^(d{4})$', 'nl-BE,fr-BE,de-BE', 'DE,NL,LU,FR', '', 1, NULL, NULL),
(22, 'BF', 'BFA', 854, 'UV', 'Burkina Faso', 'Burkina Faso', 'Ouagadougou', 274200, 16241811, 'AF', '.bf', 'XOF', '226', '', '', 'fr-BF', 'NE,BJ,GH,CI,TG,ML', '', 1, NULL, NULL),
(23, 'BG', 'BGR', 100, 'BU', 'Bŭlgarija', 'Bulgaria', 'Sofia', 110910, 7148785, 'EU', '.bg', 'BGN', '359', '####', '^(d{4})$', 'bg,tr-BG,rom', 'MK,GR,RO,TR,RS', '', 1, NULL, NULL),
(24, 'BH', 'BHR', 48, 'BA', 'al-Baḥrayn', 'Bahrain', 'Manama', 665, 738004, 'AS', '.bh', 'BHD', '973', '####|###', '^(d{3}d?)$', 'ar-BH,en,fa,ur', '', '', 1, NULL, NULL),
(25, 'BI', 'BDI', 108, 'BY', 'Burundi', 'Burundi', 'Bujumbura', 27830, 9863117, 'AF', '.bi', 'BIF', '257', '', '', 'fr-BI,rn', 'TZ,CD,RW', '', 1, NULL, NULL),
(26, 'BJ', 'BEN', 204, 'BN', 'Bénin', 'Benin', 'Porto-Novo', 112620, 9056010, 'AF', '.bj', 'XOF', '229', '', '', 'fr-BJ', 'NE,TG,BF,NG', '', 1, NULL, NULL),
(27, 'BL', 'BLM', 652, 'TB', 'Saint Barthelemy', 'Saint Barthelemy', 'Gustavia', 21, 8450, 'NA', '.gp', 'EUR', '590', '### ###', '', 'fr', '', '', 0, NULL, NULL),
(28, 'BM', 'BMU', 60, 'BD', 'Bermuda', 'Bermuda', 'Hamilton', 53, 65365, 'NA', '.bm', 'BMD', '+1-441', '@@ ##', '^([A-Z]{2}d{2})$', 'en-BM,pt', '', '', 1, NULL, NULL),
(29, 'BN', 'BRN', 96, 'BX', 'Brunei Darussalam', 'Brunei', 'Bandar Seri Begawan', 5770, 395027, 'AS', '.bn', 'BND', '673', '@@####', '^([A-Z]{2}d{4})$', 'ms-BN,en-BN', 'MY', '', 1, NULL, NULL),
(30, 'BO', 'BOL', 68, 'BL', 'Bolivia', 'Bolivia', 'Sucre', 1098580, 9947418, 'SA', '.bo', 'BOB', '591', '', '', 'es-BO,qu,ay', 'PE,CL,PY,BR,AR', '', 1, NULL, NULL),
(31, 'BQ', 'BES', 535, '', 'Bonaire, Saint Eustatius and Saba ', 'Bonaire, Saint Eustatius and Saba ', '', 328, 18012, 'NA', '.bq', 'USD', '599', '', '', 'nl,pap,en', '', '', 0, NULL, NULL),
(32, 'BR', 'BRA', 76, 'BR', 'Brasil', 'Brazil', 'Brasilia', 8511965, 201103330, 'SA', '.br', 'BRL', '55', '#####-###', '^(d{8})$', 'pt-BR,es,en,fr', 'SR,PE,BO,UY,GY,PY,GF,VE,CO,AR', '', 1, NULL, NULL),
(33, 'BS', 'BHS', 44, 'BF', 'Bahamas', 'Bahamas', 'Nassau', 13940, 301790, 'NA', '.bs', 'BSD', '+1-242', '', '', 'en-BS', '', '', 1, NULL, NULL),
(34, 'BT', 'BTN', 64, 'BT', 'Druk-yul', 'Bhutan', 'Thimphu', 47000, 699847, 'AS', '.bt', 'BTN', '975', '', '', 'dz', 'CN,IN', '', 1, NULL, NULL),
(35, 'BV', 'BVT', 74, 'BV', 'Bouvet Island', 'Bouvet Island', '', 49, 0, 'AN', '.bv', 'NOK', '', '', '', '', '', '', 0, NULL, NULL),
(36, 'BW', 'BWA', 72, 'BC', 'Botswana', 'Botswana', 'Gaborone', 600370, 2029307, 'AF', '.bw', 'BWP', '267', '', '', 'en-BW,tn-BW', 'ZW,ZA,NA', '', 1, NULL, NULL),
(37, 'BY', 'BLR', 112, 'BO', 'Biełaruś', 'Belarus', 'Minsk', 207600, 9685000, 'EU', '.by', 'BYR', '375', '######', '^(d{6})$', 'be,ru', 'PL,LT,UA,RU,LV', '', 1, NULL, NULL),
(38, 'BZ', 'BLZ', 84, 'BH', 'Belize', 'Belize', 'Belmopan', 22966, 314522, 'NA', '.bz', 'BZD', '501', '', '', 'en-BZ,es', 'GT,MX', '', 1, NULL, NULL),
(39, 'CA', 'CAN', 124, 'CA', 'Canada', 'Canada', 'Ottawa', 9984670, 33679000, 'NA', '.ca', 'CAD', '1', '@#@ #@#', '^([ABCEGHJKLMNPRSTVXY]d[ABCEGHJKLMNPRSTVWXYZ]) ?(d[ABCEGHJKLMNPRSTVWXYZ]d)$ ', 'en-CA,fr-CA,iu', 'US', '', 1, NULL, NULL),
(40, 'CC', 'CCK', 166, 'CK', 'Cocos Islands', 'Cocos Islands', 'West Island', 14, 628, 'AS', '.cc', 'AUD', '61', '', '', 'ms-CC,en', '', '', 0, NULL, NULL),
(41, 'CD', 'COD', 180, 'CG', 'RDC', 'Democratic Republic of the Congo', 'Kinshasa', 2345410, 70916439, 'AF', '.cd', 'CDF', '243', '', '', 'fr-CD,ln,kg', 'TZ,CF,SS,RW,ZM,BI,UG,CG,AO', '', 1, NULL, NULL),
(42, 'CF', 'CAF', 140, 'CT', 'Centrafrique', 'Central African Republic', 'Bangui', 622984, 4844927, 'AF', '.cf', 'XAF', '236', '', '', 'fr-CF,sg,ln,kg', 'TD,SD,CD,SS,CM,CG', '', 1, NULL, NULL),
(43, 'CG', 'COG', 178, 'CF', 'Congo', 'Republic of the Congo', 'Brazzaville', 342000, 3039126, 'AF', '.cg', 'XAF', '242', '', '', 'fr-CG,kg,ln-CG', 'CF,GA,CD,CM,AO', '', 1, NULL, NULL),
(44, 'CH', 'CHE', 756, 'SZ', 'Switzerland', 'Switzerland', 'Berne', 41290, 7581000, 'EU', '.ch', 'CHF', '41', '####', '^(d{4})$', 'de-CH,fr-CH,it-CH,rm', 'DE,IT,LI,FR,AT', '', 1, NULL, NULL),
(45, 'CI', 'CIV', 384, 'IV', 'Côte d''Ivoire', 'Ivory Coast', 'Yamoussoukro', 322460, 21058798, 'AF', '.ci', 'XOF', '225', '', '', 'fr-CI', 'LR,GH,GN,BF,ML', '', 1, NULL, NULL),
(46, 'CK', 'COK', 184, 'CW', 'Cook Islands', 'Cook Islands', 'Avarua', 240, 21388, 'OC', '.ck', 'NZD', '682', '', '', 'en-CK,mi', '', '', 1, NULL, NULL),
(47, 'CL', 'CHL', 152, 'CI', 'Chile', 'Chile', 'Santiago', 756950, 16746491, 'SA', '.cl', 'CLP', '56', '#######', '^(d{7})$', 'es-CL', 'PE,BO,AR', '', 1, NULL, NULL),
(48, 'CM', 'CMR', 120, 'CM', 'Cameroun', 'Cameroon', 'Yaounde', 475440, 19294149, 'AF', '.cm', 'XAF', '237', '', '', 'fr-CM,en-CM', 'TD,CF,GA,GQ,CG,NG', '', 1, NULL, NULL),
(49, 'CN', 'CHN', 156, 'CH', 'ZhÅngguó', 'China', 'Beijing', 9596960, 1330044000, 'AS', '.cn', 'CNY', '86', '######', '^(d{6})$', 'zh-CN,yue,wuu,dta,ug,za', 'LA,BT,TJ,KZ,MN,AF,NP,MM,KG,PK,KP,RU,VN,IN', '', 1, NULL, NULL),
(50, 'CO', 'COL', 170, 'CO', 'Colombia', 'Colombia', 'Bogota', 1138910, 47790000, 'SA', '.co', 'COP', '57', '', '', 'es-CO', 'EC,PE,PA,BR,VE', '', 1, NULL, NULL),
(51, 'CR', 'CRI', 188, 'CS', 'Costa Rica', 'Costa Rica', 'San Jose', 51100, 4516220, 'NA', '.cr', 'CRC', '506', '####', '^(d{4})$', 'es-CR,en', 'PA,NI', '', 1, NULL, NULL),
(52, 'CS', 'SCG', 891, 'YI', 'Serbia and Montenegro', 'Serbia and Montenegro', 'Belgrade', 102350, 10829175, 'EU', '.cs', 'RSD', '381', '#####', '^(d{5})$', 'cu,hu,sq,sr', 'AL,HU,MK,RO,HR,BA,BG', '', 0, NULL, NULL),
(53, 'CU', 'CUB', 192, 'CU', 'Cuba', 'Cuba', 'Havana', 110860, 11423000, 'NA', '.cu', 'CUP', '53', 'CP #####', '^(?:CP)*(d{5})$', 'es-CU', 'US', '', 1, NULL, NULL),
(54, 'CV', 'CPV', 132, 'CV', 'Cabo Verde', 'Cape Verde', 'Praia', 4033, 508659, 'AF', '.cv', 'CVE', '238', '####', '^(d{4})$', 'pt-CV', '', '', 1, NULL, NULL),
(55, 'CW', 'CUW', 531, 'UC', 'Curacao', 'Curacao', ' Willemstad', 444, 141766, 'NA', '.cw', 'ANG', '599', '', '', 'nl,pap', '', '', 0, NULL, NULL),
(56, 'CX', 'CXR', 162, 'KT', 'Christmas Island', 'Christmas Island', 'Flying Fish Cove', 135, 1500, 'AS', '.cx', 'AUD', '61', '####', '^(d{4})$', 'en,zh,ms-CC', '', '', 0, NULL, NULL),
(57, 'CY', 'CYP', 196, 'CY', 'Kýpros (Kıbrıs)', 'Cyprus', 'Nicosia', 9250, 1102677, 'EU', '.cy', 'EUR', '357', '####', '^(d{4})$', 'el-CY,tr-CY,en', '', '', 1, NULL, NULL),
(58, 'CZ', 'CZE', 203, 'EZ', 'Česko', 'Czech Republic', 'Prague', 78866, 10476000, 'EU', '.cz', 'CZK', '420', '### ##', '^(d{5})$', 'cs,sk', 'PL,DE,SK,AT', '', 1, NULL, NULL),
(59, 'DE', 'DEU', 276, 'GM', 'Deutschland', 'Germany', 'Berlin', 357021, 81802257, 'EU', '.de', 'EUR', '49', '#####', '^(d{5})$', 'de', 'CH,PL,NL,DK,BE,CZ,LU,FR,AT', '', 1, NULL, NULL),
(60, 'DJ', 'DJI', 262, 'DJ', 'Djibouti', 'Djibouti', 'Djibouti', 23000, 740528, 'AF', '.dj', 'DJF', '253', '', '', 'fr-DJ,ar,so-DJ,aa', 'ER,ET,SO', '', 1, NULL, NULL),
(61, 'DK', 'DNK', 208, 'DA', 'Danmark', 'Denmark', 'Copenhagen', 43094, 5484000, 'EU', '.dk', 'DKK', '45', '####', '^(d{4})$', 'da-DK,en,fo,de-DK', 'DE', '', 1, NULL, NULL),
(62, 'DM', 'DMA', 212, 'DO', 'Dominica', 'Dominica', 'Roseau', 754, 72813, 'NA', '.dm', 'XCD', '+1-767', '', '', 'en-DM', '', '', 1, NULL, NULL),
(63, 'DO', 'DOM', 214, 'DR', 'República Dominicana', 'Dominican Republic', 'Santo Domingo', 48730, 9823821, 'NA', '.do', 'DOP', '+1-809 and', '#####', '^(d{5})$', 'es-DO', 'HT', '', 1, NULL, NULL),
(64, 'DZ', 'DZA', 12, 'AG', 'Algérie', 'Algeria', 'Algiers', 2381740, 34586184, 'AF', '.dz', 'DZD', '213', '#####', '^(d{5})$', 'ar-DZ,fr', 'NE,EH,LY,MR,TN,MA,ML', '', 1, NULL, NULL),
(65, 'EC', 'ECU', 218, 'EC', 'Ecuador', 'Ecuador', 'Quito', 283560, 14790608, 'SA', '.ec', 'USD', '593', '@####@', '^([a-zA-Z]d{4}[a-zA-Z])$', 'es-EC', 'PE,CO', '', 1, NULL, NULL),
(66, 'EE', 'EST', 233, 'EN', 'Eesti', 'Estonia', 'Tallinn', 45226, 1291170, 'EU', '.ee', 'EUR', '372', '#####', '^(d{5})$', 'et,ru', 'RU,LV', '', 1, NULL, NULL),
(67, 'EG', 'EGY', 818, 'EG', 'Egypt', 'Egypt', 'Cairo', 1001450, 80471869, 'AF', '.eg', 'EGP', '20', '#####', '^(d{5})$', 'ar-EG,en,fr', 'LY,SD,IL,PS', '', 1, NULL, NULL),
(68, 'EH', 'ESH', 732, 'WI', 'aṣ-ṢaḥrÄwīyâ al-ʿArabīyâ', 'Western Sahara', 'El-Aaiun', 266000, 273008, 'AF', '.eh', 'MAD', '212', '', '', 'ar,mey', 'DZ,MR,MA', '', 1, NULL, NULL),
(69, 'ER', 'ERI', 232, 'ER', 'ErtrÄ', 'Eritrea', 'Asmara', 121320, 5792984, 'AF', '.er', 'ERN', '291', '', '', 'aa-ER,ar,tig,kun,ti-ER', 'ET,SD,DJ', '', 1, NULL, NULL),
(70, 'ES', 'ESP', 724, 'SP', 'España', 'Spain', 'Madrid', 504782, 46505963, 'EU', '.es', 'EUR', '34', '#####', '^(d{5})$', 'es-ES,ca,gl,eu,oc', 'AD,PT,GI,FR,MA', '', 1, NULL, NULL),
(71, 'ET', 'ETH', 231, 'ET', 'Ityoṗya', 'Ethiopia', 'Addis Ababa', 1127127, 88013491, 'AF', '.et', 'ETB', '251', '####', '^(d{4})$', 'am,en-ET,om-ET,ti-ET,so-ET,sid', 'ER,KE,SD,SS,SO,DJ', '', 1, NULL, NULL),
(72, 'FI', 'FIN', 246, 'FI', 'Suomi (Finland)', 'Finland', 'Helsinki', 337030, 5244000, 'EU', '.fi', 'EUR', '358', '#####', '^(?:FI)*(d{5})$', 'fi-FI,sv-FI,smn', 'NO,RU,SE', '', 1, NULL, NULL),
(73, 'FJ', 'FJI', 242, 'FJ', 'Viti', 'Fiji', 'Suva', 18270, 875983, 'OC', '.fj', 'FJD', '679', '', '', 'en-FJ,fj', '', '', 1, NULL, NULL),
(74, 'FK', 'FLK', 238, 'FK', 'Falkland Islands', 'Falkland Islands', 'Stanley', 12173, 2638, 'SA', '.fk', 'FKP', '500', '', '', 'en-FK', '', '', 0, NULL, NULL),
(75, 'FM', 'FSM', 583, 'FM', 'Micronesia', 'Micronesia', 'Palikir', 702, 107708, 'OC', '.fm', 'USD', '691', '#####', '^(d{5})$', 'en-FM,chk,pon,yap,kos,uli,woe,nkr,kpg', '', '', 1, NULL, NULL),
(76, 'FO', 'FRO', 234, 'FO', 'Føroyar', 'Faroe Islands', 'Torshavn', 1399, 48228, 'EU', '.fo', 'DKK', '298', 'FO-###', '^(?:FO)*(d{3})$', 'fo,da-FO', '', '', 1, NULL, NULL),
(77, 'FR', 'FRA', 250, 'FR', 'France', 'France', 'Paris', 547030, 64768389, 'EU', '.fr', 'EUR', '33', '#####', '^(d{5})$', 'fr-FR,frp,br,co,ca,eu,oc', 'CH,DE,BE,LU,IT,AD,MC,ES', '', 1, NULL, NULL),
(78, 'GA', 'GAB', 266, 'GB', 'Gabon', 'Gabon', 'Libreville', 267667, 1545255, 'AF', '.ga', 'XAF', '241', '', '', 'fr-GA', 'CM,GQ,CG', '', 1, NULL, NULL),
(79, 'GD', 'GRD', 308, 'GJ', 'Grenada', 'Grenada', 'St. George''s', 344, 107818, 'NA', '.gd', 'XCD', '+1-473', '', '', 'en-GD', '', '', 1, NULL, NULL),
(80, 'GE', 'GEO', 268, 'GG', 'Sak''art''velo', 'Georgia', 'Tbilisi', 69700, 4630000, 'AS', '.ge', 'GEL', '995', '####', '^(d{4})$', 'ka,ru,hy,az', 'AM,AZ,TR,RU', '', 1, NULL, NULL),
(81, 'GF', 'GUF', 254, 'FG', 'Guyane', 'French Guiana', 'Cayenne', 91000, 195506, 'SA', '.gf', 'EUR', '594', '#####', '^((97|98)3d{2})$', 'fr-GF', 'SR,BR', '', 0, NULL, NULL),
(82, 'GG', 'GGY', 831, 'GK', 'Guernsey', 'Guernsey', 'St Peter Port', 78, 65228, 'EU', '.gg', 'GBP', '+44-1481', '@# #@@|@## #@@|@@# #@@|@@## #@@|@#@ #@@|@@#@ #@@|G', '^(([A-Z]d{2}[A-Z]{2})|([A-Z]d{3}[A-Z]{2})|([A-Z]{2}d{2}[A-Z]{2})|([A-Z]{2}d{3}[A-Z]{2})|([A-Z]d[A-Z]d[A-Z]{2})|([A-Z]{2}d[A-Z]d[A-Z]{2})|(GIR0AA))$', 'en,fr', '', '', 1, NULL, NULL),
(83, 'GH', 'GHA', 288, 'GH', 'Ghana', 'Ghana', 'Accra', 239460, 24339838, 'AF', '.gh', 'GHS', '233', '', '', 'en-GH,ak,ee,tw', 'CI,TG,BF', '', 1, NULL, NULL),
(84, 'GI', 'GIB', 292, 'GI', 'Gibraltar', 'Gibraltar', 'Gibraltar', 7, 27884, 'EU', '.gi', 'GIP', '350', '', '', 'en-GI,es,it,pt', 'ES', '', 1, NULL, NULL),
(85, 'GL', 'GRL', 304, 'GL', 'Grønland', 'Greenland', 'Nuuk', 2166086, 56375, 'NA', '.gl', 'DKK', '299', '####', '^(d{4})$', 'kl,da-GL,en', '', '', 1, NULL, NULL),
(86, 'GM', 'GMB', 270, 'GA', 'Gambia', 'Gambia', 'Banjul', 11300, 1593256, 'AF', '.gm', 'GMD', '220', '', '', 'en-GM,mnk,wof,wo,ff', 'SN', '', 1, NULL, NULL),
(87, 'GN', 'GIN', 324, 'GV', 'Guinée', 'Guinea', 'Conakry', 245857, 10324025, 'AF', '.gn', 'GNF', '224', '', '', 'fr-GN', 'LR,SN,SL,CI,GW,ML', '', 1, NULL, NULL),
(88, 'GP', 'GLP', 312, 'GP', 'Guadeloupe', 'Guadeloupe', 'Basse-Terre', 1780, 443000, 'NA', '.gp', 'EUR', '590', '#####', '^((97|98)d{3})$', 'fr-GP', '', '', 1, NULL, NULL),
(89, 'GQ', 'GNQ', 226, 'EK', 'Guinée Equatoriale', 'Equatorial Guinea', 'Malabo', 28051, 1014999, 'AF', '.gq', 'XAF', '240', '', '', 'es-GQ,fr', 'GA,CM', '', 1, NULL, NULL),
(90, 'GR', 'GRC', 300, 'GR', 'Elláda', 'Greece', 'Athens', 131940, 11000000, 'EU', '.gr', 'EUR', '30', '### ##', '^(d{5})$', 'el-GR,en,fr', 'AL,MK,TR,BG', '', 1, NULL, NULL),
(91, 'GS', 'SGS', 239, 'SX', 'South Georgia and the South Sandwich Islands', 'South Georgia and the South Sandwich Islands', 'Grytviken', 3903, 30, 'AN', '.gs', 'GBP', '', '', '', 'en', '', '', 0, NULL, NULL),
(92, 'GT', 'GTM', 320, 'GT', 'Guatemala', 'Guatemala', 'Guatemala City', 108890, 13550440, 'NA', '.gt', 'GTQ', '502', '#####', '^(d{5})$', 'es-GT', 'MX,HN,BZ,SV', '', 1, NULL, NULL),
(93, 'GU', 'GUM', 316, 'GQ', 'Guam', 'Guam', 'Hagatna', 549, 159358, 'OC', '.gu', 'USD', '+1-671', '969##', '^(969d{2})$', 'en-GU,ch-GU', '', '', 1, NULL, NULL),
(94, 'GW', 'GNB', 624, 'PU', 'Guiné-Bissau', 'Guinea-Bissau', 'Bissau', 36120, 1565126, 'AF', '.gw', 'XOF', '245', '####', '^(d{4})$', 'pt-GW,pov', 'SN,GN', '', 1, NULL, NULL),
(95, 'GY', 'GUY', 328, 'GY', 'Guyana', 'Guyana', 'Georgetown', 214970, 748486, 'SA', '.gy', 'GYD', '592', '', '', 'en-GY', 'SR,BR,VE', '', 1, NULL, NULL),
(96, 'HK', 'HKG', 344, 'HK', 'Hèunggóng', 'Hong Kong', 'Hong Kong', 1092, 6898686, 'AS', '.hk', 'HKD', '852', '', '', 'zh-HK,yue,zh,en', '', '', 1, NULL, NULL),
(97, 'HM', 'HMD', 334, 'HM', 'Heard Island and McDonald Islands', 'Heard Island and McDonald Islands', '', 412, 0, 'AN', '.hm', 'AUD', ' ', '', '', '', '', '', 0, NULL, NULL),
(98, 'HN', 'HND', 340, 'HO', 'Honduras', 'Honduras', 'Tegucigalpa', 112090, 7989415, 'NA', '.hn', 'HNL', '504', '@@####', '^([A-Z]{2}d{4})$', 'es-HN', 'GT,NI,SV', '', 1, NULL, NULL),
(99, 'HR', 'HRV', 191, 'HR', 'Hrvatska', 'Croatia', 'Zagreb', 56542, 4491000, 'EU', '.hr', 'HRK', '385', '#####', '^(?:HR)*(d{5})$', 'hr-HR,sr', 'HU,SI,BA,ME,RS', '', 1, NULL, NULL),
(100, 'HT', 'HTI', 332, 'HA', 'Haïti', 'Haiti', 'Port-au-Prince', 27750, 9648924, 'NA', '.ht', 'HTG', '509', 'HT####', '^(?:HT)*(d{4})$', 'ht,fr-HT', 'DO', '', 1, NULL, NULL),
(101, 'HU', 'HUN', 348, 'HU', 'Magyarország', 'Hungary', 'Budapest', 93030, 9982000, 'EU', '.hu', 'HUF', '36', '####', '^(d{4})$', 'hu-HU', 'SK,SI,RO,UA,HR,AT,RS', '', 1, NULL, NULL),
(102, 'ID', 'IDN', 360, 'ID', 'Indonesia', 'Indonesia', 'Jakarta', 1919440, 242968342, 'AS', '.id', 'IDR', '62', '#####', '^(d{5})$', 'id,en,nl,jv', 'PG,TL,MY', '', 1, NULL, NULL),
(103, 'IE', 'IRL', 372, 'EI', 'Ireland', 'Ireland', 'Dublin', 70280, 4622917, 'EU', '.ie', 'EUR', '353', '', '', 'en-IE,ga-IE', 'GB', '', 1, NULL, NULL),
(104, 'IL', 'ISR', 376, 'IS', 'YiśrÄ''ēl', 'Israel', 'Jerusalem', 20770, 7353985, 'AS', '.il', 'ILS', '972', '#####', '^(d{5})$', 'he,ar-IL,en-IL,', 'SY,JO,LB,EG,PS', '', 1, NULL, NULL),
(105, 'IM', 'IMN', 833, 'IM', 'Isle of Man', 'Isle of Man', 'Douglas, Isle of Man', 572, 75049, 'EU', '.im', 'GBP', '+44-1624', '@# #@@|@## #@@|@@# #@@|@@## #@@|@#@ #@@|@@#@ #@@|G', '^(([A-Z]d{2}[A-Z]{2})|([A-Z]d{3}[A-Z]{2})|([A-Z]{2}d{2}[A-Z]{2})|([A-Z]{2}d{3}[A-Z]{2})|([A-Z]d[A-Z]d[A-Z]{2})|([A-Z]{2}d[A-Z]d[A-Z]{2})|(GIR0AA))$', 'en,gv', '', '', 1, NULL, NULL),
(106, 'IN', 'IND', 356, 'IN', 'BhÄrat', 'India', 'New Delhi', 3287590, 1173108018, 'AS', '.in', 'INR', '91', '######', '^(d{6})$', 'en-IN,hi,bn,te,mr,ta,ur,gu,kn,ml,or,pa,as,bh,sat,k', 'CN,NP,MM,BT,PK,BD', '', 1, NULL, NULL),
(107, 'IO', 'IOT', 86, 'IO', 'British Indian Ocean Territory', 'British Indian Ocean Territory', 'Diego Garcia', 60, 4000, 'AS', '.io', 'USD', '246', '', '', 'en-IO', '', '', 0, NULL, NULL),
(108, 'IQ', 'IRQ', 368, 'IZ', 'al-ʿIrÄq', 'Iraq', 'Baghdad', 437072, 29671605, 'AS', '.iq', 'IQD', '964', '#####', '^(d{5})$', 'ar-IQ,ku,hy', 'SY,SA,IR,JO,TR,KW', '', 1, NULL, NULL),
(109, 'IR', 'IRN', 364, 'IR', 'ĪrÄn', 'Iran', 'Tehran', 1648000, 76923300, 'AS', '.ir', 'IRR', '98', '##########', '^(d{10})$', 'fa-IR,ku', 'TM,AF,IQ,AM,PK,AZ,TR', '', 1, NULL, NULL),
(110, 'IS', 'ISL', 352, 'IC', 'Ãsland', 'Iceland', 'Reykjavik', 103000, 308910, 'EU', '.is', 'ISK', '354', '###', '^(d{3})$', 'is,en,de,da,sv,no', '', '', 1, NULL, NULL),
(111, 'IT', 'ITA', 380, 'IT', 'Italia', 'Italy', 'Rome', 301230, 60340328, 'EU', '.it', 'EUR', '39', '#####', '^(d{5})$', 'it-IT,en,de-IT,fr-IT,sc,ca,co,sl', 'CH,VA,SI,SM,FR,AT', '', 1, NULL, NULL),
(112, 'JE', 'JEY', 832, 'JE', 'Jersey', 'Jersey', 'Saint Helier', 116, 90812, 'EU', '.je', 'GBP', '+44-1534', '@# #@@|@## #@@|@@# #@@|@@## #@@|@#@ #@@|@@#@ #@@|G', '^(([A-Z]d{2}[A-Z]{2})|([A-Z]d{3}[A-Z]{2})|([A-Z]{2}d{2}[A-Z]{2})|([A-Z]{2}d{3}[A-Z]{2})|([A-Z]d[A-Z]d[A-Z]{2})|([A-Z]{2}d[A-Z]d[A-Z]{2})|(GIR0AA))$', 'en,pt', '', '', 1, NULL, NULL),
(113, 'JM', 'JAM', 388, 'JM', 'Jamaica', 'Jamaica', 'Kingston', 10991, 2847232, 'NA', '.jm', 'JMD', '+1-876', '', '', 'en-JM', '', '', 1, NULL, NULL),
(114, 'JO', 'JOR', 400, 'JO', 'al-Urdun', 'Jordan', 'Amman', 92300, 6407085, 'AS', '.jo', 'JOD', '962', '#####', '^(d{5})$', 'ar-JO,en', 'SY,SA,IQ,IL,PS', '', 1, NULL, NULL),
(115, 'JP', 'JPN', 392, 'JA', 'Nihon', 'Japan', 'Tokyo', 377835, 127288000, 'AS', '.jp', 'JPY', '81', '###-####', '^(d{7})$', 'ja', '', '', 1, NULL, NULL),
(116, 'KE', 'KEN', 404, 'KE', 'Kenya', 'Kenya', 'Nairobi', 582650, 40046566, 'AF', '.ke', 'KES', '254', '#####', '^(d{5})$', 'en-KE,sw-KE', 'ET,TZ,SS,SO,UG', '', 1, NULL, NULL),
(117, 'KG', 'KGZ', 417, 'KG', 'Kyrgyzstan', 'Kyrgyzstan', 'Bishkek', 198500, 5508626, 'AS', '.kg', 'KGS', '996', '######', '^(d{6})$', 'ky,uz,ru', 'CN,TJ,UZ,KZ', '', 1, NULL, NULL),
(118, 'KH', 'KHM', 116, 'CB', 'KambucÄ', 'Cambodia', 'Phnom Penh', 181040, 14453680, 'AS', '.kh', 'KHR', '855', '#####', '^(d{5})$', 'km,fr,en', 'LA,TH,VN', '', 1, NULL, NULL),
(119, 'KI', 'KIR', 296, 'KR', 'Kiribati', 'Kiribati', 'Tarawa', 811, 92533, 'OC', '.ki', 'AUD', '686', '', '', 'en-KI,gil', '', '', 1, NULL, NULL),
(120, 'KM', 'COM', 174, 'CN', 'Comores', 'Comoros', 'Moroni', 2170, 773407, 'AF', '.km', 'KMF', '269', '', '', 'ar,fr-KM', '', '', 1, NULL, NULL),
(121, 'KN', 'KNA', 659, 'SC', 'Saint Kitts and Nevis', 'Saint Kitts and Nevis', 'Basseterre', 261, 51134, 'NA', '.kn', 'XCD', '+1-869', '', '', 'en-KN', '', '', 0, NULL, NULL),
(122, 'KP', 'PRK', 408, 'KN', 'Joseon', 'North Korea', 'Pyongyang', 120540, 22912177, 'AS', '.kp', 'KPW', '850', '###-###', '^(d{6})$', 'ko-KP', 'CN,KR,RU', '', 1, NULL, NULL),
(123, 'KR', 'KOR', 410, 'KS', 'Hanguk', 'South Korea', 'Seoul', 98480, 48422644, 'AS', '.kr', 'KRW', '82', 'SEOUL ###-###', '^(?:SEOUL)*(d{6})$', 'ko-KR,en', 'KP', '', 1, NULL, NULL),
(124, 'KW', 'KWT', 414, 'KU', 'al-Kuwayt', 'Kuwait', 'Kuwait City', 17820, 2789132, 'AS', '.kw', 'KWD', '965', '#####', '^(d{5})$', 'ar-KW,en', 'SA,IQ', '', 1, NULL, NULL),
(125, 'KY', 'CYM', 136, 'CJ', 'Cayman Islands', 'Cayman Islands', 'George Town', 262, 44270, 'NA', '.ky', 'KYD', '+1-345', '', '', 'en-KY', '', '', 1, NULL, NULL),
(126, 'KZ', 'KAZ', 398, 'KZ', 'Ķazaķstan', 'Kazakhstan', 'Astana', 2717300, 15340000, 'AS', '.kz', 'KZT', '7', '######', '^(d{6})$', 'kk,ru', 'TM,CN,KG,UZ,RU', '', 1, NULL, NULL),
(127, 'LA', 'LAO', 418, 'LA', 'LÄw', 'Laos', 'Vientiane', 236800, 6368162, 'AS', '.la', 'LAK', '856', '#####', '^(d{5})$', 'lo,fr,en', 'CN,MM,KH,TH,VN', '', 1, NULL, NULL),
(128, 'LB', 'LBN', 422, 'LE', 'LubnÄn', 'Lebanon', 'Beirut', 10400, 4125247, 'AS', '.lb', 'LBP', '961', '#### ####|####', '^(d{4}(d{4})?)$', 'ar-LB,fr-LB,en,hy', 'SY,IL', '', 1, NULL, NULL),
(129, 'LC', 'LCA', 662, 'ST', 'Saint Lucia', 'Saint Lucia', 'Castries', 616, 160922, 'NA', '.lc', 'XCD', '+1-758', '', '', 'en-LC', '', '', 0, NULL, NULL),
(130, 'LI', 'LIE', 438, 'LS', 'Liechtenstein', 'Liechtenstein', 'Vaduz', 160, 35000, 'EU', '.li', 'CHF', '423', '####', '^(d{4})$', 'de-LI', 'CH,AT', '', 1, NULL, NULL),
(131, 'LK', 'LKA', 144, 'CE', 'Å rī Laá¹kÄ', 'Sri Lanka', 'Colombo', 65610, 21513990, 'AS', '.lk', 'LKR', '94', '#####', '^(d{5})$', 'si,ta,en', '', '', 1, NULL, NULL),
(132, 'LR', 'LBR', 430, 'LI', 'Liberia', 'Liberia', 'Monrovia', 111370, 3685076, 'AF', '.lr', 'LRD', '231', '####', '^(d{4})$', 'en-LR', 'SL,CI,GN', '', 1, NULL, NULL),
(133, 'LS', 'LSO', 426, 'LT', 'Lesotho', 'Lesotho', 'Maseru', 30355, 1919552, 'AF', '.ls', 'LSL', '266', '###', '^(d{3})$', 'en-LS,st,zu,xh', 'ZA', '', 1, NULL, NULL),
(134, 'LT', 'LTU', 440, 'LH', 'Lietuva', 'Lithuania', 'Vilnius', 65200, 2944459, 'EU', '.lt', 'EUR', '370', 'LT-#####', '^(?:LT)*(d{5})$', 'lt,ru,pl', 'PL,BY,RU,LV', '', 1, NULL, NULL),
(135, 'LU', 'LUX', 442, 'LU', 'Lëtzebuerg', 'Luxembourg', 'Luxembourg', 2586, 497538, 'EU', '.lu', 'EUR', '352', 'L-####', '^(d{4})$', 'lb,de-LU,fr-LU', 'DE,BE,FR', '', 1, NULL, NULL),
(136, 'LV', 'LVA', 428, 'LG', 'Latvija', 'Latvia', 'Riga', 64589, 2217969, 'EU', '.lv', 'EUR', '371', 'LV-####', '^(?:LV)*(d{4})$', 'lv,ru,lt', 'LT,EE,BY,RU', '', 1, NULL, NULL),
(137, 'LY', 'LBY', 434, 'LY', 'LībiyÄ', 'Libya', 'Tripolis', 1759540, 6461454, 'AF', '.ly', 'LYD', '218', '', '', 'ar-LY,it,en', 'TD,NE,DZ,SD,TN,EG', '', 1, NULL, NULL),
(138, 'MA', 'MAR', 504, 'MO', 'Maroc', 'Morocco', 'Rabat', 446550, 31627428, 'AF', '.ma', 'MAD', '212', '#####', '^(d{5})$', 'ar-MA,fr', 'DZ,EH,ES', '', 1, NULL, NULL),
(139, 'MC', 'MCO', 492, 'MN', 'Monaco', 'Monaco', 'Monaco', 2, 32965, 'EU', '.mc', 'EUR', '377', '#####', '^(d{5})$', 'fr-MC,en,it', 'FR', '', 1, NULL, NULL),
(140, 'MD', 'MDA', 498, 'MD', 'Moldova', 'Moldova', 'Chisinau', 33843, 4324000, 'EU', '.md', 'MDL', '373', 'MD-####', '^(?:MD)*(d{4})$', 'ro,ru,gag,tr', 'RO,UA', '', 1, NULL, NULL),
(141, 'ME', 'MNE', 499, 'MJ', 'Crna Gora', 'Montenegro', 'Podgorica', 14026, 666730, 'EU', '.me', 'EUR', '382', '#####', '^(d{5})$', 'sr,hu,bs,sq,hr,rom', 'AL,HR,BA,RS,XK', '', 1, NULL, NULL),
(142, 'MF', 'MAF', 663, 'RN', 'Saint Martin', 'Saint Martin', 'Marigot', 53, 35925, 'NA', '.gp', 'EUR', '590', '### ###', '', 'fr', 'SX', '', 0, NULL, NULL),
(143, 'MG', 'MDG', 450, 'MA', 'Madagascar', 'Madagascar', 'Antananarivo', 587040, 21281844, 'AF', '.mg', 'MGA', '261', '###', '^(d{3})$', 'fr-MG,mg', '', '', 1, NULL, NULL),
(144, 'MH', 'MHL', 584, 'RM', 'Marshall Islands', 'Marshall Islands', 'Majuro', 181, 65859, 'OC', '.mh', 'USD', '692', '', '', 'mh,en-MH', '', '', 1, NULL, NULL),
(145, 'MK', 'MKD', 807, 'MK', 'Makedonija', 'Macedonia', 'Skopje', 25333, 2062294, 'EU', '.mk', 'MKD', '389', '####', '^(d{4})$', 'mk,sq,tr,rmm,sr', 'AL,GR,BG,RS,XK', '', 1, NULL, NULL),
(146, 'ML', 'MLI', 466, 'ML', 'Mali', 'Mali', 'Bamako', 1240000, 13796354, 'AF', '.ml', 'XOF', '223', '', '', 'fr-ML,bm', 'SN,NE,DZ,CI,GN,MR,BF', '', 1, NULL, NULL),
(147, 'MM', 'MMR', 104, 'BM', 'MáºanmÄ', 'Myanmar', 'Nay Pyi Taw', 678500, 53414374, 'AS', '.mm', 'MMK', '95', '#####', '^(d{5})$', 'my', 'CN,LA,TH,BD,IN', '', 1, NULL, NULL),
(148, 'MN', 'MNG', 496, 'MG', 'Mongol Uls', 'Mongolia', 'Ulan Bator', 1565000, 3086918, 'AS', '.mn', 'MNT', '976', '######', '^(d{6})$', 'mn,ru', 'CN,RU', '', 1, NULL, NULL),
(149, 'MO', 'MAC', 446, 'MC', 'Ngoumún', 'Macao', 'Macao', 254, 449198, 'AS', '.mo', 'MOP', '853', '', '', 'zh,zh-MO,pt', '', '', 1, NULL, NULL),
(150, 'MP', 'MNP', 580, 'CQ', 'Northern Mariana Islands', 'Northern Mariana Islands', 'Saipan', 477, 53883, 'OC', '.mp', 'USD', '+1-670', '', '', 'fil,tl,zh,ch-MP,en-MP', '', '', 0, NULL, NULL),
(151, 'MQ', 'MTQ', 474, 'MB', 'Martinique', 'Martinique', 'Fort-de-France', 1100, 432900, 'NA', '.mq', 'EUR', '596', '#####', '^(d{5})$', 'fr-MQ', '', '', 1, NULL, NULL),
(152, 'MR', 'MRT', 478, 'MR', 'Mauritanie', 'Mauritania', 'Nouakchott', 1030700, 3205060, 'AF', '.mr', 'MRO', '222', '', '', 'ar-MR,fuc,snk,fr,mey,wo', 'SN,DZ,EH,ML', '', 1, NULL, NULL),
(153, 'MS', 'MSR', 500, 'MH', 'Montserrat', 'Montserrat', 'Plymouth', 102, 9341, 'NA', '.ms', 'XCD', '+1-664', '', '', 'en-MS', '', '', 1, NULL, NULL),
(154, 'MT', 'MLT', 470, 'MT', 'Malta', 'Malta', 'Valletta', 316, 403000, 'EU', '.mt', 'EUR', '356', '@@@ ###|@@@ ##', '^([A-Z]{3}d{2}d?)$', 'mt,en-MT', '', '', 1, NULL, NULL),
(155, 'MU', 'MUS', 480, 'MP', 'Mauritius', 'Mauritius', 'Port Louis', 2040, 1294104, 'AF', '.mu', 'MUR', '230', '', '', 'en-MU,bho,fr', '', '', 1, NULL, NULL),
(156, 'MV', 'MDV', 462, 'MV', 'Dhivehi', 'Maldives', 'Male', 300, 395650, 'AS', '.mv', 'MVR', '960', '#####', '^(d{5})$', 'dv,en', '', '', 1, NULL, NULL),
(157, 'MW', 'MWI', 454, 'MI', 'Malawi', 'Malawi', 'Lilongwe', 118480, 15447500, 'AF', '.mw', 'MWK', '265', '', '', 'ny,yao,tum,swk', 'TZ,MZ,ZM', '', 1, NULL, NULL),
(158, 'MX', 'MEX', 484, 'MX', 'México', 'Mexico', 'Mexico City', 1972550, 112468855, 'NA', '.mx', 'MXN', '52', '#####', '^(d{5})$', 'es-MX', 'GT,US,BZ', '', 1, NULL, NULL),
(159, 'MY', 'MYS', 458, 'MY', 'Malaysia', 'Malaysia', 'Kuala Lumpur', 329750, 28274729, 'AS', '.my', 'MYR', '60', '#####', '^(d{5})$', 'ms-MY,en,zh,ta,te,ml,pa,th', 'BN,TH,ID', '', 1, NULL, NULL),
(160, 'MZ', 'MOZ', 508, 'MZ', 'Moçambique', 'Mozambique', 'Maputo', 801590, 22061451, 'AF', '.mz', 'MZN', '258', '####', '^(d{4})$', 'pt-MZ,vmw', 'ZW,TZ,SZ,ZA,ZM,MW', '', 1, NULL, NULL),
(161, 'NA', 'NAM', 516, 'WA', 'Namibia', 'Namibia', 'Windhoek', 825418, 2128471, 'AF', '.na', 'NAD', '264', '', '', 'en-NA,af,de,hz,naq', 'ZA,BW,ZM,AO', '', 1, NULL, NULL),
(162, 'NC', 'NCL', 540, 'NC', 'Nouvelle Calédonie', 'New Caledonia', 'Noumea', 19060, 216494, 'OC', '.nc', 'XPF', '687', '#####', '^(d{5})$', 'fr-NC', '', '', 1, NULL, NULL),
(163, 'NE', 'NER', 562, 'NG', 'Niger', 'Niger', 'Niamey', 1267000, 15878271, 'AF', '.ne', 'XOF', '227', '####', '^(d{4})$', 'fr-NE,ha,kr,dje', 'TD,BJ,DZ,LY,BF,NG,ML', '', 1, NULL, NULL),
(164, 'NF', 'NFK', 574, 'NF', 'Norfolk Island', 'Norfolk Island', 'Kingston', 35, 1828, 'OC', '.nf', 'AUD', '672', '####', '^(d{4})$', 'en-NF', '', '', 0, NULL, NULL),
(165, 'NG', 'NGA', 566, 'NI', 'Nigeria', 'Nigeria', 'Abuja', 923768, 154000000, 'AF', '.ng', 'NGN', '234', '######', '^(d{6})$', 'en-NG,ha,yo,ig,ff', 'TD,NE,BJ,CM', '', 1, NULL, NULL),
(166, 'NI', 'NIC', 558, 'NU', 'Nicaragua', 'Nicaragua', 'Managua', 129494, 5995928, 'NA', '.ni', 'NIO', '505', '###-###-#', '^(d{7})$', 'es-NI,en', 'CR,HN', '', 1, NULL, NULL),
(167, 'NL', 'NLD', 528, 'NL', 'Nederland', 'Netherlands', 'Amsterdam', 41526, 16645000, 'EU', '.nl', 'EUR', '31', '#### @@', '^(d{4}[A-Z]{2})$', 'nl-NL,fy-NL', 'DE,BE', '', 1, NULL, NULL),
(168, 'NO', 'NOR', 578, 'NO', 'Norge (Noreg)', 'Norway', 'Oslo', 324220, 5009150, 'EU', '.no', 'NOK', '47', '####', '^(d{4})$', 'no,nb,nn,se,fi', 'FI,RU,SE', '', 1, NULL, NULL),
(169, 'NP', 'NPL', 524, 'NP', 'NēpÄl', 'Nepal', 'Kathmandu', 140800, 28951852, 'AS', '.np', 'NPR', '977', '#####', '^(d{5})$', 'ne,en', 'CN,IN', '', 1, NULL, NULL),
(170, 'NR', 'NRU', 520, 'NR', 'Naoero', 'Nauru', 'Yaren', 21, 10065, 'OC', '.nr', 'AUD', '674', '', '', 'na,en-NR', '', '', 1, NULL, NULL),
(171, 'NU', 'NIU', 570, 'NE', 'Niue', 'Niue', 'Alofi', 260, 2166, 'OC', '.nu', 'NZD', '683', '', '', 'niu,en-NU', '', '', 0, NULL, NULL),
(172, 'NZ', 'NZL', 554, 'NZ', 'New Zealand', 'New Zealand', 'Wellington', 268680, 4252277, 'OC', '.nz', 'NZD', '64', '####', '^(d{4})$', 'en-NZ,mi', '', '', 1, NULL, NULL),
(173, 'OM', 'OMN', 512, 'MU', 'ʿUmÄn', 'Oman', 'Muscat', 212460, 2967717, 'AS', '.om', 'OMR', '968', '###', '^(d{3})$', 'ar-OM,en,bal,ur', 'SA,YE,AE', '', 1, NULL, NULL),
(174, 'PA', 'PAN', 591, 'PM', 'Panamá', 'Panama', 'Panama City', 78200, 3410676, 'NA', '.pa', 'PAB', '507', '', '', 'es-PA,en', 'CR,CO', '', 1, NULL, NULL),
(175, 'PE', 'PER', 604, 'PE', 'Perú', 'Peru', 'Lima', 1285220, 29907003, 'SA', '.pe', 'PEN', '51', '', '', 'es-PE,qu,ay', 'EC,CL,BO,BR,CO', '', 1, NULL, NULL),
(176, 'PF', 'PYF', 258, 'FP', 'Polinésie Française', 'French Polynesia', 'Papeete', 4167, 270485, 'OC', '.pf', 'XPF', '689', '#####', '^((97|98)7d{2})$', 'fr-PF,ty', '', '', 0, NULL, NULL),
(177, 'PG', 'PNG', 598, 'PP', 'Papua New Guinea', 'Papua New Guinea', 'Port Moresby', 462840, 6064515, 'OC', '.pg', 'PGK', '675', '###', '^(d{3})$', 'en-PG,ho,meu,tpi', 'ID', '', 1, NULL, NULL),
(178, 'PH', 'PHL', 608, 'RP', 'Pilipinas', 'Philippines', 'Manila', 300000, 99900177, 'AS', '.ph', 'PHP', '63', '####', '^(d{4})$', 'tl,en-PH,fil', '', '', 1, NULL, NULL),
(179, 'PK', 'PAK', 586, 'PK', 'PÄkistÄn', 'Pakistan', 'Islamabad', 803940, 184404791, 'AS', '.pk', 'PKR', '92', '#####', '^(d{5})$', 'ur-PK,en-PK,pa,sd,ps,brh', 'CN,AF,IR,IN', '', 1, NULL, NULL),
(180, 'PL', 'POL', 616, 'PL', 'Polska', 'Poland', 'Warsaw', 312685, 38500000, 'EU', '.pl', 'PLN', '48', '##-###', '^(d{5})$', 'pl', 'DE,LT,SK,CZ,BY,UA,RU', '', 1, NULL, NULL),
(181, 'PM', 'SPM', 666, 'SB', 'Saint Pierre and Miquelon', 'Saint Pierre and Miquelon', 'Saint-Pierre', 242, 7012, 'NA', '.pm', 'EUR', '508', '#####', '^(97500)$', 'fr-PM', '', '', 0, NULL, NULL),
(182, 'PN', 'PCN', 612, 'PC', 'Pitcairn', 'Pitcairn', 'Adamstown', 47, 46, 'OC', '.pn', 'NZD', '870', '', '', 'en-PN', '', '', 0, NULL, NULL),
(183, 'PR', 'PRI', 630, 'RQ', 'Puerto Rico', 'Puerto Rico', 'San Juan', 9104, 3916632, 'NA', '.pr', 'USD', '+1-787 and', '#####-####', '^(d{9})$', 'en-PR,es-PR', '', '', 1, NULL, NULL),
(184, 'PS', 'PSE', 275, 'WE', 'Filasṭīn', 'Palestinian Territory', 'East Jerusalem', 5970, 3800000, 'AS', '.ps', 'ILS', '970', '', '', 'ar-PS', 'JO,IL,EG', '', 1, NULL, NULL),
(185, 'PT', 'PRT', 620, 'PO', 'Portugal', 'Portugal', 'Lisbon', 92391, 10676000, 'EU', '.pt', 'EUR', '351', '####-###', '^(d{7})$', 'pt-PT,mwl', 'ES', '', 1, NULL, NULL),
(186, 'PW', 'PLW', 585, 'PS', 'Palau', 'Palau', 'Melekeok', 458, 19907, 'OC', '.pw', 'USD', '680', '96940', '^(96940)$', 'pau,sov,en-PW,tox,ja,fil,zh', '', '', 1, NULL, NULL),
(187, 'PY', 'PRY', 600, 'PA', 'Paraguay', 'Paraguay', 'Asuncion', 406750, 6375830, 'SA', '.py', 'PYG', '595', '####', '^(d{4})$', 'es-PY,gn', 'BO,BR,AR', '', 1, NULL, NULL),
(188, 'QA', 'QAT', 634, 'QA', 'Qaṭar', 'Qatar', 'Doha', 11437, 840926, 'AS', '.qa', 'QAR', '974', '', '', 'ar-QA,es', 'SA', '', 1, NULL, NULL),
(189, 'RE', 'REU', 638, 'RE', 'Réunion', 'Reunion', 'Saint-Denis', 2517, 776948, 'AF', '.re', 'EUR', '262', '#####', '^((97|98)(4|7|8)d{2})$', 'fr-RE', '', '', 1, NULL, NULL),
(190, 'RO', 'ROU', 642, 'RO', 'România', 'Romania', 'Bucharest', 237500, 21959278, 'EU', '.ro', 'RON', '40', '######', '^(d{6})$', 'ro,hu,rom', 'MD,HU,UA,BG,RS', '', 1, NULL, NULL),
(191, 'RS', 'SRB', 688, 'RI', 'Srbija', 'Serbia', 'Belgrade', 88361, 7344847, 'EU', '.rs', 'RSD', '381', '######', '^(d{6})$', 'sr,hu,bs,rom', 'AL,HU,MK,RO,HR,BA,BG,ME,XK', '', 1, NULL, NULL),
(192, 'RU', 'RUS', 643, 'RS', 'Rossija', 'Russia', 'Moscow', 17100000, 140702000, 'EU', '.ru', 'RUB', '7', '######', '^(d{6})$', 'ru,tt,xal,cau,ady,kv,ce,tyv,cv,udm,tut,mns,bua,myv', 'GE,CN,BY,UA,KZ,LV,PL,EE,LT,FI,MN,NO,AZ,KP', '', 1, NULL, NULL),
(193, 'RW', 'RWA', 646, 'RW', 'Rwanda', 'Rwanda', 'Kigali', 26338, 11055976, 'AF', '.rw', 'RWF', '250', '', '', 'rw,en-RW,fr-RW,sw', 'TZ,CD,BI,UG', '', 1, NULL, NULL),
(194, 'SA', 'SAU', 682, 'SA', 'as-Saʿūdīyâ', 'Saudi Arabia', 'Riyadh', 1960582, 25731776, 'AS', '.sa', 'SAR', '966', '#####', '^(d{5})$', 'ar-SA', 'QA,OM,IQ,YE,JO,AE,KW', '', 1, NULL, NULL),
(195, 'SB', 'SLB', 90, 'BP', 'Solomon Islands', 'Solomon Islands', 'Honiara', 28450, 559198, 'OC', '.sb', 'SBD', '677', '', '', 'en-SB,tpi', '', '', 1, NULL, NULL),
(196, 'SC', 'SYC', 690, 'SE', 'Seychelles', 'Seychelles', 'Victoria', 455, 88340, 'AF', '.sc', 'SCR', '248', '', '', 'en-SC,fr-SC', '', '', 1, NULL, NULL),
(197, 'SD', 'SDN', 729, 'SU', 'Sudan', 'Sudan', 'Khartoum', 1861484, 35000000, 'AF', '.sd', 'SDG', '249', '#####', '^(d{5})$', 'ar-SD,en,fia', 'SS,TD,EG,ET,ER,LY,CF', '', 1, NULL, NULL),
(198, 'SE', 'SWE', 752, 'SW', 'Sverige', 'Sweden', 'Stockholm', 449964, 9555893, 'EU', '.se', 'SEK', '46', '### ##', '^(?:SE)*(d{5})$', 'sv-SE,se,sma,fi-SE', 'NO,FI', '', 1, NULL, NULL),
(199, 'SG', 'SGP', 702, 'SN', 'xīnjiÄpÅ', 'Singapore', 'Singapur', 693, 4701069, 'AS', '.sg', 'SGD', '65', '######', '^(d{6})$', 'cmn,en-SG,ms-SG,ta-SG,zh-SG', '', '', 1, NULL, NULL),
(200, 'SH', 'SHN', 654, 'SH', 'Saint Helena', 'Saint Helena', 'Jamestown', 410, 7460, 'AF', '.sh', 'SHP', '290', 'STHL 1ZZ', '^(STHL1ZZ)$', 'en-SH', '', '', 1, NULL, NULL),
(201, 'SI', 'SVN', 705, 'SI', 'Slovenija', 'Slovenia', 'Ljubljana', 20273, 2007000, 'EU', '.si', 'EUR', '386', '####', '^(?:SI)*(d{4})$', 'sl,sh', 'HU,IT,HR,AT', '', 1, NULL, NULL),
(202, 'SJ', 'SJM', 744, 'SV', 'Svalbard and Jan Mayen', 'Svalbard and Jan Mayen', 'Longyearbyen', 62049, 2550, 'EU', '.sj', 'NOK', '47', '', '', 'no,ru', '', '', 0, NULL, NULL),
(203, 'SK', 'SVK', 703, 'LO', 'Slovensko', 'Slovakia', 'Bratislava', 48845, 5455000, 'EU', '.sk', 'EUR', '421', '### ##', '^(d{5})$', 'sk,hu', 'PL,HU,CZ,UA,AT', '', 1, NULL, NULL),
(204, 'SL', 'SLE', 694, 'SL', 'Sierra Leone', 'Sierra Leone', 'Freetown', 71740, 5245695, 'AF', '.sl', 'SLL', '232', '', '', 'en-SL,men,tem', 'LR,GN', '', 1, NULL, NULL),
(205, 'SM', 'SMR', 674, 'SM', 'San Marino', 'San Marino', 'San Marino', 61, 31477, 'EU', '.sm', 'EUR', '378', '4789#', '^(4789d)$', 'it-SM', 'IT', '', 1, NULL, NULL),
(206, 'SN', 'SEN', 686, 'SG', 'Sénégal', 'Senegal', 'Dakar', 196190, 12323252, 'AF', '.sn', 'XOF', '221', '#####', '^(d{5})$', 'fr-SN,wo,fuc,mnk', 'GN,MR,GW,GM,ML', '', 1, NULL, NULL),
(207, 'SO', 'SOM', 706, 'SO', 'Soomaaliya', 'Somalia', 'Mogadishu', 637657, 10112453, 'AF', '.so', 'SOS', '252', '@@  #####', '^([A-Z]{2}d{5})$', 'so-SO,ar-SO,it,en-SO', 'ET,KE,DJ', '', 1, NULL, NULL),
(208, 'SR', 'SUR', 740, 'NS', 'Suriname', 'Suriname', 'Paramaribo', 163270, 492829, 'SA', '.sr', 'SRD', '597', '', '', 'nl-SR,en,srn,hns,jv', 'GY,BR,GF', '', 1, NULL, NULL),
(209, 'SS', 'SSD', 728, 'OD', 'South Sudan', 'South Sudan', 'Juba', 644329, 8260490, 'AF', '', 'SSP', '211', '', '', 'en', 'CD,CF,ET,KE,SD,UG,', '', 1, NULL, NULL),
(210, 'ST', 'STP', 678, 'TP', 'São Tomé e Príncipe', 'Sao Tome and Principe', 'Sao Tome', 1001, 175808, 'AF', '.st', 'STD', '239', '', '', 'pt-ST', '', '', 1, NULL, NULL),
(211, 'SV', 'SLV', 222, 'ES', 'El Salvador', 'El Salvador', 'San Salvador', 21040, 6052064, 'NA', '.sv', 'USD', '503', 'CP ####', '^(?:CP)*(d{4})$', 'es-SV', 'GT,HN', '', 1, NULL, NULL),
(212, 'SX', 'SXM', 534, 'NN', 'Sint Maarten', 'Sint Maarten', 'Philipsburg', 21, 37429, 'NA', '.sx', 'ANG', '599', '', '', 'nl,en', 'MF', '', 0, NULL, NULL),
(213, 'SY', 'SYR', 760, 'SY', 'Sūrīyâ', 'Syria', 'Damascus', 185180, 22198110, 'AS', '.sy', 'SYP', '963', '', '', 'ar-SY,ku,hy,arc,fr,en', 'IQ,JO,IL,TR,LB', '', 1, NULL, NULL),
(214, 'SZ', 'SWZ', 748, 'WZ', 'Swaziland', 'Swaziland', 'Mbabane', 17363, 1354051, 'AF', '.sz', 'SZL', '268', '@###', '^([A-Z]d{3})$', 'en-SZ,ss-SZ', 'ZA,MZ', '', 1, NULL, NULL),
(215, 'TC', 'TCA', 796, 'TK', 'Turks and Caicos Islands', 'Turks and Caicos Islands', 'Cockburn Town', 430, 20556, 'NA', '.tc', 'USD', '+1-649', 'TKCA 1ZZ', '^(TKCA 1ZZ)$', 'en-TC', '', '', 0, NULL, '2016-05-26 00:28:15'),
(216, 'TD', 'TCD', 148, 'CD', 'Tchad', 'Chad', 'N''Djamena', 1284000, 10543464, 'AF', '.td', 'XAF', '235', '', '', 'fr-TD,ar-TD,sre', 'NE,LY,CF,SD,CM,NG', '', 1, NULL, NULL),
(217, 'TF', 'ATF', 260, 'FS', 'French Southern Territories', 'French Southern Territories', 'Port-aux-Francais', 7829, 140, 'AN', '.tf', 'EUR', '', '', '', 'fr', '', '', 0, NULL, NULL),
(218, 'TG', 'TGO', 768, 'TO', 'Togo', 'Togo', 'Lome', 56785, 6587239, 'AF', '.tg', 'XOF', '228', '', '', 'fr-TG,ee,hna,kbp,dag,ha', 'BJ,GH,BF', '', 1, NULL, NULL),
(219, 'TH', 'THA', 764, 'TH', 'Prathēt tai', 'Thailand', 'Bangkok', 514000, 67089500, 'AS', '.th', 'THB', '66', '#####', '^(d{5})$', 'th,en', 'LA,MM,KH,MY', '', 1, NULL, NULL),
(220, 'TJ', 'TJK', 762, 'TI', 'Tojikiston', 'Tajikistan', 'Dushanbe', 143100, 7487489, 'AS', '.tj', 'TJS', '992', '######', '^(d{6})$', 'tg,ru', 'CN,AF,KG,UZ', '', 1, NULL, NULL),
(221, 'TK', 'TKL', 772, 'TL', 'Tokelau', 'Tokelau', '', 10, 1466, 'OC', '.tk', 'NZD', '690', '', '', 'tkl,en-TK', '', '', 0, NULL, NULL),
(222, 'TL', 'TLS', 626, 'TT', 'Timór Lorosa''e', 'East Timor', 'Dili', 15007, 1154625, 'OC', '.tl', 'USD', '670', '', '', 'tet,pt-TL,id,en', 'ID', '', 1, NULL, NULL),
(223, 'TM', 'TKM', 795, 'TX', 'Turkmenistan', 'Turkmenistan', 'Ashgabat', 488100, 4940916, 'AS', '.tm', 'TMT', '993', '######', '^(d{6})$', 'tk,ru,uz', 'AF,IR,UZ,KZ', '', 1, NULL, NULL),
(224, 'TN', 'TUN', 788, 'TS', 'Tunisie', 'Tunisia', 'Tunis', 163610, 10589025, 'AF', '.tn', 'TND', '216', '####', '^(d{4})$', 'ar-TN,fr', 'DZ,LY', '', 1, NULL, NULL),
(225, 'TO', 'TON', 776, 'TN', 'Tonga', 'Tonga', 'Nuku''alofa', 748, 122580, 'OC', '.to', 'TOP', '676', '', '', 'to,en-TO', '', '', 1, NULL, NULL),
(226, 'TR', 'TUR', 792, 'TU', 'Türkiye', 'Turkey', 'Ankara', 780580, 77804122, 'AS', '.tr', 'TRY', '90', '#####', '^(d{5})$', 'tr-TR,ku,diq,az,av', 'SY,GE,IQ,IR,GR,AM,AZ,BG', '', 1, NULL, NULL),
(227, 'TT', 'TTO', 780, 'TD', 'Trinidad and Tobago', 'Trinidad and Tobago', 'Port of Spain', 5128, 1228691, 'NA', '.tt', 'TTD', '+1-868', '', '', 'en-TT,hns,fr,es,zh', '', '', 1, NULL, NULL),
(228, 'TV', 'TUV', 798, 'TV', 'Tuvalu', 'Tuvalu', 'Funafuti', 26, 10472, 'OC', '.tv', 'AUD', '688', '', '', 'tvl,en,sm,gil', '', '', 1, NULL, NULL),
(229, 'TW', 'TWN', 158, 'TW', 'T''ai2-wan1', 'Taiwan', 'Taipei', 35980, 22894384, 'AS', '.tw', 'TWD', '886', '#####', '^(d{5})$', 'zh-TW,zh,nan,hak', '', '', 1, NULL, NULL),
(230, 'TZ', 'TZA', 834, 'TZ', 'Tanzania', 'Tanzania', 'Dodoma', 945087, 41892895, 'AF', '.tz', 'TZS', '255', '', '', 'sw-TZ,en,ar', 'MZ,KE,CD,RW,ZM,BI,UG,MW', '', 1, NULL, NULL),
(231, 'UA', 'UKR', 804, 'UP', 'Ukrajina', 'Ukraine', 'Kiev', 603700, 45415596, 'EU', '.ua', 'UAH', '380', '#####', '^(d{5})$', 'uk,ru-UA,rom,pl,hu', 'PL,MD,HU,SK,BY,RO,RU', '', 1, NULL, NULL),
(232, 'UG', 'UGA', 800, 'UG', 'Uganda', 'Uganda', 'Kampala', 236040, 33398682, 'AF', '.ug', 'UGX', '256', '', '', 'en-UG,lg,sw,ar', 'TZ,KE,SS,CD,RW', '', 1, NULL, NULL),
(233, 'UK', 'GBR', 826, 'UK', 'United Kingdom', 'United Kingdom', 'London', 244820, 62348447, 'EU', '.uk', 'GBP', '44', '@# #@@|@## #@@|@@# #@@|@@## #@@|@#@ #@@|@@#@ #@@|G', '^(([A-Z]d{2}[A-Z]{2})|([A-Z]d{3}[A-Z]{2})|([A-Z]{2}d{2}[A-Z]{2})|([A-Z]{2}d{3}[A-Z]{2})|([A-Z]d[A-Z]d[A-Z]{2})|([A-Z]{2}d[A-Z]d[A-Z]{2})|(GIR0AA))$', 'en-GB,cy-GB,gd', 'IE', '', 1, NULL, NULL),
(234, 'UM', 'UMI', 581, '', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands', '', 0, 0, 'OC', '.um', 'USD', '1', '', '', 'en-UM', '', '', 0, NULL, NULL),
(235, 'US', 'USA', 840, 'US', 'USA', 'United States', 'Washington', 9629091, 310232863, 'NA', '.us', 'USD', '1', '#####-####', '^d{5}(-d{4})?$', 'en-US,es-US,haw,fr', 'CA,MX,CU', '', 1, NULL, NULL),
(236, 'UY', 'URY', 858, 'UY', 'Uruguay', 'Uruguay', 'Montevideo', 176220, 3477000, 'SA', '.uy', 'UYU', '598', '#####', '^(d{5})$', 'es-UY', 'BR,AR', '', 1, NULL, NULL),
(237, 'UZ', 'UZB', 860, 'UZ', 'O''zbekiston', 'Uzbekistan', 'Tashkent', 447400, 27865738, 'AS', '.uz', 'UZS', '998', '######', '^(d{6})$', 'uz,ru,tg', 'TM,AF,KG,TJ,KZ', '', 1, NULL, NULL),
(238, 'VA', 'VAT', 336, 'VT', 'Vaticanum', 'Vatican', 'Vatican City', 0, 921, 'EU', '.va', 'EUR', '379', '#####', '^(d{5})$', 'la,it,fr', 'IT', '', 0, NULL, NULL),
(239, 'VC', 'VCT', 670, 'VC', 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 'Kingstown', 389, 104217, 'NA', '.vc', 'XCD', '+1-784', '', '', 'en-VC,fr', '', '', 0, NULL, NULL),
(240, 'VE', 'VEN', 862, 'VE', 'Venezuela', 'Venezuela', 'Caracas', 912050, 27223228, 'SA', '.ve', 'VEF', '58', '####', '^(d{4})$', 'es-VE', 'GY,BR,CO', '', 1, NULL, NULL),
(241, 'VG', 'VGB', 92, 'VI', 'British Virgin Islands', 'British Virgin Islands', 'Road Town', 153, 21730, 'NA', '.vg', 'USD', '+1-284', '', '', 'en-VG', '', '', 0, NULL, NULL),
(242, 'VI', 'VIR', 850, 'VQ', 'U.S. Virgin Islands', 'U.S. Virgin Islands', 'Charlotte Amalie', 352, 108708, 'NA', '.vi', 'USD', '+1-340', '#####-####', '^d{5}(-d{4})?$', 'en-VI', '', '', 0, NULL, NULL),
(243, 'VN', 'VNM', 704, 'VM', 'Việt Nam', 'Vietnam', 'Hanoi', 329560, 89571130, 'AS', '.vn', 'VND', '84', '######', '^(d{6})$', 'vi,en,fr,zh,km', 'CN,LA,KH', '', 1, NULL, NULL),
(244, 'VU', 'VUT', 548, 'NH', 'Vanuatu', 'Vanuatu', 'Port Vila', 12200, 221552, 'OC', '.vu', 'VUV', '678', '', '', 'bi,en-VU,fr-VU', '', '', 1, NULL, NULL),
(245, 'WF', 'WLF', 876, 'WF', 'Wallis and Futuna', 'Wallis and Futuna', 'Mata Utu', 274, 16025, 'OC', '.wf', 'XPF', '681', '#####', '^(986d{2})$', 'wls,fud,fr-WF', '', '', 0, NULL, NULL),
(246, 'WS', 'WSM', 882, 'WS', 'Samoa', 'Samoa', 'Apia', 2944, 192001, 'OC', '.ws', 'WST', '685', '', '', 'sm,en-WS', '', '', 1, NULL, NULL),
(247, 'XK', 'XKX', 0, 'KV', 'Kosovo', 'Kosovo', 'Pristina', 10908, 1800000, 'EU', '', 'EUR', '', '', '', 'sq,sr', 'RS,AL,MK,ME', '', 1, NULL, NULL),
(248, 'YE', 'YEM', 887, 'YM', 'al-Yaman', 'Yemen', 'Sanaa', 527970, 23495361, 'AS', '.ye', 'YER', '967', '', '', 'ar-YE', 'SA,OM', '', 1, NULL, NULL),
(249, 'YT', 'MYT', 175, 'MF', 'Mayotte', 'Mayotte', 'Mamoudzou', 374, 159042, 'AF', '.yt', 'EUR', '262', '#####', '^(d{5})$', 'fr-YT', '', '', 1, NULL, NULL),
(250, 'ZA', 'ZAF', 710, 'SF', 'South Africa', 'South Africa', 'Pretoria', 1219912, 49000000, 'AF', '.za', 'ZAR', '27', '####', '^(d{4})$', 'zu,xh,af,nso,en-ZA,tn,st,ts,ss,ve,nr', 'ZW,SZ,MZ,BW,NA,LS', '', 1, NULL, NULL),
(251, 'ZM', 'ZMB', 894, 'ZA', 'Zambia', 'Zambia', 'Lusaka', 752614, 13460305, 'AF', '.zm', 'ZMW', '260', '#####', '^(d{5})$', 'en-ZM,bem,loz,lun,lue,ny,toi', 'ZW,TZ,MZ,CD,NA,MW,AO', '', 1, NULL, NULL),
(252, 'ZW', 'ZWE', 716, 'ZI', 'Zimbabwe', 'Zimbabwe', 'Harare', 390580, 11651858, 'AF', '.zw', 'ZWL', '263', '', '', 'en-ZW,sn,nr,nd', 'ZA,MZ,BW,ZM', '', 1, NULL, NULL);

--
-- Truncate table before insert `currencies`
--

TRUNCATE TABLE `currencies`;
--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `code`, `name`, `html_entity`, `font_arial`, `font_code2000`, `unicode_decimal`, `unicode_hex`, `in_left`, `created_at`, `updated_at`) VALUES
(1, 'AED', 'United Arab Emirates Dirham', '&#1583;.&#1573;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(2, 'AFN', 'Afghanistan Afghani', '&#65;&#102;', '؋', '؋', '1547', '60b', 0, NULL, '2016-04-03 14:35:01'),
(3, 'ALL', 'Albania Lek', '&#76;&#101;&#107;', 'Lek', 'Lek', '76, 1', '4c, 6', 0, NULL, '2016-04-03 14:35:01'),
(4, 'AMD', 'Armenia Dram', '', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(5, 'ANG', 'Netherlands Antilles Guilder', '&#402;', 'ƒ', 'ƒ', '402', '192', 0, NULL, '2016-04-03 14:35:01'),
(6, 'AOA', 'Angola Kwanza', '&#75;&#122;', 'Kz', 'Kz', NULL, NULL, 1, NULL, '2016-04-03 14:35:01'),
(7, 'ARS', 'Argentina Peso', '&#36;', '$', '$', '36', '24', 0, NULL, '2016-04-03 14:35:01'),
(8, 'AUD', 'Australia Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(9, 'AWG', 'Aruba Guilder', '&#402;', 'ƒ', 'ƒ', '402', '192', 0, NULL, '2016-04-03 14:35:01'),
(10, 'AZN', 'Azerbaijan New Manat', '&#1084;&#1072;&#1085;', 'ман', 'ман', '1084,', '43c, ', 0, NULL, '2016-04-03 14:35:01'),
(11, 'BAM', 'Bosnia and Herzegovina Convertible Marka', '&#75;&#77;', 'KM', 'KM', '75, 7', '4b, 4', 0, NULL, '2016-04-03 14:35:01'),
(12, 'BBD', 'Barbados Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(13, 'BDT', 'Bangladesh Taka', '&#2547;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(14, 'BGN', 'Bulgaria Lev', '&#1083;&#1074;', 'лв', 'лв', '1083,', '43b, ', 0, NULL, '2016-04-03 14:35:01'),
(15, 'BHD', 'Bahrain Dinar', '.&#1583;.&#1576;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(16, 'BIF', 'Burundi Franc', '&#70;&#66;&#117;', 'FBu', 'FBu', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(17, 'BMD', 'Bermuda Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(18, 'BND', 'Brunei Darussalam Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(19, 'BOB', 'Bolivia Boliviano', '&#36;&#98;', '$b', '$b', '36, 9', '24, 6', 0, NULL, '2016-04-03 14:35:01'),
(20, 'BRL', 'Brazil Real', '&#82;&#36;', 'R$', 'R$', '82, 3', '52, 2', 0, NULL, '2016-04-03 14:35:01'),
(21, 'BSD', 'Bahamas Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(22, 'BTN', 'Bhutan Ngultrum', '&#78;&#117;&#46;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(23, 'BWP', 'Botswana Pula', '&#80;', 'P', 'P', '80', '50', 1, NULL, '2016-04-03 14:35:01'),
(24, 'BYR', 'Belarus Ruble', '&#112;&#46;', 'p.', 'p.', '112, ', '70, 2', 0, NULL, '2016-04-03 14:35:01'),
(25, 'BZD', 'Belize Dollar', '&#66;&#90;&#36;', 'BZ$', 'BZ$', '66, 9', '42, 5', 1, NULL, '2016-04-03 14:35:01'),
(26, 'CAD', 'Canada Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(27, 'CDF', 'Congo/Kinshasa Franc', '&#70;&#67;', 'Fr', 'Fr', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(28, 'CHF', 'Switzerland Franc', '&#67;&#72;&#70;', 'CHF', 'CHF', '67, 7', '43, 4', 0, NULL, '2016-04-03 14:35:01'),
(29, 'CLP', 'Chile Peso', '&#36;', '$', '$', '36', '24', 0, NULL, '2016-04-03 14:35:01'),
(30, 'CNY', 'China Yuan Renminbi', '&#165;', '¥', '¥', '165', 'a5', 0, NULL, '2016-04-03 14:35:01'),
(31, 'COP', 'Colombia Peso', '&#36;', '$', '$', '36', '24', 0, NULL, '2016-04-03 14:35:01'),
(32, 'CRC', 'Costa Rica Colon', '&#8353;', '₡', '₡', '8353', '20a1', 0, NULL, '2016-04-03 14:35:01'),
(33, 'CUC', 'Cuba Convertible Peso', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL),
(34, 'CUP', 'Cuba Peso', '&#8396;', '₱', '₱', '8369', '20b1', 0, NULL, '2016-04-03 14:35:01'),
(35, 'CVE', 'Cape Verde Escudo', '&#x24;', '$', '$', NULL, NULL, 1, NULL, '2016-04-03 14:35:01'),
(36, 'CZK', 'Czech Republic Koruna', '&#75;&#269;', 'KÄ', 'KÄ', '75, 2', '4b, 1', 0, NULL, '2016-04-03 14:35:01'),
(37, 'DJF', 'Djibouti Franc', '&#70;&#100;&#106;', 'Fr', 'Fr', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(38, 'DKK', 'Denmark Krone', '&#107;&#114;', 'kr', 'kr', '107, ', '6b, 7', 0, NULL, '2016-04-03 14:35:01'),
(39, 'DOP', 'Dominican Republic Peso', '&#82;&#68;&#36;', 'RD$', 'RD$', '82, 6', '52, 4', 0, NULL, '2016-04-03 14:35:01'),
(40, 'DZD', 'Algeria Dinar', '&#1583;&#1580;', 'DA', 'DA', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(41, 'EEK', 'Estonia Kroon', NULL, 'kr', 'kr', '107, ', '6b, 7', 0, NULL, NULL),
(42, 'EGP', 'Egypt Pound', '&#163;', '£', '£', '163', 'a3', 0, NULL, '2016-04-03 14:35:01'),
(43, 'ERN', 'Eritrea Nakfa', '&#x4E;&#x66;&#x6B;', 'Nfk', 'Nfk', NULL, NULL, 0, NULL, NULL),
(44, 'ETB', 'Ethiopia Birr', '&#66;&#114;', 'Br', 'Br', NULL, NULL, 1, NULL, '2016-04-03 14:35:01'),
(45, 'EUR', 'Euro Member Countries', '&#8364;', '€', '€', '8364', '20ac', 0, NULL, '2016-04-03 14:35:01'),
(46, 'FJD', 'Fiji Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(47, 'FKP', 'Falkland Islands (Malvinas) Pound', '&#163;', '£', '£', '163', 'a3', 0, NULL, '2016-04-03 14:35:01'),
(48, 'GBP', 'United Kingdom Pound', '&#163;', '£', '£', '163', 'a3', 0, NULL, '2016-04-03 14:35:01'),
(49, 'GEL', 'Georgia Lari', '&#4314;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(50, 'GGP', 'Guernsey Pound', NULL, '£', '£', '163', 'a3', 0, NULL, NULL),
(51, 'GHC', 'Ghana Cedi', '&#x47;&#x48;&#xA2;', 'GH¢', 'GH¢', '162', 'a2', 1, NULL, NULL),
(52, 'GHS', 'Ghana Cedi', '&#x47;&#x48;&#xA2;', 'GH¢', 'GH¢', NULL, NULL, 1, NULL, '2016-04-03 14:35:01'),
(53, 'GIP', 'Gibraltar Pound', '&#163;', '£', '£', '163', 'a3', 0, NULL, '2016-04-03 14:35:01'),
(54, 'GMD', 'Gambia Dalasi', '&#68;', 'D', 'D', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(55, 'GNF', 'Guinea Franc', '&#70;&#71;', 'Fr', 'Fr', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(56, 'GTQ', 'Guatemala Quetzal', '&#81;', 'Q', 'Q', '81', '51', 0, NULL, '2016-04-03 14:35:01'),
(57, 'GYD', 'Guyana Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(58, 'HKD', 'Hong Kong Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(59, 'HNL', 'Honduras Lempira', '&#76;', 'L', 'L', '76', '4c', 0, NULL, '2016-04-03 14:35:01'),
(60, 'HRK', 'Croatia Kuna', '&#107;&#110;', 'kn', 'kn', '107, ', '6b, 6', 0, NULL, '2016-04-03 14:35:01'),
(61, 'HTG', 'Haiti Gourde', '&#71;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(62, 'HUF', 'Hungary Forint', '&#70;&#116;', 'Ft', 'Ft', '70, 1', '46, 7', 0, NULL, '2016-04-03 14:35:01'),
(63, 'IDR', 'Indonesia Rupiah', '&#82;&#112;', 'Rp', 'Rp', '82, 1', '52, 7', 0, NULL, '2016-04-03 14:35:01'),
(64, 'ILS', 'Israel Shekel', '&#8362;', '₪', '₪', '8362', '20aa', 0, NULL, '2016-04-03 14:35:01'),
(65, 'IMP', 'Isle of Man Pound', NULL, '£', '£', '163', 'a3', 0, NULL, NULL),
(66, 'INR', 'India Rupee', '&#8377;', '', '', '', '', 0, NULL, '2016-04-03 14:35:01'),
(67, 'IQD', 'Iraq Dinar', '&#1593;.&#1583;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(68, 'IRR', 'Iran Rial', '&#65020;', '﷼', '﷼', '65020', 'fdfc', 0, NULL, '2016-04-03 14:35:01'),
(69, 'ISK', 'Iceland Krona', '&#107;&#114;', 'kr', 'kr', '107, ', '6b, 7', 0, NULL, '2016-04-03 14:35:01'),
(70, 'JEP', 'Jersey Pound', '&#163;', '£', '£', '163', 'a3', 0, NULL, '2016-04-03 14:35:01'),
(71, 'JMD', 'Jamaica Dollar', '&#74;&#36;', 'J$', 'J$', '74, 3', '4a, 2', 1, NULL, '2016-04-03 14:35:01'),
(72, 'JOD', 'Jordan Dinar', '&#74;&#68;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(73, 'JPY', 'Japan Yen', '&#165;', '¥', '¥', '165', 'a5', 0, NULL, '2016-04-03 14:35:01'),
(74, 'KES', 'Kenya Shilling', '&#x4B;&#x53;&#x68;', 'KSh', 'KSh', NULL, NULL, 1, NULL, '2016-04-03 14:35:01'),
(75, 'KGS', 'Kyrgyzstan Som', '&#1083;&#1074;', 'лв', 'лв', '1083,', '43b, ', 0, NULL, '2016-04-03 14:35:01'),
(76, 'KHR', 'Cambodia Riel', '&#6107;', '៛', '៛', '6107', '17db', 0, NULL, '2016-04-03 14:35:01'),
(77, 'KMF', 'Comoros Franc', '&#67;&#70;', 'Fr', 'Fr', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(78, 'KPW', 'Korea (North) Won', '&#8361;', '₩', '₩', '8361', '20a9', 0, NULL, '2016-04-03 14:35:01'),
(79, 'KRW', 'Korea (South) Won', '&#8361;', '₩', '₩', '8361', '20a9', 0, NULL, '2016-04-03 14:35:01'),
(80, 'KWD', 'Kuwait Dinar', '&#1583;.&#1603;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(81, 'KYD', 'Cayman Islands Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(82, 'KZT', 'Kazakhstan Tenge', '&#1083;&#1074;', 'лв', 'лв', '1083,', '43b, ', 0, NULL, '2016-04-03 14:35:01'),
(83, 'LAK', 'Laos Kip', '&#8365;', '₭', '₭', '8365', '20ad', 0, NULL, '2016-04-03 14:35:01'),
(84, 'LBP', 'Lebanon Pound', '&#163;', '£', '£', '163', 'a3', 0, NULL, '2016-04-03 14:35:01'),
(85, 'LKR', 'Sri Lanka Rupee', '&#8360;', '₨', '₨', '8360', '20a8', 0, NULL, '2016-04-03 14:35:01'),
(86, 'LRD', 'Liberia Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(87, 'LSL', 'Lesotho Loti', '&#76;', 'M', 'M', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(88, 'LTL', 'Lithuania Litas', '&#76;&#116;', 'Lt', 'Lt', '76, 1', '4c, 7', 0, NULL, '2016-04-03 14:35:01'),
(89, 'LVL', 'Latvia Lat', '&#76;&#115;', 'Ls', 'Ls', '76, 1', '4c, 7', 0, NULL, '2016-04-03 14:35:01'),
(90, 'LYD', 'Libya Dinar', '&#1604;.&#1583;', 'DL', 'DL', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(91, 'MAD', 'Morocco Dirham', '&#1583;.&#1605;.', 'Dhs', 'Dhs', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(92, 'MDL', 'Moldova Leu', '&#76;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(93, 'MGA', 'Madagascar Ariary', '&#65;&#114;', 'Ar', 'Ar', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(94, 'MKD', 'Macedonia Denar', '&#1076;&#1077;&#1085;', 'ден', 'ден', '1076,', '434, ', 0, NULL, '2016-04-03 14:35:01'),
(95, 'MMK', 'Myanmar (Burma) Kyat', '&#75;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(96, 'MNT', 'Mongolia Tughrik', '&#8366;', '₮', '₮', '8366', '20ae', 0, NULL, '2016-04-03 14:35:01'),
(97, 'MOP', 'Macau Pataca', '&#77;&#79;&#80;&#36;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(98, 'MRO', 'Mauritania Ouguiya', '&#85;&#77;', 'UM', 'UM', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(99, 'MUR', 'Mauritius Rupee', '&#8360;', '₨', '₨', '8360', '20a8', 0, NULL, '2016-04-03 14:35:01'),
(100, 'MVR', 'Maldives (Maldive Islands) Rufiyaa', '.&#1923;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(101, 'MWK', 'Malawi Kwacha', '&#77;&#75;', 'MK', 'MK', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(102, 'MXN', 'Mexico Peso', '&#36;', '$', '$', '36', '24', 0, NULL, '2016-04-03 14:35:01'),
(103, 'MYR', 'Malaysia Ringgit', '&#82;&#77;', 'RM', 'RM', '82, 7', '52, 4', 0, NULL, '2016-04-03 14:35:01'),
(104, 'MZN', 'Mozambique Metical', '&#77;&#84;', 'MT', 'MT', '77, 8', '4d, 5', 0, NULL, '2016-04-03 14:35:01'),
(105, 'NAD', 'Namibia Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(106, 'NGN', 'Nigeria Naira', '&#8358;', '₦', '₦', '8358', '20a6', 1, NULL, '2016-04-03 14:35:01'),
(107, 'NIO', 'Nicaragua Cordoba', '&#67;&#36;', 'C$', 'C$', '67, 3', '43, 2', 0, NULL, '2016-04-03 14:35:01'),
(108, 'NOK', 'Norway Krone', '&#107;&#114;', 'kr', 'kr', '107, ', '6b, 7', 0, NULL, '2016-04-03 14:35:01'),
(109, 'NPR', 'Nepal Rupee', '&#8360;', '₨', '₨', '8360', '20a8', 0, NULL, '2016-04-03 14:35:01'),
(110, 'NZD', 'New Zealand Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(111, 'OMR', 'Oman Rial', '&#65020;', '﷼', '﷼', '65020', 'fdfc', 0, NULL, '2016-04-03 14:35:01'),
(112, 'PAB', 'Panama Balboa', '&#66;&#47;&#46;', 'B/.', 'B/.', '66, 4', '42, 2', 0, NULL, '2016-04-03 14:35:01'),
(113, 'PEN', 'Peru Nuevo Sol', '&#83;&#47;&#46;', 'S/.', 'S/.', '83, 4', '53, 2', 0, NULL, '2016-04-03 14:35:01'),
(114, 'PGK', 'Papua New Guinea Kina', '&#75;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(115, 'PHP', 'Philippines Peso', '&#8369;', '₱', '₱', '8369', '20b1', 0, NULL, '2016-04-03 14:35:01'),
(116, 'PKR', 'Pakistan Rupee', '&#8360;', '₨', '₨', '8360', '20a8', 0, NULL, '2016-04-03 14:35:01'),
(117, 'PLN', 'Poland Zloty', '&#122;&#322;', 'zł', 'zł', '122, ', '7a, 1', 0, NULL, '2016-04-03 14:35:01'),
(118, 'PYG', 'Paraguay Guarani', '&#71;&#115;', 'Gs', 'Gs', '71, 1', '47, 7', 0, NULL, '2016-04-03 14:35:01'),
(119, 'QAR', 'Qatar Riyal', '&#65020;', '﷼', '﷼', '65020', 'fdfc', 0, NULL, '2016-04-03 14:35:01'),
(120, 'RON', 'Romania New Leu', '&#108;&#101;&#105;', 'lei', 'lei', '108, ', '6c, 6', 0, NULL, '2016-04-03 14:35:01'),
(121, 'RSD', 'Serbia Dinar', '&#1044;&#1080;&#1085;&#46;', 'Дин.', 'Дин.', '1044,', '414, ', 0, NULL, '2016-04-03 14:35:01'),
(122, 'RUB', 'Russia Ruble', '&#1088;&#1091;&#1073;', 'руб', 'руб', '1088,', '440, ', 0, NULL, '2016-04-03 14:35:01'),
(123, 'RWF', 'Rwanda Franc', '&#1585;.&#1587;', 'FRw', 'FRw', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(124, 'SAR', 'Saudi Arabia Riyal', '&#65020;', '﷼', '﷼', '65020', 'fdfc', 0, NULL, '2016-04-03 14:35:01'),
(125, 'SBD', 'Solomon Islands Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(126, 'SCR', 'Seychelles Rupee', '&#8360;', '₨', '₨', '8360', '20a8', 0, NULL, '2016-04-03 14:35:01'),
(127, 'SDG', 'Sudan Pound', '&#163;', 'DS', 'DS', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(128, 'SEK', 'Sweden Krona', '&#107;&#114;', 'kr', 'kr', '107, ', '6b, 7', 0, NULL, '2016-04-03 14:35:01'),
(129, 'SGD', 'Singapore Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(130, 'SHP', 'Saint Helena Pound', '&#163;', '£', '£', '163', 'a3', 0, NULL, '2016-04-03 14:35:01'),
(131, 'SLL', 'Sierra Leone Leone', '&#76;&#101;', 'Le', 'Le', NULL, NULL, 1, NULL, '2016-04-03 14:35:01'),
(132, 'SOS', 'Somalia Shilling', '&#83;', 'S', 'S', '83', '53', 0, NULL, '2016-04-03 14:35:01'),
(133, 'SPL', 'Seborga Luigino', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL),
(134, 'SRD', 'Suriname Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(135, 'SSP', 'South Sudanese Pound', '&#xA3;', '£', '£', NULL, NULL, 0, NULL, NULL),
(136, 'STD', 'São Tomé and Príncipe Dobra', '&#68;&#98;', 'Db', 'Db', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(137, 'SVC', 'El Salvador Colon', '&#36;', '$', '$', '36', '24', 0, NULL, '2016-04-03 14:35:01'),
(138, 'SYP', 'Syria Pound', '&#163;', '£', '£', '163', 'a3', 0, NULL, '2016-04-03 14:35:01'),
(139, 'SZL', 'Swaziland Lilangeni', '&#76;', 'E', 'E', NULL, NULL, 1, NULL, '2016-04-03 14:35:01'),
(140, 'THB', 'Thailand Baht', '&#3647;', '฿', '฿', '3647', 'e3f', 0, NULL, '2016-04-03 14:35:01'),
(141, 'TJS', 'Tajikistan Somoni', '&#84;&#74;&#83;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(142, 'TMT', 'Turkmenistan Manat', '&#109;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(143, 'TND', 'Tunisia Dinar', '&#1583;.&#1578;', 'DT', 'DT', NULL, NULL, 1, NULL, '2016-04-03 14:35:01'),
(144, 'TOP', 'Tonga Pa''anga', '&#84;&#36;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(145, 'TRL', 'Turkey Lira', NULL, '₤', '₤', '8356', '20a4', 1, NULL, NULL),
(146, 'TRY', 'Turkey Lira', '&#x20BA;', '₺', '₺', '', '', 1, NULL, '2016-04-03 14:35:01'),
(147, 'TTD', 'Trinidad and Tobago Dollar', '&#36;', 'TT$', 'TT$', '84, 8', '54, 5', 1, NULL, '2016-04-03 14:35:01'),
(148, 'TVD', 'Tuvalu Dollar', NULL, '$', '$', '36', '24', 1, NULL, NULL),
(149, 'TWD', 'Taiwan New Dollar', '&#78;&#84;&#36;', 'NT$', 'NT$', '78, 8', '4e, 5', 1, NULL, '2016-04-03 14:35:01'),
(150, 'TZS', 'Tanzania Shilling', '&#x54;&#x53;&#x68;', 'TSh', 'TSh', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(151, 'UAH', 'Ukraine Hryvnia', '&#8372;', '₴', '₴', '8372', '20b4', 0, NULL, '2016-04-03 14:35:01'),
(152, 'UGX', 'Uganda Shilling', '&#85;&#83;&#104;', 'USh', 'USh', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(153, 'USD', 'United States Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(154, 'UYU', 'Uruguay Peso', '&#36;&#85;', '$U', '$U', '36, 8', '24, 5', 0, NULL, '2016-04-03 14:35:01'),
(155, 'UZS', 'Uzbekistan Som', '&#1083;&#1074;', 'лв', 'лв', '1083,', '43b, ', 0, NULL, '2016-04-03 14:35:01'),
(156, 'VEF', 'Venezuela Bolivar', '&#66;&#115;', 'Bs', 'Bs', '66, 1', '42, 7', 0, NULL, '2016-04-03 14:35:01'),
(157, 'VND', 'Viet Nam Dong', '&#8363;', '₫', '₫', '8363', '20ab', 1, NULL, '2016-04-03 14:35:01'),
(158, 'VUV', 'Vanuatu Vatu', '&#86;&#84;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(159, 'WST', 'Samoa Tala', '&#87;&#83;&#36;', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(160, 'XAF', 'Communauté Financière Africaine (BEAC) CFA Franc B', '&#70;&#67;&#70;&#65;', 'F', 'F', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(161, 'XCD', 'East Caribbean Dollar', '&#36;', '$', '$', '36', '24', 1, NULL, '2016-04-03 14:35:01'),
(162, 'XDR', 'International Monetary Fund (IMF) Special Drawing ', '', NULL, NULL, NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(163, 'XOF', 'Communauté Financière Africaine (BCEAO) Franc', '&#70;&#67;&#70;&#65;', 'F', 'F', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(164, 'XPF', 'Comptoirs Français du Pacifique (CFP) Franc', '&#70;', 'F', 'F', NULL, NULL, 0, NULL, '2016-04-03 14:35:01'),
(165, 'YER', 'Yemen Rial', '&#65020;', '﷼', '﷼', '65020', 'fdfc', 0, NULL, '2016-04-03 14:35:01'),
(166, 'ZAR', 'South Africa Rand', '&#82;', 'R', 'R', '82', '52', 1, NULL, '2016-04-03 14:35:01'),
(167, 'ZMW', 'Zambia Kwacha', NULL, 'ZK', 'ZK', NULL, NULL, 0, NULL, NULL),
(168, 'ZWD', 'Zimbabwe Dollar', NULL, 'Z$', 'Z$', '90, 3', '5a, 2', 1, NULL, NULL),
(169, 'ZWL', 'Zimbabwe Dollar', NULL, 'Z$', 'Z$', '90, 3', '5a, 2', 1, NULL, NULL);

--
-- Truncate table before insert `gender`
--

TRUNCATE TABLE `gender`;
--
-- Dumping data for table `gender`
--

INSERT INTO `gender` (`id`, `translation_lang`, `translation_of`, `name`) VALUES
(1, 'en', 1, 'Mr'),
(2, 'en', 2, 'Mrs'),
(3, 'fr', 1, 'Monsieur'),
(4, 'fr', 2, 'Madame'),
(5, 'es', 1, 'Mr'),
(6, 'de', 1, 'Mr'),
(7, 'pt', 1, 'Mr'),
(8, 'es', 2, 'Mrs'),
(9, 'de', 2, 'Mrs'),
(10, 'pt', 2, 'Mrs');

--
-- Truncate table before insert `languages`
--

TRUNCATE TABLE `languages`;
--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `abbr`, `locale`, `name`, `native`, `flag`, `app_name`, `script`, `active`, `default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'en', 'en_US', 'English', 'English', '', 'english', 'Latn', 1, 1, NULL, NULL, NULL),
(3, 'fr', 'fr_FR', 'French', 'Français', '', 'french', 'Latn', 1, 0, NULL, NULL, NULL),
(5, 'es', 'es_ES', 'Spanish', 'Español', '', 'spanish', 'Latn', 1, 0, NULL, NULL, NULL),
(6, 'de', 'de_DE', 'German', 'Deutsch', '', 'german', 'Latn', 0, 0, NULL, NULL, NULL),
(7, 'pt', 'pt_PT', 'Portuguese', 'Portuguese', '', 'portuguese', 'Latn', 0, 0, NULL, NULL, NULL);

--
-- Truncate table before insert `packs`
--

TRUNCATE TABLE `packs`;
--
-- Dumping data for table `packs`
--

INSERT INTO `packs` (`id`, `translation_lang`, `translation_of`, `name`, `description`, `price`, `currency_code`, `parent_id`, `lft`, `rgt`, `depth`, `active`) VALUES
(1, 'en', 1, 'Regular List', 'Regular List', 0, 'USD', 0, 2, 3, 1, 1),
(2, 'en', 2, 'Urgent Ad', 'Urgent', 4, 'USD', 0, 6, 7, 1, 1),
(3, 'en', 3, 'Top page Ad', 'Top Ads', 7, 'USD', 0, 4, 5, 1, 1),
(4, 'en', 4, 'Top page Ad + Urgent Ad', 'Featured Ads', 9, 'USD', 0, 8, 9, 1, 0),
(8, 'fr', 1, 'Gratuit', 'Annonce gratuite', 0, 'USD', NULL, 2, 3, 1, 1),
(9, 'es', 1, 'Regular List', 'Regular List', 0, 'USD', NULL, 2, 3, 1, 1),
(10, 'fr', 2, 'Annonce urgente', 'Urgent', 4, 'USD', NULL, 6, 7, 1, 1),
(11, 'es', 2, 'Urgent Ad', 'Urgent', 4, 'USD', NULL, 6, 7, 1, 1),
(12, 'fr', 3, 'Top annonce', 'Annonce listée en haut de la page des résultats de recherche', 7, 'USD', NULL, 4, 5, 1, 1),
(13, 'es', 3, 'Top page Ad', 'Top Ads', 7, 'USD', NULL, 4, 5, 1, 1),
(14, 'fr', 4, 'Urgente + Top annonce', 'Urgente + Top annonce', 9, 'USD', NULL, 8, 9, 1, 1),
(15, 'es', 4, 'Top page Ad + Urgent Ad', 'Featured Ads', 9, 'USD', NULL, 8, 9, 1, 1);

--
-- Truncate table before insert `pages`
--

TRUNCATE TABLE `pages`;
--
-- Truncate table before insert `payment_methods`
--

TRUNCATE TABLE `payment_methods`;
--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `country_code`, `name`, `description`, `lft`, `rgt`, `depth`, `active`) VALUES
(1, NULL, 'Paypal', 'Paypal Express', NULL, NULL, NULL, 1);

--
-- Truncate table before insert `permissions`
--

TRUNCATE TABLE `permissions`;
--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'view-admin-panel', 'View Admin Panel', 'Access to the Admin Panel', '2016-05-05 16:53:32', '2016-05-05 16:53:32'),
(2, 'view-account-permissions', 'View Account Permissions', 'Show some demo info on the Admin Dashboard', '2016-05-05 16:53:32', '2016-05-05 16:53:32'),
(3, 'use-file-manager', 'Use File Manager', 'Access to upload/delete/edit files', '2016-05-05 16:53:32', '2016-05-05 16:53:32'),
(4, 'view-backups', 'View Backups', 'Access to the Backups Panel', '2016-05-05 16:53:32', '2016-05-05 16:53:32'),
(5, 'make-backups', 'Make Backups', 'Access to create new backups', '2016-05-05 16:53:32', '2016-05-05 16:53:32'),
(6, 'download-backups', 'Download Backups', 'Access to download existing backups', '2016-05-05 16:53:32', '2016-05-05 16:53:32'),
(7, 'delete-backups', 'Delete Backups', 'Access to delete existing backups', '2016-05-05 16:53:32', '2016-05-05 16:53:32'),
(8, 'view-logs', 'View Logs', NULL, '2016-05-05 16:53:32', '2016-05-05 16:53:32'),
(9, 'download-logs', 'Download Logs', NULL, '2016-05-05 16:53:32', '2016-05-05 16:53:32'),
(10, 'delete-logs', 'Delete Logs', NULL, '2016-05-05 16:53:32', '2016-05-05 16:53:32'),
(11, 'preview-logs', 'Preview Logs', NULL, '2016-05-05 16:53:32', '2016-05-05 16:53:32');

--
-- Truncate table before insert `permission_role`
--

TRUNCATE TABLE `permission_role`;
--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(1, 2),
(3, 2);

--
-- Truncate table before insert `report_type`
--

TRUNCATE TABLE `report_type`;
--
-- Dumping data for table `report_type`
--

INSERT INTO `report_type` (`id`, `translation_lang`, `translation_of`, `name`) VALUES
(2, 'en', 2, 'Fraud'),
(3, 'en', 3, 'Duplicate'),
(4, 'en', 4, 'Spam'),
(5, 'en', 5, 'Wrong category'),
(6, 'en', 6, 'Other');

--
-- Truncate table before insert `roles`
--

TRUNCATE TABLE `roles`;
--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'superadmin', 'SuperAdmin', 'Technical administrators: developers, webmins, etc', '2016-05-05 16:53:32', '2016-05-05 16:53:32'),
(2, 'admin', 'Admin', 'Users with access to the administration panel', '2016-05-05 16:53:32', '2016-05-05 16:53:32');

--
-- Truncate table before insert `time_zones`
--

TRUNCATE TABLE `time_zones`;
--
-- Dumping data for table `time_zones`
--

INSERT INTO `time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES
(1, 'AD', 'Europe/Andorra', 1, 2, 1),
(2, 'AE', 'Asia/Dubai', 4, 4, 4),
(3, 'AF', 'Asia/Kabul', 4.5, 4.5, 4.5),
(4, 'AG', 'America/Antigua', -4, -4, -4),
(5, 'AI', 'America/Anguilla', -4, -4, -4),
(6, 'AL', 'Europe/Tirane', 1, 2, 1),
(7, 'AM', 'Asia/Yerevan', 4, 4, 4),
(8, 'AO', 'Africa/Luanda', 1, 1, 1),
(9, 'AQ', 'Antarctica/Casey', 8, 8, 8),
(10, 'AR', 'America/Argentina/Buenos_Aires', -3, -3, -3),
(11, 'AS', 'Pacific/Pago_Pago', -11, -11, -11),
(12, 'AT', 'Europe/Vienna', 1, 2, 1),
(13, 'AU', 'Antarctica/Macquarie', 11, 11, 11),
(14, 'AW', 'America/Aruba', -4, -4, -4),
(15, 'AX', 'Europe/Mariehamn', 2, 3, 2),
(16, 'AZ', 'Asia/Baku', 4, 5, 4),
(17, 'BA', 'Europe/Sarajevo', 1, 2, 1),
(18, 'BB', 'America/Barbados', -4, -4, -4),
(19, 'BD', 'Asia/Dhaka', 6, 6, 6),
(20, 'BE', 'Europe/Brussels', 1, 2, 1),
(21, 'BF', 'Africa/Ouagadougou', 0, 0, 0),
(22, 'BG', 'Europe/Sofia', 2, 3, 2),
(23, 'BH', 'Asia/Bahrain', 3, 3, 3),
(24, 'BI', 'Africa/Bujumbura', 2, 2, 2),
(25, 'BJ', 'Africa/Porto-Novo', 1, 1, 1),
(26, 'BL', 'America/St_Barthelemy', -4, -4, -4),
(27, 'BM', 'Atlantic/Bermuda', -4, -3, -4),
(28, 'BN', 'Asia/Brunei', 8, 8, 8),
(29, 'BO', 'America/La_Paz', -4, -4, -4),
(30, 'BQ', 'America/Kralendijk', -4, -4, -4),
(31, 'BR', 'America/Araguaina', -3, -3, -3),
(32, 'BS', 'America/Nassau', -5, -4, -5),
(33, 'BT', 'Asia/Thimphu', 6, 6, 6),
(34, 'BW', 'Africa/Gaborone', 2, 2, 2),
(35, 'BY', 'Europe/Minsk', 3, 3, 3),
(36, 'BZ', 'America/Belize', -6, -6, -6),
(37, 'CA', 'America/Atikokan', -5, -5, -5),
(38, 'CC', 'Indian/Cocos', 6.5, 6.5, 6.5),
(39, 'CD', 'Africa/Kinshasa', 1, 1, 1),
(40, 'CF', 'Africa/Bangui', 1, 1, 1),
(41, 'CG', 'Africa/Brazzaville', 1, 1, 1),
(42, 'CH', 'Europe/Zurich', 1, 2, 1),
(43, 'CI', 'Africa/Abidjan', 0, 0, 0),
(44, 'CK', 'Pacific/Rarotonga', -10, -10, -10),
(45, 'CL', 'America/Santiago', -3, -3, -3),
(46, 'CM', 'Africa/Douala', 1, 1, 1),
(47, 'CN', 'Asia/Shanghai', 8, 8, 8),
(48, 'CO', 'America/Bogota', -5, -5, -5),
(49, 'CR', 'America/Costa_Rica', -6, -6, -6),
(50, 'CU', 'America/Havana', -5, -4, -5),
(51, 'CV', 'Atlantic/Cape_Verde', -1, -1, -1),
(52, 'CW', 'America/Curacao', -4, -4, -4),
(53, 'CX', 'Indian/Christmas', 7, 7, 7),
(54, 'CY', 'Asia/Nicosia', 2, 3, 2),
(55, 'CZ', 'Europe/Prague', 1, 2, 1),
(56, 'DE', 'Europe/Berlin', 1, 2, 1),
(57, 'DJ', 'Africa/Djibouti', 3, 3, 3),
(58, 'DK', 'Europe/Copenhagen', 1, 2, 1),
(59, 'DM', 'America/Dominica', -4, -4, -4),
(60, 'DO', 'America/Santo_Domingo', -4, -4, -4),
(61, 'DZ', 'Africa/Algiers', 1, 1, 1),
(62, 'EC', 'America/Guayaquil', -5, -5, -5),
(63, 'EE', 'Europe/Tallinn', 2, 3, 2),
(64, 'EG', 'Africa/Cairo', 2, 2, 2),
(65, 'EH', 'Africa/El_Aaiun', 0, 0, 0),
(66, 'ER', 'Africa/Asmara', 3, 3, 3),
(67, 'ES', 'Africa/Ceuta', 1, 2, 1),
(68, 'ET', 'Africa/Addis_Ababa', 3, 3, 3),
(69, 'FI', 'Europe/Helsinki', 2, 3, 2),
(70, 'FJ', 'Pacific/Fiji', 13, 12, 12),
(71, 'FK', 'Atlantic/Stanley', -3, -3, -3),
(72, 'FM', 'Pacific/Chuuk', 10, 10, 10),
(73, 'FO', 'Atlantic/Faroe', 0, 1, 0),
(74, 'FR', 'Europe/Paris', 1, 2, 1),
(75, 'GA', 'Africa/Libreville', 1, 1, 1),
(76, 'GD', 'America/Grenada', -4, -4, -4),
(77, 'GE', 'Asia/Tbilisi', 4, 4, 4),
(78, 'GF', 'America/Cayenne', -3, -3, -3),
(79, 'GG', 'Europe/Guernsey', 0, 1, 0),
(80, 'GH', 'Africa/Accra', 0, 0, 0),
(81, 'GI', 'Europe/Gibraltar', 1, 2, 1),
(82, 'GL', 'America/Danmarkshavn', 0, 0, 0),
(83, 'GM', 'Africa/Banjul', 0, 0, 0),
(84, 'GN', 'Africa/Conakry', 0, 0, 0),
(85, 'GP', 'America/Guadeloupe', -4, -4, -4),
(86, 'GQ', 'Africa/Malabo', 1, 1, 1),
(87, 'GR', 'Europe/Athens', 2, 3, 2),
(88, 'GS', 'Atlantic/South_Georgia', -2, -2, -2),
(89, 'GT', 'America/Guatemala', -6, -6, -6),
(90, 'GU', 'Pacific/Guam', 10, 10, 10),
(91, 'GW', 'Africa/Bissau', 0, 0, 0),
(92, 'GY', 'America/Guyana', -4, -4, -4),
(93, 'HK', 'Asia/Hong_Kong', 8, 8, 8),
(94, 'HN', 'America/Tegucigalpa', -6, -6, -6),
(95, 'HR', 'Europe/Zagreb', 1, 2, 1),
(96, 'HT', 'America/Port-au-Prince', -5, -4, -5),
(97, 'HU', 'Europe/Budapest', 1, 2, 1),
(98, 'ID', 'Asia/Jakarta', 7, 7, 7),
(99, 'IE', 'Europe/Dublin', 0, 1, 0),
(100, 'IL', 'Asia/Jerusalem', 2, 3, 2),
(101, 'IM', 'Europe/Isle_of_Man', 0, 1, 0),
(102, 'IN', 'Asia/Kolkata', 5.5, 5.5, 5.5),
(103, 'IO', 'Indian/Chagos', 6, 6, 6),
(104, 'IQ', 'Asia/Baghdad', 3, 3, 3),
(105, 'IR', 'Asia/Tehran', 3.5, 4.5, 3.5),
(106, 'IS', 'Atlantic/Reykjavik', 0, 0, 0),
(107, 'IT', 'Europe/Rome', 1, 2, 1),
(108, 'JE', 'Europe/Jersey', 0, 1, 0),
(109, 'JM', 'America/Jamaica', -5, -5, -5),
(110, 'JO', 'Asia/Amman', 2, 3, 2),
(111, 'JP', 'Asia/Tokyo', 9, 9, 9),
(112, 'KE', 'Africa/Nairobi', 3, 3, 3),
(113, 'KG', 'Asia/Bishkek', 6, 6, 6),
(114, 'KH', 'Asia/Phnom_Penh', 7, 7, 7),
(115, 'KI', 'Pacific/Enderbury', 13, 13, 13),
(116, 'KM', 'Indian/Comoro', 3, 3, 3),
(117, 'KN', 'America/St_Kitts', -4, -4, -4),
(118, 'KP', 'Asia/Pyongyang', 9, 9, 9),
(119, 'KR', 'Asia/Seoul', 9, 9, 9),
(120, 'KW', 'Asia/Kuwait', 3, 3, 3),
(121, 'KY', 'America/Cayman', -5, -5, -5),
(122, 'KZ', 'Asia/Almaty', 6, 6, 6),
(123, 'LA', 'Asia/Vientiane', 7, 7, 7),
(124, 'LB', 'Asia/Beirut', 2, 3, 2),
(125, 'LC', 'America/St_Lucia', -4, -4, -4),
(126, 'LI', 'Europe/Vaduz', 1, 2, 1),
(127, 'LK', 'Asia/Colombo', 5.5, 5.5, 5.5),
(128, 'LR', 'Africa/Monrovia', 0, 0, 0),
(129, 'LS', 'Africa/Maseru', 2, 2, 2),
(130, 'LT', 'Europe/Vilnius', 2, 3, 2),
(131, 'LU', 'Europe/Luxembourg', 1, 2, 1),
(132, 'LV', 'Europe/Riga', 2, 3, 2),
(133, 'LY', 'Africa/Tripoli', 2, 2, 2),
(134, 'MA', 'Africa/Casablanca', 0, 0, 0),
(135, 'MC', 'Europe/Monaco', 1, 2, 1),
(136, 'MD', 'Europe/Chisinau', 2, 3, 2),
(137, 'ME', 'Europe/Podgorica', 1, 2, 1),
(138, 'MF', 'America/Marigot', -4, -4, -4),
(139, 'MG', 'Indian/Antananarivo', 3, 3, 3),
(140, 'MH', 'Pacific/Kwajalein', 12, 12, 12),
(141, 'MK', 'Europe/Skopje', 1, 2, 1),
(142, 'ML', 'Africa/Bamako', 0, 0, 0),
(143, 'MM', 'Asia/Rangoon', 6.5, 6.5, 6.5),
(144, 'MN', 'Asia/Choibalsan', 8, 8, 8),
(145, 'MO', 'Asia/Macau', 8, 8, 8),
(146, 'MP', 'Pacific/Saipan', 10, 10, 10),
(147, 'MQ', 'America/Martinique', -4, -4, -4),
(148, 'MR', 'Africa/Nouakchott', 0, 0, 0),
(149, 'MS', 'America/Montserrat', -4, -4, -4),
(150, 'MT', 'Europe/Malta', 1, 2, 1),
(151, 'MU', 'Indian/Mauritius', 4, 4, 4),
(152, 'MV', 'Indian/Maldives', 5, 5, 5),
(153, 'MW', 'Africa/Blantyre', 2, 2, 2),
(154, 'MX', 'America/Bahia_Banderas', -6, -5, -6),
(155, 'MY', 'Asia/Kuala_Lumpur', 8, 8, 8),
(156, 'MZ', 'Africa/Maputo', 2, 2, 2),
(157, 'NA', 'Africa/Windhoek', 2, 1, 1),
(158, 'NC', 'Pacific/Noumea', 11, 11, 11),
(159, 'NE', 'Africa/Niamey', 1, 1, 1),
(160, 'NF', 'Pacific/Norfolk', 11.5, 11.5, 11.5),
(161, 'NG', 'Africa/Lagos', 1, 1, 1),
(162, 'NI', 'America/Managua', -6, -6, -6),
(163, 'NL', 'Europe/Amsterdam', 1, 2, 1),
(164, 'NO', 'Europe/Oslo', 1, 2, 1),
(165, 'NP', 'Asia/Kathmandu', 5.75, 5.75, 5.75),
(166, 'NR', 'Pacific/Nauru', 12, 12, 12),
(167, 'NU', 'Pacific/Niue', -11, -11, -11),
(168, 'NZ', 'Pacific/Auckland', 13, 12, 12),
(169, 'OM', 'Asia/Muscat', 4, 4, 4),
(170, 'PA', 'America/Panama', -5, -5, -5),
(171, 'PE', 'America/Lima', -5, -5, -5),
(172, 'PF', 'Pacific/Gambier', -9, -9, -9),
(173, 'PG', 'Pacific/Bougainville', 11, 11, 11),
(174, 'PH', 'Asia/Manila', 8, 8, 8),
(175, 'PK', 'Asia/Karachi', 5, 5, 5),
(176, 'PL', 'Europe/Warsaw', 1, 2, 1),
(177, 'PM', 'America/Miquelon', -3, -2, -3),
(178, 'PN', 'Pacific/Pitcairn', -8, -8, -8),
(179, 'PR', 'America/Puerto_Rico', -4, -4, -4),
(180, 'PS', 'Asia/Gaza', 2, 3, 2),
(181, 'PT', 'Atlantic/Azores', -1, 0, -1),
(182, 'PW', 'Pacific/Palau', 9, 9, 9),
(183, 'PY', 'America/Asuncion', -3, -4, -4),
(184, 'QA', 'Asia/Qatar', 3, 3, 3),
(185, 'RE', 'Indian/Reunion', 4, 4, 4),
(186, 'RO', 'Europe/Bucharest', 2, 3, 2),
(187, 'RS', 'Europe/Belgrade', 1, 2, 1),
(188, 'RU', 'Asia/Anadyr', 12, 12, 12),
(189, 'RW', 'Africa/Kigali', 2, 2, 2),
(190, 'SA', 'Asia/Riyadh', 3, 3, 3),
(191, 'SB', 'Pacific/Guadalcanal', 11, 11, 11),
(192, 'SC', 'Indian/Mahe', 4, 4, 4),
(193, 'SD', 'Africa/Khartoum', 3, 3, 3),
(194, 'SE', 'Europe/Stockholm', 1, 2, 1),
(195, 'SG', 'Asia/Singapore', 8, 8, 8),
(196, 'SH', 'Atlantic/St_Helena', 0, 0, 0),
(197, 'SI', 'Europe/Ljubljana', 1, 2, 1),
(198, 'SJ', 'Arctic/Longyearbyen', 1, 2, 1),
(199, 'SK', 'Europe/Bratislava', 1, 2, 1),
(200, 'SL', 'Africa/Freetown', 0, 0, 0),
(201, 'SM', 'Europe/San_Marino', 1, 2, 1),
(202, 'SN', 'Africa/Dakar', 0, 0, 0),
(203, 'SO', 'Africa/Mogadishu', 3, 3, 3),
(204, 'SR', 'America/Paramaribo', -3, -3, -3),
(205, 'SS', 'Africa/Juba', 3, 3, 3),
(206, 'ST', 'Africa/Sao_Tome', 0, 0, 0),
(207, 'SV', 'America/El_Salvador', -6, -6, -6),
(208, 'SX', 'America/Lower_Princes', -4, -4, -4),
(209, 'SY', 'Asia/Damascus', 2, 3, 2),
(210, 'SZ', 'Africa/Mbabane', 2, 2, 2),
(211, 'TC', 'America/Grand_Turk', -5, -4, -5),
(212, 'TD', 'Africa/Ndjamena', 1, 1, 1),
(213, 'TF', 'Indian/Kerguelen', 5, 5, 5),
(214, 'TG', 'Africa/Lome', 0, 0, 0),
(215, 'TH', 'Asia/Bangkok', 7, 7, 7),
(216, 'TJ', 'Asia/Dushanbe', 5, 5, 5),
(217, 'TK', 'Pacific/Fakaofo', 13, 13, 13),
(218, 'TL', 'Asia/Dili', 9, 9, 9),
(219, 'TM', 'Asia/Ashgabat', 5, 5, 5),
(220, 'TN', 'Africa/Tunis', 1, 1, 1),
(221, 'TO', 'Pacific/Tongatapu', 13, 13, 13),
(222, 'TR', 'Europe/Istanbul', 2, 3, 2),
(223, 'TT', 'America/Port_of_Spain', -4, -4, -4),
(224, 'TV', 'Pacific/Funafuti', 12, 12, 12),
(225, 'TW', 'Asia/Taipei', 8, 8, 8),
(226, 'TZ', 'Africa/Dar_es_Salaam', 3, 3, 3),
(227, 'UA', 'Europe/Kiev', 2, 3, 2),
(228, 'UG', 'Africa/Kampala', 3, 3, 3),
(229, 'UK', 'Europe/London', 0, 1, 0),
(230, 'UM', 'Pacific/Johnston', -10, -10, -10),
(231, 'US', 'America/Adak', -10, -9, -10),
(232, 'UY', 'America/Montevideo', -2, -3, -3),
(233, 'UZ', 'Asia/Samarkand', 5, 5, 5),
(234, 'VA', 'Europe/Vatican', 1, 2, 1),
(235, 'VC', 'America/St_Vincent', -4, -4, -4),
(236, 'VE', 'America/Caracas', -4.5, -4.5, -4.5),
(237, 'VG', 'America/Tortola', -4, -4, -4),
(238, 'VI', 'America/St_Thomas', -4, -4, -4),
(239, 'VN', 'Asia/Ho_Chi_Minh', 7, 7, 7),
(240, 'VU', 'Pacific/Efate', 11, 11, 11),
(241, 'WF', 'Pacific/Wallis', 12, 12, 12),
(242, 'WS', 'Pacific/Apia', 14, 13, 13),
(243, 'YE', 'Asia/Aden', 3, 3, 3),
(244, 'YT', 'Indian/Mayotte', 3, 3, 3),
(245, 'ZA', 'Africa/Johannesburg', 2, 2, 2),
(246, 'ZM', 'Africa/Lusaka', 2, 2, 2),
(247, 'ZW', 'Africa/Harare', 2, 2, 2);

--
-- Truncate table before insert `user_type`
--

TRUNCATE TABLE `user_type`;
--
-- Dumping data for table `user_type`
--

INSERT INTO `user_type` (`id`, `name`, `active`) VALUES
(1, 'Admin', 0),
(2, 'Professional', 1),
(3, 'Individual', 1);

