 -- http://www.phpmyadmin.net
 --
 -- Host: 127.0.0.1
--- Generation Time: Sep 10, 2016 at 02:39 AM
+-- Generation Time: Dec 19, 2016 at 12:54 AM
 -- Server version: 5.5.27
 -- PHP Version: 5.4.7
 

  `customer_reading_amount` double DEFAULT NULL,
  `customer_reading_date` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `customer_reading`
--

INSERT INTO `customer_reading` (`id`, `customer_id`, `customer_reading_amount`, `customer_reading_date`) VALUES
(1, 1, 400, '9-2015'),
(2, 2, 230, '9-2015'),
(3, 3, 100, '9-2015'),
(4, 1, 200, '10-2015'),
(5, 1, 679, '11-2015');

-- --------------------------------------------------------


) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `customer_firstname`, `customer_middlename`, `customer_lastname`, `customer_email`, `customer_meter_no`, `customer_address`, `customer_contact`, `customer_birthdate`) VALUES
(2, 'Belucorass', 'Palautog', 'Belucora', NULL, '098-233-4345', 'Taga IT, unahan JP Morgans', '09334416469', '2016-09-07'),
(4, 'Jerodiaz4', 'Meguizo', 'Jerodiaz', NULL, '3445-3434-23', 'Candabong Dumanjug Cebu', '0923485485757', '2016-10-24'),
(5, '3johnrobert', 'pahayahay', 'jeroidiaz', 'johnrobert@gmail.com', '938JJJKJKJKJkk', 'Taga tapon', '09358439593439', '2016-12-15'),
(6, '4johnrobert', 'pahayahay', 'jeroidiaz', 'johnrobert@gmail.com', '938JJJKJKJKJ', 'Taga tapon', '09358439593439', '2016-12-15'),
(7, '5johnrobert', 'pahayahay', 'jeroidiaz', 'johnrobert@gmail.com', '938JJJKJKJKJs', 'Taga tapons', '09358439593439', '2016-12-15');

-- --------------------------------------------------------

