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

START TRANSACTION;



--
-- Database: `lumen`
--

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

--
-- Table structure for table `addresses`
--

CREATE TABLE `addresses` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_type` enum('1','2') DEFAULT NULL COMMENT '1=user, 2=contractor',
  `default_address` varchar(256) DEFAULT 'NO',
  `street_address` longtext DEFAULT NULL,
  `street_name` varchar(256) DEFAULT NULL,
  `apartment_number` varchar(256) DEFAULT NULL,
  `state` varchar(250) DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `location` varchar(250) DEFAULT NULL,
  `landmark` varchar(250) DEFAULT NULL,
  `pincode` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_notifications`
--

CREATE TABLE `admin_notifications` (
  `id` int(11) NOT NULL,
  `title` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_type` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `notifiable_id` bigint(20) UNSIGNED DEFAULT NULL,
  `data` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_notifications`
--

INSERT INTO `admin_notifications` (`id`, `title`, `user_type`, `user_id`, `notifiable_id`, `data`, `read_at`, `created_at`, `updated_at`) VALUES
(3, 'New Offer', '1', 6, NULL, '<p>Use this offer 20% off for all product</p>', NULL, '2021-06-10 17:04:24', NULL),
(4, 'New Offer', '1', 7, NULL, '<p>Use this offer 20% off for all product</p>', NULL, '2021-06-10 17:04:24', NULL),
(5, 'contractor offer', '2', 2, NULL, '<p>ssss</p>', NULL, '2021-06-10 17:34:48', NULL),
(6, 'TEST Notified', '2', 3, NULL, '<p>This is test notification</p>', NULL, '2021-06-18 07:48:10', NULL),
(7, 'TEST Notified', '2', 4, NULL, '<p>This is test notification</p>', NULL, '2021-06-18 07:48:10', NULL),
(8, 'test1', '1', 3, NULL, '<p>test</p>', NULL, '2021-06-24 08:56:57', NULL);

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

--
-- Table structure for table `app_rating`
--

CREATE TABLE `app_rating` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `contractor_id` int(11) DEFAULT NULL,
  `rating` enum('1','2','3','4','5') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `review` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `availability`
--

CREATE TABLE `availability` (
  `id` int(11) NOT NULL,
  `contractor_id` int(11) NOT NULL,
  `availability_type_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `availability`
--

INSERT INTO `availability` (`id`, `contractor_id`, `availability_type_id`) VALUES
(1, 14, 1);

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

--
-- Table structure for table `availability_slot`
--

CREATE TABLE `availability_slot` (
  `id` int(11) NOT NULL,
  `availability_id` int(11) NOT NULL,
  `primary_number` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secondry_number` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `chat_availability` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `availability_date` date DEFAULT NULL,
  `availability_time_from` time DEFAULT NULL,
  `availability_time_to` time DEFAULT NULL,
  `shift` enum('morning','afternoon','evening') COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `availability_slot`
--

INSERT INTO `availability_slot` (`id`, `availability_id`, `primary_number`, `secondry_number`, `chat_availability`, `availability_date`, `availability_time_from`, `availability_time_to`, `shift`) VALUES
(1, 1, '8826050648', '8826001122', NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `availability_type`
--

CREATE TABLE `availability_type` (
  `id` int(11) NOT NULL,
  `name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '1=active, 0=inactive',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `availability_type`
--

INSERT INTO `availability_type` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'PHONE', 1, '2021-06-28 04:56:57', '2021-06-28 04:56:57'),
(2, 'CHAT', 1, '2021-06-28 04:56:57', '2021-06-28 04:56:57'),
(3, 'CALENDER', 1, '2021-06-28 04:57:18', '2021-06-28 04:57:18');

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

--
-- Table structure for table `booking`
--

CREATE TABLE `booking` (
  `id` int(11) NOT NULL,
  `booking_id` varchar(250) DEFAULT '0123',
  `user_id` int(11) DEFAULT NULL,
  `contractor_id` int(11) DEFAULT NULL,
  `booking_date` datetime DEFAULT NULL,
  `slot_id` int(11) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `service_cat_id` int(11) DEFAULT NULL,
  `address` varchar(250) DEFAULT 'NULL',
  `booking_time` time DEFAULT NULL,
  `longitude` varchar(250) DEFAULT 'NULL',
  `status` enum('1','2','3','4','5') DEFAULT NULL COMMENT '''confirmed'',''on the way'',''in process'',''completed'', ''cancelled''',
  `latitude` varchar(250) DEFAULT 'NULL',
  `amount` varchar(250) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `booking`
--

INSERT INTO `booking` (`id`, `booking_id`, `user_id`, `contractor_id`, `booking_date`, `slot_id`, `service_id`, `service_cat_id`, `address`, `booking_time`, `longitude`, `status`, `latitude`, `amount`, `created_at`, `updated_at`) VALUES
(1, 'ZI00123', NULL, 1, '2020-05-07 00:00:00', 1, 4, 1, 'NH 24 Gorakhpur', '15:00:00', '123456.0000', '1', '123456.0000', '450', '0000-00-00 00:00:00', '2021-06-22 06:54:44'),
(2, 'ZI00124', NULL, 2, '2021-07-30 12:12:52', NULL, 1, 1, NULL, '01:00:00', NULL, '1', NULL, '100', '0000-00-00 00:00:00', NULL),
(13, '1', 14, 2, '2020-05-06 00:00:00', 1, 4, 1, 'NH 24 Gorakhpur', '15:00:00', '123456.0000', '1', '123456.0000', '450', '2021-06-25 05:33:16', '2021-06-25 05:33:16'),
(15, '1', 14, 1, '2020-05-06 00:00:00', 1, 1, 1, 'NH 24 Gorakhpur', '15:00:00', '123456.0000', '1', '123456.0000', '450', '2021-06-25 15:06:12', '2021-06-25 15:06:12'),
(16, '1', 14, 1, '2020-05-06 00:00:00', 1, 1, 1, 'NH 24 Gorakhpur', '15:00:00', '123456.0000', '1', '123456.0000', '450', '2021-06-25 15:10:57', '2021-06-25 15:10:57'),
(17, '125666', 14, 2, '2020-05-06 00:00:00', 1, 1, 1, 'Delhi', '15:00:00', '123456.0000', '1', '123456.0000', '250', '2021-07-03 02:30:27', '2021-07-03 02:30:27');

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

--
-- Table structure for table `community_post`
--

CREATE TABLE `community_post` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_type` enum('customer','contractor') DEFAULT NULL,
  `question` longtext DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `name` varchar(250) DEFAULT NULL,
  `email` varchar(250) DEFAULT NULL,
  `phone` varchar(250) DEFAULT NULL,
  `message` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `contact_us` (`id`, `name`, `email`, `phone`, `message`, `created_at`, `updated_at`) VALUES
(2, 'Asad shaikh', 'asad@gmail.com', '8826050648', 'Hi i am using your app !', '2021-06-22 07:10:47', '2021-06-22 07:10:47'),
(3, 'Rakesh sharma', 'rak066@gmail.com', '0123654789', 'I have a sign up problem in android phone', '2021-07-19 01:19:57', '2021-07-19 01:19:57'),
(6, 'Rakesh sharma', 'rak066@gmail.com', '0123654789', 'I have a sign up problem in android phone', '2021-07-19 01:20:22', '2021-07-19 01:20:22'),
(7, 'Rakesh sharma', 'rak066@gmail.com', '0123654789', 'I have a sign up problem in android phone', '2021-07-19 01:27:57', '2021-07-19 01:27:57');

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

--
-- Table structure for table `contractor_app_settings`
--

CREATE TABLE `contractor_app_settings` (
  `id` int(11) NOT NULL,
  `contractor_id` int(11) NOT NULL,
  `new_inquiry` enum('YES','NO') COLLATE utf8mb4_unicode_ci NOT NULL,
  `new_alert` enum('YES','NO') COLLATE utf8mb4_unicode_ci NOT NULL,
  `job_completed` enum('YES','NO') COLLATE utf8mb4_unicode_ci NOT NULL,
  `job_started` enum('YES','NO') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `contractor_service`
--

CREATE TABLE `contractor_service` (
  `id` int(11) NOT NULL,
  `contractor_id` int(11) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `contractor_service`
--

INSERT INTO `contractor_service` (`id`, `contractor_id`, `service_id`, `status`, `updated_at`, `created_at`) VALUES
(4, 2, 1, 'active', '2021-06-03 00:31:15', '2021-06-03 00:31:15'),
(5, 4, 1, 'active', '2021-06-10 03:24:21', '2021-06-10 03:24:21'),
(6, 5, 1, 'active', '2021-06-10 03:24:24', '2021-06-10 03:24:24'),
(9, 6, 2, 'active', '2021-06-17 13:13:23', '2021-06-17 13:13:23'),
(11, 9, 1, 'active', '2021-06-22 12:29:34', '2021-06-22 12:29:34'),
(12, 10, 2, 'active', '2021-06-22 12:32:46', '2021-06-22 12:32:46'),
(16, 3, 1, 'active', '2021-06-22 13:05:43', '2021-06-22 13:05:43'),
(17, 11, 1, 'active', '2021-06-25 08:18:50', '2021-06-25 08:18:50');

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

--
-- Table structure for table `contractor_sub_category`
--

CREATE TABLE `contractor_sub_category` (
  `id` int(11) NOT NULL,
  `contractor_id` int(11) DEFAULT NULL,
  `contractor_service_id` int(11) DEFAULT NULL,
  `service_cat_id` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `conversation`
--

CREATE TABLE `conversation` (
  `id` int(11) NOT NULL,
  `sender_id` int(11) DEFAULT NULL,
  `reciver_id` int(11) DEFAULT NULL,
  `image` varchar(250) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `create_subscription_plan`
--

CREATE TABLE `create_subscription_plan` (
  `id` int(11) NOT NULL,
  `plane_name` varchar(250) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `price` varchar(250) DEFAULT NULL,
  `discount_type` int(11) DEFAULT NULL COMMENT '1=percentage, 2= fixed',
  `discount_amount` float DEFAULT NULL,
  `frequency` int(11) DEFAULT NULL COMMENT '1=monthly, 2=quarterly, 3=half yearly, 4=yearly',
  `no_of_category` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '1=active,0=inactive',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `create_subscription_plan`
--

INSERT INTO `create_subscription_plan` (`id`, `plane_name`, `description`, `price`, `discount_type`, `discount_amount`, `frequency`, `no_of_category`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Gold Membership', 'Gold Membership Description', '500', 1, 15, 1, 5, 1, '2021-06-03 07:44:10', '2021-06-03 20:05:22');

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

--
-- Table structure for table `customer_addresses`
--

CREATE TABLE `customer_addresses` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT 0,
  `street_address` longtext DEFAULT NULL,
  `street_name` varchar(256) DEFAULT NULL,
  `apartment_number` varchar(256) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `state` varchar(250) DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `location` varchar(250) DEFAULT NULL,
  `landmark` varchar(250) DEFAULT NULL,
  `pincode` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `customer_addresses`
--

INSERT INTO `customer_addresses` (`id`, `customer_id`, `is_default`, `street_address`, `street_name`, `apartment_number`, `country`, `state`, `city`, `location`, `landmark`, `pincode`, `created_at`, `updated_at`) VALUES
(4, 1, 1, 'NK Mall Gorakhpur', 'Lane no 18', '150', 'India', 'UP', 'Gorakhpur', 'Near state bank of india', 'airport', '123456', '2021-07-18 15:20:03', '2021-07-19 03:19:18');

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

--
-- 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 `faqs`
--

CREATE TABLE `faqs` (
  `id` int(11) NOT NULL,
  `faqs_type` int(11) DEFAULT NULL,
  `question` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `answer` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `faqs_type`, `question`, `answer`, `created_at`, `updated_at`) VALUES
(1, 1, 'What is FAQ ?', 'FAQ stands for “Frequently Asked Questions.” An FAQ is a list of commonly asked questions and answers on a website about topics such as hours, shipping and handling, product information, and return policies', '2021-06-18 10:48:40', '2021-06-18 10:48:40');

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

--
-- Table structure for table `inquery`
--

CREATE TABLE `inquery` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `question` longtext DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inquery`
--

INSERT INTO `inquery` (`id`, `user_id`, `question`, `service_id`, `created_at`, `updated_at`) VALUES
(1, 2, 'Hello,\r\nPlease tell me the price of Ac Service.', 1, '2021-06-04 06:39:01', NULL),
(2, 3, 'Hello,\r\nPlease tell me the price of Ac Service.', 1, '2021-06-04 06:39:10', NULL);

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

--
-- Table structure for table `job_tracking`
--

CREATE TABLE `job_tracking` (
  `id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `contractor_id` int(11) NOT NULL,
  `job_started` datetime DEFAULT NULL,
  `job_end` datetime DEFAULT NULL,
  `status` enum('1','2','3','4','5') DEFAULT NULL COMMENT '''confirmed'',''on the way'',''in process'',''completed'', ''cancelled''',
  `reason` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `job_tracking`
--

INSERT INTO `job_tracking` (`id`, `booking_id`, `user_id`, `contractor_id`, `job_started`, `job_end`, `status`, `reason`, `created_at`, `updated_at`) VALUES
(1, 15, 14, 1, NULL, NULL, '1', NULL, '2021-06-25 15:06:12', '2021-06-25 15:06:12'),
(2, 16, 14, 1, NULL, NULL, '1', NULL, '2021-06-25 15:10:57', '2021-06-25 15:10:57'),
(3, 17, 14, 2, NULL, NULL, '1', NULL, '2021-07-03 02:30:27', '2021-07-03 02:30:27');

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

--
-- 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, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(4, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(5, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(6, '2016_06_01_000004_create_oauth_clients_table', 1),
(7, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(8, '2019_08_19_000000_create_failed_jobs_table', 1),
(9, '2021_05_11_131057_create_permission_tables', 1);

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

--
-- Table structure for table `my_favourites`
--

CREATE TABLE `my_favourites` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `contractor_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `my_favourites`
--

INSERT INTO `my_favourites` (`id`, `user_id`, `contractor_id`, `created_at`, `updated_at`) VALUES
(2, 1, 1, '2021-06-18 04:48:01', '2021-06-18 04:48:01'),
(3, 1, 2, '2021-06-22 07:02:24', '2021-06-22 07:02:24');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_type` enum('customer','contractor','vendor','admin') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_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 `notifications`
--

INSERT INTO `notifications` (`id`, `user_type`, `type`, `notifiable_type`, `notifiable_id`, `data`, `read_at`, `created_at`, `updated_at`) VALUES
('0d304f79-f544-47ed-aca7-07ea6260d958', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 34, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir12@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-14 05:30:47', '2021-07-14 05:30:47'),
('17d90e72-67cc-4a2a-8832-d0e02fd6445a', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 9, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir12@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-15 05:44:52', '2021-07-15 05:44:53'),
('1e6dd4d9-1914-424b-baaa-87a67bb89e53', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 12, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi Super!\",\"body\":\"Your email : sean@sparxitsolutions.com and your login password is : Sparx@123\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-17 02:50:13', '2021-07-17 02:50:13'),
('1fef0273-af55-4797-840c-5b68174723c9', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 31, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir12@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-14 05:26:25', '2021-07-14 05:26:25'),
('25d9f665-e4d9-47dd-b014-9020f87f5aba', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\Users\\User', 13, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi RAKESH!\",\"body\":\"Your email : info.rakeshpatel@gmail.com and your login password is : Sean@9211\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-18 07:15:10', '2021-07-18 07:15:10'),
('2943bad3-b3d8-4c48-b7ef-49d5aab90267', 'customer', 'Modules\\User\\Notifications\\NewUserNotification', 'Modules\\User\\Entities\\Customer', 13, '{\"data\":{\"greeting\":\"Hi !\",\"body\":\"Your email : dd@gmail.com and your login password is : 12345678\",\"database_notification_message\":\"User has been updated successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-22 11:16:07', '2021-06-22 11:16:07'),
('2b9cad03-5e61-48c6-8c52-f01aafeb6af0', 'customer', 'Modules\\Contractors\\Notifications\\NewContractorNotification', 'Modules\\Contractors\\Entities\\Contractor', 4, '{\"data\":{\"greeting\":\"Hi Abhi!\",\"body\":\"Your email : testingqa2303@gmail.com and your login password is : aaaaaa@2\",\"database_notification_message\":\"New contractor has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-10 03:24:25', '2021-06-10 03:24:25'),
('2d7a1559-7281-4a79-a27a-85b22366b443', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 7, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir12@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-14 08:33:17', '2021-07-14 08:33:17'),
('38efc8be-0faf-46aa-83ca-5420e24dc173', 'customer', 'Modules\\Contractors\\Notifications\\NewContractorNotification', 'Modules\\Contractors\\Entities\\Contractor', 5, '{\"data\":{\"greeting\":\"Hi Abhi!\",\"body\":\"Your email : testingqa2303@gmail.com and your login password is : aaaaaa@2\",\"database_notification_message\":\"New contractor has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-10 03:24:28', '2021-06-10 03:24:28'),
('41089636-c05a-45ba-a025-1bf2a0dd25b6', 'customer', 'Modules\\Contractors\\Notifications\\NewContractorNotification', 'Modules\\Contractors\\Entities\\Contractor', 10, '{\"data\":{\"greeting\":\"Hi test123!\",\"body\":\"Your email : tt2@gmail.com and your login password is : 123123123\",\"database_notification_message\":\"New contractor has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-22 12:32:51', '2021-06-22 12:32:51'),
('4b6f142b-9cef-4f6d-8179-09759b08ad69', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 22, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi Pankaj!\",\"body\":\"Your email : pankaj07@yopmail.com and your login password is : Asad@12345\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-05 08:46:04', '2021-07-05 08:46:04'),
('4ee4c5f8-58e6-4c6e-9dcf-3f1c9cd88f66', 'customer', 'Modules\\User\\Notifications\\NewUserNotification', 'Modules\\User\\Entities\\User', 7, '{\"data\":{\"greeting\":\"Hi Asad khan khan!\",\"body\":\"Your email : asad7223@gmail.com and your login password is : \",\"database_notification_message\":\"User has been updated successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-02 08:41:02', '2021-06-02 08:41:02'),
('4f3426cd-3bdb-47a3-a046-16ea4c32fdee', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 7, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi Rakesh!\",\"body\":\"Your email : rakesh@sparxitsolutions.com and your login password is : Sparx@123\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-17 06:03:06', '2021-07-17 06:03:06'),
('53e9a3b5-0bb6-4ce1-a4d5-67b6693954e2', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 23, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi user1!\",\"body\":\"Your email : u1@yopmail.com and your login password is : Asad@12345\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-06 04:02:25', '2021-07-06 04:02:25'),
('5c4e177a-14f1-4431-933b-e555da98cdc1', 'customer', 'Modules\\User\\Notifications\\NewUserNotification', 'Modules\\User\\Entities\\User', 7, '{\"data\":{\"greeting\":\"Hi Asad khan shaikh!\",\"body\":\"Your email : asad7223@gmail.com and your login password is : Asad@12345\",\"database_notification_message\":\"User has been updated successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-02 08:57:46', '2021-06-02 08:57:46'),
('5ec6e5ba-e8af-4fb2-bc02-fc540a89f948', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 28, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-14 05:03:21', '2021-07-14 05:03:21'),
('6aa7d8d8-daa1-4cd4-a602-29e516dc3105', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 25, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi kulbir!\",\"body\":\"Your email : kulbir@sparx.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-13 07:48:47', '2021-07-13 07:48:47'),
('6b257b2f-a26b-4909-944e-8384bd0560d4', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 29, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir12@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-14 05:06:13', '2021-07-14 05:06:13'),
('708c39e4-fede-4e0b-bce7-c48e6fc78775', 'customer', 'Modules\\User\\Notifications\\NewUserNotification', 'Modules\\User\\Entities\\User', 8, '{\"data\":{\"greeting\":\"Hi Abhi!\",\"body\":\"Your email : testingqa23@gmail.com and your login password is : aaaaaa@2\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-10 01:44:29', '2021-06-10 01:44:29'),
('733d53c9-42f5-4a6a-9ff6-ebd7bace6189', NULL, 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\Customers\\Customer', 39, '{\"user_type\":3,\"data\":{\"greeting\":\"Hi Rakesh!\",\"body\":\"Your email : rakesh071@yopmail.com and your login password is : Asad@12345\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-18 13:34:19', '2021-07-18 13:34:19'),
('7c346c6d-448a-447a-b28d-ef95adb843c9', 'customer', 'Modules\\Contractors\\Notifications\\NewContractorNotification', 'Modules\\Contractors\\Entities\\Contractor', 3, '{\"data\":{\"greeting\":\"Hi A!\",\"body\":\"Your email : asad.mfe@gmail.com and your login password is : Asad@1111\",\"database_notification_message\":\"New contractor has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-02 09:22:39', '2021-06-02 09:22:39'),
('7c60e1ba-659f-401c-aa86-dbaf7f6dc6d8', 'customer', 'Modules\\Contractors\\Notifications\\NewContractorNotification', 'Modules\\Contractors\\Entities\\Contractor', 3, '{\"data\":{\"greeting\":\"Hi Pradeep12!\",\"body\":\"Your email : pk1@yopmail.com and your login password is : 12345678\",\"database_notification_message\":\"New contractor has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-22 13:00:38', '2021-06-22 13:00:38'),
('7f3df6c8-95f0-4115-a13e-823e6097d5ad', NULL, 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\Customers\\Customer', 38, '{\"user_type\":3,\"data\":{\"greeting\":\"Hi Rakesh!\",\"body\":\"Your email : rakesh07@yopmail.com and your login password is : Asad@12345\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-18 13:31:22', '2021-07-18 13:31:22'),
('7f8a1430-f064-4893-8640-897fc7fd3a73', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 33, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir12@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-14 05:29:45', '2021-07-14 05:29:45'),
('83275e3c-902b-4bad-a9a6-fc5b796ab6ef', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 8, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi Rakesh!\",\"body\":\"Your email : raakesh@sparxitsolutions.com and your login password is : Sparx@123\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-17 06:14:45', '2021-07-17 06:14:45'),
('88898a07-0f73-4144-ba3d-9fe293af3749', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 32, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir12@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-14 05:28:43', '2021-07-14 05:28:44'),
('88ca71f9-2619-4f9d-9358-73725794ea2d', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 11, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir52@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-16 10:34:16', '2021-07-16 10:34:16'),
('90212dfb-49fb-4ce9-9849-06a092ccb31c', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 6, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi Rakesh!\",\"body\":\"Your email : rakesh.kumar@sparxitsolutions.com and your login password is : Sparx@123\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-17 05:39:19', '2021-07-17 05:39:19'),
('930c86da-6693-4a6b-a015-43b98a9e1bcd', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\Users\\User', 12, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi Sean!\",\"body\":\"Your email : demo2s@sparxitsolutions.com and your login password is : Sparx@123\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-18 06:56:24', '2021-07-18 06:56:24'),
('96c3a915-a7bd-404c-9e85-89050014db25', 'customer', 'Modules\\User\\Notifications\\NewUserNotification', 'Modules\\User\\Entities\\User', 7, '{\"data\":{\"greeting\":\"Hi Asad khan khan!\",\"body\":\"Your email : asad7223@gmail.com and your login password is : Asad@1234\",\"database_notification_message\":\"User has been updated successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-02 08:46:30', '2021-06-02 08:46:30'),
('97a9f0be-e75c-4cd7-a52e-4cb48ffaade7', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 6, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir12@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-14 08:32:04', '2021-07-14 08:32:04'),
('9f5ccc02-e25a-4db5-9fc0-4d57eeeadb95', 'customer', 'Modules\\Contractors\\Notifications\\NewContractorNotification', 'Modules\\Contractors\\Entities\\Contractor', 7, '{\"data\":{\"greeting\":\"Hi ghhhbhkj!\",\"body\":\"Your email : bmbbbh@gmail.com and your login password is : aaaaaaaa\",\"database_notification_message\":\"New contractor has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-16 10:44:25', '2021-06-16 10:44:25'),
('a2ff8728-94cb-44e2-9c5d-8750b248735d', 'vendor', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\Vendors\\Vendor', 12, '{\"user_type\":3,\"data\":{\"greeting\":\"Hi Rakesh!\",\"body\":\"Your email : rakesh01@yopmail.com and your login password is : Asad@12345\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-18 15:55:34', '2021-07-18 15:55:34'),
('a306259c-4ff2-4fa5-b4f8-71f03840fb4b', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 10, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi Sean!\",\"body\":\"Your email : demo@sparxitsolutions.com and your login password is : Sparx@123\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-17 12:31:56', '2021-07-17 12:31:56'),
('a835677c-9880-40c7-a817-e0d4c0858286', 'customer', 'Modules\\Contractors\\Notifications\\NewContractorNotification', 'Modules\\Contractors\\Entities\\Contractor', 6, '{\"data\":{\"greeting\":\"Hi pradeep!\",\"body\":\"Your email : testingqa2303@gmail.com and your login password is : 12345678\",\"database_notification_message\":\"New contractor has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-15 10:56:33', '2021-06-15 10:56:33'),
('b7ed93e3-bc5b-4b3c-a6b9-90e902f780a0', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 11, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi Sean!\",\"body\":\"Your email : demo2@sparxitsolutions.com and your login password is : Sparx@123\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-17 16:01:19', '2021-07-17 16:01:19'),
('b973d151-b3cf-4da0-8725-bed3ae336a4b', 'customer', 'Modules\\Contractors\\Notifications\\NewContractorNotification', 'Modules\\Contractors\\Entities\\Contractor', 9, '{\"data\":{\"greeting\":\"Hi pradeep!\",\"body\":\"Your email : terst12@gmail.com and your login password is : 123123123\",\"database_notification_message\":\"New contractor has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-22 12:29:38', '2021-06-22 12:29:38'),
('c0feb0ce-281b-4928-83b6-9ccc58b4094f', 'customer', 'Modules\\Contractors\\Notifications\\NewContractorNotification', 'Modules\\Contractors\\Entities\\Contractor', 11, '{\"data\":{\"greeting\":\"Hi test123!\",\"body\":\"Your email : pkgmail@gmail.com and your login password is : 12345678\",\"database_notification_message\":\"New contractor has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-25 08:18:54', '2021-06-25 08:18:54'),
('d7454772-c326-4299-b6fe-21d3a767778a', 'customer', 'Modules\\User\\Notifications\\NewUserNotification', 'Modules\\User\\Entities\\User', 6, '{\"data\":{\"greeting\":\"Hi A shaikh!\",\"body\":\"Your email : asad111@yopmail.com and your login password is : 12345678\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-02 08:25:58', '2021-06-02 08:25:58'),
('d8c8db73-c490-479c-bffc-9e4f4cf9612b', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 5, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir12@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-14 08:30:14', '2021-07-14 08:30:14'),
('dc234d1a-7d30-4a46-8ec9-2d1143e5b8a1', 'customer', 'Modules\\User\\Notifications\\NewUserNotification', 'Modules\\User\\Entities\\User', 7, '{\"data\":{\"greeting\":\"Hi Asad khan!\",\"body\":\"Your email : asad7223@gmail.com and your login password is : 12345678\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-02 08:27:51', '2021-06-02 08:27:51'),
('e405eded-e1fa-4f07-833b-e1c019d1f629', 'customer', 'Modules\\Contractors\\Notifications\\NewContractorNotification', 'Modules\\Contractors\\Entities\\Contractor', 3, '{\"data\":{\"greeting\":\"Hi Pr2!\",\"body\":\"Your email : pk1@yopmail.com and your login password is : 12345678\",\"database_notification_message\":\"New contractor has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-22 13:05:47', '2021-06-22 13:05:47'),
('e888eeda-bdbd-41bb-92d3-5da2812fd4b6', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 30, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir12@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-14 05:24:51', '2021-07-14 05:24:51'),
('ea665b21-1201-47d2-9f55-c3c1742f78c2', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\Customers\\Customer', 40, '{\"user_type\":3,\"data\":{\"greeting\":\"Hi Rakesh!\",\"body\":\"Your email : rakesh01@yopmail.com and your login password is : Asad@12345\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-18 13:36:23', '2021-07-18 13:36:23'),
('ebb237a5-e867-464f-97bf-ce65e34ac3f0', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 9, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi fdgfdg!\",\"body\":\"Your email : info.rakeshpatel@gmail.com and your login password is : Sean@9211\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-17 06:58:24', '2021-07-17 06:58:24'),
('f049c456-bdc0-4834-94d8-2644151bbe6f', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 20, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi Rakesh!\",\"body\":\"Your email : rakesh07@yopmail.com and your login password is : Asad@12345\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-03 02:02:15', '2021-07-03 02:02:15'),
('f23348b9-d639-4fe5-97fb-ffe8d92db60c', 'customer', 'Modules\\User\\Notifications\\NewUserNotification', 'Modules\\User\\Entities\\Customer', 13, '{\"data\":{\"greeting\":\"Hi Samya!\",\"body\":\"Your email : dd@gmail.com and your login password is : 1234567890\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-06-22 11:02:31', '2021-06-22 11:02:31'),
('f2c007c5-0146-4fd2-9898-88afef8bbf37', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 10, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir12@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-15 08:29:32', '2021-07-15 08:29:32'),
('f8016fa9-9372-4d88-9a30-0d1602d6affa', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\Customer', 35, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi kulbir!\",\"body\":\"Your email : kulbir123@gmail.com and your login password is : kulbir@123A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-15 11:37:41', '2021-07-15 11:37:41'),
('f806fc3d-1b59-4d37-86d2-306d76a1032e', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 21, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi Sean!\",\"body\":\"Your email : sean@sparxitsolutions.com and your login password is : Sean@123\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-03 14:34:14', '2021-07-03 14:34:14'),
('fe2722ea-24c5-40cf-b3a4-6a34b7dad0a5', 'customer', 'App\\Notifications\\CreateNewUserNotification', 'App\\Models\\User', 8, '{\"user_type\":\"customer\",\"data\":{\"greeting\":\"Hi KulbirSingh!\",\"body\":\"Your email : kulbir12@gmail.com and your login password is : kulbir@1A\",\"database_notification_message\":\"New user has been created successfully.\",\"thanks\":\"Welcome to ZION!!\"}}', NULL, '2021-07-15 04:30:30', '2021-07-15 04:30:30');

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

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_jwt`
--

CREATE TABLE `oauth_jwt` (
  `client_id` varchar(80) NOT NULL,
  `subject` varchar(80) DEFAULT NULL,
  `public_key` varchar(2000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` char(36) 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 `oauth_scopes`
--

CREATE TABLE `oauth_scopes` (
  `scope` varchar(80) NOT NULL,
  `is_default` tinyint(1) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `oauth_scopes`
--

INSERT INTO `oauth_scopes` (`scope`, `is_default`, `description`) VALUES
('catalog.products.delete', 1, NULL),
('catalog.products.read', 1, NULL),
('catalog.products.write', 1, NULL),
('customers.delete', 1, 'Delete customers.'),
('customers.read', 1, 'View customer\'s information.'),
('customers.write', 1, 'Modify customer\'s information.'),
('newsletters.delete', 1, NULL),
('newsletters.read', 1, NULL),
('newsletters.write', 1, NULL),
('products.categories.delete', 1, NULL),
('products.categories.read', 1, NULL),
('products.categories.write', 1, NULL),
('products.reviews.delete', 1, NULL),
('products.reviews.read', 1, NULL),
('products.reviews.write', 1, NULL),
('reports.delete', 1, NULL),
('reports.read', 1, NULL),
('reports.write', 1, NULL),
('roles.delete', 1, NULL),
('roles.read', 1, NULL),
('roles.write', 1, NULL),
('sales.orders.delete', 1, NULL),
('sales.orders.read', 1, NULL),
('sales.orders.write', 1, NULL),
('scopes.read', 1, NULL),
('users.delete', 1, 'Delete users.'),
('users.read', 1, 'View user\'s information.'),
('users.write', 1, 'Modify user\'s information.'),
('vendors.delete', 1, NULL),
('vendors.read', 1, NULL),
('vendors.write', 1, NULL);

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

--
-- Table structure for table `post_comments`
--

CREATE TABLE `post_comments` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `user_type` enum('customer','contractor') DEFAULT NULL,
  `comment` longtext DEFAULT NULL,
  `status` varchar(220) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `report_problems`
--

CREATE TABLE `report_problems` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `subject` varchar(250) DEFAULT NULL,
  `image` varchar(250) DEFAULT NULL,
  `problem` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `report_problems`
--

INSERT INTO `report_problems` (`id`, `user_id`, `subject`, `image`, `problem`, `created_at`, `updated_at`) VALUES
(5, 1, 'Facing login issue', NULL, 'sometime app going crash and also i got Facing login issue', '2021-07-19 01:35:40', '2021-07-19 01:35:40'),
(6, 1, 'Facing login issue', NULL, 'sometime app going crash and also i got Facing login issue', '2021-07-19 01:35:56', '2021-07-19 01:35:56'),
(8, 1, 'Facing login issue', NULL, 'sometime app going crash and also i got Facing login issue', '2021-07-19 01:39:53', '2021-07-19 01:39:53');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) UNSIGNED NOT NULL COMMENT '1=Admin, 2=Vendor, 3=Customer',
  `name` varchar(191) NOT NULL,
  `description` varchar(191) NOT NULL,
  `status` enum('active','inactive') NOT NULL,
  `scope` varchar(4000) DEFAULT NULL,
  `read_only` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=editable,1=not editable',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `description`, `status`, `scope`, `read_only`, `created_at`, `updated_at`, `deleted_at`, `created_by`) VALUES
(1, 'Administrators', '', 'active', NULL, 1, NULL, NULL, NULL, NULL),
(2, 'Vendors', '', 'active', NULL, 1, NULL, NULL, NULL, NULL),
(3, 'Customers', '', 'active', NULL, 1, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `running_status`
--

CREATE TABLE `running_status` (
  `id` int(11) NOT NULL,
  `booking_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `contractor_id` int(11) DEFAULT NULL,
  `running_status` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

CREATE TABLE `service-category` (
  `id` int(11) NOT NULL,
  `service_id` int(11) DEFAULT NULL,
  `sub_category_name` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `service-category` (`id`, `service_id`, `sub_category_name`, `created_at`, `updated_at`) VALUES
(1, 2, 'Tv Repairing', '2021-06-01 10:15:23', '2021-06-10 04:05:19'),
(2, 1, 'Repair', '2021-06-10 04:16:25', '2021-06-10 04:16:25'),
(3, 2, 'Carpenter', '2021-06-10 04:17:53', '2021-06-10 04:17:53');

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

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

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `service_name` varchar(250) DEFAULT NULL,
  `image` varchar(256) DEFAULT NULL,
  `status` varchar(256) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `service_name`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Electrician', '1622562262.bike.jpg', 'active', '2021-06-01 10:14:22', '2021-06-01 10:14:22'),
(2, 'Wood Work', '1623317425.Tag Heuer.jpg', 'active', '2021-06-10 04:00:25', '2021-06-10 04:00:25'),
(3, 'Photographer', '1624630268.Screenshot_2.jpg', 'active', '2021-06-25 14:11:08', '2021-06-25 14:11:08');

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

--
-- Table structure for table `static_pages`
--

CREATE TABLE `static_pages` (
  `id` int(11) NOT NULL,
  `page_name` varchar(250) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` int(11) DEFAULT 1 COMMENT '	1=active, 0=inactive',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `static_pages`
--

INSERT INTO `static_pages` (`id`, `page_name`, `title`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'about_us', 'About Us', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen books.</p>', 1, '2021-06-08 10:51:40', '2021-06-10 04:39:14'),
(2, 'terms_and_conditions', 'Terms & Conditions', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>', 1, '2021-06-08 10:51:40', '2021-06-08 11:19:13'),
(5, 'privacy_policy', 'Privacy Policy', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>', 1, '2021-06-08 10:51:40', '2021-06-08 11:20:12'),
(6, 'contact_us', 'Contact Us', '<p>Suite 316-3602 noida<br />Burnaby, BC V5G 4W9<br />noida</p>', 1, '2021-06-08 10:51:40', '2021-06-08 11:23:25');

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

--
-- Table structure for table `subscription_plan`
--

CREATE TABLE `subscription_plan` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `contractor_id` int(11) DEFAULT NULL,
  `plan_id` int(11) NOT NULL,
  `order_id` varchar(300) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `cancelled_date` datetime DEFAULT NULL,
  `status` int(11) NOT NULL COMMENT '1=active, 0=inactive',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `subscription_plan_services`
--

CREATE TABLE `subscription_plan_services` (
  `id` int(11) NOT NULL,
  `subscription_plan_id` int(11) NOT NULL,
  `service_name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_description` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_plan_services`
--

INSERT INTO `subscription_plan_services` (`id`, `subscription_plan_id`, `service_name`, `service_description`) VALUES
(1, 1, 'Free hosting', 'Free hosting service'),
(2, 1, 'Free email service', 'Free email service with mailchimp');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(10) NOT NULL,
  `transaction_id` varchar(191) DEFAULT NULL,
  `contractor_id` int(10) DEFAULT NULL,
  `reciever_id` int(10) DEFAULT NULL COMMENT '''admin''',
  `amount` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `status` enum('successful','pending','failed') DEFAULT NULL,
  `payment_method` varchar(191) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `transaction_id`, `contractor_id`, `reciever_id`, `amount`, `customer_id`, `status`, `payment_method`, `notes`, `created_at`, `updated_at`) VALUES
(1, '1212', 1, 1, '100', '1212121', 'successful', 'paypal', 'paid', '2021-06-11 15:02:42', NULL),
(2, '1212', 1, 1, '100', '1212121', 'successful', 'paypal', 'paid', '2021-06-18 14:59:30', NULL);

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

--
-- Table structure for table `user_payment_method`
--

CREATE TABLE `user_payment_method` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `card_no` varchar(250) DEFAULT NULL,
  `card_type` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `user_review`
--

CREATE TABLE `user_review` (
  `id` int(11) NOT NULL,
  `user_type` enum('customer','contractor') DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `contractor_id` int(11) DEFAULT NULL,
  `rating` enum('1','2','3','4','5') DEFAULT NULL COMMENT '1,2,3,4,5',
  `review` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_review`
--

INSERT INTO `user_review` (`id`, `user_type`, `user_id`, `contractor_id`, `rating`, `review`, `created_at`, `updated_at`) VALUES
(5, NULL, 1, 1, '3', 'Expert on photography', '2021-07-19 01:54:07', '2021-07-19 01:54:07'),
(7, NULL, 1, 1, '3', 'Expert on photography', '2021-07-19 01:55:09', '2021-07-19 01:55:09'),
(8, NULL, 1, 1, '3', 'Expert on photography', '2021-07-19 01:59:31', '2021-07-19 01:59:31'),
(9, NULL, 1, 1, '3', 'Expert on photography', '2021-07-19 02:05:51', '2021-07-19 02:05:51'),
(10, NULL, 1, 1, '3', 'Expert on photography', '2021-07-19 02:05:54', '2021-07-19 02:05:54'),
(14, NULL, 1, 1, '3', 'Expert on photography', '2021-07-19 03:12:30', '2021-07-19 03:12:30');

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

--
-- Table structure for table `user_wishlist`
--

CREATE TABLE `user_wishlist` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `contractor_id` int(11) DEFAULT NULL,
  `like_status` varchar(250) DEFAULT NULL,
  `created_at` int(11) NOT NULL DEFAULT current_timestamp(),
  `updated_at` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `vendor_addresses`
--

CREATE TABLE `vendor_addresses` (
  `id` int(11) NOT NULL,
  `vendor_id` int(11) DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT 0,
  `street_address` longtext DEFAULT NULL,
  `street_name` varchar(256) DEFAULT NULL,
  `apartment_number` varchar(256) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `state` varchar(250) DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `location` varchar(250) DEFAULT NULL,
  `landmark` varchar(250) DEFAULT NULL,
  `pincode` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `vendor_addresses`
--

INSERT INTO `vendor_addresses` (`id`, `vendor_id`, `is_default`, `street_address`, `street_name`, `apartment_number`, `country`, `state`, `city`, `location`, `landmark`, `pincode`, `created_at`, `updated_at`) VALUES
(3, 1, 1, 'Okhla delhi', 'Gali no 55', '150', 'India', 'UP', 'Delhi', 'Near BTW', 'India', '123456', '2021-07-18 16:01:20', '2021-07-19 03:08:18'),
(4, 1, 0, 'Okhla 44delhi', 'Gali no 55', '150', 'India', 'UP', 'Delhi', 'Near BTW', 'India', '123456', '2021-07-18 16:04:25', '2021-07-19 03:08:18'),
(5, 1, 0, 'Okhla delhi', 'Gali no 55', '150', 'India', 'UP', 'Delhi', 'Near BTW', 'India', '123456', '2021-07-19 03:07:58', '2021-07-19 03:08:18');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `admin_notifications`
--
ALTER TABLE `admin_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_id`);

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

--
-- Indexes for table `availability`
--
ALTER TABLE `availability`
  ADD PRIMARY KEY (`id`),
  ADD KEY `availability_id` (`availability_type_id`),
  ADD KEY `contractor_id` (`contractor_id`);

--
-- Indexes for table `availability_slot`
--
ALTER TABLE `availability_slot`
  ADD PRIMARY KEY (`id`),
  ADD KEY `availability_id` (`availability_id`);

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

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

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

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

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

--
-- Indexes for table `contractor_service`
--
ALTER TABLE `contractor_service`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contractor_id` (`contractor_id`),
  ADD KEY `service_cat_id` (`service_id`);

--
-- Indexes for table `contractor_sub_category`
--
ALTER TABLE `contractor_sub_category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contractor_id` (`contractor_id`),
  ADD KEY `service_cat_id` (`service_cat_id`),
  ADD KEY `contractor_service_id` (`contractor_service_id`);

--
-- Indexes for table `conversation`
--
ALTER TABLE `conversation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reciver_id` (`reciver_id`),
  ADD KEY `sender_id` (`sender_id`);

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

--
-- Indexes for table `customer_addresses`
--
ALTER TABLE `customer_addresses`
  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 `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `job_tracking`
--
ALTER TABLE `job_tracking`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `contractor_id` (`contractor_id`),
  ADD KEY `booking_id` (`booking_id`);

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

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

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

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

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

--
-- Indexes for table `oauth_scopes`
--
ALTER TABLE `oauth_scopes`
  ADD PRIMARY KEY (`scope`);

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

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

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

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

--
-- Indexes for table `service-category`
--
ALTER TABLE `service-category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cat_relation` (`service_id`);

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

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

--
-- Indexes for table `subscription_plan`
--
ALTER TABLE `subscription_plan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `plan_id` (`plan_id`),
  ADD KEY `contractor_id` (`contractor_id`);

--
-- Indexes for table `subscription_plan_services`
--
ALTER TABLE `subscription_plan_services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subscription_plan_id` (`subscription_plan_id`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `addresses`
--
ALTER TABLE `addresses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `admin_notifications`
--
ALTER TABLE `admin_notifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `app_rating`
--
ALTER TABLE `app_rating`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `availability`
--
ALTER TABLE `availability`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `availability_slot`
--
ALTER TABLE `availability_slot`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `availability_type`
--
ALTER TABLE `availability_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `booking`
--
ALTER TABLE `booking`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `community_post`
--
ALTER TABLE `community_post`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contact_us`
--
ALTER TABLE `contact_us`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `contractor_app_settings`
--
ALTER TABLE `contractor_app_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contractor_service`
--
ALTER TABLE `contractor_service`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `contractor_sub_category`
--
ALTER TABLE `contractor_sub_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `conversation`
--
ALTER TABLE `conversation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `create_subscription_plan`
--
ALTER TABLE `create_subscription_plan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `customer_addresses`
--
ALTER TABLE `customer_addresses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `inquery`
--
ALTER TABLE `inquery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `job_tracking`
--
ALTER TABLE `job_tracking`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

--
-- AUTO_INCREMENT for table `my_favourites`
--
ALTER TABLE `my_favourites`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

--
-- AUTO_INCREMENT for table `post_comments`
--
ALTER TABLE `post_comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `report_problems`
--
ALTER TABLE `report_problems`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '1=Admin, 2=Vendor, 3=Customer', AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `running_status`
--
ALTER TABLE `running_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `service-category`
--
ALTER TABLE `service-category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `static_pages`
--
ALTER TABLE `static_pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `subscription_plan`
--
ALTER TABLE `subscription_plan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscription_plan_services`
--
ALTER TABLE `subscription_plan_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `user_payment_method`
--
ALTER TABLE `user_payment_method`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_review`
--
ALTER TABLE `user_review`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `user_wishlist`
--
ALTER TABLE `user_wishlist`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor_addresses`
--
ALTER TABLE `vendor_addresses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `addresses`
--
ALTER TABLE `addresses`
  ADD CONSTRAINT `addresses_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `addresses_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `contractors` (`id`);

--
-- Constraints for table `app_rating`
--
ALTER TABLE `app_rating`
  ADD CONSTRAINT `app_rating_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `contractors` (`id`),
  ADD CONSTRAINT `app_rating_ibfk_2` FOREIGN KEY (`contractor_id`) REFERENCES `contractors` (`id`);

--
-- Constraints for table `booking`
--
ALTER TABLE `booking`
  ADD CONSTRAINT `booking_ibfk_1` FOREIGN KEY (`contractor_id`) REFERENCES `contractors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `booking_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`);

--
-- Constraints for table `community_post`
--
ALTER TABLE `community_post`
  ADD CONSTRAINT `community_post_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `community_post_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `contractors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `community_post_ibfk_3` FOREIGN KEY (`category_id`) REFERENCES `services` (`id`);

--
-- Constraints for table `contractor_service`
--
ALTER TABLE `contractor_service`
  ADD CONSTRAINT `contractor_service_ibfk_1` FOREIGN KEY (`contractor_id`) REFERENCES `contractors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `contractor_sub_category`
--
ALTER TABLE `contractor_sub_category`
  ADD CONSTRAINT `contractor_sub_category_ibfk_1` FOREIGN KEY (`contractor_service_id`) REFERENCES `contractor_service` (`id`);

--
-- Constraints for table `job_tracking`
--
ALTER TABLE `job_tracking`
  ADD CONSTRAINT `job_tracking_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `job_tracking_ibfk_2` FOREIGN KEY (`contractor_id`) REFERENCES `contractors` (`id`),
  ADD CONSTRAINT `job_tracking_ibfk_3` FOREIGN KEY (`booking_id`) REFERENCES `booking` (`id`);

--
-- Constraints for table `post_comments`
--
ALTER TABLE `post_comments`
  ADD CONSTRAINT `post_comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `community_post` (`id`),
  ADD CONSTRAINT `post_comments_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `post_comments_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `contractors` (`id`);

--
-- Constraints for table `running_status`
--
ALTER TABLE `running_status`
  ADD CONSTRAINT `running_status_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `running_status_ibfk_2` FOREIGN KEY (`contractor_id`) REFERENCES `contractors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `service-category`
--
ALTER TABLE `service-category`
  ADD CONSTRAINT `service-category_ibfk_1` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`);

--
-- Constraints for table `subscription_plan`
--
ALTER TABLE `subscription_plan`
  ADD CONSTRAINT `subscription_plan_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `subscription_plan_ibfk_2` FOREIGN KEY (`plan_id`) REFERENCES `create_subscription_plan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `subscription_plan_ibfk_3` FOREIGN KEY (`contractor_id`) REFERENCES `contractors` (`id`);

--
-- Constraints for table `user_payment_method`
--
ALTER TABLE `user_payment_method`
  ADD CONSTRAINT `user_payment_method_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `contractors` (`id`);

--
-- Constraints for table `user_review`
--
ALTER TABLE `user_review`
  ADD CONSTRAINT `user_review_ibfk_2` FOREIGN KEY (`contractor_id`) REFERENCES `contractors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_wishlist`
--
ALTER TABLE `user_wishlist`
  ADD CONSTRAINT `user_wishlist_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `user_wishlist_ibfk_2` FOREIGN KEY (`contractor_id`) REFERENCES `contractors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

