
CREATE TABLE `tbl_lead` (
  `lead_id` int(11) NOT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `locations` varchar(500) DEFAULT '',
  `property_ids` varchar(100) DEFAULT '',
  `unit_ids` varchar(100) DEFAULT '',
  `checkindate` date DEFAULT NULL,
  `checkoutdate` date DEFAULT NULL,
  `no_of_adults` int(11) DEFAULT NULL,
  `no_of_kids` int(11) DEFAULT NULL,
  `no_of_nights` int(11) DEFAULT NULL,
  `source_name` varchar(100) DEFAULT NULL,
  `email_id` varchar(500) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT '',
  `detail` varchar(2000) DEFAULT NULL,
  `notes` varchar(2000) DEFAULT NULL,
  `email_sent_status` tinyint(1) DEFAULT 0,
  `assign_to_id` int(11) DEFAULT NULL,
  `assign_to_name` varchar(100) DEFAULT NULL,
  `assign_by_id` int(11) DEFAULT NULL,
  `assign_by_name` varchar(100) DEFAULT NULL,
  `lead_status` varchar(50) DEFAULT NULL,
  `lead_status_message` varchar(500) DEFAULT NULL,
  `re_assign_by` varchar(100) DEFAULT NULL,
  `re_assign_time` datetime DEFAULT NULL,
  `re_assign_reason` varchar(500) DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `position` int(11) DEFAULT NULL,
  `add_ip` varchar(50) DEFAULT NULL,
  `add_time` datetime DEFAULT NULL,
  `add_by` varchar(100) DEFAULT NULL,
  `add_by_id` int(11) DEFAULT NULL,
  `update_ip` varchar(50) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(100) DEFAULT NULL,
  `quotation_id` int(11) DEFAULT NULL,
  `booking_id` int(11) DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_lead`
--

INSERT INTO `tbl_lead` (`lead_id`, `first_name`, `last_name`, `city_id`, `locations`, `property_ids`, `unit_ids`, `checkindate`, `checkoutdate`, `no_of_adults`, `no_of_kids`, `no_of_nights`, `source_name`, `email_id`, `mobile`, `detail`, `notes`, `email_sent_status`, `assign_to_id`, `assign_to_name`, `assign_by_id`, `assign_by_name`, `lead_status`, `lead_status_message`, `re_assign_by`, `re_assign_time`, `re_assign_reason`, `status`, `position`, `add_ip`, `add_time`, `add_by`, `add_by_id`, `update_ip`, `update_time`, `update_by`, `quotation_id`, `booking_id`) VALUES
(1, 'Nawal', 'Kishore', 1, 'Anjuna,Parra', '22,8,19,18', '57,200,150,154,229,230,239,305', '2025-11-29', '2025-11-02', 2, 2, 3, 'WhatsApp Chat', 'nawal.kishore@thebluekite.com', '9711112213', 'Price 4000 - 5000/per day', NULL, 0, 197, 'Devansh Patidar', 1, 'Admin', 'Open', NULL, 'admin', '0000-00-00 00:00:00', 'testing', 1, NULL, '::1', '2025-09-26 13:09:55', 'Admin', 1, '::1', '2025-09-26 17:20:12', 'admin', NULL, 0),
