CREATE DATABASE  IF NOT EXISTS `unitedcghs` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `unitedcghs`;
-- MySQL dump 10.13  Distrib 5.6.17, for Win32 (x86)
--
-- Host: 127.0.0.1    Database: unitedcghs
-- ------------------------------------------------------
-- Server version	5.6.15

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `occupancy`
--

DROP TABLE IF EXISTS `occupancy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `occupancy` (
  `idoccupancy` mediumint(9) NOT NULL AUTO_INCREMENT,
  `idflatno` smallint(6) DEFAULT NULL,
  `is_owner` tinyint(1) DEFAULT NULL,
  `title` varchar(4) DEFAULT NULL,
  `fullname` varchar(45) DEFAULT NULL,
  `date_occupied` date DEFAULT NULL,
  `date_vacated` date DEFAULT NULL,
  `current` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`idoccupancy`),
  KEY `fk_occupancy_flatdata1_idx` (`idflatno`),
  CONSTRAINT `fk_Occupancy_FlatData1` FOREIGN KEY (`idflatno`) REFERENCES `flatdata` (`idflatno`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `occupancy`
--

LOCK TABLES `occupancy` WRITE;
/*!40000 ALTER TABLE `occupancy` DISABLE KEYS */;
INSERT INTO `occupancy` VALUES (1,111,1,'Sh.','Vijay Narayan Singh',NULL,NULL,1),(2,112,1,'Sh.','Vinayak U Koundanya',NULL,NULL,1),(3,113,1,NULL,'Vacant',NULL,NULL,1),(4,114,0,'Sh.','Abhishek Pandey',NULL,NULL,1),(5,115,0,'Sh.','Achintya Chakravarty',NULL,NULL,1),(6,116,1,'Sh.','Hardit Singh Kanwal',NULL,NULL,1),(7,121,1,'Smt.','Anita Solanki',NULL,NULL,1),(8,122,0,'Sh.','Rahul Gupta',NULL,NULL,1),(9,123,1,'Sh.','ML Kapoor',NULL,NULL,1),(10,124,0,'Sh.','Kuldip Bhist',NULL,NULL,1),(11,125,0,'Sh.','Rajiv Dawar',NULL,NULL,1),(12,126,1,'Sh.','Rajeev Kaushal',NULL,NULL,1),(13,131,1,'Smt.','Sudha Mahajan',NULL,NULL,1),(14,132,1,'Sh.','Anurag Sinha',NULL,NULL,1),(15,133,1,NULL,'Vacant',NULL,NULL,1),(16,134,0,'Sh.','Rajat Bose',NULL,NULL,1),(17,135,1,'Sh.','GS Chawla',NULL,NULL,1),(18,136,0,'Sh.','KG Verma',NULL,NULL,1),(19,141,1,'Sh.','Sameer M Upadhyay',NULL,NULL,1),(20,142,1,NULL,'Vacant',NULL,NULL,1),(21,143,1,'Smt.','Renu Mitra',NULL,NULL,1),(22,144,1,'Dr','Prem Grover',NULL,NULL,1),(23,145,1,'Dr','RD Chauhan',NULL,NULL,1),(24,146,1,'Sh.','KB Sharma',NULL,NULL,1),(25,151,1,NULL,'Vacant',NULL,NULL,1),(26,152,1,'Sh.','HC Juneja',NULL,NULL,1),(27,153,1,'Sh.','RK Bakshi',NULL,NULL,1),(28,154,1,'Smt.','Ramkaur Deswal',NULL,NULL,1),(29,155,1,'Sh.','Prakash Chitnis',NULL,NULL,1),(30,156,1,'Smt.','Asha Rani Gulati',NULL,NULL,1),(31,161,1,'Smt.',' Tripti Das',NULL,NULL,1),(32,162,1,'Sh.','Prashant',NULL,NULL,1),(33,163,0,NULL,'Vishwa Jagriti Mission',NULL,NULL,1),(34,164,1,'Sh.','SS Sharma',NULL,NULL,1),(35,165,0,'Sh.','IJ Singh',NULL,NULL,1),(36,166,1,'Sh.','Sukhdev Jamdar',NULL,NULL,1),(37,171,1,'Smt.','Vasantha Venkataraman',NULL,NULL,1),(38,172,0,'Sh.','DD Sood',NULL,NULL,1),(39,173,0,'Sh.','Sunil Kumar',NULL,NULL,1),(40,174,1,'Sh.','Ramesh Chand',NULL,NULL,1),(41,175,1,NULL,'Vacant',NULL,NULL,1),(42,176,0,'Sh.','Ankur Gupta',NULL,NULL,1),(43,181,1,'Sh.','Sanjiv Aggarwal',NULL,NULL,1),(44,182,1,NULL,'Vacant',NULL,NULL,1),(45,183,1,'Sh.','Om Prakash Malik',NULL,NULL,1),(46,184,1,NULL,'Vacant',NULL,NULL,1),(47,185,1,'Sh.','PP Arora',NULL,NULL,1),(48,186,1,'Sh.','Mohan S Rawat',NULL,NULL,1),(49,191,1,'Sh.','Vacant',NULL,NULL,1),(50,192,1,'Sh.','Gopal & Pankaj Ahuja',NULL,NULL,1),(51,193,1,'Sh.','Deben Moza',NULL,NULL,1),(52,194,1,NULL,'Vacant',NULL,NULL,1),(53,195,1,'Smt.','Jessie John',NULL,NULL,1),(54,196,1,'Sh.','Krishna Kumar',NULL,NULL,1),(55,211,1,'Sh.','Sehdev S Arya',NULL,NULL,1),(56,214,1,'Smt.','Pushpa',NULL,NULL,1),(57,215,1,'Dr','Harjit Singh Mahay',NULL,NULL,1),(58,216,1,'Sh.','Sunirmal Kar',NULL,NULL,1),(59,221,1,'Sh.','HK Sachdeva & C Kanta',NULL,NULL,1),(60,222,1,NULL,'Vacant',NULL,NULL,1),(61,223,1,'Sh.','Pravakar Rath',NULL,NULL,1),(62,224,1,'Sh.','Avtar Singh',NULL,NULL,1),(63,225,0,'Sh.','Jasbeer Singh',NULL,NULL,1),(64,226,1,'Sh.','Bhupinder Kumar Verma',NULL,NULL,1),(65,231,1,'Sh.','SK Bajaj',NULL,NULL,1),(66,232,1,NULL,'Vacant',NULL,NULL,1),(67,233,1,'Smt.','Pushpa J Iyer',NULL,NULL,1),(68,234,0,'Smt.','Gargi Baggchi',NULL,NULL,1),(69,235,1,'Sh.','S Krishnan',NULL,NULL,1),(70,236,0,'Sh.','Deepak Taneja',NULL,NULL,1),(71,241,1,'Sh.','Amit Sethi',NULL,NULL,1),(72,242,1,NULL,'Vacant',NULL,NULL,1),(73,243,0,'Sh.','Sanjay Yadav',NULL,NULL,1),(74,244,1,'Dr','Sunil Saxena',NULL,NULL,1),(75,245,1,'Smt.','Madhubala',NULL,NULL,1),(76,246,0,'Sh.','Ram Kumar',NULL,NULL,1),(77,251,1,'Sh.','Sarvesh Kumar',NULL,NULL,1),(78,252,1,'Sh.','Umesh C Sinha',NULL,NULL,1),(79,253,1,'Sh.','Jaideep Hora',NULL,NULL,1),(80,254,0,'Smt.','Chandrakanta Vasudeva',NULL,NULL,1),(81,255,1,'Sh.','Mahinder S Sharma',NULL,NULL,1),(82,256,1,'Sh.','Ram Kumar',NULL,NULL,1),(83,261,0,'Sh.','Suresh Chandra Lenka',NULL,NULL,1),(84,262,1,'Sh.','Vipul Kumar Barai',NULL,NULL,1),(85,263,1,'Sh.','LK Walecha',NULL,NULL,1),(86,264,1,'Dr','Dr. Santimoy Chakravarty',NULL,NULL,1),(87,265,0,'Sh.','Vivek Kumar',NULL,NULL,1),(88,266,1,'Sh.','Prakash Chand Katoch',NULL,NULL,1),(89,271,1,'Sh.','Ramjas Yadav',NULL,NULL,1),(90,272,0,'Smt.','Shalini Bhisht',NULL,NULL,1),(91,273,1,NULL,'Vacant',NULL,NULL,1),(92,274,1,'Sh.','GS Janarthanan',NULL,NULL,1),(93,275,1,'Sh.','Suresh Gupta',NULL,NULL,1),(94,276,1,'Sh.','Ram Kumar Joshi',NULL,NULL,1),(95,281,1,'Sh.','Ashish Ghosh',NULL,NULL,1),(96,282,1,'Smt.','Tripta Devi',NULL,NULL,1),(97,283,0,'Sh.','Mehrotra',NULL,NULL,1),(98,284,1,'Sh.','Girish Ranjan Singh',NULL,NULL,1),(99,285,1,NULL,'Vacant',NULL,NULL,1),(100,286,0,'Sh.','Ganesh & Smt Sumati',NULL,NULL,1),(101,291,1,'Sh.','Rajesh Vashishta',NULL,NULL,1),(102,292,1,'Sh.','Attar Singh Rana',NULL,NULL,1),(103,293,1,'Sh.','Ravi Dutt',NULL,NULL,1),(104,294,0,'Sh.','Rahul Dutta',NULL,NULL,1),(105,295,1,'Sh.','Sanjay Kumar Jha',NULL,NULL,1),(106,296,0,'Sh.','Navin Sharma',NULL,NULL,1);
/*!40000 ALTER TABLE `occupancy` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2014-08-16 11:56:30
