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

START TRANSACTION;



--
-- Database: `alkhalaf_enosa`
--

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

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

CREATE TABLE `categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `created_at`, `updated_at`, `name`, `image`) VALUES
(1, NULL, '2021-01-08 20:10:03', 'استشوار', NULL),
(2, NULL, NULL, 'خدمة منزلية', NULL),
(3, NULL, '2021-01-08 20:10:39', 'صبغه شعر', NULL),
(4, NULL, '2021-01-08 20:11:08', 'العنايه بالشعر', NULL),
(5, '2020-12-30 01:33:49', '2020-12-30 01:33:49', 'سبا', NULL),
(7, '2020-12-31 23:02:28', '2021-01-04 20:07:45', 'مايكرو', NULL),
(8, '2021-01-01 20:19:33', '2021-01-08 20:11:39', 'العنايه بالجسم', NULL),
(9, '2021-01-08 20:12:32', '2021-01-08 20:12:32', 'شمع او حلاوه', NULL),
(10, '2021-01-08 20:13:12', '2021-01-08 20:13:12', 'فتله', NULL),
(11, '2021-01-08 20:13:56', '2021-01-08 20:13:56', 'تشقير', NULL),
(12, '2021-01-08 20:14:35', '2021-01-08 20:14:35', 'العنايه بالبشرة', NULL),
(13, '2021-01-08 20:15:10', '2021-01-08 20:15:10', 'العنايه بالاظافر', NULL),
(14, '2021-01-08 20:15:38', '2021-01-08 20:15:38', 'المكياج', NULL);

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

--
-- Table structure for table `chats`
--

CREATE TABLE `chats` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sender_id` int(10) UNSIGNED NOT NULL,
  `receiver_id` int(10) UNSIGNED NOT NULL,
  `room_id` int(10) UNSIGNED NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `created_at`, `updated_at`, `name`) VALUES
(5, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'تبوك'),
(6, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'الرياض'),
(7, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'الطائف'),
(8, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'مكة المكرمة'),
(9, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'حائل'),
(10, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'بريدة'),
(11, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'الهفوف'),
(12, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'الدمام'),
(13, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'المدينة المنورة'),
(14, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'ابها'),
(15, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'جازان'),
(16, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'جدة'),
(17, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'المجمعة'),
(18, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'الخبر'),
(19, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'حفر الباطن'),
(20, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'خميس مشيط'),
(21, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'احد رفيده'),
(22, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'القطيف'),
(23, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'عنيزة'),
(24, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'قرية العليا'),
(25, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'الجبيل'),
(26, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'النعيرية'),
(27, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'الظهران'),
(28, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'الوجه'),
(29, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'بقيق'),
(30, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'الزلفي'),
(31, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'خيبر'),
(32, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'الغاط'),
(33, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'املج'),
(34, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'رابغ'),
(35, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'عفيف'),
(36, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'ثادق'),
(37, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'سيهات'),
(38, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'تاروت'),
(39, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'ينبع'),
(40, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'شقراء'),
(41, '2020-12-21 12:54:20', '2020-12-21 12:54:20', 'الدوادمي'),
(42, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'الدرعية'),
(43, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'القويعية'),
(44, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'المزاحمية'),
(45, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'بدر'),
(46, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'الخرج'),
(47, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'الدلم'),
(48, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'الشنان'),
(49, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'الخرمة'),
(50, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'الجموم'),
(51, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'المجاردة'),
(52, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'السليل'),
(53, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'تثليث'),
(54, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'بيشة'),
(55, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'الباحة'),
(56, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'القنفذة'),
(57, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'محايل'),
(58, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'ثول'),
(59, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'ضبا'),
(60, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'تربه'),
(61, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'صفوى'),
(62, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'عنك'),
(63, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'طريف'),
(64, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'عرعر'),
(65, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'القريات'),
(66, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'سكاكا'),
(67, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'رفحاء'),
(68, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'دومة الجندل'),
(69, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'الرس'),
(70, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'المذنب'),
(71, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'الخفجي'),
(72, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'رياض الخبراء'),
(73, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'البدائع'),
(74, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'رأس تنورة'),
(75, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'البكيرية'),
(76, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'الشماسية'),
(77, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'الحريق'),
(78, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'حوطة بني تميم'),
(79, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'ليلى'),
(80, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'بللسمر'),
(81, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'شرورة'),
(82, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'نجران'),
(83, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'صبيا'),
(84, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'ابو عريش'),
(85, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'صامطة'),
(86, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'احد المسارحة'),
(87, '2020-12-21 12:54:21', '2020-12-21 12:54:21', 'مدينة الملك عبدالله الاقتصادية'),
(88, '2020-12-29 20:36:22', '2020-12-29 20:36:22', 'جده');

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

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

CREATE TABLE `contacts` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `seen` enum('true','false') COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `created_at`, `updated_at`, `name`, `mobile`, `email`, `message`, `seen`) VALUES
(1, '2020-07-15 13:23:33', '2020-07-15 13:23:33', 'Farouz', '966555555', 'hossamfarouz15@gmail.com', 'اي كالام', 'false'),
(2, '2020-07-15 13:24:51', '2020-07-15 13:24:51', 'Farouz', '966555555', 'hossamfarouz15@gmail.com', 'اي كالام', 'false'),
(3, '2020-07-15 23:29:55', '2020-07-15 23:29:55', 'Farouz', '966555555', 'hossamfarouz15@gmail.com', 'اي كالام', 'false'),
(4, '2020-07-21 22:39:26', '2020-07-21 22:39:26', 'Farouz', '966555555', 'hossamfarouz15@gmail.com', 'اي كالام', 'false'),
(5, '2020-07-22 01:02:15', '2020-07-22 01:02:15', 'Farouz', '966555555', 'hossamfarouz15@gmail.com', 'اي كالام', 'false'),
(6, '2020-07-22 01:05:26', '2020-07-22 01:05:26', 'reresss', '01008226144', 'ssaa@ss.com', 'Defewfw', 'false'),
(7, '2020-07-26 16:05:31', '2020-07-26 16:05:31', 'reresss', '01008226144', 'ssaa@ss.com', 'Hhhhhhh', 'false'),
(8, '2020-07-26 16:05:36', '2020-07-26 16:05:36', 'reresss', '01008226144', 'ssaa@ss.com', 'Hhhhhhh', 'false'),
(9, '2020-08-01 10:38:11', '2020-08-01 10:38:11', 'vvvvsa', '01008226155', 'mowafdcymohab@gmail.com', 'Gswdfsd', 'false'),
(10, '2020-08-12 09:26:34', '2020-08-12 09:26:34', 'hossam farouz', '123456789', 'hossam@farouz.com', 'يشيسشي', 'false'),
(11, '2020-08-16 13:12:18', '2020-08-16 13:12:18', 'hossam farouz', '0123456789', 'hossam@farouz.com', 'Hkjdahgfjkh', 'false'),
(12, '2020-08-16 13:13:27', '2020-08-16 13:13:27', 'hossam farouz', '0123456789', 'hossam@farouz.com', 'Hkjdahgfjkh', 'false'),
(13, '2020-08-16 13:13:33', '2020-08-16 13:13:33', 'hossam farouz', '0123456789', 'hossam@farouz.com', 'Hkjdahgfjkh', 'false'),
(14, '2020-08-19 15:23:03', '2020-08-19 15:23:03', 'mohabsd', '123456789', 'mowafym3ohab@gmail.com', 'Hddhhkk', 'false'),
(15, '2020-08-19 21:07:54', '2020-08-19 21:07:54', 'mohabsd', '123456789', 'mowafym3ohab@gmail.com', 'Dsfsdfsdf', 'false'),
(16, '2020-08-27 16:45:56', '2020-08-27 16:45:56', 'salon55', '01207854555', 'salonnew@mail.com', 'kkkkk', 'false'),
(17, '2020-09-13 10:59:04', '2020-09-13 10:59:04', 'ابراهيم شمس', '01032875655', 'des.ibrahimshamss@gmail.com', 'hi 👋', 'false'),
(18, '2020-09-13 17:20:13', '2020-09-13 17:20:13', 'mohamed mahrous', 'client', 'a@adrakola.com', 'لثقل', 'false'),
(19, '2020-11-25 11:42:20', '2020-11-25 11:42:20', 'وشاقخعس', '1234567', 'as@as.com', 'Wrk', 'false'),
(20, '2020-11-25 11:43:51', '2020-11-25 11:43:51', 'باتن', '23456', 'as@ke.com', 'Fk', 'false'),
(21, '2021-01-12 19:20:42', '2021-01-12 19:20:42', 'salon_labelle21', '9660546163758', 'islam1maliki@gmail.com', 'نقدم خدمات صالونات منزلية /شعر/ مكياج /صبغات /بروتين/حف شعر/واكس/فتلة/حواجب/استشوار/قص/تساريح', 'false'),
(22, '2021-01-13 20:59:41', '2021-01-13 20:59:41', 'salon_labelle21', '9660546163758', 'islam1maliki@gmail.com', 'خدمات صالونات منزلية', 'false'),
(23, '2021-01-14 18:19:38', '2021-01-14 18:19:38', 'salon_labelle21', '9660546163758', 'islam1maliki@gmail.com', 'خدمات صالون منزلية', 'false'),
(24, '2021-01-28 18:48:26', '2021-01-28 18:48:26', 'اخلاص', '9660533245312', 'hawua.aklas@gmail.com', 'انا مسجله سابقا', 'false');

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

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

CREATE TABLE `failed_jobs` (
  `id` int(10) UNSIGNED 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 `favourites`
--

CREATE TABLE `favourites` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `salon_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `favourites`
--

INSERT INTO `favourites` (`id`, `created_at`, `updated_at`, `user_id`, `salon_id`) VALUES
(19, '2021-02-12 20:25:08', '2021-02-12 20:25:08', 162, 135);

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

--
-- Table structure for table `fields`
--

CREATE TABLE `fields` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fields`
--

INSERT INTO `fields` (`id`, `name`, `image`, `created_at`, `updated_at`) VALUES
(1, 'الصالونات', '817_1609279325.jpeg', '2020-09-17 08:03:10', '2020-12-30 01:20:08'),
(2, 'ميك اب ارتست', '233_1609295552.jpeg', '2020-09-17 08:03:28', '2020-12-30 01:44:39'),
(3, 'هير  ستايل', '870_1609277714.jpeg', '2020-12-29 20:35:14', '2020-12-30 01:43:50');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) 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, '2019_08_19_000000_create_failed_jobs_table', 1),
(3, '2020_06_23_130333_create_categories_table', 1),
(4, '2020_06_23_130333_create_chats_table', 1),
(5, '2020_06_23_130333_create_cities_table', 1),
(6, '2020_06_23_130333_create_contacts_table', 1),
(7, '2020_06_23_130333_create_favourites_table', 1),
(8, '2020_06_23_130333_create_notifications_table', 1),
(9, '2020_06_23_130333_create_order_services_table', 1),
(10, '2020_06_23_130333_create_orders_table', 1),
(11, '2020_06_23_130333_create_packages_table', 1),
(12, '2020_06_23_130333_create_rooms_table', 1),
(13, '2020_06_23_130333_create_salon_accounts_table', 1),
(14, '2020_06_23_130333_create_salon_bank_transfers_table', 1),
(15, '2020_06_23_130333_create_salon_categories_table', 1),
(16, '2020_06_23_130333_create_salon_comments_table', 1),
(17, '2020_06_23_130333_create_salon_images_table', 1),
(18, '2020_06_23_130333_create_salon_times_table', 1),
(19, '2020_06_23_130333_create_salons_table', 1),
(20, '2020_06_23_130333_create_services_table', 1),
(21, '2020_06_23_130333_create_settings_table', 1),
(22, '2020_06_23_130343_create_foreign_keys', 1),
(23, '2020_06_24_131748_create_user_tokens_table', 2),
(24, '2020_06_25_110734_add_salon_id_to_notifications', 3),
(25, '2020_06_25_114608_add_email_to_settings', 3),
(26, '2020_06_28_133831_add_duration_to_packages', 3),
(27, '2020_06_28_141505_add_place_to_services', 3),
(28, '2020_06_29_125437_add_finish_date_to_packages', 3),
(29, '2020_06_29_150620_add_city_id_to_salons', 4),
(30, '2020_06_29_153244_add_rate_to_salons', 4),
(31, '2020_06_30_111909_add_orders_count_to_salons', 5),
(32, '2020_06_30_114346_add_order_id_to_salon_comments', 6),
(33, '2020_06_30_121951_add_image_to_categories', 7),
(34, '2020_06_30_140419_add_order_place_to_orders', 8),
(35, '2020_07_01_092722_add_total_price_to_orders', 9),
(36, '2020_07_06_144146_add_account_id_to_salon_banks', 10),
(37, '2020_07_07_122953_add_parent_id_to_salon_bank_transfers', 11),
(38, '2020_08_19_132228_add_place_to_packages', 12),
(39, '2020_09_17_092314_create_fields_table', 13),
(40, '2020_09_17_092654_create_sliders_table', 13),
(41, '2020_09_17_100902_add_field_id_to_users_table', 14);

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

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

CREATE TABLE `notifications` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `order_id` int(10) UNSIGNED DEFAULT NULL,
  `body` text COLLATE utf8mb4_unicode_ci,
  `type` enum('admin','new_order','salon_accept_order','client_accept_order','salon_finish','client_accept_finish','salon_canceled','client_accept_cancel','salon_refuse') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salon_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `created_at`, `updated_at`, `user_id`, `order_id`, `body`, `type`, `salon_id`) VALUES
(5, '2020-07-06 11:49:06', '2020-07-06 11:49:06', 2, NULL, 'asdasdasdad', 'admin', NULL),
(6, '2020-07-06 11:49:06', '2020-07-06 11:49:06', 3, NULL, 'asdasdasdad', 'admin', NULL),
(7, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 2, NULL, 'مرحبا بكم في تطبيق أنوثه', 'admin', NULL),
(8, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 3, NULL, 'مرحبا بكم في تطبيق أنوثه', 'admin', NULL),
(9, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 150, NULL, 'مرحبا بكم في تطبيق أنوثه', 'admin', NULL),
(11, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 156, NULL, 'مرحبا بكم في تطبيق أنوثه', 'admin', NULL),
(12, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 157, NULL, 'مرحبا بكم في تطبيق أنوثه', 'admin', NULL),
(13, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 158, NULL, 'مرحبا بكم في تطبيق أنوثه', 'admin', NULL),
(14, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 159, NULL, 'مرحبا بكم في تطبيق أنوثه', 'admin', NULL),
(15, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 160, NULL, 'مرحبا بكم في تطبيق أنوثه', 'admin', NULL),
(16, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 161, NULL, 'مرحبا بكم في تطبيق أنوثه', 'admin', NULL),
(17, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 162, NULL, 'مرحبا بكم في تطبيق أنوثه', 'admin', NULL),
(18, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 163, NULL, 'مرحبا بكم في تطبيق أنوثه', 'admin', NULL),
(19, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 164, NULL, 'مرحبا بكم في تطبيق أنوثه', 'admin', NULL),
(20, '2020-12-17 09:12:33', '2020-12-17 09:12:33', 164, NULL, 'أهلا بكم', 'admin', NULL),
(22, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 2, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(23, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 3, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(24, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 150, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(25, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 156, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(26, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 157, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(27, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 158, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(28, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 159, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(29, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 160, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(30, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 161, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(31, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 162, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(32, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 163, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(33, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 164, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(34, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 166, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(35, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 167, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(36, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 168, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(37, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 169, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(38, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 170, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(41, '2020-12-30 01:27:21', '2020-12-30 01:27:21', 183, NULL, 'الان لدينا عروض و خصومات نهاية ٢٠٢٠', 'admin', NULL),
(42, '2021-02-12 20:58:54', '2021-02-12 20:58:54', 184, 14, 'لديكم طلب جديد', 'new_order', 123),
(43, '2021-05-01 14:41:48', '2021-05-01 14:41:48', 184, 18, 'لديكم طلب جديد', 'new_order', 123);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `salon_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_type` enum('cash','visa') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_date` date DEFAULT NULL,
  `order_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('waiting','in_progress','cancel','finish','in_complete','salon_refuse') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lng` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `package_id` int(10) UNSIGNED DEFAULT NULL,
  `order_place` enum('salon','home') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `created_at`, `updated_at`, `salon_id`, `user_id`, `code`, `payment_type`, `order_date`, `order_time`, `status`, `lat`, `lng`, `address`, `package_id`, `order_place`, `total_price`) VALUES
(5, '2020-12-31 16:55:28', '2020-12-31 16:55:28', 123, 160, '5fee10906d8a5', NULL, NULL, NULL, 'in_complete', NULL, NULL, NULL, NULL, 'salon', '405.0'),
(6, '2021-01-01 20:56:52', '2021-01-01 20:56:52', 123, 160, '5fef9aa4694c3', NULL, NULL, NULL, 'in_complete', NULL, NULL, NULL, NULL, 'salon', '405.0'),
(7, '2021-01-01 20:57:14', '2021-01-01 20:57:14', 123, 160, '5fef9abad28f3', NULL, NULL, NULL, 'in_complete', NULL, NULL, NULL, NULL, 'salon', '405.0'),
(8, '2021-01-01 20:58:53', '2021-01-01 20:58:53', 123, 160, '5fef9b1d46778', NULL, NULL, NULL, 'in_complete', NULL, NULL, NULL, NULL, 'salon', '405.0'),
(10, '2021-01-08 20:02:39', '2021-01-08 20:02:39', 124, 160, '5ff8c86fedca6', NULL, NULL, NULL, 'in_complete', NULL, NULL, NULL, NULL, 'salon', '720.0'),
(11, '2021-01-10 13:44:18', '2021-01-10 13:44:18', 123, 193, '5ffb12c2ee89f', NULL, NULL, NULL, 'in_complete', NULL, NULL, NULL, NULL, 'salon', '405.0'),
(12, '2021-01-10 13:46:46', '2021-01-10 13:46:46', 123, 193, '5ffb1356977e8', NULL, NULL, NULL, 'in_complete', NULL, NULL, NULL, NULL, 'salon', '405.0'),
(13, '2021-01-20 19:48:39', '2021-01-20 19:48:39', 123, 193, '60089727911b2', NULL, NULL, NULL, 'in_complete', NULL, NULL, NULL, NULL, 'salon', '405.0'),
(14, '2021-02-12 20:58:24', '2021-02-12 20:58:54', 123, 193, '6026fa00bd712', 'cash', '2021-02-23', '8:58 PM', 'waiting', '30.87899266769773', '31.46424890906649', 'test', NULL, 'salon', '405.0'),
(15, '2021-02-22 15:07:30', '2021-02-22 15:07:30', 123, 193, '6033d6c2883d3', NULL, NULL, NULL, 'in_complete', NULL, NULL, NULL, NULL, 'salon', '405.0'),
(16, '2021-02-24 14:18:52', '2021-02-24 14:18:52', 123, 193, '60366e5ce57e9', NULL, NULL, NULL, 'in_complete', NULL, NULL, NULL, NULL, 'salon', '405.0'),
(17, '2021-03-17 14:51:25', '2021-03-17 14:51:25', 150, 193, '6052257d8f72b', NULL, NULL, NULL, 'in_complete', NULL, NULL, NULL, 1, 'salon', '0 R.S'),
(18, '2021-05-01 14:40:46', '2021-05-01 14:41:48', 123, 256, '608d848e0848d', 'cash', '2021-05-08', '7:40 PM', 'waiting', '24.82564247069454', '46.735870904444525', 'gg', NULL, 'salon', '405.0'),
(19, '2021-06-08 09:43:13', '2021-06-08 09:43:13', 123, 261, '60bf57d1348c8', NULL, NULL, NULL, 'in_complete', NULL, NULL, NULL, NULL, 'salon', '405.0');

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

--
-- Table structure for table `order_services`
--

CREATE TABLE `order_services` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `order_id` int(10) UNSIGNED DEFAULT NULL,
  `service_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_services`
--

INSERT INTO `order_services` (`id`, `created_at`, `updated_at`, `order_id`, `service_id`) VALUES
(5, '2020-12-31 16:55:28', '2020-12-31 16:55:28', 5, 70),
(6, '2021-01-01 20:56:52', '2021-01-01 20:56:52', 6, 70),
(7, '2021-01-01 20:57:14', '2021-01-01 20:57:14', 7, 70),
(8, '2021-01-01 20:58:53', '2021-01-01 20:58:53', 8, 70),
(10, '2021-01-08 20:02:39', '2021-01-08 20:02:39', 10, 71),
(11, '2021-01-10 13:44:18', '2021-01-10 13:44:18', 11, 70),
(12, '2021-01-10 13:46:46', '2021-01-10 13:46:46', 12, 70),
(13, '2021-01-20 19:48:39', '2021-01-20 19:48:39', 13, 70),
(14, '2021-02-12 20:58:24', '2021-02-12 20:58:24', 14, 70),
(15, '2021-02-22 15:07:30', '2021-02-22 15:07:30', 15, 70),
(16, '2021-02-24 14:18:52', '2021-02-24 14:18:52', 16, 70),
(17, '2021-05-01 14:40:46', '2021-05-01 14:40:46', 18, 70),
(18, '2021-06-08 09:43:13', '2021-06-08 09:43:13', 19, 70);

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

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

CREATE TABLE `packages` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `salon_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration_type` enum('days','months') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_percent` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `duration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `finish_date` date DEFAULT NULL,
  `place` enum('home','salon') COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `created_at`, `updated_at`, `salon_id`, `title`, `duration_type`, `price`, `discount_percent`, `description`, `duration`, `finish_date`, `place`) VALUES
(1, '2021-03-17 14:47:00', '2021-03-18 13:48:32', 150, 'new test package', 'days', '0', '100', '<anwthah.EditePackageVC: 0x1032fb800>', '10', '2021-03-28', 'salon');

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

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `salon_id` int(10) UNSIGNED NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `salons`
--

CREATE TABLE `salons` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `lat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lng` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('salon','freelance') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `always_open` enum('true','false') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receive_notifications` enum('true','false') COLLATE utf8mb4_unicode_ci DEFAULT 'true',
  `salon_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wallet` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city_id` int(10) UNSIGNED DEFAULT NULL,
  `rate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_counts` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salons`
--

INSERT INTO `salons` (`id`, `created_at`, `updated_at`, `user_id`, `lat`, `lng`, `type`, `details`, `address`, `always_open`, `receive_notifications`, `salon_title`, `image`, `wallet`, `city_id`, `rate`, `order_counts`) VALUES
(123, '2020-12-31 12:43:19', '2021-05-01 14:41:48', 184, NULL, NULL, 'salon', 'مركز بيوتي كوين خدمات تجميل منزلية', 'الرياض', 'true', 'true', 'بيوتي كوين', '532_1609429612.jpg', NULL, 6, NULL, 2),
(124, '2021-01-05 14:42:21', '2021-01-06 12:40:54', 188, NULL, NULL, 'freelance', 'الاخصائيه الجوهره ✨\nمعتمده دولياً من شركة ايڤرلاستنق البريطانيه\n لـ المايكروبليدينق+ المايكروبقمنتيشن🖊🤩\n(حواجب_شفايف)\nمعتمده دوليا من شركة ايوليت الامريكيه لـ رفع وصبغه الرموش والحواجب + تركيب الرموش .. ✨🤩', '0502874711', 'true', 'true', 'al.micro.art', '158_1609940454.jpg', NULL, 6, NULL, 0),
(125, '2021-01-05 17:52:09', '2021-01-05 18:07:06', 189, NULL, NULL, 'salon', 'صالون نسائي\nيوجد لدينا جميع الخدمات ماعاد المساج والحمام المغربي', 'السويدي /شبرا /شارع ال عباد', 'false', 'true', 'لمسات رغد للتزيين النسائي', NULL, NULL, 6, NULL, 0),
(126, '2021-01-05 20:01:10', '2021-01-10 22:52:13', 192, NULL, NULL, 'salon', 'السويدي الغربي   مخرح ٢٦ شارع الشيخ اسحاق بن عبدالرحمن', 'مشغل شعاع المشاغل 3707 الشيخ اسحاق بن عبدالرحمن بن حسن، الزهرة، الرياض 12987 056 828 0862 https://goo.gl/maps/D1hXDQy67ubxVQxAA', 'false', 'true', 'شعاع المشاغل', NULL, NULL, 6, NULL, 0),
(127, '2021-01-06 05:40:02', '2021-03-05 10:38:52', 194, NULL, NULL, 'salon', 'تساريح شعر استشوار بروتين صبغات قص ميك آب تنظيف بشرة بدكير منكير حلاوة شمع وجه بيرافين', 'السويدي حي الزهره شارع لبيد بن ربيعه', 'true', 'true', 'لغة الجمال للتزيين النسائي', '751_1611078870.jpg', NULL, 6, NULL, 0),
(132, '2021-01-10 16:36:46', '2021-01-10 17:25:47', 205, NULL, NULL, 'freelance', '0505254138', 'Riyadh-AlMalaz', 'true', 'true', 'MADAM RANA', NULL, NULL, 6, NULL, 0),
(134, '2021-01-12 20:02:11', '2021-01-12 20:03:42', 210, NULL, NULL, 'salon', 'مشغل', '456712', 'false', 'true', 'مشغل', NULL, NULL, 6, NULL, 0),
(135, '2021-01-13 20:32:08', '2021-01-14 18:18:40', 211, NULL, NULL, 'freelance', 'خدمات صالون منزلية \nHome services', 'الرياض', 'true', 'true', 'salon_labelle21', '780_1610575080.jpg', NULL, 6, NULL, 0),
(137, '2021-01-18 11:08:09', '2021-01-18 11:08:40', 215, NULL, NULL, 'freelance', 'T', 'f', 'false', 'true', 'yyy', NULL, NULL, 5, NULL, 0),
(138, '2021-01-18 11:29:10', '2021-01-18 11:31:00', 216, NULL, NULL, 'freelance', 'Ss', 'ass', 'false', 'true', 'er', NULL, NULL, 6, NULL, 0),
(139, '2021-01-28 14:27:12', '2021-01-28 14:29:16', 221, NULL, NULL, 'freelance', 'Add Text To Provider', 'riyadh', 'true', 'true', 'عاليه العتيبي', NULL, NULL, 6, NULL, 0),
(140, '2021-01-28 16:58:21', '2021-01-29 10:48:00', 222, NULL, NULL, 'freelance', 'Add Text To Provider', 'الرياض اليرموك', 'true', 'true', 'خلود ميكب ارتست', NULL, NULL, 6, NULL, 0),
(141, '2021-01-30 03:57:08', '2021-01-30 04:04:51', 225, NULL, NULL, 'freelance', 'خدمات منزليه متنوعه \nميك اب & هيرستايل & خدمات عنايه', 'الرياض وماحولها 0556838366', 'false', 'true', 'ريم للخدمات المنزليه', NULL, NULL, 6, NULL, 0),
(142, '2021-02-05 06:15:05', '2021-02-05 06:25:26', 227, NULL, NULL, 'salon', '0548527288', 'الاحساء', 'true', 'true', 'reem beauty', '528_1612509777.jpg', NULL, 11, NULL, 0),
(144, '2021-02-24 17:01:10', '2021-02-24 17:02:04', 232, NULL, NULL, 'freelance', 'Add Text To Provider', 'المدينة المنورة', 'true', 'true', NULL, NULL, NULL, 13, NULL, 0),
(145, '2021-02-28 17:55:16', '2021-02-28 18:01:43', 234, NULL, NULL, 'salon', 'Add Text To Provider', 'طريق عبدالرحمن الداخل', 'false', 'true', 'مشغل موضه لين', NULL, NULL, 6, NULL, 0),
(146, '2021-02-28 23:25:54', '2021-02-28 23:31:09', 235, NULL, NULL, 'salon', 'Add Text To Provider', 'https://maps.google.com/?q=24.783655,46.628429', 'false', 'true', 'مشغل نورة', NULL, NULL, 6, NULL, 0),
(149, '2021-03-17 13:53:39', '2021-03-17 13:57:30', 241, NULL, NULL, 'salon', 'new salon', 'new address', 'true', 'true', NULL, NULL, NULL, 9, NULL, 0),
(150, '2021-03-17 14:39:25', '2021-03-18 13:48:46', 242, NULL, NULL, 'freelance', 'Last salon', 'Seoul', 'false', 'true', 'mohab', '791_1616078885.jpg', NULL, 6, NULL, 0),
(151, '2021-03-18 13:25:07', '2021-03-18 13:38:21', 243, NULL, NULL, 'salon', 'qqqq', 'القيصومه', 'false', 'true', 'مشغل', '215_1616078301.jpg', NULL, 6, NULL, 0),
(152, '2021-03-18 13:45:08', '2021-03-18 13:45:36', 245, NULL, NULL, 'freelance', 'Ghj', 'hghhh', 'false', 'true', 'hjjj', NULL, NULL, 5, NULL, 0),
(153, '2021-03-18 14:00:55', '2021-03-18 14:01:45', 246, NULL, NULL, 'freelance', 'Rrr', 'qwe', 'false', 'true', 'mohamed mahrous', NULL, NULL, 5, NULL, 0),
(154, '2021-03-22 18:34:17', '2021-03-22 19:26:41', 247, NULL, NULL, 'freelance', 'Add Text To Provider', 'الرياض', 'true', 'true', 'bshayr hair', NULL, NULL, 6, NULL, 0),
(155, '2021-04-16 20:03:05', '2021-04-16 20:03:36', 252, NULL, NULL, 'salon', 'صالون تجميل', 'المروج', 'true', 'true', NULL, NULL, NULL, 6, NULL, 0);

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

--
-- Table structure for table `salon_accounts`
--

CREATE TABLE `salon_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `salon_id` int(10) UNSIGNED NOT NULL,
  `bank_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `salon_bank_transfers`
--

CREATE TABLE `salon_bank_transfers` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `salon_id` int(10) UNSIGNED NOT NULL,
  `amount` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('add','receive') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admin_approve` enum('wait','accept','refuse') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_id` int(10) UNSIGNED DEFAULT NULL,
  `parent_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `salon_categories`
--

CREATE TABLE `salon_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `salon_id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salon_categories`
--

INSERT INTO `salon_categories` (`id`, `created_at`, `updated_at`, `salon_id`, `category_id`) VALUES
(102, '2020-12-31 13:00:27', '2020-12-31 13:00:27', 123, 2),
(103, '2020-12-31 13:00:27', '2020-12-31 13:00:27', 123, 5),
(104, '2020-12-31 13:00:27', '2020-12-31 13:00:27', 123, 1),
(105, '2021-01-05 14:48:08', '2021-01-05 14:48:08', 124, 7),
(106, '2021-01-05 18:07:15', '2021-01-05 18:07:15', 125, 1),
(107, '2021-01-05 20:05:30', '2021-01-05 20:05:30', 126, 1),
(108, '2021-01-05 20:05:30', '2021-01-05 20:05:30', 126, 2),
(109, '2021-01-05 20:05:30', '2021-01-05 20:05:30', 126, 8),
(110, '2021-01-05 20:05:30', '2021-01-05 20:05:30', 126, 3),
(111, '2021-01-05 20:05:30', '2021-01-05 20:05:30', 126, 4),
(112, '2021-01-05 20:05:30', '2021-01-05 20:05:30', 126, 7),
(113, '2021-01-06 06:04:52', '2021-01-06 06:04:52', 127, 1),
(114, '2021-01-06 06:04:52', '2021-01-06 06:04:52', 127, 3),
(115, '2021-01-06 06:04:52', '2021-01-06 06:04:52', 127, 4),
(116, '2021-01-06 06:04:52', '2021-01-06 06:04:52', 127, 8),
(134, '2021-01-10 16:46:58', '2021-01-10 16:46:58', 132, 1),
(135, '2021-01-10 16:46:58', '2021-01-10 16:46:58', 132, 3),
(136, '2021-01-10 16:46:58', '2021-01-10 16:46:58', 132, 4),
(137, '2021-01-10 16:46:58', '2021-01-10 16:46:58', 132, 9),
(138, '2021-01-10 16:46:58', '2021-01-10 16:46:58', 132, 11),
(139, '2021-01-10 16:46:58', '2021-01-10 16:46:58', 132, 14),
(140, '2021-01-10 16:46:58', '2021-01-10 16:46:58', 132, 13),
(141, '2021-01-10 16:46:58', '2021-01-10 16:46:58', 132, 2),
(148, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 1),
(149, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 2),
(150, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 3),
(151, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 4),
(152, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 5),
(153, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 7),
(154, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 8),
(155, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 9),
(156, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 10),
(157, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 11),
(158, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 12),
(159, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 13),
(160, '2021-01-12 20:04:22', '2021-01-12 20:04:22', 134, 14),
(161, '2021-01-13 20:46:38', '2021-01-13 20:46:38', 135, 1),
(162, '2021-01-13 20:46:38', '2021-01-13 20:46:38', 135, 2),
(163, '2021-01-13 20:46:38', '2021-01-13 20:46:38', 135, 3),
(164, '2021-01-13 20:46:38', '2021-01-13 20:46:38', 135, 4),
(165, '2021-01-13 20:46:38', '2021-01-13 20:46:38', 135, 9),
(166, '2021-01-13 20:46:38', '2021-01-13 20:46:38', 135, 10),
(167, '2021-01-13 20:46:38', '2021-01-13 20:46:38', 135, 11),
(168, '2021-01-13 20:46:39', '2021-01-13 20:46:39', 135, 14),
(173, '2021-01-18 11:08:44', '2021-01-18 11:08:44', 137, 2),
(174, '2021-01-18 11:08:44', '2021-01-18 11:08:44', 137, 3),
(175, '2021-01-18 11:11:48', '2021-01-18 11:11:48', 137, 1),
(176, '2021-01-18 11:11:48', '2021-01-18 11:11:48', 137, 2),
(177, '2021-01-18 11:11:48', '2021-01-18 11:11:48', 137, 3),
(178, '2021-01-18 11:31:36', '2021-01-18 11:31:36', 138, 3),
(179, '2021-01-18 11:31:36', '2021-01-18 11:31:36', 138, 2),
(180, '2021-01-18 11:31:36', '2021-01-18 11:31:36', 138, 3),
(181, '2021-01-18 11:31:36', '2021-01-18 11:31:36', 138, 2),
(182, '2021-01-18 11:31:36', '2021-01-18 11:31:36', 138, 4),
(183, '2021-01-28 14:30:00', '2021-01-28 14:30:00', 139, 14),
(184, '2021-01-28 17:05:27', '2021-01-28 17:05:27', 140, 14),
(185, '2021-01-30 04:05:58', '2021-01-30 04:05:58', 141, 3),
(186, '2021-01-30 04:05:58', '2021-01-30 04:05:58', 141, 9),
(187, '2021-01-30 04:05:58', '2021-01-30 04:05:58', 141, 10),
(188, '2021-01-30 04:05:58', '2021-01-30 04:05:58', 141, 11),
(189, '2021-01-30 04:05:58', '2021-01-30 04:05:58', 141, 12),
(190, '2021-01-30 04:05:58', '2021-01-30 04:05:58', 141, 13),
(191, '2021-01-30 04:05:58', '2021-01-30 04:05:58', 141, 14),
(192, '2021-01-30 04:05:58', '2021-01-30 04:05:58', 141, 8),
(193, '2021-01-30 04:05:58', '2021-01-30 04:05:58', 141, 7),
(194, '2021-01-30 04:05:58', '2021-01-30 04:05:58', 141, 4),
(195, '2021-01-30 04:05:58', '2021-01-30 04:05:58', 141, 1),
(196, '2021-02-05 06:19:33', '2021-02-05 06:19:33', 142, 2),
(197, '2021-02-05 06:19:33', '2021-02-05 06:19:33', 142, 7),
(198, '2021-02-05 06:19:33', '2021-02-05 06:19:33', 142, 14),
(199, '2021-02-05 06:24:08', '2021-02-05 06:24:08', 142, 2),
(200, '2021-02-05 06:24:08', '2021-02-05 06:24:08', 142, 7),
(201, '2021-02-05 06:24:08', '2021-02-05 06:24:08', 142, 14),
(205, '2021-02-28 18:03:22', '2021-02-28 18:03:22', 145, 1),
(206, '2021-02-28 18:03:22', '2021-02-28 18:03:22', 145, 2),
(207, '2021-02-28 18:03:22', '2021-02-28 18:03:22', 145, 3),
(208, '2021-02-28 18:03:22', '2021-02-28 18:03:22', 145, 4),
(209, '2021-02-28 18:03:22', '2021-02-28 18:03:22', 145, 8),
(210, '2021-02-28 18:03:22', '2021-02-28 18:03:22', 145, 9),
(211, '2021-02-28 18:03:22', '2021-02-28 18:03:22', 145, 10),
(212, '2021-02-28 18:03:22', '2021-02-28 18:03:22', 145, 11),
(213, '2021-02-28 18:03:22', '2021-02-28 18:03:22', 145, 12),
(214, '2021-02-28 18:03:22', '2021-02-28 18:03:22', 145, 13),
(215, '2021-02-28 18:03:22', '2021-02-28 18:03:22', 145, 14),
(216, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 1),
(217, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 2),
(218, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 3),
(219, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 4),
(220, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 8),
(221, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 9),
(222, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 10),
(223, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 11),
(224, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 12),
(225, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 13),
(226, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 14),
(227, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 1),
(228, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 2),
(229, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 3),
(230, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 4),
(231, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 8),
(232, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 9),
(233, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 10),
(234, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 11),
(235, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 12),
(236, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 13),
(237, '2021-02-28 18:05:53', '2021-02-28 18:05:53', 145, 14),
(238, '2021-02-28 18:08:55', '2021-02-28 18:08:55', 145, 1),
(239, '2021-02-28 18:08:55', '2021-02-28 18:08:55', 145, 2),
(240, '2021-02-28 18:08:55', '2021-02-28 18:08:55', 145, 3),
(241, '2021-02-28 18:08:55', '2021-02-28 18:08:55', 145, 4),
(242, '2021-02-28 18:08:55', '2021-02-28 18:08:55', 145, 8),
(243, '2021-02-28 18:08:55', '2021-02-28 18:08:55', 145, 9),
(244, '2021-02-28 18:08:55', '2021-02-28 18:08:55', 145, 10),
(245, '2021-02-28 18:08:55', '2021-02-28 18:08:55', 145, 11),
(246, '2021-02-28 18:08:55', '2021-02-28 18:08:55', 145, 12),
(247, '2021-02-28 18:08:55', '2021-02-28 18:08:55', 145, 13),
(248, '2021-02-28 18:08:55', '2021-02-28 18:08:55', 145, 14),
(249, '2021-02-28 18:08:56', '2021-02-28 18:08:56', 145, 1),
(250, '2021-02-28 18:08:56', '2021-02-28 18:08:56', 145, 2),
(251, '2021-02-28 18:08:56', '2021-02-28 18:08:56', 145, 3),
(252, '2021-02-28 18:08:56', '2021-02-28 18:08:56', 145, 4),
(253, '2021-02-28 18:08:56', '2021-02-28 18:08:56', 145, 8),
(254, '2021-02-28 18:08:56', '2021-02-28 18:08:56', 145, 9),
(255, '2021-02-28 18:08:56', '2021-02-28 18:08:56', 145, 10),
(256, '2021-02-28 18:08:56', '2021-02-28 18:08:56', 145, 11),
(257, '2021-02-28 18:08:56', '2021-02-28 18:08:56', 145, 12),
(258, '2021-02-28 18:08:56', '2021-02-28 18:08:56', 145, 13),
(259, '2021-02-28 18:08:56', '2021-02-28 18:08:56', 145, 14),
(260, '2021-02-28 18:16:51', '2021-02-28 18:16:51', 145, 1),
(261, '2021-02-28 18:16:51', '2021-02-28 18:16:51', 145, 2),
(262, '2021-02-28 18:16:51', '2021-02-28 18:16:51', 145, 3),
(263, '2021-02-28 18:16:51', '2021-02-28 18:16:51', 145, 4),
(264, '2021-02-28 18:16:51', '2021-02-28 18:16:51', 145, 8),
(265, '2021-02-28 18:16:51', '2021-02-28 18:16:51', 145, 9),
(266, '2021-02-28 18:16:51', '2021-02-28 18:16:51', 145, 10),
(267, '2021-02-28 18:16:51', '2021-02-28 18:16:51', 145, 11),
(268, '2021-02-28 18:16:51', '2021-02-28 18:16:51', 145, 12),
(269, '2021-02-28 18:16:51', '2021-02-28 18:16:51', 145, 13),
(270, '2021-02-28 18:16:51', '2021-02-28 18:16:51', 145, 14),
(271, '2021-02-28 18:16:53', '2021-02-28 18:16:53', 145, 1),
(272, '2021-02-28 18:16:53', '2021-02-28 18:16:53', 145, 2),
(273, '2021-02-28 18:16:53', '2021-02-28 18:16:53', 145, 3),
(274, '2021-02-28 18:16:53', '2021-02-28 18:16:53', 145, 4),
(275, '2021-02-28 18:16:53', '2021-02-28 18:16:53', 145, 8),
(276, '2021-02-28 18:16:53', '2021-02-28 18:16:53', 145, 9),
(277, '2021-02-28 18:16:53', '2021-02-28 18:16:53', 145, 10),
(278, '2021-02-28 18:16:53', '2021-02-28 18:16:53', 145, 11),
(279, '2021-02-28 18:16:53', '2021-02-28 18:16:53', 145, 12),
(280, '2021-02-28 18:16:53', '2021-02-28 18:16:53', 145, 13),
(281, '2021-02-28 18:16:53', '2021-02-28 18:16:53', 145, 14),
(282, '2021-02-28 18:17:12', '2021-02-28 18:17:12', 145, 1),
(283, '2021-02-28 18:17:12', '2021-02-28 18:17:12', 145, 2),
(284, '2021-02-28 18:17:12', '2021-02-28 18:17:12', 145, 3),
(285, '2021-02-28 18:17:12', '2021-02-28 18:17:12', 145, 4),
(286, '2021-02-28 18:17:12', '2021-02-28 18:17:12', 145, 8),
(287, '2021-02-28 18:17:12', '2021-02-28 18:17:12', 145, 9),
(288, '2021-02-28 18:17:12', '2021-02-28 18:17:12', 145, 10),
(289, '2021-02-28 18:17:12', '2021-02-28 18:17:12', 145, 11),
(290, '2021-02-28 18:17:12', '2021-02-28 18:17:12', 145, 12),
(291, '2021-02-28 18:17:12', '2021-02-28 18:17:12', 145, 13),
(292, '2021-02-28 18:17:12', '2021-02-28 18:17:12', 145, 14),
(293, '2021-02-28 18:17:25', '2021-02-28 18:17:25', 145, 1),
(294, '2021-02-28 18:17:25', '2021-02-28 18:17:25', 145, 2),
(295, '2021-02-28 18:17:25', '2021-02-28 18:17:25', 145, 3),
(296, '2021-02-28 18:17:25', '2021-02-28 18:17:25', 145, 4),
(297, '2021-02-28 18:17:25', '2021-02-28 18:17:25', 145, 8),
(298, '2021-02-28 18:17:25', '2021-02-28 18:17:25', 145, 9),
(299, '2021-02-28 18:17:25', '2021-02-28 18:17:25', 145, 10),
(300, '2021-02-28 18:17:25', '2021-02-28 18:17:25', 145, 11),
(301, '2021-02-28 18:17:25', '2021-02-28 18:17:25', 145, 12),
(302, '2021-02-28 18:17:25', '2021-02-28 18:17:25', 145, 13),
(303, '2021-02-28 18:17:25', '2021-02-28 18:17:25', 145, 14),
(304, '2021-02-28 18:18:16', '2021-02-28 18:18:16', 145, 1),
(305, '2021-02-28 18:18:16', '2021-02-28 18:18:16', 145, 2),
(306, '2021-02-28 18:18:16', '2021-02-28 18:18:16', 145, 3),
(307, '2021-02-28 18:18:16', '2021-02-28 18:18:16', 145, 4),
(308, '2021-02-28 18:18:16', '2021-02-28 18:18:16', 145, 8),
(309, '2021-02-28 18:18:16', '2021-02-28 18:18:16', 145, 9),
(310, '2021-02-28 18:18:16', '2021-02-28 18:18:16', 145, 10),
(311, '2021-02-28 18:18:16', '2021-02-28 18:18:16', 145, 11),
(312, '2021-02-28 18:18:16', '2021-02-28 18:18:16', 145, 12),
(313, '2021-02-28 18:18:16', '2021-02-28 18:18:16', 145, 13),
(314, '2021-02-28 18:18:16', '2021-02-28 18:18:16', 145, 14),
(315, '2021-02-28 18:18:22', '2021-02-28 18:18:22', 145, 1),
(316, '2021-02-28 18:18:22', '2021-02-28 18:18:22', 145, 2),
(317, '2021-02-28 18:18:22', '2021-02-28 18:18:22', 145, 3),
(318, '2021-02-28 18:18:22', '2021-02-28 18:18:22', 145, 4),
(319, '2021-02-28 18:18:22', '2021-02-28 18:18:22', 145, 8),
(320, '2021-02-28 18:18:22', '2021-02-28 18:18:22', 145, 9),
(321, '2021-02-28 18:18:22', '2021-02-28 18:18:22', 145, 10),
(322, '2021-02-28 18:18:22', '2021-02-28 18:18:22', 145, 11),
(323, '2021-02-28 18:18:22', '2021-02-28 18:18:22', 145, 12),
(324, '2021-02-28 18:18:22', '2021-02-28 18:18:22', 145, 13),
(325, '2021-02-28 18:18:22', '2021-02-28 18:18:22', 145, 14),
(326, '2021-02-28 18:19:24', '2021-02-28 18:19:24', 145, 1),
(327, '2021-02-28 18:19:24', '2021-02-28 18:19:24', 145, 2),
(328, '2021-02-28 18:19:24', '2021-02-28 18:19:24', 145, 3),
(329, '2021-02-28 18:19:24', '2021-02-28 18:19:24', 145, 4),
(330, '2021-02-28 18:19:24', '2021-02-28 18:19:24', 145, 8),
(331, '2021-02-28 18:19:24', '2021-02-28 18:19:24', 145, 9),
(332, '2021-02-28 18:19:24', '2021-02-28 18:19:24', 145, 10),
(333, '2021-02-28 18:19:24', '2021-02-28 18:19:24', 145, 11),
(334, '2021-02-28 18:19:24', '2021-02-28 18:19:24', 145, 12),
(335, '2021-02-28 18:19:24', '2021-02-28 18:19:24', 145, 13),
(336, '2021-02-28 18:19:24', '2021-02-28 18:19:24', 145, 14),
(337, '2021-02-28 23:31:34', '2021-02-28 23:31:34', 146, 1),
(338, '2021-02-28 23:31:34', '2021-02-28 23:31:34', 146, 2),
(339, '2021-02-28 23:31:34', '2021-02-28 23:31:34', 146, 3),
(340, '2021-02-28 23:31:34', '2021-02-28 23:31:34', 146, 4),
(341, '2021-02-28 23:31:34', '2021-02-28 23:31:34', 146, 9),
(342, '2021-02-28 23:31:34', '2021-02-28 23:31:34', 146, 10),
(343, '2021-02-28 23:31:34', '2021-02-28 23:31:34', 146, 11),
(344, '2021-02-28 23:31:34', '2021-02-28 23:31:34', 146, 12),
(345, '2021-02-28 23:31:34', '2021-02-28 23:31:34', 146, 13),
(346, '2021-02-28 23:31:34', '2021-02-28 23:31:34', 146, 14),
(364, '2021-03-17 14:40:17', '2021-03-17 14:40:17', 150, 2),
(365, '2021-03-17 14:40:17', '2021-03-17 14:40:17', 150, 1),
(366, '2021-03-17 14:40:17', '2021-03-17 14:40:17', 150, 3),
(367, '2021-03-17 14:40:17', '2021-03-17 14:40:17', 150, 4),
(368, '2021-03-17 14:40:17', '2021-03-17 14:40:17', 150, 5),
(369, '2021-03-17 14:40:17', '2021-03-17 14:40:17', 150, 13),
(370, '2021-03-17 14:40:17', '2021-03-17 14:40:17', 150, 12),
(371, '2021-03-18 13:26:15', '2021-03-18 13:26:15', 151, 1),
(372, '2021-03-18 13:26:15', '2021-03-18 13:26:15', 151, 2),
(373, '2021-03-18 13:26:15', '2021-03-18 13:26:15', 151, 3),
(374, '2021-03-18 13:26:15', '2021-03-18 13:26:15', 151, 4),
(375, '2021-03-18 13:26:15', '2021-03-18 13:26:15', 151, 5),
(376, '2021-03-18 13:26:15', '2021-03-18 13:26:15', 151, 8),
(377, '2021-03-18 13:26:15', '2021-03-18 13:26:15', 151, 9),
(378, '2021-03-18 13:26:15', '2021-03-18 13:26:15', 151, 10),
(379, '2021-03-18 13:26:15', '2021-03-18 13:26:15', 151, 11),
(380, '2021-03-18 13:26:15', '2021-03-18 13:26:15', 151, 12),
(381, '2021-03-18 13:45:39', '2021-03-18 13:45:39', 152, 1),
(382, '2021-03-18 14:01:50', '2021-03-18 14:01:50', 153, 1),
(383, '2021-03-22 19:27:08', '2021-03-22 19:27:08', 154, 4),
(384, '2021-03-22 19:27:08', '2021-03-22 19:27:08', 154, 1),
(385, '2021-03-22 19:27:08', '2021-03-22 19:27:08', 154, 2);

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

--
-- Table structure for table `salon_comments`
--

CREATE TABLE `salon_comments` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `salon_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `rate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salon_comments`
--

INSERT INTO `salon_comments` (`id`, `created_at`, `updated_at`, `salon_id`, `user_id`, `rate`, `comment`, `order_id`) VALUES
(1, NULL, NULL, 151, 194, '5', 'nice', NULL);

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

--
-- Table structure for table `salon_images`
--

CREATE TABLE `salon_images` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `salon_id` int(10) UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salon_images`
--

INSERT INTO `salon_images` (`id`, `created_at`, `updated_at`, `salon_id`, `image`) VALUES
(194, '2020-12-31 14:46:52', '2020-12-31 14:46:52', 123, '436_1609429612.jpg'),
(195, '2020-12-31 14:46:52', '2020-12-31 14:46:52', 123, '222_1609429612.jpg'),
(196, '2020-12-31 14:46:52', '2020-12-31 14:46:52', 123, '588_1609429612.jpg'),
(197, '2020-12-31 14:46:52', '2020-12-31 14:46:52', 123, '547_1609429612.jpg'),
(198, '2020-12-31 14:46:52', '2020-12-31 14:46:52', 123, '720_1609429612.jpg'),
(199, '2020-12-31 14:46:52', '2020-12-31 14:46:52', 123, '208_1609429612.jpg'),
(200, '2020-12-31 14:46:52', '2020-12-31 14:46:52', 123, '297_1609429612.jpg'),
(206, '2021-01-05 18:07:06', '2021-01-05 18:07:06', 125, '167_1609873626.jpg'),
(207, '2021-01-05 18:07:06', '2021-01-05 18:07:06', 125, '808_1609873626.jpg'),
(208, '2021-01-05 18:07:06', '2021-01-05 18:07:06', 125, '239_1609873626.jpg'),
(209, '2021-01-05 18:07:06', '2021-01-05 18:07:06', 125, '814_1609873626.jpg'),
(210, '2021-01-05 18:07:06', '2021-01-05 18:07:06', 125, '129_1609873626.jpg'),
(211, '2021-01-05 18:07:06', '2021-01-05 18:07:06', 125, '908_1609873626.jpg'),
(212, '2021-01-05 18:07:06', '2021-01-05 18:07:06', 125, '419_1609873626.jpg'),
(213, '2021-01-05 18:07:06', '2021-01-05 18:07:06', 125, '892_1609873626.jpg'),
(214, '2021-01-05 18:07:06', '2021-01-05 18:07:06', 125, '521_1609873626.jpg'),
(215, '2021-01-05 18:07:06', '2021-01-05 18:07:06', 125, '505_1609873626.jpg'),
(216, '2021-01-05 20:04:57', '2021-01-05 20:04:57', 126, '639_1609880697.jpg'),
(224, '2021-01-06 12:40:54', '2021-01-06 12:40:54', 124, '716_1609940454.jpg'),
(225, '2021-01-06 12:40:54', '2021-01-06 12:40:54', 124, '791_1609940454.jpg'),
(226, '2021-01-06 12:40:54', '2021-01-06 12:40:54', 124, '759_1609940454.jpg'),
(227, '2021-01-06 12:40:54', '2021-01-06 12:40:54', 124, '743_1609940454.jpg'),
(228, '2021-01-06 12:40:54', '2021-01-06 12:40:54', 124, '660_1609940454.jpg'),
(229, '2021-01-06 12:40:54', '2021-01-06 12:40:54', 124, '936_1609940454.jpg'),
(230, '2021-01-06 12:40:54', '2021-01-06 12:40:54', 124, '314_1609940454.jpg'),
(240, '2021-01-10 16:46:21', '2021-01-10 16:46:21', 132, '286_1610300781.jpg'),
(241, '2021-01-10 16:46:21', '2021-01-10 16:46:21', 132, '769_1610300781.jpg'),
(242, '2021-01-10 16:46:21', '2021-01-10 16:46:21', 132, '238_1610300781.jpg'),
(245, '2021-01-12 20:03:43', '2021-01-12 20:03:43', 134, '403_1610485422.jpg'),
(263, '2021-01-13 20:58:00', '2021-01-13 20:58:00', 135, '201_1610575080.jpg'),
(264, '2021-01-13 20:58:00', '2021-01-13 20:58:00', 135, '336_1610575080.jpg'),
(265, '2021-01-13 20:58:00', '2021-01-13 20:58:00', 135, '341_1610575080.jpg'),
(266, '2021-01-13 20:58:00', '2021-01-13 20:58:00', 135, '422_1610575080.jpg'),
(267, '2021-01-13 20:58:00', '2021-01-13 20:58:00', 135, '233_1610575080.jpg'),
(268, '2021-01-13 20:58:00', '2021-01-13 20:58:00', 135, '726_1610575080.jpg'),
(269, '2021-01-13 20:58:00', '2021-01-13 20:58:00', 135, '432_1610575080.jpg'),
(270, '2021-01-13 20:58:00', '2021-01-13 20:58:00', 135, '508_1610575080.jpg'),
(271, '2021-01-13 20:58:00', '2021-01-13 20:58:00', 135, '331_1610575080.jpg'),
(272, '2021-01-13 20:58:00', '2021-01-13 20:58:00', 135, '281_1610575080.jpg'),
(282, '2021-01-18 11:08:40', '2021-01-18 11:08:40', 137, '603_1610971720.jpg'),
(283, '2021-01-18 11:31:00', '2021-01-18 11:31:00', 138, '457_1610973060.jpg'),
(284, '2021-01-18 11:31:24', '2021-01-18 11:31:24', 138, '736_1610973084.jpg'),
(285, '2021-01-19 16:54:30', '2021-01-19 16:54:30', 127, '599_1611078870.png'),
(286, '2021-01-19 16:54:30', '2021-01-19 16:54:30', 127, '979_1611078870.jpg'),
(287, '2021-01-19 16:54:30', '2021-01-19 16:54:30', 127, '847_1611078870.jpg'),
(288, '2021-01-19 16:54:30', '2021-01-19 16:54:30', 127, '873_1611078870.jpg'),
(289, '2021-01-28 14:29:16', '2021-01-28 14:29:16', 139, '399_1611847756.jpg'),
(290, '2021-01-28 14:29:16', '2021-01-28 14:29:16', 139, '997_1611847756.jpg'),
(291, '2021-01-28 14:29:16', '2021-01-28 14:29:16', 139, '617_1611847756.jpg'),
(292, '2021-01-28 14:29:16', '2021-01-28 14:29:16', 139, '361_1611847756.jpg'),
(293, '2021-01-28 17:05:14', '2021-01-28 17:05:14', 140, '624_1611857114.jpg'),
(294, '2021-01-30 04:04:51', '2021-01-30 04:04:51', 141, '727_1611983091.jpg'),
(295, '2021-01-30 04:04:51', '2021-01-30 04:04:51', 141, '552_1611983091.jpg'),
(296, '2021-01-30 04:04:51', '2021-01-30 04:04:51', 141, '975_1611983091.jpg'),
(297, '2021-01-30 04:04:51', '2021-01-30 04:04:51', 141, '949_1611983091.jpg'),
(298, '2021-01-30 04:04:51', '2021-01-30 04:04:51', 141, '379_1611983091.jpg'),
(299, '2021-01-30 04:04:51', '2021-01-30 04:04:51', 141, '252_1611983091.jpg'),
(300, '2021-01-30 04:04:51', '2021-01-30 04:04:51', 141, '453_1611983091.jpg'),
(301, '2021-01-30 04:04:51', '2021-01-30 04:04:51', 141, '847_1611983091.jpg'),
(302, '2021-01-30 04:04:51', '2021-01-30 04:04:51', 141, '866_1611983091.jpg'),
(303, '2021-01-30 04:04:51', '2021-01-30 04:04:51', 141, '847_1611983091.jpg'),
(304, '2021-01-30 04:04:51', '2021-01-30 04:04:51', 141, '189_1611983091.jpg'),
(305, '2021-01-30 04:04:51', '2021-01-30 04:04:51', 141, '290_1611983091.jpg'),
(308, '2021-02-05 06:22:57', '2021-02-05 06:22:57', 142, '851_1612509777.jpg'),
(309, '2021-02-05 06:22:57', '2021-02-05 06:22:57', 142, '909_1612509777.jpg'),
(313, '2021-02-28 18:01:43', '2021-02-28 18:01:43', 145, '531_1614538903.jpg'),
(314, '2021-02-28 18:01:43', '2021-02-28 18:01:43', 145, '852_1614538903.jpg'),
(315, '2021-02-28 18:03:00', '2021-02-28 18:03:00', 145, '704_1614538980.jpg'),
(316, '2021-02-28 18:03:00', '2021-02-28 18:03:00', 145, '166_1614538980.jpg'),
(317, '2021-02-28 23:31:09', '2021-02-28 23:31:09', 146, '675_1614558669.jpg'),
(318, '2021-02-28 23:31:09', '2021-02-28 23:31:09', 146, '996_1614558669.jpg'),
(319, '2021-02-28 23:31:09', '2021-02-28 23:31:09', 146, '751_1614558669.jpg'),
(320, '2021-02-28 23:31:09', '2021-02-28 23:31:09', 146, '588_1614558669.jpg'),
(321, '2021-02-28 23:31:09', '2021-02-28 23:31:09', 146, '870_1614558669.jpg'),
(322, '2021-02-28 23:31:09', '2021-02-28 23:31:09', 146, '234_1614558669.jpg'),
(323, '2021-02-28 23:31:09', '2021-02-28 23:31:09', 146, '830_1614558669.jpg'),
(324, '2021-02-28 23:31:09', '2021-02-28 23:31:09', 146, '554_1614558669.jpg'),
(325, '2021-02-28 23:31:09', '2021-02-28 23:31:09', 146, '473_1614558669.jpg'),
(326, '2021-02-28 23:31:09', '2021-02-28 23:31:09', 146, '229_1614558669.jpg'),
(327, '2021-02-28 23:31:09', '2021-02-28 23:31:09', 146, '900_1614558669.jpg'),
(348, '2021-03-18 13:38:21', '2021-03-18 13:38:21', 151, '792_1616078301.jpg'),
(349, '2021-03-18 13:45:36', '2021-03-18 13:45:36', 152, '542_1616078736.jpg'),
(350, '2021-03-18 13:48:05', '2021-03-18 13:48:05', 150, '858_1616078885.jpg'),
(351, '2021-03-18 14:01:45', '2021-03-18 14:01:45', 153, '683_1616079705.jpg'),
(352, '2021-03-18 14:01:45', '2021-03-18 14:01:45', 153, '422_1616079705.jpg'),
(353, '2021-03-22 19:26:41', '2021-03-22 19:26:41', 154, '296_1616444801.jpg'),
(354, '2021-03-22 19:26:41', '2021-03-22 19:26:41', 154, '704_1616444801.jpg'),
(355, '2021-03-22 19:26:41', '2021-03-22 19:26:41', 154, '205_1616444801.jpg');

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

--
-- Table structure for table `salon_times`
--

CREATE TABLE `salon_times` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `salon_id` int(10) UNSIGNED NOT NULL,
  `day` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `open_status` enum('open','close') COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salon_times`
--

INSERT INTO `salon_times` (`id`, `created_at`, `updated_at`, `salon_id`, `day`, `from`, `to`, `open_status`) VALUES
(6, '2020-12-31 14:50:53', '2020-12-31 14:50:53', 123, 'السبت', '09:00', '20:00', 'open'),
(7, '2021-01-05 17:55:19', '2021-01-05 17:55:19', 125, 'السبت', '1:0PM', '9:30PM', 'open'),
(8, '2021-01-05 17:56:00', '2021-01-05 17:56:00', 125, 'الأحد', '1:0PM', '9:30PM', 'open'),
(9, '2021-01-05 17:56:58', '2021-01-05 17:56:58', 125, 'الاربعاء', '1:0PM', '9:30PM', 'open'),
(10, '2021-01-05 17:57:01', '2021-01-05 17:57:01', 125, 'الثلاثاء', '1:1PM', '9:30PM', 'open'),
(11, '2021-01-05 17:57:30', '2021-01-05 17:57:30', 125, 'الخميس', '1:0PM', '9:30PM', 'open'),
(12, '2021-01-05 17:57:45', '2021-01-05 17:57:45', 125, 'الجمعة', '1:0PM', '9:30PM', 'open'),
(13, '2021-01-06 05:53:58', '2021-01-06 05:53:58', 127, 'الجمعة', '12:0PM', '10:0PM', 'open'),
(14, '2021-01-06 05:54:08', '2021-01-06 05:54:08', 127, 'الجمعة', '12:0PM', '10:0PM', 'open'),
(15, '2021-01-08 21:09:59', '2021-01-08 21:09:59', 127, 'السبت', '12:0PM', '10:0PM', 'open'),
(16, '2021-01-08 21:10:49', '2021-01-08 21:10:49', 127, 'الأحد', '12:0PM', '10:0PM', 'open'),
(17, '2021-01-08 21:11:27', '2021-01-08 21:11:27', 127, 'الإثنين', '12:0PM', '10:0PM', 'open'),
(18, '2021-01-08 21:12:29', '2021-01-08 21:12:29', 127, 'الثلاثاء', '12:0PM', '10:0PM', 'open'),
(19, '2021-01-08 21:13:00', '2021-01-08 21:13:00', 127, 'الاربعاء', '12:0PM', '10:0PM', 'open'),
(20, '2021-01-08 21:13:32', '2021-01-08 21:13:32', 127, 'الخميس', '12:0PM', '10:0PM', 'open'),
(21, '2021-01-08 21:14:02', '2021-01-08 21:14:02', 127, 'الجمعة', '12:0PM', '10:0PM', 'open'),
(22, '2021-01-08 21:14:20', '2021-01-08 21:14:20', 127, 'الجمعة', '12:0PM', '10:0PM', 'open'),
(23, '2021-01-08 21:14:22', '2021-01-08 21:14:22', 127, 'الخميس', '12:0PM', '10:0PM', 'open'),
(24, '2021-01-08 21:14:25', '2021-01-08 21:14:25', 127, 'الاربعاء', '12:0PM', '10:0PM', 'open'),
(25, '2021-01-08 21:14:27', '2021-01-08 21:14:27', 127, 'الثلاثاء', '12:0PM', '10:0PM', 'open'),
(26, '2021-01-08 21:14:30', '2021-01-08 21:14:30', 127, 'الإثنين', '12:0PM', '10:0PM', 'open'),
(27, '2021-01-08 21:14:31', '2021-01-08 21:14:31', 127, 'الأحد', '12:0PM', '10:0PM', 'open'),
(28, '2021-01-08 21:14:33', '2021-01-08 21:14:33', 127, 'السبت', '12:0PM', '10:0PM', 'open'),
(29, '2021-01-10 22:51:02', '2021-01-10 22:51:02', 126, 'السبت', '12:00', '22:00', 'open'),
(30, '2021-01-12 20:05:19', '2021-01-12 20:05:19', 134, 'السبت', '22:58', '18:05', 'open'),
(31, '2021-01-13 20:35:50', '2021-01-13 20:35:50', 135, 'السبت', '10:0AM', '9:00 AM', 'open'),
(32, '2021-01-13 20:35:53', '2021-01-13 20:35:53', 135, 'الأحد', '10:0AM', '9:00 AM', 'open'),
(33, '2021-01-13 20:35:56', '2021-01-13 20:35:56', 135, 'الإثنين', '10:0AM', '9:00 AM', 'open'),
(34, '2021-01-13 20:36:05', '2021-01-13 20:36:05', 135, 'الثلاثاء', '10:0AM', '9:00 AM', 'open'),
(35, '2021-01-13 20:36:32', '2021-01-13 20:36:32', 135, 'الاربعاء', '10:0AM', '9:00 AM', 'open'),
(36, '2021-01-13 20:36:41', '2021-01-13 20:36:41', 135, 'الخميس', '10:0AM', '9:00 AM', 'open'),
(37, '2021-01-13 20:36:51', '2021-01-13 20:36:51', 135, 'الجمعة', '10:0AM', '9:00 AM', 'open'),
(38, '2021-01-13 20:37:01', '2021-01-13 20:37:01', 135, 'الجمعة', '10:0AM', '9:00 AM', 'open'),
(39, '2021-01-13 20:37:03', '2021-01-13 20:37:03', 135, 'الخميس', '10:0AM', '9:00 AM', 'open'),
(40, '2021-01-13 20:37:04', '2021-01-13 20:37:04', 135, 'الاربعاء', '10:0AM', '9:00 AM', 'open'),
(41, '2021-01-13 20:37:05', '2021-01-13 20:37:05', 135, 'الثلاثاء', '10:0AM', '9:00 AM', 'open'),
(42, '2021-01-13 20:37:07', '2021-01-13 20:37:07', 135, 'الإثنين', '10:0AM', '9:00 AM', 'open'),
(43, '2021-01-13 20:37:09', '2021-01-13 20:37:09', 135, 'الأحد', '10:0AM', '9:00 AM', 'open'),
(44, '2021-01-13 20:37:11', '2021-01-13 20:37:11', 135, 'السبت', '10:0AM', '9:00 AM', 'open'),
(46, '2021-01-29 10:43:36', '2021-01-29 10:43:36', 140, 'السبت', '12:00', '20:00', 'open'),
(47, '2021-01-29 10:44:17', '2021-01-29 10:44:17', 140, 'الاحد', '12:00', '20:00', 'open'),
(48, '2021-01-29 10:45:33', '2021-01-29 10:45:33', 140, 'الثلاث', '12:00', '20:00', 'open'),
(49, '2021-01-29 10:45:36', '2021-01-29 10:45:36', 140, 'الاتنين', '12:00', '20:00', 'open'),
(50, '2021-01-29 10:46:25', '2021-01-29 10:46:25', 140, 'الاربعاء', '12:00', '12:00', 'open'),
(51, '2021-01-29 10:47:14', '2021-01-29 10:47:14', 140, 'الاربعاء', '12:00', '12:00', 'open'),
(52, '2021-02-28 23:27:14', '2021-02-28 23:27:14', 146, 'السبت', '11:00', '23:00', 'open');

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

--
-- Table structure for table `sa_cities`
--

CREATE TABLE `sa_cities` (
  `id` int(11) NOT NULL,
  `nameAr` varchar(32) NOT NULL,
  `nameEn` varchar(32) NOT NULL,
  `provinceId` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='SA cities';

--
-- Dumping data for table `sa_cities`
--

INSERT INTO `sa_cities` (`id`, `nameAr`, `nameEn`, `provinceId`) VALUES
(1, 'تبوك', 'Tabuk', 3),
(3, 'الرياض', 'Riyadh', 6),
(5, 'الطائف', 'At Taif', 11),
(6, 'مكة المكرمة', 'Makkah Al Mukarramah', 11),
(10, 'حائل', 'Hail', 4),
(11, 'بريدة', 'Buraydah', 5),
(12, 'الهفوف', 'Al Hufuf', 13),
(13, 'الدمام', 'Ad Dammam', 13),
(14, 'المدينة المنورة', 'Al Madinah Al Munawwarah', 7),
(15, 'ابها', 'Abha', 8),
(17, 'جازان', 'Jazan', 10),
(18, 'جدة', 'Jeddah', 11),
(24, 'المجمعة', 'Al Majmaah', 6),
(31, 'الخبر', 'Al Khubar', 13),
(47, 'حفر الباطن', 'Hafar Al Batin', 13),
(62, 'خميس مشيط', 'Khamis Mushayt', 8),
(65, 'احد رفيده', 'Ahad Rifaydah', 8),
(67, 'القطيف', 'Al Qatif', 13),
(80, 'عنيزة', 'Unayzah', 5),
(89, 'قرية العليا', 'Qaryat Al Ulya', 13),
(113, 'الجبيل', 'Al Jubail', 13),
(115, 'النعيرية', 'An Nuayriyah', 13),
(227, 'الظهران', 'Dhahran', 13),
(233, 'الوجه', 'Al Wajh', 3),
(243, 'بقيق', 'Buqayq', 13),
(270, 'الزلفي', 'Az Zulfi', 6),
(288, 'خيبر', 'Khaybar', 7),
(306, 'الغاط', 'Al Ghat', 6),
(323, 'املج', 'Umluj', 3),
(377, 'رابغ', 'Rabigh', 11),
(418, 'عفيف', 'Afif', 6),
(443, 'ثادق', 'Thadiq', 6),
(454, 'سيهات', 'Sayhat', 13),
(456, 'تاروت', 'Tarut', 13),
(483, 'ينبع', 'Yanbu', 7),
(500, 'شقراء', 'Shaqra', 6),
(669, 'الدوادمي', 'Ad Duwadimi', 6),
(828, 'الدرعية', 'Ad Diriyah', 6),
(880, 'القويعية', 'Quwayiyah', 6),
(990, 'المزاحمية', 'Al Muzahimiyah', 6),
(1053, 'بدر', 'Badr', 7),
(1061, 'الخرج', 'Al Kharj', 6),
(1073, 'الدلم', 'Ad Dilam', 6),
(1228, 'الشنان', 'Ash Shinan', 4),
(1248, 'الخرمة', 'Al Khurmah', 11),
(1257, 'الجموم', 'Al Jumum', 11),
(1294, 'المجاردة', 'Al Majardah', 8),
(1361, 'السليل', 'As Sulayyil', 6),
(1443, 'تثليث', 'Tathilith', 8),
(1514, 'بيشة', 'Bishah', 8),
(1542, 'الباحة', 'Al Baha', 9),
(1625, 'القنفذة', 'Al Qunfidhah', 11),
(1801, 'محايل', 'Muhayil', 8),
(1879, 'ثول', 'Thuwal', 11),
(1947, 'ضبا', 'Duba', 3),
(2156, 'تربه', 'Turbah', 11),
(2167, 'صفوى', 'Safwa', 13),
(2171, 'عنك', 'Inak', 13),
(2208, 'طريف', 'Turaif', 1),
(2213, 'عرعر', 'Arar', 1),
(2226, 'القريات', 'Al Qurayyat', 2),
(2237, 'سكاكا', 'Sakaka', 2),
(2256, 'رفحاء', 'Rafha', 1),
(2268, 'دومة الجندل', 'Dawmat Al Jandal', 2),
(2421, 'الرس', 'Ar Rass', 5),
(2448, 'المذنب', 'Al Midhnab', 5),
(2464, 'الخفجي', 'Al Khafji', 13),
(2467, 'رياض الخبراء', 'Riyad Al Khabra', 5),
(2481, 'البدائع', 'Al Badai', 5),
(2590, 'رأس تنورة', 'Ras Tannurah', 13),
(2630, 'البكيرية', 'Al Bukayriyah', 5),
(2777, 'الشماسية', 'Ash Shimasiyah', 5),
(3158, 'الحريق', 'Al Hariq', 6),
(3161, 'حوطة بني تميم', 'Hawtat Bani Tamim', 6),
(3174, 'ليلى', 'Layla', 6),
(3275, 'بللسمر', 'Billasmar', 8),
(3347, 'شرورة', 'Sharurah', 12),
(3417, 'نجران', 'Najran', 12),
(3479, 'صبيا', 'Sabya', 10),
(3525, 'ابو عريش', 'Abu Arish', 10),
(3542, 'صامطة', 'Samtah', 10),
(3652, 'احد المسارحة', 'Ahad Al Musarihah', 10),
(3666, 'مدينة الملك عبدالله الاقتصادية', 'King Abdullah Economic City', 11);

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

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

CREATE TABLE `services` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_percent` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` int(10) UNSIGNED NOT NULL,
  `salon_id` int(10) UNSIGNED NOT NULL,
  `place` enum('salon','home') COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `services` (`id`, `created_at`, `updated_at`, `title`, `duration`, `price`, `discount_percent`, `image`, `category_id`, `salon_id`, `place`) VALUES
(70, '2020-12-31 14:44:31', '2020-12-31 14:44:31', 'حمام مغربي+مساج+بدكير ومناكير', '180', '450', '10', NULL, 2, 123, 'salon'),
(71, '2021-01-06 12:32:51', '2021-01-06 12:32:51', 'مايكروبليدنق', '90', '800', '10', NULL, 7, 124, 'salon'),
(72, '2021-01-06 12:33:38', '2021-01-06 12:33:38', 'مايكروشيدنق', '120', '1300', '10', NULL, 7, 124, 'salon'),
(73, '2021-01-06 12:34:00', '2021-01-06 12:34:00', 'شادو', '90', '800', '10', NULL, 7, 124, 'salon'),
(74, '2021-01-06 12:34:39', '2021-01-06 12:34:39', 'توريد او تفتيح شفايف', '90', '1300', '10', NULL, 7, 124, 'salon'),
(75, '2021-01-06 12:35:19', '2021-01-06 12:35:19', 'شامه', '25', '100', '5', NULL, 7, 124, 'salon'),
(76, '2021-01-06 12:37:13', '2021-01-06 12:37:13', 'رفع حواجب', '45', '300', '10', NULL, 2, 124, 'salon'),
(77, '2021-01-06 12:37:33', '2021-01-06 12:37:33', 'رفع رموش', '45', '300', '10', NULL, 2, 124, 'salon'),
(86, '2021-01-09 01:20:51', '2021-01-09 01:20:51', 'مايكرو', '90', '1500', '10', NULL, 7, 123, 'salon'),
(87, '2021-01-09 01:21:39', '2021-01-09 01:21:39', 'مايكرو', '90', '1500', '10', NULL, 7, 123, 'salon'),
(91, '2021-01-12 20:05:58', '2021-01-12 20:05:58', 'استشوار', '50', '100', '0', NULL, 1, 134, 'salon'),
(92, '2021-01-12 20:06:07', '2021-01-12 20:06:07', 'استشوار', '50', '100', '0', NULL, 1, 134, 'salon'),
(93, '2021-01-12 20:06:29', '2021-01-12 20:06:29', 'استشوار', '45', '50', '5', NULL, 1, 134, 'salon'),
(94, '2021-01-14 18:19:45', '2021-01-14 18:19:45', 'استشوار', '45', '50', '0', NULL, 1, 134, 'salon'),
(95, '2021-01-14 20:16:27', '2021-01-14 20:16:27', 'خدمات صالون منزلية', '30', '100', '0', NULL, 1, 135, 'home'),
(96, '2021-01-14 20:18:36', '2021-01-14 20:18:36', 'خدمة صالون منزلية', '60', '200', '0', NULL, 3, 135, 'home'),
(97, '2021-01-14 20:19:44', '2021-01-14 20:19:44', 'خدمة صالون منزلية', '60', '500', '0', NULL, 4, 135, 'home'),
(98, '2021-01-14 20:20:59', '2021-01-14 20:20:59', 'خدمة صالون منزلية', '30', '100', '0', NULL, 9, 135, 'home'),
(99, '2021-01-14 20:21:50', '2021-01-14 20:21:50', 'خدمة صالون منزلية', '15', '40', '0', NULL, 10, 135, 'home'),
(100, '2021-01-14 20:22:32', '2021-01-14 20:22:32', 'خدمة صالون منزلية', '45', '60', '0', NULL, 11, 135, 'home'),
(101, '2021-01-14 20:23:39', '2021-01-14 20:23:39', 'خدمة صالون منزلية', '40', '300', '0', NULL, 14, 135, 'home'),
(102, '2021-02-28 18:09:40', '2021-02-28 18:09:40', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(103, '2021-02-28 18:09:53', '2021-02-28 18:09:53', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(104, '2021-02-28 18:10:00', '2021-02-28 18:10:00', 'استشوار', '50', '11', '0', NULL, 1, 145, 'salon'),
(105, '2021-02-28 18:16:52', '2021-02-28 18:16:52', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(106, '2021-02-28 18:16:52', '2021-02-28 18:16:52', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(107, '2021-02-28 18:16:52', '2021-02-28 18:16:52', 'استشوار', '50', '11', '0', NULL, 1, 145, 'salon'),
(108, '2021-02-28 18:16:53', '2021-02-28 18:16:53', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(109, '2021-02-28 18:16:54', '2021-02-28 18:16:54', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(110, '2021-02-28 18:16:54', '2021-02-28 18:16:54', 'استشوار', '50', '11', '0', NULL, 1, 145, 'salon'),
(111, '2021-02-28 18:17:13', '2021-02-28 18:17:13', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(112, '2021-02-28 18:17:13', '2021-02-28 18:17:13', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(113, '2021-02-28 18:17:13', '2021-02-28 18:17:13', 'استشوار', '50', '11', '0', NULL, 1, 145, 'salon'),
(114, '2021-02-28 18:17:26', '2021-02-28 18:17:26', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(115, '2021-02-28 18:17:26', '2021-02-28 18:17:26', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(116, '2021-02-28 18:17:26', '2021-02-28 18:17:26', 'استشوار', '50', '11', '0', NULL, 1, 145, 'salon'),
(117, '2021-02-28 18:18:17', '2021-02-28 18:18:17', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(118, '2021-02-28 18:18:17', '2021-02-28 18:18:17', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(119, '2021-02-28 18:18:17', '2021-02-28 18:18:17', 'استشوار', '50', '11', '0', NULL, 1, 145, 'salon'),
(120, '2021-02-28 18:18:23', '2021-02-28 18:18:23', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(121, '2021-02-28 18:18:23', '2021-02-28 18:18:23', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(122, '2021-02-28 18:18:23', '2021-02-28 18:18:23', 'استشوار', '50', '11', '0', NULL, 1, 145, 'salon'),
(123, '2021-02-28 18:19:25', '2021-02-28 18:19:25', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(124, '2021-02-28 18:19:25', '2021-02-28 18:19:25', 'استشوار', '50', '50', '0', NULL, 1, 145, 'salon'),
(125, '2021-02-28 18:19:25', '2021-02-28 18:19:25', 'استشوار', '50', '11', '0', NULL, 1, 145, 'salon'),
(137, '2021-03-17 14:45:59', '2021-03-18 13:48:17', 'new test service', '20', '72.9', '10', NULL, 1, 150, 'salon'),
(138, '2021-03-17 14:54:55', '2021-03-18 13:48:24', 'Seoul', '20', '162.0', '10', NULL, 2, 150, 'salon'),
(145, '2021-03-18 15:23:20', '2021-03-18 15:23:20', 'استشوار', '50', '100', '50', NULL, 1, 151, 'salon');

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

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

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `about` text COLLATE utf8mb4_unicode_ci,
  `policy` text COLLATE utf8mb4_unicode_ci,
  `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `snapchat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commission` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `created_at`, `updated_at`, `about`, `policy`, `mobile`, `facebook`, `twitter`, `snapchat`, `email`, `commission`) VALUES
(1, NULL, '2020-12-30 14:49:10', '<p>انوثة هو تطبيق يسهل عليك العناية بالشعر و اختيار قصة الشعر المناسبة لك و العديد من المزايا الأخري مثل صبغة الشعر و مجموعات العناية بالبشرة كل هذا دون الحاجة للنزول من المنزل، فقط كل ما عليك هو اختيار الصالون المناسب و اترك الباقي علينا. ندعوك لتجربة فريدة من نوعها.</p>', '<p>انوثة هو تطبيق يسهل عليك العناية بالشعر و اختيار قصة الشعر المناسبة لك و العديد من المزايا الأخري مثل صبغة الشعر و مجموعات العناية بالبشرة كل هذا دون الحاجة للنزول من المنزل، فقط كل ما عليك هو اختيار الصالون المناسب و اترك الباقي علينا. ندعوك لتجربة فريدة من نوعها.</p>', '966541756567+', 'facebook.com', '@AnwthahSA', 'anwthah1', 'sc@anwthah.com', '5');

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

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

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `image`, `user_id`, `url`, `created_at`, `updated_at`) VALUES
(3, '483_1602157659.jpg', NULL, 'https://tweetdeck.twitter.com/', '2020-10-08 09:47:39', '2020-10-08 09:47:39'),
(4, '262_1602157783.jpg', NULL, NULL, '2020-10-08 09:49:43', '2020-10-08 09:49:43');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `chats`
--
ALTER TABLE `chats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `chats_sender_id_foreign` (`sender_id`),
  ADD KEY `chats_receiver_id_foreign` (`receiver_id`),
  ADD KEY `chats_room_id_foreign` (`room_id`);

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

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

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

--
-- Indexes for table `favourites`
--
ALTER TABLE `favourites`
  ADD PRIMARY KEY (`id`),
  ADD KEY `favourites_user_id_foreign` (`user_id`),
  ADD KEY `favourites_salon_id_foreign` (`salon_id`);

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

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

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_user_id_foreign` (`user_id`),
  ADD KEY `notifications_order_id_foreign` (`order_id`),
  ADD KEY `notifications_salon_id_foreign` (`salon_id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_salon_id_foreign` (`salon_id`),
  ADD KEY `orders_user_id_foreign` (`user_id`),
  ADD KEY `orders_package_id_foreign` (`package_id`);

--
-- Indexes for table `order_services`
--
ALTER TABLE `order_services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_services_order_id_foreign` (`order_id`),
  ADD KEY `order_services_service_id_foreign` (`service_id`);

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

--
-- Indexes for table `rooms`
--
ALTER TABLE `rooms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rooms_user_id_foreign` (`user_id`),
  ADD KEY `rooms_salon_id_foreign` (`salon_id`);

--
-- Indexes for table `salons`
--
ALTER TABLE `salons`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salons_user_id_foreign` (`user_id`),
  ADD KEY `salons_city_id_foreign` (`city_id`);

--
-- Indexes for table `salon_accounts`
--
ALTER TABLE `salon_accounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salon_accounts_salon_id_foreign` (`salon_id`);

--
-- Indexes for table `salon_bank_transfers`
--
ALTER TABLE `salon_bank_transfers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salon_bank_transfers_salon_id_foreign` (`salon_id`),
  ADD KEY `salon_bank_transfers_account_id_foreign` (`account_id`),
  ADD KEY `salon_bank_transfers_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `salon_categories`
--
ALTER TABLE `salon_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salon_categories_salon_id_foreign` (`salon_id`),
  ADD KEY `salon_categories_category_id_foreign` (`category_id`);

--
-- Indexes for table `salon_comments`
--
ALTER TABLE `salon_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salon_comments_salon_id_foreign` (`salon_id`),
  ADD KEY `salon_comments_user_id_foreign` (`user_id`),
  ADD KEY `salon_comments_order_id_foreign` (`order_id`);

--
-- Indexes for table `salon_images`
--
ALTER TABLE `salon_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salon_images_salon_id_foreign` (`salon_id`);

--
-- Indexes for table `salon_times`
--
ALTER TABLE `salon_times`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salon_times_salon_id_foreign` (`salon_id`);

--
-- Indexes for table `sa_cities`
--
ALTER TABLE `sa_cities`
  ADD UNIQUE KEY `id` (`id`),
  ADD KEY `provinceId` (`provinceId`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `services_category_id_foreign` (`category_id`),
  ADD KEY `services_salon_id_foreign` (`salon_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `fields`
--
ALTER TABLE `fields`
  MODIFY `id` bigint(20) UNSIGNED 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=42;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `chats`
--
ALTER TABLE `chats`
  ADD CONSTRAINT `chats_receiver_id_foreign` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `chats_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `chats_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `favourites`
--
ALTER TABLE `favourites`
  ADD CONSTRAINT `favourites_salon_id_foreign` FOREIGN KEY (`salon_id`) REFERENCES `salons` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `favourites_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
  ADD CONSTRAINT `notifications_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `notifications_salon_id_foreign` FOREIGN KEY (`salon_id`) REFERENCES `salons` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `orders_salon_id_foreign` FOREIGN KEY (`salon_id`) REFERENCES `salons` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `order_services`
--
ALTER TABLE `order_services`
  ADD CONSTRAINT `order_services_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `order_services_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `packages`
--
ALTER TABLE `packages`
  ADD CONSTRAINT `packages_salon_id_foreign` FOREIGN KEY (`salon_id`) REFERENCES `salons` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `rooms`
--
ALTER TABLE `rooms`
  ADD CONSTRAINT `rooms_salon_id_foreign` FOREIGN KEY (`salon_id`) REFERENCES `salons` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `rooms_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `salons`
--
ALTER TABLE `salons`
  ADD CONSTRAINT `salons_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `salons_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `salon_accounts`
--
ALTER TABLE `salon_accounts`
  ADD CONSTRAINT `salon_accounts_salon_id_foreign` FOREIGN KEY (`salon_id`) REFERENCES `salons` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `salon_bank_transfers`
--
ALTER TABLE `salon_bank_transfers`
  ADD CONSTRAINT `salon_bank_transfers_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `salon_accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `salon_bank_transfers_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `salon_bank_transfers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `salon_bank_transfers_salon_id_foreign` FOREIGN KEY (`salon_id`) REFERENCES `salons` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `salon_categories`
--
ALTER TABLE `salon_categories`
  ADD CONSTRAINT `salon_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `salon_categories_salon_id_foreign` FOREIGN KEY (`salon_id`) REFERENCES `salons` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `salon_comments`
--
ALTER TABLE `salon_comments`
  ADD CONSTRAINT `salon_comments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `salon_comments_salon_id_foreign` FOREIGN KEY (`salon_id`) REFERENCES `salons` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `salon_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `salon_images`
--
ALTER TABLE `salon_images`
  ADD CONSTRAINT `salon_images_salon_id_foreign` FOREIGN KEY (`salon_id`) REFERENCES `salons` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `salon_times`
--
ALTER TABLE `salon_times`
  ADD CONSTRAINT `salon_times_salon_id_foreign` FOREIGN KEY (`salon_id`) REFERENCES `salons` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `services`
--
ALTER TABLE `services`
  ADD CONSTRAINT `services_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `services_salon_id_foreign` FOREIGN KEY (`salon_id`) REFERENCES `salons` (`id`) ON DELETE CASCADE;

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

