-- phpMyAdmin SQL Dump
-- version 3.3.8.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 17, 2011 at 07:22 PM
-- Server version: 5.0.91
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

--
-- Database: `tubeemne_tubserv`
--

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

--
-- Table structure for table `Location_Area`
--

CREATE TABLE IF NOT EXISTS `Location_Area` (
 `id` int(11) NOT NULL auto_increment,
 `city_id` int(11) NOT NULL default '0',
 `name` varchar(100) NOT NULL default '',
 `abbreviation` varchar(100) NOT NULL,
 `friendly_url` varchar(255) NOT NULL default '',
 `seo_description` varchar(255) NOT NULL,
 `seo_keywords` varchar(255) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `city_id` (`city_id`),
 KEY `friendly_url` (`friendly_url`),
 KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `Location_Area`
--


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

--
-- Table structure for table `Location_City`
--

CREATE TABLE IF NOT EXISTS `Location_City` (
 `id` int(11) NOT NULL auto_increment,
 `region_id` int(11) NOT NULL default '0',
 `name` varchar(100) NOT NULL default '',
 `abbreviation` varchar(100) NOT NULL,
 `friendly_url` varchar(255) NOT NULL default '',
 `seo_description` varchar(255) NOT NULL,
 `seo_keywords` varchar(255) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `region_id` (`region_id`),
 KEY `friendly_url` (`friendly_url`),
 KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `Location_City`
--


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

--
-- Table structure for table `Location_Country`
--

CREATE TABLE IF NOT EXISTS `Location_Country` (
 `id` int(11) NOT NULL auto_increment,
 `name` varchar(100) NOT NULL default '',
 `abbreviation` varchar(100) NOT NULL,
 `friendly_url` varchar(255) NOT NULL default '',
 `seo_description` varchar(255) NOT NULL,
 `seo_keywords` varchar(255) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `friendly_url` (`friendly_url`),
 KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=236 ;

--
-- Dumping data for table `Location_Country`
--

INSERT INTO `Location_Country` (`id`, `name`, `abbreviation`, `friendly_url`, `seo_description`, `seo_keywords`) VALUES
(235, 'Pakistan', 'PK', 'pakistan', 'Pakistan', 'Pakistan');

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

--
-- Table structure for table `Location_Region`
--

CREATE TABLE IF NOT EXISTS `Location_Region` (
 `id` int(11) NOT NULL auto_increment,
 `state_id` int(11) NOT NULL default '0',
 `name` varchar(100) NOT NULL default '',
 `abbreviation` varchar(100) NOT NULL,
 `friendly_url` varchar(255) NOT NULL default '',
 `seo_description` varchar(255) NOT NULL,
 `seo_keywords` varchar(255) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `friendly_url` (`friendly_url`),
 KEY `state_id` (`state_id`),
 KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=780 ;

--
-- Dumping data for table `Location_Region`
--

INSERT INTO `Location_Region` (`id`, `state_id`, `name`, `abbreviation`, `friendly_url`, `seo_description`, `seo_keywords`) VALUES
(771, 3426, 'Peshawar', 'Peshawar', 'peshawar', 'Peshawar', 'Peshawar'),
(690, 3419, 'Mianwali', 'Mianwali', 'mianwali', 'Mianwali', 'Mianwali'),
(689, 3419, 'Mian Channu', 'Mian Channu', 'mian-channu', 'Mian Channu', 'Mian Channu'),
(770, 3426, 'Paharpur', 'Paharpur', 'paharpur', 'Paharpur', 'Paharpur'),
(768, 3426, 'Mingora', 'Mingora', 'mingora', 'Mingora', 'Mingora'),
(769, 3426, 'Nowshera', 'Nowshera', 'nowshera', 'Nowshera', 'Nowshera'),
(686, 3419, 'Mandi Bahauddin', 'Mandi Bahauddin', 'mandi-bahauddin', 'Mandi Bahauddin', 'Mandi Bahauddin'),
(685, 3419, 'Mailsi', 'Mailsi', 'mailsi', 'Mailsi', 'Mailsi'),
(767, 3426, 'Mastuj', 'Mastuj', 'mastuj', 'Mastuj', 'Mastuj'),
(766, 3426, 'Mardan', 'Mardan', 'mardan', 'Mardan', 'Mardan'),
(682, 3419, 'Mamoori', 'Mamoori', 'mamoori', 'Mamoori', 'Mamoori'),
(764, 3426, 'Madyan', 'Madyan', 'madyan', 'Madyan', 'Madyan'),
(765, 3426, 'Mansehra', 'Mansehra', 'mansehra', 'Mansehra', 'Mansehra'),
(763, 3426, 'Latamber', 'Latamber', 'latamber', 'Latamber', 'Latamber'),
(677, 3419, 'Lodhran', 'Lodhran', 'lodhran', 'Lodhran', 'Lodhran'),
(676, 3419, 'Liaquat Pur', 'Liaquat Pur', 'liaquat-pur', 'Liaquat Pur', 'Liaquat Pur'),
(761, 3426, 'Kohat', 'Kohat', 'kohat', 'Kohat', 'Kohat'),
(762, 3426, 'Lakki Marwat', 'Lakki Marwat', 'lakki-marwat', 'Lakki Marwat', 'Lakki Marwat'),
(674, 3419, 'Layyah', 'Layyah', 'layyah', 'Layyah', 'Layyah'),
(760, 3426, 'Karak', 'Karak', 'karak', 'Karak', 'Karak'),
(759, 3426, 'Haripur', 'Haripur', 'haripur', 'Haripur', 'Haripur'),
(671, 3419, 'Lalamusa', 'Lalamusa', 'lalamusa', 'Lalamusa', 'Lalamusa'),
(758, 3426, 'Drosh', 'Drosh', 'drosh', 'Drosh', 'Drosh'),
(757, 3426, 'Dir', 'Dir', 'dir', 'Dir', 'Dir'),
(668, 3419, 'Lahore', 'Lahore', 'lahore', 'Lahore', 'Lahore'),
(667, 3419, 'Jauharabad', 'Jauharabad', 'jauharabad', 'Jauharabad', 'Jauharabad'),
(756, 3426, 'Dera Ismail Khan', 'Dera Ismail Khan', 'dera-ismail-khan', 'Dera Ismail Khan', 'Dera Ismail Khan'),
(755, 3426, 'Darya Khan', 'Darya Khan', 'darya-khan', 'Darya Khan', 'Darya Khan'),
(664, 3419, 'Kot Adu', 'Kot Adu', 'kot-adu', 'Kot Adu', 'Kot Adu'),
(663, 3419, 'Khushab', 'Khushab', 'khushab', 'Khushab', 'Khushab'),
(753, 3426, 'Daggar', 'Daggar', 'daggar', 'Daggar', 'Daggar'),
(754, 3426, 'Dargai', 'Dargai', 'dargai', 'Dargai', 'Dargai'),
(661, 3419, 'Kharian', 'Kharian', 'kharian', 'Kharian', 'Kharian'),
(660, 3419, 'Khanpur', 'Khanpur', 'khanpur', 'Khanpur', 'Khanpur'),
(751, 3426, 'Charsadda', 'Charsadda', 'charsadda', 'Charsadda', 'Charsadda'),
(752, 3426, 'Chitral', 'Chitral', 'chitral', 'Chitral', 'Chitral'),
(657, 3419, 'Khanewal', 'Khanewal', 'khanewal', 'Khanewal', 'Khanewal'),
(656, 3419, 'Kāmoke', 'Kāmoke', 'kmoke', 'Kāmoke', 'Kāmoke'),
(655, 3419, 'Kamalia', 'Kamalia', 'kamalia', 'Kamalia', 'Kamalia'),
(750, 3426, 'Chakdara', 'Chakdara', 'chakdara', 'Chakdara', 'Chakdara'),
(653, 3419, 'Kasur', 'Kasur', 'kasur', 'Kasur', 'Kasur'),
(652, 3419, 'Karor Lal Esan', 'Karor Lal Esan', 'karor-lal-esan', 'Karor Lal Esan', 'Karor Lal Esan'),
(749, 3426, 'Birote', 'Birote', 'birote', 'Birote', 'Birote'),
(650, 3419, 'Kalabagh', 'Kalabagh', 'kalabagh', 'Kalabagh', 'Kalabagh'),
(776, 3426, 'Tank', 'Tank', 'tank', 'Tank', 'Tank'),
(648, 3419, 'Jhelum', 'Jhelum', 'jhelum', 'Jhelum', 'Jhelum'),
(647, 3419, 'Jhang', 'Jhang', 'jhang', 'Jhang', 'Jhang'),
(777, 3426, 'Thall', 'Thall', 'thall', 'Thall', 'Thall'),
(778, 3426, 'Timergara', 'Timergara', 'timergara', 'Timergara', 'Timergara'),
(645, 3419, 'Jaranwala ', 'Jaranwala ', 'jaranwala', 'Jaranwala\r\n', 'Jaranwala\r\n'),
(644, 3419, 'Jampur', 'Jampur', 'jampur', 'Jampur', 'Jampur'),
(643, 3419, 'Jalalpur Jattan', 'Jalalpur Jattan', 'jalalpur-jattan', 'Jalalpur Jattan', 'Jalalpur Jattan'),
(642, 3419, 'Haveli Lakha', 'Haveli Lakha', 'haveli-lakha', 'Haveli Lakha', 'Haveli Lakha'),
(641, 3419, 'Hafizabad', 'Hafizabad', 'hafizabad', 'Hafizabad', 'Hafizabad'),
(640, 3419, 'Haroonabad', 'Haroonabad', 'haroonabad', 'Haroonabad', 'Haroonabad'),
(639, 3420, 'Warah', 'Warah', 'warah', 'Warah', 'Warah'),
(638, 3420, 'Umerkot', 'Umerkot', 'umerkot', 'Umerkot', 'Umerkot'),
(637, 3419, 'Gujar Khan', 'Gujar Khan', 'gujar-khan', 'Gujar Khan', 'Gujar Khan'),
(636, 3420, 'Qasimabad', 'Qasimabad', 'qasimabad', 'Qasimabad', 'Qasimabad'),
(635, 3419, 'Gujrat', 'Gujrat', 'gujrat', 'Gujrat', 'Gujrat'),
(634, 3420, 'Thatta', 'Thatta', 'thatta', 'Thatta', 'Thatta'),
(633, 3419, 'Gujranwala', 'Gujranwala', 'gujranwala', 'Gujranwala', 'Gujranwala'),
(632, 3420, 'Tando Muhammad Khan', 'Tando Muhammad Khan', 'tando-muhammad-khan', 'Tando Muhammad Khan', 'Tando Muhammad Khan'),
(631, 3419, 'Gojra', 'Gojra', 'gojra', 'Gojra', 'Gojra'),
(630, 3420, 'Tando Allahyar', 'Tando Allahyar', 'tando-allahyar', 'Tando Allahyar', 'Tando Allahyar'),
(629, 3419, 'Ghakhar Mandi', 'Ghakhar Mandi', 'ghakhar-mandi', 'Ghakhar Mandi', 'Ghakhar Mandi'),
(628, 3420, 'Tando Adam Khan', 'Tando Adam Khan', 'tando-adam-khan', 'Tando Adam Khan', 'Tando Adam Khan'),
(627, 3420, 'Sukkur', 'Sukkur', 'sukkur', 'Sukkur', 'Sukkur'),
(626, 3419, 'Fateh Jang', 'Fateh Jang', 'fateh-jang', 'Fateh Jang', 'Fateh Jang'),
(625, 3420, 'Shikarpaur', 'Shikarpaur', 'shikarpaur', 'Shikarpaur', 'Shikarpaur'),
(624, 3419, 'Dibalpur', 'Dibalpur', 'dibalpur', 'Dibalpur', 'Dibalpur'),
(623, 3420, 'Shahpur Chakar', 'Shahpur Chakar', 'shahpur-chakar', 'Shahpur Chakar', 'Shahpur Chakar'),
(622, 3420, 'Shahdadpur', 'Shahdadpur', 'shahdadpur', 'Shahdadpur', 'Shahdadpur'),
(621, 3420, 'Shahdadkot', 'Shahdadkot', 'shahdadkot', 'Shahdadkot', 'Shahdadkot'),
(620, 3419, 'Faisalabad', 'Faisalabad', 'faisalabad', 'Faisalabad', 'Faisalabad'),
(619, 3420, 'Shahbandar', 'Shahbandar', 'shahbandar', 'Shahbandar', 'Shahbandar'),
(618, 3420, 'Sanghar', 'Sanghar', 'sanghar', 'Sanghar', 'Sanghar'),
(617, 3420, 'Sakrand', 'Sakrand', 'sakrand', 'Sakrand', 'Sakrand'),
(616, 3420, 'Rohri', 'Rohri', 'rohri', 'Rohri', 'Rohri'),
(615, 3420, 'Ratodero', 'Ratodero', 'ratodero', 'Ratodero', 'Ratodero'),
(614, 3419, 'Dinga', 'Dinga', 'dinga', 'Dinga', 'Dinga'),
(613, 3420, 'Ranipur', 'Ranipur', 'ranipur', 'Ranipur', 'Ranipur'),
(612, 3419, 'Dina', 'Dina', 'dina', 'Dina', 'Dina'),
(611, 3420, 'Nazimabad', 'Nazimabad', 'nazimabad', 'Nazimabad', 'Nazimabad'),
(610, 3420, 'Nawabshah', 'Nawabshah', 'nawabshah', 'Nawabshah', 'Nawabshah\r\n'),
(609, 3419, 'Dhaular', 'Dhaular', 'dhaular', 'Dhaular', 'Dhaular'),
(608, 3419, 'Dera Ghazi Khan', 'Dera Ghazi Khan', 'dera-ghazi-khan', 'Dera Ghazi Khan', 'Dera Ghazi Khan'),
(607, 3420, 'Naushara', 'Naushara', 'naushara', 'Naushara', 'Naushara'),
(606, 3420, 'Naushahro Feroze', 'Naushahro Feroze', 'naushahro-feroze', 'Naushahro Feroze', 'Naushahro Feroze'),
(605, 3420, 'Naudero', 'Naudero', 'naudero', 'Naudero', 'Naudero'),
(604, 3420, 'Nagarparkar', 'Nagarparkar', 'nagarparkar', 'Nagarparkar', 'Nagarparkar'),
(603, 3419, 'Darya Khan', 'Darya Khan', 'darya-khan', 'Darya Khan', 'Darya Khan'),
(602, 3419, 'Daska', 'Daska', 'daska', 'Daska', 'Daska'),
(601, 3419, 'Chishtian', 'Chishtian', 'chishtian', 'Chishtian', 'Chishtian'),
(600, 3419, 'Chiniot', 'Chiniot', 'chiniot', 'Chiniot', 'Chiniot'),
(599, 3419, 'Chichawatni', 'Chichawatni', 'chichawatni', 'Chichawatni', 'Chichawatni'),
(598, 3419, 'Chakwal', 'Chakwal', 'chakwal', 'Chakwal', 'Chakwal'),
(597, 3419, 'Chillianwala', 'Chillianwala', 'chillianwala', 'Chillianwala', 'Chillianwala'),
(596, 3419, 'Burewala', 'Burewala', 'burewala', 'Burewala', 'Burewala'),
(595, 3419, 'Bhakkar', 'Bhakkar', 'bhakkar', 'Bhakkar', 'Bhakkar'),
(594, 3420, 'Moro', 'Moro', 'moro', 'Moro', 'Moro'),
(593, 3420, 'Mehrabpur', 'Mehrabpur', 'mehrabpur', 'Mehrabpur', 'Mehrabpur'),
(592, 3420, 'Mithi', 'Mithi', 'mithi', 'Mithi', 'Mithi'),
(591, 3420, 'Mithani', 'Mithani', 'mithani', 'Mithani', 'Mithani'),
(590, 3420, 'Mirpur Khas', 'Mirpur Khas', 'mirpur-khas', 'Mirpur Khas', 'Mirpur Khas'),
(589, 3420, 'Mehar', 'Mehar', 'mehar', 'Mehar', 'Mehar'),
(588, 3420, 'Matiari', 'Matiari', 'matiari', 'Matiari', 'Matiari'),
(587, 3420, 'Larkana', 'Larkana', 'larkana', 'Larkana', 'Larkana'),
(586, 3420, 'Kotri', 'Kotri', 'kotri', 'Kotri', 'Kotri'),
(585, 3420, 'Khairpur', 'Khairpur', 'khairpur', 'Khairpur', 'Khairpur'),
(584, 3419, 'Bahawalpur', 'Bahawalpur', 'bahawalpur', 'Bahawalpur', 'Bahawalpur'),
(583, 3420, 'Keti Bandar', 'Keti Bandar', 'keti-bandar', 'Keti Bandar', 'Keti Bandar'),
(582, 3419, 'Bahawalnagar', 'Bahawalnagar', 'bahawalnagar', 'Bahawalnagar', 'Bahawalnagar'),
(581, 3420, 'Kashmore', 'Kashmore', 'kashmore', 'Kashmore', 'Kashmore'),
(580, 3420, 'Karachi', 'Karachi', 'karachi', 'Karachi', 'Karachi'),
(579, 3419, 'Bhalwal', 'Bhalwal', 'bhalwal', 'Bhalwal', 'Bhalwal'),
(578, 3419, 'Attock', 'Attock', 'attock', 'Attock', 'Attock'),
(577, 3420, 'Kandiaro', 'Kandiaro', 'kandiaro', 'Kandiaro', 'Kandiaro'),
(576, 3420, 'Kandhkot', 'Kandhkot', 'kandhkot', 'Kandhkot', 'Kandhkot'),
(575, 3420, 'Jungshahi', 'Jungshahi', 'jungshahi', 'Jungshahi', 'Jungshahi'),
(574, 3419, 'Arifwala', 'Arifwala', 'arifwala', 'Arifwala', 'Arifwala'),
(573, 3420, 'Jamshoro', 'Jamshoro', 'jamshoro', 'Jamshoro', 'Jamshoro'),
(572, 3420, 'Jacobabad', 'Jacobabad', 'jacobabad', 'Jacobabad', 'Jacobabad'),
(571, 3420, 'Islamkot', 'Islamkot', 'islamkot', 'Islamkot', 'Islamkot'),
(570, 3419, 'Alipur', 'Alipur', 'alipur', 'Alipur', 'Alipur'),
(569, 3420, 'Hyderabad', 'Hyderabad', 'hyderabad', 'Hyderabad', 'Hyderabad'),
(568, 3420, 'Haala', 'Haala', 'haala', 'Haala', 'Haala'),
(567, 3420, 'Ghotki', 'Ghotki', 'ghotki', 'Ghotki', 'Ghotki'),
(566, 3420, 'Dokri', 'Dokri', 'dokri', 'Dokri', 'Dokri'),
(565, 3420, 'Diplo', 'Diplo', 'diplo', 'Diplo', 'Diplo'),
(564, 3420, 'Digri', 'Digri', 'digri', 'Digri', 'Digri'),
(563, 3419, 'Ahmed Nager Chatha', 'Ahmed Nager Chatha', 'ahmed-nager-chatha', 'Ahmed Nager Chatha', 'Ahmed Nager Chatha'),
(562, 3419, 'Ahmadpur East', 'Ahmadpur East', 'ahmadpur-east', 'Ahmadpur East', 'Ahmadpur East'),
(561, 3420, 'Dadu', 'Dadu', 'dadu', 'Dadu', 'Dadu'),
(560, 3420, 'Chak', 'Chak', 'chak', 'Chak', 'Chak'),
(559, 3420, 'Rajo Khanani', 'Rajo Khanani', 'rajo-khanani', 'Rajo Khanani', 'Rajo Khanani'),
(558, 3420, 'Bhirkan', 'Bhirkan', 'bhirkan', 'Bhirkan', 'Bhirkan'),
(557, 3420, 'Badin', 'Badin', 'badin', 'Badin', 'Badin'),
(556, 3421, 'Islamabad', 'Islamabad', 'islamabad', 'Islamabad', 'Islamabad'),
(772, 3426, 'Saidu Sharif', 'Saidu Sharif', 'saidu-sharif', 'Saidu Sharif', 'Saidu Sharif'),
(773, 3426, 'Swabi', 'Swabi', 'swabi', 'Swabi', 'Swabi'),
(774, 3426, 'Swat', 'Swat', 'swat', 'Swat', 'Swat'),
(775, 3426, 'Tangi', 'Tangi', 'tangi', 'Tangi', 'Tangi'),
(552, 3417, 'Kalat', 'Kalat', 'kalat', 'Kalat', 'Kalat'),
(551, 3417, 'Nushki', 'Nushki', 'nushki', 'Nushki', 'Nushki'),
(550, 3417, 'Mastung', 'Mastung', 'mastung', 'Mastung', 'Mastung'),
(549, 3417, 'Kharan', 'Kharan', 'kharan', 'Kharan', 'Kharan'),
(548, 3417, 'Pasni', 'Pasni', 'pasni', 'Pasni', 'Pasni'),
(547, 3417, 'Loralai', 'Loralai', 'loralai', 'Loralai', 'Loralai'),
(546, 3417, 'Usta Mohammad', 'Usta Mohammad', 'usta-mohammad', 'Usta Mohammad', 'Usta Mohammad'),
(545, 3417, 'Dera Allah Yar', 'Dera Allah Yar', 'dera-allah-yar', 'Dera Allah Yar', 'Dera Allah Yar'),
(544, 3417, 'Dera Murad Jamali', 'Dera Murad Jamali', 'dera-murad-jamali', 'Dera Murad Jamali', 'Dera Murad Jamali'),
(543, 3417, 'Gwadar', 'Gwadar', 'gwadar', 'Gwadar', 'Gwadar'),
(542, 3417, 'Zhob', 'Zhob', 'zhob', 'Zhob', 'Zhob'),
(541, 3417, 'Sibi', 'Sibi', 'sibi', 'Sibi', 'Sibi'),
(540, 3417, 'Hub', 'Hub', 'hub', 'Hub', 'Hub'),
(539, 3417, 'Chaman', 'Chaman', 'chaman', 'Chaman', 'Chaman'),
(538, 3417, 'Turbat', 'Turbat', 'turbat', 'Turbat', 'Turbat'),
(537, 3417, 'Khuzdar', 'Khuzdar', 'khuzdar', 'Khuzdar', 'Khuzdar'),
(536, 3417, 'Quetta', 'Quetta', 'quetta', 'Quetta', 'Quetta'),
(535, 3424, 'Thorar', 'Thorar', 'thorar', 'Thorar', 'Thorar'),
(534, 3424, 'Taghafari', 'Taghafari', 'taghafari', 'Taghafari', 'Taghafari'),
(533, 3424, 'Sust', 'Sust', 'sust', 'Sust', 'Sust'),
(532, 3424, 'Skardu', 'Skardu', 'skardu', 'Skardu', 'Skardu'),
(531, 3424, 'Shimshal', 'Shimshal', 'shimshal', 'Shimshal', 'Shimshal'),
(530, 3424, 'Passu', 'Passu', 'passu', 'Passu', 'Passu'),
(529, 3424, 'Misgar', 'Misgar', 'misgar', 'Misgar', 'Misgar'),
(528, 3424, 'Minimerg', 'Minimerg', 'minimerg', 'Minimerg', 'Minimerg'),
(527, 3424, 'Khaplu', 'Khaplu', 'khaplu', 'Khaplu', 'Khaplu'),
(526, 3424, 'Ishkoman', 'Ishkoman', 'ishkoman', 'Ishkoman', 'Ishkoman'),
(525, 3424, 'Karimabad (Hunza)', 'Karimabad (Hunza)', 'karimabad-hunza', 'Karimabad (Hunza)', 'Karimabad (Hunza)'),
(524, 3424, 'Ghulmat (Nagar)', 'Ghulmat (Nagar)', 'ghulmat-nagar', 'Ghulmat (Nagar)', 'Ghulmat (Nagar)'),
(523, 3424, 'Nagar Proper', 'Nagar Proper', 'nagar-proper', 'Nagar Proper', 'Nagar Proper'),
(522, 3424, 'Qasimabad Masoot (Nagar)', 'Qasimabad Masoot (Nagar)', 'qasimabad-masoot-nagar', 'Qasimabad Masoot (Nagar)', 'Qasimabad Masoot (Nagar)'),
(521, 3424, 'Thole (Nagar)', 'Thole (Nagar)', 'thole-nagar', 'Thole (Nagar)', 'Thole (Nagar)'),
(520, 3424, 'Chalt (Nagar)', 'Chalt (Nagar)', 'chalt-nagar', 'Chalt (Nagar)', 'Chalt (Nagar)'),
(519, 3424, 'Jaglot', 'Jaglot', 'jaglot', 'Jaglot', 'Jaglot'),
(518, 3424, 'Gulmit', 'Gulmit', 'gulmit', 'Gulmit', 'Gulmit'),
(517, 3424, 'Gorikot', 'Gorikot', 'gorikot', 'Gorikot', 'Gorikot'),
(516, 3424, 'Gilgit', 'Gilgit', 'gilgit', 'Gilgit', 'Gilgit'),
(515, 3424, 'Ghizer', 'Ghizer', 'ghizer', 'Ghizer', 'Ghizer'),
(514, 3424, 'Ghangche', 'Ghangche', 'ghangche', 'Ghangche', 'Ghangche'),
(513, 3424, 'Gakuch', 'Gakuch', 'gakuch', 'Gakuch', 'Gakuch'),
(512, 3424, 'Chiran', 'Chiran', 'chiran', 'Chiran', 'Chiran'),
(511, 3424, 'Chillinji', 'Chillinji', 'chillinji', 'Chillinji', 'Chillinji'),
(510, 3424, 'Chilas', 'Chilas', 'chilas', 'Chilas', 'Chilas'),
(509, 3424, 'Bunji (or Boanzhi)', 'Bunji (or Boanzhi)', 'bunji-or-boanzhi', 'Bunji (or Boanzhi)', 'Bunji (or Boanzhi)'),
(508, 3424, 'Astore', 'Astore', 'astore', 'Astore', 'Astore'),
(507, 3424, 'Askole', 'Askole', 'askole', 'Askole', 'Askole'),
(506, 3422, 'Wana', 'Wana', 'wana', 'Wana', 'Wana'),
(505, 3422, 'Sadda', 'Sadda', 'sadda', 'Sadda', 'Sadda'),
(504, 3422, 'Razmak', 'Razmak', 'razmak', 'Razmak', 'Razmak'),
(503, 3422, 'Parachinar', 'Parachinar', 'parachinar', 'Parachinar', 'Parachinar'),
(502, 3422, 'Miranshah', 'Miranshah', 'miranshah', 'Miranshah', 'Miranshah'),
(501, 3422, 'Mir Ali', 'Mir Ali', 'mir-ali', 'Mir Ali', 'Mir Ali'),
(500, 3422, 'Makeen', 'Makeen', 'makeen', 'Makeen', 'Makeen'),
(499, 3422, 'Landi Kotal', 'Landi Kotal', 'landi-kotal', 'Landi Kotal', 'Landi Kotal'),
(498, 3422, 'Khar', 'Khar', 'khar', 'Khar', 'Khar'),
(497, 3422, 'Jamrud', 'Jamrud', 'jamrud', 'Jamrud', 'Jamrud'),
(496, 3422, 'Ghulam Khana', 'Ghulam Khana', 'ghulam-khana', 'Ghulam Khana', 'Ghulam Khana'),
(495, 3422, 'Darra Adam Khel', 'Darra Adam Khel', 'darra-adam-khel', 'Darra Adam Khel', 'Darra Adam Khel'),
(494, 3422, 'Bara', 'Bara', 'bara', 'Bara', 'Bara'),
(493, 3422, 'Alizai', 'Alizai', 'alizai', 'Alizai', 'Alizai'),
(492, 3423, 'Pindi Bhatian', 'Pindi Bhatian', 'pindi-bhatian', 'Pindi Bhatian', 'Pindi Bhatian'),
(491, 3423, 'Hattian', 'Hattian', 'hattian', 'Hattian', 'Hattian'),
(490, 3423, 'Havelli,Farward Kahutta', 'Havelli,Farward Kahutta', 'havellifarward-kahutta', 'Havelli,Farward Kahutta', 'Havelli,Farward Kahutta'),
(489, 3423, 'Muzaffarabad', 'Muzaffarabad', 'muzaffarabad', 'Muzaffarabad', 'Muzaffarabad'),
(488, 3423, 'Mirpur', 'Mirpur', 'mirpur', 'Mirpur', 'Mirpur'),
(487, 3423, 'Mangla', 'Mangla', 'mangla', 'Mangla', 'Mangla'),
(486, 3423, 'Kotli', 'Kotli', 'kotli', 'Kotli', 'Kotli'),
(485, 3423, 'Khuiratta', 'Khuiratta', 'khuiratta', 'Khuiratta', 'Khuiratta'),
(484, 3423, 'Bhimber', 'Bhimber', 'bhimber', 'Bhimber', 'Bhimber'),
(483, 3423, 'Bagh', 'Bagh', 'bagh', 'Bagh', 'Bagh'),
(482, 3423, 'Rawalakot', 'Rawalakot', 'rawalakot', 'Rawalakot', 'Rawalakot'),
(693, 3419, 'Multan', 'Multan', 'multan', 'Multan', 'Multan'),
(694, 3419, 'Murree', 'Murree', 'murree', 'Murree', 'Murree'),
(696, 3419, 'Muridke', 'Muridke', 'muridke', 'Muridke', 'Muridke'),
(748, 3426, 'Battagram', 'Battagram', 'battagram', 'Battagram', 'Battagram'),
(698, 3419, 'Mianwali Bangla', 'Mianwali Bangla', 'mianwali-bangla', 'Mianwali Bangla', 'Mianwali Bangla'),
(747, 3426, 'Batkhela', 'Batkhela', 'batkhela', 'Batkhela', 'Batkhela'),
(700, 3419, 'Muzaffargarh', 'Muzaffargarh', 'muzaffargarh', 'Muzaffargarh', 'Muzaffargarh'),
(701, 3419, 'Narowal', 'Narowal', 'narowal', 'Narowal', 'Narowal'),
(702, 3419, 'Okara', 'Okara', 'okara', 'Okara', 'Okara'),
(746, 3426, 'Bannu', 'Bannu', 'bannu', 'Bannu', 'Bannu'),
(704, 3419, 'Renala Khurd', 'Renala Khurd', 'renala-khurd', 'Renala Khurd', 'Renala Khurd'),
(706, 3419, 'Pakpattan', 'Pakpattan', 'pakpattan', 'Pakpattan', 'Pakpattan'),
(745, 3426, 'Banda Daud Shah', 'Banda Daud Shah', 'banda-daud-shah', 'Banda Daud Shah', 'Banda Daud Shah'),
(708, 3419, 'Pattoki', 'Pattoki', 'pattoki', 'Pattoki', 'Pattoki'),
(744, 3426, 'Ayubia', 'Ayubia', 'ayubia', 'Ayubia', 'Ayubia'),
(710, 3419, 'Pir Mahal', 'Pir Mahal', 'pir-mahal', 'Pir Mahal', 'Pir Mahal'),
(712, 3419, 'Qila Didar Singh', 'Qila Didar Singh', 'qila-didar-singh', 'Qila Didar Singh', 'Qila Didar Singh'),
(743, 3426, 'Alpuri', 'Alpuri', 'alpuri', 'Alpuri', 'Alpuri'),
(714, 3419, 'Rabwah', 'Rabwah', 'rabwah', 'Rabwah', 'Rabwah'),
(716, 3419, 'Raiwind', 'Raiwind', 'raiwind', 'Raiwind', 'Raiwind'),
(742, 3426, 'Adezai', 'Adezai', 'adezai', 'Adezai', 'Adezai'),
(718, 3419, 'Rajanpur', 'Rajanpur', 'rajanpur', 'Rajanpur', 'Rajanpur'),
(720, 3419, 'Rahim Yar Khan', 'Rahim Yar Khan', 'rahim-yar-khan', 'Rahim Yar Khan', 'Rahim Yar Khan'),
(741, 3426, 'Abbottabad', 'Abbottabad', 'abbottabad', 'Abbottabad', 'Abbottabad'),
(722, 3419, 'Rawalpindi', 'Rawalpindi', 'rawalpindi', 'Rawalpindi', 'Rawalpindi'),
(723, 3419, 'Sadiqabad', 'Sadiqabad', 'sadiqabad', 'Sadiqabad', 'Sadiqabad'),
(724, 3419, 'Safdarabad', 'Safdarabad', 'safdarabad', 'Safdarabad', 'Safdarabad'),
(725, 3419, 'Sahiwal', 'Sahiwal', 'sahiwal', 'Sahiwal', 'Sahiwal'),
(726, 3419, 'Sangla Hill', 'Sangla Hill', 'sangla-hill', 'Sangla Hill', 'Sangla Hill'),
(727, 3419, 'Sarai Alamgir', 'Sarai Alamgir', 'sarai-alamgir', 'Sarai Alamgir', 'Sarai Alamgir'),
(728, 3419, 'Sargodha', 'Sargodha', 'sargodha', 'Sargodha', 'Sargodha'),
(729, 3419, 'Shakargarh', 'Shakargarh', 'shakargarh', 'Shakargarh', 'Shakargarh'),
(730, 3419, 'Sheikhupura', 'Sheikhupura', 'sheikhupura', 'Sheikhupura', 'Sheikhupura'),
(731, 3419, 'Sialkot', 'Sialkot', 'sialkot', 'Sialkot', 'Sialkot'),
(732, 3419, 'Sohawa', 'Sohawa', 'sohawa', 'Sohawa', 'Sohawa'),
(733, 3419, 'Soianwala', 'Soianwala', 'soianwala', 'Soianwala', 'Soianwala'),
(734, 3419, 'Siranwali', 'Siranwali', 'siranwali', 'Siranwali', 'Siranwali'),
(735, 3419, 'Talagang', 'Talagang', 'talagang', 'Talagang', 'Talagang'),
(736, 3419, 'Taxila', 'Taxila', 'taxila', 'Taxila', 'Taxila'),
(737, 3419, 'Toba Tek Singh', 'Toba Tek Singh', 'toba-tek-singh', 'Toba Tek Singh', 'Toba Tek Singh'),
(738, 3419, 'Vehari', 'Vehari', 'vehari', 'Vehari', 'Vehari'),
(739, 3419, 'Wah Cantonment', 'Wah Cantonment', 'wah-cantonment', 'Wah Cantonment', 'Wah Cantonment'),
(740, 3419, 'Wazirabad', 'Wazirabad', 'wazirabad', 'Wazirabad', 'Wazirabad'),
(779, 3426, 'Tordher', 'Tordher', 'tordher', 'Tordher', 'Tordher');

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

--
-- Table structure for table `Location_State`
--

CREATE TABLE IF NOT EXISTS `Location_State` (
 `id` int(11) NOT NULL auto_increment,
 `country_id` int(11) NOT NULL default '0',
 `name` varchar(100) NOT NULL default '',
 `abbreviation` varchar(100) NOT NULL,
 `friendly_url` varchar(255) NOT NULL default '',
 `popular` char(1) NOT NULL default 'n',
 `seo_description` varchar(255) NOT NULL,
 `seo_keywords` varchar(255) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `friendly_url` (`friendly_url`),
 KEY `country_id` (`country_id`),
 KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3427 ;

--
-- Dumping data for table `Location_State`
--

INSERT INTO `Location_State` (`id`, `country_id`, `name`, `abbreviation`, `friendly_url`, `popular`, `seo_description`, `seo_keywords`) VALUES
(3417, 235, 'Balochistan', 'Balochistan', 'balochistan', 'y', 'Balochistan', 'Balochistan'),
(3419, 235, 'Punjab', 'Punjab', 'punjab', 'y', 'Punjab', 'Punjab'),
(3420, 235, 'Sindh', 'Sindh', 'sindh', 'y', 'Sindh', 'Sindh'),
(3421, 235, 'Islamabad Capital Territory', 'Islamabad Capital Territory', 'islamabad-capital-territory', 'y', 'Islamabad Capital Territory', 'Islamabad Capital Territory'),
(3422, 235, 'Federally Administered Tribal Areas', 'Federally Administered Tribal Areas', 'federally-administered-tribal-areas', 'n', 'Federally Administered Tribal Areas', 'Federally Administered Tribal Areas'),
(3423, 235, 'Azad Jammu Kashmir', 'Azad Jammu Kashmir', 'azad-jammu-kashmir', 'y', 'Azad Jammu Kashmir', 'Azad Jammu Kashmir'),
(3424, 235, 'Gilgit-Baltistan', 'Gilgit-Baltistan', 'gilgit-baltistan', 'y', 'Gilgit-Baltistan', 'Gilgit-Baltistan'),
(3426, 235, 'Khyber Pakhtunkhwa', 'Khyber Pakhtunkhwa', 'khyber-pakhtunkhwa', 'n', 'Khyber Pakhtunkhwa', 'Khyber Pakhtunkhwa');