--
-- Host: localhost    Database: nestpune_db
-- ------------------------------------------------------


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

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;

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


--
-- Table structure for table `job_batches`
--

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;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

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;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `leads`
--

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;

--
-- Dumping data for table `leads`
--

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);

--
-- Table structure for table `locations`
--

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;

--
-- Dumping data for table `locations`
--

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');

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

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;

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

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);

--
-- Table structure for table `projects`
--

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;

--
-- Dumping data for table `projects`
--

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');

--
-- Table structure for table `sessions`
--

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;

--
-- Dumping data for table `sessions`
--

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);


