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

DROP TABLE IF EXISTS `watermeter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `watermeter` (
  `id_w_meter_read` int(11) NOT NULL AUTO_INCREMENT,
  `idownership` smallint(6) NOT NULL,
  `date_read` date DEFAULT NULL,
  `last_kl` decimal(10,0) DEFAULT NULL,
  `prsnt_kl` decimal(10,0) DEFAULT NULL,
  `remarks` varchar(45) DEFAULT NULL,
  `if_billed` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id_w_meter_read`),
  KEY `fk_watermeter_ownership1_idx` (`idownership`),
  CONSTRAINT `fk_Ownership_Watermeter` FOREIGN KEY (`idownership`) REFERENCES `ownership` (`idownership`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=213 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `watermeter`
--

LOCK TABLES `watermeter` WRITE;
/*!40000 ALTER TABLE `watermeter` DISABLE KEYS */;
INSERT INTO `watermeter` VALUES (1,1,'2014-04-30',328,340,NULL,1),(2,2,'2014-04-30',78,96,NULL,1),(3,116,'2014-04-30',1,1,NULL,1),(4,4,'2014-04-30',366,386,NULL,1),(5,147,'2014-04-30',499,529,NULL,1),(6,6,'2014-04-30',249,282,NULL,1),(7,133,'2014-04-30',545,574,NULL,1),(8,8,'2014-04-30',585,608,NULL,1),(9,9,'2014-04-30',188,199,NULL,1),(10,124,'2014-04-30',310,310,NULL,1),(11,142,'2014-04-30',471,498,NULL,1),(12,12,'2014-04-30',395,396,NULL,1),(13,145,'2014-04-30',119,134,NULL,1),(14,14,'2014-04-30',220,229,NULL,1),(15,15,'2014-04-30',279,283,NULL,1),(16,16,'2014-04-30',143,148,NULL,1),(17,17,'2014-04-30',429,456,NULL,1),(18,137,'2014-04-30',681,733,NULL,1),(19,143,'2014-04-30',244,260,NULL,1),(20,108,'2014-04-30',11,12,NULL,1),(21,117,'2014-04-30',389,405,NULL,1),(22,146,'2014-04-30',68,68,NULL,1),(23,127,'2014-04-30',167,176,NULL,1),(24,149,'2014-04-30',533,558,NULL,1),(25,25,'2014-04-30',145,145,NULL,1),(26,26,'2014-04-30',652,680,NULL,1),(27,27,'2014-04-30',436,456,NULL,1),(28,28,'2014-04-30',223,250,NULL,1),(29,29,'2014-04-30',551,578,NULL,1),(30,30,'2014-04-30',390,410,NULL,1),(31,31,'2014-04-30',575,609,NULL,1),(32,154,'2014-04-30',342,363,NULL,1),(33,33,'2014-04-30',236,261,NULL,1),(34,34,'2014-04-30',480,510,NULL,1),(35,35,'2014-04-30',511,535,NULL,1),(36,107,'2014-04-30',301,313,NULL,1),(37,37,'2014-04-30',601,627,NULL,1),(38,38,'2014-04-30',308,342,NULL,1),(39,39,'2014-04-30',372,392,NULL,1),(40,40,'2014-04-30',8,18,NULL,1),(41,139,'2014-04-30',4,4,NULL,1),(42,132,'2014-04-30',280,293,NULL,1),(43,43,'2014-04-30',322,334,NULL,1),(44,138,'2014-04-30',16,16,NULL,1),(45,45,'2014-04-30',395,415,NULL,1),(46,46,'2014-04-30',27,27,NULL,1),(47,47,'2014-04-30',242,245,NULL,1),(48,48,'2014-04-30',319,337,NULL,1),(49,49,'2014-04-30',187,199,NULL,1),(50,126,'2014-04-30',247,271,NULL,1),(51,51,'2014-04-30',688,725,NULL,1),(52,52,'2014-04-30',240,240,NULL,1),(53,53,'2014-04-30',378,401,NULL,1),(54,54,'2014-04-30',641,668,NULL,1),(55,55,'2014-04-30',527,562,NULL,1),(56,150,'2014-04-30',358,374,NULL,1),(57,148,'2014-04-30',309,322,NULL,1),(58,58,'2014-04-30',352,368,NULL,1),(59,131,'2014-04-30',259,263,NULL,1),(60,60,'2014-04-30',14,14,NULL,1),(61,61,'2014-04-30',194,199,NULL,1),(62,111,'2014-04-30',540,563,NULL,1),(63,63,'2014-04-30',680,721,NULL,1),(64,152,'2014-04-30',386,397,NULL,1),(65,125,'2014-04-30',230,240,NULL,1),(66,66,'2014-04-30',47,48,NULL,1),(67,110,'2014-04-30',359,372,NULL,1),(68,68,'2014-04-30',82,107,NULL,1),(69,69,'2014-04-30',646,673,NULL,1),(70,70,'2014-04-30',731,767,NULL,1),(71,120,'2014-04-30',0,0,NULL,1),(72,72,'2014-04-30',3,9,NULL,1),(73,112,'2014-04-30',277,312,NULL,1),(74,74,'2014-04-30',331,355,NULL,1),(75,128,'2014-04-30',733,769,NULL,1),(76,76,'2014-04-30',281,292,NULL,1),(77,77,'2014-04-30',404,419,NULL,1),(78,78,'2014-04-30',558,585,NULL,1),(79,79,'2014-04-30',115,153,NULL,1),(80,119,'2014-04-30',73,73,NULL,1),(81,121,'2014-04-30',83,91,NULL,1),(82,82,'2014-04-30',519,546,NULL,1),(83,83,'2014-04-30',228,241,NULL,1),(84,84,'2014-04-30',375,396,NULL,1),(85,85,'2014-04-30',549,570,NULL,1),(86,86,'2014-04-30',499,528,NULL,1),(87,123,'2014-04-30',602,606,NULL,1),(88,151,'2014-04-30',309,329,NULL,1),(89,89,'2014-04-30',430,486,NULL,1),(90,113,'2014-04-30',578,602,NULL,1),(91,91,'2014-04-30',91,99,NULL,1),(92,92,'2014-04-30',11,12,NULL,1),(93,93,'2014-04-30',443,462,NULL,1),(94,94,'2014-04-30',404,421,NULL,1),(95,95,'2014-04-30',228,242,NULL,1),(96,96,'2014-04-30',519,520,NULL,1),(97,134,'2014-04-30',425,445,NULL,1),(98,115,'2014-04-30',639,670,NULL,1),(99,109,'2014-04-30',8,13,NULL,1),(100,100,'2014-04-30',392,422,NULL,1),(101,101,'2014-04-30',416,470,NULL,1),(102,129,'2014-04-30',408,421,NULL,1),(103,103,'2014-04-30',470,491,NULL,1),(104,153,'2014-04-30',258,277,NULL,1),(105,105,'2014-04-30',0,13,NULL,1),(106,106,'2014-04-30',240,251,NULL,1),(107,1,'2014-05-31',340,365,NULL,1),(108,2,'2014-05-31',96,114,NULL,1),(109,116,'2014-05-31',1,1,NULL,1),(110,4,'2014-05-31',386,422,NULL,1),(111,147,'2014-05-31',529,557,NULL,1),(112,6,'2014-05-31',282,315,NULL,1),(113,133,'2014-05-31',574,612,NULL,1),(114,8,'2014-05-31',608,633,NULL,1),(115,9,'2014-05-31',199,206,NULL,1),(116,124,'2014-05-31',310,310,NULL,1),(117,142,'2014-05-31',498,512,NULL,1),(118,12,'2014-05-31',396,403,NULL,1),(119,145,'2014-05-31',134,141,NULL,1),(120,14,'2014-05-31',229,242,NULL,1),(121,15,'2014-05-31',283,283,NULL,1),(122,16,'2014-05-31',148,151,NULL,1),(123,17,'2014-05-31',456,476,NULL,1),(124,137,'2014-05-31',733,810,NULL,1),(125,143,'2014-05-31',260,281,NULL,1),(126,108,'2014-05-31',12,15,NULL,1),(127,117,'2014-05-31',405,422,NULL,1),(128,146,'2014-05-31',68,68,NULL,1),(129,127,'2014-05-31',176,185,NULL,1),(130,149,'2014-05-31',558,583,NULL,1),(131,25,'2014-05-31',145,145,NULL,1),(132,26,'2014-05-31',680,714,NULL,1),(133,27,'2014-05-31',456,477,NULL,1),(134,28,'2014-05-31',250,280,NULL,1),(135,29,'2014-05-31',578,605,NULL,1),(136,30,'2014-05-31',410,428,NULL,1),(137,31,'2014-05-31',609,613,NULL,1),(138,154,'2014-05-31',363,388,NULL,1),(139,33,'2014-05-31',261,281,NULL,1),(140,34,'2014-05-31',510,533,NULL,1),(141,35,'2014-05-31',535,536,NULL,1),(142,107,'2014-05-31',313,328,NULL,1),(143,37,'2014-05-31',627,654,NULL,1),(144,38,'2014-05-31',342,379,NULL,1),(145,39,'2014-05-31',392,411,NULL,1),(146,40,'2014-05-31',18,24,NULL,1),(147,139,'2014-05-31',4,4,NULL,1),(148,132,'2014-05-31',293,306,NULL,1),(149,43,'2014-05-31',334,349,NULL,1),(150,138,'2014-05-31',16,16,NULL,1),(151,45,'2014-05-31',415,433,NULL,1),(152,46,'2014-05-31',27,27,NULL,1),(153,47,'2014-05-31',245,245,NULL,1),(154,48,'2014-05-31',337,355,NULL,1),(155,49,'2014-05-31',199,226,NULL,1),(156,126,'2014-05-31',271,289,NULL,1),(157,51,'2014-05-31',725,755,NULL,1),(158,52,'2014-05-31',240,240,NULL,1),(159,53,'2014-05-31',401,425,NULL,1),(160,54,'2014-05-31',668,709,NULL,1),(161,55,'2014-05-31',562,594,NULL,1),(162,150,'2014-05-31',374,391,NULL,1),(163,148,'2014-05-31',322,336,NULL,1),(164,58,'2014-05-31',368,382,NULL,1),(165,131,'2014-05-31',263,275,NULL,1),(166,60,'2014-05-31',14,14,NULL,1),(167,61,'2014-05-31',199,202,NULL,1),(168,111,'2014-05-31',563,590,NULL,1),(169,63,'2014-05-31',721,764,NULL,1),(170,152,'2014-05-31',397,407,NULL,1),(171,125,'2014-05-31',240,251,NULL,1),(172,66,'2014-05-31',48,53,NULL,1),(173,110,'2014-05-31',372,393,NULL,1),(174,68,'2014-05-31',107,121,NULL,1),(175,69,'2014-05-31',673,703,NULL,1),(176,70,'2014-05-31',767,806,NULL,1),(177,120,'2014-05-31',0,4,NULL,1),(178,72,'2014-05-31',9,22,NULL,1),(179,112,'2014-05-31',312,346,NULL,1),(180,74,'2014-05-31',355,370,NULL,1),(181,128,'2014-05-31',769,805,NULL,1),(182,76,'2014-05-31',292,305,NULL,1),(183,77,'2014-05-31',419,435,NULL,1),(184,78,'2014-05-31',585,612,NULL,1),(185,79,'2014-05-31',153,194,NULL,1),(186,119,'2014-05-31',73,73,NULL,1),(187,121,'2014-05-31',91,106,NULL,1),(188,82,'2014-05-31',546,571,NULL,1),(189,83,'2014-05-31',241,259,NULL,1),(190,84,'2014-05-31',396,419,NULL,1),(191,85,'2014-05-31',570,591,NULL,1),(192,86,'2014-05-31',528,556,NULL,1),(193,123,'2014-05-31',606,612,NULL,1),(194,151,'2014-05-31',329,350,NULL,1),(195,89,'2014-05-31',486,550,NULL,1),(196,113,'2014-05-31',602,627,NULL,1),(197,91,'2014-05-31',99,107,NULL,1),(198,92,'2014-05-31',12,12,NULL,1),(199,93,'2014-05-31',462,490,NULL,1),(200,94,'2014-05-31',421,435,NULL,1),(201,95,'2014-05-31',242,259,NULL,1),(202,96,'2014-05-31',520,533,NULL,1),(203,134,'2014-05-31',445,465,NULL,1),(204,115,'2014-05-31',670,707,NULL,1),(205,109,'2014-05-31',13,20,NULL,1),(206,100,'2014-05-31',422,458,NULL,1),(207,101,'2014-05-31',470,533,NULL,1),(208,129,'2014-05-31',421,436,NULL,1),(209,103,'2014-05-31',491,517,NULL,1),(210,153,'2014-05-31',277,300,NULL,1),(211,105,'2014-05-31',13,29,NULL,1),(212,106,'2014-05-31',251,265,NULL,1);
/*!40000 ALTER TABLE `watermeter` 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:42
