-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `dashboard_server`
--

-- --------------------------------------------------------

--
-- Table structure for table `builders`
--

CREATE TABLE `builders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `builder_name` varchar(200) DEFAULT NULL,
  `builder_slug` varchar(200) DEFAULT NULL,
  `builder_image` varchar(200) DEFAULT NULL,
  `status` enum('1','0') DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `builders`
--

INSERT INTO `builders` (`id`, `builder_name`, `builder_slug`, `builder_image`, `status`, `created_at`, `updated_at`) VALUES
(2, 'test test', 'test', 'categories/1729089857_doit.jpg', '1', '2024-10-16 03:44:17', '2024-11-15 05:17:31'),
(3, 'test', 'test', 'categories/1729253276_icon.png', '1', '2024-10-18 01:07:56', '2024-10-18 01:07:56'),
(5, 'PNC Developer', 'pnc-developer', 'categories/1731667854_image.jpg', '1', '2024-11-15 05:20:54', '2024-11-15 05:20:54');

-- --------------------------------------------------------

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `cat_name` varchar(200) DEFAULT NULL,
  `cat_slug` varchar(200) DEFAULT NULL,
  `cat_icon` varchar(200) DEFAULT NULL,
  `status` enum('1','0') DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`category_id`, `cat_name`, `cat_slug`, `cat_icon`, `status`, `created_at`, `updated_at`) VALUES
(21, 'Adventure', 'Adventure', 'categories/1725594984_1.jpg', '1', '2024-09-06 03:56:24', '2024-09-06 03:56:24'),
(22, 'Beach', 'Beach', 'categories/1725594997_1.jpg', '1', '2024-09-06 03:56:37', '2024-09-06 03:56:37'),
(23, 'Island', 'Island', 'categories/1725595009_1.jpg', '1', '2024-09-06 03:56:49', '2024-09-06 03:56:49'),
(24, 'Luxury', 'Luxury', 'categories/1725595031_CALIFORNIA-0.jpeg', '1', '2024-09-06 03:57:11', '2024-09-06 03:57:11'),
(25, 'Family', 'family', 'categories/1725606847_1.jpg', '1', '2024-09-06 07:14:07', '2024-09-06 07:14:07');

-- --------------------------------------------------------

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `listing`
--

CREATE TABLE `listing` (
  `listingID` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `metatitle` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `price` varchar(100) DEFAULT NULL,
  `projects_id` varchar(255) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `builder` varchar(100) DEFAULT NULL,
  `approvals` text DEFAULT NULL,
  `size` varchar(255) DEFAULT NULL,
  `unit_type` varchar(255) DEFAULT NULL,
  `segment` varchar(255) DEFAULT NULL,
  `area_no` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `listing_title` varchar(255) DEFAULT NULL,
  `floor_plans` text DEFAULT NULL,
  `amenities` text DEFAULT NULL,
  `image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `listing`
--

INSERT INTO `listing` (`listingID`, `title`, `metatitle`, `location`, `address`, `state`, `city`, `longitude`, `latitude`, `price`, `projects_id`, `category_id`, `builder`, `approvals`, `size`, `unit_type`, `segment`, `area_no`, `description`, `listing_title`, `floor_plans`, `amenities`, `image`, `created_at`, `updated_at`) VALUES
(20, 'Signature Global Titanium SPR', 'Signature Global Titanium SPR', 'Sector 71 Gurgaon', 'H98 Udyog vihar  gurgaon', 'Haryana', 'Gurgaon', '92.0000', '20.000', '24324', '10', 25, '3', 'dda', '221424', '1232', 'test', '1200', '<p>For those looking to buy a residential property, here comes one of the choicest offerings in Gurgaon, at Sector 71. Brought to you by Signature Global India Limited, Signature Global Titanium SPR is among the newest addresses for homebuyers. There are apartments for sale in Signature Global Titanium SPR. This is an under-construction project right now, and is expected to be delivered by May, 2031 .</p>', NULL, 'Passedd', '<p>For those looking to buy a residential property, here comes one of the choicest offerings in Gurgaon, at Sector 71. Brought to you by Signature Global India Limited, Signature Global Titanium SPR is among the newest addresses for homebuyers. There are apartments for sale in Signature Global Titanium SPR. This is an under-construction project right now, and is expected to be delivered by May, 2031 .</p>', '[\"quickairfares-small_4BBE.png\",\"quickairfares_EEB8.png\"]', '2024-09-06 07:21:49', '2024-11-15 01:59:28'),
(21, 'DDA Flats Turkman Gate', 'DDA Flats Turkman Gate', 'Sector 71 Gurgaon', 'H98 Udyog vihar  gurgaon', 'Haryana', 'Gurgaon', '92.0000', '20.000', '24324', '10', 25, '3', 'dda', '221424', '1232', 'test', '1200', '<p>For those looking to buy a residential property, here comes one of the choicest offerings in Central Delhi, at Ajmeri gate. Brought to you by StageBuilder1, DDA Flats Turkman Gate is among the newest addresses for homebuyers. There are villas for sal</p>', NULL, 'Passedx', '<p>Gate is among the newest addresses for homebuyers. There are villas for salGate is among the newest addresses for homebuyers. There are villas for salGate is among the newest addresses for homebuyers. There are villas for salGate is among the newest addresses for homebuyers. There are villas for salGate is among the newest addresses for homebuyers. There are villas for salGate is among the newest addresses for homebuyers. There are villas for salGate is among the newest addresses for homebuyers. There are villas for sal</p>', '[\"crkdgmu_1718101248_497636337_optOrig_B033.jpg\",\"qlozsze_1718101248_497636335_optOrig_1E6D.jpg\",\"3glphrd_1718101250_497636357_optOrig_65A0.jpg\"]', '2024-09-06 07:24:42', '2024-11-15 02:08:54'),
(22, 'Gem Silver Residency', 'Gem Silver Residency', 'Sector 71 Gurgaon', 'H98 Udyog vihar  gurgaon', 'Haryana', 'Gurgaon', '92.0000', '20.000', '24324', NULL, NULL, NULL, 'dda', '221424', '1232', 'test', '1200', '<p>Check out Gem Silver Residency in Chattarpur, one of the upcoming under-construction housing societies in South Delhi. There are apartments for sale in Gem Silver Residency. This society will have all basic facilities and amenities to suit homebuyer</p>', NULL, 'Passed', '<p>Check out Gem Silver Residency in Chattarpur, one of the upcoming under-construction housing societies in South Delhi. There are apartments for sale in Gem Silver Residency. This society will have all basic facilities and amenities to suit homebuyer</p>', '[\"prtfabi_1718101248_497636347_optOrig_8F91.jpg\",\"ic8y1nb_1718101248_497636345_optOrig_CEC1.jpg\",\"o4rus0n_1718101249_497636355_optOrig_4F5B.jpg\",\"crkdgmu_1718101248_497636337_optOrig_23D6.jpg\"]', '2024-09-06 07:26:01', '2024-09-06 07:26:01'),
(23, 'AMR Farms', 'AMR Farms', 'Chattarpur,', 'Chattarpur, South Delhi', 'Delhi', 'Dehi', '92.0000', '20.000', '9', NULL, NULL, NULL, '₹ 9 - 30 Cr', '221424', '1232', 'test', '1200', '<p>AMR Farms in Chattarpur, South Delhi is a ready-to-move housing society. It offers independent floors and villas in varied budget range. These units are a perfect combination of comfort and style, specifically designed to suit your requirements and c</p>', NULL, 'Passed', '<p>AMR Farms in Chattarpur, South Delhi is a ready-to-move housing society. It offers independent floors and villas in varied budget range. These units are a perfect combination of comfort and style, specifically designed to suit your requirements and c</p>', '[\"uzdsdm7_1723628872_512005239_large_D540.jpg\",\"b4kj7zw_1720596184_503646903_optOrig_0110.jpg\",\"nvt2eas_1718101732_497639249_optOrig_94C4.jpg\"]', '2024-09-06 07:32:47', '2024-09-06 07:32:47'),
(24, 'PNM Affordable Homes', 'PNM Affordable Homes', 'West Delhi', 'Dwarka Mor, West Delhi', 'Delhi', 'Dehi', '92.0000', '20.000', '132', NULL, NULL, NULL, '₹ 9 - 30 Cr', '221424', '1232', 'test', '1200', '<p>PNM Affordable Homes in Dwarka Mor, West Delhi is a ready-to-move housing society. It offers apartments and independent floors in varied budget range. These units are a perfect combination of comfort and style, specifically designed to suit your requPNM Affordable Homes in Dwarka Mor, West Delhi is a ready-to-move housing society. It offers apartments and independent floors in varied budget range. These units are a perfect combination of comfort and style, specifically designed to suit your requ</p>', NULL, 'Passed', '<p>PNM Affordable Homes in Dwarka Mor, West Delhi is a ready-to-move housing society. It offers apartments and independent floors in varied budget range. These units are a perfect combination of comfort and style, specifically designed to suit your requ</p>', '[\"uzdsdm7_1723628872_512005239_large_192C.jpg\",\"b4kj7zw_1720596184_503646903_optOrig_E826.jpg\",\"nvt2eas_1718101732_497639249_optOrig_6082.jpg\",\"cjzbjx4_1718101249_497636353_optOrig_9BD6.jpg\"]', '2024-09-06 07:36:11', '2024-09-06 07:36:11'),
(25, 'Determine how your tags', 'Determine how your tags', 'public_html', 'H98 Udyog vihar  gurgaon', 'Select State', 'agre', '92.0000', '20.000', '24324', '11', 25, '3', 'test', '221424', '1232', 'test', '1200', '<p>tstetae&nbsp;tstetae&nbsp;tstetae&nbsp;tstetae&nbsp;tstetae&nbsp;tstetae&nbsp;tstetae&nbsp;tstetae&nbsp;tstetae&nbsp;tstetae&nbsp;tstetae&nbsp;</p>', NULL, 'Passed', '<p>teste</p>', '[\"1_3E8B.jpg\"]', '2024-11-15 04:56:15', '2024-11-15 04:57:31');

-- --------------------------------------------------------

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) 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),
(5, '2024_07_18_145645_create_category_table', 2),
(6, '2024_08_01_073636_create_projects_table', 3),
(7, '2024_08_05_123603_create_query_details_table', 4),
(8, '2024_08_06_113357_create_listing_table', 5),
(9, '2024_08_03_132838_create_property_listing_table', 6),
(10, '2024_08_08_182447_add_images_to_listing_table', 7),
(11, '2024_09_09_084752_add_foreign_keys_to_listing_table', 8);

-- --------------------------------------------------------

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

CREATE TABLE `projects` (
  `projects_id` bigint(20) UNSIGNED NOT NULL,
  `project_name` varchar(200) DEFAULT NULL,
  `project_category` varchar(200) DEFAULT NULL,
  `project_address` varchar(200) DEFAULT NULL,
  `project_state` varchar(200) DEFAULT NULL,
  `project_city` varchar(200) DEFAULT NULL,
  `project_pin_code` varchar(200) DEFAULT NULL,
  `project_start_date` varchar(200) DEFAULT NULL,
  `status` enum('1','0') DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `projects` (`projects_id`, `project_name`, `project_category`, `project_address`, `project_state`, `project_city`, `project_pin_code`, `project_start_date`, `status`, `created_at`, `updated_at`) VALUES
(7, 'Ambience Creacions', '21', 'Sector 22, Gurgaon', 'haryana', 'Gurgaon', '353454', '2024-09-26', NULL, '2024-09-06 07:15:42', '2024-09-06 07:15:42'),
(8, 'SKA Destiny One', '21', 'Zeta, Greater Noida', 'Uttar Pradesh', 'Noida', '353454', '2024-09-26', NULL, '2024-09-06 07:16:19', '2024-09-06 07:16:19'),
(9, 'Risland Sky Mansion', '24', 'Chhattarpur, New Delhi', 'Delhi', 'Delhi', '112121', '2024-09-30', NULL, '2024-09-06 07:17:02', '2024-09-06 07:17:02'),
(10, 'Smartworld One DXP', '22', 'Chhattarpur, New Delhi', 'Delhi', 'Delhi', '112121', '2024-09-29', NULL, '2024-09-06 07:17:24', '2024-09-06 07:17:24'),
(11, 'Mahendra Aura', '21', 'Palam Vihar etest', 'Haryana', 'Gurgaon', '232323', '2024-11-23', NULL, '2024-11-15 02:57:56', '2024-11-15 04:34:33'),
(12, 'Noida Ext.', '21', 'vivek', 'Select State', 'Gurgaon', '353454', '2024-11-20', NULL, '2024-11-15 04:59:04', '2024-11-15 04:59:04'),
(13, 'Mahendra Auraaa test', '22', 'Palam Vihar', 'Haryana t', 'Gurgaon', '343434', '2024-11-21', NULL, '2024-11-15 05:04:20', '2024-11-15 05:22:15'),
(14, 'Zara Rossa tste te arsa', '23', 'Palam Vihar', 'Haryana', 'Gurgaon', '252025', '2024-11-16', NULL, '2024-11-15 05:22:58', '2024-11-15 05:22:58');

-- --------------------------------------------------------

--
-- Table structure for table `property_listing`
--

CREATE TABLE `property_listing` (
  `listingID` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `title_slug` varchar(200) DEFAULT NULL,
  `location_icon` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `state` varchar(200) NOT NULL,
  `city` varchar(100) DEFAULT NULL,
  `latitude` decimal(10,7) NOT NULL,
  `longitude` decimal(10,7) NOT NULL,
  `price` decimal(15,2) NOT NULL,
  `catID` tinyint(1) NOT NULL,
  `projectID` tinyint(1) NOT NULL,
  `approvals` varchar(200) NOT NULL,
  `size` varchar(255) DEFAULT NULL,
  `unit_type` varchar(255) NOT NULL,
  `segment` varchar(255) NOT NULL,
  `area_no` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `listing_title` varchar(255) NOT NULL,
  `floor_plans` varchar(255) NOT NULL,
  `aminities` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`aminities`)),
  `status` enum('1','0') DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `query_details`
--

CREATE TABLE `query_details` (
  `query_detailsID` bigint(20) UNSIGNED NOT NULL,
  `sourcetype` varchar(200) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `city` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `query_about` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `query_details`
--

INSERT INTO `query_details` (`query_detailsID`, `sourcetype`, `name`, `email`, `phone`, `city`, `address`, `status`, `query_about`, `created_at`, `updated_at`) VALUES
(1, '2', 'Vivek Kumar', 'tech@orbtickets.com', '8279944015', 'agra', 'afsd', '2', NULL, '2024-08-05 07:41:08', '2024-09-06 00:11:58'),
(2, '2', 'Vivek Kumar', 'vivekvarol@gmail.com', '8279944015', 'Gurgaon', 'afsd', '1', 'test', '2024-08-06 03:03:54', '2024-09-06 00:11:48'),
(3, '2', '08989898989', 'sales.ithike@gmail.com', '08989898989', 'Agra', 'Kedar Nagar', '0', NULL, '2024-08-15 12:59:07', '2024-09-06 00:12:07'),
(4, 'example', 'John Doe', 'johndoe@example.com', '1234567890', 'New York', '123 Main St', '2', 'General Inquiry', '2024-08-29 09:53:52', '2024-09-06 00:11:25'),
(5, 'example2', 'John Doe', 'johndoe@example.com', '1234567890', 'New York', '123 Main St', '1', 'General Inquiry', '2024-08-29 09:54:14', '2024-09-06 00:12:14'),
(6, 'kp', 'John Doe', 'johndoe@example.com', '1234567890', 'New York', '123 Main St', '1', 'General Inquiry', '2024-08-29 09:57:42', '2024-09-06 00:12:36'),
(7, 'kp1', 'John Doe', 'johndoe@example.com', '1234567890', 'New York', '123 Main St', '0', 'General Inquiry', '2024-08-30 04:39:40', '2024-09-06 00:11:41'),
(8, 'kp1', 'Vivek Kumar', 'vivekvarol111@gmail.com', '8279244015', 'Gurgaon', 'afsd', '2', 'test', '2024-08-30 04:43:12', '2024-09-06 00:12:23'),
(9, 'Twitter', 'bhanu', 'bhanu@gmail.com', '1234567890', 'Mathura', 'hello dost', '1', NULL, '2024-09-02 06:08:54', '2024-09-06 00:12:10'),
(10, 'Instagram', 'kp', 'kp@gmail.com', '234234234234234', 'Noida', 'sdafasdfasdfasdfsda', '0', NULL, '2024-09-02 07:11:31', '2024-09-06 00:11:30'),
(11, '1', 'Vivek Kumar', 'vivekvarol@gmail.com', '8279944015', NULL, 'afsd', NULL, 'test', '2024-11-15 01:24:51', '2024-11-15 01:24:51'),
(12, '4', 'Indigo', 'vivekvarol@gmail.com', '90-(164)-188-555', 'Gurgaon', 'afsd', NULL, 'testafsd fasd', '2024-11-15 04:44:36', '2024-11-15 04:44:36');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `builders`
--
ALTER TABLE `builders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `listing`
--
ALTER TABLE `listing`
  ADD PRIMARY KEY (`listingID`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
  ADD PRIMARY KEY (`projects_id`);

--
-- Indexes for table `property_listing`
--
ALTER TABLE `property_listing`
  ADD PRIMARY KEY (`listingID`);

--
-- Indexes for table `query_details`
--
ALTER TABLE `query_details`
  ADD PRIMARY KEY (`query_detailsID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `builders`
--
ALTER TABLE `builders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `category_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `listing`
--
ALTER TABLE `listing`
  MODIFY `listingID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `projects_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `property_listing`
--
ALTER TABLE `property_listing`
  MODIFY `listingID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `query_details`
--
ALTER TABLE `query_details`
  MODIFY `query_detailsID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;

