--
-- Host: localhost    Database: bizpit
-- ------------------------------------------------------


--
-- Table structure for table `BizPit_api_app_loginrequestresponses`
--

CREATE TABLE `BizPit_api_app_loginrequestresponses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `requestid` varchar(200) NOT NULL,
  `userMobileNos` varchar(200) NOT NULL,
  `userhandle` varchar(200) NOT NULL,
  `deviceType` varchar(200) NOT NULL,
  `deviceId` varchar(200) NOT NULL,
  `appVersion` varchar(200) NOT NULL,
  `gcmId` varchar(200) NOT NULL,
  `userLocation` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_api_app_loginrequestresponses`
--


--
-- Table structure for table `BizPit_api_app_usersettingsrequestresponses`
--

CREATE TABLE `BizPit_api_app_usersettingsrequestresponses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Request_ID` varchar(200) NOT NULL,
  `userHandle` varchar(200) NOT NULL,
  `resultCode` varchar(200) NOT NULL,
  `resultDetails` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2868 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_api_app_usersettingsrequestresponses`
--

INSERT INTO `BizPit_api_app_usersettingsrequestresponses` VALUES (1,'','12','',''),(2,'','12','',''),(3,'','12','',''),(4,'','','',''),(5,'','','',''),(6,'','','',''),(7,'','2','',''),(8,'','2','',''),(9,'','2','',''),(10,'','2','',''),(11,'','2','',''),(12,'','','',''),(13,'','','',''),(14,'','','',''),(15,'','2','',''),(16,'','2','',''),(17,'','2','',''),(18,'','','',''),(19,'','','',''),(20,'','','',''),(21,'','','',''),(22,'','','',''),(23,'','','',''),(24,'','','',''),(25,'','1','',''),(26,'','1','',''),(27,'','1','',''),(28,'','1','',''),(29,'','1','',''),(30,'','1','',''),(31,'','1','',''),(32,'','1','',''),(33,'','1','',''),(34,'','1','',''),(35,'','1','',''),(36,'','1','',''),(37,'','1','',''),(38,'','1','',''),(39,'','1','',''),(40,'','2','',''),(41,'','1','',''),(42,'','1','',''),(43,'','1','',''),(44,'','','',''),(45,'','1','',''),(46,'','1','',''),(47,'','1','',''),(48,'','2','',''),(49,'','1','',''),(50,'','1','',''),(51,'','1','',''),(52,'','1','',''),(53,'','1','',''),(54,'','2','',''),(55,'','2','',''),(56,'','1','',''),(57,'','1','',''),(58,'','1','',''),(59,'','1','',''),(60,'','1','',''),(61,'','1','',''),(62,'','1','',''),(63,'','1','',''),(64,'','1','',''),(65,'','1','',''),(66,'','1','',''),(67,'','1','',''),(68,'','1','',''),(69,'','2','',''),(70,'','2','',''),(71,'','1','',''),(72,'','1','',''),(73,'','2','',''),(74,'','1','',''),(75,'','1','',''),(76,'','1','',''),(77,'','1','',''),(78,'','1','',''),(79,'','1','',''),(80,'','1','',''),(81,'','1','',''),(82,'','1','',''),(83,'','1','',''),(84,'','1','',''),(85,'','1','',''),(86,'','','',''),(87,'','','',''),(88,'','','',''),(89,'','','',''),(90,'','','',''),(91,'','1','',''),(92,'','1','',''),(93,'','1','',''),(94,'','1','',''),(95,'','2','',''),(96,'','1','',''),(97,'','1','',''),(98,'','2','',''),(99,'','1','',''),(100,'','1','',''),(101,'','1','',''),(102,'','1','',''),(103,'','1','',''),(104,'','2','',''),(105,'','','',''),(106,'','2','',''),(107,'','2','',''),(108,'','2','',''),(109,'','2','',''),(110,'','1','',''),(111,'','1','',''),(112,'','2','',''),(113,'','1','',''),(114,'','1','',''),(115,'','1','',''),(116,'','1','',''),(117,'','1','',''),(118,'','1','',''),(119,'','','',''),(120,'','1','',''),(121,'','1','',''),(122,'','1','',''),(123,'','1','',''),(124,'','1','',''),(125,'','1','',''),(126,'','1','',''),(127,'','1','',''),(128,'','1','',''),(129,'','1','',''),(130,'','1','',''),(131,'','1','',''),(132,'','1','',''),(133,'','1','',''),(134,'','','',''),(135,'','1','',''),(136,'','1','',''),(137,'','1','',''),(138,'','1','',''),(139,'','1','',''),(140,'','1','',''),(141,'','1','',''),(142,'','1','',''),(143,'','1','',''),(144,'','1','',''),(145,'','1','',''),(146,'','1','',''),(147,'','1','',''),(148,'','1','',''),(149,'','1','',''),(150,'','1','',''),(151,'','1','',''),(152,'','1','',''),(153,'','1','',''),(154,'','1','',''),(155,'','1','',''),(156,'','','',''),(157,'','1','',''),(158,'','1','',''),(159,'','1','',''),(160,'','1','',''),(161,'','1','',''),(162,'','1','',''),(163,'','1','',''),(164,'','1','',''),(165,'','1','',''),(166,'','1','',''),(167,'','','',''),(168,'','1','',''),(169,'','2','',''),(170,'','1','',''),(171,'','1','',''),(172,'','1','',''),(173,'','1','',''),(174,'','1','',''),(175,'','1','',''),(176,'','1','',''),(177,'','1','',''),(178,'','1','',''),(179,'','1','',''),(180,'','1','',''),(181,'','1','',''),(182,'','1','',''),(183,'','1','',''),(184,'','1','',''),(185,'','','',''),(186,'','','',''),(187,'','','',''),(188,'','','',''),(189,'','','',''),(190,'','','',''),(191,'','','',''),(192,'','','',''),(193,'','','',''),(194,'','','',''),(195,'','','',''),(196,'','','',''),(197,'','','',''),(198,'','','',''),(199,'','','',''),(200,'','','',''),(201,'','','',''),(202,'','1','',''),(203,'','1','',''),(204,'','1','',''),(205,'','1','',''),(206,'','1','',''),(207,'','1','',''),(208,'','1','',''),(209,'','1','',''),(210,'','1','',''),(211,'','1','',''),(212,'','1','',''),(213,'','1','',''),(214,'','','',''),(215,'','','',''),(216,'','','',''),(217,'','1','',''),(218,'','1','',''),(219,'','1','',''),(220,'','1','',''),(221,'','1','',''),(222,'','1','',''),(223,'','1','',''),(224,'','1','',''),(225,'','1','',''),(226,'','1','',''),(227,'','1','',''),(228,'','1','',''),(229,'','1','',''),(230,'','1','',''),(231,'','1','',''),(232,'','1','',''),(233,'','1','',''),(234,'','1','',''),(235,'','1','',''),(236,'','1','',''),(237,'','1','',''),(238,'','1','',''),(239,'','2','',''),(240,'','1','',''),(241,'','1','',''),(242,'','1','',''),(243,'','1','',''),(244,'','1','',''),(245,'','1','',''),(246,'','2','',''),(247,'','1','',''),(248,'','2','',''),(249,'','1','',''),(250,'','1','',''),(251,'','1','',''),(252,'','1','',''),(253,'','1','',''),(254,'','1','',''),(255,'','2','',''),(256,'','1','',''),(257,'','1','',''),(258,'','1','',''),(259,'','1','',''),(260,'','1','',''),(261,'','1','',''),(262,'','1','',''),(263,'','2','',''),(264,'','1','',''),(265,'','2','',''),(266,'','1','',''),(267,'','1','',''),(268,'','','',''),(269,'','1','',''),(270,'','1','',''),(271,'','1','',''),(272,'','1','',''),(273,'','1','',''),(274,'','1','',''),(275,'','1','',''),(276,'','1','',''),(277,'','1','',''),(278,'','1','',''),(279,'','1','',''),(280,'','1','',''),(281,'','2','',''),(282,'','10','',''),(283,'','10','',''),(284,'','10','',''),(285,'','10','',''),(286,'','10','',''),(287,'','1','',''),(288,'','1','',''),(289,'','10','',''),(290,'','1','',''),(291,'','10','',''),(292,'','2','',''),(293,'','2','',''),(294,'','10','',''),(295,'','1','',''),(296,'','1','',''),(297,'','1','',''),(298,'','1','',''),(299,'','1','',''),(300,'','1','',''),(301,'','1','',''),(302,'','2','',''),(303,'','10','',''),(304,'','1','',''),(305,'','2','',''),(306,'','1','',''),(307,'','1','',''),(308,'','10','',''),(309,'','1','',''),(310,'','2','',''),(311,'','1','',''),(312,'','2','',''),(313,'','10','',''),(314,'','2','',''),(315,'','10','',''),(316,'','1','',''),(317,'','1','',''),(318,'','1','',''),(319,'','2','',''),(320,'','10','',''),(321,'','2','',''),(322,'','10','',''),(323,'','2','',''),(324,'','10','',''),(325,'','2','',''),(326,'','2','',''),(327,'','2','',''),(328,'','10','',''),(329,'','10','',''),(330,'','10','',''),(331,'','10','',''),(332,'','10','',''),(333,'','10','',''),(334,'','2','',''),(335,'','10','',''),(336,'','','',''),(337,'','','',''),(338,'','','',''),(339,'','','',''),(340,'','','',''),(341,'','','',''),(342,'','','',''),(343,'','2','',''),(344,'','3','',''),(345,'','3','',''),(346,'','3','',''),(347,'','3','',''),(348,'','3','',''),(349,'','','',''),(350,'','3','',''),(351,'','3','',''),(352,'','3','',''),(353,'','','',''),(354,'','','',''),(355,'','','',''),(356,'','','',''),(357,'','10','',''),(358,'','10','',''),(359,'','10','',''),(360,'','10','',''),(361,'','10','',''),(362,'','10','',''),(363,'','2','',''),(364,'','','',''),(365,'','','',''),(366,'','10','',''),(367,'','','',''),(368,'','2','',''),(369,'','10','',''),(370,'','','',''),(371,'','2','',''),(372,'','','',''),(373,'','','',''),(374,'','','',''),(375,'','','',''),(376,'','','',''),(377,'','','',''),(378,'','','',''),(379,'','','',''),(380,'','','',''),(381,'','','',''),(382,'','','',''),(383,'','','',''),(384,'','','',''),(385,'','','',''),(386,'','','',''),(387,'','','',''),(388,'','','',''),(389,'','','',''),(390,'','10','',''),(391,'','10','',''),(392,'','10','',''),(393,'','10','',''),(394,'','10','',''),(395,'','10','',''),(396,'','10','',''),(397,'','10','',''),(398,'','10','',''),(399,'','10','',''),(400,'','10','',''),(401,'','2','',''),(402,'','10','',''),(403,'','2','',''),(404,'','10','',''),(405,'','2','',''),(406,'','2','',''),(407,'','2','',''),(408,'','10','',''),(409,'','10','',''),(410,'','10','',''),(411,'','','',''),(412,'','10','',''),(413,'','2','',''),(414,'','10','',''),(415,'','10','',''),(416,'','2','',''),(417,'','10','',''),(418,'','10','',''),(419,'','10','',''),(420,'','10','',''),(421,'','','',''),(422,'','10','',''),(423,'','10','',''),(424,'','10','',''),(425,'','10','',''),(426,'','10','',''),(427,'','10','',''),(428,'','10','',''),(429,'','10','',''),(430,'','2','',''),(431,'','10','',''),(432,'','','',''),(433,'','2','',''),(434,'','10','',''),(435,'','2','',''),(436,'','10','',''),(437,'','2','',''),(438,'','10','',''),(439,'','10','',''),(440,'','2','',''),(441,'','10','',''),(442,'','10','',''),(443,'','10','',''),(444,'','10','',''),(445,'','2','',''),(446,'','10','',''),(447,'','10','',''),(448,'','10','',''),(449,'','10','',''),(450,'','2','',''),(451,'','2','',''),(452,'','2','',''),(453,'','','',''),(454,'','10','',''),(455,'','2','',''),(456,'','10','',''),(457,'','10','',''),(458,'','10','',''),(459,'','10','',''),(460,'','10','',''),(461,'','10','',''),(462,'','2','',''),(463,'','10','',''),(464,'','2','',''),(465,'','10','',''),(466,'','10','',''),(467,'','10','',''),(468,'','2','',''),(469,'','','',''),(470,'','2','',''),(471,'','10','',''),(472,'','2','',''),(473,'','10','',''),(474,'','2','',''),(475,'','2','',''),(476,'','10','',''),(477,'','10','',''),(478,'','10','',''),(479,'','10','',''),(480,'','10','',''),(481,'','','',''),(482,'','','',''),(483,'','','',''),(484,'','10','',''),(485,'','10','',''),(486,'','10','',''),(487,'','10','',''),(488,'','10','',''),(489,'','10','',''),(490,'','2','',''),(491,'','10','',''),(492,'','10','',''),(493,'','10','',''),(494,'','10','',''),(495,'','10','',''),(496,'','10','',''),(497,'','10','',''),(498,'','10','',''),(499,'','10','',''),(500,'','10','',''),(501,'','10','',''),(502,'','10','',''),(503,'','10','',''),(504,'','10','',''),(505,'','10','',''),(506,'','10','',''),(507,'','10','',''),(508,'','10','',''),(509,'','10','',''),(510,'','10','',''),(511,'','10','',''),(512,'','10','',''),(513,'','10','',''),(514,'','10','',''),(515,'','10','',''),(516,'','10','',''),(517,'','10','',''),(518,'','10','',''),(519,'','10','',''),(520,'','10','',''),(521,'','10','',''),(522,'','10','',''),(523,'','10','',''),(524,'','10','',''),(525,'','10','',''),(526,'','10','',''),(527,'','10','',''),(528,'','10','',''),(529,'','10','',''),(530,'','10','',''),(531,'','10','',''),(532,'','10','',''),(533,'','10','',''),(534,'','10','',''),(535,'','10','',''),(536,'','10','',''),(537,'','10','',''),(538,'','2','',''),(539,'','2','',''),(540,'','10','',''),(541,'','10','',''),(542,'','10','',''),(543,'','2','',''),(544,'','2','',''),(545,'','10','',''),(546,'','2','',''),(547,'','10','',''),(548,'','10','',''),(549,'','10','',''),(550,'','10','',''),(551,'','10','',''),(552,'','10','',''),(553,'','2','',''),(554,'','','',''),(555,'','','',''),(556,'','','',''),(557,'','10','',''),(558,'','10','',''),(559,'','10','',''),(560,'','10','',''),(561,'','10','',''),(562,'','10','',''),(563,'','2','',''),(564,'','2','',''),(565,'','2','',''),(566,'','2','',''),(567,'','10','',''),(568,'','2','',''),(569,'','10','',''),(570,'','2','',''),(571,'','2','',''),(572,'','10','',''),(573,'','10','',''),(574,'','10','',''),(575,'','10','',''),(576,'','10','',''),(577,'','10','',''),(578,'','10','',''),(579,'','2','',''),(580,'','2','',''),(581,'','2','',''),(582,'','2','',''),(583,'','2','',''),(584,'','10','',''),(585,'','10','',''),(586,'','10','',''),(587,'','10','',''),(588,'','10','',''),(589,'','10','',''),(590,'','2','',''),(591,'','2','',''),(592,'','2','',''),(593,'','10','',''),(594,'','2','',''),(595,'','2','',''),(596,'','10','',''),(597,'','2','',''),(598,'','10','',''),(599,'','10','',''),(600,'','10','',''),(601,'','10','',''),(602,'','10','',''),(603,'','10','',''),(604,'','2','',''),(605,'','10','',''),(606,'','2','',''),(607,'','10','',''),(608,'','2','',''),(609,'','2','',''),(610,'','2','',''),(611,'','10','',''),(612,'','2','',''),(613,'','2','',''),(614,'','2','',''),(615,'','2','',''),(616,'','2','',''),(617,'','2','',''),(618,'','2','',''),(619,'','2','',''),(620,'','2','',''),(621,'','10','',''),(622,'','2','',''),(623,'','10','',''),(624,'','10','',''),(625,'','10','',''),(626,'','10','',''),(627,'','10','',''),(628,'','10','',''),(629,'','10','',''),(630,'','2','',''),(631,'','10','',''),(632,'','2','',''),(633,'','10','',''),(634,'','2','',''),(635,'','10','',''),(636,'','2','',''),(637,'','10','',''),(638,'','10','',''),(639,'','2','',''),(640,'','10','',''),(641,'','10','',''),(642,'','10','',''),(643,'','10','',''),(644,'','10','',''),(645,'','10','',''),(646,'','10','',''),(647,'','10','',''),(648,'','10','',''),(649,'','10','',''),(650,'','10','',''),(651,'','10','',''),(652,'','10','',''),(653,'','10','',''),(654,'','10','',''),(655,'','2','',''),(656,'','2','',''),(657,'','2','',''),(658,'','2','',''),(659,'','10','',''),(660,'','2','',''),(661,'','2','',''),(662,'','10','',''),(663,'','2','',''),(664,'','1','',''),(665,'','10','',''),(666,'','2','',''),(667,'','10','',''),(668,'','10','',''),(669,'','10','',''),(670,'','10','',''),(671,'','10','',''),(672,'','10','',''),(673,'','10','',''),(674,'','10','',''),(675,'','2','',''),(676,'','10','',''),(677,'','10','',''),(678,'','2','',''),(679,'','10','',''),(680,'','','',''),(681,'','','',''),(682,'','','',''),(683,'','','',''),(684,'','','',''),(685,'','','',''),(686,'','','',''),(687,'','','',''),(688,'','','',''),(689,'','','',''),(690,'','','',''),(691,'','2','',''),(692,'','','',''),(693,'','2','',''),(694,'','10','',''),(695,'','10','',''),(696,'','10','',''),(697,'','10','',''),(698,'','10','',''),(699,'','10','',''),(700,'','2','',''),(701,'','1','',''),(702,'','10','',''),(703,'','2','',''),(704,'','10','',''),(705,'','10','',''),(706,'','10','',''),(707,'','10','',''),(708,'','10','',''),(709,'','10','',''),(710,'','10','',''),(711,'','10','',''),(712,'','10','',''),(713,'','10','',''),(714,'','10','',''),(715,'','2','',''),(716,'','10','',''),(717,'','10','',''),(718,'','10','',''),(719,'','10','',''),(720,'','10','',''),(721,'','10','',''),(722,'','2','',''),(723,'','','',''),(724,'','','',''),(725,'','','',''),(726,'','','',''),(727,'','','',''),(728,'','','',''),(729,'','2','',''),(730,'','','',''),(731,'','','',''),(732,'','','',''),(733,'','10','',''),(734,'','10','',''),(735,'','10','',''),(736,'','10','',''),(737,'','10','',''),(738,'','10','',''),(739,'','2','',''),(740,'','10','',''),(741,'','10','',''),(742,'','10','',''),(743,'','10','',''),(744,'','10','',''),(745,'','10','',''),(746,'','2','',''),(747,'','2','',''),(748,'','10','',''),(749,'','10','',''),(750,'','10','',''),(751,'','10','',''),(752,'','10','',''),(753,'','10','',''),(754,'','2','',''),(755,'','10','',''),(756,'','','',''),(757,'','','',''),(758,'','','',''),(759,'','10','',''),(760,'','10','',''),(761,'','10','',''),(762,'','10','',''),(763,'','10','',''),(764,'','10','',''),(765,'','2','',''),(766,'','','',''),(767,'','','',''),(768,'','','',''),(769,'','','',''),(770,'','','',''),(771,'','10','',''),(772,'','10','',''),(773,'','10','',''),(774,'','10','',''),(775,'','10','',''),(776,'','10','',''),(777,'','2','',''),(778,'','','',''),(779,'','','',''),(780,'','','',''),(781,'','10','',''),(782,'','10','',''),(783,'','10','',''),(784,'','10','',''),(785,'','10','',''),(786,'','10','',''),(787,'','2','',''),(788,'','','',''),(789,'','','',''),(790,'','','',''),(791,'','4','',''),(792,'','4','',''),(793,'','4','',''),(794,'','4','',''),(795,'','4','',''),(796,'','4','',''),(797,'','2','',''),(798,'','','',''),(799,'','','',''),(800,'','','',''),(801,'','4','',''),(802,'','4','',''),(803,'','4','',''),(804,'','4','',''),(805,'','4','',''),(806,'','4','',''),(807,'','4','',''),(808,'','4','',''),(809,'','4','',''),(810,'','4','',''),(811,'','4','',''),(812,'','2','',''),(813,'','2','',''),(814,'','2','',''),(815,'','2','',''),(816,'','','',''),(817,'','','',''),(818,'','','',''),(819,'','','',''),(820,'','','',''),(821,'','','',''),(822,'','2','',''),(823,'','4','',''),(824,'','4','',''),(825,'','4','',''),(826,'','4','',''),(827,'','4','',''),(828,'','','',''),(829,'','','',''),(830,'','','',''),(831,'','','',''),(832,'','','',''),(833,'','','',''),(834,'','2','',''),(835,'','1','',''),(836,'','1','',''),(837,'','','',''),(838,'','','',''),(839,'','','',''),(840,'','1','',''),(841,'','1','',''),(842,'','','',''),(843,'','5','',''),(844,'','5','',''),(845,'','5','',''),(846,'','5','',''),(847,'','5','',''),(848,'','1','',''),(849,'','5','',''),(850,'','1','',''),(851,'','2','',''),(852,'','1','',''),(853,'','2','',''),(854,'','2','',''),(855,'','2','',''),(856,'','5','',''),(857,'','5','',''),(858,'','5','',''),(859,'','5','',''),(860,'','5','',''),(861,'','5','',''),(862,'','2','',''),(863,'','2','',''),(864,'','2','',''),(865,'','2','',''),(866,'','5','',''),(867,'','5','',''),(868,'','5','',''),(869,'','5','',''),(870,'','5','',''),(871,'','5','',''),(872,'','2','',''),(873,'','5','',''),(874,'','2','',''),(875,'','2','',''),(876,'','5','',''),(877,'','5','',''),(878,'','5','',''),(879,'','5','',''),(880,'','5','',''),(881,'','5','',''),(882,'','2','',''),(883,'','','',''),(884,'','2','',''),(885,'','5','',''),(886,'','5','',''),(887,'','2','',''),(888,'','2','',''),(889,'','2','',''),(890,'','5','',''),(891,'','5','',''),(892,'','5','',''),(893,'','5','',''),(894,'','5','',''),(895,'','5','',''),(896,'','2','',''),(897,'','2','',''),(898,'','2','',''),(899,'','5','',''),(900,'','5','',''),(901,'','5','',''),(902,'','5','',''),(903,'','5','',''),(904,'','5','',''),(905,'','5','',''),(906,'','5','',''),(907,'','5','',''),(908,'','2','',''),(909,'','2','',''),(910,'','2','',''),(911,'','5','',''),(912,'','5','',''),(913,'','5','',''),(914,'','5','',''),(915,'','5','',''),(916,'','2','',''),(917,'','5','',''),(918,'','2','',''),(919,'','5','',''),(920,'','2','',''),(921,'','5','',''),(922,'','5','',''),(923,'','5','',''),(924,'','5','',''),(925,'','5','',''),(926,'','5','',''),(927,'','5','',''),(928,'','5','',''),(929,'','2','',''),(930,'','2','',''),(931,'','5','',''),(932,'','5','',''),(933,'','5','',''),(934,'','5','',''),(935,'','5','',''),(936,'','5','',''),(937,'','2','',''),(938,'','5','',''),(939,'','2','',''),(940,'','5','',''),(941,'','','',''),(942,'','','',''),(943,'','','',''),(944,'','','',''),(945,'','','',''),(946,'','5','',''),(947,'','5','',''),(948,'','5','',''),(949,'','5','',''),(950,'','5','',''),(951,'','5','',''),(952,'','2','',''),(953,'','','',''),(954,'','','',''),(955,'','','',''),(956,'','2','',''),(957,'','2','',''),(958,'','2','',''),(959,'','2','',''),(960,'','2','',''),(961,'','2','',''),(962,'','2','',''),(963,'','2','',''),(964,'','2','',''),(965,'','','',''),(966,'','','',''),(967,'','','',''),(968,'','2','',''),(969,'','5','',''),(970,'','5','',''),(971,'','5','',''),(972,'','5','',''),(973,'','5','',''),(974,'','5','',''),(975,'','2','',''),(976,'','','',''),(977,'','','',''),(978,'','','',''),(979,'','5','',''),(980,'','5','',''),(981,'','5','',''),(982,'','5','',''),(983,'','5','',''),(984,'','5','',''),(985,'','2','',''),(986,'','5','',''),(987,'','5','',''),(988,'','5','',''),(989,'','5','',''),(990,'','5','',''),(991,'','5','',''),(992,'','2','',''),(993,'','5','',''),(994,'','5','',''),(995,'','5','',''),(996,'','5','',''),(997,'','5','',''),(998,'','5','',''),(999,'','2','',''),(1000,'','5','',''),(1001,'','5','',''),(1002,'','5','',''),(1003,'','5','',''),(1004,'','5','',''),(1005,'','','',''),(1006,'','','',''),(1007,'','','',''),(1008,'','','',''),(1009,'','','',''),(1010,'','','',''),(1011,'','2','',''),(1012,'','2','',''),(1013,'','5','',''),(1014,'','5','',''),(1015,'','5','',''),(1016,'','5','',''),(1017,'','5','',''),(1018,'','5','',''),(1019,'','2','',''),(1020,'','5','',''),(1021,'','5','',''),(1022,'','5','',''),(1023,'','5','',''),(1024,'','5','',''),(1025,'','5','',''),(1026,'','2','',''),(1027,'','5','',''),(1028,'','5','',''),(1029,'','5','',''),(1030,'','5','',''),(1031,'','5','',''),(1032,'','5','',''),(1033,'','2','',''),(1034,'','5','',''),(1035,'','5','',''),(1036,'','5','',''),(1037,'','5','',''),(1038,'','5','',''),(1039,'','5','',''),(1040,'','2','',''),(1041,'','5','',''),(1042,'','5','',''),(1043,'','5','',''),(1044,'','5','',''),(1045,'','5','',''),(1046,'','5','',''),(1047,'','2','',''),(1048,'','2','',''),(1049,'','5','',''),(1050,'','5','',''),(1051,'','5','',''),(1052,'','5','',''),(1053,'','5','',''),(1054,'','5','',''),(1055,'','2','',''),(1056,'','5','',''),(1057,'','5','',''),(1058,'','5','',''),(1059,'','5','',''),(1060,'','5','',''),(1061,'','5','',''),(1062,'','2','',''),(1063,'','5','',''),(1064,'','2','',''),(1065,'','5','',''),(1066,'','','',''),(1067,'','','',''),(1068,'','','',''),(1069,'','5','',''),(1070,'','5','',''),(1071,'','5','',''),(1072,'','5','',''),(1073,'','5','',''),(1074,'','5','',''),(1075,'','2','',''),(1076,'','5','',''),(1077,'','','',''),(1078,'','','',''),(1079,'','','',''),(1080,'','5','',''),(1081,'','5','',''),(1082,'','5','',''),(1083,'','5','',''),(1084,'','5','',''),(1085,'','5','',''),(1086,'','2','',''),(1087,'','5','',''),(1088,'','2','',''),(1089,'','5','',''),(1090,'','','',''),(1091,'','','',''),(1092,'','','',''),(1093,'','5','',''),(1094,'','5','',''),(1095,'','5','',''),(1096,'','5','',''),(1097,'','5','',''),(1098,'','5','',''),(1099,'','2','',''),(1100,'','5','',''),(1101,'','2','',''),(1102,'','5','',''),(1103,'','2','',''),(1104,'','5','',''),(1105,'','2','',''),(1106,'','2','',''),(1107,'','2','',''),(1108,'','5','',''),(1109,'','2','',''),(1110,'','5','',''),(1111,'','5','',''),(1112,'','2','',''),(1113,'','5','',''),(1114,'','2','',''),(1115,'','2','',''),(1116,'','5','',''),(1117,'','5','',''),(1118,'','5','',''),(1119,'','5','',''),(1120,'','5','',''),(1121,'','5','',''),(1122,'','2','',''),(1123,'','2','',''),(1124,'','2','',''),(1125,'','2','',''),(1126,'','2','',''),(1127,'','5','',''),(1128,'','5','',''),(1129,'','5','',''),(1130,'','5','',''),(1131,'','5','',''),(1132,'','5','',''),(1133,'','2','',''),(1134,'','2','',''),(1135,'','5','',''),(1136,'','5','',''),(1137,'','5','',''),(1138,'','5','',''),(1139,'','5','',''),(1140,'','5','',''),(1141,'','2','',''),(1142,'','2','',''),(1143,'','2','',''),(1144,'','2','',''),(1145,'','2','',''),(1146,'','5','',''),(1147,'','5','',''),(1148,'','5','',''),(1149,'','5','',''),(1150,'','5','',''),(1151,'','5','',''),(1152,'','2','',''),(1153,'','5','',''),(1154,'','','',''),(1155,'','','',''),(1156,'','','',''),(1157,'','5','',''),(1158,'','5','',''),(1159,'','5','',''),(1160,'','5','',''),(1161,'','5','',''),(1162,'','5','',''),(1163,'','2','',''),(1164,'','5','',''),(1165,'','5','',''),(1166,'','5','',''),(1167,'','5','',''),(1168,'','5','',''),(1169,'','5','',''),(1170,'','5','',''),(1171,'','2','',''),(1172,'','2','',''),(1173,'','2','',''),(1174,'','2','',''),(1175,'','5','',''),(1176,'','5','',''),(1177,'','5','',''),(1178,'','5','',''),(1179,'','5','',''),(1180,'','5','',''),(1181,'','5','',''),(1182,'','2','',''),(1183,'','2','',''),(1184,'','2','',''),(1185,'','5','',''),(1186,'','5','',''),(1187,'','5','',''),(1188,'','5','',''),(1189,'','5','',''),(1190,'','5','',''),(1191,'','5','',''),(1192,'','2','',''),(1193,'','2','',''),(1194,'','2','',''),(1195,'','2','',''),(1196,'','5','',''),(1197,'','5','',''),(1198,'','5','',''),(1199,'','5','',''),(1200,'','5','',''),(1201,'','5','',''),(1202,'','5','',''),(1203,'','2','',''),(1204,'','2','',''),(1205,'','2','',''),(1206,'','2','',''),(1207,'','5','',''),(1208,'','5','',''),(1209,'','5','',''),(1210,'','5','',''),(1211,'','5','',''),(1212,'','5','',''),(1213,'','5','',''),(1214,'','2','',''),(1215,'','2','',''),(1216,'','2','',''),(1217,'','5','',''),(1218,'','2','',''),(1219,'','5','',''),(1220,'','2','',''),(1221,'','5','',''),(1222,'','2','',''),(1223,'','5','',''),(1224,'','2','',''),(1225,'','5','',''),(1226,'','5','',''),(1227,'','5','',''),(1228,'','5','',''),(1229,'','5','',''),(1230,'','5','',''),(1231,'','2','',''),(1232,'','2','',''),(1233,'','5','',''),(1234,'','2','',''),(1235,'','5','',''),(1236,'','2','',''),(1237,'','2','',''),(1238,'','2','',''),(1239,'','2','',''),(1240,'','2','',''),(1241,'','2','',''),(1242,'','2','',''),(1243,'','5','',''),(1244,'','2','',''),(1245,'','2','',''),(1246,'','2','',''),(1247,'','2','',''),(1248,'','2','',''),(1249,'','2','',''),(1250,'','2','',''),(1251,'','2','',''),(1252,'','2','',''),(1253,'','2','',''),(1254,'','2','',''),(1255,'','2','',''),(1256,'','2','',''),(1257,'','2','',''),(1258,'','2','',''),(1259,'','2','',''),(1260,'','5','',''),(1261,'','2','',''),(1262,'','2','',''),(1263,'','2','',''),(1264,'','2','',''),(1265,'','2','',''),(1266,'','2','',''),(1267,'','2','',''),(1268,'','2','',''),(1269,'','2','',''),(1270,'','2','',''),(1271,'','2','',''),(1272,'','2','',''),(1273,'','2','',''),(1274,'','2','',''),(1275,'','5','',''),(1276,'','5','',''),(1277,'','5','',''),(1278,'','5','',''),(1279,'','5','',''),(1280,'','5','',''),(1281,'','5','',''),(1282,'','2','',''),(1283,'','2','',''),(1284,'','2','',''),(1285,'','5','',''),(1286,'','5','',''),(1287,'','5','',''),(1288,'','5','',''),(1289,'','5','',''),(1290,'','5','',''),(1291,'','2','',''),(1292,'','2','',''),(1293,'','2','',''),(1294,'','2','',''),(1295,'','2','',''),(1296,'','2','',''),(1297,'','2','',''),(1298,'','2','',''),(1299,'','2','',''),(1300,'','2','',''),(1301,'','2','',''),(1302,'','2','',''),(1303,'','2','',''),(1304,'','2','',''),(1305,'','2','',''),(1306,'','2','',''),(1307,'','2','',''),(1308,'','2','',''),(1309,'','','',''),(1310,'','5','',''),(1311,'','5','',''),(1312,'','5','',''),(1313,'','5','',''),(1314,'','5','',''),(1315,'','5','',''),(1316,'','2','',''),(1317,'','2','',''),(1318,'','5','',''),(1319,'','5','',''),(1320,'','5','',''),(1321,'','5','',''),(1322,'','5','',''),(1323,'','5','',''),(1324,'','2','',''),(1325,'','2','',''),(1326,'','2','',''),(1327,'','2','',''),(1328,'','2','',''),(1329,'','2','',''),(1330,'','2','',''),(1331,'','2','',''),(1332,'','2','',''),(1333,'','5','',''),(1334,'','5','',''),(1335,'','5','',''),(1336,'','5','',''),(1337,'','5','',''),(1338,'','5','',''),(1339,'','2','',''),(1340,'','2','',''),(1341,'','2','',''),(1342,'','2','',''),(1343,'','2','',''),(1344,'','2','',''),(1345,'','5','',''),(1346,'','5','',''),(1347,'','5','',''),(1348,'','5','',''),(1349,'','5','',''),(1350,'','5','',''),(1351,'','2','',''),(1352,'','2','',''),(1353,'','2','',''),(1354,'','2','',''),(1355,'','2','',''),(1356,'','2','',''),(1357,'','2','',''),(1358,'','5','',''),(1359,'','2','',''),(1360,'','2','',''),(1361,'','5','',''),(1362,'','5','',''),(1363,'','5','',''),(1364,'','5','',''),(1365,'','5','',''),(1366,'','5','',''),(1367,'','2','',''),(1368,'','2','',''),(1369,'','2','',''),(1370,'','2','',''),(1371,'','2','',''),(1372,'','2','',''),(1373,'','2','',''),(1374,'','5','',''),(1375,'','2','',''),(1376,'','2','',''),(1377,'','2','',''),(1378,'','5','',''),(1379,'','5','',''),(1380,'','5','',''),(1381,'','5','',''),(1382,'','5','',''),(1383,'','5','',''),(1384,'','2','',''),(1385,'','2','',''),(1386,'','5','',''),(1387,'','5','',''),(1388,'','5','',''),(1389,'','5','',''),(1390,'','5','',''),(1391,'','5','',''),(1392,'','5','',''),(1393,'','5','',''),(1394,'','2','',''),(1395,'','5','',''),(1396,'','5','',''),(1397,'','5','',''),(1398,'','5','',''),(1399,'','5','',''),(1400,'','5','',''),(1401,'','2','',''),(1402,'','2','',''),(1403,'','5','',''),(1404,'','5','',''),(1405,'','5','',''),(1406,'','5','',''),(1407,'','5','',''),(1408,'','5','',''),(1409,'','2','',''),(1410,'','5','',''),(1411,'','','',''),(1412,'','','',''),(1413,'','','',''),(1414,'','','',''),(1415,'','','',''),(1416,'','','',''),(1417,'','2','',''),(1418,'','2','',''),(1419,'','2','',''),(1420,'','2','',''),(1421,'','5','',''),(1422,'','5','',''),(1423,'','5','',''),(1424,'','5','',''),(1425,'','5','',''),(1426,'','5','',''),(1427,'','2','',''),(1428,'','2','',''),(1429,'','2','',''),(1430,'','2','',''),(1431,'','2','',''),(1432,'','5','',''),(1433,'','5','',''),(1434,'','5','',''),(1435,'','5','',''),(1436,'','5','',''),(1437,'','5','',''),(1438,'','2','',''),(1439,'','2','',''),(1440,'','2','',''),(1441,'','2','',''),(1442,'','2','',''),(1443,'','2','',''),(1444,'','2','',''),(1445,'','2','',''),(1446,'','2','',''),(1447,'','','',''),(1448,'','5','',''),(1449,'','5','',''),(1450,'','5','',''),(1451,'','5','',''),(1452,'','5','',''),(1453,'','5','',''),(1454,'','2','',''),(1455,'','','',''),(1456,'','5','',''),(1457,'','2','',''),(1458,'','2','',''),(1459,'','2','',''),(1460,'','2','',''),(1461,'','2','',''),(1462,'','2','',''),(1463,'','5','',''),(1464,'','5','',''),(1465,'','5','',''),(1466,'','5','',''),(1467,'','5','',''),(1468,'','5','',''),(1469,'','5','',''),(1470,'','2','',''),(1471,'','2','',''),(1472,'','2','',''),(1473,'','2','',''),(1474,'','5','',''),(1475,'','','',''),(1476,'','5','',''),(1477,'','5','',''),(1478,'','5','',''),(1479,'','5','',''),(1480,'','5','',''),(1481,'','5','',''),(1482,'','','',''),(1483,'','2','',''),(1484,'','2','',''),(1485,'','5','',''),(1486,'','5','',''),(1487,'','5','',''),(1488,'','5','',''),(1489,'','5','',''),(1490,'','5','',''),(1491,'','5','',''),(1492,'','','',''),(1493,'','5','',''),(1494,'','5','',''),(1495,'','5','',''),(1496,'','5','',''),(1497,'','5','',''),(1498,'','','',''),(1499,'','','',''),(1500,'','','',''),(1501,'','','',''),(1502,'','','',''),(1503,'','','',''),(1504,'','','',''),(1505,'','','',''),(1506,'','','',''),(1507,'','5','',''),(1508,'','5','',''),(1509,'','5','',''),(1510,'','5','',''),(1511,'','5','',''),(1512,'','5','',''),(1513,'','2','',''),(1514,'','2','',''),(1515,'','2','',''),(1516,'','2','',''),(1517,'','5','',''),(1518,'','2','',''),(1519,'','2','',''),(1520,'','2','',''),(1521,'','2','',''),(1522,'','2','',''),(1523,'','2','',''),(1524,'','5','',''),(1525,'','5','',''),(1526,'','5','',''),(1527,'','5','',''),(1528,'','5','',''),(1529,'','5','',''),(1530,'','5','',''),(1531,'','2','',''),(1532,'','2','',''),(1533,'','2','',''),(1534,'','5','',''),(1535,'','5','',''),(1536,'','5','',''),(1537,'','5','',''),(1538,'','5','',''),(1539,'','5','',''),(1540,'','5','',''),(1541,'','','',''),(1542,'','','',''),(1543,'','','',''),(1544,'','','',''),(1545,'','1','',''),(1546,'','1','',''),(1547,'','1','',''),(1548,'','1','',''),(1549,'','1','',''),(1550,'','1','',''),(1551,'','1','',''),(1552,'','1','',''),(1553,'','1','',''),(1554,'','1','',''),(1555,'','1','',''),(1556,'','1','',''),(1557,'','1','',''),(1558,'','1','',''),(1559,'','','',''),(1560,'','','',''),(1561,'','','',''),(1562,'','','',''),(1563,'','','',''),(1564,'','','',''),(1565,'','','',''),(1566,'','','',''),(1567,'','','',''),(1568,'','','',''),(1569,'','','',''),(1570,'','','',''),(1571,'','5','',''),(1572,'','5','',''),(1573,'','5','',''),(1574,'','5','',''),(1575,'','5','',''),(1576,'','5','',''),(1577,'','','',''),(1578,'','','',''),(1579,'','','',''),(1580,'','5','',''),(1581,'','5','',''),(1582,'','5','',''),(1583,'','5','',''),(1584,'','5','',''),(1585,'','5','',''),(1586,'','','',''),(1587,'','','',''),(1588,'','1','',''),(1589,'','1','',''),(1590,'','1','',''),(1591,'','1','',''),(1592,'','1','',''),(1593,'','1','',''),(1594,'','2','',''),(1595,'','1','',''),(1596,'','1','',''),(1597,'','1','',''),(1598,'','1','',''),(1599,'','1','',''),(1600,'','1','',''),(1601,'','1','',''),(1602,'','2','',''),(1603,'','1','',''),(1604,'','1','',''),(1605,'','1','',''),(1606,'','2','',''),(1607,'','1','',''),(1608,'','1','',''),(1609,'','','',''),(1610,'','','',''),(1611,'','','',''),(1612,'','','',''),(1613,'','','',''),(1614,'','','',''),(1615,'','','',''),(1616,'','2','',''),(1617,'','','',''),(1618,'','','',''),(1619,'','2','',''),(1620,'','2','',''),(1621,'','2','',''),(1622,'','2','',''),(1623,'','2','',''),(1624,'','2','',''),(1625,'','5','',''),(1626,'','5','',''),(1627,'','5','',''),(1628,'','5','',''),(1629,'','5','',''),(1630,'','5','',''),(1631,'','','',''),(1632,'','','',''),(1633,'','','',''),(1634,'','5','',''),(1635,'','5','',''),(1636,'','5','',''),(1637,'','5','',''),(1638,'','5','',''),(1639,'','5','',''),(1640,'','1','',''),(1641,'','1','',''),(1642,'','1','',''),(1643,'','1','',''),(1644,'','1','',''),(1645,'','1','',''),(1646,'','1','',''),(1647,'','','',''),(1648,'','4','',''),(1649,'','4','',''),(1650,'','4','',''),(1651,'','4','',''),(1652,'','4','',''),(1653,'','4','',''),(1654,'','2','',''),(1655,'','2','',''),(1656,'','4','',''),(1657,'','2','',''),(1658,'','2','',''),(1659,'','4','',''),(1660,'','4','',''),(1661,'','2','',''),(1662,'','4','',''),(1663,'','2','',''),(1664,'','1','',''),(1665,'','1','',''),(1666,'','1','',''),(1667,'','1','',''),(1668,'','1','',''),(1669,'','1','',''),(1670,'','2','',''),(1671,'','2','',''),(1672,'','2','',''),(1673,'','2','',''),(1674,'','1','',''),(1675,'','1','',''),(1676,'','1','',''),(1677,'','1','',''),(1678,'','1','',''),(1679,'','1','',''),(1680,'','1','',''),(1681,'','2','',''),(1682,'','1','',''),(1683,'','4','',''),(1684,'','2','',''),(1685,'','2','',''),(1686,'','1','',''),(1687,'','1','',''),(1688,'','1','',''),(1689,'','1','',''),(1690,'','1','',''),(1691,'','1','',''),(1692,'','1','',''),(1693,'','1','',''),(1694,'','1','',''),(1695,'','1','',''),(1696,'','1','',''),(1697,'','1','',''),(1698,'','1','',''),(1699,'','1','',''),(1700,'','1','',''),(1701,'','1','',''),(1702,'','1','',''),(1703,'','1','',''),(1704,'','1','',''),(1705,'','1','',''),(1706,'','2','',''),(1707,'','2','',''),(1708,'','2','',''),(1709,'','1','',''),(1710,'','1','',''),(1711,'','2','',''),(1712,'','4','',''),(1713,'','4','',''),(1714,'','4','',''),(1715,'','4','',''),(1716,'','4','',''),(1717,'','4','',''),(1718,'','2','',''),(1719,'','','',''),(1720,'','','',''),(1721,'','','',''),(1722,'','4','',''),(1723,'','4','',''),(1724,'','4','',''),(1725,'','4','',''),(1726,'','4','',''),(1727,'','4','',''),(1728,'','2','',''),(1729,'','','',''),(1730,'','','',''),(1731,'','','',''),(1732,'','4','',''),(1733,'','4','',''),(1734,'','4','',''),(1735,'','4','',''),(1736,'','4','',''),(1737,'','4','',''),(1738,'','2','',''),(1739,'','2','',''),(1740,'','2','',''),(1741,'','2','',''),(1742,'','','',''),(1743,'','','',''),(1744,'','','',''),(1745,'','','',''),(1746,'','','',''),(1747,'','','',''),(1748,'','2','',''),(1749,'','','',''),(1750,'','','',''),(1751,'','','',''),(1752,'','','',''),(1753,'','','',''),(1754,'','','',''),(1755,'','','',''),(1756,'','2','',''),(1757,'','1','',''),(1758,'','2','',''),(1759,'','2','',''),(1760,'','4','',''),(1761,'','4','',''),(1762,'','4','',''),(1763,'','4','',''),(1764,'','4','',''),(1765,'','4','',''),(1766,'','4','',''),(1767,'','4','',''),(1768,'','1','',''),(1769,'','1','',''),(1770,'','1','',''),(1771,'','1','',''),(1772,'','1','',''),(1773,'','1','',''),(1774,'','1','',''),(1775,'','1','',''),(1776,'','1','',''),(1777,'','','',''),(1778,'','','',''),(1779,'','','',''),(1780,'','1','',''),(1781,'','1','',''),(1782,'','1','',''),(1783,'','1','',''),(1784,'','1','',''),(1785,'','4','',''),(1786,'','4','',''),(1787,'','2','',''),(1788,'','1','',''),(1789,'','2','',''),(1790,'','2','',''),(1791,'','4','',''),(1792,'','4','',''),(1793,'','4','',''),(1794,'','4','',''),(1795,'','4','',''),(1796,'','4','',''),(1797,'','4','',''),(1798,'','4','',''),(1799,'','4','',''),(1800,'','4','',''),(1801,'','4','',''),(1802,'','4','',''),(1803,'','4','',''),(1804,'','4','',''),(1805,'','4','',''),(1806,'','1','',''),(1807,'','1','',''),(1808,'','1','',''),(1809,'','1','',''),(1810,'','1','',''),(1811,'','','',''),(1812,'','','',''),(1813,'','','',''),(1814,'','','',''),(1815,'','','',''),(1816,'','1','',''),(1817,'','1','',''),(1818,'','1','',''),(1819,'','1','',''),(1820,'','1','',''),(1821,'','4','',''),(1822,'','4','',''),(1823,'','4','',''),(1824,'','4','',''),(1825,'','4','',''),(1826,'','4','',''),(1827,'','2','',''),(1828,'','','',''),(1829,'','','',''),(1830,'','','',''),(1831,'','','',''),(1832,'','','',''),(1833,'','','',''),(1834,'','','',''),(1835,'','','',''),(1836,'','','',''),(1837,'','1','',''),(1838,'','1','',''),(1839,'','1','',''),(1840,'','','',''),(1841,'','','',''),(1842,'','1','',''),(1843,'','','',''),(1844,'','','',''),(1845,'','','',''),(1846,'','','',''),(1847,'','','',''),(1848,'','','',''),(1849,'','2','',''),(1850,'','2','',''),(1851,'','','',''),(1852,'','','',''),(1853,'','2','',''),(1854,'','2','',''),(1855,'','2','',''),(1856,'','','',''),(1857,'','4','',''),(1858,'','4','',''),(1859,'','4','',''),(1860,'','','',''),(1861,'','4','',''),(1862,'','4','',''),(1863,'','4','',''),(1864,'','','',''),(1865,'','','',''),(1866,'','1','',''),(1867,'','1','',''),(1868,'','1','',''),(1869,'','4','',''),(1870,'','4','',''),(1871,'','4','',''),(1872,'','4','',''),(1873,'','4','',''),(1874,'','4','',''),(1875,'','1','',''),(1876,'','1','',''),(1877,'','1','',''),(1878,'','1','',''),(1879,'','4','',''),(1880,'','4','',''),(1881,'','4','',''),(1882,'','4','',''),(1883,'','4','',''),(1884,'','4','',''),(1885,'','1','',''),(1886,'','4','',''),(1887,'','4','',''),(1888,'','4','',''),(1889,'','4','',''),(1890,'','4','',''),(1891,'','4','',''),(1892,'','1','',''),(1893,'','1','',''),(1894,'','1','',''),(1895,'','1','',''),(1896,'','1','',''),(1897,'','1','',''),(1898,'','1','',''),(1899,'','1','',''),(1900,'','4','',''),(1901,'','4','',''),(1902,'','1','',''),(1903,'','4','',''),(1904,'','4','',''),(1905,'','4','',''),(1906,'','4','',''),(1907,'','4','',''),(1908,'','4','',''),(1909,'','4','',''),(1910,'','4','',''),(1911,'','4','',''),(1912,'','4','',''),(1913,'','4','',''),(1914,'','4','',''),(1915,'','4','',''),(1916,'','4','',''),(1917,'','2','',''),(1918,'','4','',''),(1919,'','','',''),(1920,'','2','',''),(1921,'','2','',''),(1922,'','2','',''),(1923,'','2','',''),(1924,'','2','',''),(1925,'','2','',''),(1926,'','2','',''),(1927,'','1','',''),(1928,'','1','',''),(1929,'','1','',''),(1930,'','2','',''),(1931,'','2','',''),(1932,'','1','',''),(1933,'','1','',''),(1934,'','2','',''),(1935,'','2','',''),(1936,'','1','',''),(1937,'','2','',''),(1938,'','2','',''),(1939,'','2','',''),(1940,'','2','',''),(1941,'','2','',''),(1942,'','2','',''),(1943,'','2','',''),(1944,'','2','',''),(1945,'','2','',''),(1946,'','2','',''),(1947,'','2','',''),(1948,'','2','',''),(1949,'','2','',''),(1950,'','2','',''),(1951,'','2','',''),(1952,'','','',''),(1953,'','','',''),(1954,'','','',''),(1955,'','2','',''),(1956,'','2','',''),(1957,'','1','',''),(1958,'','1','',''),(1959,'','1','',''),(1960,'','2','',''),(1961,'','2','',''),(1962,'','2','',''),(1963,'','2','',''),(1964,'','2','',''),(1965,'','2','',''),(1966,'','2','',''),(1967,'','2','',''),(1968,'','2','',''),(1969,'','2','',''),(1970,'','2','',''),(1971,'','1','',''),(1972,'','1','',''),(1973,'','1','',''),(1974,'','1','',''),(1975,'','1','',''),(1976,'','1','',''),(1977,'','2','',''),(1978,'','2','',''),(1979,'','2','',''),(1980,'','2','',''),(1981,'','2','',''),(1982,'','2','',''),(1983,'','2','',''),(1984,'','2','',''),(1985,'','2','',''),(1986,'','2','',''),(1987,'','2','',''),(1988,'','2','',''),(1989,'','2','',''),(1990,'','2','',''),(1991,'','2','',''),(1992,'','2','',''),(1993,'','2','',''),(1994,'','2','',''),(1995,'','2','',''),(1996,'','2','',''),(1997,'','2','',''),(1998,'','2','',''),(1999,'','1','',''),(2000,'','2','',''),(2001,'','2','',''),(2002,'','4','',''),(2003,'','4','',''),(2004,'','4','',''),(2005,'','4','',''),(2006,'','4','',''),(2007,'','4','',''),(2008,'','2','',''),(2009,'','4','',''),(2010,'','4','',''),(2011,'','4','',''),(2012,'','4','',''),(2013,'','1','',''),(2014,'','1','',''),(2015,'','1','',''),(2016,'','2','',''),(2017,'','1','',''),(2018,'','1','',''),(2019,'','2','',''),(2020,'','4','',''),(2021,'','1','',''),(2022,'','1','',''),(2023,'','1','',''),(2024,'','1','',''),(2025,'','4','',''),(2026,'','1','',''),(2027,'','','',''),(2028,'','4','',''),(2029,'','4','',''),(2030,'','','',''),(2031,'','1','',''),(2032,'','4','',''),(2033,'','4','',''),(2034,'','4','',''),(2035,'','4','',''),(2036,'','4','',''),(2037,'','1','',''),(2038,'','4','',''),(2039,'','1','',''),(2040,'','','',''),(2041,'','1','',''),(2042,'','1','',''),(2043,'','1','',''),(2044,'','1','',''),(2045,'','1','',''),(2046,'','1','',''),(2047,'','1','',''),(2048,'','1','',''),(2049,'','1','',''),(2050,'','1','',''),(2051,'','1','',''),(2052,'','1','',''),(2053,'','1','',''),(2054,'','1','',''),(2055,'','1','',''),(2056,'','1','',''),(2057,'','2','',''),(2058,'','2','',''),(2059,'','2','',''),(2060,'','1','',''),(2061,'','1','',''),(2062,'','2','',''),(2063,'','2','',''),(2064,'','2','',''),(2065,'','2','',''),(2066,'','2','',''),(2067,'','2','',''),(2068,'','2','',''),(2069,'','2','',''),(2070,'','2','',''),(2071,'','2','',''),(2072,'','1','',''),(2073,'','2','',''),(2074,'','1','',''),(2075,'','1','',''),(2076,'','1','',''),(2077,'','2','',''),(2078,'','1','',''),(2079,'','1','',''),(2080,'','1','',''),(2081,'','1','',''),(2082,'','1','',''),(2083,'','1','',''),(2084,'','','',''),(2085,'','','',''),(2086,'','4','',''),(2087,'','','',''),(2088,'','4','',''),(2089,'','4','',''),(2090,'','','',''),(2091,'','','',''),(2092,'','4','',''),(2093,'','4','',''),(2094,'','','',''),(2095,'','4','',''),(2096,'','2','',''),(2097,'','4','',''),(2098,'','4','',''),(2099,'','4','',''),(2100,'','4','',''),(2101,'','4','',''),(2102,'','','',''),(2103,'','1','',''),(2104,'','','',''),(2105,'','','',''),(2106,'','','',''),(2107,'','1','',''),(2108,'','1','',''),(2109,'','1','',''),(2110,'','1','',''),(2111,'','1','',''),(2112,'','1','',''),(2113,'','1','',''),(2114,'','1','',''),(2115,'','2','',''),(2116,'','1','',''),(2117,'','1','',''),(2118,'','1','',''),(2119,'','1','',''),(2120,'','1','',''),(2121,'','1','',''),(2122,'','1','',''),(2123,'','2','',''),(2124,'','','',''),(2125,'','','',''),(2126,'','','',''),(2127,'','','',''),(2128,'','','',''),(2129,'','','',''),(2130,'','','',''),(2131,'','2','',''),(2132,'','','',''),(2133,'','','',''),(2134,'','','',''),(2135,'','1','',''),(2136,'','1','',''),(2137,'','1','',''),(2138,'','1','',''),(2139,'','1','',''),(2140,'','1','',''),(2141,'','2','',''),(2142,'','','',''),(2143,'','','',''),(2144,'','','',''),(2145,'','','',''),(2146,'','','',''),(2147,'','','',''),(2148,'','','',''),(2149,'','','',''),(2150,'','','',''),(2151,'','','',''),(2152,'','','',''),(2153,'','2','',''),(2154,'','4','',''),(2155,'','4','',''),(2156,'','4','',''),(2157,'','2','',''),(2158,'','','',''),(2159,'','','',''),(2160,'','','',''),(2161,'','2','',''),(2162,'','1','',''),(2163,'','1','',''),(2164,'','1','',''),(2165,'','1','',''),(2166,'','1','',''),(2167,'','1','',''),(2168,'','2','',''),(2169,'','','',''),(2170,'','','',''),(2171,'','','',''),(2172,'','1','',''),(2173,'','1','',''),(2174,'','1','',''),(2175,'','1','',''),(2176,'','1','',''),(2177,'','1','',''),(2178,'','2','',''),(2179,'','2','',''),(2180,'','','',''),(2181,'','','',''),(2182,'','','',''),(2183,'','1','',''),(2184,'','1','',''),(2185,'','1','',''),(2186,'','1','',''),(2187,'','1','',''),(2188,'','1','',''),(2189,'','1','',''),(2190,'','2','',''),(2191,'','4','',''),(2192,'','4','',''),(2193,'','4','',''),(2194,'','4','',''),(2195,'','4','',''),(2196,'','4','',''),(2197,'','2','',''),(2198,'','2','',''),(2199,'','2','',''),(2200,'','4','',''),(2201,'','4','',''),(2202,'','4','',''),(2203,'','4','',''),(2204,'','2','',''),(2205,'','2','',''),(2206,'','2','',''),(2207,'','4','',''),(2208,'','2','',''),(2209,'','4','',''),(2210,'','4','',''),(2211,'','4','',''),(2212,'','4','',''),(2213,'','4','',''),(2214,'','4','',''),(2215,'','4','',''),(2216,'','4','',''),(2217,'','4','',''),(2218,'','4','',''),(2219,'','4','',''),(2220,'','4','',''),(2221,'','4','',''),(2222,'','4','',''),(2223,'','4','',''),(2224,'','4','',''),(2225,'','4','',''),(2226,'','4','',''),(2227,'','4','',''),(2228,'','4','',''),(2229,'','4','',''),(2230,'','4','',''),(2231,'','4','',''),(2232,'','2','',''),(2233,'','4','',''),(2234,'','10','',''),(2235,'','2','',''),(2236,'','2','',''),(2237,'','2','',''),(2238,'','2','',''),(2239,'','2','',''),(2240,'','1','',''),(2241,'','1','',''),(2242,'','1','',''),(2243,'','1','',''),(2244,'','1','',''),(2245,'','1','',''),(2246,'','1','',''),(2247,'','10','',''),(2248,'','1','',''),(2249,'','1','',''),(2250,'','1','',''),(2251,'','1','',''),(2252,'','10','',''),(2253,'','10','',''),(2254,'','10','',''),(2255,'','1','',''),(2256,'','1','',''),(2257,'','1','',''),(2258,'','4','',''),(2259,'','4','',''),(2260,'','4','',''),(2261,'','4','',''),(2262,'','4','',''),(2263,'','4','',''),(2264,'','4','',''),(2265,'','4','',''),(2266,'','4','',''),(2267,'','4','',''),(2268,'','4','',''),(2269,'','4','',''),(2270,'','4','',''),(2271,'','1','',''),(2272,'','4','',''),(2273,'','2','',''),(2274,'','2','',''),(2275,'','1','',''),(2276,'','2','',''),(2277,'','1','',''),(2278,'','2','',''),(2279,'','2','',''),(2280,'','1','',''),(2281,'','2','',''),(2282,'','2','',''),(2283,'','2','',''),(2284,'','2','',''),(2285,'','1','',''),(2286,'','2','',''),(2287,'','2','',''),(2288,'','4','',''),(2289,'','1','',''),(2290,'','4','',''),(2291,'','4','',''),(2292,'','4','',''),(2293,'','2','',''),(2294,'','4','',''),(2295,'','4','',''),(2296,'','4','',''),(2297,'','1','',''),(2298,'','2','',''),(2299,'','4','',''),(2300,'','4','',''),(2301,'','4','',''),(2302,'','4','',''),(2303,'','4','',''),(2304,'','1','',''),(2305,'','1','',''),(2306,'','1','',''),(2307,'','4','',''),(2308,'','4','',''),(2309,'','1','',''),(2310,'','1','',''),(2311,'','1','',''),(2312,'','1','',''),(2313,'','4','',''),(2314,'','1','',''),(2315,'','1','',''),(2316,'','4','',''),(2317,'','4','',''),(2318,'','4','',''),(2319,'','4','',''),(2320,'','4','',''),(2321,'','2','',''),(2322,'','4','',''),(2323,'','4','',''),(2324,'','4','',''),(2325,'','4','',''),(2326,'','4','',''),(2327,'','1','',''),(2328,'','4','',''),(2329,'','1','',''),(2330,'','2','',''),(2331,'','4','',''),(2332,'','4','',''),(2333,'','4','',''),(2334,'','4','',''),(2335,'','1','',''),(2336,'','2','',''),(2337,'','4','',''),(2338,'','4','',''),(2339,'','4','',''),(2340,'','4','',''),(2341,'','1','',''),(2342,'','1','',''),(2343,'','1','',''),(2344,'','1','',''),(2345,'','1','',''),(2346,'','1','',''),(2347,'','1','',''),(2348,'','1','',''),(2349,'','1','',''),(2350,'','1','',''),(2351,'','4','',''),(2352,'','4','',''),(2353,'','4','',''),(2354,'','4','',''),(2355,'','4','',''),(2356,'','4','',''),(2357,'','4','',''),(2358,'','4','',''),(2359,'','4','',''),(2360,'','4','',''),(2361,'','4','',''),(2362,'','4','',''),(2363,'','4','',''),(2364,'','4','',''),(2365,'','4','',''),(2366,'','4','',''),(2367,'','4','',''),(2368,'','4','',''),(2369,'','4','',''),(2370,'','4','',''),(2371,'','4','',''),(2372,'','4','',''),(2373,'','4','',''),(2374,'','4','',''),(2375,'','4','',''),(2376,'','4','',''),(2377,'','4','',''),(2378,'','4','',''),(2379,'','4','',''),(2380,'','4','',''),(2381,'','4','',''),(2382,'','4','',''),(2383,'','4','',''),(2384,'','4','',''),(2385,'','4','',''),(2386,'','4','',''),(2387,'','4','',''),(2388,'','4','',''),(2389,'','4','',''),(2390,'','4','',''),(2391,'','4','',''),(2392,'','4','',''),(2393,'','4','',''),(2394,'','4','',''),(2395,'','4','',''),(2396,'','4','',''),(2397,'','4','',''),(2398,'','4','',''),(2399,'','4','',''),(2400,'','4','',''),(2401,'','1','',''),(2402,'','1','',''),(2403,'','2','',''),(2404,'','2','',''),(2405,'','2','',''),(2406,'','2','',''),(2407,'','2','',''),(2408,'','2','',''),(2409,'','2','',''),(2410,'','2','',''),(2411,'','2','',''),(2412,'','2','',''),(2413,'','2','',''),(2414,'','2','',''),(2415,'','2','',''),(2416,'','2','',''),(2417,'','2','',''),(2418,'','2','',''),(2419,'','2','',''),(2420,'','2','',''),(2421,'','2','',''),(2422,'','2','',''),(2423,'','2','',''),(2424,'','2','',''),(2425,'','2','',''),(2426,'','2','',''),(2427,'','2','',''),(2428,'','2','',''),(2429,'','2','',''),(2430,'','2','',''),(2431,'','2','',''),(2432,'','2','',''),(2433,'','2','',''),(2434,'','2','',''),(2435,'','2','',''),(2436,'','','',''),(2437,'','','',''),(2438,'','','',''),(2439,'','','',''),(2440,'','','',''),(2441,'','','',''),(2442,'','','',''),(2443,'','','',''),(2444,'','ranjithakr123@gmail.com','',''),(2445,'','ranjithakr123@gmail.com','',''),(2446,'','ranjithakr123@gmail.com','',''),(2447,'','1','',''),(2448,'','1','',''),(2449,'','1','',''),(2450,'','2','',''),(2451,'','3','',''),(2452,'','1','',''),(2453,'','1','',''),(2454,'','1','',''),(2455,'','1','',''),(2456,'','1','',''),(2457,'','1','',''),(2458,'','1','',''),(2459,'','1','',''),(2460,'','1','',''),(2461,'','1','',''),(2462,'','1','',''),(2463,'','1','',''),(2464,'','1','',''),(2465,'','1','',''),(2466,'','2','',''),(2467,'','1','',''),(2468,'','2','',''),(2469,'','2','',''),(2470,'','2','',''),(2471,'','','',''),(2472,'','','',''),(2473,'','','',''),(2474,'','','',''),(2475,'','','',''),(2476,'','','',''),(2477,'','','',''),(2478,'','','',''),(2479,'','','',''),(2480,'','','',''),(2481,'','','',''),(2482,'','','',''),(2483,'','','',''),(2484,'','','',''),(2485,'','','',''),(2486,'','','',''),(2487,'','','',''),(2488,'','2','',''),(2489,'','1','',''),(2490,'','1','',''),(2491,'','2','',''),(2492,'','3','',''),(2493,'','4','',''),(2494,'','5','',''),(2495,'','6','',''),(2496,'','7','',''),(2497,'','8','',''),(2498,'','7','',''),(2499,'','10','',''),(2500,'','10','',''),(2501,'','1','',''),(2502,'','10','',''),(2503,'','10','',''),(2504,'','10','',''),(2505,'','10','',''),(2506,'','10','',''),(2507,'','10','',''),(2508,'','1','',''),(2509,'','1','',''),(2510,'','10','',''),(2511,'','10','',''),(2512,'','10','',''),(2513,'','1','',''),(2514,'','1','',''),(2515,'','1','',''),(2516,'','10','',''),(2517,'','10','',''),(2518,'','10','',''),(2519,'','1','',''),(2520,'','1','',''),(2521,'','1','',''),(2522,'','1','',''),(2523,'','1','',''),(2524,'','1','',''),(2525,'','1','',''),(2526,'','1','',''),(2527,'','1','',''),(2528,'','1','',''),(2529,'','1','',''),(2530,'','1','',''),(2531,'','2','',''),(2532,'','3','',''),(2533,'','10','',''),(2534,'','10','',''),(2535,'','10','',''),(2536,'','1','',''),(2537,'','1','',''),(2538,'','1','',''),(2539,'','1','',''),(2540,'','7','',''),(2541,'','1','',''),(2542,'','1','',''),(2543,'','1','',''),(2544,'','','',''),(2545,'','','',''),(2546,'','','',''),(2547,'','','',''),(2548,'','','',''),(2549,'','','',''),(2550,'','','',''),(2551,'','','',''),(2552,'','','',''),(2553,'','','',''),(2554,'','','',''),(2555,'','','',''),(2556,'','','',''),(2557,'','','',''),(2558,'','','',''),(2559,'','','',''),(2560,'','','',''),(2561,'','2','',''),(2562,'','2','',''),(2563,'','2','',''),(2564,'','2','',''),(2565,'','2','',''),(2566,'','1','',''),(2567,'','2','',''),(2568,'','2','',''),(2569,'','2','',''),(2570,'','2','',''),(2571,'','2','',''),(2572,'','2','',''),(2573,'','2','',''),(2574,'','2','',''),(2575,'','2','',''),(2576,'','2','',''),(2577,'','2','',''),(2578,'','2','',''),(2579,'','2','',''),(2580,'','2','',''),(2581,'','2','',''),(2582,'','','',''),(2583,'','','',''),(2584,'','1','',''),(2585,'','1','',''),(2586,'','1','',''),(2587,'','1','',''),(2588,'','','',''),(2589,'','','',''),(2590,'','2','',''),(2591,'','2','',''),(2592,'','2','',''),(2593,'','2','',''),(2594,'','2','',''),(2595,'','2','',''),(2596,'','','',''),(2597,'','','',''),(2598,'','','',''),(2599,'','','',''),(2600,'','','',''),(2601,'','','',''),(2602,'','2','',''),(2603,'','','',''),(2604,'','','',''),(2605,'','','',''),(2606,'','','',''),(2607,'','','',''),(2608,'','','',''),(2609,'','','',''),(2610,'','','',''),(2611,'','','',''),(2612,'','2','',''),(2613,'','','',''),(2614,'','','',''),(2615,'','','',''),(2616,'','','',''),(2617,'','','',''),(2618,'','','',''),(2619,'','','',''),(2620,'','','',''),(2621,'','','',''),(2622,'','','',''),(2623,'','1','',''),(2624,'','1','',''),(2625,'','1','',''),(2626,'','1','',''),(2627,'','1','',''),(2628,'','1','',''),(2629,'','1','',''),(2630,'','1','',''),(2631,'','1','',''),(2632,'','1','',''),(2633,'','1','',''),(2634,'','1','',''),(2635,'','1','',''),(2636,'','1','',''),(2637,'','1','',''),(2638,'','1','',''),(2639,'','1','',''),(2640,'','1','',''),(2641,'','1','',''),(2642,'','1','',''),(2643,'','1','',''),(2644,'','1','',''),(2645,'','1','',''),(2646,'','1','',''),(2647,'','1','',''),(2648,'','1','',''),(2649,'','1','',''),(2650,'','1','',''),(2651,'','1','',''),(2652,'','1','',''),(2653,'','1','',''),(2654,'','1','',''),(2655,'','1','',''),(2656,'','1','',''),(2657,'','1','',''),(2658,'','1','',''),(2659,'','1','',''),(2660,'','1','',''),(2661,'','1','',''),(2662,'','1','',''),(2663,'','1','',''),(2664,'','1','',''),(2665,'','1','',''),(2666,'','1','',''),(2667,'','1','',''),(2668,'','1','',''),(2669,'','1','',''),(2670,'','1','',''),(2671,'','1','',''),(2672,'','1','',''),(2673,'','1','',''),(2674,'','1','',''),(2675,'','1','',''),(2676,'','1','',''),(2677,'','1','',''),(2678,'','1','',''),(2679,'','1','',''),(2680,'','1','',''),(2681,'','1','',''),(2682,'','1','',''),(2683,'','1','',''),(2684,'','1','',''),(2685,'','1','',''),(2686,'','1','',''),(2687,'','1','',''),(2688,'','1','',''),(2689,'','1','',''),(2690,'','1','',''),(2691,'','1','',''),(2692,'','1','',''),(2693,'','1','',''),(2694,'','1','',''),(2695,'','1','',''),(2696,'','1','',''),(2697,'','','',''),(2698,'','','',''),(2699,'','2','',''),(2700,'','2','',''),(2701,'','2','',''),(2702,'','1','',''),(2703,'','1','',''),(2704,'','1','',''),(2705,'','1','',''),(2706,'','10','',''),(2707,'','10','',''),(2708,'','10','',''),(2709,'','10','',''),(2710,'','10','',''),(2711,'','10','',''),(2712,'','10','',''),(2713,'','10','',''),(2714,'','10','',''),(2715,'','10','',''),(2716,'','10','',''),(2717,'','10','',''),(2718,'','10','',''),(2719,'','10','',''),(2720,'','10','',''),(2721,'','10','',''),(2722,'','10','',''),(2723,'','10','',''),(2724,'','10','',''),(2725,'','10','',''),(2726,'','10','',''),(2727,'','10','',''),(2728,'','10','',''),(2729,'','1','',''),(2730,'','1','',''),(2731,'','10','',''),(2732,'','10','',''),(2733,'','10','',''),(2734,'','10','',''),(2735,'','1','',''),(2736,'','1','',''),(2737,'','1','',''),(2738,'','1','',''),(2739,'','1','',''),(2740,'','1','',''),(2741,'','1','',''),(2742,'','1','',''),(2743,'','1','',''),(2744,'','1','',''),(2745,'','1','',''),(2746,'','1','',''),(2747,'','1','',''),(2748,'','1','',''),(2749,'','1','',''),(2750,'','1','',''),(2751,'','1','',''),(2752,'','1','',''),(2753,'','1','',''),(2754,'','1','',''),(2755,'','1','',''),(2756,'','1','',''),(2757,'','1','',''),(2758,'','1','',''),(2759,'','1','',''),(2760,'','1','',''),(2761,'','1','',''),(2762,'','1','',''),(2763,'','1','',''),(2764,'','1','',''),(2765,'','1','',''),(2766,'','1','',''),(2767,'','1','',''),(2768,'','1','',''),(2769,'','1','',''),(2770,'','1','',''),(2771,'','1','',''),(2772,'','1','',''),(2773,'','1','',''),(2774,'','1','',''),(2775,'','1','',''),(2776,'','1','',''),(2777,'','1','',''),(2778,'','1','',''),(2779,'','1','',''),(2780,'','1','',''),(2781,'','1','',''),(2782,'','1','',''),(2783,'','1','',''),(2784,'','1','',''),(2785,'','1','',''),(2786,'','1','',''),(2787,'','1','',''),(2788,'','1','',''),(2789,'','1','',''),(2790,'','1','',''),(2791,'','1','',''),(2792,'','1','',''),(2793,'','1','',''),(2794,'','1','',''),(2795,'','1','',''),(2796,'','1','',''),(2797,'','1','',''),(2798,'','2','',''),(2799,'','2','',''),(2800,'','2','',''),(2801,'','','',''),(2802,'','2','',''),(2803,'','2','',''),(2804,'','2','',''),(2805,'','2','',''),(2806,'','2','',''),(2807,'','2','',''),(2808,'','2','',''),(2809,'','2','',''),(2810,'','2','',''),(2811,'','2','',''),(2812,'','2','',''),(2813,'','2','',''),(2814,'','2','',''),(2815,'','2','',''),(2816,'','2','',''),(2817,'','2','',''),(2818,'','2','',''),(2819,'','2','',''),(2820,'','2','',''),(2821,'','2','',''),(2822,'','2','',''),(2823,'','2','',''),(2824,'','2','',''),(2825,'','2','',''),(2826,'','2','',''),(2827,'','2','',''),(2828,'','2','',''),(2829,'','2','',''),(2830,'','2','',''),(2831,'','2','',''),(2832,'','2','',''),(2833,'','2','',''),(2834,'','2','',''),(2835,'','2','',''),(2836,'','','',''),(2837,'','1','',''),(2838,'','1','',''),(2839,'','1','',''),(2840,'','1','',''),(2841,'','1','',''),(2842,'','1','',''),(2843,'','1','',''),(2844,'','1','',''),(2845,'','1','',''),(2846,'','1','',''),(2847,'','2','',''),(2848,'','2','',''),(2849,'','2','',''),(2850,'','7','',''),(2851,'','1','',''),(2852,'','2','',''),(2853,'','','',''),(2854,'','','',''),(2855,'','2','',''),(2856,'','2','',''),(2857,'','2','',''),(2858,'','4','',''),(2859,'','7','',''),(2860,'','2','',''),(2861,'','1','',''),(2862,'','1','',''),(2863,'','2','',''),(2864,'','2','',''),(2865,'','2','',''),(2866,'','10','',''),(2867,'','10','','');

--
-- Table structure for table `BizPit_app_booking_master_table`
--

CREATE TABLE `BizPit_app_booking_master_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `booked_by` varchar(100) NOT NULL,
  `booked_by_id` int(11) NOT NULL,
  `booking_type` varchar(100) NOT NULL,
  `property_type` varchar(100) NOT NULL,
  `head_count` int(11) NOT NULL,
  `timestamp` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_booking_master_table`
--

INSERT INTO `BizPit_app_booking_master_table` VALUES (4,2,4,'user',1,'Hourly','Plug & Play',10,'11/04/2016'),(10,2,10,'user',10,'Hourly','Plug & Play',10,'10/04/2016'),(14,1,14,'user',10,'Daily','meeting',10,'time'),(15,2,15,'user',10,'Hourly','Plug & Play',10,'10/04/2016'),(16,2,16,'user',10,'Hourly','Plug & Play',10,'08/04/2016'),(17,6,17,'user',10,'Weekly','meeting',10,'time'),(18,2,18,'user',10,'Hourly','Plug & Play',10,'09/04/2016'),(19,2,19,'user',10,'Hourly','Plug & Play',10,'10/04/2016'),(20,2,20,'user',10,'Hourly','Plug & Play',10,'10/04/2016'),(21,2,21,'user',10,'Hourly','Plug & Play',10,'10/04/2016'),(24,4,24,'user',10,'HalfDay','Plug & Play',10,'10/04/2016'),(26,2,26,'user',5,'Hourly','Plug & Play',10,'07/04/2016'),(27,2,27,'user',5,'Hourly','Plug & Play',10,'09/04/2016'),(28,2,28,'user',5,'Hourly','Plug & Play',10,'10/04/2016'),(29,2,29,'user',5,'Hourly','Plug & Play',10,'09/04/2016'),(30,2,30,'user',5,'Hourly','Plug & Play',10,'10/04/2016'),(31,2,31,'user',2,'HalfDay','eventhall',2,'8/4/2016'),(32,2,32,'user',2,'HalfDay','eventhall',2,' 8/4/2016'),(33,2,33,'user',2,'HalfDay','eventhall',2,' 8/4/2016'),(53,11,53,'user',2,'Monthly','plug&play',2,'time'),(54,1,54,'user',2,'Weekly','meeting',2,'time'),(55,8,55,'user',2,'Daily','plug&play',2,'time'),(56,2,56,'user',2,'Hourly','meeting',2,'12/4/2016'),(57,8,57,'user',2,'Daily','plug&play',2,'time'),(58,8,58,'user',4,'Daily','Plug & Play',10,'time'),(60,8,60,'user',4,'Daily','Plug & Play',10,'time'),(61,8,61,'user',4,'Daily','Plug & Play',10,'time'),(62,8,62,'user',2,'Daily','Plug & Play',20,'time'),(63,8,63,'user',2,'Daily','Plug & Play',20,'time'),(64,8,64,'user',4,'Daily','Plug & Play',10,'time'),(65,8,65,'user',4,'Daily','Plug & Play',10,'time'),(67,8,67,'user',4,'Daily','Plug & Play',1,'time'),(68,9,68,'user',4,'Hourly','Plug & Play',1,'22/04/2016'),(70,14,70,'user',2,'HalfDay','Event_Hall',2,'15/04/2016'),(71,10,71,'user',2,'Weekly','Plug & Play',10,'time'),(72,8,72,'user',2,'Weekly','Plug & Play',10,'time'),(74,17,74,'user',2,'HalfDay','Training Room',10,'13/5/2016'),(75,17,75,'user',2,'HalfDay','Training Room',10,'13/5/2016'),(76,8,76,'user',2,'Daily','Plug & Play',20,'time'),(77,8,77,'user',2,'Daily','Plug & Play',2,'time'),(78,8,78,'user',2,'Daily','Plug & Play',2,'time'),(79,8,79,'user',2,'Daily','Plug & Play',2,'time'),(80,8,80,'user',2,'Daily','Plug & Play',2,'time'),(81,3,81,'user',2,'HalfDay','Event_Hall',5,'8/4/2016'),(82,3,82,'user',2,'HalfDay','Event_Hall',5,'8/4/2016'),(83,3,83,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(84,3,84,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(85,3,85,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(86,3,86,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(87,3,87,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(88,3,88,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(89,3,89,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(90,3,90,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(91,3,91,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(92,3,92,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(93,3,93,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(94,3,94,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(95,3,95,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(96,3,96,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(97,3,97,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(98,3,98,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(99,3,99,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(100,1,100,'user',2,'Weekly','Meeting_Room',2,'time'),(101,16,101,'user',2,'Weekly','Meeting_Room',2,'time'),(102,8,102,'user',2,'Weekly','Plug & Play',2,'time'),(103,8,103,'user',2,'Weekly','Plug & Play',2,'time'),(104,5,104,'user',2,'Monthly','Plug & Play',2,'time'),(105,35,105,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(106,35,106,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(107,35,107,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(108,38,108,'user',2,'HalfDay','Event_Hall',2,'8/4/2016'),(109,38,109,'user',2,'HalfDay','Event_Hall',2,'8/4/2016');

--
-- Table structure for table `BizPit_app_booking_type`
--

CREATE TABLE `BizPit_app_booking_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `book_type` varchar(500) NOT NULL,
  `property_type` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_booking_type`
--

INSERT INTO `BizPit_app_booking_type` VALUES (1,1,'Hourly,Daily,Weekly','[u\'Meeting_Room\']'),(2,2,'Hourly,Daily,Weekly','[u\'Meeting_Room\']'),(3,3,'FullDay,HalfDay','Event_Hall'),(4,4,'FullDay,HalfDay','Training Room'),(5,5,'Monthly,Hourly,Daily,Weekly','Plug & Play'),(6,6,'Monthly,Hourly,Daily,Weekly','Plug & Play'),(7,7,'Monthly,Hourly,Daily,Weekly','Plug & Play'),(8,8,'Monthly,Hourly,Daily,Weekly','Plug & Play'),(9,9,'Monthly,Hourly,Daily,Weekly','Plug & Play'),(10,10,'Monthly,Hourly,Daily,Weekly','Plug & Play'),(11,11,'Monthly,Hourly,Daily,Weekly','Plug & Play'),(12,12,'FullDay,HalfDay','Training Room'),(13,13,'FullDay,HalfDay','Training Room'),(14,14,'FullDay,HalfDay','Event_Hall'),(15,15,'FullDay,HalfDay','Event_Hall'),(16,16,'Hourly,Daily,Weekly','[u\'Meeting_Room\']'),(17,17,'FullDay,HalfDay','Training Room'),(18,18,'Monthly,Hourly,Daily,Weekly','Plug & Play'),(19,20,'Hourly,Daily','[u\'Meeting_Room\']'),(20,21,'Hourly,Daily','[u\'Meeting_Room\']'),(21,22,'FullDay,HalfDay','Training Room'),(22,23,'FullDay,HalfDay','Training Room'),(23,24,'Hourly,Daily','Meeting_Room'),(24,25,'FullDay,HalfDay','Training Room'),(25,26,'FullDay,HalfDay','Event_Hall'),(26,27,'FullDay,HalfDay','Event_Hall'),(27,28,'FullDay,HalfDay','Event_Hall'),(28,29,'FullDay,HalfDay','Event_Hall'),(29,30,'FullDay,HalfDay','Event_Hall'),(30,31,'FullDay,HalfDay','Event_Hall'),(31,32,'FullDay,HalfDay','Event_Hall'),(32,33,'FullDay,HalfDay','Event_Hall'),(33,35,'FullDay,HalfDay','Event_Hall'),(34,36,'FullDay,HalfDay','Training Room'),(35,37,'FullDay,HalfDay','Training Room'),(36,38,'FullDay,HalfDay','Event_Hall');

--
-- Table structure for table `BizPit_app_commercial_halls`
--

CREATE TABLE `BizPit_app_commercial_halls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `capacity` int(11) NOT NULL,
  `rate_hr` int(11) NOT NULL,
  `rate_daily` int(11) NOT NULL,
  `rate_weekly` int(11) NOT NULL,
  `rate_monthly` int(11) NOT NULL,
  `shared_images` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_commercial_halls`
--


--
-- Table structure for table `BizPit_app_daily_booking`
--

CREATE TABLE `BizPit_app_daily_booking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `booked_by` varchar(100) DEFAULT NULL,
  `booked_by_id` int(11) DEFAULT NULL,
  `start_date` varchar(100) NOT NULL,
  `end_date` varchar(100) NOT NULL,
  `start_time` varchar(100) NOT NULL,
  `end_time` varchar(100) NOT NULL,
  `Timestamp` varchar(100) NOT NULL,
  `head_count` int(11) NOT NULL,
  `property_type` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_daily_booking`
--


--
-- Table structure for table `BizPit_app_dwm_booking`
--

CREATE TABLE `BizPit_app_dwm_booking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `booking_type` varchar(100) NOT NULL,
  `head_count` int(11) NOT NULL,
  `date` varchar(100) NOT NULL,
  `room_no` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_dwm_booking`
--

INSERT INTO `BizPit_app_dwm_booking` VALUES (2,6,6,'Weekly',10,'27/04/2016',1),(3,6,6,'Weekly',10,'28/04/2016',1),(4,6,6,'Weekly',10,'29/04/2016',1),(5,6,6,'Weekly',10,'30/04/2016',1),(67,8,8,'Daily',20,'14/04/2016',1),(68,8,8,'Daily',20,'15/04/2016',1),(69,8,8,'Daily',10,'19/04/2016',1),(70,8,8,'Daily',10,'21/04/2016',1),(71,8,8,'Daily',10,'22/04/2016',1),(72,8,8,'Daily',1,'23/04/2016',1),(73,10,10,'Weekly',10,'5/5/2016',1),(74,8,8,'Weekly',10,'5/5/2016',1),(75,8,8,'Daily',20,'7/4/2016|09:00am',1),(76,8,8,'Daily',20,'7/4/2016|10:00am',1),(77,8,8,'Daily',20,'7/4/2016|11:00am',1),(78,8,8,'Daily',20,'7/4/2016|12:00pm',1),(79,8,8,'Daily',20,'7/4/2016|01:00pm',1),(80,8,8,'Daily',20,'8/4/2016|09:00am',1),(81,8,8,'Daily',2,'7/4/2016|09:00am',1),(82,8,8,'Daily',2,'7/4/2016|10:00am',1),(83,8,8,'Daily',2,'7/4/2016|11:00am',1),(84,8,8,'Daily',2,'7/4/2016|12:00pm',1),(85,8,8,'Daily',2,'7/4/2016|01:00pm',1),(86,8,8,'Daily',2,'8/4/2016|09:00am',1),(87,8,8,'Daily',2,'7/4/2016|09:00am',1),(88,8,8,'Daily',2,'7/4/2016|10:00am',1),(89,8,8,'Daily',2,'7/4/2016|11:00am',1),(90,8,8,'Daily',2,'7/4/2016|12:00pm',1),(91,8,8,'Daily',2,'7/4/2016|01:00pm',1),(92,8,8,'Daily',2,'8/4/2016|09:00am',1),(93,8,8,'Daily',2,'7/4/2016|09:00am',1),(94,8,8,'Daily',2,'7/4/2016|10:00am',1),(95,8,8,'Daily',2,'7/4/2016|11:00am',1),(96,8,8,'Daily',2,'7/4/2016|12:00pm',1),(97,8,8,'Daily',2,'7/4/2016|01:00pm',1),(98,8,8,'Daily',2,'8/4/2016|09:00am',1),(99,8,8,'Daily',2,'7/4/2016|09:00am',1),(100,8,8,'Daily',2,'7/4/2016|10:00am',1),(101,8,8,'Daily',2,'7/4/2016|11:00am',1),(102,8,8,'Daily',2,'7/4/2016|12:00pm',1),(103,8,8,'Daily',2,'7/4/2016|01:00pm',1),(104,8,8,'Daily',2,'8/4/2016|09:00am',1),(105,1,1,'Weekly',2,'23/03/2016',1),(106,1,1,'Weekly',2,'24/03/2016',1),(107,1,1,'Weekly',2,'25/03/2016',1),(108,1,1,'Weekly',2,'26/03/2016',1),(109,1,1,'Weekly',2,'27/03/2016',1),(110,1,1,'Weekly',2,'28/03/2016',1),(111,1,1,'Weekly',2,'29/03/2016',1),(112,16,16,'Weekly',2,'23/03/2016',1),(113,16,16,'Weekly',2,'24/03/2016',1),(114,16,16,'Weekly',2,'25/03/2016',1),(115,16,16,'Weekly',2,'26/03/2016',1),(116,16,16,'Weekly',2,'27/03/2016',1),(117,16,16,'Weekly',2,'28/03/2016',1),(118,16,16,'Weekly',2,'29/03/2016',1),(125,8,8,'Weekly',2,'29/03/2016',1);

--
-- Table structure for table `BizPit_app_event_halls`
--

CREATE TABLE `BizPit_app_event_halls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `capacity` int(11) NOT NULL,
  `duration_half` int(11) DEFAULT NULL,
  `rate_daily` int(11) NOT NULL,
  `rate_halfday` int(11) DEFAULT NULL,
  `shared_images` longtext NOT NULL,
  `room_no` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_event_halls`
--

INSERT INTO `BizPit_app_event_halls` VALUES (1,3,20,-1,500,1000,'',1),(2,14,20,-1,0,7000,'',1),(3,15,10,-1,500,1000,'',1),(4,26,-1,-1,-1,-1,'',1),(5,27,-1,-1,-1,-1,'',1),(6,28,-1,-1,-1,-1,'',1),(7,29,-1,-1,-1,-1,'',1),(8,30,-1,-1,-1,-1,'',1),(9,31,-1,-1,-1,-1,'',1),(10,32,-1,-1,-1,-1,'',1),(11,33,-1,-1,-1,-1,'',1),(12,35,50,-1,1000,200,'',1),(13,35,10,-1,0,500,'',2),(14,38,50,-1,1000,200,'',1),(15,38,10,-1,0,500,'',2);

--
-- Table structure for table `BizPit_app_favourite`
--

CREATE TABLE `BizPit_app_favourite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `property_id` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `status` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_favourite`
--

INSERT INTO `BizPit_app_favourite` VALUES (1,1,2,1,'false'),(2,2,6,2,'false'),(3,1,3,1,'true'),(4,2,5,2,'true');

--
-- Table structure for table `BizPit_app_holidays`
--

CREATE TABLE `BizPit_app_holidays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `holidays` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_holidays`
--

INSERT INTO `BizPit_app_holidays` VALUES (1,1,'08/04/2016'),(2,2,'15/04/2016,20/04/2016'),(3,3,'28/04/2016'),(5,4,'08/04/2016'),(6,5,'08/04/2016'),(7,6,'08/04/2016'),(8,7,'08/04/2016'),(9,8,'08/04/2016'),(10,9,'08/04/2016'),(11,10,'01/05/2016'),(12,11,'01/05/2016'),(13,12,'15/04/2016,29/04/2016'),(14,13,'20/04/2016'),(15,14,'22/04/2016'),(16,15,'28/04/2016'),(17,16,'30/04/2016,26/04/2016'),(18,17,'28/04/2016'),(19,18,'28/04/2016'),(20,19,'28/04/2016'),(21,20,'28/04/2016'),(22,21,'28/04/2016'),(23,22,'28/04/2016'),(24,23,'28/04/2016'),(25,24,'28/04/2016'),(26,25,'28/04/2016'),(27,26,'28/04/2016'),(28,27,'28/04/2016'),(29,28,'28/04/2016'),(30,29,'28/04/2016'),(31,30,'28/04/2016'),(32,31,'28/04/2016'),(33,32,'28/04/2016'),(34,33,'28/04/2016'),(35,34,'28/04/2016'),(36,35,'28/04/2016'),(37,36,'28/04/2016'),(38,37,'28/04/2016'),(39,38,'30/04/2016,26/04/2016');

--
-- Table structure for table `BizPit_app_hourly_booking`
--

CREATE TABLE `BizPit_app_hourly_booking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `booked_by` varchar(100) DEFAULT NULL,
  `booked_by_id` int(11) DEFAULT NULL,
  `date` varchar(100) DEFAULT NULL,
  `start_time` varchar(100) NOT NULL,
  `end_time` varchar(100) NOT NULL,
  `property_type` varchar(100) DEFAULT NULL,
  `head_count` int(11) NOT NULL,
  `timestamp` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_hourly_booking`
--


--
-- Table structure for table `BizPit_app_hourly_halfday_booking`
--

CREATE TABLE `BizPit_app_hourly_halfday_booking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `booking_type` varchar(100) NOT NULL,
  `head_count` int(11) NOT NULL,
  `date` varchar(100) NOT NULL,
  `time` varchar(100) NOT NULL,
  `room_no` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=407 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_hourly_halfday_booking`
--

INSERT INTO `BizPit_app_hourly_halfday_booking` VALUES (3,1,3,'Hourly',10,'12/04/2016','10:00am',1),(4,2,4,'Hourly',10,'11/04/2016','10:00am',1),(5,1,5,'Hourly',10,'11/04/2016','08:00am',1),(6,1,5,'Hourly',10,'11/04/2016','09:00am',1),(7,1,6,'Hourly',10,'11/04/2016','12:00pm',1),(8,1,7,'Hourly',10,'11/04/2016','01:00pm',1),(9,1,8,'Hourly',10,'13/04/2016','01:00pm',1),(11,2,10,'Hourly',10,'10/04/2016','02:00pm',1),(12,1,11,'Hourly',10,'07/04/2016','01:00pm',1),(13,1,12,'Hourly',10,'11/04/2016','02:00pm',1),(14,1,13,'Hourly',10,'11/04/2016','03:00pm',1),(15,2,15,'Hourly',10,'10/04/2016','03:00pm',1),(16,2,16,'Hourly',10,'08/04/2016','01:00pm',1),(17,2,18,'Hourly',10,'09/04/2016','02:00pm',1),(18,2,19,'Hourly',10,'10/04/2016','12:00pm',1),(19,2,19,'Hourly',10,'10/04/2016','01:00pm',1),(20,2,19,'Hourly',10,'10/04/2016','02:00pm',1),(21,2,20,'Hourly',10,'10/04/2016','01:00pm',1),(22,2,21,'Hourly',10,'10/04/2016','12:00pm',1),(23,1,22,'Hourly',10,'15/04/2016','09:00am',1),(24,1,22,'Hourly',10,'15/04/2016','10:00am',1),(25,1,22,'Hourly',10,'15/04/2016','11:00am',1),(27,4,24,'HalfDay',10,'10/04/2016','11:30am',1),(29,2,26,'Hourly',10,'07/04/2016','10:00am',1),(31,2,27,'Hourly',10,'09/04/2016','12:00pm',1),(32,2,27,'Hourly',10,'09/04/2016','01:00pm',1),(33,2,28,'Hourly',10,'09/04/2016','11:00am',1),(34,2,28,'Hourly',10,'10/04/2016','11:00am',1),(35,2,28,'Hourly',10,'09/04/2016','12:00pm',1),(36,2,28,'Hourly',10,'10/04/2016','12:00pm',1),(37,2,29,'Hourly',10,'09/04/2016','11:00am',1),(38,2,29,'Hourly',10,'10/04/2016','11:00am',1),(39,2,29,'Hourly',10,'09/04/2016','12:00pm',1),(40,2,29,'Hourly',10,'09/04/2016','01:00pm',1),(41,2,30,'Hourly',10,'09/04/2016','11:00am',1),(42,2,30,'Hourly',10,'09/04/2016','12:00pm',1),(43,2,30,'Hourly',10,'09/04/2016','01:00pm',1),(44,2,30,'Hourly',10,'10/04/2016','01:00pm',1),(45,2,31,'HalfDay',2,'7/4/2016','09:00am',1),(46,2,31,'HalfDay',2,'7/4/2016','10:00am',1),(47,2,31,'HalfDay',2,'7/4/2016','11:00am',1),(48,2,31,'HalfDay',2,'7/4/2016','12:00pm',1),(49,2,31,'HalfDay',2,'7/4/2016','01:00pm',1),(50,2,31,'HalfDay',2,'8/4/2016','09:00am',1),(57,2,33,'HalfDay',2,'8/4/2016','09:00am',1),(58,2,33,'HalfDay',2,'8/4/2016','10:00am',1),(59,2,33,'HalfDay',2,'8/4/2016','11:00am',1),(60,2,33,'HalfDay',2,'8/4/2016','12:00pm',1),(61,2,33,'HalfDay',2,'8/4/2016','01:00pm',1),(175,1,50,'Hourly',10,'20/04/2016','10:00am',1),(188,2,56,'Hourly',2,'10/4/2016','09:00am',1),(189,2,56,'Hourly',2,'11/4/2016','10:00am',1),(190,2,56,'Hourly',2,'12/4/2016','11:00am',1),(192,1,66,'Hourly',10,'14/04/2016','10:00am',1),(193,9,68,'Hourly',1,'22/04/2016','10:00am',1),(194,1,69,'Hourly',10,'13/04/2016','10:00am',1),(195,14,70,'HalfDay',2,'15/04/2016','11:00am',1),(196,14,70,'HalfDay',2,'15/04/2016','12:00pm',1),(197,14,70,'HalfDay',2,'15/04/2016','01:00pm',1),(198,14,70,'HalfDay',2,'15/04/2016','02:00pm',1),(199,14,70,'HalfDay',2,'15/04/2016','03:00pm',1),(200,14,70,'HalfDay',2,'15/04/2016','04:00pm',1),(219,17,74,'HalfDay',10,'12/5/2016','9:00am',1),(220,17,74,'HalfDay',10,'12/5/2016','10:00am',1),(221,17,74,'HalfDay',10,'12/5/2016','11:00am',1),(222,17,74,'HalfDay',10,'12/5/2016','12:00pm',1),(223,17,74,'HalfDay',10,'13/5/2016','2:00pm',1),(224,17,74,'HalfDay',10,'13/5/2016','3:00pm',1),(225,17,74,'HalfDay',10,'13/5/2016','4:00pm',1),(226,17,74,'HalfDay',10,'13/5/2016','5:00pm',1),(227,17,74,'HalfDay',10,'13/5/2016','6:00pm',1),(228,17,74,'HalfDay',10,'12/5/2016','9:00am',1),(229,17,74,'HalfDay',10,'12/5/2016','10:00am',1),(230,17,74,'HalfDay',10,'12/5/2016','11:00am',1),(231,17,74,'HalfDay',10,'12/5/2016','12:00pm',1),(232,17,74,'HalfDay',10,'13/5/2016','2:00pm',1),(233,17,74,'HalfDay',10,'13/5/2016','3:00pm',1),(234,17,74,'HalfDay',10,'13/5/2016','4:00pm',1),(235,17,74,'HalfDay',10,'13/5/2016','5:00pm',1),(236,17,74,'HalfDay',10,'13/5/2016','6:00pm',1),(237,17,74,'HalfDay',10,'12/5/2016','9:00am',1),(238,17,74,'HalfDay',10,'12/5/2016','10:00am',1),(239,17,74,'HalfDay',10,'12/5/2016','11:00am',1),(240,17,74,'HalfDay',10,'12/5/2016','12:00pm',1),(241,17,74,'HalfDay',10,'13/5/2016','2:00pm',1),(242,17,74,'HalfDay',10,'13/5/2016','3:00pm',1),(243,17,74,'HalfDay',10,'13/5/2016','4:00pm',1),(244,17,74,'HalfDay',10,'13/5/2016','5:00pm',1),(245,17,74,'HalfDay',10,'13/5/2016','6:00pm',1),(246,17,75,'HalfDay',10,'12/5/2016','9:00am',1),(247,17,75,'HalfDay',10,'12/5/2016','10:00am',1),(248,17,75,'HalfDay',10,'12/5/2016','11:00am',1),(249,17,75,'HalfDay',10,'12/5/2016','12:00pm',1),(250,17,75,'HalfDay',10,'13/5/2016','2:00pm',1),(251,17,75,'HalfDay',10,'13/5/2016','3:00pm',1),(252,17,75,'HalfDay',10,'13/5/2016','4:00pm',1),(253,17,75,'HalfDay',10,'13/5/2016','5:00pm',1),(254,17,75,'HalfDay',10,'13/5/2016','6:00pm',1),(255,3,81,'HalfDay',5,'7/4/2016','09:00am',1),(256,3,81,'HalfDay',5,'7/4/2016','10:00am',1),(257,3,81,'HalfDay',5,'7/4/2016','11:00am',1),(258,3,81,'HalfDay',5,'7/4/2016','12:00pm',1),(259,3,81,'HalfDay',5,'7/4/2016','01:00pm',1),(260,3,81,'HalfDay',5,'7/4/2016','03:00pm',1),(261,3,81,'HalfDay',5,'7/4/2016','04:00pm',1),(262,3,81,'HalfDay',5,'7/4/2016','05:00pm',1),(263,3,81,'HalfDay',5,'7/4/2016','06:00pm',1),(264,3,81,'HalfDay',5,'8/4/2016','09:00am',1),(265,3,82,'HalfDay',5,'7/4/2016','09:00am',1),(266,3,82,'HalfDay',5,'7/4/2016','10:00am',1),(267,3,82,'HalfDay',5,'7/4/2016','11:00am',1),(268,3,82,'HalfDay',5,'7/4/2016','12:00pm',1),(269,3,82,'HalfDay',5,'7/4/2016','01:00pm',1),(270,3,82,'HalfDay',5,'7/4/2016','03:00pm',1),(271,3,82,'HalfDay',5,'7/4/2016','04:00pm',1),(272,3,82,'HalfDay',5,'7/4/2016','05:00pm',1),(273,3,82,'HalfDay',5,'7/4/2016','06:00pm',1),(274,3,82,'HalfDay',5,'8/4/2016','09:00am',1),(275,3,83,'HalfDay',2,'7/4/2016','09:00am',1),(276,3,83,'HalfDay',2,'7/4/2016','10:00am',1),(277,3,83,'HalfDay',2,'7/4/2016','11:00am',1),(278,3,83,'HalfDay',2,'7/4/2016','12:00pm',1),(279,3,83,'HalfDay',2,'7/4/2016','01:00pm',1),(280,3,83,'HalfDay',2,'8/4/2016','09:00am',1),(281,3,84,'HalfDay',2,'7/4/2016','09:00am',1),(282,3,84,'HalfDay',2,'7/4/2016','10:00am',1),(283,3,84,'HalfDay',2,'7/4/2016','11:00am',1),(284,3,84,'HalfDay',2,'7/4/2016','12:00pm',1),(285,3,84,'HalfDay',2,'7/4/2016','01:00pm',1),(286,3,84,'HalfDay',2,'8/4/2016','09:00am',1),(287,3,85,'HalfDay',2,'7/4/2016','09:00am',1),(288,3,85,'HalfDay',2,'7/4/2016','10:00am',1),(289,3,85,'HalfDay',2,'7/4/2016','11:00am',1),(290,3,85,'HalfDay',2,'7/4/2016','12:00pm',1),(291,3,85,'HalfDay',2,'7/4/2016','01:00pm',1),(292,3,85,'HalfDay',2,'8/4/2016','09:00am',1),(293,3,86,'HalfDay',2,'7/4/2016','09:00am',1),(294,3,86,'HalfDay',2,'7/4/2016','10:00am',1),(295,3,86,'HalfDay',2,'7/4/2016','11:00am',1),(296,3,86,'HalfDay',2,'7/4/2016','12:00pm',1),(297,3,86,'HalfDay',2,'7/4/2016','01:00pm',1),(298,3,86,'HalfDay',2,'8/4/2016','09:00am',1),(299,3,87,'HalfDay',2,'7/4/2016','09:00am',1),(300,3,87,'HalfDay',2,'7/4/2016','10:00am',1),(301,3,87,'HalfDay',2,'7/4/2016','11:00am',1),(302,3,87,'HalfDay',2,'7/4/2016','12:00pm',1),(303,3,87,'HalfDay',2,'7/4/2016','01:00pm',1),(304,3,87,'HalfDay',2,'8/4/2016','09:00am',1),(305,3,88,'HalfDay',2,'7/4/2016','09:00am',1),(306,3,88,'HalfDay',2,'7/4/2016','10:00am',1),(307,3,88,'HalfDay',2,'7/4/2016','11:00am',1),(308,3,88,'HalfDay',2,'7/4/2016','12:00pm',1),(309,3,88,'HalfDay',2,'7/4/2016','01:00pm',1),(310,3,88,'HalfDay',2,'8/4/2016','09:00am',1),(311,3,89,'HalfDay',2,'7/4/2016','09:00am',1),(312,3,89,'HalfDay',2,'7/4/2016','10:00am',1),(313,3,89,'HalfDay',2,'7/4/2016','11:00am',1),(314,3,89,'HalfDay',2,'7/4/2016','12:00pm',1),(315,3,89,'HalfDay',2,'7/4/2016','01:00pm',1),(316,3,89,'HalfDay',2,'8/4/2016','09:00am',1),(317,3,90,'HalfDay',2,'7/4/2016','09:00am',1),(318,3,90,'HalfDay',2,'7/4/2016','10:00am',1),(319,3,90,'HalfDay',2,'7/4/2016','11:00am',1),(320,3,90,'HalfDay',2,'7/4/2016','12:00pm',1),(321,3,90,'HalfDay',2,'7/4/2016','01:00pm',1),(322,3,90,'HalfDay',2,'8/4/2016','09:00am',1),(323,3,91,'HalfDay',2,'7/4/2016','09:00am',1),(324,3,91,'HalfDay',2,'7/4/2016','10:00am',1),(325,3,91,'HalfDay',2,'7/4/2016','11:00am',1),(326,3,91,'HalfDay',2,'7/4/2016','12:00pm',1),(327,3,91,'HalfDay',2,'7/4/2016','01:00pm',1),(328,3,91,'HalfDay',2,'8/4/2016','09:00am',1),(329,3,92,'HalfDay',2,'7/4/2016','09:00am',1),(330,3,92,'HalfDay',2,'7/4/2016','10:00am',1),(331,3,92,'HalfDay',2,'7/4/2016','11:00am',1),(332,3,92,'HalfDay',2,'7/4/2016','12:00pm',1),(333,3,92,'HalfDay',2,'7/4/2016','01:00pm',1),(334,3,92,'HalfDay',2,'8/4/2016','09:00am',1),(335,3,93,'HalfDay',2,'7/4/2016','09:00am',1),(336,3,93,'HalfDay',2,'7/4/2016','10:00am',1),(337,3,93,'HalfDay',2,'7/4/2016','11:00am',1),(338,3,93,'HalfDay',2,'7/4/2016','12:00pm',1),(339,3,93,'HalfDay',2,'7/4/2016','01:00pm',1),(340,3,93,'HalfDay',2,'8/4/2016','09:00am',1),(341,3,94,'HalfDay',2,'7/4/2016','09:00am',1),(342,3,94,'HalfDay',2,'7/4/2016','10:00am',1),(343,3,94,'HalfDay',2,'7/4/2016','11:00am',1),(344,3,94,'HalfDay',2,'7/4/2016','12:00pm',1),(345,3,94,'HalfDay',2,'7/4/2016','01:00pm',1),(346,3,94,'HalfDay',2,'8/4/2016','09:00am',1),(347,3,95,'HalfDay',2,'7/4/2016','09:00am',1),(348,3,95,'HalfDay',2,'7/4/2016','10:00am',1),(349,3,95,'HalfDay',2,'7/4/2016','11:00am',1),(350,3,95,'HalfDay',2,'7/4/2016','12:00pm',1),(351,3,95,'HalfDay',2,'7/4/2016','01:00pm',1),(352,3,95,'HalfDay',2,'8/4/2016','09:00am',1),(353,3,96,'HalfDay',2,'7/4/2016','09:00am',1),(354,3,96,'HalfDay',2,'7/4/2016','10:00am',1),(355,3,96,'HalfDay',2,'7/4/2016','11:00am',1),(356,3,96,'HalfDay',2,'7/4/2016','12:00pm',1),(357,3,96,'HalfDay',2,'7/4/2016','01:00pm',1),(358,3,96,'HalfDay',2,'8/4/2016','09:00am',1),(359,3,97,'HalfDay',2,'7/4/2016','09:00am',1),(360,3,97,'HalfDay',2,'7/4/2016','10:00am',1),(361,3,97,'HalfDay',2,'7/4/2016','11:00am',1),(362,3,97,'HalfDay',2,'7/4/2016','12:00pm',1),(363,3,97,'HalfDay',2,'7/4/2016','01:00pm',1),(364,3,97,'HalfDay',2,'8/4/2016','09:00am',1),(365,3,98,'HalfDay',2,'7/4/2016','09:00am',1),(366,3,98,'HalfDay',2,'7/4/2016','10:00am',1),(367,3,98,'HalfDay',2,'7/4/2016','11:00am',1),(368,3,98,'HalfDay',2,'7/4/2016','12:00pm',1),(369,3,98,'HalfDay',2,'7/4/2016','01:00pm',1),(370,3,98,'HalfDay',2,'8/4/2016','09:00am',1),(371,3,99,'HalfDay',2,'7/4/2016','09:00am',1),(372,3,99,'HalfDay',2,'7/4/2016','10:00am',1),(373,3,99,'HalfDay',2,'7/4/2016','11:00am',1),(374,3,99,'HalfDay',2,'7/4/2016','12:00pm',1),(375,3,99,'HalfDay',2,'7/4/2016','01:00pm',1),(376,3,99,'HalfDay',2,'8/4/2016','09:00am',1),(377,35,105,'HalfDay',2,'7/4/2016','09:00am',1),(378,35,105,'HalfDay',2,'7/4/2016','10:00am',1),(379,35,105,'HalfDay',2,'7/4/2016','11:00am',1),(380,35,105,'HalfDay',2,'7/4/2016','12:00pm',1),(381,35,105,'HalfDay',2,'7/4/2016','01:00pm',1),(382,35,105,'HalfDay',2,'8/4/2016','09:00am',1),(383,35,106,'HalfDay',2,'7/4/2016','09:00am',1),(384,35,106,'HalfDay',2,'7/4/2016','10:00am',1),(385,35,106,'HalfDay',2,'7/4/2016','11:00am',1),(386,35,106,'HalfDay',2,'7/4/2016','12:00pm',1),(387,35,106,'HalfDay',2,'7/4/2016','01:00pm',1),(388,35,106,'HalfDay',2,'8/4/2016','09:00am',1),(389,35,107,'HalfDay',2,'7/4/2016','09:00am',1),(390,35,107,'HalfDay',2,'7/4/2016','10:00am',1),(391,35,107,'HalfDay',2,'7/4/2016','11:00am',1),(392,35,107,'HalfDay',2,'7/4/2016','12:00pm',1),(393,35,107,'HalfDay',2,'7/4/2016','01:00pm',1),(394,35,107,'HalfDay',2,'8/4/2016','09:00am',1),(395,38,108,'HalfDay',2,'7/4/2016','09:00am',1),(396,38,108,'HalfDay',2,'7/4/2016','10:00am',1),(397,38,108,'HalfDay',2,'7/4/2016','11:00am',1),(398,38,108,'HalfDay',2,'7/4/2016','12:00pm',1),(399,38,108,'HalfDay',2,'7/4/2016','01:00pm',1),(400,38,108,'HalfDay',2,'8/4/2016','09:00am',1),(401,38,109,'HalfDay',2,'7/4/2016','09:00am',1),(402,38,109,'HalfDay',2,'7/4/2016','10:00am',1),(403,38,109,'HalfDay',2,'7/4/2016','11:00am',1),(404,38,109,'HalfDay',2,'7/4/2016','12:00pm',1),(405,38,109,'HalfDay',2,'7/4/2016','01:00pm',1),(406,38,109,'HalfDay',2,'8/4/2016','09:00am',1);

--
-- Table structure for table `BizPit_app_meeting_room`
--

CREATE TABLE `BizPit_app_meeting_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `capacity` int(11) NOT NULL,
  `room_no` int(11) NOT NULL,
  `rate_hr` int(11) NOT NULL,
  `rate_daily` int(11) NOT NULL,
  `rate_weekly` int(11) NOT NULL,
  `rate_monthly` int(11) NOT NULL,
  `meeting_room_images` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_meeting_room`
--

INSERT INTO `BizPit_app_meeting_room` VALUES (1,1,10,1,250,600,1500,0,''),(2,2,15,1,250,0,0,0,''),(3,16,15,1,200,500,1500,0,''),(4,20,10,1,200,1000,0,0,''),(5,20,5,2,0,100,0,0,''),(6,21,10,1,200,1000,0,0,''),(7,24,10,1,200,1000,0,0,''),(8,24,5,2,0,100,0,0,''),(9,24,10,3,200,1000,0,0,'');

--
-- Table structure for table `BizPit_app_monthly_booking`
--

CREATE TABLE `BizPit_app_monthly_booking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `booked_by` varchar(100) DEFAULT NULL,
  `booked_by_id` int(11) DEFAULT NULL,
  `start_month` varchar(100) NOT NULL,
  `end_month` varchar(100) NOT NULL,
  `start_time` varchar(100) NOT NULL,
  `end_time` varchar(100) NOT NULL,
  `property_type` varchar(100) DEFAULT NULL,
  `head_count` int(11) NOT NULL,
  `timestamp` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_monthly_booking`
--


--
-- Table structure for table `BizPit_app_non_working_days`
--

CREATE TABLE `BizPit_app_non_working_days` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `Non_Working_days` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_non_working_days`
--

INSERT INTO `BizPit_app_non_working_days` VALUES (1,1,'Sunday,Saturday'),(2,2,'Sunday'),(3,3,'Sunday'),(5,4,'Sunday'),(6,5,'Sunday'),(7,6,'Sunday'),(8,7,'Sunday'),(9,8,'Sunday'),(10,9,'Sunday'),(11,10,'Sunday'),(12,11,'Sunday'),(13,12,'Sunday'),(14,13,'Sunday,Saturday'),(15,14,'Saturday'),(16,15,'Saturday'),(17,16,'Sunday'),(18,17,'Sunday'),(19,18,''),(20,19,''),(21,20,''),(22,21,''),(23,22,''),(24,23,''),(25,24,''),(26,25,''),(27,26,''),(28,27,''),(29,28,''),(30,29,''),(31,30,''),(32,31,''),(33,32,''),(34,33,''),(35,34,''),(36,35,''),(37,36,''),(38,37,''),(39,38,'Sunday,Saturday');

--
-- Table structure for table `BizPit_app_payment`
--

CREATE TABLE `BizPit_app_payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `Booking_id` int(11) NOT NULL,
  `Payment_id` int(11) NOT NULL,
  `User_id` int(11) NOT NULL,
  `Booking_type` varchar(100) NOT NULL,
  `Price` varchar(100) NOT NULL,
  `Payment_status` varchar(100) NOT NULL,
  `timestamp` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_payment`
--


--
-- Table structure for table `BizPit_app_property_capacity`
--

CREATE TABLE `BizPit_app_property_capacity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `Shared_area` tinyint(1) NOT NULL,
  `Shared_capacity` int(11) NOT NULL,
  `Shared_available` int(11) NOT NULL,
  `Meeting_Room` tinyint(1) NOT NULL,
  `Meeting_capacity` int(11) NOT NULL,
  `Meeting_availabe` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_property_capacity`
--


--
-- Table structure for table `BizPit_app_property_details`
--

CREATE TABLE `BizPit_app_property_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `status` varchar(500) NOT NULL,
  `property_type` varchar(200) NOT NULL,
  `property_subtype` varchar(200) NOT NULL,
  `property_name` varchar(200) NOT NULL,
  `location` varchar(100) NOT NULL,
  `address` varchar(500) NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `starting_price` varchar(100) NOT NULL,
  `submitted_by` varchar(100) DEFAULT NULL,
  `timestamp` varchar(100) NOT NULL,
  `Owner_id` int(11) NOT NULL,
  `operating_stoptime` varchar(100) NOT NULL,
  `operating_strattime` varchar(100) NOT NULL,
  `submitted_by_id` int(11) NOT NULL,
  `images` varchar(1000),
  `default_type` varchar(200) NOT NULL,
  `description` varchar(200) NOT NULL,
  `invoice_no` varchar(500),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_property_details`
--

INSERT INTO `BizPit_app_property_details` VALUES (1,1,'active','Meeting_Room','','Quest office pvt. ltd','Service Rd,Muneswara Nagar, Sector 6, Koramangala,Bengaluru, Karnataka 560034','Service Rd,Muneswara Nagar, Sector 6, Koramangala,Bengaluru, Karnataka 560034',12.9180621488383,77.6232039928436,'250','abhaybansod@gmail.com','06-04-2016 11:27',-1,'09:00pm','08:00am',-1,'static/1/meetingroom.jpg','ND','ND','INVOICE1'),(2,2,'active','Meeting_Room','','Breathing room','Marathahalli - Sarjapur Outer Ring Rd,Green Glen Layout, HSR Layout,Bengaluru, Karnataka 560103','Marathahalli - Sarjapur Outer Ring Rd,Green Glen Layout, HSR Layout,Bengaluru, Karnataka 560103',12.9217496261337,77.6669407635927,'250','abhaybansod@gmail.com','06-04-2016 11:34',-1,'07:00pm','10:00am',-1,'static/2/meetingroom.jpg, static/2/meet.jpg','ND','ND','INVOICE2'),(4,3,'active','Event_Hall','','Bookmy function','2nd Main Rd,Reliable Residency Layout Phase 3, Reliable Tranquil Layout,Bengaluru, Karnataka 560068','2nd Main Rd,Reliable Residency Layout Phase 3, Reliable Tranquil Layout,Bengaluru, Karnataka 560068',12.8982454381636,77.6541224867105,'1000','abhaybansod@gmail.com','06-04-2016 11:48',-1,'10:00pm','11:00am',-1,'static/3/Event.jpg','ND','ND','INVOICE3'),(5,4,'active','Training Room','','my training room','11,HAL 3rd Stage, Kodihalli,Bengaluru, Karnataka 560017','11,HAL 3rd Stage, Kodihalli,Bengaluru, Karnataka 560017',12.9608677115967,77.6498644798994,'500','abhaybansod@gmail.com','06-04-2016 11:56',-1,'06:00pm','11:00am',-1,'static/4/training.JPG, static/4/trainingroomback.jpg','ND','ND','INVOICE4'),(6,5,'active','Plug & Play','Co-Working','TechHub.','313,Sector 1, HSR Layout,Bengaluru, Karnataka 560102','313,Sector 1, HSR Layout,Bengaluru, Karnataka 560102',12.9068784725267,77.6523086428642,'5000','tanmaywange@gmail.com','07-04-2016 05:28',-1,'06:00pm','09:00am',-1,'static/5/0, static/5/0, static/5/0','ND','ND','INVOICE5'),(7,6,'active','Plug & Play','Co-Working','Regus.','MG Road,Richmond Town,Bengaluru, Karnataka 560025','MG Road,Richmond Town,Bengaluru, Karnataka 560025',12.9694515312212,77.6051456853747,'5997','tanmaywange@gmail.com','07-04-2016 05:33',-1,'06:00pm','09:00am',-1,'static/6/0, static/6/0, static/6/0','ND','ND','INVOICE6'),(8,7,'active','Plug & Play','Co-Working','Workshaala.','1029, 25th Cross Rd,Garden Layout, Sector 2, HSR Layout,Bengaluru, Karnataka 560102','1029, 25th Cross Rd,Garden Layout, Sector 2, HSR Layout,Bengaluru, Karnataka 560102',12.9072631219153,77.6473938301206,'5000','tanmaywange@gmail.com','07-04-2016 05:41',-1,'10:00pm','08:00pm',-1,'static/7/0, static/7/0','ND','ND','INVOICE7'),(9,8,'active','Plug & Play','Co-Working','Bhive Workspace.','Sarjapur Main Rd,Kudremukh Colony, Koramangala,Bengaluru, Karnataka 560034','Sarjapur Main Rd,Kudremukh Colony, Koramangala,Bengaluru, Karnataka 560034',12.9249818427797,77.6268957182765,'428','tanmaywange@gmail.com','07-04-2016 05:45',-1,'12:00am','12:00am',-1,'static/8/0, static/8/0','ND','ND','INVOICE8'),(10,9,'active','Plug & Play','Co-Working','Golden Square Business Centre.','Post Office Rd,Ambedkar Veedhi, Sampangi Rama Nagar,Bengaluru, Karnataka 560009','Post Office Rd,Ambedkar Veedhi, Sampangi Rama Nagar,Bengaluru, Karnataka 560009',12.9754670858028,77.586770541966,'250','tanmaywange@gmail.com','07-04-2016 05:53',-1,'07:00pm','09:00am',-1,'static/9/0, static/9/0, static/9/0','ND','ND','INVOICE9'),(11,10,'active','Plug & Play','Coffee Shop','Hangout Cafe.','370A, 1st Cross Rd,Koramangala 3 Block, Koramangala,Bengaluru, Karnataka 560034','370A, 1st Cross Rd,Koramangala 3 Block, Koramangala,Bengaluru, Karnataka 560034',12.9250769361754,77.6271421462297,'200','tanmaywange@gmail.com','07-04-2016 05:59',-1,'11:00pm','09:00am',-1,'static/10/0, static/10/0, static/10/0','ND','ND','INVOICE10'),(12,11,'active','Plug & Play','Start Up','CoWork Cafe-Business Workspace for Startups.','Unnamed Rd,Cheemasandra,Baiyappanahalli, Karnataka 560049','Unnamed Rd,Cheemasandra,Baiyappanahalli, Karnataka 560049',13.0715958625809,77.7219203487039,'300','tanmaywange@gmail.com','07-04-2016 06:10',-1,'10:00pm','09:00am',-1,'static/11/0, static/11/0','ND','ND','INVOICE11'),(13,12,'active','Training Room','','Mentors IT','1, Wind Tunnel Rd,Rustam Bagh Layout,Bengaluru, Karnataka 560017','1, Wind Tunnel Rd,Rustam Bagh Layout,Bengaluru, Karnataka 560017',12.9489435788629,77.6485200226307,'500','abhaybansod@gmail.com','11-04-2016 09:36',-1,'07:00pm','09:00am',-1,'static/12/trainingroomback.jpg, static/12/coworkingspace.jpg','ND','ND','INVOICE12'),(14,13,'active','Training Room','','Sneed','64/8, Ejipura Main Rd,Gowda Muniswamy Garden, Ejipura,Bengaluru, Karnataka 560047','64/8, Ejipura Main Rd,Gowda Muniswamy Garden, Ejipura,Bengaluru, Karnataka 560047',12.9494801019484,77.6290314272046,'0','abhaybansod@gmail.com','11-04-2016 09:48',-1,'06:00pm','10:00am',-1,'static/13/tra.jpg','ND','ND','INVOICE13'),(15,14,'active','Event_Hall','','temple tree','Wind Tunnel Rd,HAL Airport Area, HAL,Bengaluru, Karnataka 560017','Wind Tunnel Rd,HAL Airport Area, HAL,Bengaluru, Karnataka 560017',12.9474071951597,77.6558974385262,'7000','abhaybansod@gmail.com','11-04-2016 09:55',-1,'11:00pm','11:00am',-1,'static/14/eventhalldd.jpg, static/14/Event.jpg','ND','ND','INVOICE14'),(16,15,'active','Event_Hall','','star banquet','57,IAS Layout, Eastwood Township, Kasavanahalli,Bengaluru, Karnataka 560035','57,IAS Layout, Eastwood Township, Kasavanahalli,Bengaluru, Karnataka 560035',12.9038953771452,77.6751784980297,'1000','abhaybansod@gmail.com','11-04-2016 09:58',-1,'09:00pm','09:00am',-1,'static/15/EventHall.jpg','ND','ND','INVOICE15'),(17,16,'active','Meeting_Room','','The ritz corlton','19, 27th Cross Rd,Rajiv Gandhi Nagar, HSR Layout,Bengaluru, Karnataka 560068','19, 27th Cross Rd,Rajiv Gandhi Nagar, HSR Layout,Bengaluru, Karnataka 560068',12.9062885884999,77.6307202130556,'200','abhaybansod@gmail.com','11-04-2016 10:02',-1,'07:00pm','08:00am',-1,'static/16/mmetdd.jpg','ND','ND','INVOICE16'),(18,17,'active','Training Room','','galaxy','2004, 17th Main Rd,AECS Layout A-Block, Singasandra,Bengaluru, Karnataka 560068','2004, 17th Main Rd,AECS Layout A-Block, Singasandra,Bengaluru, Karnataka 560068',12.8833428180538,77.654430270195,'200','abhaybansod@gmail.com','11-04-2016 11:03',-1,'07:00pm','08:00am',-1,'','ND','ND','INVOICE17'),(19,18,'active','Plug & Play, Training Room','Coffee Shop','my_testinggg','HSR Layout','HSR Layout,Banglore',12.814941,77.674015,'200/Hr','abcxyz','15-04-2016 11:59',-1,'','',-1,'static/18/image2.png, static/18/image4.png, static/18/image5.png','ND','ND','INVOICE18'),(20,19,'active','Meeting_Room','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','20-04-2016 09:53',-1,'','',-1,'static/19/image2.png, static/19/image4.png, static/19/image5.png','ND','ND','INVOICE19'),(21,20,'active','Meeting_Room','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','20-04-2016 09:53',-1,'','',-1,'static/20/image2.png, static/20/image4.png, static/20/image5.png','ND','ND','INVOICE20'),(22,21,'active','Meeting_Room','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','20-04-2016 09:55',-1,'','',-1,'static/21/image2.png, static/21/image4.png, static/21/image5.png','ND','ND','-1'),(23,22,'active','Training Room','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','20-04-2016 10:09',-1,'','',-1,'static/22/image2.png, static/22/image4.png, static/22/image5.png','ND','ND','-1'),(24,23,'active','Training Room','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','20-04-2016 10:12',-1,'','',-1,'static/23/image2.png, static/23/image4.png, static/23/image5.png','ND','ND','-1'),(25,24,'active','Meeting_Room','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','20-04-2016 10:18',-1,'','',-1,'static/24/image2.png, static/24/image4.png, static/24/image5.png','ND','ND','-1'),(26,25,'active','Training Room','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','20-04-2016 10:22',-1,'','',-1,'static/25/image2.png, static/25/image4.png, static/25/image5.png','ND','ND','-1'),(27,26,'active','Training Room, Event_Hall','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','25-04-2016 09:50',-1,'','',-1,'static/26/image2.png, static/26/image4.png, static/26/image5.png','ND','ND','-1'),(28,27,'active','Training Room, Event_Hall','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','25-04-2016 09:53',-1,'','',-1,'static/27/image2.png, static/27/image4.png, static/27/image5.png','ND','ND','-1'),(29,28,'active','Training Room, Event_Hall','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','25-04-2016 09:54',-1,'','',-1,'static/28/image2.png, static/28/image4.png, static/28/image5.png','ND','ND','-1'),(30,29,'active','Training Room, Event_Hall','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','25-04-2016 09:56',-1,'','',-1,'static/29/image2.png, static/29/image4.png, static/29/image5.png','ND','ND','-1'),(31,30,'active','[u\'Training Room\', u\'Event_Hall\']','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','25-04-2016 09:57',-1,'','',-1,'static/30/image2.png, static/30/image4.png, static/30/image5.png','ND','ND','-1'),(32,31,'active','[u\'Training Room\', u\'Event_Hall\']','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','25-04-2016 09:58',-1,'','',-1,'static/31/image2.png, static/31/image4.png, static/31/image5.png','ND','ND','-1'),(33,32,'active','[u\'Training Room\', u\'Event_Hall\']','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','25-04-2016 10:02',-1,'','',-1,'static/32/image2.png, static/32/image4.png, static/32/image5.png','Event_Hall','ND','-1'),(34,33,'active','Training Room,Event_Hall','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','25-04-2016 10:09',-1,'','',-1,'static/33/image2.png, static/33/image4.png, static/33/image5.png','Event_Hall','ND','-1'),(35,34,'active','Event_Hall','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','25-04-2016 10:28',-1,'','',-1,'static/34/image2.png, static/34/image4.png, static/34/image5.png','Event_Hall','ND','-1'),(36,35,'active','Event_Hall','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','25-04-2016 10:29',-1,'','',-1,'static/35/image2.png, static/35/image4.png, static/35/image5.png','Event_Hall','ND','-1'),(37,36,'active','Training Room,Event_Hall','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','26-04-2016 10:01',-1,'','',-1,'static/36/image2.png, static/36/image4.png, static/36/image5.png','','good property..','-1'),(38,37,'active','Training Room,Event_Hall','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','26-04-2016 10:22',-1,'','',-1,'static/37/image2.png, static/37/image4.png, static/37/image5.png','','','-1'),(39,38,'active','Training Room,Event_Hall','co-working','my_testing','HSR Layout','HSR Layout,Banglore',12.914941,77.574015,'200/Hr','abcxyz','28-04-2016 07:02',-1,'','',-1,'static/38/image2.png, static/38/image4.png, static/38/image5.png','','','-1');

--
-- Table structure for table `BizPit_app_property_facility`
--

CREATE TABLE `BizPit_app_property_facility` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `Wifi` tinyint(1) NOT NULL,
  `Coffee_tea` tinyint(1) NOT NULL,
  `Water_bottle` tinyint(1) NOT NULL,
  `Printer` tinyint(1) NOT NULL,
  `Charging_Point` tinyint(1) NOT NULL,
  `Changing_room` tinyint(1) NOT NULL,
  `Library` tinyint(1) NOT NULL,
  `Massage_chair` tinyint(1) NOT NULL,
  `Locker` tinyint(1) NOT NULL,
  `AC` tinyint(1) NOT NULL,
  `Hourly_deal` tinyint(1) NOT NULL,
  `Half_day_deal` tinyint(1) NOT NULL,
  `Full_day_deal` tinyint(1) NOT NULL,
  `Projector` tinyint(1) NOT NULL,
  `Projection_screen` tinyint(1) NOT NULL,
  `PA_system` tinyint(1) NOT NULL,
  `PC_or_Laptop` tinyint(1) NOT NULL,
  `Seat_up` varchar(100) NOT NULL,
  `Chair` varchar(100) NOT NULL,
  `Stationary` varchar(100) NOT NULL,
  `Complemetry` varchar(100) NOT NULL,
  `Add_On` varchar(100) NOT NULL,
  `Meeting_room_images` longtext NOT NULL,
  `Conference_room_images` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_property_facility`
--

INSERT INTO `BizPit_app_property_facility` VALUES (1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,1,'ND','ND','ND','ND','ND','',''),(2,2,1,0,0,1,0,0,1,0,1,0,0,0,0,0,0,0,0,'ND','ND','basic','ND','ND','',''),(3,3,1,0,1,1,0,0,0,0,0,0,0,0,0,1,1,0,0,'common','ND','ND','ND','ND','',''),(5,4,1,0,1,0,1,0,0,0,0,0,0,0,0,1,1,0,1,'ND','ND','ND','ND','ND','',''),(6,5,1,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(7,6,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(8,7,1,0,1,0,1,0,0,0,0,1,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(9,8,1,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,'common','ND','ND','ND','ND','',''),(10,9,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(11,10,1,0,1,0,1,0,0,0,0,1,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(12,11,1,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,'common','ND','ND','ND','ND','',''),(13,12,1,1,1,1,0,0,0,0,1,0,0,0,0,0,0,0,1,'ND','ND','ND','ND','ND','',''),(14,13,0,0,0,0,1,0,0,0,1,0,0,0,0,1,1,0,1,'common','ND','ND','ND','ND','',''),(15,14,1,0,0,1,1,0,0,0,0,1,0,0,0,0,0,0,0,'common','ND','basic','ND','ND','',''),(16,15,1,0,0,1,0,0,1,0,0,1,0,0,0,1,1,0,0,'ND','ND','ND','ND','ND','',''),(17,16,1,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'common','ND','ND','ND','ND','',''),(18,17,1,0,1,1,0,0,1,0,1,1,0,0,0,0,0,0,1,'ND','ND','ND','ND','ND','',''),(19,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(20,19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(21,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(22,21,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(23,22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(24,23,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(25,24,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(26,25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(27,26,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(28,27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(29,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(30,29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(31,30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(32,31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(33,32,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(34,33,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(35,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(36,35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(37,36,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(38,37,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','',''),(39,38,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'ND','ND','ND','ND','ND','','');

--
-- Table structure for table `BizPit_app_property_tags`
--

CREATE TABLE `BizPit_app_property_tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `Label` varchar(500) NOT NULL,
  `Usecase` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_property_tags`
--


--
-- Table structure for table `BizPit_app_rate_comment`
--

CREATE TABLE `BizPit_app_rate_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `comment` varchar(100) NOT NULL,
  `rates` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_rate_comment`
--


--
-- Table structure for table `BizPit_app_shared_area`
--

CREATE TABLE `BizPit_app_shared_area` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `capacity` int(11) NOT NULL,
  `rate_hr` int(11) NOT NULL,
  `rate_daily` int(11) NOT NULL,
  `rate_weekly` int(11) NOT NULL,
  `rate_monthly` int(11) NOT NULL,
  `shared_images` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_shared_area`
--

INSERT INTO `BizPit_app_shared_area` VALUES (1,5,1,0,0,0,5000,''),(2,6,20,0,0,0,5997,''),(3,7,10,0,0,0,5000,''),(4,8,15,0,428,2314,7000,''),(5,9,1,250,0,0,0,''),(6,10,20,200,0,0,0,''),(7,11,10,0,300,0,4000,''),(8,18,50,200,300,3000,30000,'');

--
-- Table structure for table `BizPit_app_training_room`
--

CREATE TABLE `BizPit_app_training_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `capacity` int(11) NOT NULL,
  `training_room_no` int(11) NOT NULL,
  `rate_half_day` int(11) NOT NULL,
  `rate_full_day` int(11) NOT NULL,
  `rate_weekly` int(11) NOT NULL,
  `rate_monthly` int(11) NOT NULL,
  `training_room_images` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_training_room`
--

INSERT INTO `BizPit_app_training_room` VALUES (1,4,15,1,500,900,0,0,''),(2,12,10,1,500,0,0,0,''),(3,13,15,1,0,1000,0,0,''),(4,17,11,1,200,400,0,0,''),(5,18,50,1,500,1000,0,0,''),(6,22,50,1,200,1000,0,0,''),(7,22,10,2,500,0,0,0,''),(8,23,50,1,200,1000,0,0,''),(9,23,10,2,500,0,0,0,''),(10,25,50,1,200,1000,0,0,''),(11,25,10,2,500,0,0,0,''),(12,26,50,1,200,1000,0,0,''),(13,26,10,2,500,0,0,0,''),(14,27,50,1,200,1000,0,0,''),(15,27,10,2,500,0,0,0,''),(16,28,50,1,200,1000,0,0,''),(17,28,10,2,500,0,0,0,''),(18,29,50,1,200,1000,0,0,''),(19,29,10,2,500,0,0,0,''),(20,30,50,1,200,1000,0,0,''),(21,30,10,2,500,0,0,0,''),(22,31,50,1,200,1000,0,0,''),(23,31,10,2,500,0,0,0,''),(24,32,50,1,200,1000,0,0,''),(25,32,10,2,500,0,0,0,''),(26,33,50,1,200,1000,0,0,''),(27,33,10,2,500,0,0,0,''),(28,36,50,1,200,1000,0,0,''),(29,36,10,2,500,0,0,0,''),(30,37,50,1,200,1000,0,0,''),(31,37,10,2,500,0,0,0,''),(32,38,50,1,200,1000,0,0,''),(33,38,10,2,500,0,0,0,'');

--
-- Table structure for table `BizPit_app_user_share`
--

CREATE TABLE `BizPit_app_user_share` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `mobile_number` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_user_share`
--

INSERT INTO `BizPit_app_user_share` VALUES (1,1,2,'1234567890'),(2,5,2,'1234567890'),(3,1,2,'1234567890');

--
-- Table structure for table `BizPit_app_user_usage`
--

CREATE TABLE `BizPit_app_user_usage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `Action` varchar(100) NOT NULL,
  `Action_data` varchar(100) NOT NULL,
  `Action_timestamp` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_user_usage`
--


--
-- Table structure for table `BizPit_app_weekly_booking`
--

CREATE TABLE `BizPit_app_weekly_booking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `booked_by` varchar(100) DEFAULT NULL,
  `booked_by_id` int(11) DEFAULT NULL,
  `start_week` varchar(100) NOT NULL,
  `end_week` varchar(100) NOT NULL,
  `start_time` varchar(100) NOT NULL,
  `end_time` varchar(100) NOT NULL,
  `property_type` varchar(100) DEFAULT NULL,
  `head_count` int(11) NOT NULL,
  `timestamp` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BizPit_app_weekly_booking`
--


--
-- Table structure for table `auth_group`
--

CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_group`
--


--
-- Table structure for table `auth_group_permissions`
--

CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `group_id` (`group_id`,`permission_id`),
  KEY `auth_group_permissions_0e939a4f` (`group_id`),
  KEY `auth_group_permissions_8373b171` (`permission_id`),
  CONSTRAINT `auth_group_permission_group_id_689710a9a73b7457_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_group__permission_id_1f49ccbbdc69d2fc_fk_auth_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_group_permissions`
--


--
-- Table structure for table `auth_permission`
--

CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `content_type_id` (`content_type_id`,`codename`),
  KEY `auth_permission_417f1b1c` (`content_type_id`),
  CONSTRAINT `auth__content_type_id_508cf46651277a81_fk_django_content_type_id` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_permission`
--

INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can add permission',2,'add_permission'),(5,'Can change permission',2,'change_permission'),(6,'Can delete permission',2,'delete_permission'),(7,'Can add group',3,'add_group'),(8,'Can change group',3,'change_group'),(9,'Can delete group',3,'delete_group'),(10,'Can add user',4,'add_user'),(11,'Can change user',4,'change_user'),(12,'Can delete user',4,'delete_user'),(13,'Can add content type',5,'add_contenttype'),(14,'Can change content type',5,'change_contenttype'),(15,'Can delete content type',5,'delete_contenttype'),(16,'Can add session',6,'add_session'),(17,'Can change session',6,'change_session'),(18,'Can delete session',6,'delete_session'),(19,'Can add property_ details',7,'add_property_details'),(20,'Can change property_ details',7,'change_property_details'),(21,'Can delete property_ details',7,'delete_property_details'),(22,'Can add booking_ type',8,'add_booking_type'),(23,'Can change booking_ type',8,'change_booking_type'),(24,'Can delete booking_ type',8,'delete_booking_type'),(25,'Can add holidays',9,'add_holidays'),(26,'Can change holidays',9,'change_holidays'),(27,'Can delete holidays',9,'delete_holidays'),(31,'Can add property_tags',11,'add_property_tags'),(32,'Can change property_tags',11,'change_property_tags'),(33,'Can delete property_tags',11,'delete_property_tags'),(34,'Can add login',12,'add_login'),(35,'Can change login',12,'change_login'),(36,'Can delete login',12,'delete_login'),(37,'Can add sign_ up',13,'add_sign_up'),(38,'Can change sign_ up',13,'change_sign_up'),(39,'Can delete sign_ up',13,'delete_sign_up'),(40,'Can add meeting_room',14,'add_meeting_room'),(41,'Can change meeting_room',14,'change_meeting_room'),(42,'Can delete meeting_room',14,'delete_meeting_room'),(43,'Can add training_room',15,'add_training_room'),(44,'Can change training_room',15,'change_training_room'),(45,'Can delete training_room',15,'delete_training_room'),(46,'Can add shared_area',16,'add_shared_area'),(47,'Can change shared_area',16,'change_shared_area'),(48,'Can delete shared_area',16,'delete_shared_area'),(49,'Can add event_ halls',17,'add_event_halls'),(50,'Can change event_ halls',17,'change_event_halls'),(51,'Can delete event_ halls',17,'delete_event_halls'),(52,'Can add commercial_ halls',18,'add_commercial_halls'),(53,'Can change commercial_ halls',18,'change_commercial_halls'),(54,'Can delete commercial_ halls',18,'delete_commercial_halls'),(55,'Can add property_ facility',19,'add_property_facility'),(56,'Can change property_ facility',19,'change_property_facility'),(57,'Can delete property_ facility',19,'delete_property_facility'),(58,'Can add payment',20,'add_payment'),(59,'Can change payment',20,'change_payment'),(60,'Can delete payment',20,'delete_payment'),(61,'Can add user_ usage',21,'add_user_usage'),(62,'Can change user_ usage',21,'change_user_usage'),(63,'Can delete user_ usage',21,'delete_user_usage'),(64,'Can add user_ details',22,'add_user_details'),(65,'Can change user_ details',22,'change_user_details'),(66,'Can delete user_ details',22,'delete_user_details'),(67,'Can add property_ capacity',23,'add_property_capacity'),(68,'Can change property_ capacity',23,'change_property_capacity'),(69,'Can delete property_ capacity',23,'delete_property_capacity'),(70,'Can add hourly_ booking',24,'add_hourly_booking'),(71,'Can change hourly_ booking',24,'change_hourly_booking'),(72,'Can delete hourly_ booking',24,'delete_hourly_booking'),(73,'Can add monthly_ booking',25,'add_monthly_booking'),(74,'Can change monthly_ booking',25,'change_monthly_booking'),(75,'Can delete monthly_ booking',25,'delete_monthly_booking'),(76,'Can add weekly_ booking',26,'add_weekly_booking'),(77,'Can change weekly_ booking',26,'change_weekly_booking'),(78,'Can delete weekly_ booking',26,'delete_weekly_booking'),(79,'Can add daily_ booking',27,'add_daily_booking'),(80,'Can change daily_ booking',27,'change_daily_booking'),(81,'Can delete daily_ booking',27,'delete_daily_booking'),(82,'Can add booking_ master_ table',28,'add_booking_master_table'),(83,'Can change booking_ master_ table',28,'change_booking_master_table'),(84,'Can delete booking_ master_ table',28,'delete_booking_master_table'),(85,'Can add dw m_ booking',29,'add_dwm_booking'),(86,'Can change dw m_ booking',29,'change_dwm_booking'),(87,'Can delete dw m_ booking',29,'delete_dwm_booking'),(88,'Can add hourly_ halfday_ booking',30,'add_hourly_halfday_booking'),(89,'Can change hourly_ halfday_ booking',30,'change_hourly_halfday_booking'),(90,'Can delete hourly_ halfday_ booking',30,'delete_hourly_halfday_booking'),(91,'Can add login request responses',31,'add_loginrequestresponses'),(92,'Can change login request responses',31,'change_loginrequestresponses'),(93,'Can delete login request responses',31,'delete_loginrequestresponses'),(94,'Can add user settings request responses',32,'add_usersettingsrequestresponses'),(95,'Can change user settings request responses',32,'change_usersettingsrequestresponses'),(96,'Can delete user settings request responses',32,'delete_usersettingsrequestresponses'),(97,'Can add api access',33,'add_apiaccess'),(98,'Can change api access',33,'change_apiaccess'),(99,'Can delete api access',33,'delete_apiaccess'),(100,'Can add api key',34,'add_apikey'),(101,'Can change api key',34,'change_apikey'),(102,'Can delete api key',34,'delete_apikey'),(103,'Can add favourite',35,'add_favourite'),(104,'Can change favourite',35,'change_favourite'),(105,'Can delete favourite',35,'delete_favourite'),(106,'Can add non_ working_ days',36,'add_non_working_days'),(107,'Can change non_ working_ days',36,'change_non_working_days'),(108,'Can delete non_ working_ days',36,'delete_non_working_days'),(109,'Can add rate_ comment',37,'add_rate_comment'),(110,'Can change rate_ comment',37,'change_rate_comment'),(111,'Can delete rate_ comment',37,'delete_rate_comment'),(112,'Can add user_ share',38,'add_user_share'),(113,'Can change user_ share',38,'change_user_share'),(114,'Can delete user_ share',38,'delete_user_share');

--
-- Table structure for table `auth_user_groups`
--

CREATE TABLE `auth_user_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`group_id`),
  KEY `auth_user_groups_e8701ad4` (`user_id`),
  KEY `auth_user_groups_0e939a4f` (`group_id`),
  CONSTRAINT `auth_user_groups_group_id_33ac548dcf5f8e37_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_user_groups_user_id_4b5ed4ffdb8fd9b0_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_user_groups`
--


--
-- Table structure for table `auth_user_user_permissions`
--

CREATE TABLE `auth_user_user_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`permission_id`),
  KEY `auth_user_user_permissions_e8701ad4` (`user_id`),
  KEY `auth_user_user_permissions_8373b171` (`permission_id`),
  CONSTRAINT `auth_user_user_permissi_user_id_7f0938558328534a_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `auth_user_u_permission_id_384b62483d7071f0_fk_auth_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_user_user_permissions`
--


--
-- Table structure for table `django_admin_log`
--

CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime NOT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_417f1b1c` (`content_type_id`),
  KEY `django_admin_log_e8701ad4` (`user_id`),
  CONSTRAINT `django_admin_log_user_id_52fdd58701c5f563_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `djang_content_type_id_697914295151027a_fk_django_content_type_id` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `django_admin_log`
--


--
-- Table structure for table `django_content_type`
--

CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_45f3b1d93ec8c61c_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `django_content_type`
--

INSERT INTO `django_content_type` VALUES (1,'log entry','admin','logentry'),(2,'permission','auth','permission'),(3,'group','auth','group'),(4,'user','auth','user'),(5,'content type','contenttypes','contenttype'),(6,'session','sessions','session'),(7,'property_ details','BizPit_app','property_details'),(8,'booking_ type','BizPit_app','booking_type'),(9,'holidays','BizPit_app','holidays'),(11,'property_tags','BizPit_app','property_tags'),(12,'login','BizPit_app','login'),(13,'sign_ up','BizPit_app','sign_up'),(14,'meeting_room','BizPit_app','meeting_room'),(15,'training_room','BizPit_app','training_room'),(16,'shared_area','BizPit_app','shared_area'),(17,'event_ halls','BizPit_app','event_halls'),(18,'commercial_ halls','BizPit_app','commercial_halls'),(19,'property_ facility','BizPit_app','property_facility'),(20,'payment','BizPit_app','payment'),(21,'user_ usage','BizPit_app','user_usage'),(22,'user_ details','BizPit_app','user_details'),(23,'property_ capacity','BizPit_app','property_capacity'),(24,'hourly_ booking','BizPit_app','hourly_booking'),(25,'monthly_ booking','BizPit_app','monthly_booking'),(26,'weekly_ booking','BizPit_app','weekly_booking'),(27,'daily_ booking','BizPit_app','daily_booking'),(28,'booking_ master_ table','BizPit_app','booking_master_table'),(29,'dw m_ booking','BizPit_app','dwm_booking'),(30,'hourly_ halfday_ booking','BizPit_app','hourly_halfday_booking'),(31,'login request responses','BizPit_api_app','loginrequestresponses'),(32,'user settings request responses','BizPit_api_app','usersettingsrequestresponses'),(33,'api access','tastypie','apiaccess'),(34,'api key','tastypie','apikey'),(35,'favourite','BizPit_app','favourite'),(36,'non_ working_ days','BizPit_app','non_working_days'),(37,'rate_ comment','BizPit_app','rate_comment'),(38,'user_ share','BizPit_app','user_share');

--
-- Table structure for table `django_migrations`
--

CREATE TABLE `django_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `django_migrations`
--

INSERT INTO `django_migrations` VALUES (1,'BizPit_app','0001_initial','2016-02-25 07:34:15'),(2,'BizPit_app','0002_auto_20160212_0608','2016-02-25 07:34:15'),(3,'BizPit_app','0003_auto_20160212_0616','2016-02-25 07:34:15'),(4,'BizPit_app','0004_auto_20160212_0618','2016-02-25 07:34:15'),(5,'BizPit_app','0005_login','2016-02-25 07:34:15'),(6,'BizPit_app','0006_daily_booking_hourly_booking_monthly_booking_payment_property_capacity_property_facility_user_detail','2016-02-25 07:34:15'),(7,'BizPit_app','0007_auto_20160222_1217','2016-02-25 07:34:18'),(8,'BizPit_app','0008_auto_20160223_0617','2016-02-25 07:34:19'),(9,'BizPit_app','0009_sign_up','2016-02-25 07:34:19'),(10,'BizPit_app','0010_auto_20160224_1210','2016-02-25 07:34:19'),(11,'BizPit_app','0011_holidays_working_days','2016-02-25 07:34:20'),(12,'contenttypes','0001_initial','2016-02-25 07:34:20'),(13,'auth','0001_initial','2016-02-25 07:34:20'),(14,'admin','0001_initial','2016-02-25 07:34:20'),(15,'sessions','0001_initial','2016-02-25 07:34:20'),(16,'BizPit_api_app','0001_initial','2016-02-25 09:33:43'),(17,'tastypie','0001_initial','2016-02-25 09:33:43'),(18,'BizPit_app','0012_auto_20160304_0505','2016-03-04 05:05:35'),(19,'BizPit_app','0013_holidays_non_working_days','2016-03-08 09:44:29'),(20,'BizPit_app','0014_login_user_type','2016-04-11 10:50:56'),(21,'BizPit_app','0015_auto_20160411_1042','2016-04-11 10:50:56'),(22,'BizPit_app','0014_auto_20160323_0625','2016-04-13 06:50:16'),(23,'BizPit_app','0015_rate_comment','2016-04-13 06:55:31'),(24,'BizPit_app','0016_user_share','2016-04-13 06:55:31'),(25,'BizPit_app','0017_property_details_default_type','2016-04-25 10:02:21'),(26,'BizPit_app','0018_event_halls_room_no','2016-04-25 10:29:12'),(27,'BizPit_app','0019_property_details_description','2016-04-26 10:00:26'),(28,'BizPit_app','0020_auto_20160428_1025','2016-04-28 10:44:50'),(29,'BizPit_app','0021_remove_hourly_halfday_booking_room_no','2016-04-28 10:47:17'),(30,'BizPit_app','0022_hourly_halfday_booking_room_no','2016-04-28 10:47:44'),(31,'BizPit_app','0023_property_details_invoice_no','2016-05-03 05:28:35'),(32,'BizPit_app','0024_auto_20160503_0533','2016-05-03 05:33:47');

--
-- Table structure for table `tastypie_apiaccess`
--

CREATE TABLE `tastypie_apiaccess` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `request_method` varchar(10) NOT NULL,
  `accessed` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tastypie_apiaccess`
--



