-- phpMyAdmin SQL Dump
-- version 2.9.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost:3306
-- Generation Time: May 04, 2009 at 09:42 AM
-- Server version: 5.0.33
-- PHP Version: 5.2.1
-- 
-- Database: `hamrokura`
-- 

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

-- 
-- Table structure for table `location`
-- 

CREATE TABLE `location` (
  `district_id` int(13) NOT NULL auto_increment,
  `district_name` varchar(100) collate latin1_general_ci NOT NULL,
  `country_id` int(11) NOT NULL default '1',
  PRIMARY KEY  (`district_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=84 ;

-- 
-- Dumping data for table `location`
-- 

INSERT INTO `location` VALUES (10, 'Darchula', 4);
INSERT INTO `location` VALUES (8, 'Baitadi', 4);
INSERT INTO `location` VALUES (9, 'Dadeldhura', 4);
INSERT INTO `location` VALUES (6, 'Kanchanpur', 4);
INSERT INTO `location` VALUES (11, 'Kailai', 4);
INSERT INTO `location` VALUES (12, 'Achham', 4);
INSERT INTO `location` VALUES (13, 'Doti', 4);
INSERT INTO `location` VALUES (14, 'Bajhang', 4);
INSERT INTO `location` VALUES (15, 'Bajura', 4);
INSERT INTO `location` VALUES (16, 'Bardiya', 4);
INSERT INTO `location` VALUES (17, 'Banke', 4);
INSERT INTO `location` VALUES (18, 'Dailekh', 4);
INSERT INTO `location` VALUES (19, 'Surkhet', 4);
INSERT INTO `location` VALUES (20, 'Jajarkot', 4);
INSERT INTO `location` VALUES (21, 'Kalikot', 4);
INSERT INTO `location` VALUES (22, 'Jumla', 4);
INSERT INTO `location` VALUES (23, 'Mugu', 4);
INSERT INTO `location` VALUES (24, 'Humla', 4);
INSERT INTO `location` VALUES (25, 'Dolpa', 4);
INSERT INTO `location` VALUES (26, 'Pyuthan', 4);
INSERT INTO `location` VALUES (27, 'Dang', 4);
INSERT INTO `location` VALUES (28, 'Salyan', 4);
INSERT INTO `location` VALUES (29, 'Rolpa', 4);
INSERT INTO `location` VALUES (34, 'Rukum', 4);
INSERT INTO `location` VALUES (33, 'Kapilvastu', 4);
INSERT INTO `location` VALUES (32, 'Rupandehi', 4);
INSERT INTO `location` VALUES (35, 'Nawalparasi', 4);
INSERT INTO `location` VALUES (36, 'Gulmi', 4);
INSERT INTO `location` VALUES (37, 'Palpa', 4);
INSERT INTO `location` VALUES (38, 'Arghakhanchi', 4);
INSERT INTO `location` VALUES (39, 'Parbat', 4);
INSERT INTO `location` VALUES (40, 'Baglung', 4);
INSERT INTO `location` VALUES (41, 'Myagdi', 4);
INSERT INTO `location` VALUES (42, 'Mustang', 4);
INSERT INTO `location` VALUES (43, 'Syangja', 4);
INSERT INTO `location` VALUES (44, 'Tanahu', 4);
INSERT INTO `location` VALUES (45, 'Kaski', 4);
INSERT INTO `location` VALUES (46, 'Lamjung', 4);
INSERT INTO `location` VALUES (47, 'Gorkha', 4);
INSERT INTO `location` VALUES (48, 'Manang', 4);
INSERT INTO `location` VALUES (49, 'Rautahat', 4);
INSERT INTO `location` VALUES (50, 'Bara', 4);
INSERT INTO `location` VALUES (51, 'Parsa', 4);
INSERT INTO `location` VALUES (52, 'Chitwan', 4);
INSERT INTO `location` VALUES (53, 'Makwanpur', 4);
INSERT INTO `location` VALUES (54, 'Kathmandu', 4);
INSERT INTO `location` VALUES (55, 'Bhaktapur', 4);
INSERT INTO `location` VALUES (56, 'Lalitpur', 4);
INSERT INTO `location` VALUES (57, 'Kavrepalanchok', 4);
INSERT INTO `location` VALUES (58, 'Dhading', 4);
INSERT INTO `location` VALUES (59, 'Nuwakot', 4);
INSERT INTO `location` VALUES (60, 'Sindhupalchok', 4);
INSERT INTO `location` VALUES (61, 'Rasuwa', 4);
INSERT INTO `location` VALUES (62, 'Dhanusa', 4);
INSERT INTO `location` VALUES (63, 'Sarlahi', 4);
INSERT INTO `location` VALUES (64, 'Mahottari', 4);
INSERT INTO `location` VALUES (65, 'Ramechhap', 4);
INSERT INTO `location` VALUES (66, 'Sindhuli', 4);
INSERT INTO `location` VALUES (67, 'Dolakha', 4);
INSERT INTO `location` VALUES (68, 'Siraha', 4);
INSERT INTO `location` VALUES (69, 'Saptari', 4);
INSERT INTO `location` VALUES (70, 'Okhaldhunga', 4);
INSERT INTO `location` VALUES (71, 'Khotang', 4);
INSERT INTO `location` VALUES (72, 'Udayapur', 4);
INSERT INTO `location` VALUES (73, 'Solukhumbu', 4);
INSERT INTO `location` VALUES (74, 'Sunsari', 4);
INSERT INTO `location` VALUES (75, 'Morang', 4);
INSERT INTO `location` VALUES (76, 'Dhankuta', 4);
INSERT INTO `location` VALUES (77, 'Terhathum', 4);
INSERT INTO `location` VALUES (78, 'Bhojpur', 4);
INSERT INTO `location` VALUES (79, 'Sankhuwasabha', 4);
INSERT INTO `location` VALUES (80, 'Jhapa', 4);
INSERT INTO `location` VALUES (81, 'Ilam', 4);
INSERT INTO `location` VALUES (82, 'Panchthar', 4);
INSERT INTO `location` VALUES (83, 'Taplejung', 4);