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

DROP TABLE IF EXISTS `electricmeter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `electricmeter` (
  `id_e_meter_read` int(11) NOT NULL AUTO_INCREMENT,
  `idownership` smallint(6) DEFAULT NULL,
  `date_read` date DEFAULT NULL,
  `last_kwh` decimal(10,0) DEFAULT NULL,
  `prsnt_kwh` decimal(10,0) DEFAULT NULL,
  `remarks` varchar(45) DEFAULT NULL,
  `if_billed` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id_e_meter_read`),
  KEY `fk_electricmeter_ownership1_idx` (`idownership`),
  CONSTRAINT `fk_Ownership_Electricmeter` FOREIGN KEY (`idownership`) REFERENCES `ownership` (`idownership`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `electricmeter`
--

LOCK TABLES `electricmeter` WRITE;
/*!40000 ALTER TABLE `electricmeter` DISABLE KEYS */;
INSERT INTO `electricmeter` VALUES (1,4,'2014-03-04',30245,30279,NULL,1),(2,4,'2014-03-04',0,0,NULL,1),(3,68,'2014-04-13',54271,54271,NULL,1),(4,68,'2014-04-13',3,3,NULL,1),(5,1,'2014-04-30',39885,40092,NULL,1),(6,2,'2014-04-30',638,1178,NULL,1),(7,116,'2014-04-30',4815,4815,NULL,1),(8,4,'2014-04-30',0,245,NULL,1),(9,147,'2014-04-30',36541,36706,NULL,1),(10,6,'2014-04-30',9760,10244,NULL,1),(11,133,'2014-04-30',4524,4909,NULL,1),(12,8,'2014-04-30',24074,24550,NULL,1),(13,9,'2014-04-30',5589,5665,NULL,1),(14,124,'2014-04-30',67379,67379,NULL,1),(15,142,'2014-04-30',42051,42360,NULL,1),(16,12,'2014-04-30',61636,61781,NULL,1),(17,145,'2014-04-30',56651,56972,NULL,1),(18,14,'2014-04-30',13150,13401,NULL,1),(19,15,'2014-04-30',51531,51558,NULL,1),(20,16,'2014-04-30',69,69,NULL,1),(21,17,'2014-04-30',8184,8647,NULL,1),(22,137,'2014-04-30',43292,43793,NULL,1),(23,143,'2014-04-30',36439,36537,NULL,1),(24,108,'2014-04-30',6470,6531,NULL,1),(25,117,'2014-04-30',116,312,NULL,1),(26,146,'2014-04-30',74736,74784,NULL,1),(27,127,'2014-04-30',46403,46780,NULL,1),(28,149,'2014-04-30',697,975,NULL,1),(29,25,'2014-04-30',44669,44669,NULL,1),(30,26,'2014-04-30',60815,61406,NULL,1),(31,27,'2014-04-30',52585,52877,NULL,1),(32,28,'2014-04-30',2026,2346,NULL,1),(33,29,'2014-04-30',857,1140,NULL,1),(34,30,'2014-04-30',19015,19450,NULL,1),(35,31,'2014-04-30',24437,24922,NULL,1),(36,154,'2014-04-30',34904,35188,NULL,1),(37,33,'2014-04-30',4120,4886,NULL,1),(38,34,'2014-04-30',1223,1909,NULL,1),(39,35,'2014-04-30',77807,78049,NULL,1),(40,107,'2014-04-30',24657,24860,NULL,1),(41,37,'2014-04-30',506,742,NULL,1),(42,38,'2014-04-30',66524,67008,NULL,1),(43,39,'2014-04-30',4068,4298,NULL,1),(44,40,'2014-04-30',26409,26573,NULL,1),(45,139,'2014-04-30',32474,32474,NULL,1),(46,132,'2014-04-30',21437,21661,NULL,1),(47,43,'2014-04-30',2922,3064,NULL,1),(48,138,'2014-04-30',59021,59021,NULL,1),(49,45,'2014-04-30',44871,45300,NULL,1),(50,46,'2014-04-30',7659,7659,NULL,1),(51,47,'2014-04-30',11213,11252,NULL,1),(52,48,'2014-04-30',31138,31370,NULL,1),(53,49,'2014-04-30',26440,26494,NULL,1),(54,126,'2014-04-30',53159,53407,NULL,1),(55,51,'2014-04-30',2017,2538,NULL,1),(56,52,'2014-04-30',39086,39086,NULL,1),(57,53,'2014-04-30',56814,57589,NULL,1),(58,54,'2014-04-30',60173,60480,NULL,1),(59,55,'2014-04-30',31136,31418,NULL,1),(60,150,'2014-04-30',2951,3178,NULL,1),(61,148,'2014-04-30',73312,73747,NULL,1),(62,58,'2014-04-30',60,290,NULL,1),(63,131,'2014-04-30',7901,8003,NULL,1),(64,60,'2014-04-30',6357,6399,NULL,1),(65,61,'2014-04-30',20598,20679,NULL,1),(66,111,'2014-04-30',8648,8966,NULL,1),(67,63,'2014-04-30',54825,55183,NULL,1),(68,152,'2014-04-30',46699,46863,NULL,1),(69,125,'2014-04-30',25614,25792,NULL,1),(70,66,'2014-04-30',37038,37065,NULL,1),(71,110,'2014-04-30',28812,29041,NULL,1),(72,68,'2014-04-30',3,184,NULL,1),(73,69,'2014-04-30',21536,21899,NULL,1),(74,70,'2014-04-30',57861,58214,NULL,1),(75,120,'2014-04-30',33207,33302,NULL,1),(76,72,'2014-04-30',0,51,NULL,1),(77,112,'2014-04-30',20798,21284,NULL,1),(78,74,'2014-04-30',35669,36193,NULL,1),(79,128,'2014-04-30',20589,20896,NULL,1),(80,76,'2014-04-30',23655,23871,NULL,1),(81,77,'2014-04-30',71899,72426,NULL,1),(82,78,'2014-04-30',22593,22872,NULL,1),(83,79,'2014-04-30',74372,74761,NULL,1),(84,119,'2014-04-30',9306,9306,NULL,1),(85,121,'2014-04-30',41095,41284,NULL,1),(86,82,'2014-04-30',62862,63621,NULL,1),(87,83,'2014-04-30',20544,20690,NULL,1),(88,84,'2014-04-30',34982,35200,NULL,1),(89,85,'2014-04-30',5366,5658,NULL,1),(90,86,'2014-04-30',47918,48118,NULL,1),(91,123,'2014-04-30',0,5,NULL,1),(92,151,'2014-04-30',8987,9342,NULL,1),(93,89,'2014-04-30',83037,83422,NULL,1),(94,113,'2014-04-30',54448,54593,NULL,1),(95,91,'2014-04-30',334,562,NULL,1),(96,92,'2014-04-30',37850,37851,NULL,1),(97,93,'2014-04-30',66677,66948,NULL,1),(98,94,'2014-04-30',23145,23294,NULL,1),(99,95,'2014-04-30',15994,16208,NULL,1),(100,96,'2014-04-30',30623,30638,NULL,1),(101,134,'2014-04-30',18351,18704,NULL,1),(102,115,'2014-04-30',39614,39874,NULL,1),(103,109,'2014-04-30',1576,1664,NULL,1),(104,100,'2014-04-30',12372,13136,NULL,1),(105,101,'2014-04-30',1771,2424,NULL,1),(106,129,'2014-04-30',47187,47487,NULL,1),(107,103,'2014-04-30',53914,54250,NULL,1),(108,153,'2014-04-30',15938,16376,NULL,1),(109,105,'2014-04-30',50727,51033,NULL,1),(110,106,'2014-04-30',868,1169,NULL,1),(111,1,'2014-05-31',40092,40471,NULL,1),(112,2,'2014-05-31',1178,2184,NULL,1),(113,116,'2014-05-31',4815,4815,NULL,1),(114,4,'2014-05-31',245,1143,NULL,1),(115,147,'2014-05-31',36706,36976,NULL,1),(116,6,'2014-05-31',10244,11548,NULL,1),(117,133,'2014-05-31',4909,5448,NULL,1),(118,8,'2014-05-31',24550,25623,NULL,1),(119,9,'2014-05-31',5665,5763,NULL,1),(120,124,'2014-05-31',67379,67379,NULL,1),(121,142,'2014-05-31',42360,42369,NULL,1),(122,12,'2014-05-31',61781,62530,NULL,1),(123,145,'2014-05-31',56972,57422,NULL,1),(124,14,'2014-05-31',13401,13868,NULL,1),(125,15,'2014-05-31',51558,51558,NULL,1),(126,16,'2014-05-31',69,130,NULL,1),(127,17,'2014-05-31',8647,9354,NULL,1),(128,137,'2014-05-31',43793,44722,NULL,1),(129,143,'2014-05-31',36537,36852,NULL,1),(130,108,'2014-05-31',6531,6691,NULL,1),(131,117,'2014-05-31',312,1009,NULL,1),(132,146,'2014-05-31',74784,74843,NULL,1),(133,127,'2014-05-31',46780,47559,NULL,1),(134,149,'2014-05-31',975,1675,NULL,1),(135,25,'2014-05-31',44669,44669,NULL,1),(136,26,'2014-05-31',61406,62492,NULL,1),(137,27,'2014-05-31',52877,53572,NULL,1),(138,28,'2014-05-31',2346,3170,NULL,1),(139,29,'2014-05-31',1140,1590,NULL,1),(140,30,'2014-05-31',19450,20227,NULL,1),(141,31,'2014-05-31',24922,25668,NULL,1),(142,154,'2014-05-31',35188,35713,NULL,1),(143,33,'2014-05-31',4886,5313,NULL,1),(144,34,'2014-05-31',1909,2751,NULL,1),(145,35,'2014-05-31',78049,78049,NULL,1),(146,107,'2014-05-31',24860,25276,NULL,1),(147,37,'2014-05-31',742,1088,NULL,1),(148,38,'2014-05-31',67008,68057,NULL,1),(149,39,'2014-05-31',4298,4683,NULL,1),(150,40,'2014-05-31',26573,26897,NULL,1),(151,139,'2014-05-31',32474,32474,NULL,1),(152,132,'2014-05-31',21661,22138,NULL,1),(153,43,'2014-05-31',3064,3431,NULL,1),(154,138,'2014-05-31',59021,59021,NULL,1),(155,45,'2014-05-31',45300,45973,NULL,1),(156,46,'2014-05-31',7659,7659,NULL,1),(157,47,'2014-05-31',11252,11252,NULL,1),(158,48,'2014-05-31',31370,31761,NULL,1),(159,49,'2014-05-31',26494,27080,NULL,1),(160,126,'2014-05-31',53407,53759,NULL,1),(161,51,'2014-05-31',2538,3516,NULL,1),(162,52,'2014-05-31',39086,39086,NULL,1),(163,53,'2014-05-31',57589,58868,NULL,1),(164,54,'2014-05-31',60480,61081,NULL,1),(165,55,'2014-05-31',31418,31916,NULL,1),(166,150,'2014-05-31',3178,3775,NULL,1),(167,148,'2014-05-31',73747,74582,NULL,1),(168,58,'2014-05-31',290,740,NULL,1),(169,131,'2014-05-31',8003,8270,NULL,1),(170,60,'2014-05-31',6399,6456,NULL,1),(171,61,'2014-05-31',20679,20767,NULL,1),(172,111,'2014-05-31',8966,9759,NULL,1),(173,63,'2014-05-31',55183,55652,NULL,1),(174,152,'2014-05-31',46863,47333,NULL,1),(175,125,'2014-05-31',25792,26092,NULL,1),(176,66,'2014-05-31',37065,37424,NULL,1),(177,110,'2014-05-31',29041,29820,NULL,1),(178,68,'2014-05-31',184,705,NULL,1),(179,69,'2014-05-31',21899,22686,NULL,1),(180,70,'2014-05-31',58214,58785,NULL,1),(181,120,'2014-05-31',33302,33389,NULL,1),(182,72,'2014-05-31',51,280,NULL,1),(183,112,'2014-05-31',21284,22122,NULL,1),(184,74,'2014-05-31',36193,37167,NULL,1),(185,128,'2014-05-31',20896,21374,NULL,1),(186,76,'2014-05-31',23871,24328,NULL,1),(187,77,'2014-05-31',72426,73367,NULL,1),(188,78,'2014-05-31',22872,23342,NULL,1),(189,79,'2014-05-31',74761,75169,NULL,1),(190,119,'2014-05-31',9306,9306,NULL,1),(191,121,'2014-05-31',41284,41638,NULL,1),(192,82,'2014-05-31',63621,64592,NULL,1),(193,83,'2014-05-31',20690,20969,NULL,1),(194,84,'2014-05-31',35200,35751,NULL,1),(195,85,'2014-05-31',5658,6080,NULL,1),(196,86,'2014-05-31',48118,48673,NULL,1),(197,123,'2014-05-31',5,11,NULL,1),(198,151,'2014-05-31',9342,10035,NULL,1),(199,89,'2014-05-31',83422,84181,NULL,1),(200,113,'2014-05-31',54593,56148,NULL,1),(201,91,'2014-05-31',562,1198,NULL,1),(202,92,'2014-05-31',37851,37851,NULL,1),(203,93,'2014-05-31',66948,67602,NULL,1),(204,94,'2014-05-31',23294,23698,NULL,1),(205,95,'2014-05-31',16208,16553,NULL,1),(206,96,'2014-05-31',30638,30909,NULL,1),(207,134,'2014-05-31',18704,19213,NULL,1),(208,115,'2014-05-31',39874,40365,NULL,1),(209,109,'2014-05-31',1664,1848,NULL,1),(210,100,'2014-05-31',13136,14399,NULL,1),(211,101,'2014-05-31',2424,3720,NULL,1),(212,129,'2014-05-31',47487,48094,NULL,1),(213,103,'2014-05-31',54250,55082,NULL,1),(214,153,'2014-05-31',16376,17482,NULL,1),(215,105,'2014-05-31',51033,51712,NULL,1),(216,106,'2014-05-31',1169,1522,NULL,1);
/*!40000 ALTER TABLE `electricmeter` 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:55:59
