| Server IP : 127.0.0.1 / Your IP : 216.73.216.48 Web Server : Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12 System : Windows NT DESKTOP-3H4FHQJ 10.0 build 19045 (Windows 10) AMD64 User : win 10 ( 0) PHP Version : 8.2.12 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : D:/bk up/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Apr 30, 2022 at 09:36 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 `previous_meter_readingtb` -- CREATE TABLE `previous_meter_readingtb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `previous_reading` varchar(255) NOT NULL, `cur_date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `previous_meter_readingtb` -- INSERT INTO `previous_meter_readingtb` (`id`, `user_id`, `previous_reading`, `cur_date`) VALUES (1, '4', '4', '2022-04-28'), (2, '3', '9', '2022-04-28'); -- -------------------------------------------------------- -- -- Table structure for table `rent_receipttb` -- CREATE TABLE `rent_receipttb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `user_id` varchar(255) NOT NULL, `tenant_name` varchar(255) NOT NULL, `receipt_no` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `for_the_month` varchar(255) NOT NULL, `balance` varchar(255) NOT NULL, `rented_block` varchar(255) NOT NULL, `receipt_date` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_date` date NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `rent_receipttb` -- INSERT INTO `rent_receipttb` (`id`, `my_id`, `user_id`, `tenant_name`, `receipt_no`, `amount`, `for_the_month`, `balance`, `rented_block`, `receipt_date`, `cur_city`, `cur_country`, `cur_date`, `cur_time`) VALUES (8, '1', '3', 'Matovu Amis', '002', '200000', 'May', 'none', 'SN UNIT 2', '21/04/2022', '', '', '2022-04-27', '13:26:15'), (9, '1', '4', 'Recheal Magola', '004', '200000', 'July', 'none', 'SN UNIT 1', '25/04/2022', '', '', '2022-04-27', '14:11:48'), (10, '1', '3', 'Matovu Amis', '005', '200000', 'June', 'none', 'SN UNIT 2', '20/05/2022', '', '', '2022-04-27', '14:22:10'), (11, '1', '4', 'Recheal Magola', '6', '200000', 'July', 'None', 'SN UNIT 1', '12/04/2022', '', '', '2022-04-30', '10:19:11'); -- -------------------------------------------------------- -- -- Table structure for table `sn_admintb` -- CREATE TABLE `sn_admintb` ( `id` int(11) NOT NULL, `adm_name` varchar(255) NOT NULL, `adm_idno` varchar(255) NOT NULL, `adm_mob_no` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_date` date NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sn_admintb` -- INSERT INTO `sn_admintb` (`id`, `adm_name`, `adm_idno`, `adm_mob_no`, `cur_city`, `cur_country`, `cur_date`, `cur_time`) VALUES (1, 'Kat Cent', 'CM44', '0751045153', 'Kampala', 'Uganda', '2022-04-26', '16:41:14'); -- -------------------------------------------------------- -- -- Table structure for table `sn_tenanttb` -- CREATE TABLE `sn_tenanttb` ( `id` int(11) NOT NULL, `tenant_name` varchar(255) NOT NULL, `tenant_id_no` varchar(255) NOT NULL, `tenant_mob_no` varchar(255) NOT NULL, `rented_sn_unit` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_date` date NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sn_tenanttb` -- INSERT INTO `sn_tenanttb` (`id`, `tenant_name`, `tenant_id_no`, `tenant_mob_no`, `rented_sn_unit`, `cur_city`, `cur_country`, `cur_date`, `cur_time`) VALUES (3, 'Matovu Amis', 'CM66', '07589899878', 'SN UNIT 2', '', '', '2022-04-26', '18:39:54'), (4, 'Recheal Magola', 'CM77', '656565656', 'SN UNIT 1', '', '', '2022-04-26', '18:57:26'), (5, 'Kato Ben', 'CM99', '546465', 'SN UNIT 1', '', '', '2022-04-28', '23:40:24'); -- -------------------------------------------------------- -- -- 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, `price_per_unit` 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, `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`, `price_per_unit`, `service_charge`, `vat_charge`, `for_the_month_of`, `rented_block`, `cur_citty`, `cur_counrty`, `cur_date`, `cur_time`) VALUES (10, '1', '3', 'Matovu Amis', '2', '1', '26/05/2022', '4220', '2000', '00', 'Feb', 'SN UNIT 2', '', '', '2022-04-28', '13:52:48'), (11, '1', '4', 'Recheal Magola', '3', '1', '11/02/2022', '4220', '2000', '00', 'Jan', 'SN UNIT 1', '', '', '2022-04-28', '13:57:30'), (12, '1', '4', 'Recheal Magola', '4', '3', '20/08/2022', '4220', '2000', '00', 'June', 'SN UNIT 1', '', '', '2022-04-28', '13:58:50'), (13, '1', '3', 'Matovu Amis', '2', '1', '21/04/2022', '4220', '2000', '00', 'May', 'SN UNIT 2', '', '', '2022-04-30', '10:23:41'), (14, '1', '3', 'Matovu Amis', '4', '2', '21/05/2022', '4220', '2000', '00', 'May', 'SN UNIT 2', '', '', '2022-04-30', '10:27:57'), (15, '1', '3', 'Matovu Amis', '6', '4', '21/06/2022', '4220', '2000', '00', 'July', 'SN UNIT 2', '', '', '2022-04-30', '10:28:56'), (16, '1', '3', 'Matovu Amis', '9', '6', '21/07/2022', '4220', '2000', '00', 'August ', 'SN UNIT 2', '', '', '2022-04-30', '10:29:46'); -- -- Indexes for dumped tables -- -- -- Indexes for table `previous_meter_readingtb` -- ALTER TABLE `previous_meter_readingtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `rent_receipttb` -- ALTER TABLE `rent_receipttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sn_admintb` -- ALTER TABLE `sn_admintb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sn_tenanttb` -- ALTER TABLE `sn_tenanttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sn_water_billingtb` -- ALTER TABLE `sn_water_billingtb` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `previous_meter_readingtb` -- ALTER TABLE `previous_meter_readingtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `rent_receipttb` -- ALTER TABLE `rent_receipttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `sn_admintb` -- ALTER TABLE `sn_admintb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `sn_tenanttb` -- ALTER TABLE `sn_tenanttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `sn_water_billingtb` -- ALTER TABLE `sn_water_billingtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; 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 */;