-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `housgcjs_prosphere`
--

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

--
-- Table structure for table `soft_addon_types`
--

CREATE TABLE IF NOT EXISTS `soft_addon_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `sign` varchar(10) NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`id`),
  KEY `sign` (`sign`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `soft_addon_types`
--

INSERT INTO `soft_addon_types` (`id`, `name`, `sign`, `del`) VALUES
(1, 'N/A', 'N/A', 'Y'),
(2, 'Percentage', '%', 'N'),
(3, 'Rupees', 'Rs', 'N');

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

--
-- Table structure for table `soft_cities`
--

CREATE TABLE IF NOT EXISTS `soft_cities` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=510 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `soft_cities`
--

INSERT INTO `soft_cities` (`id`, `name`, `del`) VALUES
(1, 'Islamabad', 'N'),
(2, 'Karachi', 'N'),
(3, 'Lahore', 'N'),
(4, 'Abbaspur', 'N'),
(5, 'Abbottabad', 'N'),
(6, 'Abdul Hakim', 'N'),
(7, 'Adda Jahan Khan', 'N'),
(8, 'Adda Shaiwala', 'N'),
(9, 'Ahmadpur East', 'N'),
(10, 'Ahmed pur Sial', 'N'),
(11, 'Akhora Khattak', 'N'),
(12, 'Ali Chak', 'N'),
(13, 'Alipur', 'N'),
(14, 'Allahabad', 'N'),
(15, 'Amangarh', 'N'),
(16, 'Ambela', 'N'),
(17, 'Arifwala', 'N'),
(18, 'Astore', 'N'),
(19, 'Attock', 'N'),
(20, 'Babri Banda', 'N'),
(21, 'Badin', 'N'),
(22, 'Bagh', 'N'),
(23, 'Bahawalnagar', 'N'),
(24, 'Bahawalpur', 'N'),
(25, 'Bajaur', 'N'),
(26, 'Balakot', 'N'),
(27, 'Bannu', 'N'),
(28, 'Barbar Loi', 'N'),
(29, 'Barkhan', 'N'),
(30, 'Baroute', 'N'),
(31, 'Bat Khela', 'N'),
(32, 'Battagram', 'N'),
(33, 'Besham', 'N'),
(34, 'Bewal', 'N'),
(35, 'Bhakkar', 'N'),
(36, 'Bhalwal', 'N'),
(37, 'Bhan Saeedabad', 'N'),
(38, 'Bhara Kahu', 'N'),
(39, 'Bhera', 'N'),
(40, 'Bhimbar', 'N'),
(41, 'Bhirya Road', 'N'),
(42, 'Bhuawana', 'N'),
(43, 'Bisham', 'N'),
(44, 'Blitang', 'N'),
(45, 'Bolan', 'N'),
(46, 'Buchay Key', 'N'),
(47, 'Bunner', 'N'),
(48, 'Burewala', 'N'),
(49, 'Chacklala', 'N'),
(50, 'Chaghi', 'N'),
(51, 'Chaininda', 'N'),
(52, 'Chak 4 b c', 'N'),
(53, 'Chak 46', 'N'),
(54, 'Chak Jamal', 'N'),
(55, 'Chak Jhumra', 'N'),
(56, 'Chak Sawara', 'N'),
(57, 'Chak Sheza', 'N'),
(58, 'Chakwal', 'N'),
(59, 'Chaman', 'N'),
(60, 'Charsada', 'N'),
(61, 'Chashma', 'N'),
(62, 'Chawinda', 'N'),
(63, 'Cherat', 'N'),
(64, 'Chicha watni', 'N'),
(65, 'Chilas', 'N'),
(66, 'Chiniot', 'N'),
(67, 'Chishtian', 'N'),
(68, 'Chitral', 'N'),
(69, 'Choa Saiden Shah', 'N'),
(70, 'Chohar Jamali', 'N'),
(71, 'Choppar Hatta', 'N'),
(72, 'Chowk Azam', 'N'),
(73, 'Chowk Maitla', 'N'),
(74, 'Chowk Munda', 'N'),
(75, 'Chunian', 'N'),
(76, 'Dadakhel', 'N'),
(77, 'Dadu', 'N'),
(78, 'Daharki', 'N'),
(79, 'Dandot', 'N'),
(80, 'Dargai', 'N'),
(81, 'Darra Pezu', 'N'),
(82, 'Darya Khan', 'N'),
(83, 'Daska', 'N'),
(84, 'Dassu', 'N'),
(85, 'Daud Khel', 'N'),
(86, 'Daulat Pur', 'N'),
(87, 'Daur', 'N'),
(88, 'Deh Pathaan', 'N'),
(89, 'Depal Pur', 'N'),
(90, 'Dera Bugti', 'N'),
(91, 'Dera Ghazi Khan', 'N'),
(92, 'Dera Ismail Khan', 'N'),
(93, 'Dera Murad Jamali', 'N'),
(94, 'Dera Nawab Sahib', 'N'),
(95, 'Dhatmal', 'N'),
(96, 'Dhirkot', 'N'),
(97, 'Dhoun Kal', 'N'),
(98, 'Diamer', 'N'),
(99, 'Digri', 'N'),
(100, 'Dijkot', 'N'),
(101, 'Dina', 'N'),
(102, 'Dinga', 'N'),
(103, 'Dir', 'N'),
(104, 'Doaaba', 'N'),
(105, 'Doltala', 'N'),
(106, 'Domeli', 'N'),
(107, 'Dudial', 'N'),
(108, 'Dunyapur', 'N'),
(109, 'Eminabad', 'N'),
(110, 'Faisalabad', 'N'),
(111, 'Farooqabad', 'N'),
(112, 'Fateh Jang', 'N'),
(113, 'Fateh Pur', 'N'),
(114, 'Feroz Walla', 'N'),
(115, 'Feroz Watan', 'N'),
(116, 'Fizagat', 'N'),
(117, 'Fort Abbas', 'N'),
(118, 'FR Bannu', 'N'),
(119, 'FR Bannu / Lakki', 'N'),
(120, 'FR DI Khan', 'N'),
(121, 'FR Kohat', 'N'),
(122, 'FR Peshawar', 'N'),
(123, 'FR Peshawar / Kohat', 'N'),
(124, 'FR Tank / DI Khan', 'N'),
(125, 'Gadoon Amazai', 'N'),
(126, 'Gaggo Mandi', 'N'),
(127, 'Gakhar Mandi', 'N'),
(128, 'Gambet', 'N'),
(129, 'Garh Maharaja', 'N'),
(130, 'Garh More', 'N'),
(131, 'Gari Habibullah', 'N'),
(132, 'Gari Mori', 'N'),
(133, 'Ghari Dupatta', 'N'),
(134, 'Gharo', 'N'),
(135, 'Ghazi', 'N'),
(136, 'Ghizer', 'N'),
(137, 'Ghotki', 'N'),
(138, 'Ghuzdar', 'N'),
(139, 'Gilgit', 'N'),
(140, 'Gohar Ghoushti', 'N'),
(141, 'Gojra', 'N'),
(142, 'Goular Khel', 'N'),
(143, 'Guddu', 'N'),
(144, 'Gujar Khan', 'N'),
(145, 'Gujranwala', 'N'),
(146, 'Gujrat', 'N'),
(147, 'Gwadar', 'N'),
(148, 'Hafizabad', 'N'),
(149, 'Hala', 'N'),
(150, 'Hangu', 'N'),
(151, 'Hari Pur', 'N'),
(152, 'Hariwala', 'N'),
(153, 'Harnai', 'N'),
(154, 'Haroonabad', 'N'),
(155, 'Hasilpur', 'N'),
(156, 'Hassan Abdal', 'N'),
(157, 'Hattar', 'N'),
(158, 'Hattian', 'N'),
(159, 'Haveli Kahuta', 'N'),
(160, 'Haveli Lakha', 'N'),
(161, 'Havelian', 'N'),
(162, 'Hayatabad', 'N'),
(163, 'Hazro', 'N'),
(164, 'Head Marala', 'N'),
(165, 'Hub Chowki', 'N'),
(166, 'Hub Inds Estate', 'N'),
(167, 'Hujra Shah Muqeem', 'N'),
(168, 'Hunza Nagar', 'N'),
(169, 'Hyderabad', 'N'),
(170, 'Issa Khel', 'N'),
(171, 'Jacobabad', 'N'),
(172, 'Jaffarabad', 'N'),
(173, 'Jaja Abasian', 'N'),
(174, 'Jalal Pur Jatan', 'N'),
(175, 'Jalal Pur Priwala', 'N'),
(176, 'Jalozai', 'N'),
(177, 'Jampur', 'N'),
(178, 'Jamrud Road', 'N'),
(179, 'Jamshoro', 'N'),
(180, 'Jandanwala', 'N'),
(181, 'Jaranwala', 'N'),
(182, 'Jatoi', 'N'),
(183, 'Jauharabad', 'N'),
(184, 'Jehangira', 'N'),
(185, 'Jehanian', 'N'),
(186, 'Jhal Magsi', 'N'),
(187, 'Jhand', 'N'),
(188, 'Jhang', 'N'),
(189, 'Jhatta Bhutta', 'N'),
(190, 'Jhelum', 'N'),
(191, 'Jhudo', 'N'),
(192, 'Kabir Wala', 'N'),
(193, 'Kacha Khooh', 'N'),
(194, 'Kachhi/Bolan', 'N'),
(195, 'Kahror Pacca', 'N'),
(196, 'Kahuta', 'N'),
(197, 'Kakul', 'N'),
(198, 'Kakur Town', 'N'),
(199, 'Kala Bagh', 'N'),
(200, 'Kala Shah Kaku', 'N'),
(201, 'Kalam', 'N'),
(202, 'Kalar Syedian', 'N'),
(203, 'Kalaswala', 'N'),
(204, 'Kallat', 'N'),
(205, 'Kallur Kot', 'N'),
(206, 'Kamalia', 'N'),
(207, 'Kamalia Musa', 'N'),
(208, 'Kamber Ali Khan', 'N'),
(209, 'Kamokey', 'N'),
(210, 'Kamra', 'N'),
(211, 'Kandhkot', 'N'),
(212, 'Kandiaro', 'N'),
(213, 'Karak', 'N'),
(214, 'Karore Lalisan', 'N'),
(215, 'Kashmir', 'N'),
(216, 'Kashmore', 'N'),
(217, 'Kasur', 'N'),
(218, 'Kazi Ahmed', 'N'),
(219, 'Kech', 'N'),
(220, 'Khair Pur', 'N'),
(221, 'Khair Pur Mir', 'N'),
(222, 'Khairpur Nathan Shah', 'N'),
(223, 'Khanbela', 'N'),
(224, 'Khandabad', 'N'),
(225, 'Khanewal', 'N'),
(226, 'Khangarh', 'N'),
(227, 'Khanpur', 'N'),
(228, 'Khanqah Dogran', 'N'),
(229, 'Khanqah Sharif', 'N'),
(230, 'Kharan', 'N'),
(231, 'Kharian', 'N'),
(232, 'Khewra', 'N'),
(233, 'Khoski', 'N'),
(234, 'Khuiratta', 'N'),
(235, 'Khurian wala', 'N'),
(236, 'Khushab', 'N'),
(237, 'Khushal Kot', 'N'),
(238, 'Khuzdar', 'N'),
(239, 'Khyber Agency', 'N'),
(240, 'Killa Abdullah', 'N'),
(241, 'Killa Saifullah', 'N'),
(242, 'Kohat', 'N'),
(243, 'Kohistan', 'N'),
(244, 'Kohlu', 'N'),
(245, 'Kot Addu', 'N'),
(246, 'Kot Bunglow', 'N'),
(247, 'Kot Ghulam Mohd', 'N'),
(248, 'Kot Mithan', 'N'),
(249, 'Kot Radha Kishan', 'N'),
(250, 'Kotla', 'N'),
(251, 'Kotla Arab Ali Khan', 'N'),
(252, 'Kotla Jam', 'N'),
(253, 'Kotla Pathan', 'N'),
(254, 'Kotli', 'N'),
(255, 'Kotli Loharan', 'N'),
(256, 'Kotmomin', 'N'),
(257, 'Kotri', 'N'),
(258, 'Kumbh', 'N'),
(259, 'Kundina', 'N'),
(260, 'Kunjah', 'N'),
(261, 'Kunri', 'N'),
(262, 'Kurram', 'N'),
(263, 'Kurram Agency', 'N'),
(264, 'Lakimarwat', 'N'),
(265, 'Lakki Marwat', 'N'),
(266, 'Lala rukh', 'N'),
(267, 'Lalamusa', 'N'),
(268, 'Laliah', 'N'),
(269, 'Lalshanra', 'N'),
(270, 'Landi Kotal', 'N'),
(271, 'Larkana', 'N'),
(272, 'Lasbela', 'N'),
(273, 'Lawrence pur', 'N'),
(274, 'Layyah', 'N'),
(275, 'Leepa', 'N'),
(276, 'Liaquat Pur', 'N'),
(277, 'Lodhran', 'N'),
(278, 'Loralai', 'N'),
(279, 'Lower Dir', 'N'),
(280, 'Ludhan', 'N'),
(281, 'Machh', 'N'),
(282, 'Machi Goth', 'N'),
(283, 'Madinah', 'N'),
(284, 'Mailsi', 'N'),
(285, 'Makli', 'N'),
(286, 'Makran', 'N'),
(287, 'Malakand', 'N'),
(288, 'Malakwal', 'N'),
(289, 'Mamu kunjan', 'N'),
(290, 'Mandi Bahauddin', 'N'),
(291, 'Mandi Faizabad', 'N'),
(292, 'Mandra', 'N'),
(293, 'Manga Mandi', 'N'),
(294, 'Mangal Sada', 'N'),
(295, 'Mangi', 'N'),
(296, 'Mangla', 'N'),
(297, 'Mangowal', 'N'),
(298, 'Manoabad', 'N'),
(299, 'Mansehra', 'N'),
(300, 'Mardan', 'N'),
(301, 'Mari Indus', 'N'),
(302, 'Mastoi', 'N'),
(303, 'Matiari', 'N'),
(304, 'Matli', 'N'),
(305, 'Mehar', 'N'),
(306, 'Mehmood Kot', 'N'),
(307, 'Mehrab Pur', 'N'),
(308, 'Mian Chunnu', 'N'),
(309, 'Mian Walli', 'N'),
(310, 'Minchanabad', 'N'),
(311, 'Mingora', 'N'),
(312, 'Mir Ali', 'N'),
(313, 'Miran Shah', 'N'),
(314, 'Mirpur  (AJK)', 'N'),
(315, 'Mirpur Khas', 'N'),
(316, 'Mirpur Mathelo', 'N'),
(317, 'Mithi', 'N'),
(318, 'Mohen Jo Daro', 'N'),
(319, 'Mohmand', 'N'),
(320, 'More kunda', 'N'),
(321, 'Morgah', 'N'),
(322, 'Moro', 'N'),
(323, 'Mubarik Pur', 'N'),
(324, 'Multan', 'N'),
(325, 'Muridkay', 'N'),
(326, 'Murree', 'N'),
(327, 'Musafir Khana', 'N'),
(328, 'Musakhel', 'N'),
(329, 'Mustang', 'N'),
(330, 'Muzaffarabad', 'N'),
(331, 'Muzaffargarh', 'N'),
(332, 'Nankana Sahib', 'N'),
(333, 'Narang Mandi', 'N'),
(334, 'Narowal', 'N'),
(335, 'Naseerabad', 'N'),
(336, 'Naudero', 'N'),
(337, 'Naukot', 'N'),
(338, 'Naukundi', 'N'),
(339, 'Nawab Shah', 'N'),
(340, 'Neelam', 'N'),
(341, 'New Saeedabad', 'N'),
(342, 'Nilam', 'N'),
(343, 'Nilore', 'N'),
(344, 'Noor kot', 'N'),
(345, 'Nooriabad', 'N'),
(346, 'Noorpur nooranga', 'N'),
(347, 'North Wazirstan', 'N'),
(348, 'Noshki', 'N'),
(349, 'Nowshera', 'N'),
(350, 'Nowshera Cantt', 'N'),
(351, 'Nowshero Feroz', 'N'),
(352, 'Okara', 'N'),
(353, 'Orakzai', 'N'),
(354, 'Padidan', 'N'),
(355, 'Pak Pattan Sharif', 'N'),
(356, 'Panjan Kisan', 'N'),
(357, 'Panjgur', 'N'),
(358, 'Pannu aqil', 'N'),
(359, 'Parachinar', 'N'),
(360, 'Pasni', 'N'),
(361, 'Pasroor', 'N'),
(362, 'Patika', 'N'),
(363, 'Patoki', 'N'),
(364, 'Peshawar', 'N'),
(365, 'Phagwar', 'N'),
(366, 'Phalia', 'N'),
(367, 'Phool nagar', 'N'),
(368, 'Phoolnagar (Bhai Pheru)', 'N'),
(369, 'Piaro goth', 'N'),
(370, 'Pind Dadan Khan', 'N'),
(371, 'Pindi Bhattian', 'N'),
(372, 'Pindi bhohri', 'N'),
(373, 'Pindi gheb', 'N'),
(374, 'Piplan', 'N'),
(375, 'Pir Mahal', 'N'),
(376, 'Pirpai', 'N'),
(377, 'Pishin', 'N'),
(378, 'Poonch', 'N'),
(379, 'Punch', 'N'),
(380, 'Qalandarabad', 'N'),
(381, 'Qambar', 'N'),
(382, 'Qambar Shahdatkot', 'N'),
(383, 'Qasba Gujrat', 'N'),
(384, 'Qazi Ahmed', 'N'),
(385, 'Quaidabad', 'N'),
(386, 'Quetta', 'N'),
(387, 'Rabwah', 'N'),
(388, 'Rahimyar Khan', 'N'),
(389, 'Rahwali', 'N'),
(390, 'Raiwind', 'N'),
(391, 'Rajana', 'N'),
(392, 'Rajanpur', 'N'),
(393, 'Rangoo', 'N'),
(394, 'Ranipur', 'N'),
(395, 'Rashidabad', 'N'),
(396, 'Ratto Dero', 'N'),
(397, 'Rawala Kot', 'N'),
(398, 'Rawalpindi', 'N'),
(399, 'Rawat', 'N'),
(400, 'Renala Khurd', 'N'),
(401, 'Risalpur', 'N'),
(402, 'Rohri', 'N'),
(403, 'Sadiqabad', 'N'),
(404, 'Sagri', 'N'),
(405, 'Sahiwal', 'N'),
(406, 'Saidu Sharif', 'N'),
(407, 'Sajawal', 'N'),
(408, 'Sakardu', 'N'),
(409, 'Sakrand', 'N'),
(410, 'Sambrial', 'N'),
(411, 'Samma Satta', 'N'),
(412, 'Samundri', 'N'),
(413, 'Sanghar', 'N'),
(414, 'Sanghi', 'N'),
(415, 'Sangla Hill', 'N'),
(416, 'Sangote', 'N'),
(417, 'Sanjwal', 'N'),
(418, 'Sara e Naurang', 'N'),
(419, 'Sarai Alamgir', 'N'),
(420, 'Sargodha', 'N'),
(421, 'Satyana Bangla', 'N'),
(422, 'Sehar Baqlas', 'N'),
(423, 'Sehwan', 'N'),
(424, 'Shadiwal', 'N'),
(425, 'Shahdad Kot', 'N'),
(426, 'Shahdad Pur', 'N'),
(427, 'Shaheed Benazirabad', 'N'),
(428, 'Shahkot', 'N'),
(429, 'Shahpur Chakar', 'N'),
(430, 'Shakargarh', 'N'),
(431, 'Shamsabad', 'N'),
(432, 'Shangla', 'N'),
(433, 'Shankiari', 'N'),
(434, 'Shedani sharif', 'N'),
(435, 'Sheikhupura', 'N'),
(436, 'Shemier', 'N'),
(437, 'Sherani', 'N'),
(438, 'Shikarpur', 'N'),
(439, 'Shogram', 'N'),
(440, 'Shorkot', 'N'),
(441, 'Shujabad', 'N'),
(442, 'Sialkot', 'N'),
(443, 'Sibi', 'N'),
(444, 'Sidhnoti', 'N'),
(445, 'Sihala', 'N'),
(446, 'Sikandarabad', 'N'),
(447, 'Silanwala', 'N'),
(448, 'Sita Road', 'N'),
(449, 'Skardu', 'N'),
(450, 'Sohawa District Daska', 'N'),
(451, 'Sohawa District Jelum', 'N'),
(452, 'Sohbatpur', 'N'),
(453, 'South Wazirstan', 'N'),
(454, 'Sudhnoti', 'N'),
(455, 'Sukkur', 'N'),
(456, 'Swabi', 'N'),
(457, 'Swat', 'N'),
(458, 'Swatmingora', 'N'),
(459, 'Takhtbai', 'N'),
(460, 'Talagang', 'N'),
(461, 'Talamba', 'N'),
(462, 'Talhur', 'N'),
(463, 'Tall', 'N'),
(464, 'Tando Adam', 'N'),
(465, 'Tando Allahyar', 'N'),
(466, 'Tando Jam', 'N'),
(467, 'Tando Mohd Khan', 'N'),
(468, 'Tank', 'N'),
(469, 'Tarbela', 'N'),
(470, 'Tarmatan', 'N'),
(471, 'Tarnol', 'N'),
(472, 'Taunsa sharif', 'N'),
(473, 'Taxila', 'N'),
(474, 'Thana Bula Khan', 'N'),
(475, 'Thari Mirwah', 'N'),
(476, 'Tharo Shah', 'N'),
(477, 'Tharparkar', 'N'),
(478, 'Thatta', 'N'),
(479, 'Theing Jattan More', 'N'),
(480, 'Thul', 'N'),
(481, 'Tibba Sultanpur', 'N'),
(482, 'Timergara', 'N'),
(483, 'Tobatek Singh', 'N'),
(484, 'Topi', 'N'),
(485, 'Toru', 'N'),
(486, 'Trinda Mohd Pannah', 'N'),
(487, 'Turbat', 'N'),
(488, 'Ubaro', 'N'),
(489, 'Ugoki', 'N'),
(490, 'Ukba', 'N'),
(491, 'Umer Kot', 'N'),
(492, 'Upper Deval', 'N'),
(493, 'Upper Dir', 'N'),
(494, 'Usta Mohammad', 'N'),
(495, 'Utror', 'N'),
(496, 'Vehari', 'N'),
(497, 'Village Sunder', 'N'),
(498, 'Wah Cantt', 'N'),
(499, 'Wahi hassain', 'N'),
(500, 'Wan Radha Ram', 'N'),
(501, 'Wana', 'N'),
(502, 'Warah', 'N'),
(503, 'Warburton', 'N'),
(504, 'Washuk', 'N'),
(505, 'Wazirabad', 'N'),
(506, 'Yazman Mandi', 'N'),
(507, 'Zahir Pir', 'N'),
(508, 'Zhob', 'N'),
(509, 'Ziarat', 'N');

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

--
-- Table structure for table `soft_countries`
--

CREATE TABLE IF NOT EXISTS `soft_countries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `country` varchar(32) DEFAULT NULL,
  `iso2` varchar(2) DEFAULT NULL,
  `iso3` varchar(3) DEFAULT NULL,
  `top_level_domain` varchar(2) DEFAULT NULL,
  `fips` varchar(2) DEFAULT NULL,
  `iso_numeric` int DEFAULT NULL,
  `geo_name_id` varchar(7) DEFAULT NULL,
  `e164` int DEFAULT NULL,
  `country_code` varchar(19) DEFAULT NULL,
  `continent` varchar(13) DEFAULT NULL,
  `capital` varchar(20) DEFAULT NULL,
  `timezone` varchar(30) DEFAULT NULL,
  `currency` varchar(13) DEFAULT NULL,
  `languages_codes` varchar(89) DEFAULT NULL,
  `languages` varchar(489) DEFAULT NULL,
  `areakm2` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=241 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `soft_countries`
--

INSERT INTO `soft_countries` (`id`, `country`, `iso2`, `iso3`, `top_level_domain`, `fips`, `iso_numeric`, `geo_name_id`, `e164`, `country_code`, `continent`, `capital`, `timezone`, `currency`, `languages_codes`, `languages`, `areakm2`) VALUES
(1, 'Afghanistan', 'AF', 'AFG', 'af', 'AF', 4, '1149361', 93, '93', 'Asia', 'Kabul', 'Asia/Kabul', 'Afghani', 'fa-AF,ps,uz-AF,tk', 'Afghan Persian or Dari (official) 50%, Pashto (official) 35%, Turkic languages (primarily Uzbek and Turkmen) 11%, 30 minor languages (primarily Balochi and Pashai) 4%, much bilingualism, but Dari functions as the lingua franca', 647500),
(2, 'Albania', 'AL', 'ALB', 'al', 'AL', 8, '783754', 355, '355', 'Europe', 'Tirana', 'Europe/Tirane', 'Lek', 'sq,el', 'Albanian 98.8% (official - derived from Tosk dialect), Greek 0.5%, other 0.6% (including Macedonian, Roma, Vlach, Turkish, Italian, and Serbo-Croatian), unspecified 0.1% (2011 est.)', 28748),
(3, 'Algeria', 'DZ', 'DZA', 'dz', 'AG', 12, '2589581', 213, '213', 'Africa', 'Algiers', 'Africa/Algiers', 'Dinar', 'ar-DZ', 'Arabic (official), French (lingua franca), Berber dialects: Kabylie Berber (Tamazight), Chaouia Berber (Tachawit), Mzab Berber, Tuareg Berber (Tamahaq)', 2381740),
(4, 'American Samoa', 'AS', 'ASM', 'as', 'AQ', 16, '5880801', 1, '1684', 'Oceania', 'Pago Pago', 'Pacific/Pago_Pago', 'Dollar', 'en-AS,sm,to', 'Samoan 90.6% (closely related to Hawaiian and other Polynesian languages), English 2.9%, Tongan 2.4%, other Pacific islander 2.1%, other 2%', 199),
(5, 'Andorra', 'AD', 'AND', 'ad', 'AN', 20, '3041565', 376, '376', 'Europe', 'Andorra la Vella', 'Europe/Andorra', 'Euro', 'ca', 'Catalan (official), French, Castilian, Portuguese', 468),
(6, 'Angola', 'AO', 'AGO', 'ao', 'AO', 24, '3351879', 244, '244', 'Africa', 'Luanda', 'Africa/Luanda', 'Kwanza', 'pt-AO', 'Portuguese (official), Bantu and other African languages', 1246700),
(7, 'Anguilla', 'AI', 'AIA', 'ai', 'AV', 660, '3573511', 1, '1264', 'North America', 'The Valley', 'America/Anguilla', 'Dollar', 'en-AI', 'English (official)', 102),
(8, 'Antarctica', 'AQ', 'ATA', 'aq', 'AY', 10, '6697173', 672, '672', 'Antarctica', '', 'Antarctica/Troll', '', '', '', 14000000),
(9, 'Antigua and Barbuda', 'AG', 'ATG', 'ag', 'AC', 28, '3576396', 1, '1268', 'North America', 'St. John\'s', 'America/Antigua', 'Dollar', 'en-AG', 'English (official), local dialects', 443),
(10, 'Argentina', 'AR', 'ARG', 'ar', 'AR', 32, '3865483', 54, '54', 'South America', 'Buenos Aires', 'America/Argentina/Buenos_Aires', 'Peso', 'es-AR,en,it,de,fr,gn', 'Spanish (official), Italian, English, German, French, indigenous (Mapudungun, Quechua)', 2766890),
(11, 'Armenia', 'AM', 'ARM', 'am', 'AM', 51, '174982', 374, '374', 'Asia', 'Yerevan', 'Asia/Yerevan', 'Dram', 'hy', 'Armenian (official) 97.9%, Kurdish (spoken by Yezidi minority) 1%, other 1% (2011 est.)', 29800),
(12, 'Aruba', 'AW', 'ABW', 'aw', 'AA', 533, '3577279', 297, '297', 'North America', 'Oranjestad', 'America/Aruba', 'Guilder', 'nl-AW,es,en', 'Papiamento (a Spanish-Portuguese-Dutch-English dialect) 69.4%, Spanish 13.7%, English (widely spoken) 7.1%, Dutch (official) 6.1%, Chinese 1.5%, other 1.7%, unspecified 0.4% (2010 est.)', 193),
(13, 'Australia', 'AU', 'AUS', 'au', 'AS', 36, '2077456', 61, '61', 'Oceania', 'Canberra', 'Australia/Sydney', 'Dollar', 'en-AU', 'English 76.8%, Mandarin 1.6%, Italian 1.4%, Arabic 1.3%, Greek 1.2%, Cantonese 1.2%, Vietnamese 1.1%, other 10.4%, unspecified 5% (2011 est.)', 7686850),
(14, 'Austria', 'AT', 'AUT', 'at', 'AU', 40, '2782113', 43, '43', 'Europe', 'Vienna', 'Europe/Vienna', 'Euro', 'de-AT,hr,hu,sl', 'German (official nationwide) 88.6%, Turkish 2.3%, Serbian 2.2%, Croatian (official in Burgenland) 1.6%, other (includes Slovene, official in Carinthia, and Hungarian, official in Burgenland) 5.3% (2001 census)', 83858),
(15, 'Azerbaijan', 'AZ', 'AZE', 'az', 'AJ', 31, '587116', 994, '994', 'Asia', 'Baku', 'Asia/Baku', 'Manat', 'az,ru,hy', 'Azerbaijani (Azeri) (official) 92.5%, Russian 1.4%, Armenian 1.4%, other 4.7% (2009 est.)', 86600),
(16, 'Bahamas', 'BS', 'BHS', 'bs', 'BF', 44, '3572887', 1, '1242', 'North America', 'Nassau', 'America/Nassau', 'Dollar', 'en-BS', 'English (official), Creole (among Haitian immigrants)', 13940),
(17, 'Bahrain', 'BH', 'BHR', 'bh', 'BA', 48, '290291', 973, '973', 'Asia', 'Manama', 'Asia/Bahrain', 'Dinar', 'ar-BH,en,fa,ur', 'Arabic (official), English, Farsi, Urdu', 665),
(18, 'Bangladesh', 'BD', 'BGD', 'bd', 'BG', 50, '1210997', 880, '880', 'Asia', 'Dhaka', 'Asia/Dhaka', 'Taka', 'bn-BD,en', 'Bangla (official, also known as Bengali), English', 144000),
(19, 'Barbados', 'BB', 'BRB', 'bb', 'BB', 52, '3374084', 1, '1246', 'North America', 'Bridgetown', 'America/Barbados', 'Dollar', 'en-BB', 'English (official), Bajan (English-based creole language, widely spoken in informal settings)', 431),
(20, 'Belarus', 'BY', 'BLR', 'by', 'BO', 112, '630336', 375, '375', 'Europe', 'Minsk', 'Europe/Minsk', 'Ruble', 'be,ru', 'Belarusian (official) 23.4%, Russian (official) 70.2%, other 3.1% (includes small Polish- and Ukrainian-speaking minorities), unspecified 3.3% (2009 est.)', 207600),
(21, 'Belgium', 'BE', 'BEL', 'be', 'BE', 56, '2802361', 32, '32', 'Europe', 'Brussels', 'Europe/Brussels', 'Euro', 'nl-BE,fr-BE,de-BE', 'Dutch (official) 60%, French (official) 40%, German (official) less than 1%, legally bilingual (Dutch and French)', 30510),
(22, 'Belize', 'BZ', 'BLZ', 'bz', 'BH', 84, '3582678', 501, '501', 'North America', 'Belmopan', 'America/Belize', 'Dollar', 'en-BZ,es', 'Spanish 46%, Creole 32.9%, Mayan dialects 8.9%, English 3.9% (official), Garifuna 3.4% (Carib), German 3.3%, other 1.4%, unknown 0.2% (2000 census)', 22966),
(23, 'Benin', 'BJ', 'BEN', 'bj', 'BN', 204, '2395170', 229, '229', 'Africa', 'Porto-Novo', 'Africa/Porto-Novo', 'Franc', 'fr-BJ', 'French (official), Fon and Yoruba (most common vernaculars in south), tribal languages (at least six major ones in north)', 112620),
(24, 'Bermuda', 'BM', 'BMU', 'bm', 'BD', 60, '3573345', 1, '1441', 'North America', 'Hamilton', 'Atlantic/Bermuda', 'Dollar', 'en-BM,pt', 'English (official), Portuguese', 53),
(25, 'Bhutan', 'BT', 'BTN', 'bt', 'BT', 64, '1252634', 975, '975', 'Asia', 'Thimphu', 'Asia/Thimphu', 'Ngultrum', 'dz', 'Sharchhopka 28%, Dzongkha (official) 24%, Lhotshamkha 22%, other 26% (includes foreign languages) (2005 est.)', 47000),
(26, 'Bolivia', 'BO', 'BOL', 'bo', 'BL', 68, '3923057', 591, '591', 'South America', 'Sucre', 'America/La_Paz', 'Boliviano', 'es-BO,qu,ay', 'Spanish (official) 60.7%, Quechua (official) 21.2%, Aymara (official) 14.6%, Guarani (official), foreign languages 2.4%, other 1.2%', 1098580),
(27, 'Bosnia and Herzegovina', 'BA', 'BIH', 'ba', 'BK', 70, '3277605', 387, '387', 'Europe', 'Sarajevo', 'Europe/Sarajevo', 'Marka', 'bs,hr-BA,sr-BA', 'Bosnian (official), Croatian (official), Serbian (official)', 51129),
(28, 'Botswana', 'BW', 'BWA', 'bw', 'BC', 72, '933860', 267, '267', 'Africa', 'Gaborone', 'Africa/Gaborone', 'Pula', 'en-BW,tn-BW', 'Setswana 78.2%, Kalanga 7.9%, Sekgalagadi 2.8%, English (official) 2.1%, other 8.6%, unspecified 0.4% (2001 census)', 600370),
(29, 'Brazil', 'BR', 'BRA', 'br', 'BR', 76, '3469034', 55, '55', 'South America', 'Brasilia', 'America/Sao_Paulo', 'Real', 'pt-BR,es,en,fr', 'Portuguese (official and most widely spoken language)', 8511965),
(30, 'British Indian Ocean Territory', 'IO', 'IOT', 'io', 'IO', 86, '1282588', 246, '246', 'Asia', 'Diego Garcia', 'Indian/Chagos', 'Dollar', 'en-IO', 'English', 60),
(31, 'British Virgin Islands', 'VG', 'VGB', 'vg', 'VI', 92, '3577718', 1, '1284', 'North America', 'Road Town', 'America/Tortola', 'Dollar', 'en-VG', 'English (official)', 153),
(32, 'Brunei', 'BN', 'BRN', 'bn', 'BX', 96, '1820814', 673, '673', 'Asia', 'Bandar Seri Begawan', 'Asia/Brunei', 'Dollar', 'ms-BN,en-BN', 'Malay (official), English, Chinese', 5770),
(33, 'Bulgaria', 'BG', 'BGR', 'bg', 'BU', 100, '732800', 359, '359', 'Europe', 'Sofia', 'Europe/Sofia', 'Lev', 'bg,tr-BG', 'Bulgarian (official) 76.8%, Turkish 8.2%, Roma 3.8%, other 0.7%, unspecified 10.5% (2011 est.)', 110910),
(34, 'Burkina Faso', 'BF', 'BFA', 'bf', 'UV', 854, '2361809', 226, '226', 'Africa', 'Ouagadougou', 'Africa/Ouagadougou', 'Franc', 'fr-BF', 'French (official), native African languages belonging to Sudanic family spoken by 90% of the population', 274200),
(35, 'Burundi', 'BI', 'BDI', 'bi', 'BY', 108, '433561', 257, '257', 'Africa', 'Bujumbura', 'Africa/Bujumbura', 'Franc', 'fr-BI,rn', 'Kirundi 29.7% (official), Kirundi and other language 9.1%, French (official) and French and other language 0.3%, Swahili and Swahili and other language 0.2% (along Lake Tanganyika and in the Bujumbura area), English and English and other language 0.06%, more than 2 languages 3.7%, unspecified 56.9% (2008 est.)', 27830),
(36, 'Cambodia', 'KH', 'KHM', 'kh', 'CB', 116, '1831722', 855, '855', 'Asia', 'Phnom Penh', 'Asia/Phnom_Penh', 'Riels', 'km,fr,en', 'Khmer (official) 96.3%, other 3.7% (2008 est.)', 181040),
(37, 'Cameroon', 'CM', 'CMR', 'cm', 'CM', 120, '2233387', 237, '237', 'Africa', 'Yaounde', 'Africa/Douala', 'Franc', 'en-CM,fr-CM', '24 major African language groups, English (official), French (official)', 475440),
(38, 'Canada', 'CA', 'CAN', 'ca', 'CA', 124, '6251999', 1, '1', 'North America', 'Ottawa', 'America/Toronto', 'Dollar', 'en-CA,fr-CA,iu', 'English (official) 58.7%, French (official) 22%, Punjabi 1.4%, Italian 1.3%, Spanish 1.3%, German 1.3%, Cantonese 1.2%, Tagalog 1.2%, Arabic 1.1%, other 10.5% (2011 est.)', 9984670),
(39, 'Cape Verde', 'CV', 'CPV', 'cv', 'CV', 132, '3374766', 238, '238', 'Africa', 'Praia', 'Atlantic/Cape_Verde', 'Escudo', 'pt-CV', 'Portuguese (official), Crioulo (a blend of Portuguese and West African words)', 4033),
(40, 'Cayman Islands', 'KY', 'CYM', 'ky', 'CJ', 136, '3580718', 1, '1345', 'North America', 'George Town', 'America/Cayman', 'Dollar', 'en-KY', 'English (official) 90.9%, Spanish 4%, Filipino 3.3%, other 1.7%, unspecified 0.1% (2010 est.)', 262),
(41, 'Central African Republic', 'CF', 'CAF', 'cf', 'CT', 140, '239880', 236, '236', 'Africa', 'Bangui', 'Africa/Bangui', 'Franc', 'fr-CF,sg,ln,kg', 'French (official), Sangho (lingua franca and national language), tribal languages', 622984),
(42, 'Chad', 'TD', 'TCD', 'td', 'CD', 148, '2434508', 235, '235', 'Africa', 'N\'Djamena', 'Africa/Ndjamena', 'Franc', 'fr-TD,ar-TD,sre', 'French (official), Arabic (official), Sara (in south), more than 120 different languages and dialects', 1284000),
(43, 'Chile', 'CL', 'CHL', 'cl', 'CI', 152, '3895114', 56, '56', 'South America', 'Santiago', 'America/Santiago', 'Peso', 'es-CL', 'Spanish 99.5% (official), English 10.2%, indigenous 1% (includes Mapudungun, Aymara, Quechua, Rapa Nui), other 2.3%, unspecified 0.2%', 756950),
(44, 'China', 'CN', 'CHN', 'cn', 'CH', 156, '1814991', 86, '86', 'Asia', 'Beijing', 'Asia/Shanghai', 'Yuan Renminbi', 'zh-CN,yue,wuu,dta,ug,za', 'Standard Chinese or Mandarin (official; Putonghua, based on the Beijing dialect), Yue (Cantonese), Wu (Shanghainese), Minbei (Fuzhou), Minnan (Hokkien-Taiwanese), Xiang, Gan, Hakka dialects, minority languages', 9596960),
(45, 'Christmas Island', 'CX', 'CXR', 'cx', 'KT', 162, '2078138', 61, '61', 'Asia', 'Flying Fish Cove', 'Indian/Christmas', 'Dollar', 'en,zh,ms-CC', 'English (official), Chinese, Malay', 135),
(46, 'Cocos Islands', 'CC', 'CCK', 'cc', 'CK', 166, '1547376', 61, '61', 'Asia', 'West Island', 'Indian/Cocos', 'Dollar', 'ms-CC,en', 'Malay (Cocos dialect), English', 14),
(47, 'Colombia', 'CO', 'COL', 'co', 'CO', 170, '3686110', 57, '57', 'South America', 'Bogota', 'America/Bogota', 'Peso', 'es-CO', 'Spanish (official)', 1138910),
(48, 'Comoros', 'KM', 'COM', 'km', 'CN', 174, '921929', 269, '269', 'Africa', 'Moroni', 'Indian/Comoro', 'Franc', 'ar,fr-KM', 'Arabic (official), French (official), Shikomoro (a blend of Swahili and Arabic)', 2170),
(49, 'Cook Islands', 'CK', 'COK', 'ck', 'CW', 184, '1899402', 682, '682', 'Oceania', 'Avarua', 'Pacific/Rarotonga', 'Dollar', 'en-CK,mi', 'English (official) 86.4%, Cook Islands Maori (Rarotongan) (official) 76.2%, other 8.3%', 240),
(50, 'Costa Rica', 'CR', 'CRI', 'cr', 'CS', 188, '3624060', 506, '506', 'North America', 'San Jose', 'America/Costa_Rica', 'Colon', 'es-CR,en', 'Spanish (official), English', 51100),
(51, 'Croatia', 'HR', 'HRV', 'hr', 'HR', 191, '3202326', 385, '385', 'Europe', 'Zagreb', 'Europe/Zagreb', 'Kuna', 'hr-HR,sr', 'Croatian (official) 95.6%, Serbian 1.2%, other 3% (including Hungarian, Czech, Slovak, and Albanian), unspecified 0.2% (2011 est.)', 56542),
(52, 'Cuba', 'CU', 'CUB', 'cu', 'CU', 192, '3562981', 53, '53', 'North America', 'Havana', 'America/Havana', 'Peso', 'es-CU', 'Spanish (official)', 110860),
(53, 'Curacao', 'CW', 'CUW', 'cw', 'UC', 531, '7626836', 599, '599', 'North America', 'Willemstad', 'America/Curacao', 'Guilder', 'nl,pap', 'Papiamentu (a Spanish-Portuguese-Dutch-English dialect) 81.2%, Dutch (official) 8%, Spanish 4%, English 2.9%, other 3.9% (2001 census)', 444),
(54, 'Cyprus', 'CY', 'CYP', 'cy', 'CY', 196, '146669', 357, '357', 'Europe', 'Nicosia', 'Asia/Nicosia', 'Euro', 'el-CY,tr-CY,en', 'Greek (official) 80.9%, Turkish (official) 0.2%, English 4.1%, Romanian 2.9%, Russian 2.5%, Bulgarian 2.2%, Arabic 1.2%, Filippino 1.1%, other 4.3%, unspecified 0.6% (2011 est.)', 9250),
(55, 'Czech Republic', 'CZ', 'CZE', 'cz', 'EZ', 203, '3077311', 420, '420', 'Europe', 'Prague', 'Europe/Prague', 'Koruna', 'cs,sk', 'Czech 95.4%, Slovak 1.6%, other 3% (2011 census)', 78866),
(56, 'Democratic Republic of the Congo', 'CD', 'COD', 'cd', 'CG', 180, '203312', 243, '243', 'Africa', 'Kinshasa', 'Africa/Kinshasa', 'Franc', 'fr-CD,ln,kg', 'French (official), Lingala (a lingua franca trade language), Kingwana (a dialect of Kiswahili or Swahili), Kikongo, Tshiluba', 2345410),
(57, 'Denmark', 'DK', 'DNK', 'dk', 'DA', 208, '2623032', 45, '45', 'Europe', 'Copenhagen', 'Europe/Copenhagen', 'Krone', 'da-DK,en,fo,de-DK', 'Danish, Faroese, Greenlandic (an Inuit dialect), German (small minority)', 43094),
(58, 'Djibouti', 'DJ', 'DJI', 'dj', 'DJ', 262, '223816', 253, '253', 'Africa', 'Djibouti', 'Africa/Djibouti', 'Franc', 'fr-DJ,ar,so-DJ,aa', 'French (official), Arabic (official), Somali, Afar', 23000),
(59, 'Dominica', 'DM', 'DMA', 'dm', 'DO', 212, '3575830', 1, '1767', 'North America', 'Roseau', 'America/Dominica', 'Dollar', 'en-DM', 'English (official), French patois', 754),
(60, 'Dominican Republic', 'DO', 'DOM', 'do', 'DR', 214, '3508796', 1, '1809', 'North America', 'Santo Domingo', 'America/Santo_Domingo', 'Peso', 'es-DO', 'Spanish (official)', 48730),
(61, 'East Timor', 'TL', 'TLS', 'tl', 'TT', 626, '1966436', 670, '670', 'Oceania', 'Dili', 'Asia/Dili', 'Dollar', 'tet,pt-TL,id,en', 'Tetum (official), Portuguese (official), Indonesian, English', 15007),
(62, 'Ecuador', 'EC', 'ECU', 'ec', 'EC', 218, '3658394', 593, '593', 'South America', 'Quito', 'America/Guayaquil', 'Dollar', 'es-EC', 'Spanish (Castillian) 93% (official), Quechua 4.1%, other indigenous 0.7%, foreign 2.2%', 283560),
(63, 'Egypt', 'EG', 'EGY', 'eg', 'EG', 818, '357994', 20, '20', 'Africa', 'Cairo', 'Africa/Cairo', 'Pound', 'ar-EG,en,fr', 'Arabic (official), English and French widely understood by educated classes', 1001450),
(64, 'El Salvador', 'SV', 'SLV', 'sv', 'ES', 222, '3585968', 503, '503', 'North America', 'San Salvador', 'America/El_Salvador', 'Dollar', 'es-SV', 'Spanish (official), Nahua (among some Amerindians)', 21040),
(65, 'Equatorial Guinea', 'GQ', 'GNQ', 'gq', 'EK', 226, '2309096', 240, '240', 'Africa', 'Malabo', 'Africa/Malabo', 'Franc', 'es-GQ,fr', 'Spanish (official) 67.6%, other (includes French (official), Fang, Bubi) 32.4% (1994 census)', 28051),
(66, 'Eritrea', 'ER', 'ERI', 'er', 'ER', 232, '338010', 291, '291', 'Africa', 'Asmara', 'Africa/Asmara', 'Nakfa', 'aa-ER,ar,tig,kun,ti-ER', 'Tigrinya (official), Arabic (official), English (official), Tigre, Kunama, Afar, other Cushitic languages', 121320),
(67, 'Estonia', 'EE', 'EST', 'ee', 'EN', 233, '453733', 372, '372', 'Europe', 'Tallinn', 'Europe/Tallinn', 'Euro', 'et,ru', 'Estonian (official) 68.5%, Russian 29.6%, Ukrainian 0.6%, other 1.2%, unspecified 0.1% (2011 est.)', 45226),
(68, 'Ethiopia', 'ET', 'ETH', 'et', 'ET', 231, '337996', 251, '251', 'Africa', 'Addis Ababa', 'Africa/Addis_Ababa', 'Birr', 'am,en-ET,om-ET,ti-ET,so-ET,sid', 'Oromo (official working language in the State of Oromiya) 33.8%, Amharic (official national language) 29.3%, Somali (official working language of the State of Sumale) 6.2%, Tigrigna (Tigrinya) (official working language of the State of Tigray) 5.9%, Sidamo 4%, Wolaytta 2.2%, Gurage 2%, Afar (official working language of the State of Afar) 1.7%, Hadiyya 1.7%, Gamo 1.5%, Gedeo 1.3%, Opuuo 1.2%, Kafa 1.1%, other 8.1%, English (major foreign language taught in schools), Arabic (2007 est.)', 1127127),
(69, 'Falkland Islands', 'FK', 'FLK', 'fk', 'FK', 238, '3474414', 500, '500', 'South America', 'Stanley', 'Atlantic/Stanley', 'Pound', 'en-FK', 'English 89%, Spanish 7.7%, other 3.3% (2006 est.)', 12173),
(70, 'Faroe Islands', 'FO', 'FRO', 'fo', 'FO', 234, '2622320', 298, '298', 'Europe', 'Torshavn', 'Atlantic/Faroe', 'Krone', 'fo,da-FO', 'Faroese (derived from Old Norse), Danish', 1399),
(71, 'Fiji', 'FJ', 'FJI', 'fj', 'FJ', 242, '2205218', 679, '679', 'Oceania', 'Suva', 'Pacific/Fiji', 'Dollar', 'en-FJ,fj', 'English (official), Fijian (official), Hindustani', 18270),
(72, 'Finland', 'FI', 'FIN', 'fi', 'FI', 246, '660013', 358, '358', 'Europe', 'Helsinki', 'Europe/Helsinki', 'Euro', 'fi-FI,sv-FI,smn', 'Finnish (official) 94.2%, Swedish (official) 5.5%, other (small Sami- and Russian-speaking minorities) 0.2% (2012 est.)', 337030),
(73, 'France', 'FR', 'FRA', 'fr', 'FR', 250, '3017382', 33, '33', 'Europe', 'Paris', 'Europe/Paris', 'Euro', 'fr-FR,frp,br,co,ca,eu,oc', 'French (official) 100%, rapidly declining regional dialects and languages (Provencal, Breton, Alsatian, Corsican, Catalan, Basque, Flemish)', 547030),
(74, 'French Polynesia', 'PF', 'PYF', 'pf', 'FP', 258, '4030656', 689, '689', 'Oceania', 'Papeete', 'Pacific/Tahiti', 'Franc', 'fr-PF,ty', 'French (official) 61.1%, Polynesian (official) 31.4%, Asian languages 1.2%, other 0.3%, unspecified 6% (2002 census)', 4167),
(75, 'Gabon', 'GA', 'GAB', 'ga', 'GB', 266, '2400553', 241, '241', 'Africa', 'Libreville', 'Africa/Libreville', 'Franc', 'fr-GA', 'French (official), Fang, Myene, Nzebi, Bapounou/Eschira, Bandjabi', 267667),
(76, 'Gambia', 'GM', 'GMB', 'gm', 'GA', 270, '2413451', 220, '220', 'Africa', 'Banjul', 'Africa/Banjul', 'Dalasi', 'en-GM,mnk,wof,wo,ff', 'English (official), Mandinka, Wolof, Fula, other indigenous vernaculars', 11300),
(77, 'Georgia', 'GE', 'GEO', 'ge', 'GG', 268, '614540', 995, '995', 'Asia', 'Tbilisi', 'Asia/Tbilisi', 'Lari', 'ka,ru,hy,az', 'Georgian (official) 71%, Russian 9%, Armenian 7%, Azeri 6%, other 7%', 69700),
(78, 'Germany', 'DE', 'DEU', 'de', 'GM', 276, '2921044', 49, '49', 'Europe', 'Berlin', 'Europe/Berlin', 'Euro', 'de', 'German (official)', 357021),
(79, 'Ghana', 'GH', 'GHA', 'gh', 'GH', 288, '2300660', 233, '233', 'Africa', 'Accra', 'Africa/Accra', 'Cedi', 'en-GH,ak,ee,tw', 'Asante 14.8%, Ewe 12.7%, Fante 9.9%, Boron (Brong) 4.6%, Dagomba 4.3%, Dangme 4.3%, Dagarte (Dagaba) 3.7%, Akyem 3.4%, Ga 3.4%, Akuapem 2.9%, other (includes English (official)) 36.1% (2000 census)', 239460),
(80, 'Gibraltar', 'GI', 'GIB', 'gi', 'GI', 292, '2411586', 350, '350', 'Europe', 'Gibraltar', 'Europe/Gibraltar', 'Pound', 'en-GI,es,it,pt', 'English (used in schools and for official purposes), Spanish, Italian, Portuguese', 7),
(81, 'Greece', 'GR', 'GRC', 'gr', 'GR', 300, '390903', 30, '30', 'Europe', 'Athens', 'Europe/Athens', 'Euro', 'el-GR,en,fr', 'Greek (official) 99%, other (includes English and French) 1%', 131940),
(82, 'Greenland', 'GL', 'GRL', 'gl', 'GL', 304, '3425505', 299, '299', 'North America', 'Nuuk', 'America/Godthab', 'Krone', 'kl,da-GL,en', 'Greenlandic (East Inuit) (official), Danish (official), English', 2166086),
(83, 'Grenada', 'GD', 'GRD', 'gd', 'GJ', 308, '3580239', 1, '1473', 'North America', 'St. George\'s', 'America/Grenada', 'Dollar', 'en-GD', 'English (official), French patois', 344),
(84, 'Guam', 'GU', 'GUM', 'gu', 'GQ', 316, '4043988', 1, '1671', 'Oceania', 'Hagatna', 'Pacific/Guam', 'Dollar', 'en-GU,ch-GU', 'English 43.6%, Filipino 21.2%, Chamorro 17.8%, other Pacific island languages 10%, Asian languages 6.3%, other 1.1% (2010 est.)', 549),
(85, 'Guatemala', 'GT', 'GTM', 'gt', 'GT', 320, '3595528', 502, '502', 'North America', 'Guatemala City', 'America/Guatemala', 'Quetzal', 'es-GT', 'Spanish (official) 60%, Amerindian languages 40%', 108890),
(86, 'Guernsey', 'GG', 'GGY', 'gg', 'GK', 831, '3042362', 44, '441481', 'Europe', 'St Peter Port', 'Europe/Guernsey', 'Pound', 'en,fr', 'English, French, Norman-French dialect spoken in country districts', 78),
(87, 'Guinea', 'GN', 'GIN', 'gn', 'GV', 324, '2420477', 224, '224', 'Africa', 'Conakry', 'Africa/Conakry', 'Franc', 'fr-GN', 'French (official)', 245857),
(88, 'Guinea-Bissau', 'GW', 'GNB', 'gw', 'PU', 624, '2372248', 245, '245', 'Africa', 'Bissau', 'Africa/Bissau', 'Franc', 'pt-GW,pov', 'Portuguese (official), Crioulo, African languages', 36120),
(89, 'Guyana', 'GY', 'GUY', 'gy', 'GY', 328, '3378535', 592, '592', 'South America', 'Georgetown', 'America/Guyana', 'Dollar', 'en-GY', 'English, Amerindian dialects, Creole, Caribbean Hindustani (a dialect of Hindi), Urdu', 214970),
(90, 'Haiti', 'HT', 'HTI', 'ht', 'HA', 332, '3723988', 509, '509', 'North America', 'Port-au-Prince', 'America/Port-au-Prince', 'Gourde', 'ht,fr-HT', 'French (official), Creole (official)', 27750),
(91, 'Honduras', 'HN', 'HND', 'hn', 'HO', 340, '3608932', 504, '504', 'North America', 'Tegucigalpa', 'America/Tegucigalpa', 'Lempira', 'es-HN', 'Spanish (official), Amerindian dialects', 112090),
(92, 'Hong Kong', 'HK', 'HKG', 'hk', 'HK', 344, '1819730', 852, '852', 'Asia', 'Hong Kong', 'Asia/Hong_Kong', 'Dollar', 'zh-HK,yue,zh,en', 'Cantonese (official) 89.5%, English (official) 3.5%, Putonghua (Mandarin) 1.4%, other Chinese dialects 4%, other 1.6% (2011 est.)', 1092),
(93, 'Hungary', 'HU', 'HUN', 'hu', 'HU', 348, '719819', 36, '36', 'Europe', 'Budapest', 'Europe/Budapest', 'Forint', 'hu-HU', 'Hungarian (official) 99.6%, English 16%, German 11.2%, Russian 1.6%, Romanian 1.3%, French 1.2%, other 4.2%', 93030),
(94, 'Iceland', 'IS', 'ISL', 'is', 'IC', 352, '2629691', 354, '354', 'Europe', 'Reykjavik', 'Atlantic/Reykjavik', 'Krona', 'is,en,de,da,sv,no', 'Icelandic, English, Nordic languages, German widely spoken', 103000),
(95, 'India', 'IN', 'IND', 'in', 'IN', 356, '1269750', 91, '91', 'Asia', 'New Delhi', 'Asia/Kolkata', 'Rupee', 'en-IN,hi,bn,te,mr,ta,ur,gu,kn,ml,or,pa,as,bh,sat,ks,ne,sd,kok,doi,mni,sit,sa,fr,lus,inc', 'Hindi 41%, Bengali 8.1%, Telugu 7.2%, Marathi 7%, Tamil 5.9%, Urdu 5%, Gujarati 4.5%, Kannada 3.7%, Malayalam 3.2%, Oriya 3.2%, Punjabi 2.8%, Assamese 1.3%, Maithili 1.2%, other 5.9%', 3287590),
(96, 'Indonesia', 'ID', 'IDN', 'id', 'ID', 360, '1643084', 62, '62', 'Asia', 'Jakarta', 'Asia/Jakarta', 'Rupiah', 'id,en,nl,jv', 'Bahasa Indonesia (official, modified form of Malay), English, Dutch, local dialects (of which the most widely spoken is Javanese)', 1919440),
(97, 'Iran', 'IR', 'IRN', 'ir', 'IR', 364, '130758', 98, '98', 'Asia', 'Tehran', 'Asia/Tehran', 'Rial', 'fa-IR,ku', 'Persian (official) 53%, Azeri Turkic and Turkic dialects 18%, Kurdish 10%, Gilaki and Mazandarani 7%, Luri 6%, Balochi 2%, Arabic 2%, other 2%', 1648000),
(98, 'Iraq', 'IQ', 'IRQ', 'iq', 'IZ', 368, '99237', 964, '964', 'Asia', 'Baghdad', 'Asia/Baghdad', 'Dinar', 'ar-IQ,ku,hy', 'Arabic (official), Kurdish (official), Turkmen (a Turkish dialect) and Assyrian (Neo-Aramaic) are official in areas where they constitute a majority of the population), Armenian', 437072),
(99, 'Ireland', 'IE', 'IRL', 'ie', 'EI', 372, '2963597', 353, '353', 'Europe', 'Dublin', 'Europe/Dublin', 'Euro', 'en-IE,ga-IE', 'English (official, the language generally used), Irish (Gaelic or Gaeilge) (official, spoken mainly in areas along the western coast)', 70280),
(100, 'Isle of Man', 'IM', 'IMN', 'im', 'IM', 833, '3042225', 44, '441624', 'Europe', 'Douglas, Isle of Man', 'Europe/Isle_of_Man', 'Pound', 'en,gv', 'English, Manx Gaelic (about 2% of the population has some knowledge)', 572),
(101, 'Israel', 'IL', 'ISR', 'il', 'IS', 376, '294640', 972, '972', 'Asia', 'Jerusalem', 'Asia/Jerusalem', 'Shekel', 'he,ar-IL,en-IL,', 'Hebrew (official), Arabic (used officially for Arab minority), English (most commonly used foreign language)', 20770),
(102, 'Italy', 'IT', 'ITA', 'it', 'IT', 380, '3175395', 39, '39', 'Europe', 'Rome', 'Europe/Rome', 'Euro', 'it-IT,de-IT,fr-IT,sc,ca,co,sl', 'Italian (official), German (parts of Trentino-Alto Adige region are predominantly German-speaking), French (small French-speaking minority in Valle d\'Aosta region), Slovene (Slovene-speaking minority in the Trieste-Gorizia area)', 301230),
(103, 'Ivory Coast', 'CI', 'CIV', 'ci', 'IV', 384, '2287781', 225, '225', 'Africa', 'Yamoussoukro', 'Africa/Abidjan', 'Franc', 'fr-CI', 'French (official), 60 native dialects of which Dioula is the most widely spoken', 322460),
(104, 'Jamaica', 'JM', 'JAM', 'jm', 'JM', 388, '3489940', 1, '1876', 'North America', 'Kingston', 'America/Jamaica', 'Dollar', 'en-JM', 'English, English patois', 10991),
(105, 'Japan', 'JP', 'JPN', 'jp', 'JA', 392, '1861060', 81, '81', 'Asia', 'Tokyo', 'Asia/Tokyo', 'Yen', 'ja', 'Japanese', 377835),
(106, 'Jersey', 'JE', 'JEY', 'je', 'JE', 832, '3042142', 44, '441534', 'Europe', 'Saint Helier', 'Europe/Jersey', 'Pound', 'en,pt', 'English 94.5% (official), Portuguese 4.6%, other 0.9% (2001 census)', 116),
(107, 'Jordan', 'JO', 'JOR', 'jo', 'JO', 400, '248816', 962, '962', 'Asia', 'Amman', 'Asia/Amman', 'Dinar', 'ar-JO,en', 'Arabic (official), English (widely understood among upper and middle classes)', 92300),
(108, 'Kazakhstan', 'KZ', 'KAZ', 'kz', 'KZ', 398, '1522867', 7, '7', 'Asia', 'Astana', 'Asia/Almaty', 'Tenge', 'kk,ru', 'Kazakh (official, Qazaq) 64.4%, Russian (official, used in everyday business, designated the \"language of interethnic communication\") 95% (2001 est.)', 2717300),
(109, 'Kenya', 'KE', 'KEN', 'ke', 'KE', 404, '192950', 254, '254', 'Africa', 'Nairobi', 'Africa/Nairobi', 'Shilling', 'en-KE,sw-KE', 'English (official), Kiswahili (official), numerous indigenous languages', 582650),
(110, 'Kiribati', 'KI', 'KIR', 'ki', 'KR', 296, '4030945', 686, '686', 'Oceania', 'Tarawa', 'Pacific/Tarawa', 'Dollar', 'en-KI,gil', 'I-Kiribati, English (official)', 811),
(111, 'Kosovo', 'XK', 'XKX', '', 'KV', 0, '831053', 383, '383', 'Europe', 'Pristina', 'Europe/Podgorica', 'Euro', 'sq,sr', 'Albanian (official), Serbian (official), Bosnian, Turkish, Roma', 10887),
(112, 'Kuwait', 'KW', 'KWT', 'kw', 'KU', 414, '285570', 965, '965', 'Asia', 'Kuwait City', 'Asia/Kuwait', 'Dinar', 'ar-KW,en', 'Arabic (official), English widely spoken', 17820),
(113, 'Kyrgyzstan', 'KG', 'KGZ', 'kg', 'KG', 417, '1527747', 996, '996', 'Asia', 'Bishkek', 'Asia/Bishkek', 'Som', 'ky,uz,ru', 'Kyrgyz (official) 64.7%, Uzbek 13.6%, Russian (official) 12.5%, Dungun 1%, other 8.2% (1999 census)', 198500),
(114, 'Laos', 'LA', 'LAO', 'la', 'LA', 418, '1655842', 856, '856', 'Asia', 'Vientiane', 'Asia/Vientiane', 'Kip', 'lo,fr,en', 'Lao (official), French, English, various ethnic languages', 236800),
(115, 'Latvia', 'LV', 'LVA', 'lv', 'LG', 428, '458258', 371, '371', 'Europe', 'Riga', 'Europe/Riga', 'Euro', 'lv,ru,lt', 'Latvian (official) 56.3%, Russian 33.8%, other 0.6% (includes Polish, Ukrainian, and Belarusian), unspecified 9.4% (2011 est.)', 64589),
(116, 'Lebanon', 'LB', 'LBN', 'lb', 'LE', 422, '272103', 961, '961', 'Asia', 'Beirut', 'Asia/Beirut', 'Pound', 'ar-LB,fr-LB,en,hy', 'Arabic (official), French, English, Armenian', 10400),
(117, 'Lesotho', 'LS', 'LSO', 'ls', 'LT', 426, '932692', 266, '266', 'Africa', 'Maseru', 'Africa/Maseru', 'Loti', 'en-LS,st,zu,xh', 'Sesotho (official) (southern Sotho), English (official), Zulu, Xhosa', 30355),
(118, 'Liberia', 'LR', 'LBR', 'lr', 'LI', 430, '2275384', 231, '231', 'Africa', 'Monrovia', 'Africa/Monrovia', 'Dollar', 'en-LR', 'English 20% (official), some 20 ethnic group languages few of which can be written or used in correspondence', 111370),
(119, 'Libya', 'LY', 'LBY', 'ly', 'LY', 434, '2215636', 218, '218', 'Africa', 'Tripolis', 'Africa/Tripoli', 'Dinar', 'ar-LY,it,en', 'Arabic (official), Italian, English (all widely understood in the major cities); Berber (Nafusi, Ghadamis, Suknah, Awjilah, Tamasheq)', 1759540),
(120, 'Liechtenstein', 'LI', 'LIE', 'li', 'LS', 438, '3042058', 423, '423', 'Europe', 'Vaduz', 'Europe/Vaduz', 'Franc', 'de-LI', 'German 94.5% (official) (Alemannic is the main dialect), Italian 1.1%, other 4.3% (2010 est.)', 160),
(121, 'Lithuania', 'LT', 'LTU', 'lt', 'LH', 440, '597427', 370, '370', 'Europe', 'Vilnius', 'Europe/Vilnius', 'Euro', 'lt,ru,pl', 'Lithuanian (official) 82%, Russian 8%, Polish 5.6%, other 0.9%, unspecified 3.5% (2011 est.)', 65200),
(122, 'Luxembourg', 'LU', 'LUX', 'lu', 'LU', 442, '2960313', 352, '352', 'Europe', 'Luxembourg', 'Europe/Luxembourg', 'Euro', 'lb,de-LU,fr-LU', 'Luxembourgish (official administrative language and national language (spoken vernacular)), French (official administrative language), German (official administrative language)', 2586),
(123, 'Macau', 'MO', 'MAC', 'mo', 'MC', 446, '1821275', 853, '853', 'Asia', 'Macao', 'Asia/Macau', 'Pataca', 'zh,zh-MO,pt', 'Cantonese 83.3%, Mandarin 5%, Hokkien 3.7%, English 2.3%, other Chinese dialects 2%, Tagalog 1.7%, Portuguese 0.7%, other 1.3%', 254),
(124, 'Macedonia', 'MK', 'MKD', 'mk', 'MK', 807, '718075', 389, '389', 'Europe', 'Skopje', 'Europe/Skopje', 'Denar', 'mk,sq,tr,rmm,sr', 'Macedonian (official) 66.5%, Albanian (official) 25.1%, Turkish 3.5%, Roma 1.9%, Serbian 1.2%, other 1.8% (2002 census)', 25333),
(125, 'Madagascar', 'MG', 'MDG', 'mg', 'MA', 450, '1062947', 261, '261', 'Africa', 'Antananarivo', 'Indian/Antananarivo', 'Ariary', 'fr-MG,mg', 'French (official), Malagasy (official), English', 587040),
(126, 'Malawi', 'MW', 'MWI', 'mw', 'MI', 454, '927384', 265, '265', 'Africa', 'Lilongwe', 'Africa/Blantyre', 'Kwacha', 'ny,yao,tum,swk', 'English (official), Chichewa (common), Chinyanja, Chiyao, Chitumbuka, Chilomwe, Chinkhonde, Chingoni, Chisena, Chitonga, Chinyakyusa, Chilambya', 118480),
(127, 'Malaysia', 'MY', 'MYS', 'my', 'MY', 458, '1733045', 60, '60', 'Asia', 'Kuala Lumpur', 'Asia/Kuala_Lumpur', 'Ringgit', 'ms-MY,en,zh,ta,te,ml,pa,th', 'Bahasa Malaysia (official), English, Chinese (Cantonese, Mandarin, Hokkien, Hakka, Hainan, Foochow), Tamil, Telugu, Malayalam, Panjabi, Thai', 329750),
(128, 'Maldives', 'MV', 'MDV', 'mv', 'MV', 462, '1282028', 960, '960', 'Asia', 'Male', 'Indian/Maldives', 'Rufiyaa', 'dv,en', 'Dhivehi (official, dialect of Sinhala, script derived from Arabic), English (spoken by most government officials)', 300),
(129, 'Mali', 'ML', 'MLI', 'ml', 'ML', 466, '2453866', 223, '223', 'Africa', 'Bamako', 'Africa/Bamako', 'Franc', 'fr-ML,bm', 'French (official), Bambara 46.3%, Peul/foulfoulbe 9.4%, Dogon 7.2%, Maraka/soninke 6.4%, Malinke 5.6%, Sonrhai/djerma 5.6%, Minianka 4.3%, Tamacheq 3.5%, Senoufo 2.6%, unspecified 0.6%, other 8.5%', 1240000),
(130, 'Malta', 'MT', 'MLT', 'mt', 'MT', 470, '2562770', 356, '356', 'Europe', 'Valletta', 'Europe/Malta', 'Euro', 'mt,en-MT', 'Maltese (official) 90.1%, English (official) 6%, multilingual 3%, other 0.9% (2005 est.)', 316),
(131, 'Marshall Islands', 'MH', 'MHL', 'mh', 'RM', 584, '2080185', 692, '692', 'Oceania', 'Majuro', 'Pacific/Majuro', 'Dollar', 'mh,en-MH', 'Marshallese (official) 98.2%, other languages 1.8% (1999 census)', 181),
(132, 'Mauritania', 'MR', 'MRT', 'mr', 'MR', 478, '2378080', 222, '222', 'Africa', 'Nouakchott', 'Africa/Nouakchott', 'Ouguiya', 'ar-MR,fuc,snk,fr,mey,wo', 'Arabic (official and national), Pulaar, Soninke, Wolof (all national languages), French, Hassaniya (a variety of Arabic)', 1030700),
(133, 'Mauritius', 'MU', 'MUS', 'mu', 'MP', 480, '934292', 230, '230', 'Africa', 'Port Louis', 'Indian/Mauritius', 'Rupee', 'en-MU,bho,fr', 'Creole 86.5%, Bhojpuri 5.3%, French 4.1%, two languages 1.4%, other 2.6% (includes English, the official language, which is spoken by less than 1% of the population), unspecified 0.1% (2011 est.)', 2040),
(134, 'Mayotte', 'YT', 'MYT', 'yt', 'MF', 175, '1024031', 262, '262', 'Africa', 'Mamoudzou', 'Indian/Mayotte', 'Euro', 'fr-YT', 'French', 374),
(135, 'Mexico', 'MX', 'MEX', 'mx', 'MX', 484, '3996063', 52, '52', 'North America', 'Mexico City', 'America/Mexico_City', 'Peso', 'es-MX', 'Spanish only 92.7%, Spanish and indigenous languages 5.7%, indigenous only 0.8%, unspecified 0.8%', 1972550),
(136, 'Micronesia', 'FM', 'FSM', 'fm', 'FM', 583, '2081918', 691, '691', 'Oceania', 'Palikir', 'Pacific/Pohnpei', 'Dollar', 'en-FM,chk,pon,yap,kos,uli,woe,nkr,kpg', 'English (official and common language), Chuukese, Kosrean, Pohnpeian, Yapese, Ulithian, Woleaian, Nukuoro, Kapingamarangi', 702),
(137, 'Moldova', 'MD', 'MDA', 'md', 'MD', 498, '617790', 373, '373', 'Europe', 'Chisinau', 'Europe/Chisinau', 'Leu', 'ro,ru,gag,tr', 'Moldovan 58.8% (official; virtually the same as the Romanian language), Romanian 16.4%, Russian 16%, Ukrainian 3.8%, Gagauz 3.1% (a Turkish language), Bulgarian 1.1%, other 0.3%, unspecified 0.4%', 33843),
(138, 'Monaco', 'MC', 'MCO', 'mc', 'MN', 492, '2993457', 377, '377', 'Europe', 'Monaco', 'Europe/Monaco', 'Euro', 'fr-MC,en,it', 'French (official), English, Italian, Monegasque', 2),
(139, 'Mongolia', 'MN', 'MNG', 'mn', 'MG', 496, '2029969', 976, '976', 'Asia', 'Ulan Bator', 'Asia/Ulaanbaatar', 'Tugrik', 'mn,ru', 'Khalkha Mongol 90% (official), Turkic, Russian (1999)', 1565000),
(140, 'Montenegro', 'ME', 'MNE', 'me', 'MJ', 499, '3194884', 382, '382', 'Europe', 'Podgorica', 'Europe/Podgorica', 'Euro', 'sr,hu,bs,sq,hr,rom', 'Serbian 42.9%, Montenegrin (official) 37%, Bosnian 5.3%, Albanian 5.3%, Serbo-Croat 2%, other 3.5%, unspecified 4% (2011 est.)', 14026),
(141, 'Montserrat', 'MS', 'MSR', 'ms', 'MH', 500, '3578097', 1, '1664', 'North America', 'Plymouth', 'America/Montserrat', 'Dollar', 'en-MS', 'English', 102),
(142, 'Morocco', 'MA', 'MAR', 'ma', 'MO', 504, '2542007', 212, '212', 'Africa', 'Rabat', 'Africa/Casablanca', 'Dirham', 'ar-MA,fr', 'Arabic (official), Berber languages (Tamazight (official), Tachelhit, Tarifit), French (often the language of business, government, and diplomacy)', 446550),
(143, 'Mozambique', 'MZ', 'MOZ', 'mz', 'MZ', 508, '1036973', 258, '258', 'Africa', 'Maputo', 'Africa/Maputo', 'Metical', 'pt-MZ,vmw', 'Emakhuwa 25.3%, Portuguese (official) 10.7%, Xichangana 10.3%, Cisena 7.5%, Elomwe 7%, Echuwabo 5.1%, other Mozambican languages 30.1%, other 4% (1997 census)', 801590),
(144, 'Myanmar', 'MM', 'MMR', 'mm', 'BM', 104, '1327865', 95, '95', 'Asia', 'Nay Pyi Taw', 'Asia/Rangoon', 'Kyat', 'my', 'Burmese (official)', 678500),
(145, 'Namibia', 'NA', 'NAM', 'na', 'WA', 516, '3355338', 264, '264', 'Africa', 'Windhoek', 'Africa/Windhoek', 'Dollar', 'en-NA,af,de,hz,naq', 'Oshiwambo languages 48.9%, Nama/Damara 11.3%, Afrikaans 10.4% (common language of most of the population and about 60% of the white population), Otjiherero languages 8.6%, Kavango languages 8.5%, Caprivi languages 4.8%, English (official) 3.4%, other African languages 2.3%, other 1.7%', 825418),
(146, 'Nauru', 'NR', 'NRU', 'nr', 'NR', 520, '2110425', 674, '674', 'Oceania', 'Yaren', 'Pacific/Nauru', 'Dollar', 'na,en-NR', 'Nauruan 93% (official, a distinct Pacific Island language), English 2% (widely understood, spoken, and used for most government and commercial purposes), other 5% (includes I-Kiribati 2% and Chinese 2%)', 21),
(147, 'Nepal', 'NP', 'NPL', 'np', 'NP', 524, '1282988', 977, '977', 'Asia', 'Kathmandu', 'Asia/Kathmandu', 'Rupee', 'ne,en', 'Nepali (official) 44.6%, Maithali 11.7%, Bhojpuri 6%, Tharu 5.8%, Tamang 5.1%, Newar 3.2%, Magar 3%, Bajjika 3%, Urdu 2.6%, Avadhi 1.9%, Limbu 1.3%, Gurung 1.2%, other 10.4%, unspecified 0.2%', 140800),
(148, 'Netherlands', 'NL', 'NLD', 'nl', 'NL', 528, '2750405', 31, '31', 'Europe', 'Amsterdam', 'Europe/Amsterdam', 'Euro', 'nl-NL,fy-NL', 'Dutch (official)', 41526),
(149, 'Netherlands Antilles', 'AN', 'ANT', 'an', 'NT', 530, '', 599, '599', 'North America', 'Willemstad', 'America/Curacao', 'Guilder', 'nl-AN,en,es', 'Dutch, English, Spanish', 960),
(150, 'New Caledonia', 'NC', 'NCL', 'nc', 'NC', 540, '2139685', 687, '687', 'Oceania', 'Noumea', 'Pacific/Noumea', 'Franc', 'fr-NC', 'French (official), 33 Melanesian-Polynesian dialects', 19060),
(151, 'New Zealand', 'NZ', 'NZL', 'nz', 'NZ', 554, '2186224', 64, '64', 'Oceania', 'Wellington', 'Pacific/Auckland', 'Dollar', 'en-NZ,mi', 'English (de facto official) 89.8%, Maori (de jure official) 3.5%, Samoan 2%, Hindi 1.6%, French 1.2%, Northern Chinese 1.2%, Yue 1%, Other or not stated 20.5%, New Zealand Sign Language (de jure official)', 268680),
(152, 'Nicaragua', 'NI', 'NIC', 'ni', 'NU', 558, '3617476', 505, '505', 'North America', 'Managua', 'America/Managua', 'Cordoba', 'es-NI,en', 'Spanish (official) 95.3%, Miskito 2.2%, Mestizo of the Caribbean coast 2%, other 0.5%', 129494),
(153, 'Niger', 'NE', 'NER', 'ne', 'NG', 562, '2440476', 227, '227', 'Africa', 'Niamey', 'Africa/Niamey', 'Franc', 'fr-NE,ha,kr,dje', 'French (official), Hausa, Djerma', 1267000),
(154, 'Nigeria', 'NG', 'NGA', 'ng', 'NI', 566, '2328926', 234, '234', 'Africa', 'Abuja', 'Africa/Lagos', 'Naira', 'en-NG,ha,yo,ig,ff', 'English (official), Hausa, Yoruba, Igbo (Ibo), Fulani, over 500 additional indigenous languages', 923768),
(155, 'Niue', 'NU', 'NIU', 'nu', 'NE', 570, '4036232', 683, '683', 'Oceania', 'Alofi', 'Pacific/Niue', 'Dollar', 'niu,en-NU', 'Niuean (official) 46% (a Polynesian language closely related to Tongan and Samoan), Niuean and English 32%, English (official) 11%, Niuean and others 5%, other 6% (2011 est.)', 260),
(156, 'North Korea', 'KP', 'PRK', 'kp', 'KN', 408, '1873107', 850, '850', 'Asia', 'Pyongyang', 'Asia/Pyongyang', 'Won', 'ko-KP', 'Korean', 120540),
(157, 'Northern Mariana Islands', 'MP', 'MNP', 'mp', 'CQ', 580, '4041468', 1, '1670', 'Oceania', 'Saipan', 'Pacific/Saipan', 'Dollar', 'fil,tl,zh,ch-MP,en-MP', 'Philippine languages 32.8%, Chamorro (official) 24.1%, English (official) 17%, other Pacific island languages 10.1%, Chinese 6.8%, other Asian languages 7.3%, other 1.9% (2010 est.)', 477),
(158, 'Norway', 'NO', 'NOR', 'no', 'NO', 578, '3144096', 47, '47', 'Europe', 'Oslo', 'Europe/Oslo', 'Krone', 'no,nb,nn,se,fi', 'Bokmal Norwegian (official), Nynorsk Norwegian (official), small Sami- and Finnish-speaking minorities', 324220),
(159, 'Oman', 'OM', 'OMN', 'om', 'MU', 512, '286963', 968, '968', 'Asia', 'Muscat', 'Asia/Muscat', 'Rial', 'ar-OM,en,bal,ur', 'Arabic (official), English, Baluchi, Urdu, Indian dialects', 212460),
(160, 'Pakistan', 'PK', 'PAK', 'pk', 'PK', 586, '1168579', 92, '92', 'Asia', 'Islamabad', 'Asia/Karachi', 'Rupee', 'ur-PK,en-PK,pa,sd,ps,brh', 'Punjabi 48%, Sindhi 12%, Saraiki (a Punjabi variant) 10%, Pashto (alternate name, Pashtu) 8%, Urdu (official) 8%, Balochi 3%, Hindko 2%, Brahui 1%, English (official; lingua franca of Pakistani elite and most government ministries), Burushaski, and other 8%', 803940),
(161, 'Palau', 'PW', 'PLW', 'pw', 'PS', 585, '1559582', 680, '680', 'Oceania', 'Melekeok', 'Pacific/Palau', 'Dollar', 'pau,sov,en-PW,tox,ja,fil,zh', 'Palauan (official on most islands) 66.6%, Carolinian 0.7%, other Micronesian 0.7%, English (official) 15.5%, Filipino 10.8%, Chinese 1.8%, other Asian 2.6%, other 1.3%', 458),
(162, 'Palestine', 'PS', 'PSE', 'ps', 'WE', 275, '6254930', 970, '970', 'Asia', 'East Jerusalem', 'Asia/Hebron', 'Shekel', 'ar-PS', 'Arabic, Hebrew, English', 5970),
(163, 'Panama', 'PA', 'PAN', 'pa', 'PM', 591, '3703430', 507, '507', 'North America', 'Panama City', 'America/Panama', 'Balboa', 'es-PA,en', 'Spanish (official), English 14%', 78200),
(164, 'Papua New Guinea', 'PG', 'PNG', 'pg', 'PP', 598, '2088628', 675, '675', 'Oceania', 'Port Moresby', 'Pacific/Port_Moresby', 'Kina', 'en-PG,ho,meu,tpi', 'Tok Pisin (official), English (official), Hiri Motu (official), some 836 indigenous languages spoken (about 12% of the world\'s total); most languages have fewer than 1,000 speakers', 462840),
(165, 'Paraguay', 'PY', 'PRY', 'py', 'PA', 600, '3437598', 595, '595', 'South America', 'Asuncion', 'America/Asuncion', 'Guarani', 'es-PY,gn', 'Spanish (official), Guarani (official)', 406750),
(166, 'Peru', 'PE', 'PER', 'pe', 'PE', 604, '3932488', 51, '51', 'South America', 'Lima', 'America/Lima', 'Sol', 'es-PE,qu,ay', 'Spanish (official) 84.1%, Quechua (official) 13%, Aymara (official) 1.7%, Ashaninka 0.3%, other native languages (includes a large number of minor Amazonian languages) 0.7%, other (includes foreign languages and sign language) 0.2% (2007 est.)', 1285220),
(167, 'Philippines', 'PH', 'PHL', 'ph', 'RP', 608, '1694008', 63, '63', 'Asia', 'Manila', 'Asia/Manila', 'Peso', 'tl,en-PH,fil', 'Filipino (official; based on Tagalog) and English (official); eight major dialects - Tagalog, Cebuano, Ilocano, Hiligaynon or Ilonggo, Bicol, Waray, Pampango, and Pangasinan', 300000),
(168, 'Pitcairn', 'PN', 'PCN', 'pn', 'PC', 612, '4030699', 64, '64', 'Oceania', 'Adamstown', 'Pacific/Pitcairn', 'Dollar', 'en-PN', 'English', 47),
(169, 'Poland', 'PL', 'POL', 'pl', 'PL', 616, '798544', 48, '48', 'Europe', 'Warsaw', 'Europe/Warsaw', 'Zloty', 'pl', 'Polish (official) 96.2%, Polish and non-Polish 2%, non-Polish 0.5%, unspecified 1.3%', 312685),
(170, 'Portugal', 'PT', 'PRT', 'pt', 'PO', 620, '2264397', 351, '351', 'Europe', 'Lisbon', 'Europe/Lisbon', 'Euro', 'pt-PT,mwl', 'Portuguese (official), Mirandese (official, but locally used)', 92391),
(171, 'Puerto Rico', 'PR', 'PRI', 'pr', 'RQ', 630, '4566966', 1, '1787', 'North America', 'San Juan', 'America/Puerto_Rico', 'Dollar', 'en-PR,es-PR', 'Spanish, English', 9104),
(172, 'Qatar', 'QA', 'QAT', 'qa', 'QA', 634, '289688', 974, '974', 'Asia', 'Doha', 'Asia/Qatar', 'Rial', 'ar-QA,es', 'Arabic (official), English commonly used as a second language', 11437),
(173, 'Republic of the Congo', 'CG', 'COG', 'cg', 'CF', 178, '2260494', 242, '242', 'Africa', 'Brazzaville', 'Africa/Brazzaville', 'Franc', 'fr-CG,kg,ln-CG', 'French (official), Lingala and Monokutuba (lingua franca trade languages), many local languages and dialects (of which Kikongo is the most widespread)', 342000),
(174, 'Reunion', 'RE', 'REU', 're', 'RE', 638, '935317', 262, '262', 'Africa', 'Saint-Denis', 'Indian/Reunion', 'Euro', 'fr-RE', 'French', 2517),
(175, 'Romania', 'RO', 'ROU', 'ro', 'RO', 642, '798549', 40, '40', 'Europe', 'Bucharest', 'Europe/Bucharest', 'Leu', 'ro,hu,rom', 'Romanian (official) 85.4%, Hungarian 6.3%, Romany (Gypsy) 1.2%, other 1%, unspecified 6.1% (2011 est.)', 237500),
(176, 'Russia', 'RU', 'RUS', 'ru', 'RS', 643, '2017370', 7, '7', 'Europe', 'Moscow', 'Europe/Moscow', 'Ruble', 'ru,tt,xal,cau,ady,kv,ce,tyv,cv,udm,tut,mns,bua,myv,mdf,chm,ba,inh,tut,kbd,krc,ava,sah,nog', 'Russian (official) 96.3%, Dolgang 5.3%, German 1.5%, Chechen 1%, Tatar 3%, other 10.3%', 17100000),
(177, 'Rwanda', 'RW', 'RWA', 'rw', 'RW', 646, '49518', 250, '250', 'Africa', 'Kigali', 'Africa/Kigali', 'Franc', 'rw,en-RW,fr-RW,sw', 'Kinyarwanda only (official, universal Bantu vernacular) 93.2%, Kinyarwanda and other language(s) 6.2%, French (official) and other language(s) 0.1%, English (official) and other language(s) 0.1%, Swahili (or Kiswahili, used in commercial centers) 0.02%, other 0.03%, unspecified 0.3% (2002 est.)', 26338),
(178, 'Saint Barthelemy', 'BL', 'BLM', 'gp', 'TB', 652, '3578476', 590, '590', 'North America', 'Gustavia', 'America/St_Barthelemy', 'Euro', 'fr', 'French (primary), English', 21),
(179, 'Saint Helena', 'SH', 'SHN', 'sh', 'SH', 654, '3370751', 290, '290', 'Africa', 'Jamestown', 'Atlantic/St_Helena', 'Pound', 'en-SH', 'English', 410),
(180, 'Saint Kitts and Nevis', 'KN', 'KNA', 'kn', 'SC', 659, '3575174', 1, '1869', 'North America', 'Basseterre', 'America/St_Kitts', 'Dollar', 'en-KN', 'English (official)', 261),
(181, 'Saint Lucia', 'LC', 'LCA', 'lc', 'ST', 662, '3576468', 1, '1758', 'North America', 'Castries', 'America/St_Lucia', 'Dollar', 'en-LC', 'English (official), French patois', 616),
(182, 'Saint Martin', 'MF', 'MAF', 'gp', 'RN', 663, '3578421', 1, '590', 'North America', 'Marigot', 'America/Marigot', 'Euro', 'fr', 'French (official), English, Dutch, French Patois, Spanish, Papiamento (dialect of Netherlands Antilles)', 53),
(183, 'Saint Pierre and Miquelon', 'PM', 'SPM', 'pm', 'SB', 666, '3424932', 508, '508', 'North America', 'Saint-Pierre', 'America/Miquelon', 'Euro', 'fr-PM', 'French (official)', 242),
(184, 'Saint Vincent and the Grenadines', 'VC', 'VCT', 'vc', 'VC', 670, '3577815', 1, '1784', 'North America', 'Kingstown', 'America/St_Vincent', 'Dollar', 'en-VC,fr', 'English, French patois', 389),
(185, 'Samoa', 'WS', 'WSM', 'ws', 'WS', 882, '4034894', 685, '685', 'Oceania', 'Apia', 'Pacific/Apia', 'Tala', 'sm,en-WS', 'Samoan (Polynesian) (official), English', 2944),
(186, 'San Marino', 'SM', 'SMR', 'sm', 'SM', 674, '3168068', 378, '378', 'Europe', 'San Marino', 'Europe/San_Marino', 'Euro', 'it-SM', 'Italian', 61),
(187, 'Sao Tome and Principe', 'ST', 'STP', 'st', 'TP', 678, '2410758', 239, '239', 'Africa', 'Sao Tome', 'Africa/Sao_Tome', 'Dobra', 'pt-ST', 'Portuguese 98.4% (official), Forro 36.2%, Cabo Verdian 8.5%, French 6.8%, Angolar 6.6%, English 4.9%, Lunguie 1%, other (including sign language) 2.4%', 1001),
(188, 'Saudi Arabia', 'SA', 'SAU', 'sa', 'SA', 682, '102358', 966, '966', 'Asia', 'Riyadh', 'Asia/Riyadh', 'Rial', 'ar-SA', 'Arabic (official)', 1960582),
(189, 'Senegal', 'SN', 'SEN', 'sn', 'SG', 686, '2245662', 221, '221', 'Africa', 'Dakar', 'Africa/Dakar', 'Franc', 'fr-SN,wo,fuc,mnk', 'French (official), Wolof, Pulaar, Jola, Mandinka', 196190),
(190, 'Serbia', 'RS', 'SRB', 'rs', 'RI', 688, '6290252', 381, '381', 'Europe', 'Belgrade', 'Europe/Belgrade', 'Dinar', 'sr,hu,bs,rom', 'Serbian (official) 88.1%, Hungarian 3.4%, Bosnian 1.9%, Romany 1.4%, other 3.4%, undeclared or unknown 1.8%', 88361),
(191, 'Seychelles', 'SC', 'SYC', 'sc', 'SE', 690, '241170', 248, '248', 'Africa', 'Victoria', 'Indian/Mahe', 'Rupee', 'en-SC,fr-SC', 'Seychellois Creole (official) 89.1%, English (official) 5.1%, French (official) 0.7%, other 3.8%, unspecified 1.4% (2010 est.)', 455),
(192, 'Sierra Leone', 'SL', 'SLE', 'sl', 'SL', 694, '2403846', 232, '232', 'Africa', 'Freetown', 'Africa/Freetown', 'Leone', 'en-SL,men,tem', 'English (official, regular use limited to literate minority), Mende (principal vernacular in the south), Temne (principal vernacular in the north), Krio (English-based Creole, spoken by the descendants of freed Jamaican slaves who were settled in the Freetown area, a lingua franca and a first language for 10% of the population but understood by 95%)', 71740),
(193, 'Singapore', 'SG', 'SGP', 'sg', 'SN', 702, '1880251', 65, '65', 'Asia', 'Singapore', 'Asia/Singapore', 'Dollar', 'cmn,en-SG,ms-SG,ta-SG,zh-SG', 'Mandarin (official) 36.3%, English (official) 29.8%, Malay (official) 11.9%, Hokkien 8.1%, Tamil (official) 4.4%, Cantonese 4.1%, Teochew 3.2%, other Indian languages 1.2%, other Chinese dialects 1.1%, other 1.1% (2010 est.)', 693),
(194, 'Sint Maarten', 'SX', 'SXM', 'sx', 'NN', 534, '7609695', 1, '1721', 'North America', 'Philipsburg', 'America/Lower_Princes', 'Guilder', 'nl,en', 'English (official) 67.5%, Spanish 12.9%, Creole 8.2%, Dutch (official) 4.2%, Papiamento (a Spanish-Portuguese-Dutch-English dialect) 2.2%, French 1.5%, other 3.5% (2001 census)', 34),
(195, 'Slovakia', 'SK', 'SVK', 'sk', 'LO', 703, '3057568', 421, '421', 'Europe', 'Bratislava', 'Europe/Bratislava', 'Euro', 'sk,hu', 'Slovak (official) 78.6%, Hungarian 9.4%, Roma 2.3%, Ruthenian 1%, other or unspecified 8.8% (2011 est.)', 48845),
(196, 'Slovenia', 'SI', 'SVN', 'si', 'SI', 705, '3190538', 386, '386', 'Europe', 'Ljubljana', 'Europe/Ljubljana', 'Euro', 'sl,sh', 'Slovenian (official) 91.1%, Serbo-Croatian 4.5%, other or unspecified 4.4%, Italian (official, only in municipalities where Italian national communities reside), Hungarian (official, only in municipalities where Hungarian national communities reside) (2002 census)', 20273),
(197, 'Solomon Islands', 'SB', 'SLB', 'sb', 'BP', 90, '2103350', 677, '677', 'Oceania', 'Honiara', 'Pacific/Guadalcanal', 'Dollar', 'en-SB,tpi', 'Melanesian pidgin (in much of the country is lingua franca), English (official but spoken by only 1%-2% of the population), 120 indigenous languages', 28450),
(198, 'Somalia', 'SO', 'SOM', 'so', 'SO', 706, '51537', 252, '252', 'Africa', 'Mogadishu', 'Africa/Mogadishu', 'Shilling', 'so-SO,ar-SO,it,en-SO', 'Somali (official), Arabic (official, according to the Transitional Federal Charter), Italian, English', 637657),
(199, 'South Africa', 'ZA', 'ZAF', 'za', 'SF', 710, '953987', 27, '27', 'Africa', 'Pretoria', 'Africa/Johannesburg', 'Rand', 'zu,xh,af,nso,en-ZA,tn,st,ts,ss,ve,nr', 'IsiZulu (official) 22.7%, IsiXhosa (official) 16%, Afrikaans (official) 13.5%, English (official) 9.6%, Sepedi (official) 9.1%, Setswana (official) 8%, Sesotho (official) 7.6%, Xitsonga (official) 4.5%, siSwati (official) 2.5%, Tshivenda (official) 2.4%, isiNdebele (official) 2.1%, sign language 0.5%, other 1.6% (2011 est.)', 1219912),
(200, 'South Korea', 'KR', 'KOR', 'kr', 'KS', 410, '1835841', 82, '82', 'Asia', 'Seoul', 'Asia/Seoul', 'Won', 'ko-KR,en', 'Korean, English (widely taught in junior high and high school)', 98480),
(201, 'South Sudan', 'SS', 'SSD', 'ss', 'OD', 728, '7909807', 211, '211', 'Africa', 'Juba', 'Africa/Juba', 'Pound', 'en', 'English (official), Arabic (includes Juba and Sudanese variants), regional languages include Dinka, Nuer, Bari, Zande, Shilluk', 644329),
(202, 'Spain', 'ES', 'ESP', 'es', 'SP', 724, '2510769', 34, '34', 'Europe', 'Madrid', 'Europe/Madrid', 'Euro', 'es-ES,ca,gl,eu,oc', 'Castilian Spanish (official) 74%, Catalan 17%, Galician 7%, and Basque 2%', 504782),
(203, 'Sri Lanka', 'LK', 'LKA', 'lk', 'CE', 144, '1227603', 94, '94', 'Asia', 'Colombo', 'Asia/Colombo', 'Rupee', 'si,ta,en', 'Sinhala (official and national language) 74%, Tamil (national language) 18%, other 8%', 65610);
INSERT INTO `soft_countries` (`id`, `country`, `iso2`, `iso3`, `top_level_domain`, `fips`, `iso_numeric`, `geo_name_id`, `e164`, `country_code`, `continent`, `capital`, `timezone`, `currency`, `languages_codes`, `languages`, `areakm2`) VALUES
(204, 'Sudan', 'SD', 'SDN', 'sd', 'SU', 729, '366755', 249, '249', 'Africa', 'Khartoum', 'Africa/Khartoum', 'Pound', 'ar-SD,en,fia', 'Arabic (official), English (official), Nubian, Ta Bedawie, Fur', 1861484),
(205, 'Suriname', 'SR', 'SUR', 'sr', 'NS', 740, '3382998', 597, '597', 'South America', 'Paramaribo', 'America/Paramaribo', 'Dollar', 'nl-SR,en,srn,hns,jv', 'Dutch (official), English (widely spoken), Sranang Tongo (Surinamese, sometimes called Taki-Taki, is native language of Creoles and much of the younger population and is lingua franca among others), Caribbean Hindustani (a dialect of Hindi), Javanese', 163270),
(206, 'Svalbard and Jan Mayen', 'SJ', 'SJM', 'sj', 'SV', 744, '607072', 47, '47', 'Europe', 'Longyearbyen', 'Arctic/Longyearbyen', 'Krone', 'no,ru', 'Norwegian, Russian', 62049),
(207, 'Swaziland', 'SZ', 'SWZ', 'sz', 'WZ', 748, '934841', 268, '268', 'Africa', 'Mbabane', 'Africa/Mbabane', 'Lilangeni', 'en-SZ,ss-SZ', 'English (official, used for government business), siSwati (official)', 17363),
(208, 'Sweden', 'SE', 'SWE', 'se', 'SW', 752, '2661886', 46, '46', 'Europe', 'Stockholm', 'Europe/Stockholm', 'Krona', 'sv-SE,se,sma,fi-SE', 'Swedish (official), small Sami- and Finnish-speaking minorities', 449964),
(209, 'Switzerland', 'CH', 'CHE', 'ch', 'SZ', 756, '2658434', 41, '41', 'Europe', 'Berne', 'Europe/Zurich', 'Franc', 'de-CH,fr-CH,it-CH,rm', 'German (official) 64.9%, French (official) 22.6%, Italian (official) 8.3%, Serbo-Croatian 2.5%, Albanian 2.6%, Portuguese 3.4%, Spanish 2.2%, English 4.6%, Romansch (official) 0.5%, other 5.1%', 41290),
(210, 'Syria', 'SY', 'SYR', 'sy', 'SY', 760, '163843', 963, '963', 'Asia', 'Damascus', 'Asia/Damascus', 'Pound', 'ar-SY,ku,hy,arc,fr,en', 'Arabic (official), Kurdish, Armenian, Aramaic, Circassian (widely understood); French, English (somewhat understood)', 185180),
(211, 'Taiwan', 'TW', 'TWN', 'tw', 'TW', 158, '1668284', 886, '886', 'Asia', 'Taipei', 'Asia/Taipei', 'Dollar', 'zh-TW,zh,nan,hak', 'Mandarin Chinese (official), Taiwanese (Min), Hakka dialects', 35980),
(212, 'Tajikistan', 'TJ', 'TJK', 'tj', 'TI', 762, '1220409', 992, '992', 'Asia', 'Dushanbe', 'Asia/Dushanbe', 'Somoni', 'tg,ru', 'Tajik (official), Russian widely used in government and business', 143100),
(213, 'Tanzania', 'TZ', 'TZA', 'tz', 'TZ', 834, '149590', 255, '255', 'Africa', 'Dodoma', 'Africa/Dar_es_Salaam', 'Shilling', 'sw-TZ,en,ar', 'Kiswahili or Swahili (official), Kiunguja (name for Swahili in Zanzibar), English (official, primary language of commerce, administration, and higher education), Arabic (widely spoken in Zanzibar), many local languages', 945087),
(214, 'Thailand', 'TH', 'THA', 'th', 'TH', 764, '1605651', 66, '66', 'Asia', 'Bangkok', 'Asia/Bangkok', 'Baht', 'th,en', 'Thai (official) 90.7%, Burmese 1.3%, other 8%', 514000),
(215, 'Togo', 'TG', 'TGO', 'tg', 'TO', 768, '2363686', 228, '228', 'Africa', 'Lome', 'Africa/Lome', 'Franc', 'fr-TG,ee,hna,kbp,dag,ha', 'French (official, the language of commerce), Ewe and Mina (the two major African languages in the south), Kabye (sometimes spelled Kabiye) and Dagomba (the two major African languages in the north)', 56785),
(216, 'Tokelau', 'TK', 'TKL', 'tk', 'TL', 772, '4031074', 690, '690', 'Oceania', '', 'Pacific/Fakaofo', 'Dollar', 'tkl,en-TK', 'Tokelauan 93.5% (a Polynesian language), English 58.9%, Samoan 45.5%, Tuvaluan 11.6%, Kiribati 2.7%, other 2.5%, none 4.1%, unspecified 0.6%', 10),
(217, 'Tonga', 'TO', 'TON', 'to', 'TN', 776, '4032283', 676, '676', 'Oceania', 'Nuku\'alofa', 'Pacific/Tongatapu', 'Pa\'anga', 'to,en-TO', 'English and Tongan 87%, Tongan (official) 10.7%, English (official) 1.2%, other 1.1%, uspecified 0.03% (2006 est.)', 748),
(218, 'Trinidad and Tobago', 'TT', 'TTO', 'tt', 'TD', 780, '3573591', 1, '1868', 'North America', 'Port of Spain', 'America/Port_of_Spain', 'Dollar', 'en-TT,hns,fr,es,zh', 'English (official), Caribbean Hindustani (a dialect of Hindi), French, Spanish, Chinese', 5128),
(219, 'Tunisia', 'TN', 'TUN', 'tn', 'TS', 788, '2464461', 216, '216', 'Africa', 'Tunis', 'Africa/Tunis', 'Dinar', 'ar-TN,fr', 'Arabic (official, one of the languages of commerce), French (commerce), Berber (Tamazight)', 163610),
(220, 'Turkey', 'TR', 'TUR', 'tr', 'TU', 792, '298795', 90, '90', 'Asia', 'Ankara', 'Europe/Istanbul', 'Lira', 'tr-TR,ku,diq,az,av', 'Turkish (official), Kurdish, other minority languages', 780580),
(221, 'Turkmenistan', 'TM', 'TKM', 'tm', 'TX', 795, '1218197', 993, '993', 'Asia', 'Ashgabat', 'Asia/Ashgabat', 'Manat', 'tk,ru,uz', 'Turkmen (official) 72%, Russian 12%, Uzbek 9%, other 7%', 488100),
(222, 'Turks and Caicos Islands', 'TC', 'TCA', 'tc', 'TK', 796, '3576916', 1, '1649', 'North America', 'Cockburn Town', 'America/Grand_Turk', 'Dollar', 'en-TC', 'English (official)', 430),
(223, 'Tuvalu', 'TV', 'TUV', 'tv', 'TV', 798, '2110297', 688, '688', 'Oceania', 'Funafuti', 'Pacific/Funafuti', 'Dollar', 'tvl,en,sm,gil', 'Tuvaluan (official), English (official), Samoan, Kiribati (on the island of Nui)', 26),
(224, 'U.S. Virgin Islands', 'VI', 'VIR', 'vi', 'VQ', 850, '4796775', 1, '1340', 'North America', 'Charlotte Amalie', 'America/St_Thomas', 'Dollar', 'en-VI', 'English 74.7%, Spanish or Spanish Creole 16.8%, French or French Creole 6.6%, other 1.9% (2000 census)', 352),
(225, 'Uganda', 'UG', 'UGA', 'ug', 'UG', 800, '226074', 256, '256', 'Africa', 'Kampala', 'Africa/Kampala', 'Shilling', 'en-UG,lg,sw,ar', 'English (official national language, taught in grade schools, used in courts of law and by most newspapers and some radio broadcasts), Ganda or Luganda (most widely used of the Niger-Congo languages, preferred for native language publications in the capital and may be taught in school), other Niger-Congo languages, Nilo-Saharan languages, Swahili, Arabic', 236040),
(226, 'Ukraine', 'UA', 'UKR', 'ua', 'UP', 804, '690791', 380, '380', 'Europe', 'Kiev', 'Europe/Kiev', 'Hryvnia', 'uk,ru-UA,rom,pl,hu', 'Ukrainian (official) 67%, Russian (regional language) 24%, other (includes small Romanian-, Polish-, and Hungarian-speaking minorities) 9%', 603700),
(227, 'United Arab Emirates', 'AE', 'ARE', 'ae', 'AE', 784, '290557', 971, '971', 'Asia', 'Abu Dhabi', 'Asia/Dubai', 'Dirham', 'ar-AE,fa,en,hi,ur', 'Arabic (official), Persian, English, Hindi, Urdu', 82880),
(228, 'United Kingdom', 'GB', 'GBR', 'uk', 'UK', 826, '2635167', 44, '44', 'Europe', 'London', 'Europe/London', 'Pound', 'en-GB,cy-GB,gd', 'English', 244820),
(229, 'United States', 'US', 'USA', 'us', 'US', 840, '6252001', 1, '1', 'North America', 'Washington', 'America/New_York', 'Dollar', 'en-US,es-US,haw,fr', 'English 82.1%, Spanish 10.7%, other Indo-European 3.8%, Asian and Pacific island 2.7%, other 0.7% (2000 census)', 9629091),
(230, 'Uruguay', 'UY', 'URY', 'uy', 'UY', 858, '3439705', 598, '598', 'South America', 'Montevideo', 'America/Montevideo', 'Peso', 'es-UY', 'Spanish (official), Portunol, Brazilero (Portuguese-Spanish mix on the Brazilian frontier)', 176220),
(231, 'Uzbekistan', 'UZ', 'UZB', 'uz', 'UZ', 860, '1512440', 998, '998', 'Asia', 'Tashkent', 'Asia/Tashkent', 'Som', 'uz,ru,tg', 'Uzbek (official) 74.3%, Russian 14.2%, Tajik 4.4%, other 7.1%', 447400),
(232, 'Vanuatu', 'VU', 'VUT', 'vu', 'NH', 548, '2134431', 678, '678', 'Oceania', 'Port Vila', 'Pacific/Efate', 'Vatu', 'bi,en-VU,fr-VU', 'local languages (more than 100) 63.2%, Bislama (official; creole) 33.7%, English (official) 2%, French (official) 0.6%, other 0.5% (2009 est.)', 12200),
(233, 'Vatican', 'VA', 'VAT', 'va', 'VT', 336, '3164670', 39, '379', 'Europe', 'Vatican City', 'Europe/Vatican', 'Euro', 'la,it,fr', 'Latin, Italian, French', 0),
(234, 'Venezuela', 'VE', 'VEN', 've', 'VE', 862, '3625428', 58, '58', 'South America', 'Caracas', 'America/Caracas', 'Bolivar', 'es-VE', 'Spanish (official), numerous indigenous dialects', 912050),
(235, 'Vietnam', 'VN', 'VNM', 'vn', 'VM', 704, '1562822', 84, '84', 'Asia', 'Hanoi', 'Asia/Ho_Chi_Minh', 'Dong', 'vi,en,fr,zh,km', 'Vietnamese (official), English (increasingly favored as a second language), some French, Chinese, and Khmer, mountain area languages (Mon-Khmer and Malayo-Polynesian)', 329560),
(236, 'Wallis and Futuna', 'WF', 'WLF', 'wf', 'WF', 876, '4034749', 681, '681', 'Oceania', 'Mata Utu', 'Pacific/Wallis', 'Franc', 'wls,fud,fr-WF', 'Wallisian (indigenous Polynesian language) 58.9%, Futunian 30.1%, French (official) 10.8%, other 0.2% (2003 census)', 274),
(238, 'Yemen', 'YE', 'YEM', 'ye', 'YM', 887, '69543', 967, '967', 'Asia', 'Sanaa', 'Asia/Aden', 'Rial', 'ar-YE', 'Arabic (official)', 527970),
(239, 'Zambia', 'ZM', 'ZMB', 'zm', 'ZA', 894, '895949', 260, '260', 'Africa', 'Lusaka', 'Africa/Lusaka', 'Kwacha', 'en-ZM,bem,loz,lun,lue,ny,toi', 'Bembe 33.4%, Nyanja 14.7%, Tonga 11.4%, Lozi 5.5%, Chewa 4.5%, Nsenga 2.9%, Tumbuka 2.5%, Lunda (North Western) 1.9%, Kaonde 1.8%, Lala 1.8%, Lamba 1.8%, English (official) 1.7%, Luvale 1.5%, Mambwe 1.3%, Namwanga 1.2%, Lenje 1.1%, Bisa 1%, other 9.2%, unspecified 0.4%', 752614),
(240, 'Zimbabwe', 'ZW', 'ZWE', 'zw', 'ZI', 716, '878675', 263, '263', 'Africa', 'Harare', 'Africa/Harare', 'Dollar', 'en-ZW,sn,nr,nd', 'English (official), Shona, Sindebele (the language of the Ndebele, sometimes called Ndebele), numerous but minor tribal dialects', 390580);

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

--
-- Table structure for table `soft_days`
--

CREATE TABLE IF NOT EXISTS `soft_days` (
  `id` int NOT NULL AUTO_INCREMENT,
  `day` varchar(50) NOT NULL,
  `sort` int NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`id`),
  KEY `day` (`day`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `soft_days`
--

INSERT INTO `soft_days` (`id`, `day`, `sort`, `del`) VALUES
(1, 'Monday', 1, 'N'),
(2, 'Tuesday', 2, 'N'),
(3, 'Wednesday', 3, 'N'),
(4, 'Thursday', 4, 'N'),
(5, 'Friday', 5, 'N'),
(6, 'Saturday', 6, 'N'),
(7, 'Sunday', 0, 'N');

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

--
-- Table structure for table `users_contracts`
--

CREATE TABLE IF NOT EXISTS `users_contracts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `contract_type` varchar(50) NOT NULL,
  `contract_duration` varchar(20) NOT NULL,
  `probation_status` varchar(1) NOT NULL DEFAULT 'N',
  `probation_duration` varchar(20) NOT NULL,
  `allocated_leaves` int NOT NULL,
  `doj` varchar(20) NOT NULL,
  `dir` varchar(50) NOT NULL DEFAULT 'employee_contracts',
  `offer_letter` varchar(150) NOT NULL,
  `page_count` varchar(15) NOT NULL,
  `dt` varchar(20) NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  `user` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `user` (`user`),
  KEY `contract_type` (`contract_type`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_contracts`
--

INSERT INTO `users_contracts` (`id`, `user_id`, `contract_type`, `contract_duration`, `probation_status`, `probation_duration`, `allocated_leaves`, `doj`, `dir`, `offer_letter`, `page_count`, `dt`, `del`, `user`) VALUES
(1, 54, 'Full Time', '3', 'y', '20 Days', 20, '07/13/2023', 'employee_contracts', 'offer_letter_userid_54.pdf', '3 Pages', '1690318346', 'N', 'ehtesham'),
(2, 1, 'Full Time', '40', 'y', '85', 40, '07/27/2023', 'employee_contracts', 'offer_letter_userid_101.pdf', '1 Page', '1696253062', 'N', 'ehtesham');

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

--
-- Table structure for table `users_contracts_types`
--

CREATE TABLE IF NOT EXISTS `users_contracts_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`id`),
  KEY `type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_contracts_types`
--

INSERT INTO `users_contracts_types` (`id`, `type`, `del`) VALUES
(1, 'Full Time', 'N'),
(2, 'Part Time', 'N'),
(3, 'Freelance', 'N');

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

--
-- Table structure for table `users_departments`
--

CREATE TABLE IF NOT EXISTS `users_departments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `department` varchar(150) NOT NULL,
  `budget` int NOT NULL,
  `department_head` int NOT NULL,
  `dt` varchar(20) NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  `user` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `department_head` (`department_head`),
  KEY `department` (`department`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_departments`
--

INSERT INTO `users_departments` (`id`, `department`, `budget`, `department_head`, `dt`, `del`, `user`) VALUES
(1, 'Sales', 0, 206, '1688484513', 'N', 'ehtesham'),
(2, 'Digital Marketing', 0, 54, '1696664808', 'N', 'ehtesham'),
(5, 'Elaan Productions', 500000, 0, '1700064647', 'N', 'ehtesham');

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

--
-- Table structure for table `users_designations`
--

CREATE TABLE IF NOT EXISTS `users_designations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `designation` varchar(150) NOT NULL,
  `departments` varchar(50) NOT NULL,
  `sort` int NOT NULL,
  `dt` varchar(20) NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  `user` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `designation` (`designation`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_designations`
--

INSERT INTO `users_designations` (`id`, `designation`, `departments`, `sort`, `dt`, `del`, `user`) VALUES
(1, 'Manager Sales', '1', 1, '1688484513', 'N', 'ehtesham'),
(2, 'Digital Marketing Strategist', '2', 1, '1688484513', 'N', 'ehtesham'),
(3, 'Content Writer', '2', 2, '1688484513', 'N', 'ehtesham'),
(4, 'Digital Marketing Manager', '2', 0, '1688484513', 'N', 'ehtesham'),
(5, 'Assistant Director Sales', '1', 0, '1688484513', 'N', 'ehtesham');

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

--
-- Table structure for table `users_details`
--

CREATE TABLE IF NOT EXISTS `users_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `dob` varchar(20) NOT NULL,
  `address` text NOT NULL,
  `city` varchar(50) NOT NULL,
  `whatsapp` varchar(20) NOT NULL,
  `instagram` varchar(250) NOT NULL,
  `twitter` varchar(250) NOT NULL,
  `facebook` varchar(250) NOT NULL,
  `linkedin` varchar(250) NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  `dt` varchar(20) NOT NULL,
  `user` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `user` (`user`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_details`
--

INSERT INTO `users_details` (`id`, `user_id`, `dob`, `address`, `city`, `whatsapp`, `instagram`, `twitter`, `facebook`, `linkedin`, `del`, `dt`, `user`) VALUES
(4, 54, '09/21/1996', 'Office # 1, Second floor, Gulberg Trade Center, Gulberg Greens', 'Hunza Nagar', '03085602470', 'instagram.com/hannan', 'twitter.com/hannan', 'facebook.com/hannan', 'linkedin.com/hannan', 'N', '1690318381', 'ehtesham');

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

--
-- Table structure for table `users_genders`
--

CREATE TABLE IF NOT EXISTS `users_genders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `gender` varchar(50) NOT NULL,
  `sort` int NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  `dt` varchar(20) NOT NULL,
  `user` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `gender` (`gender`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_genders`
--

INSERT INTO `users_genders` (`id`, `gender`, `sort`, `del`, `dt`, `user`) VALUES
(1, 'Male', 1, 'N', '1689855112', 'ehtesham'),
(2, 'Female', 2, 'N', '1689855112', 'ehtesham');

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

--
-- Table structure for table `users_jobs`
--

CREATE TABLE IF NOT EXISTS `users_jobs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `offices` varchar(100) NOT NULL,
  `day_off` varchar(50) NOT NULL,
  `time_in` varchar(20) NOT NULL,
  `time_out` varchar(20) NOT NULL,
  `dt` varchar(20) NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  `user` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `user` (`user`),
  KEY `day_off` (`day_off`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_jobs`
--

INSERT INTO `users_jobs` (`id`, `user_id`, `offices`, `day_off`, `time_in`, `time_out`, `dt`, `del`, `user`) VALUES
(1, 206, '2,1', 'Sunday', '10:30 AM', '19:30 PM', '1690283637', 'N', 'ehtesham'),
(2, 54, '1', 'Sunday', '10:30 AM', '19:30 PM', '1690317500', 'N', 'ehtesham');

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

--
-- Table structure for table `users_logs`
--

CREATE TABLE IF NOT EXISTS `users_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `log_type` varchar(100) NOT NULL,
  `log_descp` text NOT NULL,
  `user` varchar(50) NOT NULL,
  `dt` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_logs`
--

INSERT INTO `users_logs` (`id`, `log_type`, `log_descp`, `user`, `dt`) VALUES
(1, 'Edit/Update', 'User ID 2 Suspended!', 'ehtesham', '1696664556'),
(2, 'Edit/Update', 'Department ID 2 Suspended!', 'ehtesham', '1696664800'),
(3, 'Edit/Update', 'Department ID 2 Activated!', 'ehtesham', '1696664808'),
(4, 'Edit/Update', 'User ID 162 Suspended!', 'ehtesham', '1696666797'),
(5, 'New User Created', 'New User Generated on User ID 207', 'ehtesham', '1699611160'),
(6, 'New User Created', 'New User Generated on User ID 208', 'ehtesham', '1699627162'),
(7, 'New User Created', 'New User Generated on User ID 209', 'ehtesham', '1700054493'),
(8, 'New Department Created', 'New Department Generated on Department ID 5', 'ehtesham', '1700054617');

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

--
-- Table structure for table `users_offices`
--

CREATE TABLE IF NOT EXISTS `users_offices` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `address` text NOT NULL,
  `type` varchar(100) NOT NULL,
  `number` varchar(20) NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  `dt` varchar(20) NOT NULL,
  `user` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_offices`
--

INSERT INTO `users_offices` (`id`, `name`, `address`, `type`, `number`, `del`, `dt`, `user`) VALUES
(1, 'Elaan Head Office', 'Office No. 1, Second Floor, Gulberg Trade Center, Gulberg Greens, Islamabad', 'Head Office', '051111222679', 'N', '1690277773', 'ehtesham'),
(2, 'Elaan Corporate Office', 'Office No. 1 & 2, First Floor, Sector G-11 Markaz, Islamabad', 'Corporate Office', '051111222679', 'N', '1690277773', 'ehtesham');

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

--
-- Table structure for table `users_salaries`
--

CREATE TABLE IF NOT EXISTS `users_salaries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `salary` int NOT NULL,
  `health_check` varchar(10) NOT NULL,
  `health_type` varchar(10) NOT NULL DEFAULT 'N/A',
  `health_value` int NOT NULL,
  `travel_check` varchar(10) NOT NULL,
  `travel_type` varchar(10) NOT NULL DEFAULT 'N/A',
  `travel_value` int NOT NULL,
  `food_check` varchar(10) NOT NULL,
  `food_type` varchar(10) NOT NULL DEFAULT 'N/A',
  `food_value` int NOT NULL,
  `overtime_check` varchar(10) NOT NULL,
  `overtime_type` varchar(10) NOT NULL DEFAULT 'N/A',
  `overtime_value` int NOT NULL,
  `overtime_per` varchar(20) NOT NULL,
  `commission_check` varchar(10) NOT NULL,
  `commission_type` varchar(10) NOT NULL DEFAULT 'N/A',
  `commission_value` int NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  `dt` varchar(20) NOT NULL,
  `user` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `health_type` (`health_type`),
  KEY `travel_type` (`travel_type`),
  KEY `food_type` (`food_type`),
  KEY `overtime_type` (`overtime_type`),
  KEY `commission_type` (`commission_type`),
  KEY `user` (`user`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_salaries`
--

INSERT INTO `users_salaries` (`id`, `user_id`, `salary`, `health_check`, `health_type`, `health_value`, `travel_check`, `travel_type`, `travel_value`, `food_check`, `food_type`, `food_value`, `overtime_check`, `overtime_type`, `overtime_value`, `overtime_per`, `commission_check`, `commission_type`, `commission_value`, `del`, `dt`, `user`) VALUES
(0, 206, 100000, 'on', '%', 16, 'on', 'Rs', 20000, '', 'N/A', 0, 'on', 'Rs', 2018, 'h', 'on', '%', 12, 'N', '1690305858', 'ehtesham'),
(6, 54, 75000, 'on', 'Rs', 2500, 'on', 'Rs', 5000, '', 'N/A', 0, 'on', 'Rs', 8500, 'h', '', 'N/A', 0, 'N', '1690317499', 'ehtesham');

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

--
-- Table structure for table `users_teams`
--

CREATE TABLE IF NOT EXISTS `users_teams` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `manager_id` int NOT NULL,
  `zone_id` int NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  `dt` varchar(20) NOT NULL,
  `user` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `manager_id` (`manager_id`),
  KEY `user` (`user`),
  KEY `zone_id` (`zone_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_types`
--

CREATE TABLE IF NOT EXISTS `users_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `permission_level` decimal(10,1) NOT NULL,
  `del` varchar(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `category` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_types`
--

INSERT INTO `users_types` (`id`, `type`, `permission_level`, `del`) VALUES
(1, 'admin', '9.0', 'N'),
(2, 'standard', '3.0', 'N'),
(3, 'manager', '4.0', 'N'),
(4, 'user', '0.0', 'N'),
(5, 'accounts', '3.0', 'N'),
(6, 'dealer', '3.0', 'N'),
(7, 'director', '6.0', 'N'),
(8, 'zone_manager', '5.0', 'N');

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

--
-- Table structure for table `users_zones`
--

CREATE TABLE IF NOT EXISTS `users_zones` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `zonal_manager` int NOT NULL,
  `del` varchar(1) NOT NULL DEFAULT 'N',
  `dt` varchar(20) NOT NULL,
  `user` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `zonal_manager` (`zonal_manager`),
  KEY `user` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Constraints for table `users_contracts`
--
ALTER TABLE `users_contracts`
  ADD CONSTRAINT `users_contracts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_contracts_ibfk_2` FOREIGN KEY (`user`) REFERENCES `users` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_contracts_ibfk_3` FOREIGN KEY (`contract_type`) REFERENCES `users_contracts_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `users_departments`
--
ALTER TABLE `users_departments`
  ADD CONSTRAINT `users_departments_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `users_designations`
--
ALTER TABLE `users_designations`
  ADD CONSTRAINT `users_designations_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `users_details`
--
ALTER TABLE `users_details`
  ADD CONSTRAINT `users_details_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_details_ibfk_2` FOREIGN KEY (`user`) REFERENCES `users` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `users_genders`
--
ALTER TABLE `users_genders`
  ADD CONSTRAINT `users_genders_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `users_jobs`
--
ALTER TABLE `users_jobs`
  ADD CONSTRAINT `users_jobs_ibfk_1` FOREIGN KEY (`day_off`) REFERENCES `soft_days` (`day`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_jobs_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_jobs_ibfk_3` FOREIGN KEY (`user`) REFERENCES `users` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `users_offices`
--
ALTER TABLE `users_offices`
  ADD CONSTRAINT `users_offices_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `users_salaries`
--
ALTER TABLE `users_salaries`
  ADD CONSTRAINT `users_salaries_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_salaries_ibfk_2` FOREIGN KEY (`user`) REFERENCES `users` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_salaries_ibfk_3` FOREIGN KEY (`commission_type`) REFERENCES `soft_addon_types` (`sign`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_salaries_ibfk_4` FOREIGN KEY (`food_type`) REFERENCES `soft_addon_types` (`sign`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_salaries_ibfk_5` FOREIGN KEY (`health_type`) REFERENCES `soft_addon_types` (`sign`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_salaries_ibfk_6` FOREIGN KEY (`overtime_type`) REFERENCES `soft_addon_types` (`sign`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_salaries_ibfk_7` FOREIGN KEY (`travel_type`) REFERENCES `soft_addon_types` (`sign`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `users_teams`
--
ALTER TABLE `users_teams`
  ADD CONSTRAINT `users_teams_ibfk_1` FOREIGN KEY (`manager_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_teams_ibfk_2` FOREIGN KEY (`user`) REFERENCES `users` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_teams_ibfk_3` FOREIGN KEY (`zone_id`) REFERENCES `users_zones` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `users_zones`
--
ALTER TABLE `users_zones`
  ADD CONSTRAINT `users_zones_ibfk_1` FOREIGN KEY (`zonal_manager`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `users_zones_ibfk_3` FOREIGN KEY (`user`) REFERENCES `users` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

