/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.16-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: weblinkltd_bms
-- ------------------------------------------------------
-- Server version	10.11.16-MariaDB

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `buildings`
--

DROP TABLE IF EXISTS `buildings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `buildings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `user_name` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `contact_no` varchar(100) DEFAULT NULL,
  `security_guard_mobile_no` varchar(100) DEFAULT NULL,
  `security_mobile_no` varchar(100) DEFAULT NULL,
  `moderator_mobile_no` varchar(100) DEFAULT NULL,
  `construction_year` year(4) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `company_phone_no` varchar(100) DEFAULT NULL,
  `company_address` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `user_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `buildings`
--

LOCK TABLES `buildings` WRITE;
/*!40000 ALTER TABLE `buildings` DISABLE KEYS */;
INSERT INTO `buildings` VALUES
(1,'Russel Park','russel123@gmail.com','russel123@gmail.com','$2y$10$yC69x2LDT2rKgwuYJw0ZOuoTZRnGviJGcRm31rn9.HXAVaFgKlhdC','01300432338',NULL,NULL,NULL,NULL,'Banani, Dhaka.','1667722565.jpg','AK Builders','01300432339','Banani, Dhaka.',1,1,'2022-11-06 08:16:05','2022-11-06 08:47:10'),
(2,'Jannatul Sifa','sifa@gmail.com','sifa@gmail.com','$2y$10$vX15XP3UOiM77D8OL/NT/OiJNUgt2WZ/RtIb4uzFyvQT2RrsSuVXS','012354',NULL,NULL,NULL,NULL,'Azimpur, Dhaka.','1667800191.jpg','SK Builders','01300432339','Banani, Dhaka.',1,1,'2022-11-07 05:49:51','2022-11-07 05:49:51'),
(3,'Masud Tower','info@masudtower.com','masudtower','$2y$10$w.jK6k9V8GG1HPX6jdNgU.FtY8HxeYOU4z63DDdq6aH3V7vaFBI42','01672315302',NULL,NULL,NULL,NULL,'Uttara','1668324694.jpg','Navana Group','01700000000','Dhanmondhi',1,1,'2022-11-13 07:31:34','2023-09-12 07:02:55'),
(4,'Rahman Tropical Tower','rahman@weblinkltd.com','rahman@weblinkltd.com','$2y$10$1A8yj5XUsWaGN4vVgYTbIeh72DJL3haG1yX3wqi80EBkmors2Lu7.','017432338',NULL,NULL,NULL,NULL,'Purana palton line, Dhaka-1000.','1668419749.jpg','Tropical Housing Limited','018432338','Motijheel, Dhaka.',1,1,'2022-11-14 06:31:04','2022-11-14 09:55:49'),
(5,'432 Park Avenue','park@gmail.com','park@gmail.com','$2y$10$zqLZc6DAaNGfkwGKTnrXreSMREZAU6tx2ojCI5XfLwbG96PbLS8JW','0190043200338',NULL,NULL,NULL,NULL,'New York','1744875063.jpg',NULL,NULL,NULL,1,1,'2025-04-17 07:31:03','2025-04-17 07:31:03');
/*!40000 ALTER TABLE `buildings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories`
--

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES
(1,'Building Color',1,21,'2022-11-17 06:08:32','2022-11-17 06:08:32'),
(2,'Building Decoration',1,12,'2022-11-20 03:12:36','2022-11-20 03:12:36');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `committees`
--

DROP TABLE IF EXISTS `committees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `committees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `contact_no` varchar(255) NOT NULL,
  `present_add` varchar(255) NOT NULL,
  `permanent_add` varchar(255) NOT NULL,
  `c_nid` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `designation_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `joining_date` date NOT NULL,
  `ending_date` date NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `committees`
--

LOCK TABLES `committees` WRITE;
/*!40000 ALTER TABLE `committees` DISABLE KEYS */;
INSERT INTO `committees` VALUES
(2,'Rockey','rockey123@gmail.com','01300432338','Banani,Dhaka.','Gazipur.','1234567890','$2y$10$QSpP.veGr2SU4igiDoY5qO4vE2paSHJREFyKPpseTX3mwV9eXP7TS','1667807331.jpg',2,7,'2022-11-07','2023-11-30',1,'2022-11-07 07:48:51','2022-11-07 07:48:51'),
(3,'Rahi','rahi@gmail.com','0225458','Banani','Gazipur','123456789','$2y$10$VvZ0iUykuxpGth7u0xdaLeGMSDJY5d49tKdVT9MlYEUa2B9SZ5aRW','1667807502.png',5,12,'2022-11-07','2022-11-30',1,'2022-11-07 07:51:42','2022-11-07 07:51:42'),
(4,'Rasel Ahmen','ra@gmail.com','019567834556','Dhaka','Dhaka','334455','$2y$10$vGpy6EMJM3UzoX4wt7HB6ezJ45VhxhWMIe0vd3bcdHkynMYd6EhMK','',8,17,'2022-11-01','1970-01-01',1,'2022-11-13 10:46:18','2022-11-13 10:46:18'),
(5,'Abdullah Al kafi','kafi@rt.com','013543338','Banani','Gazipur','123456789','$2y$10$qbCGMTmKj/LywM.YzFPPJeMSZdqWlqy8gmH.XGUXzOgjb8fj2Ygbq','1668419332.png',10,21,'2022-11-07','2022-11-30',1,'2022-11-14 09:48:40','2022-11-14 09:48:52');
/*!40000 ALTER TABLE `committees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `complains`
--

DROP TABLE IF EXISTS `complains`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `complains` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `title` varchar(255) NOT NULL,
  `details` varchar(255) NOT NULL,
  `status` enum('Pending','Working','Done') NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `complains`
--

LOCK TABLES `complains` WRITE;
/*!40000 ALTER TABLE `complains` DISABLE KEYS */;
INSERT INTO `complains` VALUES
(1,'2022-11-14','Flat Color Issue(RT FLAT 1B)','Nothing','Pending',8,'2022-11-06 10:55:50','2022-11-14 08:25:14'),
(2,'2022-11-13','Door Lock issue','Door Lock not proper work','Done',6,'2022-11-13 10:53:19','2022-11-13 11:05:20'),
(3,'2022-11-14','Electric service (RT FLAT 1A)','Electric line need to fixed.','Pending',7,'2022-11-14 07:48:40','2022-11-14 07:48:59'),
(4,'2022-11-15','Flat color (RT FLAT 1A)','New color required.','Working',7,'2022-11-14 07:50:10','2022-11-14 07:52:41'),
(5,'2022-11-14','flat floor issue(RT FLAT 1B)','nothing','Working',8,'2022-11-14 08:15:33','2022-11-14 08:19:11'),
(6,'2022-11-23','Noise','Noise Problem','Working',15,'2022-11-23 06:25:17','2022-11-23 06:25:44'),
(7,'2024-03-01','Air Condition','Air Condition doesn\'t work (Cool issue).','Pending',1,'2025-04-25 16:57:21','2025-04-25 16:57:21'),
(8,'2025-12-03','দরজা লক সমস্যা','দরজা লক সমস্যা','Pending',16,'2025-12-03 04:26:17','2025-12-03 04:26:17');
/*!40000 ALTER TABLE `complains` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `designations`
--

DROP TABLE IF EXISTS `designations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `designations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `designations`
--

LOCK TABLES `designations` WRITE;
/*!40000 ALTER TABLE `designations` DISABLE KEYS */;
INSERT INTO `designations` VALUES
(1,'Security Guard',1,7,'2022-11-06 08:53:13','2022-11-06 08:53:13'),
(2,'Incharge',1,7,'2022-11-06 08:53:29','2025-04-25 16:54:52'),
(3,'Coordinator',1,7,'2022-11-06 08:53:44','2025-04-25 16:54:28'),
(4,'Staff(B2)',1,12,'2022-11-07 06:10:48','2022-11-07 06:10:48'),
(5,'Manager(B2)',1,12,'2022-11-07 06:16:10','2022-11-07 06:16:10'),
(6,'Security Guard',1,17,'2022-11-13 09:03:03','2022-11-13 09:03:03'),
(7,'House Keeper',1,17,'2022-11-13 09:14:47','2022-11-13 09:14:47'),
(8,'Member',1,17,'2022-11-13 10:46:04','2022-11-13 10:46:04'),
(9,'Security Guard (RT)',1,21,'2022-11-14 06:41:06','2022-11-14 06:41:28'),
(10,'Staff (RT)',1,21,'2022-11-14 06:41:50','2022-11-14 06:41:50'),
(11,'Manager',1,37,'2025-04-17 07:43:30','2025-04-17 07:43:30'),
(12,'Managing Partner',1,7,'2025-04-25 16:53:43','2025-04-25 16:55:15');
/*!40000 ALTER TABLE `designations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employees`
--

DROP TABLE IF EXISTS `employees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `employees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `contact_no` varchar(255) NOT NULL,
  `present_add` varchar(255) NOT NULL,
  `permanent_add` varchar(255) NOT NULL,
  `e_nid` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `salary_per_month` varchar(255) NOT NULL,
  `designation_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `joining_date` date NOT NULL,
  `ending_date` date NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employees`
--

LOCK TABLES `employees` WRITE;
/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
INSERT INTO `employees` VALUES
(3,'alice(B2)','alice@gmail.com','$2y$10$MdhagTDp5XcAgzdy4Eo7i.iFsVHhqtCCLKuM0EmTYKuld9PFhpw5u','01300432344','Banani,Dhaka.','Gazipur.','1234567890','1667801558.jpg','15000',4,12,'2022-11-07','2023-11-30',1,'2022-11-07 06:12:38','2022-11-07 06:12:38'),
(5,'Abdullah','abdullah@gmail.com','$2y$10$1eUKUT7atY6HOtHxF7efPO/DJnf6VmyFTq1KFtEpSh6dZnkklKGn2','01834567890','Mohakhali','Cumilla','556688','1668331512.png','10000',7,17,'2021-01-01','1970-01-01',1,'2022-11-13 09:25:13','2022-11-13 09:29:37'),
(6,'Md. Dipu','dipu@rt.com','$2y$10$PbYF5CgQVCsVvMn5wBZaVuL02RrPv73zQJem1QP.IsVvAgbUUb4eu','016432338','Purana palton line, Dhaka-1000.','Barisal','123456789','1668419242.png','15000',9,21,'2022-11-01','2023-11-30',1,'2022-11-14 07:17:42','2022-11-14 09:47:22'),
(7,'Fajlu','fajlu@rt.com','$2y$10$sn2huZqd2KM6eScPA9VwIOEwShPVQxOUfR0qmpo/kqCzrcMeWdX22','015432338','Purana palton line, Dhaka-1000.','Patuakhali.','123456789','1668419230.png','10000',10,21,'2022-11-01','2022-12-31',1,'2022-11-14 08:28:02','2022-11-14 09:47:10'),
(8,'MR. Rafi','rafi@gmail.com','$2y$10$hulxpOJQABfHLQM3popk9.rebmRgvMZOVa1brnh3WGt9AEkqSgrcy','01300432335','Banani','Banani','5184984849159','1721104851.jpg','20000',2,7,'2024-07-01','2025-07-01',1,'2024-07-16 04:40:51','2024-07-16 04:40:51');
/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `funds`
--

DROP TABLE IF EXISTS `funds`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `funds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `building_id` int(11) NOT NULL,
  `month` varchar(50) NOT NULL,
  `year` year(4) NOT NULL,
  `issue_date` date NOT NULL,
  `amount` varchar(255) NOT NULL,
  `details` varchar(255) NOT NULL,
  `created_userid` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `funds`
--

LOCK TABLES `funds` WRITE;
/*!40000 ALTER TABLE `funds` DISABLE KEYS */;
INSERT INTO `funds` VALUES
(1,1,'November',2022,'2022-11-07','3000','Nothing',7,'2022-11-07 05:39:12','2022-11-07 05:47:45'),
(3,3,'November',2022,'2022-11-01','20000','Maintenance',17,'2022-11-13 10:47:28','2022-11-13 10:47:28'),
(4,4,'November',2022,'2022-11-01','5000','Regular building fund (RT)',21,'2022-11-14 07:38:08','2022-11-14 07:38:08'),
(5,4,'November',2022,'2022-11-17','50000','Regular Fund',21,'2022-11-17 10:09:51','2022-11-17 10:09:51'),
(6,2,'November',2022,'2022-11-20','15000','For building maintenance',12,'2022-11-20 03:14:20','2022-11-20 03:14:20');
/*!40000 ALTER TABLE `funds` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leaves`
--

DROP TABLE IF EXISTS `leaves`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leaves` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `leave_details` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `status` enum('Pending','Approved') NOT NULL DEFAULT 'Pending',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leaves`
--

LOCK TABLES `leaves` WRITE;
/*!40000 ALTER TABLE `leaves` DISABLE KEYS */;
INSERT INTO `leaves` VALUES
(3,'Sick leave',11,'2022-11-08','2022-11-09','Approved','2022-11-08 07:26:18','2022-11-08 07:26:37'),
(4,'sfs',11,'2022-11-01','2022-11-03','Approved','2022-11-08 07:27:43','2022-11-08 07:28:00'),
(5,'Sick Leave...',20,'2022-11-01','2022-11-03','Pending','2022-11-14 04:37:53','2022-11-14 04:38:34'),
(6,'Medical Issue',20,'2022-11-13','2022-11-13','Pending','2022-11-14 04:38:18','2022-11-14 04:38:51'),
(8,'Sick Leave.',5,'2022-11-01','2022-11-02','Approved','2022-11-14 04:43:36','2022-11-14 04:45:38'),
(9,'Sick leave (RT).',6,'2022-11-14','2022-11-15','Approved','2022-11-14 08:00:25','2022-11-14 08:01:12'),
(10,'Sick leave (RT)',7,'2022-11-14','2022-11-15','Pending','2022-11-14 08:30:35','2022-11-14 08:30:35');
/*!40000 ALTER TABLE `leaves` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `maintenances`
--

DROP TABLE IF EXISTS `maintenances`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `maintenances` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `building_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `cost_month` varchar(30) NOT NULL,
  `cost_year` year(4) NOT NULL,
  `title` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `details` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `maintenances`
--

LOCK TABLES `maintenances` WRITE;
/*!40000 ALTER TABLE `maintenances` DISABLE KEYS */;
INSERT INTO `maintenances` VALUES
(1,7,0,'2022-11-06','November',2022,'Building Decoration','3000','This amount for building decoration.',7,'2022-11-06 09:10:33','2022-11-06 09:10:33'),
(3,17,0,'2022-11-01','November',2022,'Camera','5000','Camera Setup and buy',17,'2022-11-13 10:22:03','2022-11-13 10:22:15'),
(5,21,1,'2022-11-17','November',2022,'test','20000','For building color',21,'2022-11-17 07:15:01','2022-11-17 07:15:01'),
(6,21,1,'2022-11-16','November',2022,'','7000','test 2',21,'2022-11-17 08:47:14','2022-11-17 08:47:14'),
(7,12,2,'2022-11-20','November',2022,'','10000','For building decoration.',12,'2022-11-20 03:13:18','2022-11-20 03:13:18');
/*!40000 ALTER TABLE `maintenances` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES
(1,'2014_10_12_000000_create_users_table',1),
(2,'2014_10_12_100000_create_password_resets_table',1),
(3,'2019_08_19_000000_create_failed_jobs_table',1),
(4,'2019_12_14_000001_create_personal_access_tokens_table',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payments`
--

DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` varchar(50) NOT NULL,
  `transaction_id` varchar(50) DEFAULT NULL,
  `tenant` varchar(255) NOT NULL,
  `unit` varchar(255) NOT NULL,
  `pay_method` enum('Bkash','Nagad','Bank','Cash') NOT NULL,
  `month` varchar(30) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `status` enum('Received','Pending') NOT NULL,
  `issue_date` date NOT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payments`
--

LOCK TABLES `payments` WRITE;
/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
INSERT INTO `payments` VALUES
(6,'123456','7654321','Zakariya Foisal','RT FLAT 1D','Nagad','2022-11-01','30000','Received','2022-11-23',NULL,15,'2022-11-23 05:22:58','2022-11-23 05:23:13'),
(7,'2345678','0987','Mizanur Rahman','RT FLAT 1A','Bkash','2022-11-01','20000','Pending','2022-11-23',NULL,7,'2022-11-23 05:28:24','2022-11-23 05:28:24');
/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `personal_access_tokens`
--

DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `personal_access_tokens`
--

LOCK TABLES `personal_access_tokens` WRITE;
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rents`
--

DROP TABLE IF EXISTS `rents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `rents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tenant_id` int(11) NOT NULL,
  `unit_id` varchar(100) NOT NULL,
  `building_id` int(11) NOT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `t_rent` varchar(255) DEFAULT NULL,
  `bill_month` varchar(30) NOT NULL,
  `bill_year` year(4) NOT NULL,
  `water_bill` varchar(100) NOT NULL,
  `electric_bill` varchar(100) NOT NULL,
  `gas_bill` varchar(100) NOT NULL,
  `security_bill` varchar(100) NOT NULL,
  `utility_bill` varchar(100) NOT NULL,
  `other_bill` varchar(100) NOT NULL,
  `total_rent` varchar(100) DEFAULT NULL,
  `issue_date` date NOT NULL,
  `bill_date` date DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rents`
--

LOCK TABLES `rents` WRITE;
/*!40000 ALTER TABLE `rents` DISABLE KEYS */;
INSERT INTO `rents` VALUES
(6,1,'Flat 1A',1,NULL,'30000','November',2022,'1000','1000','1000','1000','1000','1000','36000','2022-11-08','1970-01-01',0,1,'2022-11-08 03:48:51','2022-11-08 03:48:51'),
(7,3,'Flat 1A(B2)',2,NULL,'40000','November',2022,'1000','1000','1000','1000','1000','1000','46000','2022-11-08','1970-01-01',0,2,'2022-11-08 03:59:57','2022-11-08 04:00:45'),
(8,4,'Flat 1B(B2)',2,NULL,'30000','October',2022,'1000','1000','1000','1000','1000','1000','36000','2022-11-08','1970-01-01',1,2,'2022-11-08 04:17:58','2022-11-08 04:17:58'),
(9,6,'MT Unit 1B',3,NULL,'50000','November',2022,'1000','1000','1000','1000','1000','1000',NULL,'2022-11-01','1970-01-01',0,3,'2022-11-13 10:14:42','2022-11-13 10:20:15'),
(10,7,'RT FLAT 1A',4,NULL,'20000','November',2022,'1000','0','1000','0','0','40000',NULL,'2022-11-14','1970-01-01',0,4,'2022-11-14 07:41:39','2022-11-14 07:41:39'),
(11,8,'RT FLAT 1B',4,NULL,'20000','November',2022,'1000','0','1000','2000','0','40000',NULL,'2022-11-14','1970-01-01',0,4,'2022-11-14 08:07:15','2022-11-14 08:08:18'),
(12,15,'RT FLAT 1D',4,NULL,NULL,'November',2022,'0','0','0','2000','0','0',NULL,'2022-11-23','1970-01-01',0,4,'2022-11-23 06:22:44','2022-11-23 06:22:44'),
(13,17,'Flat 2B',1,NULL,'3000','January',2025,'20000','22222','20000','20000','20000','10000',NULL,'2025-04-25','1970-01-01',1,1,'2025-04-25 17:02:16','2025-04-25 17:02:16');
/*!40000 ALTER TABLE `rents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salarys`
--

DROP TABLE IF EXISTS `salarys`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `salarys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `pay_salary` varchar(255) NOT NULL,
  `designation_id` varchar(255) NOT NULL,
  `month` varchar(30) NOT NULL,
  `user_id` int(11) NOT NULL,
  `building_id` int(11) DEFAULT NULL,
  `issue_date` date NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salarys`
--

LOCK TABLES `salarys` WRITE;
/*!40000 ALTER TABLE `salarys` DISABLE KEYS */;
INSERT INTO `salarys` VALUES
(1,1,'10000','Security Guard','2022-08-01',7,NULL,'2022-11-06','2022-11-06 09:15:03','2022-11-06 09:15:03'),
(2,2,'20000','Moderator','2022-08-01',7,NULL,'2022-11-06','2022-11-06 09:18:09','2022-11-06 09:18:09'),
(3,3,'15000','Staff(B2)','2022-01-01',12,NULL,'2022-11-30','2022-11-07 08:00:17','2022-11-07 08:00:17'),
(6,5,'10000','House Keeper','2022-01-01',3,3,'2022-02-01','2022-11-13 09:35:34','2022-11-13 09:43:22'),
(7,6,'15000','Security Guard (RT)','2022-01-01',4,4,'2022-11-14','2022-11-14 08:01:49','2022-11-14 08:01:49'),
(8,7,'10000','Staff (RT)','2022-01-01',4,4,'2022-11-14','2022-11-14 08:28:40','2022-11-14 08:28:40');
/*!40000 ALTER TABLE `salarys` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tenants`
--

DROP TABLE IF EXISTS `tenants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tenants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `contact_no` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `t_nid` varchar(255) NOT NULL,
  `type` enum('Tenant','Floor_owner') NOT NULL,
  `password` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `advance_rent` varchar(255) DEFAULT NULL,
  `per_mon_rent` varchar(255) DEFAULT NULL,
  `rent_month` varchar(50) NOT NULL,
  `rent_year` year(4) NOT NULL,
  `unit_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `issue_date` date NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tenants`
--

LOCK TABLES `tenants` WRITE;
/*!40000 ALTER TABLE `tenants` DISABLE KEYS */;
INSERT INTO `tenants` VALUES
(1,'Abdullah Al Kafi','kafi123@gmail.com','01300432338','Banani, Dhaka.','1234567890','Tenant','$2y$10$uuQCS9eflTJufmu2aX2pTupmAQ0O5BqvOEn16uJe0zneu/ZkDk43a','1667724925.jpg','60000','30000','August',2022,1,7,'2022-11-06',1,'2022-11-06 08:55:25','2022-11-06 08:55:54'),
(3,'John(B2)','john@gmail.com','01300432345','Uttara, Dhaka.','1234567890123','Tenant','$2y$10$C0Q.ccP7jr4Zk3idVUEcZu7VuOz.qFz4Ry9xPEJ7PJwoM0nKohGsS','1667800527.jpg','80000','40000','September',2022,5,12,'2022-11-07',1,'2022-11-07 05:55:27','2022-11-07 05:55:49'),
(4,'ABS(B2)','abs@gmail.com','325464','Azimpur, Dhaka.','1234567890','Tenant','$2y$10$m.whssqM23wyvOgFmv0jqeYaIU/hLXhUfCHyfwlUyQmDB39fYxIRy','1667881005.jpg','60000','30000','October',2022,6,12,'2022-11-08',1,'2022-11-08 04:16:45','2022-11-08 04:16:45'),
(5,'Kafi Ahmed','kafi@gmail.com','01623456789','Banani','99443366','Tenant','$2y$10$L2J7L4hS04mAZavDXMJX9uAou.aYbCNpdVsN/OctOKhPgJGmY8QTO','','80000','40000','June',2022,7,17,'2022-06-01',1,'2022-11-13 09:17:44','2022-11-13 09:17:44'),
(6,'Abdur Rahman','ab@gmail.com','019567834556','Mirpur','33445566','Tenant','$2y$10$7JIkRoQkzJjFcACD.Jno..FikmINx84ryDocahz8ewLC5fLjsgKLC','','100000','50000','July',2022,8,17,'2022-07-01',1,'2022-11-13 09:19:01','2023-09-12 07:08:49'),
(7,'Mizanur Rahman','mizan@rt.com','014432338','Purana palton line, Dhaka-1000.','123456789','Tenant','$2y$10$6nfoyCdHZmNhYKIwDLV/nOkl/vY5rnYXMBUiQtX0F1XW7Q2zB.JcG','1668419161.png','40000','20000','November',2022,13,21,'2022-11-01',1,'2022-11-14 06:45:28','2022-11-14 09:46:01'),
(8,'Taibur Rahman','tb@rt.weblinkltd.com','0139432338','Purana palton line, Dhaka-1000.','123456789','Tenant','$2y$10$bpzO9bof1Uyd9cEQw.NN4e00Jo.FlyH127Y2E/i5AUgbO47rtluh2','1668419041.png','40000','20000','November',2022,14,21,'2022-11-14',1,'2022-11-14 08:05:55','2022-11-14 09:44:01'),
(12,'Limon','limon@rt.com','01300456338','banani','123456789','Tenant','$2y$10$nwjBCZIHMydX1wiJ26XIUehuAg3ZTJRNJZ6Rh/k8T4cp0NcTRDgdS','1668418367.png','30000','15000','November',2022,15,21,'2022-11-15',1,'2022-11-14 09:31:49','2023-01-02 16:34:50'),
(15,'Zakariya Foisal','zaki@gmail.com','019432388','Moghbazar,dhaka.','1234567890','Floor_owner','$2y$10$8mAwWh6VodnevZTujDGLye.PHpudbKcHzIQDE1SF./hdDx9mEwbK6','1668921758.png',NULL,NULL,'November',2022,16,21,'2022-11-20',1,'2022-11-20 05:22:38','2022-11-20 05:43:44'),
(16,'Mr. Aa','aa@gmail.com','00022347788','New York, USA','123456','Tenant','$2y$10$hs4G2xWFUpbPkvvIqcQyvOPrjJTqowtNkLwMwUsI7DyyBXmsikWAS','1745040036.jpeg',NULL,'20000','January',2025,17,37,'2025-04-19',1,'2025-04-19 05:20:36','2025-04-25 20:50:05'),
(17,'rashedul alam','Rashed_cis@yahoo.com','9299917974','house 154,road 8, bashundhara residential area','12344567','Tenant','$2y$10$JkJ78xZ3ZFKj.QRLVfsM5.zqrr3MZ2epRqJKZrq6viyNOEq6G6N/G','','1000','3000','January',2024,4,7,'2025-04-25',1,'2025-04-25 17:01:16','2025-04-25 17:01:16'),
(18,'Nazmul','nazmul@gmail.com','01300432338','Banani, Dhaka','15894984','Floor_owner','$2y$10$HUh8uTs//y02ss2ImxfuKeQMLozjSR4CEcn71ct69iaonb87Be3wi','1764735154.png','50000','0','December',2025,19,37,'2025-12-03',1,'2025-12-03 04:12:34','2025-12-03 04:12:34');
/*!40000 ALTER TABLE `tenants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `units`
--

DROP TABLE IF EXISTS `units`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `units` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `units`
--

LOCK TABLES `units` WRITE;
/*!40000 ALTER TABLE `units` DISABLE KEYS */;
INSERT INTO `units` VALUES
(1,'Flat 1A',7,'2022-11-06 08:49:18','2022-11-06 08:49:18'),
(2,'Flat 1B',7,'2022-11-06 08:49:29','2022-11-06 08:49:29'),
(3,'Flat 2A',7,'2022-11-06 08:50:06','2022-11-06 08:50:28'),
(4,'Flat 2B',7,'2022-11-06 08:50:49','2022-11-06 08:50:49'),
(5,'Flat 1A(B2)',12,'2022-11-07 05:52:24','2022-11-07 05:52:24'),
(6,'Flat 1B(B2)',12,'2022-11-07 05:52:45','2022-11-07 05:52:45'),
(7,'MT Unit 1A',17,'2022-11-13 07:35:11','2022-11-13 07:35:11'),
(8,'MT Unit 1B',17,'2022-11-13 07:35:20','2022-11-13 07:35:20'),
(9,'MT Unit 1C',17,'2022-11-13 07:35:28','2022-11-13 07:35:28'),
(10,'MT Unit 2A',17,'2022-11-13 07:35:39','2022-11-13 07:35:39'),
(11,'MT Unit 2B',17,'2022-11-13 07:35:52','2022-11-13 07:35:52'),
(12,'MT Unit 2C',17,'2022-11-13 07:36:01','2022-11-13 07:36:11'),
(13,'RT FLAT 1A',21,'2022-11-14 06:39:34','2022-11-14 06:39:34'),
(14,'RT FLAT 1B',21,'2022-11-14 06:39:47','2022-11-14 06:39:47'),
(15,'RT FLAT 1C',21,'2022-11-14 06:40:00','2022-11-14 06:40:00'),
(16,'RT FLAT 1D',21,'2022-11-14 06:40:11','2022-11-14 06:40:11'),
(17,'Floor 2',37,'2025-04-17 07:43:10','2025-04-19 05:17:21'),
(18,'rashedul alam',37,'2025-04-25 20:56:25','2025-04-25 20:56:25'),
(19,'Weblink ISP',37,'2025-12-03 04:09:11','2025-12-03 04:09:11');
/*!40000 ALTER TABLE `units` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `type` enum('building_owner','floor_ower','tenant','employee','admin') NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `user_id` int(11) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,'Superadmin','superadmin@gmail.com','admin',1,1,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-10-17 04:46:00',NULL),
(7,'Russel Park','russel123@gmail.com','building_owner',1,1,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-06 02:16:06','2022-11-06 02:16:06'),
(8,'Abdullah Al Kafi','kafi123@gmail.com','tenant',1,1,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-06 02:55:25','2022-11-06 02:55:25'),
(10,'Md. Rakibul','rakibul123@gmail.com','employee',1,1,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-06 03:00:50','2022-11-06 03:00:50'),
(11,'Md. Habibullah','habib123@gmail.com','employee',1,2,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-06 03:03:41','2022-11-06 03:03:41'),
(12,'Jannatul Sifa','sifa@gmail.com','building_owner',1,2,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-06 23:49:51','2022-11-06 23:49:51'),
(13,'John(B2)','john@gmail.com','tenant',1,3,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-06 23:55:27','2022-11-06 23:55:27'),
(14,'alice(B2)','alice@gmail.com','employee',1,3,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-07 00:12:38','2022-11-07 00:12:38'),
(15,'Jui','jui@gmail.com','employee',1,4,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-07 01:59:16','2022-11-07 01:59:16'),
(16,'ABS(B2)','abs@gmail.com','tenant',1,4,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-07 22:16:45','2022-11-07 22:16:45'),
(17,'Masud Tower','info@masudtower.com','building_owner',1,3,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-13 01:31:34','2022-11-13 01:31:34'),
(18,'Kafi Ahmed','kafi@gmail.com','tenant',1,5,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-13 03:17:44','2022-11-13 03:17:44'),
(19,'Abdur Rahman','ab@gmail.com','tenant',1,6,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-13 03:19:01','2022-11-13 22:35:11'),
(20,'Abdullah','abdullah@gmail.com','employee',1,5,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-13 03:25:13','2022-11-13 03:25:13'),
(21,'Rahman Tropical Tower','rahman@weblinkltd.com','building_owner',1,4,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-14 00:31:04','2022-11-14 00:31:04'),
(22,'Mizanur Rahman','mizan@rt.com','tenant',1,7,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-14 00:45:28','2022-11-14 00:45:28'),
(23,'Md. Dipu','dipu@rt.com','employee',1,6,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-14 01:17:42','2022-11-14 01:17:42'),
(24,'Taibur Rahman','tb@rt.weblinkltd.com','tenant',1,8,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-14 02:05:55','2022-11-14 02:05:55'),
(25,'Fajlu','fajlu@rt.com','employee',1,7,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-14 02:28:03','2022-11-14 02:28:03'),
(29,'Limon','limon@rt.com','tenant',1,12,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-14 03:31:49','2022-11-14 03:31:49'),
(34,'Zakariya Foisal','zaki@gmail.com','floor_ower',1,15,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-19 23:22:38','2022-11-19 23:22:38'),
(35,'Taibur Tower','taibur@gmail.com','building_owner',1,7,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2022-11-24 04:33:01','2022-11-24 04:33:01'),
(36,'MR. Rafi','rafi@gmail.com','employee',1,8,NULL,'$2y$10$JpdjP4rY.xgDpp3a.tWoN.kox9xlxrBb.cltCrvuEnmtVHll684he',NULL,'2024-07-15 22:40:51','2024-07-15 22:40:51'),
(37,'432 Park Avenue','park@gmail.com','building_owner',1,5,NULL,'$2y$10$HebRrsB4aA9kMyqqA63Fb.BBEWvDDwSiv4929aM8zL9aNhLaahMVC',NULL,'2025-04-17 01:31:03','2025-04-17 01:31:03'),
(38,'Mr. Aa','aa@gmail.com','tenant',1,16,NULL,'$2y$10$vBHBcvJEUVZ5jjDDlDx66.FAkSj985GjZFbmfz0vnY84vEZtIi8b.',NULL,'2025-04-18 23:20:36','2025-04-18 23:20:36'),
(39,'rashedul alam','Rashed_cis@yahoo.com','tenant',1,17,NULL,'$2y$10$8AjRNa4gX/Fq9rZGiiIqHO2O8PUtlSUFF1jbUHwjC3hMvEEBIc2jO',NULL,'2025-04-25 11:01:16','2025-04-25 11:01:16'),
(40,'Nazmul','nazmul@gmail.com','floor_ower',1,18,NULL,'$2y$10$coiQCGd00ThnzkQBc1DfUO4xuKCTEjAZbpHN6mDMA.PozOG.flZVS',NULL,'2025-12-02 22:12:34','2025-12-02 22:12:34');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `utilities`
--

DROP TABLE IF EXISTS `utilities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `utilities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `utilities`
--

LOCK TABLES `utilities` WRITE;
/*!40000 ALTER TABLE `utilities` DISABLE KEYS */;
INSERT INTO `utilities` VALUES
(1,'Water Bill','800',7,'2022-11-06 09:04:38','2022-11-06 09:07:40'),
(2,'Security Bill','4000',7,'2022-11-06 09:08:05','2022-11-06 09:08:05'),
(4,'Electricity Bill(B2)','800',12,'2022-11-07 06:37:30','2022-11-07 06:37:30'),
(5,'Water Bill(B2)','1000',12,'2022-11-07 06:44:45','2022-11-07 06:44:45'),
(6,'Lift Maintenance','25000',17,'2022-11-13 09:46:32','2022-11-13 09:46:32'),
(7,'RT Water Bill','1000',21,'2022-11-14 07:19:24','2022-11-14 07:19:24'),
(8,'RT Gas Bill','1000',21,'2022-11-14 07:19:43','2022-11-14 07:19:43');
/*!40000 ALTER TABLE `utilities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `visitors`
--

DROP TABLE IF EXISTS `visitors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `visitors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `name` varchar(255) NOT NULL,
  `contact_no` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `unit_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `in_time` varchar(30) NOT NULL,
  `out_time` varchar(30) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `visitors`
--

LOCK TABLES `visitors` WRITE;
/*!40000 ALTER TABLE `visitors` DISABLE KEYS */;
INSERT INTO `visitors` VALUES
(1,'2022-11-06','Abdullah Al Kafi','01300432338','Uttara, Dhaka.',1,11,'9.00 AM','10.00 AM','2022-11-06 11:15:54','2022-11-06 11:15:54'),
(2,'2022-11-02','Sifa','01734567890','Tongi',8,20,'9 AM','','2022-11-14 04:09:39','2022-11-14 04:11:05'),
(3,'2022-11-14','Rana','01723456789','Dhaka',8,20,'9 AM',NULL,'2022-11-14 05:33:09','2022-11-14 05:33:09'),
(4,'2022-11-14','Hatim','018432338','Palton,Dhaka.',13,23,'10.00 AM',NULL,'2022-11-14 07:57:13','2022-11-14 07:57:13'),
(5,'2022-11-14','Talha','0130044321','Badda,dhaka.',14,25,'10.00 AM',NULL,'2022-11-14 08:31:39','2022-11-14 08:31:39'),
(6,'2022-11-23','Hatim 1D','0130044321','Badda,dhaka.',16,23,'10.00 AM',NULL,'2022-11-23 06:11:41','2022-11-23 06:11:41');
/*!40000 ALTER TABLE `visitors` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-05-05 15:22:14
