-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jan 10, 2025 at 02:21 AM
-- Server version: 10.4.19-MariaDB
-- PHP Version: 8.0.7

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `script_directory_free`
--

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

--
-- Table structure for table `app_settings`
--

CREATE TABLE `app_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email_activation` tinyint(1) NOT NULL DEFAULT 0,
  `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'USD/$',
  `currency_code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'USD',
  `currency_symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '$',
  `currency_type` enum('Symbol','Code') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Symbol',
  `messsage_notification` tinyint(1) NOT NULL DEFAULT 0,
  `review_notification` tinyint(1) NOT NULL DEFAULT 0,
  `list_view` tinyint(4) NOT NULL DEFAULT 12,
  `grid_view` tinyint(4) NOT NULL DEFAULT 12,
  `blog` tinyint(4) NOT NULL DEFAULT 12,
  `featured_list` tinyint(4) NOT NULL DEFAULT 3,
  `latest_list` tinyint(4) NOT NULL DEFAULT 3,
  `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 `app_settings`
--

INSERT INTO `app_settings` (`id`, `email_activation`, `currency`, `currency_code`, `currency_symbol`, `currency_type`, `messsage_notification`, `review_notification`, `list_view`, `grid_view`, `blog`, `featured_list`, `latest_list`, `created_at`, `updated_at`) VALUES
(1, 0, 'USD/$', 'USD', '$', 'Symbol', 1, 0, 12, 12, 12, 3, 3, NULL, NULL);

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

--
-- Table structure for table `business_details`
--

CREATE TABLE `business_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `about` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `listing_id` bigint(20) UNSIGNED 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 `business_details`
--

INSERT INTO `business_details` (`id`, `about`, `user_id`, `listing_id`, `created_at`, `updated_at`) VALUES
(1, '{\"time\":1649005307190,\"blocks\":[{\"id\":\"RqmyjVa4OM\",\"type\":\"paragraph\",\"data\":{\"text\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc in felis tellus. In sapien metus, ornare ac sollicitudin non, tincidunt vel ex. Proin tincidunt nisl diam, ut tincidunt massa ultrices vitae. Aliquam auctor ex dolor, vel viverra purus rutrum vel. Aenean vitae ultricies elit. Nullam suscipit facilisis felis in ornare. Aenean luctus nibh sed auctor molestie. Curabitur tincidunt velit nec aliquet facilisis. Cras ac risus vestibulum, mattis nisi in, fringilla libero.\"}},{\"id\":\"q-HGbMkfmW\",\"type\":\"paragraph\",\"data\":{\"text\":\"Integer vestibulum convallis tellus, at dapibus metus ullamcorper id. Fusce sit amet libero libero. Fusce et odio ac nisi convallis ullamcorper et ac lorem. Fusce eget metus suscipit, blandit ante eget, cursus tellus. Sed leo tellus, iaculis a metus ac, pharetra finibus enim. Phasellus in sapien eros. Pellentesque ultrices dolor eu magna luctus, quis aliquam ipsum porttitor. Vivamus aliquam mi at rutrum accumsan. Phasellus semper eros ac lobortis eleifend.\"}},{\"id\":\"iqP-N7R-pi\",\"type\":\"paragraph\",\"data\":{\"text\":\"Pellentesque a bibendum sapien. Ut viverra viverra convallis. Nunc laoreet urna tellus. Cras nec maximus dolor, in fringilla leo. Sed id quam nec sapien congue consequat a quis odio. Nulla sodales tortor nec convallis mollis. Morbi ornare elit eget leo dapibus, id tristique ipsum auctor. Aenean elit lectus, rhoncus id tincidunt id, volutpat sit amet nisi. Aenean magna est, tempus sed tortor id, eleifend ornare magna.\"}}],\"version\":\"2.23.2\"}', 1, 1, NULL, NULL),
(2, '{\"time\":1649053164556,\"blocks\":[{\"id\":\"KBakO4zKmK\",\"type\":\"paragraph\",\"data\":{\"text\":\"Sed quis metus scelerisque, porta turpis non, tristique diam. Integer vitae lorem lectus. Morbi gravida justo at neque suscipit ultricies. Vestibulum elementum ac ex vitae porttitor. Donec ligula leo, bibendum eget lectus sed, euismod venenatis turpis. Aliquam interdum velit lorem, vitae cursus magna rhoncus eu. Nam viverra arcu non mi sodales venenatis. Fusce eu turpis ac sem faucibus tempus.\"}},{\"id\":\"VU1sGw8HeI\",\"type\":\"paragraph\",\"data\":{\"text\":\"Maecenas mattis lorem nunc, a vulputate sapien egestas quis. Maecenas massa risus, pellentesque vel suscipit et, pulvinar ut nibh. Proin sit amet nunc porta, interdum erat eu, laoreet lectus. Proin a ligula eu nisl eleifend porta auctor vel massa. Nullam quis enim ex. Fusce aliquet fermentum auctor. Nam tincidunt nisi vitae sodales aliquet. Nulla quis laoreet odio, et sagittis massa. Cras iaculis feugiat vestibulum. Sed fermentum nisi in dolor elementum, aliquet scelerisque eros ultricies. Quisque elementum lacinia eros. Praesent blandit eget neque quis ullamcorper. Vivamus ultricies sodales lectus, sed ornare diam tristique ac.\"}}],\"version\":\"2.23.2\"}', 1, 2, NULL, NULL),
(3, '{\"time\":1649053856427,\"blocks\":[{\"id\":\"aKLMhrXUS6\",\"type\":\"paragraph\",\"data\":{\"text\":\"Maecenas mattis lorem nunc, a vulputate sapien egestas quis. Maecenas massa risus, pellentesque vel suscipit et, pulvinar ut nibh. Proin sit amet nunc porta, interdum erat eu, laoreet lectus. Proin a ligula eu nisl eleifend porta auctor vel massa. Nullam quis enim ex. Fusce aliquet fermentum auctor. Nam tincidunt nisi vitae sodales aliquet. Nulla quis laoreet odio, et sagittis massa. Cras iaculis feugiat vestibulum. Sed fermentum nisi in dolor elementum, aliquet scelerisque eros ultricies. Quisque elementum lacinia eros. Praesent blandit eget neque quis ullamcorper. Vivamus ultricies sodales lectus, sed ornare diam tristique ac.\"}}],\"version\":\"2.23.2\"}', 1, 3, NULL, NULL),
(4, '{\"time\":1649055526603,\"blocks\":[{\"id\":\"1dnQVRNUQL\",\"type\":\"paragraph\",\"data\":{\"text\":\"Maecenas mattis lorem nunc, a vulputate sapien egestas quis. Maecenas massa risus, pellentesque vel suscipit et, pulvinar ut nibh. Proin sit amet nunc porta, interdum erat eu, laoreet lectus. Proin a ligula eu nisl eleifend porta auctor vel massa. Nullam quis enim ex. Fusce aliquet fermentum auctor. Nam tincidunt nisi vitae sodales aliquet. Nulla quis laoreet odio, et sagittis massa. Cras iaculis feugiat vestibulum. Sed fermentum nisi in dolor elementum, aliquet scelerisque eros ultricies. Quisque elementum lacinia eros. Praesent blandit eget neque quis ullamcorper. Vivamus ultricies sodales lectus, sed ornare diam tristique ac.\"}}],\"version\":\"2.23.2\"}', 2, 4, NULL, NULL),
(5, '{\"time\":1649056888849,\"blocks\":[{\"id\":\"I5iCvNCtcW\",\"type\":\"paragraph\",\"data\":{\"text\":\"Morbi in leo in ipsum pellentesque congue ac vel ante. Phasellus tristique dui et eros fringilla efficitur. Pellentesque blandit dolor ut mauris commodo, quis tincidunt lorem semper. Integer ac neque diam. Fusce sed ante in nibh egestas dignissim ac id augue. In viverra euismod velit, convallis congue ex aliquet vitae. Proin vehicula tincidunt quam, ac interdum libero sollicitudin eu. Morbi gravida ultrices consequat. Phasellus erat ex, pretium eu ultrices ut, lobortis non sem. Maecenas at blandit leo, in volutpat purus. Ut elementum elit massa, nec ultrices augue varius eget. Vivamus sollicitudin fringilla sem, ac ultrices nisi condimentum sed. Duis sit amet porta dolor, vitae lobortis nisl. Aliquam egestas nunc non mollis dictum. Vivamus pretium semper sodales. Donec mollis libero dapibus, sagittis libero id, fermentum lacus.\"}}],\"version\":\"2.23.2\"}', 1, 5, NULL, NULL),
(6, '{\"time\":1649058615582,\"blocks\":[{\"id\":\"a7Sg08hDAv\",\"type\":\"paragraph\",\"data\":{\"text\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent ac gravida dolor. Morbi non congue eros. Aliquam ultricies nibh risus. Maecenas commodo ornare dolor eu venenatis. Cras luctus ultrices ipsum, eget rhoncus velit dictum eu. Etiam et quam at quam ultrices interdum non non eros. Donec scelerisque pharetra ex non congue. Duis commodo dui consequat, vehicula dui in, ultricies nisl. Phasellus ut consectetur diam, ac bibendum risus. Nam et nibh mi. Nulla condimentum non est tristique congue.\"}},{\"id\":\"SprEzb7-B4\",\"type\":\"paragraph\",\"data\":{\"text\":\"Sed quis metus scelerisque, porta turpis non, tristique diam. Integer vitae lorem lectus. Morbi gravida justo at neque suscipit ultricies. Vestibulum elementum ac ex vitae porttitor. Donec ligula leo, bibendum eget lectus sed, euismod venenatis turpis. Aliquam interdum velit lorem, vitae cursus magna rhoncus eu. Nam viverra arcu non mi sodales venenatis.\"}}],\"version\":\"2.23.2\"}', 2, 6, NULL, NULL),
(7, '{\"time\":1649059047553,\"blocks\":[{\"id\":\"4aRUeC20tI\",\"type\":\"paragraph\",\"data\":{\"text\":\"Morbi in leo in ipsum pellentesque congue ac vel ante. Phasellus tristique dui et eros fringilla efficitur. Pellentesque blandit dolor ut mauris commodo, quis tincidunt lorem semper. Integer ac neque diam. Fusce sed ante in nibh egestas dignissim ac id augue. In viverra euismod velit, convallis congue ex aliquet vitae. Proin vehicula tincidunt quam, ac interdum libero sollicitudin eu. Morbi gravida ultrices consequat. Phasellus erat ex, pretium eu ultrices ut, lobortis non sem. Maecenas at blandit leo, in volutpat purus. Ut elementum elit massa, nec ultrices augue varius eget. Vivamus sollicitudin fringilla sem, ac ultrices nisi condimentum sed. Duis sit amet porta dolor, vitae lobortis nisl. Aliquam egestas nunc non mollis dictum. Vivamus pretium semper sodales. Donec mollis libero dapibus, sagittis libero id, fermentum lacus.\"}}],\"version\":\"2.23.2\"}', 1, 7, NULL, NULL),
(8, '{\"time\":1649059047553,\"blocks\":[{\"id\":\"4aRUeC20tI\",\"type\":\"paragraph\",\"data\":{\"text\":\"Morbi in leo in ipsum pellentesque congue ac vel ante. Phasellus tristique dui et eros fringilla efficitur. Pellentesque blandit dolor ut mauris commodo, quis tincidunt lorem semper. Integer ac neque diam. Fusce sed ante in nibh egestas dignissim ac id augue. In viverra euismod velit, convallis congue ex aliquet vitae. Proin vehicula tincidunt quam, ac interdum libero sollicitudin eu. Morbi gravida ultrices consequat. Phasellus erat ex, pretium eu ultrices ut, lobortis non sem. Maecenas at blandit leo, in volutpat purus. Ut elementum elit massa, nec ultrices augue varius eget. Vivamus sollicitudin fringilla sem, ac ultrices nisi condimentum sed. Duis sit amet porta dolor, vitae lobortis nisl. Aliquam egestas nunc non mollis dictum. Vivamus pretium semper sodales. Donec mollis libero dapibus, sagittis libero id, fermentum lacus.\"}}],\"version\":\"2.23.2\"}', 1, 8, NULL, NULL),
(9, '{\"time\":1649059047553,\"blocks\":[{\"id\":\"4aRUeC20tI\",\"type\":\"paragraph\",\"data\":{\"text\":\"Morbi in leo in ipsum pellentesque congue ac vel ante. Phasellus tristique dui et eros fringilla efficitur. Pellentesque blandit dolor ut mauris commodo, quis tincidunt lorem semper. Integer ac neque diam. Fusce sed ante in nibh egestas dignissim ac id augue. In viverra euismod velit, convallis congue ex aliquet vitae. Proin vehicula tincidunt quam, ac interdum libero sollicitudin eu. Morbi gravida ultrices consequat. Phasellus erat ex, pretium eu ultrices ut, lobortis non sem. Maecenas at blandit leo, in volutpat purus. Ut elementum elit massa, nec ultrices augue varius eget. Vivamus sollicitudin fringilla sem, ac ultrices nisi condimentum sed. Duis sit amet porta dolor, vitae lobortis nisl. Aliquam egestas nunc non mollis dictum. Vivamus pretium semper sodales. Donec mollis libero dapibus, sagittis libero id, fermentum lacus.\"}}],\"version\":\"2.23.2\"}', 2, 9, NULL, NULL),
(10, '{\"time\":1649059047553,\"blocks\":[{\"id\":\"4aRUeC20tI\",\"type\":\"paragraph\",\"data\":{\"text\":\"Morbi in leo in ipsum pellentesque congue ac vel ante. Phasellus tristique dui et eros fringilla efficitur. Pellentesque blandit dolor ut mauris commodo, quis tincidunt lorem semper. Integer ac neque diam. Fusce sed ante in nibh egestas dignissim ac id augue. In viverra euismod velit, convallis congue ex aliquet vitae. Proin vehicula tincidunt quam, ac interdum libero sollicitudin eu. Morbi gravida ultrices consequat. Phasellus erat ex, pretium eu ultrices ut, lobortis non sem. Maecenas at blandit leo, in volutpat purus. Ut elementum elit massa, nec ultrices augue varius eget. Vivamus sollicitudin fringilla sem, ac ultrices nisi condimentum sed. Duis sit amet porta dolor, vitae lobortis nisl. Aliquam egestas nunc non mollis dictum. Vivamus pretium semper sodales. Donec mollis libero dapibus, sagittis libero id, fermentum lacus.\"}}],\"version\":\"2.23.2\"}', 2, 10, NULL, NULL),
(11, '{\"time\":1649059047553,\"blocks\":[{\"id\":\"4aRUeC20tI\",\"type\":\"paragraph\",\"data\":{\"text\":\"Morbi in leo in ipsum pellentesque congue ac vel ante. Phasellus tristique dui et eros fringilla efficitur. Pellentesque blandit dolor ut mauris commodo, quis tincidunt lorem semper. Integer ac neque diam. Fusce sed ante in nibh egestas dignissim ac id augue. In viverra euismod velit, convallis congue ex aliquet vitae. Proin vehicula tincidunt quam, ac interdum libero sollicitudin eu. Morbi gravida ultrices consequat. Phasellus erat ex, pretium eu ultrices ut, lobortis non sem. Maecenas at blandit leo, in volutpat purus. Ut elementum elit massa, nec ultrices augue varius eget. Vivamus sollicitudin fringilla sem, ac ultrices nisi condimentum sed. Duis sit amet porta dolor, vitae lobortis nisl. Aliquam egestas nunc non mollis dictum. Vivamus pretium semper sodales. Donec mollis libero dapibus, sagittis libero id, fermentum lacus.\"}}],\"version\":\"2.23.2\"}', 1, 11, NULL, NULL),
(12, '{\"time\":1649059047553,\"blocks\":[{\"id\":\"4aRUeC20tI\",\"type\":\"paragraph\",\"data\":{\"text\":\"Morbi in leo in ipsum pellentesque congue ac vel ante. Phasellus tristique dui et eros fringilla efficitur. Pellentesque blandit dolor ut mauris commodo, quis tincidunt lorem semper. Integer ac neque diam. Fusce sed ante in nibh egestas dignissim ac id augue. In viverra euismod velit, convallis congue ex aliquet vitae. Proin vehicula tincidunt quam, ac interdum libero sollicitudin eu. Morbi gravida ultrices consequat. Phasellus erat ex, pretium eu ultrices ut, lobortis non sem. Maecenas at blandit leo, in volutpat purus. Ut elementum elit massa, nec ultrices augue varius eget. Vivamus sollicitudin fringilla sem, ac ultrices nisi condimentum sed. Duis sit amet porta dolor, vitae lobortis nisl. Aliquam egestas nunc non mollis dictum. Vivamus pretium semper sodales. Donec mollis libero dapibus, sagittis libero id, fermentum lacus.\"}}],\"version\":\"2.23.2\"}', 1, 12, NULL, NULL),
(13, '{\"time\":1649059047553,\"blocks\":[{\"id\":\"4aRUeC20tI\",\"type\":\"paragraph\",\"data\":{\"text\":\"Morbi in leo in ipsum pellentesque congue ac vel ante. Phasellus tristique dui et eros fringilla efficitur. Pellentesque blandit dolor ut mauris commodo, quis tincidunt lorem semper. Integer ac neque diam. Fusce sed ante in nibh egestas dignissim ac id augue. In viverra euismod velit, convallis congue ex aliquet vitae. Proin vehicula tincidunt quam, ac interdum libero sollicitudin eu. Morbi gravida ultrices consequat. Phasellus erat ex, pretium eu ultrices ut, lobortis non sem. Maecenas at blandit leo, in volutpat purus. Ut elementum elit massa, nec ultrices augue varius eget. Vivamus sollicitudin fringilla sem, ac ultrices nisi condimentum sed. Duis sit amet porta dolor, vitae lobortis nisl. Aliquam egestas nunc non mollis dictum. Vivamus pretium semper sodales. Donec mollis libero dapibus, sagittis libero id, fermentum lacus.\"}}],\"version\":\"2.23.2\"}', 2, 13, NULL, NULL),
(14, '{\"time\":1649059047553,\"blocks\":[{\"id\":\"4aRUeC20tI\",\"type\":\"paragraph\",\"data\":{\"text\":\"Morbi in leo in ipsum pellentesque congue ac vel ante. Phasellus tristique dui et eros fringilla efficitur. Pellentesque blandit dolor ut mauris commodo, quis tincidunt lorem semper. Integer ac neque diam. Fusce sed ante in nibh egestas dignissim ac id augue. In viverra euismod velit, convallis congue ex aliquet vitae. Proin vehicula tincidunt quam, ac interdum libero sollicitudin eu. Morbi gravida ultrices consequat. Phasellus erat ex, pretium eu ultrices ut, lobortis non sem. Maecenas at blandit leo, in volutpat purus. Ut elementum elit massa, nec ultrices augue varius eget. Vivamus sollicitudin fringilla sem, ac ultrices nisi condimentum sed. Duis sit amet porta dolor, vitae lobortis nisl. Aliquam egestas nunc non mollis dictum. Vivamus pretium semper sodales. Donec mollis libero dapibus, sagittis libero id, fermentum lacus.\"}}],\"version\":\"2.23.2\"}', 1, 14, NULL, NULL);

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(155) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keyword` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `categories`
--

INSERT INTO `categories` (`id`, `name`, `url`, `icon`, `description`, `title`, `keyword`, `featured`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Restuarent', 'restuarent', 'icon/dt6NPTzaLkrJ97jj8pQBvOgcwzteAnz9gcA1ldu7.png', 'Find Restaurants Near You Indian, Chinese, South India, Italian etc..', NULL, NULL, 1, NULL, NULL, NULL),
(2, 'Retail Shops', 'retail-shops', 'icon/E9tXm2McCoxweRwl2CyHqhxBbjMOb29Av02mwUL7.png', 'Find the Beat packers and Movers Near You, International Packers and Movers, With city movers', NULL, NULL, 1, NULL, NULL, NULL),
(3, 'Health Care and Beauty', 'health-care-and-beauty', 'icon/TuqqYqsnSGabOvsvogvWtTZETbHcI1hUcIMLBJuU.png', 'Find the best Spa and beauty Parlours near you. Find Beauty services in best price', NULL, NULL, 1, NULL, NULL, NULL),
(4, 'Furniture', 'furniture', 'icon/HQzryCLolOqn6wlSMhYqkoWP2KiZHOHSK9DRoWWm.png', 'Find Best deals on Home and office furniture near you', NULL, NULL, 1, NULL, NULL, NULL),
(5, 'Computer and Accessories', 'computer-and-accessories', 'icon/2Qtr9IeSNe8iDkfgVW7FmKFwnNVZUcGTmasIBsOy.png', 'Find Computer Service Centers and Dealers near you', NULL, NULL, 1, NULL, NULL, NULL),
(6, 'Real Estate', 'real-estate', 'icon/DxqtBDR3uLOXOVdpYad4Icfg78ME0VUGrVAjH6We.png', 'Find the best Real Estate Brokers and Land Developers near You', NULL, NULL, 1, NULL, NULL, NULL),
(7, 'Automobile', 'automobile', 'icon/l6VEmggedNMZKWDEs8pLcJ1c7whOzwmW64njwJaD.png', 'Find Best Automobile Service center and automobile dealers near you', NULL, NULL, 1, NULL, NULL, NULL),
(8, 'Clothing', 'clothing', 'icon/abxR1GARnNfYUvuNOqg1IPyzSpRQKUyq80xUvT5z.png', 'Find Best Cloth shops near you, Mens Womens, kids', NULL, NULL, 1, NULL, NULL, NULL),
(9, 'Electrical and Electronics', 'electrical-and-electronics', 'icon/SAKCttX2eMa4uHzoN4KTYW1d9Rvp74np7pzE5RxA.png', 'Find the Best Electrical and Electronics store near You', NULL, NULL, 1, NULL, NULL, NULL),
(10, 'Finance Institutes', 'finance-institutes', 'icon/B5DWFEuUReSpEzulDe4KTpdIItKZ0DLE10VCUbOg.png', 'Easily. find the best finance institutes around you banks, Accounts, ATM etc..', NULL, NULL, 1, NULL, NULL, NULL),
(11, 'Educational Institute', 'educational-institute', 'icon/Pm5avWHie4Oo08BMiYePJckmFJca0QcrgDlDdmja.png', 'Find Best Educational Institutes near you. Read the Details service and Review. Choose the Right one for you', NULL, NULL, 1, NULL, NULL, NULL),
(12, 'Web Design and Development', 'web-design-and-development', 'icon/7LFrz7CKgxi5ID0JHwo3OUqYn23GrRpSdtEFP4xL.png', 'Find Best deal on Webdesign and Development Servies Near You', NULL, NULL, 1, NULL, NULL, NULL),
(13, 'Builders', 'builders', NULL, 'Builders', NULL, NULL, 0, NULL, NULL, NULL),
(14, 'AC Service', 'ac-service', 'icon/MVmBzduNqgNfzcg5Bfio878LQfaf5Cg88PtAsa8k.png', 'AC Service', NULL, NULL, 0, NULL, NULL, NULL),
(15, 'Call Taxi', 'call-taxi', NULL, 'List of Call Taxi Services', NULL, NULL, 0, NULL, NULL, NULL);

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `listings`
--

CREATE TABLE `listings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `business_name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(155) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(155) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(155) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rating` float DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `listings`
--

INSERT INTO `listings` (`id`, `user_id`, `business_name`, `url`, `image`, `description`, `email`, `mobile`, `website`, `whatsapp`, `address`, `rating`, `featured`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'Dell Computer Service Center', 'dell-computer-service-center', 'iHdi9ALkrDzlWIxAIcPTztoWEkxClxBvXLSFYR1u.jpg', 'One of the most popular laptop brands in the world is Dell. Their laptop is the work companion for many users. Even some consider it to be the indispensable one', 'info@manidell.com', '989 878 7878', 'https://manidell.com', '987 987 8987', 'Loyall Grden, Udumalpet, Tirupur, 642112', 3, 1, NULL, NULL, NULL),
(2, 1, 'Dr Suresh Opticals and Health Care', 'dr-suresh-opticals-and-health-care', 'uOMs7DhLtnmsezyiBE6pcsaRG1PJptYk8SJ5jjOu.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent ac gravida dolor. Morbi non congue eros. Aliquam ultricies nibh risus. Maecenas commodo ornare dolor eu venenatis.', 'sureshoptical@gmail.com', '98787676', 'https://sueshoptical.org', '987878789', 'Ramar Colony, Winorginay, South Colony New Delhi', 4, 0, NULL, NULL, NULL),
(3, 1, 'Spanish Hyper Market Neelakada', 'spanish-hyper-market-neelakada', 'XPkkoxBObvRTmBPKu0OOllZreQm3CezzsCCt6hfw.jpg', 'Morbi gravida justo at neque suscipit ultricies. Vestibulum elementum ac ex vitae porttitor. Donec ligula leo', 'neelakadamarket@exp.com', '878787878', 'https://neelakadamarket.com', '9887 878 788', 'Loyall Grden, Udumalpet, Tirupur, 642112', NULL, 0, NULL, NULL, NULL),
(4, 2, 'Orange Super Market Manali', 'orange-super-market-manali', 'QEKnmLupv3zeh1TsxuIcIcqA4LtnxvuzQAZrOV10.jpg', 'Morbi gravida justo at neque suscipit ultricies. Vestibulum elementum ac ex vitae porttitor', 'orangesupermarket@etail.com', '987676787', 'https://orangesupermarket.com', '987 776 7876', 'Ramar Colony, Winorginay, South Colony New Delhi', 3.5, 1, NULL, NULL, NULL),
(5, 1, 'Eden Furniture Mart', 'eden-furniture-mart', 'VIZvPBJ5LYijMnFzrQizwyuKB8uAXA4oWkamWilH.jpg', 'Sed quis metus scelerisque, porta turpis non, tristique diam. Integer vitae lorem lectus.', 'edenfurniture@gmail.com', '8767 6767 676', 'https://edenfurniture.com', '877 676 67656', 'Ramar Colony, Winorginay, South Colony New Delhi', NULL, 0, NULL, NULL, NULL),
(6, 2, 'Modern Italian Gardern Restuarent', 'modern-italian-gardern-restuarent', '23R3YaXLonA2PuFH7dDUZUKwFCY8j2BhuCINoQDp.jpg', 'Maecenas massa risus, pellentesque vel suscipit et, pulvinar ut nibh. Proin sit amet nunc porta, interdum erat', 'italianrestuarent@gmail.com', '987 8787 8787', 'https://italianrestuarent.co', '987 878 7878 78', 'Loyall Grden, Udumalpet, Tirupur, 642112', 5, 0, NULL, NULL, NULL),
(7, 1, 'Kovail Palamudir Solai', 'kovail-palamudir-solai', 'lK5JMzvGpgF8LhboQFOnNpYbwaM2xl8Dw0J8Gr7B.jpg', 'Maecenas mattis lorem nunc, a vulputate sapien egestas quis. Maecenas massa risus, pellentesque vel suscipit et', 'kovaipalamudir@gmail.com', '34 589 89098', 'https://kovaipalamudir.in', '34 589 89098', '8638 Amarica Stranfod Mailbon Star', NULL, 0, NULL, NULL, NULL),
(8, 1, 'Sakthi Computer Sales and Service', 'sakthi-computer-sales-and-service', 'oWtqGpDaR4i4d2skkbLw14UfGBr4SLDl4Ip0tSgm.jpg', 'Maecenas mattis lorem nunc, a vulputate sapien egestas quis. Maecenas massa risus,', 'shakticomputer@example.com', '878 786 7676', 'https://shakticomputer.com', '767 676 7676', '8638 Amarica Stranfod Mailbon Star', 3, 0, NULL, NULL, NULL),
(9, 2, 'Dr Jhon Opticals and Eye Care', 'dr-jhon-opticals-and-eye-care', 'bvsSGPMxjdKh8o669OjBHuVJH9a2qFQHKjb7sUsl.jpg', 'Morbi in leo in ipsum pellentesque congue ac vel ante. Phasellus tristique dui et eros fringilla efficitur', 'jhonopticals@gmail.com', '8787 8787 78', 'https://jhonopticalshcare.com', '987 898 7878', 'Rosestreet, Motycarony, Torranto', NULL, 0, NULL, NULL, NULL),
(10, 2, 'Sam Sam Restuarent', 'sam-sam-restuarent', 'ECHTZ4aCv1eeMiii7yZpeNgoEnWre7KEeZFkBPyn.jpg', 'Maecenas massa risus, pellentesque vel suscipit et, pulvinar ut nibh. Proin sit amet nunc porta, interdum erat eu, laoreet lectus', 'samsamsamsamrest@ssm.com', '435 4545 454', 'https://samsamrestssm.com', '453 335 343 34', 'Rosestreet, Motycarony, Torranto', NULL, 0, NULL, NULL, NULL),
(11, 1, 'David Furniture Land', 'david-furniture-land', 'ZlQBqopucYTlm6odPferuZdxOSWae1HFqp0BIKIR.jpg', 'tiam eget mauris vitae est venenatis fermentum sed ac lacus. Praesent tempor nibh at porttitor bibendum.', 'davidfunrniture@ssm.com', '2342 3443 34', 'https://davidfunrniture.com', '343 3434 3434', '24/6 AVK Avenue, Loks Land Palaplam, Trampt', 3.75, 1, NULL, NULL, NULL),
(12, 1, 'Vintage Family Restuarent', 'vintage-family-restuarent', 'KhxfzwuBfIBoWsZ1005sUnX1D2VgsMSbVqn6UQRL.jpg', 'Morbi luctus lacus suscipit malesuada consequat. Suspendisse tempor dolor diam.', 'vintagerestuarent@gmail.comm', '9878767876', 'https://vintagerestuarent.co.in', '78787898987', '8638 Amarica Stranfod Mailbon Star', NULL, 0, NULL, NULL, NULL),
(13, 2, 'Oriantal Computers', 'oriantal-computers', 'Tvzw0josjFx8WGyqIoGqXE6YWrYrZ3EjIINRLAdO.jpg', 'Morbi luctus lacus suscipit malesuada consequat. Suspendisse tempor dolor diam.', 'oriantalcomputer@gmail.com', '8789878787', 'https://oriantal@gmail.com', '8787878787', '8638 Amarica Stranfod Mailbon Star', NULL, 0, NULL, NULL, NULL),
(14, 1, 'Daily Fresh Kovai', 'daily-fresh-kovai', 'qKGXj0yePaau5Kkf9KROvKc9MXysStnusERXsI7m.jpg', 'Morbi luctus lacus suscipit malesuada consequat. Suspendisse tempor dolor diam.', 'dailyfresh@hotmail.com', '343534342432', 'https://dailyfresh.co.in', '98989898898', 'Kanoory, Racelnager, Kanniyakumari', 3, 0, NULL, NULL, NULL);

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

--
-- Table structure for table `list_categories`
--

CREATE TABLE `list_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `listing_id` bigint(20) UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL 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 `list_categories`
--

INSERT INTO `list_categories` (`id`, `category_id`, `listing_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 5, 1, NULL, NULL, NULL),
(2, 3, 2, NULL, NULL, NULL),
(3, 2, 3, NULL, NULL, NULL),
(4, 2, 4, NULL, NULL, NULL),
(5, 4, 5, NULL, NULL, NULL),
(6, 1, 6, NULL, NULL, NULL),
(7, 2, 7, NULL, NULL, NULL),
(8, 5, 8, NULL, NULL, NULL),
(9, 3, 9, NULL, NULL, NULL),
(10, 1, 10, NULL, NULL, NULL),
(11, 4, 11, NULL, NULL, NULL),
(12, 1, 12, NULL, NULL, NULL),
(13, 5, 13, NULL, NULL, NULL),
(14, 2, 14, NULL, NULL, NULL);

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

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

CREATE TABLE `locations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(155) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci 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, '0001_01_01_000001_create_cache_table', 1),
(2, '0001_01_01_000002_create_jobs_table', 1),
(3, '2014_10_12_000000_create_users_table', 1),
(4, '2014_10_12_100000_create_password_resets_table', 1),
(5, '2019_08_19_000000_create_failed_jobs_table', 1),
(6, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(7, '2022_02_25_154033_create_packages_table', 1),
(8, '2022_03_04_023723_create_app_settings_table', 1),
(9, '2022_03_06_033720_create_site_infos_table', 1),
(10, '2022_03_07_070035_create_locations_table', 1),
(11, '2022_03_08_151905_create_categories_table', 1),
(12, '2022_03_13_023746_create_listings_table', 1),
(13, '2022_03_13_040347_create_list_categories_table', 1),
(14, '2022_03_17_014117_create_business_details_table', 1),
(15, '2022_03_29_064824_create_ratings_table', 1),
(16, '2022_03_30_053653_create_timings_table', 1),
(17, '2022_04_02_115956_create_pages_table', 1);

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

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

CREATE TABLE `packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL,
  `desic` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double NOT NULL,
  `listing` int(11) NOT NULL,
  `verification` enum('Yes','No') COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` enum('Allowed','Not Allowed') COLLATE utf8mb4_unicode_ci NOT NULL,
  `review` enum('Yes','No') COLLATE utf8mb4_unicode_ci NOT NULL,
  `services` int(11) NOT NULL,
  `products` int(11) NOT NULL,
  `images` int(11) NOT NULL,
  `validity` int(11) NOT NULL,
  `deleted_at` timestamp NULL 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 `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(175) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(175) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `pages`
--

INSERT INTO `pages` (`id`, `title`, `url`, `description`, `content`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'About Us', 'about-us', 'About Smart Directory', '{\"time\":1648996331278,\"blocks\":[{\"id\":\"-mnkfH47Jg\",\"type\":\"paragraph\",\"data\":{\"text\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce placerat rhoncus dolor feugiat semper. Vestibulum imperdiet purus nibh, ut finibus dolor lobortis quis. Vivamus et blandit urna. Aliquam mi arcu, sagittis nec tortor vel, sollicitudin dapibus nulla. Praesent a semper magna, non cursus odio. Nulla volutpat, lacus eu tincidunt egestas, erat nisi sodales diam, et vestibulum nisl mauris venenatis metus. Morbi mattis metus eu placerat scelerisque. Cras tempor diam quis erat imperdiet, non malesuada tortor efficitur. Quisque aliquam convallis arcu, quis consequat felis sagittis quis. Cras sapien risus, cursus vel placerat non, tempus quis nulla.\"}},{\"id\":\"WHq8ztwe_k\",\"type\":\"paragraph\",\"data\":{\"text\":\"Maecenas quis turpis pharetra, sollicitudin leo vel, posuere felis. Proin id congue libero. Vestibulum sit amet nulla dui. Etiam in mattis felis. Fusce luctus odio ut semper volutpat. Etiam cursus mauris eget mollis finibus. Cras varius mattis dui, vitae viverra nisi fringilla nec. Aenean tincidunt tempus risus, ut lobortis eros suscipit eget. Fusce fermentum tempus massa, nec hendrerit augue laoreet sit amet. Pellentesque eget luctus ligula, quis molestie ante.\"}},{\"id\":\"WzAoUqjhcJ\",\"type\":\"header\",\"data\":{\"text\":\"Our Mission\",\"level\":2}},{\"id\":\"bg0nP0MtAw\",\"type\":\"paragraph\",\"data\":{\"text\":\"Duis lacus libero, accumsan at volutpat et, hendrerit suscipit velit. Etiam lobortis eros tellus, in congue nisl rutrum eget. Vestibulum turpis lorem, pretium eget nunc sed, pulvinar venenatis eros. Maecenas ullamcorper nisi id tortor consequat, id molestie nunc ornare. Pellentesque viverra maximus ullamcorper. Ut tincidunt viverra velit, at feugiat lorem fringilla in. Cras egestas, arcu placerat laoreet facilisis, elit turpis ultrices ante, sit amet sagittis lectus nulla eget felis. Phasellus a ornare lacus. Ut tristique purus quis dui convallis, at tempor lectus cursus. Donec lobortis metus iaculis diam ultricies bibendum. Morbi laoreet, tortor nec hendrerit egestas, arcu tortor iaculis lacus, non rhoncus ipsum risus ac nibh. Mauris pellentesque ac ligula at lacinia. Donec ornare tortor id erat blandit, sit amet tristique elit tempor. Phasellus semper scelerisque dolor nec elementum.\"}},{\"id\":\"izDk2Hk024\",\"type\":\"paragraph\",\"data\":{\"text\":\"Pellentesque mattis, risus sit amet pharetra mattis, mauris ante molestie erat, et gravida purus neque id mauris. Praesent vehicula sodales felis, eget tempor nibh ultricies at. Sed magna ex, gravida sit amet sem a, fermentum molestie risus. Pellentesque bibendum suscipit mi, ullamcorper eleifend nunc laoreet ut. Sed urna elit, vestibulum ac dolor quis, imperdiet ullamcorper ex. Donec ante justo, condimentum at vulputate a, imperdiet quis risus. Pellentesque malesuada, lacus et venenatis sodales, orci velit ullamcorper orci, ac feugiat odio neque egestas nibh. Suspendisse tincidunt, purus ac cursus rhoncus, neque eros tincidunt arcu, tempus rhoncus nibh quam sit amet purus. Integer sit amet augue eget tellus feugiat aliquam id sit amet urna.\"}},{\"id\":\"A9l5DS4dPA\",\"type\":\"header\",\"data\":{\"text\":\"Our Vision\",\"level\":2}},{\"id\":\"8WBtUHShoy\",\"type\":\"paragraph\",\"data\":{\"text\":\"Phasellus sit amet justo nec sem molestie auctor id ut diam. Vivamus non leo ornare, porta sem at, malesuada purus. Proin laoreet diam semper, accumsan tellus in, euismod nunc. Vestibulum iaculis laoreet sapien cursus convallis. Praesent a ullamcorper leo. Donec at dignissim ante. Nunc libero dui, porttitor a pretium non, eleifend eget ipsum. Phasellus pellentesque sagittis consectetur. Phasellus laoreet non ante in viverra. Aliquam luctus ultricies tortor, non mollis diam hendrerit commodo. Cras a tortor tempor, ullamcorper orci at, consectetur leo. Praesent ut consequat ante. Nulla aliquam mauris mi, id iaculis enim lacinia nec. Sed sed sapien eget justo placerat lobortis at eu tortor. Vivamus ac orci tortor.\"}}],\"version\":\"2.23.2\"}', NULL, NULL, NULL),
(2, 'Privacy Policy', 'privacy-policy', 'Privacy Policy', '{\"time\":1648996383534,\"blocks\":[{\"id\":\"E4P2VvNPzq\",\"type\":\"paragraph\",\"data\":{\"text\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. In blandit purus in condimentum mattis. Nam venenatis quam vel eros posuere, eget pulvinar felis commodo. Ut finibus tincidunt turpis tristique fermentum. Aenean quis est consequat, efficitur mauris vitae, sagittis turpis. Maecenas volutpat dui et gravida suscipit. Proin at sagittis nisl, ac pellentesque augue. Donec varius pharetra diam in tempor. Phasellus aliquet, diam condimentum laoreet semper, arcu mauris ullamcorper felis, eu sagittis ex quam in sem. Curabitur vestibulum lacus vel sagittis finibus. Vestibulum tellus tortor, fermentum ut ante a, placerat mattis ipsum. Nullam quis mauris at turpis sodales tincidunt in vel neque. Quisque et nisl a ante suscipit placerat sit amet nec mi. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Praesent sed finibus enim, et consequat eros. Proin tellus arcu, interdum sed blandit vitae, pulvinar a sapien. Sed diam lacus, tincidunt eu cursus eu, luctus a tellus.\"}},{\"id\":\"AQq_44FVKt\",\"type\":\"paragraph\",\"data\":{\"text\":\"Vestibulum justo turpis, pharetra quis quam nec, ultricies hendrerit massa. Suspendisse sed dictum odio, a malesuada sapien. Donec venenatis, nisi vel tempor imperdiet, justo turpis aliquet ligula, id aliquet erat tellus vel nunc. Donec faucibus purus lorem, non luctus est sodales sit amet. Nam malesuada libero pulvinar purus elementum, sollicitudin vulputate risus posuere. Vivamus suscipit dolor dapibus tortor tempor accumsan. Phasellus a lacus interdum, dictum augue ut, semper ipsum. Praesent id orci luctus, semper magna id, ornare nunc. Aliquam massa ex, consequat sed lacus eget, molestie volutpat nulla. Mauris consectetur arcu nisi, eget porttitor nibh pulvinar in. Proin nec luctus risus, non volutpat orci. Mauris vulputate, mauris eget molestie vulputate, nisi tortor commodo libero, vitae facilisis magna nibh ultrices lorem. Donec iaculis magna in purus luctus luctus. In vitae orci blandit mauris ultrices sollicitudin vitae at ex. Donec eu hendrerit neque, eu fermentum metus. Suspendisse sagittis porttitor urna, at laoreet leo porta sed.\"}},{\"id\":\"cceQQUu5SZ\",\"type\":\"paragraph\",\"data\":{\"text\":\"Nulla condimentum vestibulum semper. Interdum et malesuada fames ac ante ipsum primis in faucibus. Quisque laoreet feugiat massa sit amet hendrerit. Morbi hendrerit ex risus, sed euismod mi feugiat quis. Ut feugiat, urna at pretium posuere, eros arcu sollicitudin arcu, nec suscipit neque tortor et mauris. Duis lobortis, sem convallis semper ultricies, velit arcu rhoncus massa, id pulvinar erat ipsum quis lectus. Sed volutpat sem sit amet turpis bibendum imperdiet. Curabitur tortor dolor, finibus nec sollicitudin vel, lacinia a velit. Etiam quis gravida metus. Ut egestas fermentum diam a gravida.\"}}],\"version\":\"2.23.2\"}', NULL, NULL, NULL),
(3, 'Terms and Conditions', 'terms-and-conditions', 'Terms and Conditions', '{\"time\":1648996418077,\"blocks\":[],\"version\":\"2.23.2\"}', NULL, NULL, NULL);

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_used_at` timestamp NULL 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 `ratings`
--

CREATE TABLE `ratings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `listing_id` bigint(20) UNSIGNED NOT NULL,
  `rating` float NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL 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 `sessions`
--

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

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

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('82neuQ7rxWwEAhXjGnLL2JMraVy0j9M99UGxOGlC', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1 Safari/605.1.15', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaDJoeU5uNjljcDlha090dndiMGNjVXZHSEtCSnJKcXVKempZVHF2YSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1732015719),
('cbehDiumYPrIIlHSVjfM1UPUzG8lDywCwXhSPxzt', 1, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1 Safari/605.1.15', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQzAxMGRwaE5wMFhCRVo3R1djWDJheW1nRWl6ZTM5WHBNSTliNUhxZCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9saXN0aW5nL2NyZWF0ZSI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1732001954),
('IFeP378NPVQIvJmHKBnTln6ir7fNDDrROQH0KkxW', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiamNLYXVyYmZRWDZTY3V3WDJTRzFYdkZ2aUZnNHdCY2FORmhNOEVLQyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1733118186),
('M47Ryy7aVR3bflGcF3QrJJpMCLugr7GnJJrS3YMX', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1 Safari/605.1.15', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUG1udEhiQkRsWHdobDJoTnppa2lBN3ZkdnRuSHF1R0pkMkVwWnRUUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1732023240),
('X1VVXpoeGVFfknf297IGVfA30V5QSr61cMuA1zAx', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMFlqV1BYSXFiMHdMQjRYNE9Xc3FzbkNPdjhFbkxoUTVpQzJqN091SCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1736472027);

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

--
-- Table structure for table `site_infos`
--

CREATE TABLE `site_infos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `logo` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fav` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_no_1` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_no_2` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_1` varchar(215) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_2` varchar(215) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `web` varchar(115) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fb` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tw` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `li` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ins` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `yt` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pin` varchar(225) 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 `site_infos`
--

INSERT INTO `site_infos` (`id`, `logo`, `fav`, `mobile_no_1`, `mobile_no_2`, `email_1`, `email_2`, `web`, `address`, `title`, `meta`, `description`, `fb`, `tw`, `li`, `ins`, `yt`, `pin`, `created_at`, `updated_at`) VALUES
(1, 'logo/smartdirectory_logo.png', 'fav/smartdirectory_fav.png', '+987 98676789', '+044 878898789', 'info@smartdirectory.com', 'sales@smartdirectory.com', 'https://smarteyeapps.com', '5-34, Rosestreet, Ramson Motycarony, Torranto', 'Smart Directory - Find top rates services and business near you', 'smart-directory, business directory, business listing', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce placerat rhoncus dolor feugiat semper. Vestibulum imperdiet purus nibh, ut finibus dolor lobortis quis. Vivamus et blandit urna. Aliquam mi arcu, sagittis nec tortor vel', 'https://facebook.com', 'http://twitter.com', 'https://linkedin.com', 'http://instagram.com', 'https://youtube.com', 'http://pinterest.com', NULL, NULL);

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

--
-- Table structure for table `timings`
--

CREATE TABLE `timings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `listing_id` bigint(20) UNSIGNED NOT NULL,
  `monday_from` time DEFAULT NULL,
  `monday_to` time DEFAULT NULL,
  `tuesday_from` time DEFAULT NULL,
  `tuesday_to` time DEFAULT NULL,
  `wednesday_from` time DEFAULT NULL,
  `wednesday_to` time DEFAULT NULL,
  `thursday_from` time DEFAULT NULL,
  `thursday_to` time DEFAULT NULL,
  `friday_from` time DEFAULT NULL,
  `friday_to` time DEFAULT NULL,
  `saturday_from` time DEFAULT NULL,
  `saturday_to` time DEFAULT NULL,
  `sunday_from` time DEFAULT NULL,
  `sunday_to` time DEFAULT NULL,
  `iframe` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` varchar(155) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(155) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube` varchar(155) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pintrest` varchar(155) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(155) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` varchar(155) 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 `timings`
--

INSERT INTO `timings` (`id`, `listing_id`, `monday_from`, `monday_to`, `tuesday_from`, `tuesday_to`, `wednesday_from`, `wednesday_to`, `thursday_from`, `thursday_to`, `friday_from`, `friday_to`, `saturday_from`, `saturday_to`, `sunday_from`, `sunday_to`, `iframe`, `facebook`, `twitter`, `youtube`, `pintrest`, `instagram`, `linkedin`, `created_at`, `updated_at`) VALUES
(1, 1, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(2, 2, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(3, 3, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(4, 4, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(5, 5, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(6, 6, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(7, 7, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(8, 8, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(9, 9, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(10, 10, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(11, 11, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(12, 12, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(13, 13, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL),
(14, 14, '09:30:00', '18:30:00', '09:30:00', '06:30:00', '10:02:00', '17:03:00', '08:40:00', '18:30:00', '10:15:00', '19:30:00', '06:03:00', '14:03:00', '10:30:00', '17:30:00', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15659.16664494769!2d77.32095495000002!3d11.1288885!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m3!3e0!4m0!4m0!5e0!3m2!1sen!2sin!4v1645123276968!5m2!1sen!2sin', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', 'https://pintrest.com', 'https://instagram.com', 'https://linkedin.com', NULL, NULL);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `role` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(35) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(125) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pincode` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `role`, `image`, `mobile`, `state`, `city`, `pincode`, `address`, `password`, `remember_token`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'John Smith', 'johnsmith@example.com', NULL, 'user', 'HNQDwAVikQAGrZWbnbV4NDSneAS33Qm8SNxjSZp7.jpg', '91 8787 8786', NULL, 'Chennai', NULL, 'Rosestreet, Motycarony, Torranto', '$2y$12$m0QCVr8FcfiUDbtFIys5NeqvoVla1FUS8mqL75JGNDkFbFxTWjloO', NULL, NULL, NULL, NULL),
(2, 'Reena Samuel', 'reenasmauel@example.com', NULL, 'user', 'iqeL3q4MenO9lPmVkWFIEm5uDaSTUA8GepztH7jn.jpg', '91 8787 8786', NULL, 'Chennai', NULL, '34-5, Kolivari, Malapali, Torranto', '$2y$12$AqXnWQNGTOZM7d/XUMilxupzjFpyo65Vd46boaxOJWhustaCyz9Qa', NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `business_details`
--
ALTER TABLE `business_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `business_details_listing_id_foreign` (`listing_id`),
  ADD KEY `business_details_user_id_foreign` (`user_id`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`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 `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Indexes for table `listings`
--
ALTER TABLE `listings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `listings_user_id_foreign` (`user_id`);

--
-- Indexes for table `list_categories`
--
ALTER TABLE `list_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `list_categories_category_id_foreign` (`category_id`),
  ADD KEY `list_categories_listing_id_foreign` (`listing_id`);

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

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

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `ratings`
--
ALTER TABLE `ratings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ratings_user_id_foreign` (`user_id`),
  ADD KEY `ratings_listing_id_foreign` (`listing_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 `site_infos`
--
ALTER TABLE `site_infos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `timings`
--
ALTER TABLE `timings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `timings_listing_id_foreign` (`listing_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `locations`
--
ALTER TABLE `locations`
  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=18;

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `business_details`
--
ALTER TABLE `business_details`
  ADD CONSTRAINT `business_details_listing_id_foreign` FOREIGN KEY (`listing_id`) REFERENCES `listings` (`id`),
  ADD CONSTRAINT `business_details_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `listings`
--
ALTER TABLE `listings`
  ADD CONSTRAINT `listings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `list_categories`
--
ALTER TABLE `list_categories`
  ADD CONSTRAINT `list_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  ADD CONSTRAINT `list_categories_listing_id_foreign` FOREIGN KEY (`listing_id`) REFERENCES `listings` (`id`);

--
-- Constraints for table `ratings`
--
ALTER TABLE `ratings`
  ADD CONSTRAINT `ratings_listing_id_foreign` FOREIGN KEY (`listing_id`) REFERENCES `listings` (`id`),
  ADD CONSTRAINT `ratings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `timings`
--
ALTER TABLE `timings`
  ADD CONSTRAINT `timings_listing_id_foreign` FOREIGN KEY (`listing_id`) REFERENCES `listings` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
