   `balance_amount` double DEFAULT NULL,
   `balance_responsibility` tinyint(3) DEFAULT NULL COMMENT '1-company 2-customer',
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
 
 --
 -- Dumping data for table `balance`
 --
 
 INSERT INTO `balance` (`id`, `customer_id`, `balance_amount`, `balance_responsibility`) VALUES
-(1, 1, -16, NULL),
+(1, 1, 0, NULL),
 (2, 2, 0, NULL),
 (3, 3, 0, NULL),
 (4, 4, 0, NULL),
-(5, 5, 0, NULL),
-(6, 6, 0, NULL),
-(7, 7, 0, NULL);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `customer`
---
-
-CREATE TABLE IF NOT EXISTS `customer` (
+(5, 5, 0, NULL);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `customers`
+--
+
+CREATE TABLE IF NOT EXISTS `customers` (
   `id` bigint(20) NOT NULL AUTO_INCREMENT,
   `customer_firstname` varchar(100) DEFAULT NULL,
   `customer_middlename` varchar(200) NOT NULL,

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

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`id`, `customer_firstname`, `customer_middlename`, `customer_lastname`, `customer_email`, `customer_meter_no`, `customer_address`, `customer_contact`, `customer_birthdate`) VALUES
(1, 'Abella', '', 'Hector', NULL, 'EVER-100702374', 'SUNFLOWER', '09239117973', '1992-06-17'),
(2, 'Ritchie', '', 'Acilo', NULL, 'EVER-110102249', 'SUNFLOWER', '09223454555', '1989-12-28'),
(3, 'Vicente', '', 'Alaba', NULL, 'EVER 080805472', 'PHASE 2', '09062334357', '1988-12-30'),
(4, 'Juvelyn', '', 'Alferez', NULL, 'EVER- 111276275', 'SUNFLOWER', '09059876765', '1984-12-23'),
(5, 'Florifie', '', 'Batis', NULL, 'EVER- 05569', 'SINAI', '09876545456', '1990-12-23'),
(6, 'Darlito', '', 'Baula', NULL, 'EVER- 100308955', 'SUNFLOWER', '09876545654', '1991-12-22'),
(7, 'Dolly', '', 'Bautista', NULL, 'EVER- 08010000211', 'TABAYLAWON', '09568767656', '1995-12-23');

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


  `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=1 ;

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

