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

START TRANSACTION;



--
-- Database: `housevtwodb`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `bank_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `town` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `account_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `assigns`
--

CREATE TABLE `assigns` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `job_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `feedback` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `award` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `assigns`
--

INSERT INTO `assigns` (`id`, `service_id`, `job_id`, `user_id`, `feedback`, `status`, `award`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 2, NULL, '1', '1', '2021-08-07 20:27:44', '2021-08-07 20:29:30'),
(2, 1, 4, 2, NULL, '1', '1', '2021-08-07 20:30:56', '2021-08-07 20:31:11');

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

--
-- Table structure for table `assign_points`
--

CREATE TABLE `assign_points` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `points` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '10',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `assign_points`
--

INSERT INTO `assign_points` (`id`, `user_id`, `points`, `created_at`, `updated_at`) VALUES
(1, 3, '20', '2021-08-07 14:26:52', '2021-08-07 20:05:26'),
(2, 6, '20', '2021-08-07 16:19:35', '2021-08-07 20:13:12');

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

--
-- Table structure for table `automations`
--

CREATE TABLE `automations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `permission` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `automations`
--

INSERT INTO `automations` (`id`, `permission`, `created_at`, `updated_at`) VALUES
(1, 'no', '2021-08-07 14:26:53', '2021-08-07 14:26:53');

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

--
-- Table structure for table `bank_balances`
--

CREATE TABLE `bank_balances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `job_id` bigint(20) UNSIGNED NOT NULL,
  `balance` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `points` int(11) NOT NULL DEFAULT 0,
  `job_after_payment` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Professional Services', '2021-08-07 14:26:51', '2021-08-07 14:26:51'),
(2, 'General Services ', '2021-08-07 14:26:51', '2021-08-07 14:26:51'),
(3, 'Skilled Tradesmen', '2021-08-07 14:26:51', '2021-08-07 14:26:51');

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

--
-- Table structure for table `certificates`
--

CREATE TABLE `certificates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `course_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `institution` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `course_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `institution_from` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `institution_to` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `charges`
--

CREATE TABLE `charges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `subcategory_id` bigint(20) UNSIGNED NOT NULL,
  `price` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `charges`
--

INSERT INTO `charges` (`id`, `user_id`, `subcategory_id`, `price`, `currency`, `created_at`, `updated_at`) VALUES
(1, 4, 1, '231', 'jmd', '2021-08-07 16:28:34', '2021-08-07 16:28:34');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ph_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `message` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `details_released`
--

CREATE TABLE `details_released` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `job_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `holding_fee` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `quotes` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `doc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `reply_quote` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `assign_jobs` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `details_released`
--

INSERT INTO `details_released` (`id`, `job_id`, `user_id`, `holding_fee`, `quotes`, `doc`, `status`, `reply_quote`, `assign_jobs`, `created_at`, `updated_at`) VALUES
(1, 1, 2, '400', '1000', NULL, '2', '1', '1', '2021-08-07 20:27:07', '2021-08-07 20:27:44'),
(2, 4, 2, '100', '2000', NULL, '2', '1', '1', '2021-08-07 20:30:32', '2021-08-07 20:30:56');

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

--
-- Table structure for table `experiences`
--

CREATE TABLE `experiences` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `company_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `role` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `from` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `to` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `que` text COLLATE utf8_unicode_ci NOT NULL,
  `ans` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `free_services`
--

CREATE TABLE `free_services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `permission` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `free_services`
--

INSERT INTO `free_services` (`id`, `permission`, `created_at`, `updated_at`) VALUES
(1, 'no', '2021-08-07 14:26:52', '2021-08-07 14:26:52');

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

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `sr_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `invoice_details` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `sub_category_id` bigint(20) UNSIGNED NOT NULL,
  `town_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `payment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `publish` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `desc` text COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `seen` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 0,
  `paid_pading` int(11) NOT NULL DEFAULT 0,
  `bank_slip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `job_compelete_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sup_req_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` enum('range','standard') COLLATE utf8_unicode_ci NOT NULL,
  `price` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `latitude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `user_id`, `sub_category_id`, `town_id`, `title`, `date`, `payment`, `publish`, `desc`, `image`, `seen`, `status`, `paid_pading`, `bank_slip`, `job_compelete_date`, `sup_req_date`, `type`, `price`, `longitude`, `latitude`, `created_at`, `updated_at`) VALUES
(1, 6, 1, 1, 'web dev', '2021-08-21', '', '1', 'mudasirm', '', 1, 4, 0, NULL, NULL, '2021-08-08 10:28:40', 'standard', '', NULL, NULL, '2021-08-07 16:33:46', '2021-08-07 20:27:44'),
(2, 6, 1, 1, 'web dev', '2021-08-25', '', '1', 'mudaisr', '', 0, 1, 0, NULL, NULL, '2021-08-08 10:58:44', 'standard', '', NULL, NULL, '2021-08-07 17:53:43', '2021-08-07 17:58:44'),
(3, 6, 1, 1, 'web dev', '2021-09-10', '', '1', 'dd', '', 0, 1, 0, NULL, NULL, '2021-08-08 11:48:41', 'standard', '', NULL, NULL, '2021-08-07 17:59:44', '2021-08-07 18:48:41'),
(4, 6, 1, 1, 'web dev', '2021-09-10', '', '1', 'dd', '', 1, 4, 0, NULL, NULL, '2021-08-08 11:54:34', 'standard', '', NULL, NULL, '2021-08-07 18:49:16', '2021-08-07 20:30:56'),
(5, 6, 1, 1, 'web dev', '2021-09-10', '', '1', 'dd', '', 0, 1, 0, NULL, NULL, '2021-08-08 13:05:21', 'standard', '', NULL, NULL, '2021-08-07 18:55:01', '2021-08-07 20:05:21'),
(6, 3, 1, 1, 'web dev', '2021-09-03', '', '1', 'mudaisr', '', 0, 1, 0, NULL, NULL, '2021-08-08 13:10:39', 'standard', '', NULL, NULL, '2021-08-07 20:09:36', '2021-08-07 20:10:39'),
(7, 3, 1, 1, 'web dev', '2021-09-03', '', '1', 'mudaisr', '', 0, 1, 0, NULL, NULL, '2021-08-08 13:13:08', 'standard', '', NULL, NULL, '2021-08-07 20:12:51', '2021-08-07 20:13:08');

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

--
-- Table structure for table `job_images`
--

CREATE TABLE `job_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `job_id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `loyalty_points`
--

CREATE TABLE `loyalty_points` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `assign_points` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `points_rate` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `points_val` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `loyalty_points`
--

INSERT INTO `loyalty_points` (`id`, `assign_points`, `points_rate`, `points_val`, `created_at`, `updated_at`) VALUES
(1, '10', '1', '5', '2021-08-07 14:26:52', '2021-08-07 14:26:52');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_100000_create_password_resets_table', 1),
(2, '2019_08_19_000000_create_failed_jobs_table', 1),
(3, '2021_02_10_110643_create_roles_table', 1),
(4, '2021_02_10_111847_create_users_table', 1),
(5, '2021_02_12_103621_create_nearest_towns_table', 1),
(6, '2021_02_12_103708_create_user_towns_table', 1),
(7, '2021_02_15_123432_create_contacts_table', 1),
(8, '2021_02_16_140642_create_qualifications_table', 1),
(9, '2021_02_16_141259_create_experiences_table', 1),
(10, '2021_02_16_141523_create_certificates_table', 1),
(11, '2021_02_23_114203_create_categories_table', 1),
(12, '2021_02_23_121706_create_sub_categories_table', 1),
(13, '2021_02_24_081047_create_services_table', 1),
(14, '2021_02_24_081454_create_reviews_table', 1),
(15, '2021_02_24_081537_create_ratings_table', 1),
(16, '2021_02_25_103914_create_jobs_table', 1),
(17, '2021_02_25_144829_create_assigns_table', 1),
(18, '2021_03_05_122439_create_recommands_table', 1),
(19, '2021_03_11_092024_create_news_table', 1),
(20, '2021_03_17_110436_create_viewed_recommendations_table', 1),
(21, '2021_03_26_091652_create_payments_table', 1),
(22, '2021_03_27_105358_create_details_released_table', 1),
(23, '2021_04_02_125916_create_charges_table', 1),
(24, '2021_04_03_074834_create_accounts_table', 1),
(25, '2021_04_23_031941_create_faqs_table', 1),
(26, '2021_05_06_052147_create_invoice_table', 1),
(27, '2021_05_10_041416_create_pages_table', 1),
(28, '2021_05_10_054223_create_page_stores_table', 1),
(29, '2021_05_21_122133_create_web_files_table', 1),
(30, '2021_05_31_103206_create_loyalty_points_table', 1),
(31, '2021_06_01_090111_create_assign_points_table', 1),
(32, '2021_06_14_110324_create_bank_balances_table', 1),
(33, '2021_07_12_094814_create_free_services_table', 1),
(34, '2021_07_17_143535_create_proofs_table', 1),
(35, '2021_07_19_100032_create_resolutions_table', 1),
(36, '2021_07_24_090730_create_automations_table', 1),
(37, '2021_08_01_101424_create_job_images_table', 1),
(38, '2021_08_03_100007_create_user_details_table', 1),
(39, '2021_08_07_144131_create__user_feeback_table', 2);

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

--
-- Table structure for table `nearest_towns`
--

CREATE TABLE `nearest_towns` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `nearest_towns`
--

INSERT INTO `nearest_towns` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'karachi', '2021-08-07 16:28:48', '2021-08-07 16:28:48');

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `desc` text COLLATE utf8_unicode_ci NOT NULL,
  `publish` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `image`, `desc`, `publish`, `created_at`, `updated_at`) VALUES
(1, 'news 1', 'newsfbSY36jfVTSm9HLWYXPd.jpeg', 'a;lksdfjsadf', '1', '2021-08-07 21:30:36', '2021-08-07 21:31:10');

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `pages` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'About', '2021-08-07 14:26:51', '2021-08-07 14:26:51'),
(2, 'How our service works', '2021-08-07 14:26:51', '2021-08-07 14:26:51'),
(3, 'Loyalty rewards program', '2021-08-07 14:26:52', '2021-08-07 14:26:52'),
(4, 'Thinking to become a Service Provider?', '2021-08-07 14:26:52', '2021-08-07 14:26:52'),
(5, 'Service Provider training program', '2021-08-07 14:26:52', '2021-08-07 14:26:52'),
(6, 'Opportunities for Service Providers', '2021-08-07 14:26:52', '2021-08-07 14:26:52'),
(7, 'Community involvement', '2021-08-07 14:26:52', '2021-08-07 14:26:52'),
(8, 'Meet our team', '2021-08-07 14:26:52', '2021-08-07 14:26:52'),
(9, 'Terms and Conditions', '2021-08-07 14:26:52', '2021-08-07 14:26:52'),
(10, 'Privacy Policy', '2021-08-07 14:26:52', '2021-08-07 14:26:52'),
(11, 'Cookie Policy', '2021-08-07 14:26:52', '2021-08-07 14:26:52'),
(12, 'Home', '2021-08-07 14:26:52', '2021-08-07 14:26:52');

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

--
-- Table structure for table `page_stores`
--

CREATE TABLE `page_stores` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page_id` bigint(20) UNSIGNED NOT NULL,
  `meta` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `side_meta` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `user_id`, `transaction_id`, `created_at`, `updated_at`) VALUES
(1, 6, 'ch_3JLmleCyyJ0RKpxZ03iRgj9P', '2021-08-07 17:28:40', '2021-08-07 17:28:40'),
(2, 6, 'ch_3JLnElCyyJ0RKpxZ1cM5D8J4', '2021-08-07 17:58:43', '2021-08-07 17:58:43'),
(3, 6, 'ch_3JLnG4CyyJ0RKpxZ0gdPHghI', '2021-08-07 18:00:04', '2021-08-07 18:00:04'),
(4, 6, 'ch_3JLnILCyyJ0RKpxZ1AWQMpUB', '2021-08-07 18:02:25', '2021-08-07 18:02:25'),
(5, 6, 'ch_3JLnJbCyyJ0RKpxZ0PgaFfbM', '2021-08-07 18:03:43', '2021-08-07 18:03:43'),
(6, 6, 'ch_3JLnNpCyyJ0RKpxZ0fZR9Ane', '2021-08-07 18:08:05', '2021-08-07 18:08:05'),
(7, 6, 'ch_3JLnOmCyyJ0RKpxZ0yMwyrmb', '2021-08-07 18:09:04', '2021-08-07 18:09:04'),
(8, 6, 'ch_3JLnRHCyyJ0RKpxZ0GaESsiP', '2021-08-07 18:11:39', '2021-08-07 18:11:39'),
(9, 6, 'ch_3JLnoBCyyJ0RKpxZ0GlgL5m4', '2021-08-07 18:35:19', '2021-08-07 18:35:19'),
(10, 6, 'ch_3JLnrjCyyJ0RKpxZ0B60fO9I', '2021-08-07 18:38:59', '2021-08-07 18:38:59'),
(11, 6, 'ch_3JLnsGCyyJ0RKpxZ1muWIMpU', '2021-08-07 18:39:32', '2021-08-07 18:39:32'),
(12, 6, 'ch_3JLnssCyyJ0RKpxZ0oKdCn87', '2021-08-07 18:40:10', '2021-08-07 18:40:10'),
(13, 6, 'ch_3JLnu0CyyJ0RKpxZ0aI5Ny1f', '2021-08-07 18:41:20', '2021-08-07 18:41:20'),
(14, 6, 'ch_3JLnwJCyyJ0RKpxZ0LzdsZ4D', '2021-08-07 18:43:43', '2021-08-07 18:43:43'),
(15, 6, 'ch_3JLo17CyyJ0RKpxZ1719FJFH', '2021-08-07 18:48:41', '2021-08-07 18:48:41'),
(16, 6, 'ch_3JLo6oCyyJ0RKpxZ1EHx32Ox', '2021-08-07 18:54:34', '2021-08-07 18:54:34'),
(17, 6, 'ch_3JLo7fCyyJ0RKpxZ1iLlsI0m', '2021-08-07 18:55:27', '2021-08-07 18:55:27'),
(18, 6, 'ch_3JLoFnCyyJ0RKpxZ1b2F5mtE', '2021-08-07 19:03:51', '2021-08-07 19:03:51'),
(19, 6, 'ch_3JLoKOCyyJ0RKpxZ1LyZCfIP', '2021-08-07 19:08:35', '2021-08-07 19:08:35'),
(20, 6, 'ch_3JLoO8CyyJ0RKpxZ07GUQEdA', '2021-08-07 19:12:28', '2021-08-07 19:12:28'),
(21, 6, 'ch_3JLoPvCyyJ0RKpxZ0z2MMseA', '2021-08-07 19:14:20', '2021-08-07 19:14:20'),
(22, 6, 'ch_3JLoSdCyyJ0RKpxZ1WMANcA2', '2021-08-07 19:17:07', '2021-08-07 19:17:07'),
(23, 6, 'ch_3JLoTDCyyJ0RKpxZ0VRPsryr', '2021-08-07 19:17:43', '2021-08-07 19:17:43'),
(24, 6, 'ch_3JLoUwCyyJ0RKpxZ0ik3UIQM', '2021-08-07 19:19:30', '2021-08-07 19:19:30'),
(25, 6, 'ch_3JLoWVCyyJ0RKpxZ0RA68VcR', '2021-08-07 19:21:08', '2021-08-07 19:21:08'),
(26, 6, 'ch_3JLoZYCyyJ0RKpxZ1evWPzNw', '2021-08-07 19:24:16', '2021-08-07 19:24:16'),
(27, 6, 'ch_3JLoeSCyyJ0RKpxZ0kYwX5Ip', '2021-08-07 19:29:20', '2021-08-07 19:29:20'),
(28, 6, 'ch_3JLpDJCyyJ0RKpxZ0UIx9HQ6', '2021-08-07 20:05:21', '2021-08-07 20:05:21'),
(29, 3, 'ch_3JLpIRCyyJ0RKpxZ1wzxOaOb', '2021-08-07 20:10:39', '2021-08-07 20:10:39'),
(30, 3, 'ch_3JLpKqCyyJ0RKpxZ18JHITGk', '2021-08-07 20:13:08', '2021-08-07 20:13:08');

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

--
-- Table structure for table `proofs`
--

CREATE TABLE `proofs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `proofs`
--

INSERT INTO `proofs` (`id`, `user_id`, `file_name`, `created_at`, `updated_at`) VALUES
(1, 6, 'proofqmBpjZB8OHoBv9sc3BC2.webp', '2021-08-07 16:19:35', '2021-08-07 16:19:35'),
(2, 6, 'proofVGmZB5yjBRzGzfgwXJwN.webp', '2021-08-07 16:19:35', '2021-08-07 16:19:35'),
(3, 7, 'prooftyx1babHJkkX6O7UnZqQ.webp', '2021-08-07 16:21:17', '2021-08-07 16:21:17');

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

--
-- Table structure for table `qualifications`
--

CREATE TABLE `qualifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `major` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `institution_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `degree` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `passing_year` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `ratings`
--

CREATE TABLE `ratings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `provider_id` bigint(20) UNSIGNED NOT NULL,
  `job_id` bigint(20) NOT NULL,
  `rating` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `recommands`
--

CREATE TABLE `recommands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `provider_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `provider_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `provider_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `provider_primary` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `provider_secondary` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `provider_oter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tell_us` text COLLATE utf8_unicode_ci NOT NULL,
  `your_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `your_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `your_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `your_messge` text COLLATE utf8_unicode_ci NOT NULL,
  `viewed` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `resolutions`
--

CREATE TABLE `resolutions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sr_no` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `service_provider_id` bigint(20) UNSIGNED NOT NULL,
  `dispute_details` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` enum('open','closed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'closed',
  `resolution` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `provider_id` bigint(20) UNSIGNED NOT NULL,
  `job_id` bigint(20) NOT NULL,
  `review` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'super admin', '2021-08-07 14:26:49', '2021-08-07 14:26:49'),
(2, 'seller', '2021-08-07 14:26:49', '2021-08-07 14:26:49'),
(3, 'bayer', '2021-08-07 14:26:49', '2021-08-07 14:26:49'),
(4, 'admin', '2021-08-07 14:26:49', '2021-08-07 14:26:49');

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

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

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `sub_category_id` bigint(20) UNSIGNED NOT NULL,
  `town_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `price` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `desc` text COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `latitude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `services` (`id`, `user_id`, `sub_category_id`, `town_id`, `title`, `price`, `status`, `desc`, `image`, `longitude`, `latitude`, `created_at`, `updated_at`) VALUES
(1, 2, 1, NULL, 'web dev', '0', '1', 'web', NULL, NULL, NULL, '2021-08-07 20:25:40', '2021-08-07 20:26:45');

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

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sub_categories`
--

INSERT INTO `sub_categories` (`id`, `category_id`, `name`, `created_at`, `updated_at`) VALUES
(1, 2, 'web dev', '2021-08-07 16:28:34', '2021-08-07 16:28:34');

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

--
-- Table structure for table `user_details`
--

CREATE TABLE `user_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `heard_about` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recommender_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recommender_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `point_assign` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_details`
--

INSERT INTO `user_details` (`id`, `user_id`, `heard_about`, `recommender_email`, `recommender_number`, `point_assign`, `created_at`, `updated_at`) VALUES
(1, 3, 'ali', 'mudasirm508@gmail.com', '974098890', 1, '2021-08-07 16:19:35', '2021-08-07 20:13:12');

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

--
-- Table structure for table `user_feeback`
--

CREATE TABLE `user_feeback` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `satisfied` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `about_our_service` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `better_next_time` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `permission` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `publish` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_feeback`
--

INSERT INTO `user_feeback` (`id`, `user_id`, `satisfied`, `about_our_service`, `better_next_time`, `permission`, `publish`, `created_at`, `updated_at`) VALUES
(4, 6, 'Satisfied', 'Do perspiciatis ut', 'Unde voluptatem culp', 'yes', '1', '2021-08-07 22:11:13', '2021-08-07 22:34:38'),
(5, 6, 'Satisfied', 'Et velit quidem mag', 'Sed enim ea esse lo', 'no', '1', '2021-08-07 22:11:19', '2021-08-07 22:33:41'),
(6, 6, 'Satisfied', 'Quasi repudiandae et', 'Dolorum rerum est re', 'yes', '0', '2021-08-07 22:21:04', '2021-08-07 22:21:04');

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

--
-- Table structure for table `user_towns`
--

CREATE TABLE `user_towns` (
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `town_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `viewed_recommendations`
--

CREATE TABLE `viewed_recommendations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `recommendation_id` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `web_files`
--

CREATE TABLE `web_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `assigns`
--
ALTER TABLE `assigns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `assigns_service_id_foreign` (`service_id`),
  ADD KEY `assigns_job_id_foreign` (`job_id`),
  ADD KEY `assigns_user_id_foreign` (`user_id`);

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

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

--
-- Indexes for table `bank_balances`
--
ALTER TABLE `bank_balances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bank_balances_job_id_foreign` (`job_id`);

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

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

--
-- Indexes for table `charges`
--
ALTER TABLE `charges`
  ADD PRIMARY KEY (`id`),
  ADD KEY `charges_user_id_foreign` (`user_id`),
  ADD KEY `charges_subcategory_id_foreign` (`subcategory_id`);

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

--
-- Indexes for table `details_released`
--
ALTER TABLE `details_released`
  ADD PRIMARY KEY (`id`),
  ADD KEY `details_released_job_id_foreign` (`job_id`),
  ADD KEY `details_released_user_id_foreign` (`user_id`);

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

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

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

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

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

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_user_id_foreign` (`user_id`),
  ADD KEY `jobs_sub_category_id_foreign` (`sub_category_id`),
  ADD KEY `jobs_town_id_foreign` (`town_id`);

--
-- Indexes for table `job_images`
--
ALTER TABLE `job_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `job_images_job_id_foreign` (`job_id`);

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

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

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

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

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

--
-- Indexes for table `page_stores`
--
ALTER TABLE `page_stores`
  ADD PRIMARY KEY (`id`),
  ADD KEY `page_stores_page_id_foreign` (`page_id`);

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

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

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

--
-- Indexes for table `ratings`
--
ALTER TABLE `ratings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ratings_user_id_foreign` (`user_id`),
  ADD KEY `ratings_service_id_foreign` (`service_id`),
  ADD KEY `ratings_provider_id_foreign` (`provider_id`);

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

--
-- Indexes for table `resolutions`
--
ALTER TABLE `resolutions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `resolutions_sr_no_foreign` (`sr_no`),
  ADD KEY `resolutions_client_id_foreign` (`client_id`),
  ADD KEY `resolutions_service_provider_id_foreign` (`service_provider_id`);

--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reviews_user_id_foreign` (`user_id`),
  ADD KEY `reviews_service_id_foreign` (`service_id`),
  ADD KEY `reviews_provider_id_foreign` (`provider_id`);

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

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `services_user_id_foreign` (`user_id`),
  ADD KEY `services_sub_category_id_foreign` (`sub_category_id`),
  ADD KEY `services_town_id_foreign` (`town_id`);

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

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

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

--
-- Indexes for table `user_towns`
--
ALTER TABLE `user_towns`
  ADD PRIMARY KEY (`user_id`,`town_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

--
-- 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` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `qualifications`
--
ALTER TABLE `qualifications`
  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 `recommands`
--
ALTER TABLE `recommands`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

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

--
-- Constraints for table `assigns`
--
ALTER TABLE `assigns`
  ADD CONSTRAINT `assigns_job_id_foreign` FOREIGN KEY (`job_id`) REFERENCES `jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `assigns_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `assigns_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

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

--
-- Constraints for table `bank_balances`
--
ALTER TABLE `bank_balances`
  ADD CONSTRAINT `bank_balances_job_id_foreign` FOREIGN KEY (`job_id`) REFERENCES `jobs` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `charges`
--
ALTER TABLE `charges`
  ADD CONSTRAINT `charges_subcategory_id_foreign` FOREIGN KEY (`subcategory_id`) REFERENCES `sub_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `charges_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `details_released`
--
ALTER TABLE `details_released`
  ADD CONSTRAINT `details_released_job_id_foreign` FOREIGN KEY (`job_id`) REFERENCES `jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `details_released_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

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

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

--
-- Constraints for table `jobs`
--
ALTER TABLE `jobs`
  ADD CONSTRAINT `jobs_sub_category_id_foreign` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `jobs_town_id_foreign` FOREIGN KEY (`town_id`) REFERENCES `nearest_towns` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `jobs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `job_images`
--
ALTER TABLE `job_images`
  ADD CONSTRAINT `job_images_job_id_foreign` FOREIGN KEY (`job_id`) REFERENCES `jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `page_stores`
--
ALTER TABLE `page_stores`
  ADD CONSTRAINT `page_stores_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

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

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

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

--
-- Constraints for table `ratings`
--
ALTER TABLE `ratings`
  ADD CONSTRAINT `ratings_provider_id_foreign` FOREIGN KEY (`provider_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `ratings_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `ratings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `resolutions`
--
ALTER TABLE `resolutions`
  ADD CONSTRAINT `resolutions_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `resolutions_service_provider_id_foreign` FOREIGN KEY (`service_provider_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `resolutions_sr_no_foreign` FOREIGN KEY (`sr_no`) REFERENCES `jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `reviews`
--
ALTER TABLE `reviews`
  ADD CONSTRAINT `reviews_provider_id_foreign` FOREIGN KEY (`provider_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `reviews_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `services`
--
ALTER TABLE `services`
  ADD CONSTRAINT `services_sub_category_id_foreign` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `services_town_id_foreign` FOREIGN KEY (`town_id`) REFERENCES `nearest_towns` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `services_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD CONSTRAINT `sub_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_details`
--
ALTER TABLE `user_details`
  ADD CONSTRAINT `user_details_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

