CREATE DATABASE  IF NOT EXISTS `rorach` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `rorach`;
-- MySQL dump 10.13  Distrib 5.6.27, for debian-linux-gnu (x86_64)
--
-- Host: 127.0.0.1    Database: rorach
-- ------------------------------------------------------
-- Server version	5.6.27-0ubuntu0.15.04.1

/*!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 `classes`
--

DROP TABLE IF EXISTS `classes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `classes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(45) DEFAULT NULL,
  `first_class` date DEFAULT NULL,
  `second_class` date DEFAULT NULL,
  `third_class` date DEFAULT NULL,
  `gestation` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `phone` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `classes`
--

LOCK TABLES `classes` WRITE;
/*!40000 ALTER TABLE `classes` DISABLE KEYS */;
INSERT INTO `classes` VALUES (37,'+254727880922','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(39,'+254726232757','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(40,'+254726445485','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(41,'+254725241082','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(42,'+254724261350','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(43,'+254724391897','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(44,'+254711135765','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(45,'+254725891571','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(46,'+254720130201','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(47,'+254722507596','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(48,'+254726374844','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(49,'+254727610512','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(50,'+254725573050','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(51,'+254727573314','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(52,'+254726149769','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(53,'+254720776768','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(54,'+254722986561','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(55,'+254723032614','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(56,'+254725805695','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(57,'+254715551400','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(58,'+254704365419','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(59,'+254720355604','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(60,'+254721552345','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(61,'+254773038928','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(62,'+254725406265','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(64,'+254713219901','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(65,'+254705741413','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(66,'+254724361569','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(67,'+254723940573','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(68,'+254726909441','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(69,'+254720233850','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(70,'+254721542927','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(71,'+254721748540','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(72,'+254723579571','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(73,'+254720392045','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(74,'+254721424282','2015-11-12','2015-11-19','2015-11-26','39.285714285714'),(75,'+254723489399','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(76,'+25479017186','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(78,'+254722546892','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(79,'+254706934340','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(80,'+254720527679','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(81,'+254723681598','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(82,'+254726965362','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(83,'+254719526711','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(84,'+254731358387','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(85,'+254722365077','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(86,'+254726009165','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(87,'+254726691212','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(88,'+254723625484','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(89,'+254724673947','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(90,'+254720950165','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(91,'+254722904544','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(92,'+254725200945','2015-11-21','2015-12-12','2016-01-02','0'),(93,'+254713871977','2015-11-07','2015-11-14','2015-11-21','38.428571428571'),(94,'+254710738881','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(95,'+254717111358','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(96,'+254729613781','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(97,'+254720346493','2015-11-07','2015-11-14','2015-11-21','38.571428571429'),(98,'+254713835021','2015-11-06','2015-11-13','2015-11-20','38.285714285714'),(99,'+254724228931','2015-10-10','2015-10-17','2015-10-24','34.428571428571'),(100,'+254721317505','2015-11-14','2015-11-21','2015-11-28','35.285714285714'),(101,'+254728419378','2015-11-14','2015-11-21','2015-11-28','35.428571428571'),(102,'+254724131861','2015-11-19','2015-11-26','2015-12-03','36');
/*!40000 ALTER TABLE `classes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `patients`
--

DROP TABLE IF EXISTS `patients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `patients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `dob` varchar(45) DEFAULT NULL,
  `phone` varchar(45) DEFAULT NULL,
  `address` varchar(45) DEFAULT NULL,
  `datejoined` date DEFAULT NULL,
  `parity` varchar(45) DEFAULT NULL,
  `abortions` varchar(45) DEFAULT NULL,
  `gravidity` varchar(45) DEFAULT NULL,
  `lmp` varchar(45) DEFAULT NULL,
  `edd` varchar(45) DEFAULT NULL,
  `gestation` varchar(45) DEFAULT NULL,
  `fname` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `phone` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `patients`
--

LOCK TABLES `patients` WRITE;
/*!40000 ALTER TABLE `patients` DISABLE KEYS */;
INSERT INTO `patients` VALUES (79,'<NAME>','29','+254727880922','Nairobi','2015-10-31','1','0','1','2015-02-04','2015-11-11','38.428571428571','Lilian'),(80,'<NAME>','31','+254727228198','Nairobi','2015-10-31','1','0','1','2015-10-31','2016-08-06','0','Josephine'),(81,'<NAME>','31','+254726232757','Nairobi','2015-10-31','0','0','0','2015-02-04','2015-11-11','38.428571428571','Virginia'),(82,'<NAME>','30','+254726445485','Nairobi','2015-10-31','1','1','2','2015-02-04','2015-11-11','38.428571428571','Ivy '),(83,'Kalama','29','+254725241082','Nairobi','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Lin<NAME>'),(84,'<NAME>','34','+25472426135','Nairobi','2015-10-31','2','2','4','2015-02-04','2015-11-11','38.428571428571','Josephine'),(85,'muthoni','28','+254724391897','Nairobi','2015-10-31','1','1','2','2015-02-04','2015-11-11','38.428571428571','Maureen'),(86,'<NAME>','20','+254711135765','Nairobi','2015-10-31','2','0','2','2015-02-04','2015-11-11','38.428571428571','Judith'),(87,'<NAME>','36','+254725891571','Nairobi','2015-10-31','1','0','1','2015-02-04','2015-11-11','38.428571428571','Rhoda'),(88,'<NAME>','35','+254720130201','Nairobi','2015-10-31','2','1','3','2015-02-03','2015-11-10','38.571428571429','Rachael '),(89,'Petronilla','40','+254722507596','Nairobi','2015-10-31','0','1','1','2015-02-04','2015-11-11','38.428571428571','Wanjiku'),(90,'<NAME>','25','+254726374844','Nairobi','2015-10-31','1','0','1','2015-02-03','2015-11-10','38.571428571429','Hilda'),(91,'Wamui','25','+254727610512','Nairobi','2015-10-31','0','0','0','2015-02-04','2015-11-11','38.428571428571','Tabitha'),(92,'Mumbi','30','+25472557305','','2015-10-31','1','0','1','2015-02-04','2015-11-11','38.428571428571','Mary'),(93,'Nyambogo','34','+254727573314','','2015-10-31','0','1','1','2015-02-04','2015-11-11','38.428571428571','Loise'),(94,'Kanana','31','+254726149769','Nairobi','2015-10-31','1','0','1','2015-02-03','2015-11-10','38.571428571429','Eunice'),(95,'Njambi','36','+254720776768','Nairobi','2015-10-31','1','0','1','2015-02-03','2015-11-10','38.571428571429','Nelly '),(96,'Njeri','31','+254722986561','Nairobi','2015-10-31','1','0','1','2015-02-04','2015-11-11','38.428571428571','<NAME>'),(97,'Odhiambo','33','+254723032614','Nairobi','2015-10-31','1','1','2','2015-02-03','2015-11-10','38.571428571429','Evelyn'),(98,'NJoki','38','+254725805695','','2015-10-31','1','0','1','2015-02-03','2015-11-10','38.571428571429','Veronicah'),(99,'Muraa','25','+2547155514','','2015-10-31','1','1','2','2015-02-03','2015-11-10','38.571428571429','Evelyn'),(100,'Musimbi','27','+254704365419','Nairobi','2015-10-31','1','0','1','2015-02-03','2015-11-10','38.571428571429','Sarah'),(101,'<NAME>','28','+254720355604','Nairobi','2015-10-31','1','0','1','2015-02-03','2015-11-10','38.571428571429','Virginia'),(102,'Koskei','34','+254721552345','Nairobi','2015-10-31','2','0','2','2015-02-03','2015-11-10','38.571428571429','Beverly'),(103,'Nyambene','41','+254773038928','Nairobi','2015-10-31','6','0','6','2015-02-03','2015-11-10','38.571428571429','Evelyn'),(104,'Kinyua','31','+254725406265','','2015-10-31','1','2','3','2015-02-03','2015-11-10','38.571428571429','Lilian'),(105,'Kamau','34','+254722106858','Nairobi','2015-10-31','0','0','0','2015-10-31','2016-08-06','0','Virginia'),(106,'<NAME>','25','+254713219901','Nairobi','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Serah'),(107,'Time ','21','+254705741413','','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Fatuma'),(108,'Achieng','28','+254724361569','Nairobi','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Beatrice'),(109,'Asman','35','+254723940573','Nairobi','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Zuhura'),(110,'Jento','27','+254726909441','Nairobi','2015-10-31','0','0','0','2015-02-04','2015-11-11','38.428571428571','Caroline'),(111,'Macharia','26','+25472023385','Nairobi','2015-10-31','0','0','0','2015-02-04','2015-11-11','38.428571428571','Cecilia'),(112,'Akinyi','40','+254721542927','Nairobi','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Lilian'),(113,'Njeri','23','+25472174854','Nairobi','2015-10-31','0','0','0','2015-02-04','2015-11-11','38.428571428571','Teresiah '),(114,'Nunga','27','+254723579571','Nairobi','2015-10-31','0','0','0','2015-02-04','2015-11-11','38.428571428571','Alice'),(115,'Njeri','40','+254720392045','Nairobi','2015-10-31','0','0','0','2015-02-04','2015-11-11','38.428571428571','Mercy'),(116,'<NAME>','40','+254721424282','Nairobi','0000-00-00','0','0','0','2015-02-03','2015-11-10','39.285714285714','Leah '),(117,'Adhiambo','33','+254723489399','Nairobi','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Pauline'),(118,'Wambui','26','+25479017186','','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Irene'),(120,'Simiyu','31','+254722546892','Nairobi','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Stellah'),(121,'Mogoi','29','+25470693434','Nairobi','2015-10-31','1','0','1','2015-02-03','2015-11-10','38.571428571429','Divinah'),(122,'Wanjiku','29','+254720527679','Nairobi','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Lucy'),(123,'Gesare','26','+254723681598','Nairobi','2015-10-31','0','0','0','2015-02-04','2015-11-11','38.428571428571','Mellen'),(124,'<NAME>','21','+254726965362','','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Elizabeth'),(125,' <NAME>','26','+254719526711','','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Shalet'),(126,'Bijuma','30','+254731358387','','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Faiza '),(127,'Ambetsa','31','+254722365077','','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Josephine'),(128,'Kedeveresia','26','+254726009165','','2015-10-31','0','0','0','2015-02-04','2015-11-11','38.428571428571','Vivian'),(129,'Juma','','+254726691212','','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Teresiah '),(130,'Macharia','33','+254723625484','','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Catherine'),(131,'Njemo','32','+254724673947','','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Evelyn'),(132,'Wambui','30','+254720950165','Nairobi','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Elizabeth'),(133,'Mumbi','36','+254722904544','','2015-10-31','0','0','0','2015-02-04','2015-11-11','38.428571428571','Beatrice'),(134,'Waitherero','','+254725200945','','2015-10-31','0','0','0','2015-10-31','2016-08-06','0','Esther '),(135,'Wambui','27','+254713871977','','2015-10-31','0','0','0','2015-02-04','2015-11-11','38.428571428571','Mary'),(136,'Gakii','26','+254710738881','','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Josline '),(137,'Kiprono','20','+254717111358','','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Maureen'),(139,'Kathoni','','+254720346493','','2015-10-31','0','0','0','2015-02-03','2015-11-10','38.571428571429','Sharon'),(140,'Wanjiku','27','+254713835021','Nairobi','2015-10-30','0','0','0','2015-02-04','2015-11-11','38.285714285714','Teresiah '),(141,'Ndarau','30','+254724228931','Nairobi','2015-10-03','0','0','0','2015-02-04','2015-11-11','34.428571428571','Joyce'),(142,'Wangui','28','+254721317505','Nairobi','2015-11-07','0','0','0','2015-03-05','2015-12-10','35.285714285714','Judy'),(143,'Ngendo','29','+254728419378','Nairobi','2015-11-07','0','0','0','2015-03-04','2015-12-09','35.428571428571','Mary'),(144,'Wilter','30','+254724131861','Nairobi','2015-11-12','0','0','0','2015-03-05','2015-12-10','36','Cherono');
/*!40000 ALTER TABLE `patients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(45) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email_UNIQUE` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'rose','123456'),(2,'cate','cate'),(3,'George','George');
/*!40000 ALTER TABLE `users` 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 2016-01-08 12:11:12
