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 `flatdata`
--

DROP TABLE IF EXISTS `flatdata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `flatdata` (
  `idflatno` smallint(6) NOT NULL,
  `isflatfreehold` tinyint(1) DEFAULT NULL,
  `datefreehold` date DEFAULT NULL,
  PRIMARY KEY (`idflatno`),
  UNIQUE KEY `idflatno_UNIQUE` (`idflatno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `flatdata`
--

LOCK TABLES `flatdata` WRITE;
/*!40000 ALTER TABLE `flatdata` DISABLE KEYS */;
INSERT INTO `flatdata` VALUES (111,0,NULL),(112,0,NULL),(113,0,NULL),(114,1,'2008-09-17'),(115,1,'2007-10-16'),(116,0,NULL),(121,1,'2011-11-30'),(122,0,NULL),(123,1,'2005-09-07'),(124,0,NULL),(125,1,'2010-08-31'),(126,0,NULL),(131,1,'2010-12-01'),(132,1,'2006-03-24'),(133,0,NULL),(134,0,NULL),(135,1,'2005-03-11'),(136,1,'2008-04-30'),(141,1,'2006-05-19'),(142,0,NULL),(143,1,'2012-01-17'),(144,1,'2007-11-23'),(145,0,NULL),(146,0,NULL),(151,0,NULL),(152,1,'2013-02-15'),(153,0,NULL),(154,1,'2007-09-11'),(155,1,'2014-04-01'),(156,1,'2009-03-31'),(161,0,NULL),(162,1,'2012-07-18'),(163,1,'2014-02-19'),(164,0,NULL),(165,1,'2014-02-18'),(166,1,'2013-05-14'),(171,1,'2012-12-12'),(172,0,NULL),(173,0,NULL),(174,0,NULL),(175,0,NULL),(176,1,'2007-04-04'),(181,1,'2008-07-08'),(182,1,'2005-06-01'),(183,0,NULL),(184,0,NULL),(185,1,'2006-05-19'),(186,0,NULL),(191,0,NULL),(192,1,'2005-12-13'),(193,1,'2006-03-22'),(194,0,NULL),(195,1,'2007-01-16'),(196,0,NULL),(211,0,NULL),(214,1,'2011-07-29'),(215,1,'2009-08-19'),(216,0,NULL),(221,1,'2004-11-11'),(222,0,NULL),(223,1,'2010-07-16'),(224,0,NULL),(225,0,NULL),(226,1,'2009-08-09'),(231,1,'2012-09-05'),(232,0,NULL),(233,1,'2004-08-06'),(234,0,NULL),(235,0,NULL),(236,0,NULL),(241,1,'2005-12-23'),(242,0,NULL),(243,1,'2013-11-19'),(244,0,NULL),(245,0,NULL),(246,0,NULL),(251,1,'2013-02-15'),(252,1,'2013-03-20'),(253,0,NULL),(254,1,'2009-03-13'),(255,1,'2010-07-13'),(256,0,NULL),(261,0,NULL),(262,1,'2006-03-24'),(263,0,NULL),(264,1,'2012-02-01'),(265,0,NULL),(266,1,'2011-10-21'),(271,0,NULL),(272,1,'2013-12-04'),(273,1,'2012-10-03'),(274,1,'2006-03-22'),(275,1,'2008-07-14'),(276,0,NULL),(281,0,NULL),(282,0,NULL),(283,1,'2007-06-28'),(284,0,NULL),(285,0,NULL),(286,1,'2013-10-25'),(291,1,'2011-02-04'),(292,0,NULL),(293,0,NULL),(294,1,'2012-01-18'),(295,0,NULL),(296,0,NULL);
/*!40000 ALTER TABLE `flatdata` 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:14
