0

i tried reverse engineering option in Mysql workbend 5.1,

1stly i imprted DB's script and then created it, Its done :)
but when i try to create ERD via Reverse Engineering option , then it doesn't show relations ships btw tbl, it only brings table to front ! why ?
even it is working in php app,

-- MySQL dump 10.13  Distrib 5.5.9, for Win32 (x86)
--
-- Host: localhost    Database: safeer
-- ------------------------------------------------------
-- Server version   5.5.15

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `safeer`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `safeer` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `safeer`;

--
-- Table structure for table `hr_admin`
--

DROP TABLE IF EXISTS `hr_admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_admin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_user` varchar(255) NOT NULL,
  `admin_pwd` varchar(255) NOT NULL,
  `admin_email` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `google_code` text NOT NULL,
  `career_email` varchar(255) NOT NULL,
  `invester` varchar(225) NOT NULL,
  `contact_us` varchar(225) NOT NULL,
  `default_commission` int(11) NOT NULL,
  PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_admin`
--

LOCK TABLES `hr_admin` WRITE;
/*!40000 ALTER TABLE `hr_admin` DISABLE KEYS */;
INSERT INTO `hr_admin` VALUES (1,'admin','admin','ishpgroup@gmail.com','Admin','ishpgroup@gmail.com','<iframe width=\"350\" height=\"160\" frameborder=\"0\" scrolling=\"no\" marginheight=\"0\" marginwidth=\"0\" src=\"http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=8+Jalan+Permas+10,+Taman+Permas+Jaya,+Masai,+Johor,+Malaysia&aq=&sll=37.0625,-95.677068&sspn=37.325633,56.513672&ie=UTF8&split=0&hq=&hnear=8+Jalan+Permas+10,+Taman+Permas+Jaya,+81750+Masai,+Johor,+Malaysia&t=m&z=14&ll=1.495521,103.815371&output=embed\"></iframe>','directory@directory.com','online@online.coma','ishpgroup@gmail.com',11);
/*!40000 ALTER TABLE `hr_admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_ads`
--

DROP TABLE IF EXISTS `hr_ads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_ads` (
  `adsid` int(255) NOT NULL AUTO_INCREMENT,
  `fid` int(255) NOT NULL,
  `title` varchar(30) NOT NULL,
  `images` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `postion` int(11) NOT NULL COMMENT 'bottom=0,right=1',
  `status` int(30) NOT NULL DEFAULT '1' COMMENT 'block=0,unblock=1',
  `expiry` int(255) NOT NULL,
  PRIMARY KEY (`adsid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_ads`
--

LOCK TABLES `hr_ads` WRITE;
/*!40000 ALTER TABLE `hr_ads` DISABLE KEYS */;
INSERT INTO `hr_ads` VALUES (1,-1,'bar','','http://50.63.83.247/wasee',0,1,1362822139),(3,-1,'fancy room','','http://50.63.83.247/waseem/booking/hotel.php?p_id=15',1,1,1362985641),(4,-1,'Lighthouse','','http://50.63.83.247/waseem/booking/hotel.php?p_id=15',0,1,1363057986),(5,-1,'Desert','1360638870Desert.jpg','',1,1,1363058070);
/*!40000 ALTER TABLE `hr_ads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_attribute`
--

DROP TABLE IF EXISTS `hr_attribute`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_attribute` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `attribute_name` varchar(100) NOT NULL,
  `type` int(10) NOT NULL COMMENT '0=>click / 1=>checkbox',
  `attributetype` int(11) NOT NULL COMMENT '0 for hotal 1 for room',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_attribute`
--

LOCK TABLES `hr_attribute` WRITE;
/*!40000 ALTER TABLE `hr_attribute` DISABLE KEYS */;
INSERT INTO `hr_attribute` VALUES (44,'Facilities',2,0),(45,'Activities',2,0),(41,'floor type',3,1),(46,'Services',2,0),(47,'Internet',2,0),(48,'Parking',4,0),(57,'Accepted credit cards',2,0),(50,'Check in',0,0),(51,'Check out',0,0),(52,'Pets',4,0);
/*!40000 ALTER TABLE `hr_attribute` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_attributes_option`
--

DROP TABLE IF EXISTS `hr_attributes_option`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_attributes_option` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `optionid` int(20) NOT NULL COMMENT '456456456',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=143 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_attributes_option`
--

LOCK TABLES `hr_attributes_option` WRITE;
/*!40000 ALTER TABLE `hr_attributes_option` DISABLE KEYS */;
INSERT INTO `hr_attributes_option` VALUES (45,'testing123',30),(46,'123',33),(47,'123123',33),(48,'test1',33),(49,'test2',33),(50,'test3',33),(51,'test4',33),(52,'123',33),(53,'212',33),(54,'1212',33),(55,'1212',33),(56,'121212',33),(57,'121212',33),(58,'121212',33),(59,'121212',33),(72,'Single room',39),(62,'pindi',34),(63,'Yes',35),(64,'No',35),(65,'Yes',37),(73,'Double room',39),(67,'1',38),(68,'123',38),(70,'No',37),(74,'Twin room',39),(75,'Family room',39),(76,'Deluxe room',39),(77,'Lough view suite',39),(78,'01',41),(79,'10',41),(80,'Restaurant',44),(81,'Bar',44),(82,' 24-Hour Front Des',44),(83,'Newspapers',44),(84,'Terrace',44),(85,'Non-smoking',44),(86,'Facilities for Disabled Guests',44),(87,'Elevator',44),(88,'Safe',44),(89,'Soundproof Rooms',44),(90,'Designer Hotel',44),(91,'Baggage Storage',44),(92,'Air Conditioning',44),(93,'Air Conditioning',44),(94,'Restaurant With Dining Menu',44),(95,'Sun Deck',44),(96,'Tennis Court',45),(97,' Fitness Center',45),(98,'Golf Course',45),(99,'Skiing',45),(100,'Spa',45),(101,'Massage',45),(102,'Ski School',45),(103,'Outdoor Pool',45),(104,'Outdoor Swimming Pool (All Year)',45),(105,'Room Service',46),(106,'Meeting/Banquet Facilities',46),(107,' Airport Shuttle',46),(108,'Business Center',46),(109,'Babysitting/Child Services',46),(110,'Laundry',46),(111,'Dry Cleaning',46),(112,'Hair/Beauty Salon',46),(113,'VIP Room Facilities',46),(114,'Breakfast in the Room',46),(115,'Ironing Service',46),(140,'Euro/Mastercard',57),(117,'Shoeshine',46),(118,'Car Rental',46),(119,'Tour Desk',46),(120,'Fax/Photocopying',46),(121,'Ticket Service',46),(122,'On-Site ATM Machine',46),(139,'American Express',57),(124,'Shuttle Service (Surcharge)',46),(125,'Ski Equipment Rental on site',46),(126,'Ski Passes Available',46),(127,'Ski-to-Door Access',46),(128,'Free! Wi-Fi is available in all areas and is free of charge',47),(129,' Wi-Fi is available in all areas and is free of charge',47),(130,'Wi-Fi is not available',47),(131,'Free private parking is possible on site',48),(132,'not available',48),(133,'Pets are allowed',52),(134,'Pets are not allowed',52),(135,'Yes',53),(136,'No',53),(137,'Yes',54),(138,'No',54),(141,'Diners Club',57),(142,'The hotel reserves the right to pre-authorize credit cards prior to arrival',57);
/*!40000 ALTER TABLE `hr_attributes_option` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_booking`
--

DROP TABLE IF EXISTS `hr_booking`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_booking` (
  `booking_id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(50) NOT NULL,
  `customer_id` int(50) NOT NULL,
  `owner_id` int(50) NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `fname` varchar(50) NOT NULL,
  `lname` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `contactno` varchar(50) NOT NULL,
  `city` varchar(50) NOT NULL,
  `state` varchar(50) NOT NULL,
  `zip_code` varchar(50) NOT NULL,
  `country` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `price` bigint(20) NOT NULL,
  `currency` varchar(50) NOT NULL,
  `order_status` tinyint(1) NOT NULL,
  `approve_status` int(1) NOT NULL COMMENT '0 for Default, 1 Approve, 2 Disapprove',
  `owner_paid` tinyint(1) NOT NULL,
  `admin_profit` bigint(20) NOT NULL,
  PRIMARY KEY (`booking_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_booking`
--

LOCK TABLES `hr_booking` WRITE;
/*!40000 ALTER TABLE `hr_booking` DISABLE KEYS */;
INSERT INTO `hr_booking` VALUES (1,1,0,-1,'2013-02-18','2013-02-24','Asad','Khan','umairafridi62@gmail.com','12345678','Rawp','Punjab','46000','PAKISTAN','test',120,'USD',1,1,0,0),(2,3,0,20,'2013-02-13','2013-02-15','safeer','shah','safeer_shah143@yahoo.com','03005656561','kohat','kpk','26000','PAKISTAN','',150,'USD',0,1,0,0),(3,3,0,20,'2013-02-12','2013-02-14','','','','','','','','','',150,'GBP',0,1,0,0),(4,3,0,20,'2013-02-20','2013-02-28','rehmat','','','','','','','PAKISTAN','',322,'USD',0,2,0,0),(5,3,0,20,'2013-02-13','2013-02-22','rehmat','','rehmat.32@gmail.com','','','','','','',397,'USD',0,1,0,0),(6,3,0,20,'2013-02-12','2013-02-13','safeer','shah','safeershah143@gmail.com','03005656143','kohat','','','PAKISTAN','',75,'USD',0,1,0,0);
/*!40000 ALTER TABLE `hr_booking` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_calender`
--

DROP TABLE IF EXISTS `hr_calender`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_calender` (
  `calenderid` int(255) NOT NULL AUTO_INCREMENT,
  `id` int(255) NOT NULL COMMENT 'property id',
  `title` varchar(50) NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `minimumstay` varchar(255) NOT NULL,
  `status` int(255) NOT NULL COMMENT '0=available,1=notavailable',
  `pernight` bigint(20) NOT NULL,
  `perweek` bigint(20) NOT NULL,
  `pertwoweek` bigint(20) NOT NULL,
  `perfourweek` bigint(20) NOT NULL,
  PRIMARY KEY (`calenderid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_calender`
--

LOCK TABLES `hr_calender` WRITE;
/*!40000 ALTER TABLE `hr_calender` DISABLE KEYS */;
INSERT INTO `hr_calender` VALUES (2,1,'','2013-02-09','2013-02-12','',1,20,50,100,250),(3,1,'','2013-02-01','2013-02-08','',0,20,50,100,250),(5,1,'','2013-02-13','2013-02-14','',1,20,50,100,250),(7,2,'default rates','2013-02-13','2013-02-28','50',0,150,200,350,500),(8,4,'1st floor room no','2013-02-01','2013-02-28','10',0,50,100,250,500),(9,1,'Special Feb','2013-02-01','2013-02-28','1 Night',0,20,60,120,250),(10,1,'','2013-02-18','2013-02-24','',1,20,50,100,250),(11,1,'','2013-02-15','2013-02-17','',0,20,50,100,250),(12,1,'','2013-02-25','2013-02-28','',0,20,50,100,250),(13,3,'24-hour room service Service bar Digital Safe Cabl','2013-02-11','2013-03-02','2',0,75,247,420,600);
/*!40000 ALTER TABLE `hr_calender` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_contactemail`
--

DROP TABLE IF EXISTS `hr_contactemail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_contactemail` (
  `contactemail_id` int(11) NOT NULL AUTO_INCREMENT,
  `email_subject` varchar(255) DEFAULT NULL,
  `email_text` text,
  `category` int(255) NOT NULL,
  PRIMARY KEY (`contactemail_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_contactemail`
--

LOCK TABLES `hr_contactemail` WRITE;
/*!40000 ALTER TABLE `hr_contactemail` DISABLE KEYS */;
INSERT INTO `hr_contactemail` VALUES (1,'Auto Reply','<p><strong>Dear Customer</strong>,</p>\r\n<p><font color=\"#009900\">This is to acknowledge that your feedback has been received. Your complaint or query shall be addressed by our concerned department.Thank you for writing to us and we look forward to serving you better</font>.</p>\r\n<p><font color=\"#888888\"><br />\r\nSUR Team</font></p>',1);
/*!40000 ALTER TABLE `hr_contactemail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_country`
--

DROP TABLE IF EXISTS `hr_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_country` (
  `country_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `code2` char(2) DEFAULT NULL,
  `code3` char(3) DEFAULT NULL,
  `codeint` varchar(4) DEFAULT NULL,
  PRIMARY KEY (`country_id`)
) ENGINE=MyISAM AUTO_INCREMENT=239 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_country`
--

LOCK TABLES `hr_country` WRITE;
/*!40000 ALTER TABLE `hr_country` DISABLE KEYS */;
INSERT INTO `hr_country` VALUES (1,'AFGHANISTAN','AF','AFG','4'),(2,'ALBANIA','AL','ALB','8'),(3,'ALGERIA','DZ','DZA','12'),(4,'AMERICAN SAMOA','AS','ASM','16'),(5,'ANDORRA','AD','AND','20'),(6,'ANGOLA','AO','AGO','24'),(7,'ANGUILLA','AI','AIA','660'),(8,'ANTIGUA AND BARBUDA','AG','ATG','28'),(9,'ARGENTINA','AR','ARG','32'),(10,'ARMENIA','AM','ARM','51'),(11,'ARUBA','AW','ABW','533'),(12,'AUSTRALIA','AU','AUS','36'),(13,'AUSTRIA','AT','AUT','40'),(14,'AZERBAIJAN','AZ','AZE','31'),(15,'BAHAMAS','BS','BHS','44'),(16,'BAHRAIN','BH','BHR','48'),(17,'BANGLADESH','BD','BGD','50'),(18,'BARBADOS','BB','BRB','52'),(19,'BELARUS','BY','BLR','112'),(20,'BELGIUM','BE','BEL','56'),(21,'BELIZE','BZ','BLZ','84'),(22,'BENIN','BJ','BEN','204'),(23,'BERMUDA','BM','BMU','60'),(24,'BHUTAN','BT','BTN','64'),(25,'BOLIVIA','BO','BOL','68'),(26,'BOSNIA AND HERZEGOWINA','BA','BIH','70'),(27,'BOTSWANA','BW','BWA','72'),(28,'BOUVET ISLAND','BV','BVT','74'),(29,'BRAZIL','BR','BRA','76'),(30,'BRITISH INDIAN OCEAN TERRITORY','IO','IOT','86'),(31,'BRUNEI DARUSSALAM','BN','BRN','96'),(32,'BULGARIA','BG','BGR','100'),(33,'BURKINA FASO','BF','BFA','854'),(34,'BURUNDI','BI','BDI','108'),(35,'CAMBODIA','KH','KHM','116'),(36,'CAMEROON','CM','CMR','120'),(37,'CANADA','CA','CAN','124'),(38,'CAPE VERDE','CV','CPV','132'),(39,'CAYMAN ISLANDS','KY','CYM','136'),(40,'CENTRAL AFRICAN REPUBLIC','CF','CAF','140'),(41,'CHAD','TD','TCD','148'),(42,'CHILE','CL','CHL','152'),(43,'CHINA','CN','CHN','156'),(44,'CHRISTMAS ISLAND','CX','CXR','162'),(45,'COCOS (KEELING) ISLANDS','CC','CCK','166'),(46,'COLOMBIA','CO','COL','170'),(47,'COMOROS','KM','COM','174'),(48,'CONGO','CG','COG','178'),(49,'COOK ISLANDS','CK','COK','184'),(50,'COSTA RICA','CR','CRI','188'),(51,'COTE DIVOIRE','CI','CIV','384'),(52,'CROATIA (local name: Hrvatska)','HR','HRV','191'),(53,'CUBA','CU','CUB','192'),(54,'CYPRUS','CY','CYP','196'),(55,'CZECH REPUBLIC','CZ','CZE','203'),(56,'DENMARK','DK','DNK','208'),(57,'DJIBOUTI','DJ','DJI','262'),(58,'DOMINICA','DM','DMA','212'),(59,'DOMINICAN REPUBLIC','DO','DOM','214'),(60,'EAST TIMOR','TP','TMP','626'),(61,'ECUADOR','EC','ECU','218'),(62,'EGYPT','EG','EGY','818'),(63,'EL SALVADOR','SV','SLV','222'),(64,'EQUATORIAL GUINEA','GQ','GNQ','226'),(65,'ERITREA','ER','ERI','232'),(66,'ESTONIA','EE','EST','233'),(67,'ETHIOPIA','ET','ETH','231'),(68,'FALKLAND ISLANDS (MALVINAS)','FK','FLK','238'),(69,'FAROE ISLANDS','FO','FRO','234'),(70,'FIJI','FJ','FJI','242'),(71,'FINLAND','FI','FIN','246'),(72,'FRANCE','FR','FRA','250'),(73,'FRANCE, METROPOLITAN','FX','FXX','249'),(74,'FRENCH GUIANA','GF','GUF','254'),(75,'FRENCH POLYNESIA','PF','PYF','258'),(76,'FRENCH SOUTHERN TERRITORIES','TF','ATF','260'),(77,'GABON','GA','GAB','266'),(78,'GAMBIA','GM','GMB','270'),(79,'GEORGIA','GE','GEO','268'),(80,'GERMANY','DE','DEU','276'),(81,'GHANA','GH','GHA','288'),(82,'GIBRALTAR','GI','GIB','292'),(83,'GREECE','GR','GRC','300'),(84,'GREENLAND','GL','GRL','304'),(85,'GRENADA','GD','GRD','308'),(86,'GUADELOUPE','GP','GLP','312'),(87,'GUAM','GU','GUM','316'),(88,'GUATEMALA','GT','GTM','320'),(89,'GUINEA','GN','GIN','324'),(90,'GUINEA-BISSAU','GW','GNB','624'),(91,'GUYANA','GY','GUY','328'),(92,'HAITI','HT','HTI','332'),(93,'HEARD AND MC DONALD ISLANDS','HM','HMD','334'),(94,'HONDURAS','HN','HND','340'),(95,'HONG KONG','HK','HKG','344'),(96,'HUNGARY','HU','HUN','348'),(97,'ICELAND','IS','ISL','352'),(98,'INDIA','IN','IND','356'),(99,'INDONESIA','ID','IDN','360'),(100,'IRAN (ISLAMIC REPUBLIC OF)','IR','IRN','364'),(101,'IRAQ','IQ','IRQ','368'),(102,'IRELAND','IE','IRL','372'),(103,'ISRAEL','IL','ISR','376'),(104,'ITALY','IT','ITA','380'),(105,'JAMAICA','JM','JAM','388'),(106,'JAPAN','JP','JPN','392'),(107,'JORDAN','JO','JOR','400'),(108,'KAZAKHSTAN','KZ','KAZ','398'),(109,'KENYA','KE','KEN','404'),(110,'KIRIBATI','KI','KIR','296'),(111,'KOREA, DEMOCRATIC PEOPLES REPUBLIC OF','KP','PRK','408'),(112,'KOREA, REPUBLIC OF','KR','KOR','410'),(113,'KUWAIT','KW','KWT','414'),(114,'KYRGYZSTAN','KG','KGZ','417'),(115,'LAO PEOPLES DEMOCRATIC REPUBLIC','LA','LAO','418'),(116,'LATVIA','LV','LVA','428'),(117,'LEBANON','LB','LBN','422'),(118,'LESOTHO','LS','LSO','426'),(119,'LIBERIA','LR','LBR','430'),(120,'LIBYAN ARAB JAMAHIRIYA','LY','LBY','434'),(121,'LIECHTENSTEIN','LI','LIE','438'),(122,'LITHUANIA','LT','LTU','440'),(123,'LUXEMBOURG','LU','LUX','442'),(124,'MACAU','MO','MAC','446'),(125,'MACEDONIA','MK','MKD','807'),(126,'MADAGASCAR','MG','MDG','450'),(127,'MALAWI','MW','MWI','454'),(128,'MALAYSIA','MY','MYS','458'),(129,'MALDIVES','MV','MDV','462'),(130,'MALI','ML','MLI','466'),(131,'MALTA','MT','MLT','470'),(132,'MARSHALL ISLANDS','MH','MHL','584'),(133,'MARTINIQUE','MQ','MTQ','474'),(134,'MAURITANIA','MR','MRT','478'),(135,'MAURITIUS','MU','MUS','480'),(136,'MAYOTTE','YT','MYT','175'),(137,'MEXICO','MX','MEX','484'),(138,'MICRONESIA, FEDERATED STATES OF','FM','FSM','583'),(139,'MOLDOVA, REPUBLIC OF','MD','MDA','498'),(140,'MONACO','MC','MCO','492'),(141,'MONGOLIA','MN','MNG','496'),(142,'MONTSERRAT','MS','MSR','500'),(143,'MOROCCO','MA','MAR','504'),(144,'MOZAMBIQUE','MZ','MOZ','508'),(145,'MYANMAR','MM','MMR','104'),(146,'NAMIBIA','NA','NAM','516'),(147,'NAURU','NR','NRU','520'),(148,'NEPAL','NP','NPL','524'),(149,'NETHERLANDS','NL','NLD','528'),(150,'NETHERLANDS ANTILLES','AN','ANT','530'),(151,'NEW CALEDONIA','NC','NCL','540'),(152,'NEW ZEALAND','NZ','NZL','554'),(153,'NICARAGUA','NI','NIC','558'),(154,'NIGER','NE','NER','562'),(155,'NIGERIA','NG','NGA','566'),(156,'NIUE','NU','NIU','570'),(157,'NORFOLK ISLAND','NF','NFK','574'),(158,'NORTHERN MARIANA ISLANDS','MP','MNP','580'),(159,'NORWAY','NO','NOR','578'),(160,'OMAN','OM','OMN','512'),(161,'PAKISTAN','PK','PAK','586'),(162,'PALAU','PW','PLW','585'),(163,'PANAMA','PA','PAN','591'),(164,'PAPUA NEW GUINEA','PG','PNG','598'),(165,'PARAGUAY','PY','PRY','600'),(166,'PERU','PE','PER','604'),(167,'PHILIPPINES','PH','PHL','608'),(168,'PITCAIRN','PN','PCN','612'),(169,'POLAND','PL','POL','616'),(170,'PORTUGAL','PT','PRT','620'),(171,'PUERTO RICO','PR','PRI','630'),(172,'QATAR','QA','QAT','634'),(173,'REUNION','RE','REU','638'),(174,'ROMANIA','RO','ROM','642'),(175,'RUSSIAN FEDERATION','RU','RUS','643'),(176,'RWANDA','RW','RWA','646'),(177,'SAINT KITTS AND NEVIS','KN','KNA','659'),(178,'SAINT LUCIA','LC','LCA','662'),(179,'SAINT VINCENT AND THE GRENADINES','VC','VCT','670'),(180,'SAMOA','WS','WSM','882'),(181,'SAN MARINO','SM','SMR','674'),(182,'SAO TOME AND PRINCIPE','ST','STP','678'),(183,'SAUDI ARABIA','SA','SAU','682'),(184,'SENEGAL','SN','SEN','686'),(185,'SEYCHELLES','SC','SYC','690'),(186,'SIERRA LEONE','SL','SLE','694'),(187,'SINGAPORE','SG','SGP','702'),(188,'SLOVAKIA (Slovak Republic)','SK','SVK','703'),(189,'SLOVENIA','SI','SVN','705'),(190,'SOLOMON ISLANDS','SB','SLB','90'),(191,'SOMALIA','SO','SOM','706'),(192,'SOUTH AFRICA','ZA','ZAF','710'),(193,'SOUTH GEORGIA','GS','SGS','239'),(194,'SPAIN','ES','ESP','724'),(195,'SRI LANKA','LK','LKA','144'),(196,'ST. HELENA','SH','SHN','654'),(197,'ST. PIERRE AND MIQUELON','PM','SPM','666'),(198,'SUDAN','SD','SDN','736'),(199,'SURINAME','SR','SUR','740'),(200,'SVALBARD AND JAN MAYEN ISLANDS','SJ','SJM','744'),(201,'SWAZILAND','SZ','SWZ','748'),(202,'SWEDEN','SE','SWE','752'),(203,'SWITZERLAND','CH','CHE','756'),(204,'SYRIAN ARAB REPUBLIC','SY','SYR','760'),(205,'TAIWAN, PROVINCE OF CHINA','TW','TWN','158'),(206,'TAJIKISTAN','TJ','TJK','762'),(207,'TANZANIA, UNITED REPUBLIC OF','TZ','TZA','834'),(208,'THAILAND','TH','THA','764'),(209,'TOGO','TG','TGO','768'),(210,'TOKELAU','TK','TKL','772'),(211,'TONGA','TO','TON','776'),(212,'TRINIDAD AND TOBAGO','TT','TTO','780'),(213,'TUNISIA','TN','TUN','788'),(214,'TURKEY','TR','TUR','792'),(215,'TURKMENISTAN','TM','TKM','795'),(216,'TURKS AND CAICOS ISLANDS','TC','TCA','796'),(217,'TUVALU','TV','TUV','798'),(218,'UGANDA','UG','UGA','800'),(219,'UKRAINE','UA','UKR','804'),(220,'UNITED ARAB EMIRATES','AE','ARE','784'),(221,'UNITED KINGDOM','GB','GBR','826'),(222,'UNITED STATES','US','USA','840'),(223,'UNITED STATES MINOR OUTLYING ISLANDS','UM','UMI','581'),(224,'URUGUAY','UY','URY','858'),(225,'UZBEKISTAN','UZ','UZB','860'),(226,'VANUATU','VU','VUT','548'),(227,'VATICAN CITY STATE (HOLY SEE)','VA','VAT','336'),(228,'VENEZUELA','VE','VEN','862'),(229,'VIET NAM','VN','VNM','704'),(230,'VIRGIN ISLANDS (BRITISH)','VG','VGB','92'),(231,'VIRGIN ISLANDS (U.S.)','VI','VIR','850'),(232,'WALLIS AND FUTUNA ISLANDS','WF','WLF','876'),(233,'WESTERN SAHARA','EH','ESH','732'),(234,'YEMEN','YE','YEM','887'),(235,'YUGOSLAVIA','YU','YUG','891'),(236,'ZAIRE','ZR','ZAR','180'),(237,'ZAMBIA','ZM','ZMB','894'),(238,'ANTARCTICA','AQ','ATA','10');
/*!40000 ALTER TABLE `hr_country` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_faq`
--

DROP TABLE IF EXISTS `hr_faq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_faq` (
  `pkfaqid` int(255) NOT NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  `answer` text NOT NULL,
  `questionita` text NOT NULL,
  `questionspa` text NOT NULL,
  `answerita` text NOT NULL,
  `answerspa` text NOT NULL,
  PRIMARY KEY (`pkfaqid`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_faq`
--

LOCK TABLES `hr_faq` WRITE;
/*!40000 ALTER TABLE `hr_faq` DISABLE KEYS */;
INSERT INTO `hr_faq` VALUES (2,'Are any of the main sections of the site changing?','There have been small changes to the names - for example, the Education section was renamed \"Education & Family\" earlier this year, and with the redesign we will re-label the Entertainment section \"Entertainment & Arts\" to fully reflect the content of the section which has always included the arts. Among the international regional indexes, the Americas index is being split into a \"US & Canada\" index and a \"Latin America\" index.','Are any of the main sections of the site changing?','Are any of the main sections of the site changing?','There have been small changes to the names - for example, the Education section was renamed \"Education & Family\" earlier this year, and with the redesign we will re-label the Entertainment section \"Entertainment & Arts\" to fully reflect the content of the section which has always included the arts. Among the international regional indexes, the Americas index is being split into a \"US & Canada\" index and a \"Latin America\" index.','There have been small changes to the names - for example, the Education section was renamed \"Education & Family\" earlier this year, and with the redesign we will re-label the Entertainment section \"Entertainment & Arts\" to fully reflect the content of the section which has always included the arts. Among the international regional indexes, the Americas index is being split into a \"US & Canada\" index and a \"Latin America\" index.'),(3,'Why have you stopped providing a low-graphics version of the site?','The low-graphics version was switched off in April when the News website story HTML was upgraded. This is the system that is used to create the page layouts of the site and the new system did not support the old low-graphics version.','Why have you stopped providing a low-graphics version of the site?','Why have you stopped providing a low-graphics version of the site?','The low-graphics version was switched off in April when the News website story HTML was upgraded. This is the system that is used to create the page layouts of the site and the new system did not support the old low-graphics version.','The low-graphics version was switched off in April when the News website story HTML was upgraded. This is the system that is used to create the page layouts of the site and the new system did not support the old low-graphics version.'),(4,'How will you ensure the site is still user-friendly for those with disabilities?','We know that people used the low-graphics version because it was simpler to read and we now offer the mobile version of the site online which provides a similarly simplified presentation.','How will you ensure the site is still user-friendly for those with disabilities?','How will you ensure the site is still user-friendly for those with disabilities?','We know that people used the low-graphics version because it was simpler to read and we now offer the mobile version of the site online which provides a similarly simplified presentation.','We know that people used the low-graphics version because it was simpler to read and we now offer the mobile version of the site online which provides a similarly simplified presentation.'),(5,'Why have you chosen to include more video?','The BBC is a broadcaster and one of the largest producers of video news in the world with correspondents filing video from all over the world every day. With our audience increasingly looking to consume video news at a time that suits them, we hope the improvements will make it easier to find video news of interest.','Why have you chosen to include more video?','Why have you chosen to include more video?','The BBC is a broadcaster and one of the largest producers of video news in the world with correspondents filing video from all over the world every day. With our audience increasingly looking to consume video news at a time that suits them, we hope the improvements will make it easier to find video news of interest.','The BBC is a broadcaster and one of the largest producers of video news in the world with correspondents filing video from all over the world every day. With our audience increasingly looking to consume video news at a time that suits them, we hope the improvements will make it easier to find video news of interest.'),(6,'Will bigger pictures and more video change the loading time of pages?','No. We have improved the way our site is served, so that the pages are lighter, and we make better use of caching and compression. This counterbalances any effect of larger images and more video. We monitor the response time of our site regularly from several locations around the world.','Will bigger pictures and more video change the loading time of pages?','Will bigger pictures and more video change the loading time of pages?','No. We have improved the way our site is served, so that the pages are lighter, and we make better use of caching and compression. This counterbalances any effect of larger images and more video. We monitor the response time of our site regularly from several locations around the world.','No. We have improved the way our site is served, so that the pages are lighter, and we make better use of caching and compression. This counterbalances any effect of larger images and more video. We monitor the response time of our site regularly from several locations around the world.'),(7,'Will video play on iPhones and other devices that don\'t support Flash?','We are working to ensure our video will work on devices which do not support the Flash software, but which do support other video standards. Although this functionality will not be available immediately on the redesigned site, we hope to be able to roll it out later in the year.','Will video play on iPhones and other devices that don\'t support Flash?','Will video play on iPhones and other devices that don\'t support Flash?','We are working to ensure our video will work on devices which do not support the Flash software, but which do support other video standards. Although this functionality will not be available immediately on the redesigned site, we hope to be able to roll it out later in the year.','We are working to ensure our video will work on devices which do not support the Flash software, but which do support other video standards. Although this functionality will not be available immediately on the redesigned site, we hope to be able to roll it out later in the year.'),(8,'How do I use the UK local news and weather box on the front page?','This feature allows UK users to personalise the BBC News front page so that they can see the top stories from a given area in addition to the headlines from around the UK. If you wish to use this function, all you need to do is insert your postcode in the box marked \"Add your local news and weather\" and your local headlines will appear there as well. All the local content will also be available on your BBC Local page as before - we\'re only making it easier for you to access it. You can also click on the \"World News\" tab if you wish to see a snapshot of the main headlines of the day from around the world.','How do I use the UK local news and weather box on the front page?','How do I use the UK local news and weather box on the front page?','This feature allows UK users to personalise the BBC News front page so that they can see the top stories from a given area in addition to the headlines from around the UK. If you wish to use this function, all you need to do is insert your postcode in the box marked \"Add your local news and weather\" and your local headlines will appear there as well. All the local content will also be available on your BBC Local page as before - we\'re only making it easier for you to access it. You can also click on the \"World News\" tab if you wish to see a snapshot of the main headlines of the day from around the world.','This feature allows UK users to personalise the BBC News front page so that they can see the top stories from a given area in addition to the headlines from around the UK. If you wish to use this function, all you need to do is insert your postcode in the box marked \"Add your local news and weather\" and your local headlines will appear there as well. All the local content will also be available on your BBC Local page as before - we\'re only making it easier for you to access it. You can also click on the \"World News\" tab if you wish to see a snapshot of the main headlines of the day from around the world.'),(11,'question1','answer1','question1','question1','answer1','answer1'),(12,'Question-1','This is the answer of question','Question-1','Question-1','This is the answer of question','This is the answer of question');
/*!40000 ALTER TABLE `hr_faq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_gallery`
--

DROP TABLE IF EXISTS `hr_gallery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_gallery` (
  `img_id` int(11) NOT NULL AUTO_INCREMENT,
  `img_caption` varchar(1024) NOT NULL,
  `img_src` varchar(1024) NOT NULL,
  `img_order` int(11) NOT NULL,
  `property_id` int(11) NOT NULL,
  `links` varchar(255) NOT NULL,
  PRIMARY KEY (`img_id`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_gallery`
--

LOCK TABLES `hr_gallery` WRITE;
/*!40000 ALTER TABLE `hr_gallery` DISABLE KEYS */;
INSERT INTO `hr_gallery` VALUES (40,'The Booking: a heavenly place </br> Pure enjoyment in a warm city called Dublin...','1356425143slide-1.jpg',2,0,'#'),(42,'Palms in front of your room.</br>That so cool!','1356425291slide-3.jpg',0,0,'http://www.google.com'),(41,'Sea, surf, and sun...</br> The sun, the zenith, these litle blue birds we call tits...','1356425231slide-2.jpg',1,0,'#');
/*!40000 ALTER TABLE `hr_gallery` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_googlemap`
--

DROP TABLE IF EXISTS `hr_googlemap`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_googlemap` (
  `pkgmid` int(255) NOT NULL AUTO_INCREMENT,
  `googlecode` varchar(255) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`pkgmid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_googlemap`
--

LOCK TABLES `hr_googlemap` WRITE;
/*!40000 ALTER TABLE `hr_googlemap` DISABLE KEYS */;
INSERT INTO `hr_googlemap` VALUES (1,'google code \r\ndssfsdaf',0);
/*!40000 ALTER TABLE `hr_googlemap` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_hotel_gallery`
--

DROP TABLE IF EXISTS `hr_hotel_gallery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_hotel_gallery` (
  `img_id` int(11) NOT NULL AUTO_INCREMENT,
  `img_caption` varchar(1024) NOT NULL,
  `img_src` varchar(1024) NOT NULL,
  `img_order` int(11) NOT NULL,
  `property_id` int(11) NOT NULL,
  PRIMARY KEY (`img_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_hotel_gallery`
--

LOCK TABLES `hr_hotel_gallery` WRITE;
/*!40000 ALTER TABLE `hr_hotel_gallery` DISABLE KEYS */;
INSERT INTO `hr_hotel_gallery` VALUES (1,'front view','1360139532pakistan_the_beautif.jpg',1,4),(2,'near road','13601396251_(33).jpg',2,4),(3,'Caption-1','1360357798Chrysanthemum.jpg',3,11),(5,'testing','1360598586069622a_hb_w_005.jpg',4,20),(6,'testing','1360640141069622a_hb_w_001.jpg',5,20),(7,'testing 2','1360640158069622a_hb_w_005.jpg',6,20),(8,'testing 3','1360640176marriott-islamabad.jpg',7,20),(9,'Sheraton','1360745098she.jpg',8,25),(10,'test','136074519913544534.jpg',9,25),(11,'test2','136074521513544535.jpg',10,25),(12,'test3','136074523013544536.jpg',11,25),(13,'test4','136074524813544538.jpg',12,25);
/*!40000 ALTER TABLE `hr_hotel_gallery` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_hotel_option`
--

DROP TABLE IF EXISTS `hr_hotel_option`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_hotel_option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(11) NOT NULL,
  `attribute_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=734 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_hotel_option`
--

LOCK TABLES `hr_hotel_option` WRITE;
/*!40000 ALTER TABLE `hr_hotel_option` DISABLE KEYS */;
INSERT INTO `hr_hotel_option` VALUES (46,83,30,'testing123'),(47,83,31,'waseem textarea'),(48,83,32,'asas text fiels'),(49,83,33,'123'),(50,83,33,'123123'),(51,83,33,'test1'),(52,83,33,'test2'),(53,83,33,'test3'),(54,83,33,'test4'),(55,83,33,'123'),(56,83,33,'212'),(57,83,33,'1212'),(58,83,33,'1212'),(59,83,33,'121212'),(60,83,33,'121212'),(61,83,33,'121212'),(62,83,33,'121212'),(63,83,34,'kohat'),(64,83,35,'Yes'),(68,84,30,'testing123'),(69,84,33,'123'),(70,84,33,'123'),(71,84,33,'121212'),(72,84,34,'pindi'),(73,85,30,'testing123'),(111,46,30,'testing123'),(112,46,33,'123'),(113,46,33,'123'),(114,46,33,'121212'),(115,46,33,'121212'),(116,46,33,'121212'),(117,46,33,'121212'),(118,46,34,'pindi'),(120,95,39,'Double room'),(121,94,39,'Single room'),(122,39,39,'Single room'),(123,40,39,'Single room'),(124,41,39,'Single room'),(158,4,30,'testing123'),(159,4,33,'123'),(160,4,33,'test1'),(161,4,33,'test3'),(162,4,33,'123'),(163,4,33,'212'),(164,4,33,'1212'),(165,4,33,'1212'),(166,4,33,'121212'),(167,4,33,'121212'),(168,4,33,'121212'),(169,4,33,'121212'),(170,6,30,'testing123'),(171,6,34,'pindi'),(172,7,30,'testing123'),(173,9,30,'testing123'),(174,9,33,'121212'),(177,11,30,'testing123'),(180,12,30,'testing123'),(181,12,33,'123'),(182,12,33,'123123'),(183,12,33,'test1'),(184,12,33,'test2'),(185,12,33,'test3'),(186,12,33,'test4'),(187,12,33,'123'),(188,12,33,'212'),(189,12,33,'1212'),(190,12,33,'1212'),(191,12,33,'121212'),(192,12,33,'121212'),(193,12,33,'121212'),(194,12,33,'121212'),(195,12,34,'pindi'),(196,2,39,'Single room'),(197,2,41,'10'),(200,4,39,'Double room'),(201,4,41,'01'),(314,1,39,'Twin room'),(315,1,41,'10'),(316,1,53,'Yes'),(317,1,54,'Yes'),(318,1,56,'Tv, Internet'),(319,2,39,'Twin room'),(320,2,41,'10'),(321,2,53,'Yes'),(322,2,54,'Yes'),(323,2,56,'Tv, Internet'),(378,3,41,'10'),(587,24,50,''),(588,24,51,''),(640,20,44,'Restaurant'),(641,20,44,'Bar'),(642,20,44,' 24-Hour Front Des'),(643,20,44,'Newspapers'),(644,20,44,'Terrace'),(645,20,44,'Non-smoking'),(646,20,44,'Facilities for Disabled Guests'),(647,20,44,'Elevator'),(648,20,44,'Safe'),(649,20,44,'Soundproof Rooms'),(650,20,44,'Designer Hotel'),(651,20,44,'Baggage Storage'),(652,20,44,'Air Conditioning'),(653,20,44,'Air Conditioning'),(654,20,44,'Restaurant With Dining Menu'),(655,20,44,'Sun Deck'),(656,20,45,'Tennis Court'),(657,20,45,' Fitness Center'),(658,20,45,'Golf Course'),(659,20,45,'Skiing'),(660,20,45,'Spa'),(661,20,45,'Massage'),(662,20,45,'Ski School'),(663,20,45,'Outdoor Pool'),(664,20,45,'Outdoor Swimming Pool (All Year)'),(665,20,46,'Room Service'),(666,20,46,'Meeting/Banquet Facilities'),(667,20,46,' Airport Shuttle'),(668,20,46,'Business Center'),(669,20,46,'Babysitting/Child Services'),(670,20,46,'Laundry'),(671,20,46,'Dry Cleaning'),(672,20,46,'Hair/Beauty Salon'),(673,20,46,'VIP Room Facilities'),(674,20,46,'Breakfast in the Room'),(675,20,46,'Ironing Service'),(676,20,46,'Shoeshine'),(677,20,46,'Tour Desk'),(678,20,46,'Ticket Service'),(679,20,47,'Free! Wi-Fi is available in all areas and is free of charge'),(680,20,48,'Free private parking is possible on site'),(681,20,50,'From 15:00 hours'),(682,20,51,'Until 12:00 hours'),(683,20,52,'Pets are not allowed'),(684,25,44,'Restaurant'),(685,25,44,'Bar'),(686,25,44,' 24-Hour Front Des'),(687,25,44,'Newspapers'),(688,25,44,'Terrace'),(689,25,44,'Non-smoking'),(690,25,44,'Facilities for Disabled Guests'),(691,25,44,'Elevator'),(692,25,44,'Safe'),(693,25,44,'Soundproof Rooms'),(694,25,44,'Designer Hotel'),(695,25,44,'Baggage Storage'),(696,25,44,'Air Conditioning'),(697,25,44,'Air Conditioning'),(698,25,44,'Restaurant With Dining Menu'),(699,25,44,'Sun Deck'),(700,25,45,'Tennis Court'),(701,25,45,' Fitness Center'),(702,25,45,'Golf Course'),(703,25,45,'Skiing'),(704,25,45,'Spa'),(705,25,45,'Massage'),(706,25,45,'Ski School'),(707,25,45,'Outdoor Pool'),(708,25,45,'Outdoor Swimming Pool (All Year)'),(709,25,46,'Room Service'),(710,25,46,'Meeting/Banquet Facilities'),(711,25,46,' Airport Shuttle'),(712,25,46,'Business Center'),(713,25,46,'Babysitting/Child Services'),(714,25,46,'Laundry'),(715,25,46,'Dry Cleaning'),(716,25,46,'Hair/Beauty Salon'),(717,25,46,'VIP Room Facilities'),(718,25,46,'Breakfast in the Room'),(719,25,46,'Ironing Service'),(720,25,46,'Shoeshine'),(721,25,46,'Car Rental'),(722,25,46,'Tour Desk'),(723,25,46,'Fax/Photocopying'),(724,25,46,'Ticket Service'),(725,25,46,'On-Site ATM Machine'),(726,25,46,'Shuttle Service (Surcharge)'),(727,25,46,'Ski Equipment Rental on site'),(728,25,46,'Ski Passes Available'),(729,25,46,'Ski-to-Door Access'),(730,25,47,'Free! Wi-Fi is available in all areas and is free of charge'),(731,25,50,'From 15:00 hours'),(732,25,51,'Until 12:00 hours'),(733,25,52,'Pets are not allowed');
/*!40000 ALTER TABLE `hr_hotel_option` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_pages`
--

DROP TABLE IF EXISTS `hr_pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_pages` (
  `pkpageid` int(255) NOT NULL AUTO_INCREMENT,
  `pagemenu` varchar(255) NOT NULL,
  `pagetext` longtext NOT NULL,
  `ptitle` varchar(255) DEFAULT NULL,
  `mtags` varchar(255) DEFAULT NULL,
  `mdes` varchar(255) NOT NULL,
  `pagemenu_sp` varchar(255) NOT NULL,
  `pagemenu_it` varchar(255) NOT NULL,
  `pagetext_it` longtext NOT NULL,
  `pagetext_sp` longtext NOT NULL,
  PRIMARY KEY (`pkpageid`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_pages`
--

LOCK TABLES `hr_pages` WRITE;
/*!40000 ALTER TABLE `hr_pages` DISABLE KEYS */;
INSERT INTO `hr_pages` VALUES (3,'CONTACT US','<p><span style=\"margin: 0px; padding: 0px; color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; \"> </span></p>\r\n<h1 style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; \">Office Address:</h1>\r\n<p><span style=\"color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; \">Kohat University of Science and Technology(KUST). </span><br style=\"margin: 0px; padding: 0px; color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; \" />\r\n<span style=\"color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; \">Tel/Fax : (123456-6) </span><br style=\"margin: 0px; padding: 0px; color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; \" />\r\n<br style=\"margin: 0px; padding: 0px; color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; \" />\r\n<span style=\"margin: 0px; padding: 0px; color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; \"> </span></p>\r\n<h1 style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px; \">Contacts:</h1>\r\n<p><span style=\"color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; \">Developing group em</span><br style=\"margin: 0px; padding: 0px; color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; \" />\r\n<span style=\"color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; \">Email: </span><a href=\"http://localhost/holidayrental/contact.php#\" style=\"margin: 0px; padding: 0px; font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; color: rgb(0, 0, 0); \">ISHP@gmail.com<br style=\"margin: 0px; padding: 0px; \" />\r\n</a><span style=\"color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; \">Website:</span><u><span style=\"color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; \">&nbsp;</span></u><a href=\"http://localhost/holidayrental/contact.php#\" style=\"margin: 0px; padding: 0px; font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify; color: rgb(0, 0, 0); \"><u>www.ISHP.com</u></a><span style=\"color: rgb(102, 102, 102); font-family: Arial, Helvetica, sans-serif; line-height: 24px; text-align: justify;\"> <br />\r\n</span></p>\r\n<p>&nbsp;</p>','Contact Us','Contact Us','','','','',''),(4,'About ISPH','<h2><span>Our Mission</span></h2>\r\n<p>To help leisure and business travelers, whatever their budget, easily  discover, book, and enjoy the world&rsquo;s best places to stay.</p>\r\n<h2><span>Our Vision</span></h2>\r\n<p>ISHP.com is an informative, user-friendly website &ndash; that  guarantees the best available prices. Our goal is to provide business  and leisure travelers with the most accessible and cost-effective way of  discovering and booking the broadest selection of accommodations, in  every corner of the world.</p>\r\n<p>&nbsp;</p>','About ISHP','About ISHP','ISHP','','','','');
/*!40000 ALTER TABLE `hr_pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_property`
--

DROP TABLE IF EXISTS `hr_property`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_property` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(225) NOT NULL,
  `short_description` text NOT NULL,
  `google` text NOT NULL,
  `listingid` int(225) NOT NULL,
  `bedroom` varchar(225) NOT NULL,
  `bathroom` varchar(225) NOT NULL,
  `sleeps` varchar(50) NOT NULL,
  `halfbath` varchar(50) NOT NULL,
  `image` varchar(225) NOT NULL,
  `status` int(11) NOT NULL,
  `aprice` int(255) NOT NULL,
  `admin` int(255) NOT NULL,
  `person` int(255) NOT NULL,
  `rooms` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `regionname` varchar(255) NOT NULL,
  `destination` varchar(255) NOT NULL,
  `locationtype` varchar(255) NOT NULL,
  `coordinate` varchar(255) NOT NULL,
  `pernight` int(255) NOT NULL,
  `perweek` int(255) NOT NULL,
  `weekend` int(255) NOT NULL,
  `midweek` int(255) NOT NULL,
  `twoweeks` int(255) NOT NULL,
  `threeweeks` int(255) NOT NULL,
  `monthprice` int(255) NOT NULL,
  `upddate` date NOT NULL,
  `property_type` varchar(255) NOT NULL,
  `general` varchar(255) NOT NULL,
  `admin_commission` varchar(50) NOT NULL,
  `user_id` int(50) NOT NULL,
  `description_it` text NOT NULL,
  `description_gr` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_property`
--

LOCK TABLES `hr_property` WRITE;
/*!40000 ALTER TABLE `hr_property` DISABLE KEYS */;
INSERT INTO `hr_property` VALUES (1,'Test Room','<p style=\"color: rgb(0, 53, 128); font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 15px;\">Hotel One Downtown, Lahore is located beside Androon Shehr (Old City) and offers modern rooms with free Wi-Fi. Featuring 2 dining options and a 24-hour front desk, the hotel provides free returns transfers to Allama Iqbal International Airport.</p>\r\n<p style=\"color: rgb(0, 53, 128); font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 15px;\">Each air-conditioned room features dark wood furnishings and a flat-screen cable TV, minibar and safe. Private bathroom includes a bath or shower and hairdryer.</p>\r\n<p style=\"color: rgb(0, 53, 128); font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 15px;\">500 metres from the hotel is Anarkali Bazaar. Attractions within 2 km of the hotel include Badshahi Mosque and Badshahi Fort. The city centre of Gulberg is 7 km away.</p>\r\n<p style=\"color: rgb(0, 53, 128); font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 15px;\">The hotel is equipped with a wheelchair access elevator. Conveniences at the hotel include an ATM cash machine, concierge and car rental desk. Guests enjoy free private parking.</p>\r\n<p style=\"color: rgb(0, 53, 128); font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 15px;\">Traditional Pakistani Cuisine is served at Chingari Restaurant. International cuisine and snacks can be ordered from Ravian Lounge.</p>','   ',0,'','','2','','1360524084images.jpg',1,0,-1,2,'Single room','PAKISTAN','Rawalpindi','','','','',0,0,0,0,0,0,0,'0000-00-00','','','',0,'',''),(2,'Fancy Corner Room','<p>&nbsp;<span style=\"color: rgb(0, 53, 128); font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 15px;\">Hotel One Hussain Chowk is centrally located in Lahore Central Business District, less than 1 km from MM Alam Food Street, Hafeez Centre and Gaddafi Stadium. Providing free Wi-Fi, it also has a 24-hour front desk and free parking. Table tennis facilities are available.</span></p>\r\n<p style=\"color: rgb(0, 53, 128); font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 15px;\">Fitted with air conditioning, all rooms come with a flat-screen TV, coffee machine and minibar. Suites include a separate seating area. En suite bathroom has a shower and free toiletries.</p>\r\n<p style=\"color: rgb(0, 53, 128); font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 15px;\">Hotel One Hussain Chowk is 22 km from Allama Iqbal International Airport. It is 50 km from Shiekhupura City, 70 km from Kasoor City and 80 km from Gujranwala City.</p>\r\n<p style=\"color: rgb(0, 53, 128); font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 15px;\">Kafe One serves Chinese and Continental dishes for lunch and dinner. In-room dining is possible with room service.</p>\r\n<p style=\"color: rgb(0, 53, 128); font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 15px;\">Guests can rent a car to explore the area, or request for a meeting room. The hotel also provides newspapers and currency exchange.</p>','',0,'','','4','','1360525753images_(2).jpg',1,0,-1,2,'Double room','','','','','','',0,0,0,0,0,0,0,'0000-00-00','','','',0,'',''),(3,'Corner Suite','<p>&nbsp;</p>\r\n<p>24-hour room service</p>\r\n<p>Service bar</p>\r\n<p>Digital Safe</p>\r\n<p>Cable/Satellite TV</p>\r\n<p>Internet access</p>','',0,'','','2','1','1360548762islamabad-marriott-room.jpg',1,0,20,4,'Lough view suite','','','','','','',0,0,0,0,0,0,0,'0000-00-00','','','',0,'','');
/*!40000 ALTER TABLE `hr_property` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_property_gallery`
--

DROP TABLE IF EXISTS `hr_property_gallery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_property_gallery` (
  `img_id` int(11) NOT NULL AUTO_INCREMENT,
  `img_caption` varchar(1024) NOT NULL,
  `img_src` varchar(1024) NOT NULL,
  `img_order` int(11) NOT NULL,
  `property_id` int(11) NOT NULL,
  PRIMARY KEY (`img_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_property_gallery`
--

LOCK TABLES `hr_property_gallery` WRITE;
/*!40000 ALTER TABLE `hr_property_gallery` DISABLE KEYS */;
INSERT INTO `hr_property_gallery` VALUES (1,'Caption-1','1360523948images_(1).jpg',1,1),(2,'Caption-2','1360523958images_(2).jpg',2,1),(3,'Caption-3','1360523971images.jpg',3,1);
/*!40000 ALTER TABLE `hr_property_gallery` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_registration`
--

DROP TABLE IF EXISTS `hr_registration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_registration` (
  `fid` int(50) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `fname` varchar(40) NOT NULL,
  `lname` varchar(40) NOT NULL,
  `email` varchar(50) NOT NULL,
  `bussiness_email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `gander` tinyint(4) NOT NULL COMMENT '0=male,1=female',
  `dob` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `address` varchar(500) NOT NULL,
  `zipcode` varchar(50) NOT NULL,
  `country` varchar(50) NOT NULL,
  `city` varchar(255) NOT NULL,
  `contectno` varchar(255) NOT NULL,
  `registered` int(11) NOT NULL COMMENT '1 for owner and 0 for customer',
  `profiledescription` text NOT NULL,
  `googlecode` text NOT NULL,
  `publish` int(11) NOT NULL COMMENT '0 for unblock and 1 for block',
  PRIMARY KEY (`fid`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_registration`
--

LOCK TABLES `hr_registration` WRITE;
/*!40000 ALTER TABLE `hr_registration` DISABLE KEYS */;
INSERT INTO `hr_registration` VALUES (14,'','umair','afridi','umairafridi@ymail.com','','123',0,'2013-02-05','kpk','babri banda p/o bili tang kohat','26000','PAKISTAN','kohat','033342092111',0,'','',0),(15,'shelton','mohammad','umair','umairafridi62@gmail.com','umairafridi62@gmail.com','123',0,'','nwfp','jhjhjhjhjgyut','26000','PAKISTAN','kohat','03214565987',1,'no thanks','',0),(20,'mall of emarat','safeer','shah','safeershah143@gmail.com','safeershah143@gmail.com','123',0,'','','Sheikh Zayed Road, Al Barsha, Dubai','','SAUDI ARABIA','madina','03000000000',1,'This 5-star Kempinski offers 24/7 concierge service and is connected to SkiDubai and Mall of the Emirates. It features luxurious rooms with chandeliers and marble bathrooms, as well as a vintage-style cigar bar, and an Ayurvedic spa.\r\nMall of the EmiratesThis 5-star Kempinski offers 24/7 concierge service and is connected to SkiDubai and Mall of the Emirates. It features luxurious rooms with chandeliers and marble bathrooms, as well as a vintage-style cigar bar, and an Ayurvedic spa.\r\nMall of the EmiratesThis 5-star Kempinski offers 24/7 concierge service and is connected to SkiDubai and Mall of the Emirates. It features luxurious rooms with chandeliers and marble bathrooms, as well as a vintage-style cigar bar, and an Ayurvedic spa.\r\nMall of the EmiratesThis 5-star Kempinski offers 24/7 concierge service and is connected to SkiDubai and Mall of the Emirates. It features luxurious rooms with chandeliers and marble bathrooms, as well as a vintage-style cigar bar, and an Ayurvedic spa.\r\nMall of the EmiratesThis 5-star Kempinski offers 24/7 concierge service and is connected to SkiDubai and Mall of the Emirates. It features luxurious rooms with chandeliers and marble bathrooms, as well as a vintage-style cigar bar, and an Ayurvedic spa.\r\nMall of the Emirates','<iframe width=\"220\" height=\"240\" frameborder=\"0\" scrolling=\"no\" marginheight=\"0\" marginwidth=\"0\" src=\"https://maps.google.com/maps?t=m&hl=en-US&ie=UTF8&ll=25.117621,55.203381&spn=0.079269,0.169086&z=13&output=embed\"></iframe><br /><small><a href=\"https://maps.google.com/maps?t=m&hl=en-US&ie=UTF8&ll=25.117621,55.203381&spn=0.079269,0.169086&z=13&source=embed\" style=\"color:#0000FF;text-align:left\">View Larger Map</a></small>',0),(21,'','safeer','shah','safeer_shah143@yahoo.com','','123',0,'1990-1-1','kpk','kohat cantt','26000','PAKISTAN','kohat','03005656561',0,'','',0),(23,'','rehmat','ullah','rehmat.32@gmail.com','','123',0,'','','kohat,kpk,Pakistan.','','PAKISTAN','','',0,'','',0),(25,'Sheraton park tower','ahmad','khan','riskyplayer_549@yahoo.com','riskyplayer_549@yahoo.com','123',0,'','','kpk kohat','','UNITED ARAB EMIRATES','','03000000000',1,'Directly connected to the Mall of the Emirates, the Sheraton Dubai Hotel is located with easy access to such destinations as Jumeirah and Dubai Marina. Dubai International Airport is only 20 minutes away by car.\r\n\r\nAll suites and rooms at Sheraton Dubai Mall of the Emirates offer views of the city skyline. Each features a flat-screen TV, minibar and a private bathroom. Some suites have a living room and a kitchenette complete with dining area.\r\n\r\nGuests enjoy wealth of options at Sheraton such as indulge in a spa treatment or in the sauna or whirlpool. After an energizing workout at the gym, guests can take a dip in the outdoor pool to refresh.\r\n\r\nAl Sanabel Restaurant serves a breakfast buffet daily, while diverse specialties are served in the evening. Guests can unwind by the rooftop pool at Sanctuary Pool Lounge, which offers a variety of drinks and snacks.\r\n\r\nSouk Madinat, with its traditional markets, is 4 miles from Sheraton Dubai Mall of the Emirates. Dubai Festival City is 16 miles drive away. An airport shuttle is available upon request','<iframe width=\"220\" height=\"240\" frameborder=\"0\" scrolling=\"no\" marginheight=\"0\" marginwidth=\"0\" src=\"http://maps.google.com/maps?t=m&amp;hl=en&amp;ie=UTF8&amp;ll=25.11991,55.20294&amp;spn=0.010744,0.021136&amp;z=16&amp;output=embed\"></iframe><br /><small><a href=\"http://maps.google.com/maps?t=m&amp;hl=en&amp;ie=UTF8&amp;ll=25.11991,55.20294&amp;spn=0.010744,0.021136&amp;z=16&amp;source=embed\" style=\"color:#0000FF;text-align:left\">View Larger Map</a></small>',1);
/*!40000 ALTER TABLE `hr_registration` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_submission`
--

DROP TABLE IF EXISTS `hr_submission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hr_submission` (
  `pksubid` int(255) NOT NULL AUTO_INCREMENT,
  `fname` varchar(100) NOT NULL,
  `lname` varchar(255) NOT NULL,
  `sub_date` date NOT NULL,
  `sub_phone` varchar(25) NOT NULL,
  `sub_email` varchar(50) NOT NULL,
  `sub_message` text,
  `category` int(255) NOT NULL DEFAULT '1',
  `sub_subject` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) NOT NULL,
  PRIMARY KEY (`pksubid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_submission`
--

LOCK TABLES `hr_submission` WRITE;
/*!40000 ALTER TABLE `hr_submission` DISABLE KEYS */;
/*!40000 ALTER TABLE `hr_submission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'safeer'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2013-02-14 23:19:18
2
Contributors
1
Reply
17
Views
4 Years
Discussion Span
Last Post by LastMitch
1

@HunainHafeez

i tried reverse engineering option in Mysql workbend 5.1,

I think in the future try not to post your dump.

It's a bit long don't you think?

Only 1 table is good enough to display not your whole database.

I don't anyone will read a whole database table. That's too much to ask.

Read this regarding about how to create a code:

http://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.