download code – PHP Project – Employee management system
The Future of Tenant Management Systems
Tenant management systems are set to become even more advanced, offering tools that make managing properties easier and more efficient. Here’s what we can expect:
Integration with Smart Home Technology
Future systems may connect with smart home devices, enabling property managers to remotely monitor and control rental units. This could include features like automated temperature control, security monitoring, and energy management.
Predictive Analytics for Proactive Management
With predictive analytics, property managers will be able to spot potential problems and fix them before they happen. This could save time and money while ensuring tenant satisfaction.
AI and Machine Learning Advancements
As artificial intelligence (AI) and machine learning improve, tenant management systems will become smarter and more capable. They could handle tasks like automatically renewing leases, answering tenant questions, or even sending personalized updates to tenants without manual effort.
Maximizing Efficiency and Tenant Satisfaction
The ultimate goal is to give property managers the tools they need to run their properties more effectively, increase profits, and keep tenants happy. By adopting these new technologies, property management companies can stay competitive and provide excellent service to both landlords and tenants.
index.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 |
<!DOCTYPE html> <html lang="en"> <?php session_start(); ?> <head> <meta charset="utf-8"> <meta content="width=device-width, initial-scale=1.0" name="viewport"> <title><?php echo isset($_SESSION['system']['name']) ? $_SESSION['system']['name'] : '' ?></title> <?php if(!isset($_SESSION['login_id'])) header('location:login.php'); include('./header.php'); // include('./auth.php'); ?> </head> <style> body{ background: #80808045; } .modal-dialog.large { width: 80% !important; max-width: unset; } .modal-dialog.mid-large { width: 50% !important; max-width: unset; } #viewer_modal .btn-close { position: absolute; z-index: 999999; /*right: -4.5em;*/ background: unset; color: white; border: unset; font-size: 27px; top: 0; } #viewer_modal .modal-dialog { width: 80%; max-width: unset; height: calc(90%); max-height: unset; } #viewer_modal .modal-content { background: black; border: unset; height: calc(100%); display: flex; align-items: center; justify-content: center; } #viewer_modal img,#viewer_modal video{ max-height: calc(100%); max-width: calc(100%); } </style> <body> <?php include 'topbar.php' ?> <?php include 'navbar.php' ?> <div class="toast" id="alert_toast" role="alert" aria-live="assertive" aria-atomic="true"> <div class="toast-body text-white"> </div> </div> <main id="view-panel" > <?php $page = isset($_GET['page']) ? $_GET['page'] :'home'; ?> <?php include $page.'.php' ?> </main> <div id="preloader"></div> <a href="#" class="back-to-top"><i class="icofont-simple-up"></i></a> <div class="modal fade" id="confirm_modal" role='dialog'> <div class="modal-dialog modal-md" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title">Confirmation</h5> </div> <div class="modal-body"> <div id="delete_content"></div> </div> <div class="modal-footer"> <button type="button" class="btn btn-primary" id='confirm' onclick="">Continue</button> <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button> </div> </div> </div> </div> <div class="modal fade" id="uni_modal" role='dialog'> <div class="modal-dialog modal-md" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title"></h5> </div> <div class="modal-body"> </div> <div class="modal-footer"> <button type="button" class="btn btn-primary" id='submit' onclick="$('#uni_modal form').submit()">Save</button> <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button> </div> </div> </div> </div> <div class="modal fade" id="viewer_modal" role='dialog'> <div class="modal-dialog modal-md" role="document"> <div class="modal-content"> <button type="button" class="btn-close" data-dismiss="modal"><span class="fa fa-times"></span></button> <img src="" alt=""> </div> </div> </div> </body> <script> window.start_load = function(){ $('body').prepend('<di id="preloader2"></di>') } window.end_load = function(){ $('#preloader2').fadeOut('fast', function() { $(this).remove(); }) } window.viewer_modal = function($src = ''){ start_load() var t = $src.split('.') t = t[1] if(t =='mp4'){ var view = $("<video src='"+$src+"' controls autoplay></video>") }else{ var view = $("<img src='"+$src+"' />") } $('#viewer_modal .modal-content video,#viewer_modal .modal-content img').remove() $('#viewer_modal .modal-content').append(view) $('#viewer_modal').modal({ show:true, backdrop:'static', keyboard:false, focus:true }) end_load() } window.uni_modal = function($title = '' , $url='',$size=""){ start_load() $.ajax({ url:$url, error:err=>{ console.log() alert("An error occured") }, success:function(resp){ if(resp){ $('#uni_modal .modal-title').html($title) $('#uni_modal .modal-body').html(resp) if($size != ''){ $('#uni_modal .modal-dialog').addClass($size) }else{ $('#uni_modal .modal-dialog').removeAttr("class").addClass("modal-dialog modal-md") } $('#uni_modal').modal({ show:true, backdrop:'static', keyboard:false, focus:true }) end_load() } } }) } window._conf = function($msg='',$func='',$params = []){ $('#confirm_modal #confirm').attr('onclick',$func+"("+$params.join(',')+")") $('#confirm_modal .modal-body').html($msg) $('#confirm_modal').modal('show') } window.alert_toast= function($msg = 'TEST',$bg = 'success'){ $('#alert_toast').removeClass('bg-success') $('#alert_toast').removeClass('bg-danger') $('#alert_toast').removeClass('bg-info') $('#alert_toast').removeClass('bg-warning') if($bg == 'success') $('#alert_toast').addClass('bg-success') if($bg == 'danger') $('#alert_toast').addClass('bg-danger') if($bg == 'info') $('#alert_toast').addClass('bg-info') if($bg == 'warning') $('#alert_toast').addClass('bg-warning') $('#alert_toast .toast-body').html($msg) $('#alert_toast').toast({delay:3000}).toast('show'); } $(document).ready(function(){ $('#preloader').fadeOut('fast', function() { $(this).remove(); }) }) $('.datetimepicker').datetimepicker({ format:'Y/m/d H:i', startDate: '+3d' }) $('.select2').select2({ placeholder:"Please select here", width: "100%" }) </script> </html> |
login.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 |
<!DOCTYPE html> <html lang="en"> <?php session_start(); include('./db_connect.php'); ob_start(); if(!isset($_SESSION['system'])){ $system = $conn->query("SELECT * FROM system_settings limit 1")->fetch_array(); foreach($system as $k => $v){ $_SESSION['system'][$k] = $v; } } ob_end_flush(); ?> <head> <meta charset="utf-8"> <meta content="width=device-width, initial-scale=1.0" name="viewport"> <title><?php echo $_SESSION['system']['name'] ?></title> <?php include('./header.php'); ?> <?php if(isset($_SESSION['login_id'])) header("location:index.php?page=home"); ?> </head> <style> .field-icon { position: absolute; top: 18px; right: 30px; font-size: 20px; z-index: 2; } body{ /* width: 100%; height: calc(100%); background: #007bff; } main#main{ width:100%; height: calc(100%); background:white; } #login-right{ position: absolute; right:0; width:40%; height: calc(100%); background:white; display: flex; align-items: center; } #login-left{ position: absolute; left:0; width:60%; height: calc(100%); background:#59b6ec61; display: flex; align-items: center; background: url(assets/uploads/blood-cells.jpg); background-repeat: no-repeat; background-size: cover; } #login-right .card{ margin: auto; z-index: 1 } .logo { margin: auto; font-size: 8rem; background: white; padding: .5em 0.7em; border-radius: 50% 50%; color: #000000b3; z-index: 10; } div#login-right::before { content: ""; position: absolute; top: 0; left: 0; width: calc(100%); height: calc(100%); background: #000000e0; }*/ </style> <body> <main id="main" class="row bg-white"> <div class="col-md-6 p-0"> <div id="login-left" class="bg-white"> <img src="assets/img/login.jpg" width="100%" class="vh-100"> </div> </div> <div class="col-md-6"> <div class="text-center mb-5 pt-5"> <a href="index.php" class="logo logo-admin"><img src="assets/img/logo.png" alt="logo" width="250px"></a> </div> <div id="login-right" class="bg-white"> <div class="w-100"> <h4 class="text-dark text-center"><b><?php echo $_SESSION['system']['name'] ?></b></h4> <div class="card border-0 col-md-8 mx-auto"> <div class="card-body"> <form id="login-form" > <div class="form-group"> <label for="username" class="control-label">Username</label> <input type="text" id="username" name="username" class="form-control" placeholder="Username"> </div> <div class="form-group"> <label class="control-label">Password</label> <input type="password" id="password-field" name="password" class="form-control" placeholder="Password"> <!-- <span toggle="#password-field" class="fa fa-fw fa-eye field-icon toggle-password"></span> --> </div> <div class="g-recaptcha pb-3 mt-3" data-sitekey=""></div> <center><button class="btn btn-primary btn-block waves-effect waves-light py-2 btn-1">Login</button></center> </form> </div> </div> </div> </div> </div> </main> <a href="#" class="back-to-top"><i class="icofont-simple-up"></i></a> </body> <script src="https://www.google.com/recaptcha/api.js" async defer></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.7.1/jquery.min.js" integrity="sha512-v2CJ7UaYy4JwqLDIrZUI/4hqeoQieOmAZNXBeQyjo21dadnwR+8ZaIJVT8EE2iyI61OV8e6M8PP2/4hpQINQ/g==" crossorigin="anonymous" referrerpolicy="no-referrer"></script> <script> $('#login-form').submit(function(e){ e.preventDefault() $('#login-form button[type="button"]').attr('disabled',true).html('Logging in...'); if($(this).find('.alert-danger').length > 0 ) $(this).find('.alert-danger').remove(); $.ajax({ url:'ajax.php?action=login', method:'POST', data:$(this).serialize(), error:err=>{ console.log(err) $('#login-form button[type="button"]').removeAttr('disabled').html('Login'); }, success:function(resp){ if(resp == 1){ location.href ='index.php?page=home'; }else{ $('#login-form').prepend('<div class="alert alert-danger">Username or password is incorrect.</div>') $('#login-form button[type="button"]').removeAttr('disabled').html('Login'); } } }) }) </script> <script> $(".toggle-password").click(function() { $(this).toggleClass("fa-eye fa-eye-slash"); var input = $($(this).attr("toggle")); if (input.attr("type") == "password") { input.attr("type", "text"); } else { input.attr("type", "password"); } }); </script> </html> |
house_rental_latest.sql
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 |
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: May 14, 2024 at 03:26 PM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.2.4 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: `house_rental_latest` -- -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int(30) NOT NULL, `name` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `name`) VALUES (9, 'Single-Family Home'), (10, 'Apartment'), (11, 'Townhouse'), (12, 'Condominium'), (13, 'Duplex'), (14, 'Mobile Home'), (17, 'Tiny House'); -- -------------------------------------------------------- -- -- Table structure for table `houses` -- CREATE TABLE `houses` ( `id` int(30) NOT NULL, `house_no` varchar(50) NOT NULL, `category_id` int(30) NOT NULL, `description` text NOT NULL, `price` double NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `houses` -- INSERT INTO `houses` (`id`, `house_no`, `category_id`, `description`, `price`) VALUES (1, '123 Main St', 9, 'Beautiful single-family home with spacious backyard', 250000), (2, '456 Elm St', 10, 'Modern apartment in downtown area', 1500), (3, '789 Oak St', 11, 'Cozy townhouse with attached garage', 300000), (4, '101 Pine St', 12, 'Luxurious condominium with panoramic views', 500000), (5, '222 Maple St', 13, 'Well-maintained duplex with rental income potential', 200000), (6, '333 Cherry St', 14, 'Comfortable mobile home in a quiet community', 75000), (7, '444 Walnut St', 17, 'Charming tiny house with efficient design', 100000), (8, '555 Cedar St', 9, 'Spacious single-family home with modern amenities', 275000), (9, '666 Birch St', 10, 'Cozy apartment in a historic building', 1200), (10, '777 Spruce St', 11, 'Townhouse with backyard patio perfect for entertaining', 320000), (11, '888 Elmwood St', 12, 'Luxury condominium with 24/7 security and concierge service', 600000), (12, '999 Pineapple St', 13, 'Duplex with updated kitchen and bathrooms', 220000), (13, '111 Mango St', 14, 'Mobile home in a family-friendly community with swimming pool', 80000), (14, '222 Banana St', 17, 'Tiny house with loft bedroom and solar panels', 95000), (15, '333 Grape St', 9, 'Classic single-family home with original hardwood floors', 280000), (16, '444 Lemon St', 10, 'Bright and airy apartment with city views', 1600), (17, '555 Orange St', 11, 'Townhouse with spacious living area and attached garage', 330000), (18, '666 Peach St', 12, 'Condominium in a high-rise building with amenities', 550000), (19, '777 Plum St', 13, 'Duplex with separate entrances for each unit', 230000), (20, '888 Watermelon St', 14, 'Mobile home with updated interior and large deck', 85000); -- -------------------------------------------------------- -- -- Table structure for table `payments` -- CREATE TABLE `payments` ( `id` int(30) NOT NULL, `tenant_id` int(30) NOT NULL, `amount` float NOT NULL, `invoice` varchar(50) NOT NULL, `date_created` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `payments` -- INSERT INTO `payments` (`id`, `tenant_id`, `amount`, `invoice`, `date_created`) VALUES (1, 1, 1500, 'INV001', '2024-05-02 00:00:00'), (2, 2, 1200, 'INV002', '2024-05-04 00:00:00'), (3, 3, 1600, 'INV003', '2024-05-06 00:00:00'), (4, 4, 1800, 'INV004', '2024-05-08 00:00:00'), (5, 5, 1400, 'INV005', '2024-05-10 00:00:00'), (6, 6, 1700, 'INV006', '2024-05-12 00:00:00'), (7, 7, 1300, 'INV007', '2024-05-14 00:00:00'), (8, 8, 1900, 'INV008', '2024-05-16 00:00:00'), (9, 9, 1550, 'INV009', '2024-05-18 00:00:00'), (10, 10, 1250, 'INV010', '2024-05-20 00:00:00'), (11, 11, 1650, 'INV011', '2024-05-22 00:00:00'), (12, 12, 1350, 'INV012', '2024-05-24 00:00:00'), (13, 13, 1450, 'INV013', '2024-05-26 00:00:00'), (14, 14, 1700, 'INV014', '2024-05-28 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `system_settings` -- CREATE TABLE `system_settings` ( `id` int(30) NOT NULL, `name` text NOT NULL, `email` varchar(200) NOT NULL, `contact` varchar(20) NOT NULL, `cover_img` text NOT NULL, `about_content` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `system_settings` -- INSERT INTO `system_settings` (`id`, `name`, `email`, `contact`, `cover_img`, `about_content`) VALUES (1, 'House Rental Management System', 'info@sample.comm', '+6948 8542 623', '1603344720_1602738120_pngtree-purple-hd-business-banner-image_5493.jpg', '<p style="text-align: center; background: transparent; position: relative;"><span style="color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; text-align: justify;">&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span><br></p><p style="text-align: center; background: transparent; position: relative;"><br></p><p style="text-align: center; background: transparent; position: relative;"><br></p><p></p>'); -- -------------------------------------------------------- -- -- Table structure for table `tenants` -- CREATE TABLE `tenants` ( `id` int(30) NOT NULL, `firstname` varchar(100) NOT NULL, `middlename` varchar(100) NOT NULL, `lastname` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `contact` varchar(50) NOT NULL, `house_id` int(30) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 = active, 0= inactive', `date_in` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tenants` -- INSERT INTO `tenants` (`id`, `firstname`, `middlename`, `lastname`, `email`, `contact`, `house_id`, `status`, `date_in`) VALUES (1, 'Aarav', 'Kumar', 'Sharma', 'aarav.sharma@example.com', '+91-9876543210', 1, 1, '2024-05-01'), (2, 'Aadhya', 'Singh', 'Patel', 'aadhya.patel@example.com', '+91-8765432109', 2, 1, '2024-05-03'), (3, 'Advait', 'Gupta', 'Desai', 'advait.desai@example.com', '+91-7654321098', 3, 1, '2024-05-05'), (4, 'Ananya', 'Shah', 'Joshi', 'ananya.joshi@example.com', '+91-6543210987', 4, 1, '2024-05-07'), (5, 'Arnav', 'Patel', 'Khan', 'arnav.khan@example.com', '+91-5432109876', 5, 1, '2024-05-09'), (6, 'Aryan', 'Mishra', 'Shah', 'aryan.shah@example.com', '+91-4321098765', 6, 1, '2024-05-11'), (7, 'Avni', 'Verma', 'Singh', 'avni.singh@example.com', '+91-3210987654', 7, 1, '2024-05-13'), (8, 'Ishaan', 'Kumar', 'Mehta', 'ishaan.mehta@example.com', '+91-2109876543', 8, 1, '2024-05-15'), (9, 'Kabir', 'Malhotra', 'Gupta', 'kabir.gupta@example.com', '+91-1098765432', 9, 1, '2024-05-17'), (10, 'Kiara', 'Sharma', 'Singh', 'kiara.singh@example.com', '+91-0987654321', 10, 1, '2024-05-19'), (11, 'Reyaansh', 'Singh', 'Verma', 'reyaansh.verma@example.com', '+91-9876543210', 11, 1, '2024-05-21'), (12, 'Rhea', 'Patel', 'Sharma', 'rhea.sharma@example.com', '+91-8765432109', 12, 1, '2024-05-23'), (13, 'Rudra', 'Mishra', 'Kaur', 'rudra.kaur@example.com', '+91-7654321098', 13, 1, '2024-05-25'), (14, 'Saisha', 'Desai', 'Kumar', 'saisha.kumar@example.com', '+91-6543210987', 14, 1, '2024-05-27'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(30) NOT NULL, `name` text NOT NULL, `username` varchar(200) NOT NULL, `password` text NOT NULL, `type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '1=Admin,2=Staff' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `username`, `password`, `type`) VALUES (1, 'Administrator', 'mayuri.infospace@gmail.com', 'cd92a26534dba48cd785cdcc0b3e6bd1', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `houses` -- ALTER TABLE `houses` ADD PRIMARY KEY (`id`); -- -- Indexes for table `payments` -- ALTER TABLE `payments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `system_settings` -- ALTER TABLE `system_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tenants` -- ALTER TABLE `tenants` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `houses` -- ALTER TABLE `houses` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT for table `payments` -- ALTER TABLE `payments` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `system_settings` -- ALTER TABLE `system_settings` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tenants` -- ALTER TABLE `tenants` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; 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 */; |