-- MySQL dump 10.13 Distrib 5.5.41, for Win64 (x86) -- -- Host: localhost Database: nestpune_db -- ------------------------------------------------------ -- Server version 5.5.5-10.4.32-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 utf8 */; /*!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 `agents` -- DROP TABLE IF EXISTS `agents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `agents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(100) NOT NULL, `password` varchar(100) NOT NULL, `name` varchar(100) DEFAULT NULL, `create_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `agents` -- LOCK TABLES `agents` WRITE; /*!40000 ALTER TABLE `agents` DISABLE KEYS */; INSERT INTO `agents` VALUES (1,'agent','agent123','NestPune Agent','2026-05-25 10:09:43'); /*!40000 ALTER TABLE `agents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `brokers` -- DROP TABLE IF EXISTS `brokers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `brokers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) DEFAULT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'Active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `brokers_email_unique` (`email`), UNIQUE KEY `brokers_username_unique` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `brokers` -- LOCK TABLES `brokers` WRITE; /*!40000 ALTER TABLE `brokers` DISABLE KEYS */; INSERT INTO `brokers` VALUES (1,'Broker_1','broker@gmail.com','1234567890','bk_1','$2y$12$9IMHC/2d5T4Nj/rN/kOKYOFHuFpZXKeYHKTjIyFAU1LwDWkWGBC5S','Active','2026-06-11 08:40:08','2026-06-11 08:40:08'); /*!40000 ALTER TABLE `brokers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`), KEY `cache_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache` -- LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`), KEY `cache_locks_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache_locks` -- LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` 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 = utf8 */; 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 `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_batches` -- LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `leads` -- DROP TABLE IF EXISTS `leads`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `leads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer_name` varchar(150) NOT NULL, `whatsapp_number` varchar(20) NOT NULL, `preferred_location` varchar(100) DEFAULT NULL, `requirement` varchar(100) DEFAULT NULL, `budget_range` varchar(100) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `status` varchar(50) DEFAULT 'New', `notes` text DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `leads` -- LOCK TABLES `leads` WRITE; /*!40000 ALTER TABLE `leads` DISABLE KEYS */; INSERT INTO `leads` VALUES (6,'K','1234567890','Bavdhan','4 BHK','₹2Cr – ₹5Cr','2026-05-25 11:10:38','New',NULL),(8,'a','0987654321','Kothrud','1 BHK','Under ₹50L','2026-05-25 11:20:21','New',NULL),(10,'abc','2933018492','Baner','2 BHK','₹50L – ₹1Cr','2026-05-25 16:46:06','New',NULL),(12,'kaoed','2034909910','Baner','2 BHK','₹2Cr – ₹5Cr','2026-05-25 16:46:44','Contacted',NULL),(14,'b','1234','Balewadi','2 BHK','Under ₹50L','2026-05-25 18:19:57','New',NULL),(16,'hgmhgmh','5657098765','Viman Nagar','2 BHK','₹2Cr – ₹5Cr','2026-05-26 16:09:58','New',NULL),(18,'sjiuheddi','278249502','Kharadi','1 BHK','₹50L – ₹1Cr','2026-05-30 05:54:32','New',NULL),(19,'djn','283488530','Kothrud','3 BHK','₹50L – ₹1Cr','2026-05-30 15:04:10','Contacted','Agreed'),(20,'Rahul Sharma','9876543210','Baner','2 BHK','₹50L-₹1Cr','2026-06-11 08:06:31','New',NULL),(21,'Priya Patil','9988776655','Kharadi','3 BHK','₹1Cr-₹2Cr','2026-06-11 08:06:31','Contacted','Interested in site visit'),(22,'Amit Joshi','9123456789','Wakad','2 BHK','₹75L-₹1Cr','2026-06-11 08:06:31','Follow Up','Call again next week'),(23,'Sneha Kulkarni','9871234567','Hinjewadi','1 BHK','Under ₹50L','2026-06-11 08:06:31','New',NULL),(24,'Vikas Deshmukh','9765432109','Balewadi','3 BHK','₹1Cr-₹2Cr','2026-06-11 08:06:31','Closed','Booked flat'),(25,'Neha More','9012345678','Viman Nagar','2 BHK','₹50L-₹1Cr','2026-06-11 08:06:31','Contacted','Requested brochure'),(26,'Rohan Pawar','9090909090','Kothrud','4 BHK','Above ₹2Cr','2026-06-11 08:06:31','Follow Up','Needs loan assistance'),(27,'Anjali Jadhav','9898989898','Bavdhan','2 BHK','₹75L-₹1Cr','2026-06-11 08:06:31','New',NULL); /*!40000 ALTER TABLE `leads` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `locations` -- DROP TABLE IF EXISTS `locations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `description` text DEFAULT NULL, `drive_link` text DEFAULT NULL, `image_url` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), 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 `locations` -- LOCK TABLES `locations` WRITE; /*!40000 ALTER TABLE `locations` DISABLE KEYS */; INSERT INTO `locations` VALUES (1,'Baner','Premium residential area in West Pune','https://drive.google.com/drive/folders/1IEPV_LZfKMdLYkKR-qfZ_amvCQO81hRn?usp=drive_link',NULL,'2026-05-25 10:10:04'),(2,'Balewadi','Modern lifestyle location near Baner','https://drive.google.com/drive/folders/1IEPV_LZfKMdLYkKR-qfZ_amvCQO81hRn?usp=drive_link',NULL,'2026-05-25 10:10:04'),(3,'PCMC','Growing real-estate zone','https://drive.google.com/drive/folders/1IEPV_LZfKMdLYkKR-qfZ_amvCQO81hRn?usp=drive_link',NULL,'2026-05-25 10:10:04'),(4,'Wakad','Popular IT and residential hub','https://drive.google.com/drive/folders/1IEPV_LZfKMdLYkKR-qfZ_amvCQO81hRn?usp=drive_link',NULL,'2026-05-25 10:10:04'),(5,'Hinjewadi','Major IT and investment location','https://drive.google.com/drive/folders/1IEPV_LZfKMdLYkKR-qfZ_amvCQO81hRn?usp=drive_link',NULL,'2026-05-25 10:10:04'),(6,'Kharadi','Prime IT and commercial zone','https://drive.google.com/drive/folders/1IEPV_LZfKMdLYkKR-qfZ_amvCQO81hRn?usp=drive_link',NULL,'2026-05-25 10:10:04'),(7,'Viman Nagar','Premium city-side location','https://drive.google.com/drive/folders/1IEPV_LZfKMdLYkKR-qfZ_amvCQO81hRn?usp=drive_link',NULL,'2026-05-25 10:10:04'),(8,'Hadapsar','Affordable and growing locality','https://drive.google.com/drive/folders/1IEPV_LZfKMdLYkKR-qfZ_amvCQO81hRn?usp=drive_link',NULL,'2026-05-25 10:10:04'),(9,'Kothrud','Established Pune residential area','https://drive.google.com/drive/folders/1IEPV_LZfKMdLYkKR-qfZ_amvCQO81hRn?usp=drive_link',NULL,'2026-05-25 10:10:04'),(10,'Bavdhan','Peaceful location near hills','https://drive.google.com/drive/folders/1IEPV_LZfKMdLYkKR-qfZ_amvCQO81hRn?usp=drive_link',NULL,'2026-05-25 10:10:04'); /*!40000 ALTER TABLE `locations` 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 = utf8 */; 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,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_06_11_134131_create_brokers_table',2); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `projects` -- DROP TABLE IF EXISTS `projects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `projects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_name` varchar(150) NOT NULL, `location` varchar(100) DEFAULT NULL, `builder_name` varchar(150) DEFAULT NULL, `flat_type` varchar(50) DEFAULT NULL, `carpet_area` varchar(100) DEFAULT NULL, `price_range` varchar(100) DEFAULT NULL, `possession_date` varchar(100) DEFAULT NULL, `amenities` text DEFAULT NULL, `description` text DEFAULT NULL, `brochure_url` text DEFAULT NULL, `drive_folder_link` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `status` varchar(50) DEFAULT 'Active', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `projects` -- LOCK TABLES `projects` WRITE; /*!40000 ALTER TABLE `projects` DISABLE KEYS */; INSERT INTO `projects` VALUES (154,'Celestia Heights','Baner','ABC','2 BHK','850','85L','2026-12','Swimming Pool, Gymnasium, 24/7 Security, Car Parking, Lift','Good Amenities','http://127.0.0.1:8000/uploads/brochures/1781185076_Elvion_Round_1_certificate_Elvion-R1_132.pdf','https://drive.google.com/drive/folders/1IEPV_LZfKMdLYkKR-qfZ_amvCQO81hRn?usp=drive_link','2026-06-11 08:07:56','Active'); /*!40000 ALTER TABLE `projects` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `sessions_user_id_index` (`user_id`), KEY `sessions_last_activity_index` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; INSERT INTO `sessions` VALUES ('S8xYwZvmCTBLcoqG2JH6yhD1aA4VSg9pvH93nezf',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYjhQellET0RITjVRSzE3Vk1SZU5pZ3dabFlZb09sREN6RHVxbGREWCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NzA6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC8ud2VsbC1rbm93bi9hcHBzcGVjaWZpYy9jb20uY2hyb21lLmRldnRvb2xzLmpzb24iO3M6NToicm91dGUiO047fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1781188064); /*!40000 ALTER TABLE `sessions` 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 = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) 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 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 */; /*!40000 ALTER TABLE `users` 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-06-11 20:01:29