-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 20, 2022 at 02:31 PM
-- Server version: 10.4.21-MariaDB
-- PHP Version: 8.0.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `sn_redb`
--

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

--
-- Table structure for table `sn_water_billingtb`
--

CREATE TABLE `sn_water_billingtb` (
  `id` int(11) NOT NULL,
  `my_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `tenant_name` varchar(255) NOT NULL,
  `cur_meter_reading` varchar(255) NOT NULL,
  `previous_m_reading` varchar(255) NOT NULL,
  `meter_reading_date` varchar(255) NOT NULL,
  `total_due` varchar(255) NOT NULL,
  `paid_amount` varchar(255) NOT NULL,
  `calculated_amount` varchar(255) NOT NULL,
  `service_charge` varchar(255) NOT NULL,
  `vat_charge` varchar(255) NOT NULL,
  `for_the_month_of` varchar(255) NOT NULL,
  `rented_block` varchar(255) NOT NULL,
  `pay_status` varchar(255) NOT NULL,
  `cur_citty` varchar(255) NOT NULL,
  `cur_counrty` varchar(255) NOT NULL,
  `cur_date` date NOT NULL,
  `cur_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sn_water_billingtb`
--

INSERT INTO `sn_water_billingtb` (`id`, `my_id`, `user_id`, `tenant_name`, `cur_meter_reading`, `previous_m_reading`, `meter_reading_date`, `total_due`, `paid_amount`, `calculated_amount`, `service_charge`, `vat_charge`, `for_the_month_of`, `rented_block`, `pay_status`, `cur_citty`, `cur_counrty`, `cur_date`, `cur_time`) VALUES
(89, '1', '6', 'Mugisha ismail', '2', '0', '02', '10431.2', '', '10431.2', '400', '1591.2', 'August', 'SN UNIT 2', 'Not Paid', '', '', '2022-05-20', '15:01:40'),
(90, '1', '6', 'Mugisha ismail', '', '', '01/Mar/2022', '', '4000', '6431.2', '', '', '', 'SN UNIT 2', 'Paid', '', '', '2022-05-20', '15:02:17'),
(91, '', '6', 'Mugisha ismail', '3', '2', '05/Jun/2022', '5451.6', '', '11882.8', '400', '831.6', 'May', 'SN UNIT 2', 'Not Paid', '', '', '2022-05-20', '15:05:23'),
(92, '', '7', 'Paul kamba', '3', '0', '07', '15410.8', '', '15410.8', '400', '2350.8', 'March', 'SN UNIT 3', 'Not Paid', '', '', '2022-05-20', '15:07:01'),
(93, '1', '5', 'Kato Ben', '2', '0', '05', '10431.2', '', '10431.2', '400', '1591.2', 'March', 'SN UNIT 1', 'Not Paid', '', '', '2022-05-20', '15:08:12'),
(94, '1', '5', 'Kato Ben', '2', '2', '05/Apr/2022', '472', '', '10903.2', '400', '72', 'March', 'SN UNIT 1', 'Not Paid', '', '', '2022-05-20', '15:09:26'),
(95, '1', '5', 'Kato Ben', '', '', '07/Jul/2022', '', '22000', '-11096.8', '', '', '', 'SN UNIT 1', 'Paid', '', '', '2022-05-20', '15:12:09');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `sn_water_billingtb`
--
ALTER TABLE `sn_water_billingtb`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `sn_water_billingtb`
--
ALTER TABLE `sn_water_billingtb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=96;
COMMIT;

/*!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 */;