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

START TRANSACTION;



--
-- Database: `home-care`
--

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

--
-- Table structure for table `about_us`
--

CREATE TABLE `about_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `photo` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `featured_photo` text DEFAULT NULL,
  `title_1` varchar(191) NOT NULL,
  `value_1` varchar(191) NOT NULL,
  `title_2` varchar(191) NOT NULL,
  `value_2` varchar(191) NOT NULL,
  `title_3` varchar(191) NOT NULL,
  `value_3` varchar(191) NOT NULL,
  `title_4` varchar(191) NOT NULL,
  `value_4` varchar(191) NOT NULL,
  `subtitle` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

--
-- Dumping data for table `about_us`
--

INSERT INTO `about_us` (`id`, `title`, `description`, `photo`, `created_at`, `updated_at`, `short_description`, `featured_photo`, `title_1`, `value_1`, `title_2`, `value_2`, `title_3`, `value_3`, `title_4`, `value_4`, `subtitle`) VALUES
(1, 'About Us', '<p>Kotha Bhada is Nepal&#39;s best and most trusted, ultimate online destination for finding, advertising, and managing Rental &amp; Homestay properties. It enables users to explore and find their desired property easily. In addition, Kotha Bhada has introduced Nepal&#39;s First Homestay platform, where users can discover unique vacation rental stays for their short &amp; long trips.<br />\r\nWith thousands of available rental &amp; homestay properties in Nepal, Kotha Bhada has a rich experience when it comes to looking after renters. Kotha Badha is equipped with value-added services that can support users through the entire process, from finding your dream property to packing and shifting your belongings, making it a one-stop solution. Kotha Bhada will be there for you at every step of your journey.officiis doloribus eaque sequi rerum dolores cupiditate. Aliquam quisquam natus modi in? Omnis dolor nesciunt reprehenderit eos incidunt ex, assumenda error sint, molestiae eligendi quasi, veritatis eius corporis cupiditate harum facilis amet! Corrupti, aperiam nihil rerum soluta ut aliquam unde inventore perferendis adipisci eligendi? Eum quis id cumque modi beatae, repellat qui numquam commodi obcaecati sunt nostrum. Laudantium sit pariatur dolore alias commodi in magnam distinctio. Error cupiditate ratione excepturi facere quos!</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>officiis doloribus eaque sequi rerum dolores cupiditate. Aliquam quisquam natus modi in? Omnis dolor nesciunt reprehenderit eos incidunt ex, assumenda error sint, molestiae eligendi quasi, veritatis eius corporis cupiditate harum facilis amet! Corrupti, aperiam nihil rerum soluta ut aliquam unde inventore perferendis adipisci eligendi? Eum quis id cumque modi beatae, repellat qui numquam commodi obcaecati sunt nostrum. Laudantium sit pariatur dolore alias commodi in magnam distinctio. Error cupiditate ratione excepturi facere quos!</p>\r\n\r\n<p>officiis doloribus eaque sequi rerum dolores cupiditate. Aliquam quisquam natus modi in? Omnis dolor nesciunt reprehenderit eos incidunt ex, assumenda error sint, molestiae eligendi quasi, veritatis eius corporis cupiditate harum facilis amet! Corrupti, aperiam nihil rerum soluta ut aliquam unde inventore perferendis adipisci eligendi? Eum quis id cumque modi beatae, repellat qui numquam commodi obcaecati sunt nostrum. Laudantium sit pariatur dolore alias commodi in magnam distinctio. Error cupiditate ratione excepturi facere quos!</p>', '220407094302.jpg', '2022-04-07 03:58:02', '2022-05-01 15:25:54', '<p>Kotha Bhada is Nepal&#39;s best and most trusted, ultimate online destination for finding, advertising, and managing Rental &amp; Homestay properties. It enables users to explore and find their desired property easily. In addition, Kotha Bhada has introduced Nepal&#39;s First Homestay platform, where users can discover unique vacation rental stays for their short &amp; long trips.<br />\r\nWith thousands of available rental &amp; homestay properties in Nepal, Kotha Bhada has a rich experience when it comes to looking after renters. Kotha Badha is equipped with value-added services that can support users through the entire process, from finding your dream property to packing and shifting your belongings, making it a one-stop solution. Kotha Bhada will be there for you at every step of your journey.officiis doloribus eaque sequi rerum dolores cupiditate. Aliquam quisquam natus modi in? Omnis dolor nesciunt reprehenderit eos incidunt ex, assumenda error sint, molestiae eligendi quasi, veritatis eius corporis cupiditate harum facilis amet! Corrupti, aperiam nihil rerum soluta ut aliquam unde inventore perferendis adipisci eligendi? Eum quis id cumque modi beatae, repellat qui numquam commodi obcaecati sunt nostrum. Laudantium sit pariatur dolore alias commodi in magnam distinctio. Error cupiditate ratione excepturi facere quos!</p>', '220407101626.webp', 'Customer', '48,000', 'Full-time researchers', '300', 'Professionals rely on Preqin', '170,000', 'Global Offices', '15', 'Sub tititle for about us');

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

--
-- Table structure for table `admin_menus`
--

CREATE TABLE `admin_menus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

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

--
-- Table structure for table `admin_menu_items`
--

CREATE TABLE `admin_menu_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `label` varchar(191) NOT NULL,
  `link` varchar(191) NOT NULL,
  `parent` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `sort` int(11) NOT NULL DEFAULT 0,
  `class` varchar(191) DEFAULT NULL,
  `menu` bigint(20) UNSIGNED DEFAULT NULL,
  `depth` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `role_id` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

--
-- Dumping data for table `admin_menu_items`
--

INSERT INTO `admin_menu_items` (`id`, `label`, `link`, `parent`, `sort`, `class`, `menu`, `depth`, `created_at`, `updated_at`, `role_id`) VALUES
(1, 'Home', '#', 0, 1, NULL, NULL, 1, '2022-09-08 07:09:29', '2022-09-08 07:09:29', 0);

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

--
-- Table structure for table `advertisements`
--

CREATE TABLE `advertisements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ad_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `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 `advertisement_positions`
--

CREATE TABLE `advertisement_positions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `advertisement_id` bigint(20) UNSIGNED NOT NULL,
  `position` varchar(191) COLLATE utf8mb4_unicode_ci NOT 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 `ask_for_quotes`
--

CREATE TABLE `ask_for_quotes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_of_residence` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `list_of_task_to_be_done` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `read` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ask_for_quotes`
--

INSERT INTO `ask_for_quotes` (`id`, `name`, `email`, `phone`, `address_of_residence`, `list_of_task_to_be_done`, `user_id`, `service_id`, `created_at`, `updated_at`, `read`) VALUES
(1, 'Admin Kothabhada', 'admin@kothabhada.com', '9860347384', 'sadasd', NULL, 1, 1, '2022-09-11 05:19:57', '2022-09-11 05:59:11', 1),
(2, 'Admin Kothabhada', 'admin@kothabhada.com', '9860347384', 'sadasd', NULL, 1, 1, '2022-09-11 05:20:31', '2022-09-11 05:59:01', 1);

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT 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 `blogs`
--

INSERT INTO `blogs` (`id`, `title`, `slug`, `photo`, `short_description`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Corrupti sit anim', 'corrupti-sit-anim', '220909023254.jpg', 'Ad assumenda sunt pe', '<p>sdfasddsasd</p>', 1, '2022-09-09 08:47:54', '2022-09-09 08:47:54');

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

--
-- Table structure for table `book_packages`
--

CREATE TABLE `book_packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_of_residence` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `read` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `book_packages`
--

INSERT INTO `book_packages` (`id`, `user_id`, `package_id`, `name`, `email`, `phone`, `address_of_residence`, `message`, `created_at`, `updated_at`, `read`) VALUES
(1, 1, 2, 'Admin Kothabhada', 'admin@kothabhada.com', '9860347384', 'Architecto laborum', 'sdfsdf', '2022-09-09 09:40:00', '2022-09-09 09:59:51', 0),
(2, 1, 2, 'Admin Kothabhada', 'admin@kothabhada.com', '9860347384', 'sadasd', 'asdasd', '2022-09-11 05:11:43', '2022-09-11 05:11:43', 0),
(3, 1, 2, 'Admin Kothabhada', 'admin@kothabhada.com', '9860347384', 'sadasd', 'asdasd', '2022-09-11 05:12:31', '2022-09-11 05:12:31', 0);

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

--
-- Table structure for table `bottom_links`
--

CREATE TABLE `bottom_links` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int(11) NOT NULL,
  `status` int(11) NOT 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 `bottom_links`
--

INSERT INTO `bottom_links` (`id`, `title`, `link`, `order`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Mission & Vision', 'Aut cumque omnis rem', 9, 1, '2022-09-08 06:59:06', '2022-09-08 07:00:10'),
(2, 'To the students', 'Est qui ea deserunt', 44, 0, '2022-09-08 06:59:12', '2022-09-08 07:00:28'),
(3, 'Terms and Condition', 'Mollitia dolor volup', 83, 1, '2022-09-08 06:59:18', '2022-09-08 07:00:40');

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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `parent` bigint(20) UNSIGNED DEFAULT NULL,
  `depth` int(11) NOT NULL DEFAULT 1,
  `order` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `slug` varchar(191) DEFAULT NULL,
  `meta_title` varchar(191) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_keyword` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

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

INSERT INTO `categories` (`id`, `title`, `parent`, `depth`, `order`, `status`, `created_at`, `updated_at`, `slug`, `meta_title`, `meta_description`, `meta_keyword`) VALUES
(1, 'Residential Property', NULL, 1, 1, 1, '2022-04-06 01:13:15', '2022-05-02 18:22:02', 'Residential Property', NULL, NULL, NULL),
(2, '1 BHK', 1, 2, 1, 1, '2022-04-06 01:21:45', '2022-04-06 01:21:45', '1 BHK', NULL, NULL, NULL),
(3, 'Commercial', NULL, 1, 2, 1, '2022-04-12 01:56:56', '2022-04-12 01:56:56', 'Commercial', NULL, NULL, NULL),
(4, 'sadasd', 3, 2, 2, 0, '2022-04-12 01:57:12', '2022-05-07 21:16:13', 'sadasd', NULL, NULL, NULL),
(6, '2BHK', 1, 2, 2, 1, '2022-05-02 17:28:24', '2022-05-02 17:28:24', '2BHK', NULL, NULL, NULL),
(7, '3BHK', 1, 2, 3, 0, '2022-05-02 17:29:39', '2022-05-02 18:35:58', '3BHK', NULL, NULL, NULL),
(8, '4BHK', 1, 2, 4, 1, '2022-05-02 17:30:09', '2022-05-02 17:30:09', '4BHK', NULL, NULL, NULL),
(9, 'FLAT', 1, 2, 5, 1, '2022-05-02 17:30:33', '2022-05-02 17:30:33', 'FLAT', NULL, NULL, NULL),
(10, 'HOUSE', 1, 2, 6, 1, '2022-05-02 17:32:12', '2022-05-02 17:32:12', 'HOUSE', NULL, NULL, NULL),
(11, '1 SHUTTER', 3, 2, 1, 1, '2022-05-02 17:32:40', '2022-05-02 17:32:40', '1 SHUTTER', NULL, NULL, NULL),
(12, 'Appartment/Housing', 1, 2, 3, 1, '2022-05-02 18:25:01', '2022-05-08 13:12:13', 'Appartment/Housing', NULL, NULL, NULL),
(13, 'Office Space', 3, 2, 4, 1, '2022-05-02 18:27:07', '2022-05-02 18:27:07', 'Office Space', NULL, NULL, NULL),
(14, 'Shop/Showroom', 3, 2, 5, 1, '2022-05-02 18:28:33', '2022-05-02 18:28:33', 'Shop/Showroom', NULL, NULL, NULL),
(15, 'Commercial land', 3, 2, 6, 1, '2022-05-02 18:29:10', '2022-05-02 18:29:10', 'Commercial land', NULL, NULL, NULL),
(16, 'Warehouse/Godown', 3, 2, 6, 1, '2022-05-02 18:29:56', '2022-05-02 18:29:56', 'Warehouse/Godown', NULL, NULL, NULL),
(17, 'OTHER PROPERTISE TYPE', NULL, 1, 4, 0, '2022-05-02 18:31:02', '2022-05-09 12:41:30', 'OTHER PROPERTISE TYPE', NULL, NULL, NULL),
(18, 'Industrial Building', 3, 2, 7, 1, '2022-05-02 18:33:14', '2022-05-02 18:33:14', 'Industrial Building', NULL, NULL, NULL),
(19, 'Agriculture Land', 17, 2, 1, 1, '2022-05-02 18:33:45', '2022-05-02 18:33:45', 'Agriculture Land', NULL, NULL, NULL),
(20, 'Farm House', 17, 2, 2, 1, '2022-05-02 18:34:39', '2022-05-02 18:34:39', 'Farm House', NULL, NULL, NULL);

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

--
-- Table structure for table `contact_categories`
--

CREATE TABLE `contact_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `contact_id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `phone` varchar(191) NOT NULL,
  `total_area` varchar(191) NOT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `location` longtext DEFAULT NULL,
  `rental_type` longtext DEFAULT NULL,
  `deposit_slip` varchar(191) DEFAULT NULL,
  `read` int(11) NOT NULL DEFAULT 0,
  `email` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

--
-- Dumping data for table `contact_us`
--

INSERT INTO `contact_us` (`id`, `name`, `phone`, `total_area`, `message`, `created_at`, `updated_at`, `location`, `rental_type`, `deposit_slip`, `read`, `email`) VALUES
(1, 'Surendra Ojha', '9860347384', 'Samakhusi', 'my message', '2022-04-06 01:22:21', '2022-09-09 09:59:15', '[\"Lazimpat Kathmandu\",\"Baneshwor,Kathmandu\",\"Sundhara Kathmandu\"]', '[\"1 BHK\"]', NULL, 0, NULL),
(2, 'Surendra Ojha', '9860347384', 'sadas', 'sadas', '2022-04-08 03:13:26', '2022-04-08 03:13:26', '[\"Baneshwor,Kathmandu\"]', '[\"1 BHK\"]', NULL, 0, NULL),
(3, 'testing', '987655667776', 'samakushi', 'testing testin testing testing', '2022-05-02 22:10:37', '2022-05-02 22:10:37', '[\"Baneshwor,Kathmandu\"]', '[\"4BHK\"]', NULL, 0, NULL),
(4, 'testing', '987655667776', 'samakushi', 'With thoor cupiditate ratione excepturi facere quos!With thoor cupiditate ratione excepturi facere quos!With thoor cupiditate ratione excepturi facere quos!With thoor cupiditate ratione excepturi facere quos!', '2022-05-02 22:12:10', '2022-05-02 22:12:10', '[\"Lazimpat Kathmandu\"]', '[\"1 BHK\",\"3BHK\",\"4BHK\",\"Agriculture Land\"]', NULL, 0, NULL),
(5, 'hongkong bazar', '987655667776', 'samakushi', 'from customize service, from customize service', '2022-05-03 23:22:30', '2022-05-03 23:22:30', '[\"Pokhara\"]', '[\"4BHK\"]', NULL, 0, NULL),
(6, 'hongkong bazar', '987655667776', 'samakushi', 'header find me a room', '2022-05-03 23:24:45', '2022-05-03 23:24:45', '[\"Budhanilkantha Kathmandu\"]', '[\"Shop\\/Showroom\"]', NULL, 0, NULL);

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

--
-- Table structure for table `customer_stories`
--

CREATE TABLE `customer_stories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `photo` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `activity` varchar(191) NOT NULL,
  `rating` double(8,2) NOT NULL,
  `order` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `message` text NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

--
-- Dumping data for table `customer_stories`
--

INSERT INTO `customer_stories` (`id`, `photo`, `name`, `activity`, `rating`, `order`, `status`, `created_at`, `updated_at`, `message`, `user_id`) VALUES
(1, NULL, 'test 1', 'test', 3.00, 1, 1, '2022-05-02 20:15:00', '2022-05-02 20:15:00', 'test test test test test test test test test test test test', NULL),
(2, '220502044436.jpg', 'kothabhada', 'hello', 3.00, 2, 1, '2022-05-02 21:44:36', '2022-05-02 21:44:36', 'Kotha Bhada is Nepal\'s best and most trusted, ultimate online destination for finding, advertising, and managing Rental & Homestay properties. It enables users to explore and find their desired property easily. In addition, Kotha Bhada has introduced Nepal\'s First Homestay platform, where users can discover unique vacation rental stays for their short & long trips', NULL),
(3, '220502044827.jpg', 'kothabhada', 'hello', 5.00, 3, 1, '2022-05-02 21:48:27', '2022-05-02 21:48:27', 'With thousands of available rental & homestay properties in Nepal, Kotha Bhada has a rich experience when it comes to looking after renters. Kotha Badha is equipped with value-added services that can support users through the entire process, from finding your dream property to packing and shifting your belongings, making it a one-stop solution. Kotha Bhada will be there for you at every step of your journey.officiis doloribus eaque sequi rerum dolores cupiditate. Aliquam quisquam natus modi in? Omnis dolor nesciunt reprehenderit eos incidunt ex, assumenda error sint, molestiae eligendi quasi, veritatis eius corporis cupiditate harum facilis amet! Corrupti, aperiam nihil rerum soluta ut aliquam unde inventore perferendis adipisci eligendi? Eum quis id cumque modi beatae, repellat qui numquam commodi obcaecati sunt nostrum. Laudantium sit pariatur dolore alias commodi in magnam distinctio. Error cupiditate ratione excepturi facere quos!', NULL),
(4, '220502044945.jpg', 'kothabhada', 'hello', 5.00, 4, 1, '2022-05-02 21:49:45', '2022-05-02 21:49:45', 'With thousands of available rental & homestay properties in Nepal, Kotha Bhada has a rich experience when it comes to looking after renters. Kotha Badha is equipped with value-added services that can support users through the entire process, from finding your dream property to packing and shifting your belongings, making it a one-stop solution. Kotha Bhada will be there for you at every step of your journey.officiis doloribus eaque sequi rerum dolores cupiditate. Aliquam quisquam natus modi in? Omnis dolor nesciunt reprehenderit eos incidunt ex, assumenda error sint, molestiae eligendi quasi, veritatis eius corporis cupiditate harum facilis amet! Corrupti, aperiam nihil rerum soluta ut aliquam unde inventore perferendis adipisci eligendi? Eum quis id cumque modi beatae, repellat qui numquam commodi obcaecati sunt nostrum. Laudantium sit pariatur dolore alias commodi in magnam distinctio. Error cupiditate ratione excepturi facere quos!\r\nWith thousands of available rental & homestay properties in Nepal, Kotha Bhada has a rich experience when it comes to looking after renters. Kotha Badha is equipped with value-added services that can support users through the entire process, from finding your dream property to packing and shifting your belongings, making it a one-stop solution. Kotha Bhada will be there for you at every step of your journey.officiis doloribus eaque sequi rerum dolores cupiditate. Aliquam quisquam natus modi in? Omnis dolor nesciunt reprehenderit eos incidunt ex, assumenda error sint, molestiae eligendi quasi, veritatis eius corporis cupiditate harum facilis amet! Corrupti, aperiam nihil rerum soluta ut aliquam unde inventore perferendis adipisci eligendi? Eum quis id cumque modi beatae, repellat qui numquam commodi obcaecati sunt nostrum. Laudantium sit pariatur dolore alias commodi in magnam distinctio. Error cupiditate ratione excepturi facere quos!', NULL),
(5, '220502045122.jpg', 'kothabhada', 'hello', 2.00, 5, 1, '2022-05-02 21:51:22', '2022-05-02 21:53:56', 'With thoor cupiditate ratione excepturi facere quos!\r\n\r\nWith thoor cupiditate ratione excepturi facere quos!', NULL),
(6, '220502045456.jpg', 'kothabhada', 'hello', 3.00, 6, 1, '2022-05-02 21:54:56', '2022-05-02 21:54:56', 'With thoor cupiditate ratione excepturi facere quos!With thoor cupiditate ratione excepturi facere quos!With thoor cupiditate ratione excepturi facere quos!', NULL),
(7, '220504015149.jpg', 'user review', 'enter activity', 4.00, 7, 1, '2022-05-04 18:51:49', '2022-05-04 18:53:15', 'this is review testing from user.', NULL);

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(191) 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=utf16;

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

--
-- Table structure for table `f_a_q_s`
--

CREATE TABLE `f_a_q_s` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `property_id` bigint(20) UNSIGNED DEFAULT NULL,
  `question` varchar(191) NOT NULL,
  `answer` varchar(191) NOT NULL,
  `featured` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `order` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

--
-- Dumping data for table `f_a_q_s`
--

INSERT INTO `f_a_q_s` (`id`, `property_id`, `question`, `answer`, `featured`, `status`, `created_at`, `updated_at`, `order`) VALUES
(1, NULL, 'WHat is RAM?', 'Random Access Memory', 0, 1, '2022-04-08 00:07:25', '2022-04-08 00:07:25', 1),
(2, NULL, 'WHat is ROM?', 'Read Only Memory', 0, 1, '2022-04-08 00:07:50', '2022-04-08 00:07:50', 2),
(3, 3, 'test 1', 'test 1 test 1 test 1 test 1 test 1 test 1 test 1 test 1 test 1 test 1 test 1 test 1', 0, 1, '2022-05-02 22:16:40', '2022-05-02 22:16:40', 1);

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

--
-- Table structure for table `how_we_works`
--

CREATE TABLE `how_we_works` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int(11) NOT 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 `how_we_works`
--

INSERT INTO `how_we_works` (`id`, `title`, `value`, `photo`, `order`, `created_at`, `updated_at`) VALUES
(1, 'Vel hic ea voluptate', 'Similique ipsa faci', '220908103330.png', 4, '2022-09-08 04:48:30', '2022-09-08 04:48:30'),
(2, 'Voluptatem anim ex o', 'Eos elit repellendu', '220908103344.png', 7, '2022-09-08 04:48:44', '2022-09-08 04:48:44'),
(3, 'Qui id sint est con', 'Facilis anim nihil e', '220908103356.png', 22, '2022-09-08 04:48:56', '2022-09-08 04:48:56');

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

--
-- Table structure for table `metas`
--

CREATE TABLE `metas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meta_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_keyword` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `module` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

--
-- 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, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1),
(4, '2017_08_11_073824_create_menus_wp_table', 1),
(5, '2017_08_11_074006_create_menu_items_wp_table', 1),
(6, '2019_01_05_293551_add-role-id-to-menu-items-table', 1),
(7, '2019_08_19_000000_create_failed_jobs_table', 1),
(8, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(9, '2022_03_23_104831_create_sessions_table', 1),
(10, '2022_03_24_045438_create_settings_table', 1),
(11, '2022_03_24_060633_add_role_user', 1),
(12, '2022_03_24_090502_create_our_services_table', 1),
(13, '2022_03_27_043203_create_user_profiles_table', 1),
(14, '2022_03_27_043943_add_gender_user', 1),
(15, '2022_03_27_050101_add_user_phone', 1),
(16, '2022_03_27_072636_create_locations_table', 1),
(17, '2022_03_27_075813_create_categories_table', 1),
(18, '2022_03_27_084803_create_customer_stories_table', 1),
(19, '2022_03_27_101202_add_message_testimonial', 1),
(20, '2022_03_28_043054_create_properties_table', 1),
(21, '2022_03_28_043649_create_features_table', 1),
(22, '2022_03_28_043725_create_floors_table', 1),
(23, '2022_03_28_043745_create_road_sizes_table', 1),
(24, '2022_03_28_060903_add_token_status_user', 1),
(25, '2022_03_28_071432_add_profile_column', 1),
(26, '2022_03_28_071910_create_profile_locations_table', 1),
(27, '2022_03_28_080156_add_profile_columns', 1),
(28, '2022_03_30_051635_add_additional_column_property', 1),
(29, '2022_03_30_052414_drop_property_column', 1),
(30, '2022_03_30_053008_add_location_id_property', 1),
(31, '2022_03_30_063954_add_nullable_property', 1),
(32, '2022_03_30_070104_add_fullfilled_property', 1),
(33, '2022_03_30_071318_add_expiration_property', 1),
(34, '2022_03_30_074447_add_column_property_add_i_d', 1),
(35, '2022_03_30_100551_create_property_features_table', 1),
(36, '2022_03_30_102319_add_both_property', 1),
(37, '2022_03_31_042722_add_column_property_contact_number', 1),
(38, '2022_03_31_044859_add_column_price_negotiable', 1),
(39, '2022_03_31_052529_create_featured_properties_table', 1),
(40, '2022_03_31_052549_create_recommended_properties_table', 1),
(41, '2022_03_31_064248_create_about_us_table', 1),
(42, '2022_03_31_074014_add_short_description_about_us', 1),
(43, '2022_03_31_074822_add_settings_banner', 1),
(44, '2022_04_01_041548_create_home_page_products_table', 1),
(45, '2022_04_01_061432_create_contact_us_table', 1),
(46, '2022_04_01_061816_create_contact_categories_table', 1),
(47, '2022_04_01_072307_add_status_location', 1),
(48, '2022_04_01_082851_add_slug_property', 1),
(49, '2022_04_01_092111_create_shift_homes_table', 1),
(50, '2022_04_01_105441_create_partners_table', 1),
(51, '2022_04_03_051159_add_column_contact_us', 1),
(52, '2022_04_03_064907_create_wish_lists_table', 1),
(53, '2022_04_03_102606_create_f_a_q_s_table', 1),
(54, '2022_04_04_042651_add_column_f_a_q', 1),
(55, '2022_04_04_055056_create_support_forums_table', 1),
(56, '2022_04_04_063434_create_like_forums_table', 1),
(57, '2022_04_04_075133_create_news_letters_table', 1),
(58, '2022_04_05_055504_create_purposes_table', 1),
(59, '2022_04_05_063229_add_purpose_property', 1),
(60, '2022_04_05_073238_drop_purpose_property', 1),
(61, '2022_04_06_072231_create_property_photos_table', 2),
(62, '2022_04_06_083701_create_quick_links_table', 3),
(63, '2022_04_06_100341_create_home_stay_videos_table', 4),
(65, '2022_04_06_102302_add_video_text_setting', 5),
(66, '2022_04_07_050605_add_capacity_property', 6),
(67, '2022_04_07_070822_create_pages_table', 7),
(68, '2022_04_07_094736_add_feature_photo_about_us', 8),
(69, '2022_04_08_044031_add_home_page_about_us_settings', 9),
(70, '2022_04_08_044711_create_messages_table', 10),
(71, '2022_04_08_081542_add_youtube_setting', 11),
(72, '2022_04_08_083647_add_subtitle_page', 12),
(73, '2022_04_08_084129_add_subtitle_about_us', 13),
(74, '2022_04_12_052943_add_column_setting_add_video', 14),
(75, '2022_04_20_045408_create_home_types_table', 15),
(76, '2022_04_20_045638_create_home_facilities_table', 15),
(77, '2022_04_20_045729_create_local_area_facilities_table', 16),
(78, '2022_04_20_045931_create_rooms_table', 16),
(79, '2022_04_20_083803_create_family_welcomes_table', 17),
(80, '2022_04_20_090516_create_shift_home_items_table', 18),
(81, '2022_04_20_094954_add_item_shift_home', 19),
(82, '2022_04_20_100450_nullable_shift', 20),
(83, '2022_04_26_085221_create_boost_posts_table', 21),
(84, '2022_05_01_052612_add_video_code_property', 22),
(85, '2022_05_02_080257_create_advertisements_table', 23),
(86, '2022_05_02_081740_create_advertisement_positions_table', 23),
(87, '2022_05_02_095743_add_video_field_property', 23),
(88, '2022_05_03_043040_add_column_read_shift_home', 23),
(89, '2022_05_03_051112_nullable_dob', 23),
(90, '2022_05_03_090602_create_boosting_steps_table', 23),
(91, '2022_05_03_091434_add_boost_price_setting', 23),
(92, '2022_05_03_092219_create_boost_features_table', 23),
(93, '2022_05_03_094734_add_q_r_code_setting', 23),
(94, '2022_05_04_054639_add_user_id_testimonial', 24),
(95, '2022_05_04_065916_add_deposit_slip_find_me_room', 24),
(96, '2022_05_04_073559_add_deposit_slip_shift_home', 24),
(97, '2022_05_06_075626_change_price_property', 25),
(98, '2022_05_09_080010_add_category_purpose', 26),
(99, '2022_05_16_044442_add_boost_detail_setting', 26),
(100, '2022_05_16_055459_vendor_dashboard_content', 26),
(101, '2022_05_16_061147_add_shift_home_content', 26),
(102, '2022_05_16_102044_add_slug_category', 26),
(103, '2022_05_17_071135_change_shift_home_content', 27),
(104, '2022_05_18_055725_add_column_property_and_settings', 27),
(105, '2022_05_19_072927_add_bed_rooom_nullable', 27),
(106, '2022_05_20_045025_create_boost_subscriptions_table', 27),
(107, '2022_05_20_060935_add_price_to_subscription', 27),
(108, '2022_05_20_100858_add_subscription_boost_request', 27),
(109, '2022_06_03_093257_change_terms', 27),
(110, '2022_06_17_130516_add_message_shift_home', 27),
(111, '2022_06_17_154730_add_status_contact_us', 27),
(112, '2022_06_19_122954_add_tagline_setting', 27),
(113, '2022_06_26_104728_add_status_shift_home', 27),
(114, '2022_06_26_113845_add_meta_title_property', 27),
(115, '2022_06_26_120347_create_metas_table', 27),
(116, '2022_06_26_144516_add_module_name_meta', 27),
(117, '2022_06_26_153156_add_meta_category', 27),
(118, '2022_06_26_155700_add_meta_keyword_property_category', 27),
(119, '2022_06_27_102518_add_location_meta', 27),
(120, '2022_08_24_163837_add_email_c_ontact_us', 27),
(121, '2022_08_25_101333_add_email_shift_home', 27),
(122, '2022_09_06_102406_create_services_table', 27),
(123, '2022_09_06_112325_create_packages_table', 27),
(124, '2022_09_06_141442_create_why_choose_us_table', 27),
(125, '2022_09_06_152522_create_how_we_works_table', 27),
(126, '2022_09_07_121700_create_sliders_table', 27),
(127, '2022_09_07_140131_create_ask_for_quotes_table', 27),
(128, '2022_09_07_150201_add_fields_user', 27),
(132, '2022_09_08_105548_modify_setting_table', 28),
(133, '2022_09_08_123722_create_bottom_links_table', 29),
(134, '2022_09_09_131653_create_blogs_table', 30),
(135, '2022_09_09_145637_create_book_packages_table', 31),
(136, '2022_09_09_153605_add_read_book_package', 32),
(137, '2022_09_11_114305_add_read_ask_for_quote', 33);

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

--
-- Table structure for table `news_letters`
--

CREATE TABLE `news_letters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

--
-- Dumping data for table `news_letters`
--

INSERT INTO `news_letters` (`id`, `email`, `created_at`, `updated_at`) VALUES
(1, 'test@gmail.com', '2022-05-04 00:06:38', '2022-05-04 00:06:38'),
(2, 'sieunhangiansv882@gmail.com', '2022-05-11 13:53:47', '2022-05-11 13:53:47'),
(3, 'sojha060@gmail.com', '2022-09-11 06:02:05', '2022-09-11 06:02:05');

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

--
-- Table structure for table `our_services`
--

CREATE TABLE `our_services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `order` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_id` bigint(20) UNSIGNED DEFAULT NULL,
  `included_points` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`included_points`)),
  `order` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  `description` text COLLATE utf8mb4_unicode_ci 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 `packages`
--

INSERT INTO `packages` (`id`, `title`, `slug`, `price`, `service_id`, `included_points`, `order`, `status`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Et dicta earum quasi', 'et-dicta-earum-quasi', '521', 1, '[\"Occaecat perferendis\",\"Facere eveniet aliq\",\"Sed sunt odio ut vol\",\"Autem corrupti at c\",\"Magnam ut ab harum e\",\"Do dolores amet lau\",\"Velit libero dolor e\",\"Labore rerum nostrud\"]', 100, 1, '<p>description</p>', '2022-09-09 09:10:02', '2022-09-09 09:10:02'),
(2, 'Consequat Error qui', 'consequat-error-qui', '795', 1, '[\"Dolore quo repudiand\",\"Voluptate esse natu\",\"Odio blanditiis ipsa\",\"Laborum id fugit f\",\"Alias consequatur ex\",\"Illo laboris qui cup\",\"Iure nihil culpa vol\",\"Quam quia quis exerc\"]', 3, 1, '<p>asdasd</p>', '2022-09-09 09:10:15', '2022-09-09 09:10:15'),
(3, 'Ipsum omnis quae eiu', 'ipsum-omnis-quae-eiu', '198', 1, '[\"Molestiae voluptatum\",\"Cupidatat consequatu\",\"Molestias maxime eiu\",\"Et sunt molestias ve\",\"Tempore quam quasi\",\"Autem quia iste quia\",\"Quo consequuntur est\",\"Repudiandae quis mag\"]', 50, 1, '<p>sadasd</p>', '2022-09-09 09:10:25', '2022-09-09 09:10:25');

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `photo` varchar(191) DEFAULT NULL,
  `parent` bigint(20) UNSIGNED DEFAULT NULL,
  `order` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `subtitle` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `title`, `slug`, `description`, `photo`, `parent`, `order`, `status`, `created_at`, `updated_at`, `subtitle`) VALUES
(1, 'Terms and Conditions', 'terms-and-conditions', '<p>&nbsp;</p>\r\n\r\n<h1><strong>Kotha Bhada Terms of Use</strong></h1>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Last Updated: 2/5/2022</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Welcome to the Kotha Bhada dot com Terms of Use agreement. For the intent of this agreement, &ldquo;Website&rdquo; refers to the Company&rsquo;s website, which can be accessed at www.Kothabhada.com. &ldquo;Service&rdquo; refers to the Company&rsquo;s services accessed through the website, in which users can post or search a property for rent. The terms &ldquo;we,&rdquo; &ldquo;us,&rdquo; and &ldquo;our&rdquo; represents the Company. &ldquo;You&rdquo; describes you as a user of our website or our Service.&nbsp;</p>\r\n\r\n<p>The given Terms of Use apply when you view or use our Service via our website at www.kothabhada.com.&nbsp;&nbsp;</p>\r\n\r\n<p>Please study the following terms carefully. By entering or using the Service, you indicate your understanding of these Terms of Use.<strong>&nbsp;If you disagree to be restrained by these Terms of Use in their entirety, you may not access or use the Service</strong>.&nbsp;&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>PRIVACY POLICY</strong></p>\r\n\r\n<p>The Company values the solitude of our Service users. Please study the Company&rsquo;s <a href=\"https://kothabhada.com/page/privacy-policy\"><strong>Privacy Policy</strong></a>, which clarifies how we gather, utilize, and disclose information that pertains to your privacy or security. When you enter or use our Service, you indicate your agreement to the Privacy Policy and these Terms of Use.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>ABOUT THE SERVICE</strong></p>\r\n\r\n<p>The Service privileges you to search for rental properties. We offer a platform for our property owners and property renters to explore the possibilities of a rental. Additionally, we also offer to find a room through an agent and home shifting facility.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>REGISTRATION; REGULATIONS FOR USER CONDUCT AND USE OF THE SERVICE</strong></p>\r\n\r\n<p>You should be above 18 years and a resident of Nepal to register and use the Service.</p>\r\n\r\n<p>In case you are a user who signs up for Service, you have to make a personalized account containing your mail id and a password to access the Service and obtain messages from the Company. You can also use Google and Facebook to log in. You approve to inform us instantly of any uncertified use of the password and/or account. The Company will not be answerable for any liabilities, losses, or harms arising out from the uncertified use of your member name, password, and/or account.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>USE RESTRICTIONS</strong></p>\r\n\r\n<p>Your license to use the website is prepared upon the following use, posting, and conduct limitations:&nbsp;</p>\r\n\r\n<p>You authorize that you will not be under any prospects:</p>\r\n\r\n<p>&middot; enter the Service for any reason other than your personal, non-commercial use solely as authorized by the standard functionality of the Service,</p>\r\n\r\n<p>&middot; gather or harvest any personal data of any user of the Site or the Service&nbsp;</p>\r\n\r\n<p>&middot; use Site or Service for the solicitation of business in practice of business or connection with a commercial enterprise;</p>\r\n\r\n<p>&middot; disseminate any part or parts of the website or the Service without our direct written authorization.</p>\r\n\r\n<p>&middot; use the Service for any illegal intent or the promotion of prohibited activities;</p>\r\n\r\n<p>&middot; attempt to, or harass, abuse or hurt another person or group;</p>\r\n\r\n<p>&middot; use another user&rsquo;s account without authorization;</p>\r\n\r\n<p>&middot; deliberately allow another user to access your account;&nbsp;</p>\r\n\r\n<p>&middot; provide false or incorrect data when signing into the account;</p>\r\n\r\n<p>&middot; intrude or attempt to intrude with the proper processing of the Service;</p>\r\n\r\n<p>&middot; make any robotic use of the site, the Service, or the affiliated systems, or take any measure that we consider in levying or in possibly levying an excessive or disproportionately large burden on our servers or network infrastructure;</p>\r\n\r\n<p>&middot; detour any robot exclusion headers or other measures we take to limit entry to the Service, or use our software or technology to scrape, spider, or crawl the Service or harvest or contrive data;&nbsp;</p>\r\n\r\n<p>&middot; evade, disable or otherwise interfere with any security-related elements of Service or elements that avert or regulate use or copying of essence, or enforce restrictions on the use of the Service or the content accessible via the Service; or&nbsp;</p>\r\n\r\n<p>&middot; issue or connect to harmful content, including deliberate damage or deranging another user&rsquo;s browser or computer.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>POSTING AND CONDUCT DIMINUTION</strong></p>\r\n\r\n<p>When you create your own customized account, you may be able to provide your property description, Prices, photos of the property, etc. (&ldquo;User Content&rdquo;) to the Service. You are solely accountable for the User Content that you issue, upload, connect to, or otherwise make available through the Service.&nbsp;</p>\r\n\r\n<p>&nbsp;You accept that we are only acting as a passive channel for your online dispensation and publication of the User Content. The Company, however, withholds the right to remove any User Content from the website at its sole circumspection.</p>\r\n\r\n<p>We authorize you to use and access our Service, subject to the following conditions neighboring User Content. You agree that failure to adhere to any of these circumstances comprises a material violation&nbsp;of these Terms.&nbsp;</p>\r\n\r\n<p>By circulating and submitting any User Content while using the Service, you should agree to the given statements:</p>\r\n\r\n<p>&middot; You are solely accountable for your account and activity which occurs while marked into or while using your account;</p>\r\n\r\n<p>&middot; You will not post details that are malicious, defamatory, incorrect, or inaccurate;</p>\r\n\r\n<p>&middot; You will not post any statement that is abusive, threatening, obscene, defamatory, libelous, or racially, sexually, religiously, or otherwise objectionable and offensive;</p>\r\n\r\n<p>&middot; You maintain all ownership rights in your User Content, but you are mandated to grant the following rights to the website and users of the Service as set forth more completely under the &ldquo;Intellectual Property&rdquo; provisions below: When you upload or post User Content to the website or the Service, you consent to the website a worldwide, non-exclusive, royalty-free, transferable license to use, reproduce, distribute, formulate derivative works of, display, and execute that content is linked with the condition of the Service; and you give to each user of our Service, a worldwide, non-exclusive, royalty-free authorize to access your User Content through the Service, and to use, reproduce, distribute, prepare imitative works of, display and act such content to the extent permitted by the Service and under these Terms of Use;</p>\r\n\r\n<p>&middot; You will not post content that is copyrighted or subject to third party proprietary rights, along with privacy, publicity, trade secret, or others unless you are the owner of such rights or have the reasonable authorization from their rightful owner to post such content, mainly; and</p>\r\n\r\n<p>&middot; You approve that we have the right to decide whether your User Content requests are relevant and comply with these Terms of Service, terminate any and/or all of your requests, and remove your account with or without prior notice.</p>\r\n\r\n<p>You comprehend and approve that any disadvantage, loss, or damage that occurs due to any User Content that you make public or pass through your use of the Service is solely your responsibility. The site is not accountable for any public exhibit or abuse of your User Content.&nbsp;</p>\r\n\r\n<p>The site does not, and cannot, pre-screen or observe all User Content. However, at our preference, we, or the technology we operate, may attend and/or record your dealings with the Service or other Users.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>ONLINE CONTENT DISCLAIMER</strong></p>\r\n\r\n<p>Kotha Bhada is only a medium that connects the owners and the customers in a platform and doesn&#39;t have any control over any transaction between the owner and the Agent or customer. The details displayed on the website are for information purposes only. We do not tend to hurt anyone&#39;s feelings or emotions by our conduct. Information concerning the properties, properties detail, location data, and listings has been sourced from numerous sources on the best effort basis. Nothing conducted here shall be deemed to comprise legal advice, solicitations, marketing, offers, and invitation to offer by any entity.</p>\r\n\r\n<p>Beliefs, guidance, information, offers, or other data or content made public through the Service, but not literally by the site, are those of their authors and should not necessarily be relied upon. Such authors are solely answerable for such content.&nbsp;</p>\r\n\r\n<p>We do not certify the accuracy, absoluteness, or usefulness of any data on the Site or the Service. We do not embrace or endorse or are accountable for the precision or dependability of any opinion, advice, or statement other parties make. We take no obligation and bear no liability for any User Content that you or any other user or third party posts or sends through the Service. Under no possibilities will we be answerable for any loss or damage resulting from anyone&rsquo;s reliance on information or other content posted on the Service or transmitted to users.</p>\r\n\r\n<p>Though we seek to implement these Terms of Use, you may be exposed to User Content that is incorrect or objectionable when you use or access the Site or the Service. We withhold the right but have no burden to monitor the materials posted in the public areas of the Site or the Service or modify or deny a user&rsquo;s access to the Service or carry out other suitable action if a user breaches these Terms of Use or encounters in any activity that disobeys the rights of any person or entity or which we consider unlawful, offensive, abusive, harmful or malicious. The Company shall have the right to remove any material that in its sole opinion violates or is alleged to violate the law or this agreement or which might be offensive, violate the rights, harm, or jeopardize the safety of users or others. Unauthorized use may result in unlawful and/or civil prosecution under State and local law. If you become aware of misuse of our Service or violation of these Terms of Use, please get in touch with us at info@kothabhada.com.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>LINKS TO OTHER SITES AND/OR MATERIALS</strong></p>\r\n\r\n<p>As part of the Service, we may deliver you suitable links to a third-party website(s) (&ldquo;Third Party Sites&rdquo;) as well as content or objects belonging to or emanating from third parties (the &ldquo;Third Party Applications, Software or Content&rdquo;). These ties are provided as a polish to Service subscribers. We have no control over Third Party Sites or Third Party Applications, Software or Content, or the advertisements, materials, information, goods, or services obtainable on these Third Party Sites or Third Party Applications, Software, or Content. Such Third-Party Sites and Third Party Applications, Software, or Content are not scrutinized, monitored, or checked for precision, appropriateness, or wholeness. We are not accountable for any Third Party Sites accessed through the Site or any Third Party Applications, Software, or Content posted on, accessible through, or installed from the site, including the content, precision, offensiveness, opinions, reliability, privacy practices, or other policies of or included in the Third Party Sites or the Third Party Applications, Software or Content. Inclusion of, linking to, or allowing the use or installation of any Third Party Site or any Third Party Applications, Software, or Content does not allude to our approval or endorsement. Suppose you determine to leave the site and access the Third Party Sites or to use or install any Third Party Applications, Software, or Content. In that case, you do so at your peril, and you should be conscious that our terms and policies, including these Terms of Use, no longer govern. You should review the applicable terms and policies, including privacy and data conference practices, of any Third Party Site to which you guide from the site or any applications you use or install from the Third Party Site.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>INTELLECTUAL PROPERTY</strong></p>\r\n\r\n<p>You acknowledge and approve that we and our licensors maintain ownership of all intellectual property rights bonded to the Service, including appropriate copyrights, trademarks, and other proprietary rights. Other product and company names mentioned on the Service may be trademarks of their respective owners. We secure all rights not expressly given to you under these Terms of Use.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>WARRANTY DISCLAIMER</strong></p>\r\n\r\n<p>OUR SERVICE IS EQUIPPED &ldquo;AS IS,&rdquo; WITHOUT A WARRANTY OF ANY KIND. WITHOUT LIMITING THE PRECEDING, WE EXPRESSLY DISCLAIM ALL WARRANTIES, WHETHER EXPRESS, INDICATED, OR STATUTORY, REGARDING THE SERVICE, INCLUDING, WITHOUT BOUNDARY, ANY WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR AIM, TITLE, SECURITY, PRECISION, AND NON-INFRINGEMENT. WITHOUT SPECIFYING THE PRECEDING, WE MAKE NO WARRANTY OR REPRESENTATION THAT ACCESS TO OR FUNCTION OF THE SERVICE WILL BE UNINTERRUPTED OR ERROR-FREE. YOU ACCEPT THE FULL BURDEN AND HAZARD OF LOSS RESULTING FROM YOUR DOWNLOADING AND/OR USE OF FILES, STATEMENTS, CONTENT, OR OTHER MATERIAL BROUGHT FROM THE SERVICE. SOME JURISDICTIONS LIMIT OR DO NOT AUTHORIZE DISCLAIMERS OF WARRANTY, SO THIS CONDITION MAY NOT APPLY TO YOU.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>LIMITATION OF DAMAGES</strong>;&nbsp;<strong>RELEASE</strong></p>\r\n\r\n<p>TO THE TIME ALLOWED BY PRACTICAL LAW, IN NO EVENT SHALL THE SITE, THE SERVICE, ITS COMPANIONS, DIRECTORS, OR EMPLOYEES, OR ITS LICENSORS OR PARTNERS, BE RESPONSIBLE TO YOU FOR ANY LOSS OF PROFITS, USE, OR INFORMATION, OR FOR ANY ACCIDENTAL, INDIRECT, SPECIAL, SUBSTANTIAL OR ILLUSTRATIVE DAMAGES, HOWEVER EMERGING, THAT RESULT FROM: (A) THE USE, REVELATION, OR EXHIBIT OF YOUR USER CONTENT; (B) YOUR USE OR INCAPACITY TO USE THE SERVICE; (C) THE SERVICE TYPICALLY OR THE SOFTWARE OR SYSTEMS THAT MAKE THE SERVICE AVAILABLE; OR (D) ANY OTHER EXCHANGES WITH US OR WITH ANY OTHER USER OF THE SERVICE, WHETHER BASED ON WARRANTY, CONTRACT, TORT (INCLUDING DELINQUENCY) OR ANY OTHER LEGAL THEORY, AND WHETHER OR NOT WE HAVE BEEN ANNOUNCED OF THE POTENTIAL OF SUCH DAMAGE, AND EVEN IF A REMEDY SET FORTH HEREIN IS FOUND TO HAVE FAILED OF ITS VIRTUAL PURPOSE. SOME JURISDICTIONS LIMIT OR DO NOT AUTHORIZE DISCLAIMERS OF LIABILITY, SO THIS PROVISION MAY NOT APPLY TO YOU.</p>\r\n\r\n<p>Suppose you have a conflict with one or more users, hosts, or a merchant of a service that you review using the Service. In that case, you release us (and our authorities, directors, agents, subsidiaries, joint ventures, and employees) from claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown, arising out of or in any way connected with such arguments.&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>MODIFICATION OF TERMS OF USE</strong></p>\r\n\r\n<p>We can revise these Terms of Use at any moment and will update these Terms of Use in the event of any such modifications. It is your sole obligation to check the site occasionally to view any such changes in this contract. Your persisted use of the site or the Service indicates your agreement to our modifications to these Terms of Use. We will attempt to inform you of content changes to the Terms by publishing a notice on our homepage and/or sending an email to the email address you provided to us upon signup. You should keep your contact and profile details current for this additional reason. Any changes to these Terms (other than as outlined in this paragraph) or disclaimer of our rights hereunder shall not be reasonable or adequate except in a written contract enduring the physical signature of one of our officers. No purported rejection or modification of this agreement on our part through telephonic or email communications shall be valid.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>GENERAL TERMS</strong></p>\r\n\r\n<p>Suppose any part of this Terms of Use contract is held or seen as invalid or unenforceable. In that case, that part of the agreement will be construed to be compatible with applicable law, while the remaining portions of the contract will stay in full force and impact. Any failure on our part to implement any prerequisite of this agreement will not be deemed a disclaimer of our right to enforce such a requirement. Our rights under this agreement survive any transfer or cessation of this agreement.</p>\r\n\r\n<p>You approve that any cause of action connected to or arising out of your connection with the Company must begin within ONE year after the cause of action accrues. Otherwise, such cause of action is permanently barred.</p>\r\n\r\n<p>We may assign or entrust these Terms of Service and/or our Privacy Policy, in whole or in part, to any person or entity at any time with or without your consent. Without our prior written authorization, you may not assign or entrust any rights or duties under the Terms of Service or Privacy Policy. Any unauthorized assignment or representatives by you is void.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>YOU CONCEDE THAT YOU HAVE READ THESE TERMS OF USE, COMPREHEND THE TERMS OF USE, AND WILL BE BOUND BY THESE TERMS AND CONDITIONS. YOU FURTHER CONCEDE THAT THESE TERMS OF USE TOGETHER WITH THE <a href=\"https://kothabhada.com/page/privacy-policy\"><strong>PRIVACY POLICY</strong></a> DENOTE THE COMPLETE AND PREMIER STATEMENT OF THE AGREEMENT BETWEEN US AND THAT IT DISPLACES ANY PROPOSAL OR PRIOR AGREEMENT ORAL OR WRITTEN, AND ANY OTHER COMMUNICATIONS BETWEEN US RELATING TO THE SUBJECT MATTER OF THIS AGREEMENT.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>', '220502044940.jpg', NULL, 1, 1, '2022-04-07 01:41:00', '2022-05-02 12:22:01', 'Terms of use'),
(5, 'Privacy Policy', 'privacy-policy', '<h1><strong>KOTHA BHADA PRIVACY POLICY</strong></h1>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Kotha Bhada dot com (the &quot;Company&quot;) is dedicated to maintaining robust privacy protections for its users. Our Privacy Policy (&quot;Privacy Policy&quot;) is developed to help you comprehend how we gather, utilize and protect the data you provide to us and assist you in producing informed decisions when using our Service.&nbsp;&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>For objectives of this Agreement, &quot;Site&quot; refers to the Company&#39;s Website, which can be accessed at Kothabhada.com.</p>\r\n\r\n<p>&quot;Service&quot; refers to the Company&#39;s services accessed via the Website, in which users can post or search a property for rent.</p>\r\n\r\n<p>The phrases &quot;we,&quot; &quot;us,&quot; and &quot;our&quot; refer to the Company.</p>\r\n\r\n<p>&quot;You&quot; refers to the user of our Website or our Service.&nbsp;</p>\r\n\r\n<p>By accessing our Website or our Service, you consent to our Privacy Policy and <a href=\"https://kothabhada.com/page/terms-and-conditions\"><strong>Terms of Use</strong></a>. You agree to our collection, storage, usage, and disclosure of your Personal Information as defined in this Privacy Policy.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>I. INFORMATION WE COLLECT</p>\r\n\r\n<p>We gather &quot;Non-Personal Details&quot; and &quot;Personal Information.&quot;&nbsp;<strong>Non-Personal Details</strong>&nbsp;include information that cannot be used to determine the user, such as unidentified usage data, general demographic information, referring/exit pages and URLs, medium types, choices you submit, and choices that are generated based on the details you raise and the number of clicks.&nbsp;<strong>Personal information</strong>&nbsp;includes your email address, date of birth, marital status, location, name, contact information, computer ID, Internet IP address, etc., which you provide to us through the registration process at the Site.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>1.&nbsp; &nbsp;<em>Details collected via Technology</em></p>\r\n\r\n<p>To start the Service, you do not need to provide any Personal Information other than your email address. To use the Service after that, you need to submit further Personal Information like legal name, address, payment mode details, etc. However, to enhance the quality of the Service, we track details fed to us by your browser when you view or use the Service, such as the Website you came from (known as the &quot;referring URL&quot;), the kind of browser you use, the instrument from which you connected to the Service, the time and date of entrance, and other information that does not personally identify you. We track these details using cookies or small text files, including a unique anonymous identifier. Cookies are transmitted to a user&#39;s browser from our servers and are stored on the user&#39;s computer hard drive. Dispatching a cookie to a user&#39;s browser lets us gather Non-Personal Information about that user and record the user&#39;s choices when using our services, both on an individual and aggregate basis. For example, the Company may use cookies to collect the following information:</p>\r\n\r\n<ul>\r\n	<li>Domain Name</li>\r\n	<li>Time Spent&nbsp;</li>\r\n	<li>Meta Data&nbsp;</li>\r\n	<li>Visited sub-pages&nbsp;</li>\r\n	<li>User Settings&nbsp;</li>\r\n	<li>IP address&nbsp;</li>\r\n	<li>Computer ID&nbsp;</li>\r\n</ul>\r\n\r\n<p>The Company may use both persistent and session cookies; persistent cookies stay on your computer after you shut your session and until you delete them, while session cookies expire when you shut your browser.&nbsp;&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>2.&nbsp; &nbsp;<em>Details you provide us by registering for an account</em></p>\r\n\r\n<p>In addition to the details provided automatically by your browser when you visit the Website, you will need to build a personal profile to become a subscriber to the Service. You can make a profile by registering with the Service, and entering your email address, and password. By registering, you permit us to gather, store, and utilize your email address according to this Privacy Policy.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>3.&nbsp;<em>Children&#39;s Privacy</em></p>\r\n\r\n<p>The Website and the Service are not directed to anyone under 18. The Website does not knowingly collect/solicit information from anyone under 18 or allow anyone under 18 to sign up for Service. In the event that we learn that we have collected personal information from anyone under 18 without the permission of a parent or guardian, we will delete that data as soon as possible. If you believe we have collected such information, please contact us at info@kothabhada.com.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>II. HOW WE USE AND SHARE INFORMATION</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><em>Personal Information:</em></p>\r\n\r\n<p>Except as otherwise noted in this Privacy Policy, we do not sell, exchange, rent, or transfer your Personal Information with third parties without your authorization for marketing purposes. We share Personal Information with vendors who are serving the Company, such as the servers for our email communications who are provided entrance to the user&#39;s email addresses to send emails from us. Those vendors use your Personal Information only in our guide and per our Privacy Policy.</p>\r\n\r\n<p>In general, the Personal Information you give to us is used to enable us to communicate with you. For example, we use Personal Information to contact users in reply to questions, request feedback from users, provide technical support, and inform users about promotional offers.</p>\r\n\r\n<p>We may provide Personal Information to external parties if we have good faith that access, use, protection, or exposure of the information is essential to meet any appropriate legal process or enforceable governmental request. To enforce applicable Terms of Service, including investigation of possible violations; handle fraud, security, or technical concerns; or protect against harm to the rights, property, or safety of our users or the public as mandated or authorized by law.&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><em>Non-Personal Information:</em></p>\r\n\r\n<p>In general, we use Non-Personal Information to help us enhance the Service and customize the user experience. We also aggregate Non-Personal Information to follow fads and study use practices on the Site. This Privacy Policy does not restrict our use or exposure of Non-Personal Information. We secure the right to utilize and reveal such Non-Personal Information to our partners, advertisers, and other third parties at our discretion.</p>\r\n\r\n<p>In the event we undergo a business trade such as a merger, purchase by another company, or sale of all or a part of our assets, your Personal Information may be among the assets transferred. You acknowledge and approve that such transfers may emerge and are permitted by this Privacy Policy. Any acquirer of our assets may continue to process your Personal Information as outlined in this Privacy Policy. If our information rules change at any time in the future, we will post the policy changes to the Website so that you may opt-out of the new details practices. We recommend checking the Website occasionally if you are concerned about how your information is used.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>III. HOW WE PROTECT INFORMATION</p>\r\n\r\n<p>We enforce security measures developed to protect your information from unauthorized access. Your account password protects your account, and we urge you to take steps to keep your Personal Information safe by not revealing your password and by logging out of your account after every use. We also safeguard your details from possible security violations by enforcing specific technological security measures, including encryption and firewall technology. However, these efforts do not guarantee that your information will not be accessed, disclosed, altered, or destroyed by breach of such firewalls and secure server software. By using our Service, you acknowledge that you understand and agree to take these risks.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>IV. LINKS TO OTHER WEBSITES</p>\r\n\r\n<p>As part of the Service, we may deliver links to or compatible with other websites. Nevertheless, we are not liable for the privacy approaches utilized by those websites or the data or scope they possess. This Privacy Policy applies exclusively to data collected by us through the Website and the Service. Thus, this Privacy Policy does not involve your use of a third-party website accessed by choosing a link on our Website or via our Service. During the period that you access or operate the Service through or on another website, the other Web site&#39;s privacy policy will involve your access or use of that Website or application. We urge our users to read the privacy policy information of other websites before proceeding to use them.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>V. CHANGES TO OUR PRIVACY POLICY</p>\r\n\r\n<p>The Company reserves the right to modify this policy and our Terms of Use. We will inform you of substantial changes to our Privacy Policy by mailing a notification to the primary email address identified in your account or by placing a conspicuous notice on our Site. Meaningful changes will go into effect 30 days following such notification. Non-material modifications or clarifications will take effect instantly. You should occasionally check the Website and this privacy page for updates.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>VI. CONTACT US</p>\r\n\r\n<p>If you have any queries concerning this Privacy Policy or the courses of this Site, don&#39;t hesitate to contact us by sending an email to info@kothabhada.com.</p>\r\n\r\n<p>This Privacy Policy was last updated on 5/2/2022.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>', '220408084900.jpg', NULL, 2, 1, '2022-04-08 03:04:00', '2022-05-02 12:26:31', 'Privacy Policy'),
(6, 'test 1', 'test-1', '<p>With thoor cupiditate ratione excepturi facere quos!With thoor cupiditate ratione excepturi facere quos!With thoor cupiditate ratione excepturi facere quos!</p>', '220502050106.jpg', NULL, 1, 1, '2022-05-02 22:01:06', '2022-05-02 22:03:28', 'test 1');

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

--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `photo` text NOT NULL,
  `link` varchar(191) DEFAULT NULL,
  `order` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

--
-- Dumping data for table `partners`
--

INSERT INTO `partners` (`id`, `photo`, `link`, `order`, `status`, `created_at`, `updated_at`) VALUES
(1, '220421050838.png', '#', 1, 1, '2022-04-20 23:23:38', '2022-04-20 23:23:38'),
(2, '220502043353.jpg', 'kothabhada.com', 2, 1, '2022-05-02 21:33:53', '2022-05-02 21:33:53'),
(3, '220502043444.jpg', 'kothabhada.com', 3, 1, '2022-05-02 21:34:44', '2022-05-02 21:34:44'),
(4, '220502043604.jpg', 'kothabhada.com', 4, 1, '2022-05-02 21:36:04', '2022-05-02 21:36:04'),
(5, '220502043644.jpg', 'kothabhada.com', 5, 1, '2022-05-02 21:36:44', '2022-05-02 21:36:44'),
(6, '220502043713.jpg', 'kothabhada.com', 6, 1, '2022-05-02 21:37:13', '2022-05-02 21:37:13'),
(7, '220502043759.jpg', 'kothabhada.com', 7, 1, '2022-05-02 21:37:59', '2022-05-02 21:37:59'),
(8, '220503053601.jpg', 'hongkongbazar.com', 8, 1, '2022-05-02 21:38:54', '2022-05-03 22:36:01');

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

--
-- Table structure for table `quick_links`
--

CREATE TABLE `quick_links` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `link` varchar(191) NOT NULL,
  `order` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

--
-- Dumping data for table `quick_links`
--

INSERT INTO `quick_links` (`id`, `title`, `link`, `order`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Facebook', 'www.heroisexpo.eu', 1, 1, '2022-04-06 03:02:17', '2022-04-06 03:02:17'),
(2, 'Twitters', 'http://heroisjobs.com/', 2, 1, '2022-04-06 03:02:31', '2022-04-06 03:02:42'),
(3, 'Vel minima recusanda', 'Qui impedit pariatu', 1, 1, '2022-09-08 05:05:31', '2022-09-08 05:05:31');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured_photo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `included_points` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`included_points`)),
  `featured` int(11) NOT NULL DEFAULT 0,
  `order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `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 `services`
--

INSERT INTO `services` (`id`, `title`, `slug`, `icon`, `short_description`, `description`, `featured_photo`, `included_points`, `featured`, `order`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Ex facere est molest', 'ex-facere-est-molest', '220908105352.png', NULL, '<p>dsfsdfsdf</p>', '220908105352.jpg', '[\"Doloremque quisquam\",\"Est vel dolores recu\",\"Illum do sunt aliq\",\"Rerum molestiae null\",\"Quo omnis cumque inc\",\"Esse qui soluta odit\",\"Pariatur Minim vero\",\"Cum sed qui voluptat\"]', 0, 92, 1, '2022-09-08 05:08:52', '2022-09-08 05:08:52');

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

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

CREATE TABLE `sessions` (
  `id` varchar(191) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` text NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

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

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('ClnbfykyHINYLskZE2nKdreDlt59KThH4ylSz47f', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjY6Il90b2tlbiI7czo0MDoidFZlb1VrcnlmRXh3S3ozZDlPSXJiVXV1WlY1SnlBY1VpUHZrdWxoaiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjA6Imh0dHA6Ly9sb2NhbGhvc3QvaG9tZS1jYXJlLW5lcGFsL3B1YmxpYy9leC1mYWNlcmUtZXN0LW1vbGVzdCI7fXM6MzoidXJsIjthOjE6e3M6ODoiaW50ZW5kZWQiO3M6NDg6Imh0dHA6Ly9sb2NhbGhvc3QvaG9tZS1jYXJlLW5lcGFsL3B1YmxpYy9pdi1hZG1pbiI7fX0=', 1662881091),
('qxdhzSZGKEjPIZdoSVSP3KITwyIiBcCWxpyKbIuh', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWDZpWGRRT2twdlFFeFhOZ05BZU85Q1RYZkJ3cExITndNdGFvTnBZdiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTU6Imh0dHA6Ly9sb2NhbGhvc3QvaG9tZS1jYXJlLW5lcGFsL3B1YmxpYy9mb3Jnb3QtcGFzc3dvcmQiO319', 1662880519);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone` varchar(191) NOT NULL,
  `mobile` varchar(191) NOT NULL,
  `company_logo` text NOT NULL,
  `favicon` text NOT NULL,
  `address` text NOT NULL,
  `facebook` varchar(191) DEFAULT NULL,
  `instagram` varchar(191) DEFAULT NULL,
  `tiktok` varchar(191) DEFAULT NULL,
  `twitter` varchar(191) DEFAULT NULL,
  `linkedin` varchar(191) DEFAULT NULL,
  `skype` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `banner` text DEFAULT NULL,
  `youtube` varchar(191) DEFAULT NULL,
  `ad_video` text DEFAULT NULL,
  `qr_code` varchar(191) DEFAULT NULL,
  `shift_home_content` text DEFAULT NULL,
  `watermark` text DEFAULT NULL,
  `new_deals_term` varchar(191) DEFAULT NULL,
  `tagline` varchar(191) DEFAULT NULL,
  `email_2` varchar(191) DEFAULT NULL,
  `footer_text` text DEFAULT NULL,
  `post_box_address` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `company_name`, `email`, `phone`, `mobile`, `company_logo`, `favicon`, `address`, `facebook`, `instagram`, `tiktok`, `twitter`, `linkedin`, `skype`, `created_at`, `updated_at`, `banner`, `youtube`, `ad_video`, `qr_code`, `shift_home_content`, `watermark`, `new_deals_term`, `tagline`, `email_2`, `footer_text`, `post_box_address`) VALUES
(1, 'Home Care Nepal', 'info@kothabhada.com', '42xxxxxxxxx', '98603473844', '20220908121836-logo.jpeg', '20220908121836-logo.jpeg', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3532.603418480235!2d85.37141681423537!3d27.698649632482773!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x39eb1a49e46c86c3%3A0xe7527f2b2b0d67f8!2sHome%20Service%20Nepal!5e0!3m2!1sen!2snp!4v1660993687080!5m2!1sen!2snp', 'https://www.facebook.com/ManjariLiveDohori2020/', 'instagram.com/', 'https:// tiktok.com/@www.europeexpo.es', 'https://twitter.com/DohoriLive?s=07', 'https://www.linkedin.com/in/surendra-ojha-968112203/', NULL, '2022-04-06 00:57:57', '2022-09-11 04:39:08', '1662871147slider_1.jpg', NULL, 'oyEuk8j8imI', NULL, NULL, NULL, NULL, 'asdasd', 'info@kothabhada.com', 'sadasd', 'Home Service Nepal,Basundhara-4, Kathmandu');

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `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 `why_choose_us`
--

CREATE TABLE `why_choose_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo_1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value_1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo_2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value_2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo_3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value_3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo_4` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_4` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value_4` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo_5` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_5` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value_5` varchar(191) COLLATE utf8mb4_unicode_ci 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 `why_choose_us`
--

INSERT INTO `why_choose_us` (`id`, `photo`, `photo_1`, `title_1`, `value_1`, `photo_2`, `title_2`, `value_2`, `photo_3`, `title_3`, `value_3`, `photo_4`, `title_4`, `value_4`, `photo_5`, `title_5`, `value_5`, `created_at`, `updated_at`) VALUES
(1, '20220908103117-759338392-H.jpg', '20220908103117-electrician.png', 'Recusandae Consequa', 'In qui veniam imped', '20220908103117-family.png', 'Enim sed voluptate a', 'Incidunt aute in et', '20220908103117-law.png', 'Tempora dolor veniam', 'Excepteur tempor ill', '20220908103117-house-keeping.png', 'Nulla omnis vel volu', 'Voluptatem Et accus', '20220908103117-interior-design.png', NULL, NULL, '2022-09-08 04:46:17', '2022-09-08 04:46:17');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `admin_menu_items`
--
ALTER TABLE `admin_menu_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_menu_items_menu_foreign` (`menu`);

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

--
-- Indexes for table `advertisement_positions`
--
ALTER TABLE `advertisement_positions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `advertisement_positions_advertisement_id_index` (`advertisement_id`);

--
-- Indexes for table `ask_for_quotes`
--
ALTER TABLE `ask_for_quotes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ask_for_quotes_user_id_index` (`user_id`),
  ADD KEY `ask_for_quotes_service_id_index` (`service_id`);

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

--
-- Indexes for table `book_packages`
--
ALTER TABLE `book_packages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `book_packages_user_id_index` (`user_id`),
  ADD KEY `book_packages_package_id_index` (`package_id`);

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

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `categories_parent_foreign` (`parent`);

--
-- Indexes for table `contact_categories`
--
ALTER TABLE `contact_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contact_categories_contact_id_index` (`contact_id`),
  ADD KEY `contact_categories_category_id_index` (`category_id`);

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

--
-- Indexes for table `customer_stories`
--
ALTER TABLE `customer_stories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_stories_user_id_foreign` (`user_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 `f_a_q_s`
--
ALTER TABLE `f_a_q_s`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `packages_service_id_index` (`service_id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pages_parent_index` (`parent`);

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

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

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `admin_menu_items`
--
ALTER TABLE `admin_menu_items`
  ADD CONSTRAINT `admin_menu_items_menu_foreign` FOREIGN KEY (`menu`) REFERENCES `admin_menus` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `advertisement_positions`
--
ALTER TABLE `advertisement_positions`
  ADD CONSTRAINT `advertisement_positions_advertisement_id_foreign` FOREIGN KEY (`advertisement_id`) REFERENCES `advertisements` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `ask_for_quotes`
--
ALTER TABLE `ask_for_quotes`
  ADD CONSTRAINT `ask_for_quotes_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ask_for_quotes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `book_packages`
--
ALTER TABLE `book_packages`
  ADD CONSTRAINT `book_packages_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `book_packages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_parent_foreign` FOREIGN KEY (`parent`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `contact_categories`
--
ALTER TABLE `contact_categories`
  ADD CONSTRAINT `contact_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `contact_categories_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contact_us` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_stories`
--
ALTER TABLE `customer_stories`
  ADD CONSTRAINT `customer_stories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `packages`
--
ALTER TABLE `packages`
  ADD CONSTRAINT `packages_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pages`
--
ALTER TABLE `pages`
  ADD CONSTRAINT `pages_parent_foreign` FOREIGN KEY (`parent`) REFERENCES `pages` (`id`) ON DELETE CASCADE;
COMMIT;

