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

START TRANSACTION;



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

--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, '2023-07-22 12:54:24', '2023-07-22 12:54:24', NULL),
(2, 1, '2023-08-23 11:51:09', '2023-08-23 11:51:09', NULL);

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

--
-- Table structure for table `category_translations`
--

CREATE TABLE `category_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_translations`
--

INSERT INTO `category_translations` (`id`, `category_id`, `locale`, `name`) VALUES
(1, 1, 'ar', 'مركبات كبيرة'),
(2, 2, 'ar', 'مركبات صغيرة');

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

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

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `message` longtext NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `faqs` (`id`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, '2023-07-03 13:16:03', '2023-07-03 13:19:24', NULL),
(2, 1, '2023-08-21 13:35:04', '2023-08-21 13:35:04', NULL),
(3, 1, '2023-08-21 13:35:20', '2023-08-21 13:35:20', NULL);

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

--
-- Table structure for table `faq_translations`
--

CREATE TABLE `faq_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `faq_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faq_translations`
--

INSERT INTO `faq_translations` (`id`, `faq_id`, `locale`, `title`, `description`) VALUES
(1, 1, 'ar', 'هذا النص يمكن استبداله بنص اخر بديل من معجم اللغة العربية ؟', '<p><span data-metadata=\"<!--(figmeta)eyJmaWxlS2V5IjoiTG5uZ1Zza2JmNGFCclAxakVCZjVxaCIsInBhc3RlSUQiOjQzNjk1NTU4LCJkYXRhVHlwZSI6InNjZW5lIn0K(/figmeta)-->\"></span><span data-buffer=\"<!--(figma)[BLOB](/figma)-->\"></span><span style=\"white-space-collapse: preserve;\">تقوم رؤيتنا على مبدأ أن نكون دائماً موزع لقطع غيار السيارات المفضل لدى المستهلك في المملكة العربية السعودية. لذا فإننا نجتهد لتحقيق هذا الهدف من خلال إعتماد فكر جديد والإدراك بأن العالم ساحة ديناميكية .</span><br></p>');
INSERT INTO `faq_translations` (`id`, `faq_id`, `locale`, `title`, `description`) VALUES
(2, 2, 'ar', 'هذا النص يمكن استبداله بنص اخر بديل من معجم اللغة العربية ؟', '<p><span data-metadata=\"<!--(figmeta)eyJmaWxlS2V5IjoiTG5uZ1Zza2JmNGFCclAxakVCZjVxaCIsInBhc3RlSUQiOjQzNjk1NTU4LCJkYXRhVHlwZSI6InNjZW5lIn0K(/figmeta)-->\"></span><span data-buffer=\"<!--(figma)[BLOB](/figma)-->\"></span><span style=\"white-space-collapse: preserve;\">تقوم رؤيتنا على مبدأ أن نكون دائماً موزع لقطع غيار السيارات المفضل لدى المستهلك في المملكة العربية السعودية. لذا فإننا نجتهد لتحقيق هذا الهدف من خلال إعتماد فكر جديد والإدراك بأن العالم ساحة ديناميكية .</span><br></p>');
INSERT INTO `faq_translations` (`id`, `faq_id`, `locale`, `title`, `description`) VALUES
(3, 3, 'ar', 'هذا النص يمكن استبداله بنص اخر بديل من معجم اللغة العربية ؟', '<p><span data-metadata=\"<!--(figmeta)eyJmaWxlS2V5IjoiTG5uZ1Zza2JmNGFCclAxakVCZjVxaCIsInBhc3RlSUQiOjM4MDAwMDgzOSwiZGF0YVR5cGUiOiJzY2VuZSJ9Cg==(/figmeta)-->\"></span><span data-buffer=\"<!--(figma)[BLOB](/figma)-->\"></span><span style=\"white-space-collapse: preserve;\">تقوم رؤيتنا على مبدأ أن نكون دائماً موزع لقطع غيار السيارات المفضل لدى المستهلك في المملكة العربية السعودية. لذا فإننا نجتهد لتحقيق هذا الهدف من خلال إعتماد فكر جديد والإدراك بأن العالم ساحة ديناميكية .</span><br></p>');

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

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `mime_type` varchar(255) NOT NULL,
  `size` double(20,2) 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 `images`
--

INSERT INTO `images` (`id`, `file_name`, `display_name`, `mime_type`, `size`, `created_at`, `updated_at`) VALUES
(1, 'image_16886328151213999643.png', '316688519_686398922875483_1919521695316500906_n.png', 'png', 12985.00, '2023-07-06 03:40:15', '2023-07-06 03:40:15'),
(2, 'image_1688639233615621520.jpeg', '1682963269 (1).jpeg', 'jpeg', 401056.00, '2023-07-06 05:27:13', '2023-07-06 05:27:13'),
(3, 'image_1688639241827914237.jpeg', '1682963269 (1).jpeg', 'jpeg', 401056.00, '2023-07-06 05:27:21', '2023-07-06 05:27:21'),
(4, 'image_16886397031670370183.png', 'cell.png', 'png', 601.00, '2023-07-06 05:35:03', '2023-07-06 05:35:03'),
(5, 'image_16886397161324275805.jpeg', 'WhatsApp Image 2023-03-24 at 12.39.17 PM.jpeg', 'jpeg', 157298.00, '2023-07-06 05:35:16', '2023-07-06 05:35:16'),
(6, 'image_16887285691648718976.jpeg', '1682963269 (1).jpeg', 'jpeg', 401056.00, '2023-07-07 06:16:09', '2023-07-07 06:16:09'),
(7, 'image_16926320222040685980.png', '43.png', 'png', 8697.00, '2023-08-21 13:33:42', '2023-08-21 13:33:42'),
(8, 'image_16926320391665058138.png', '43.png', 'png', 8697.00, '2023-08-21 13:33:59', '2023-08-21 13:33:59'),
(9, 'image_1692632055452831336.png', '43.png', 'png', 8697.00, '2023-08-21 13:34:15', '2023-08-21 13:34:15'),
(10, 'image_1692798370274948454.png', 'Vector.png', 'png', 809.00, '2023-08-23 11:46:10', '2023-08-23 11:46:10'),
(11, 'image_1692798387160386294.png', 'Vector.png', 'png', 809.00, '2023-08-23 11:46:27', '2023-08-23 11:46:27'),
(12, 'image_16927984052126167761.png', 'Vector.png', 'png', 809.00, '2023-08-23 11:46:45', '2023-08-23 11:46:45'),
(13, 'image_1692798430524086755.png', 'Vector.png', 'png', 809.00, '2023-08-23 11:47:10', '2023-08-23 11:47:10'),
(14, 'image_1692798457974617291.png', 'Rectangle 41924.png', 'png', 1009350.00, '2023-08-23 11:47:37', '2023-08-23 11:47:37'),
(15, 'image_1692798485936212537.png', 'Rectangle 41927.png', 'png', 397222.00, '2023-08-23 11:48:05', '2023-08-23 11:48:05'),
(16, 'image_16927985011940200118.png', 'Group 164464.png', 'png', 460428.00, '2023-08-23 11:48:21', '2023-08-23 11:48:21'),
(17, 'image_16927986801095005111.png', 'img-04.png', 'png', 68291.00, '2023-08-23 11:51:20', '2023-08-23 11:51:20');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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, '2019_11_17_071845_create_contacts_table', 1),
(2, '2019_11_17_080832_create_replays_table', 1),
(3, '2019_11_17_090815_create_pages_table', 1),
(4, '2019_11_17_150355_create_page_translations_table', 1),
(5, '2020_01_31_100544_create_admins_table', 1),
(6, '2020_03_19_104922_create_permission_tables', 1),
(7, '2020_03_26_114520_create_images_table', 1),
(8, '2020_09_08_081507_create_faqs_table', 1),
(9, '2020_09_08_081659_create_faq_translations_table', 1),
(10, '2020_10_19_112215_create_settings_table', 1),
(11, '2023_07_06_080733_create_services_table', 2),
(12, '2023_07_06_080740_create_service_translations_table', 2),
(13, '2023_07_06_103657_create_products_table', 3),
(14, '2023_07_06_103707_create_product_translations_table', 3),
(19, '2014_10_12_000000_create_users_table', 4),
(20, '2014_10_12_100000_create_password_resets_table', 4),
(21, '2023_07_11_182957_add_price_column_to_products_table', 5),
(26, '2023_07_12_093301_create_properties_table', 6),
(27, '2023_07_12_093310_create_property_translations_table', 6),
(28, '2023_07_12_093325_create_options_table', 6),
(29, '2023_07_12_093337_create_option_translations_table', 6),
(30, '2023_06_03_105209_create_sliders_table', 7),
(31, '2023_06_03_105238_create_slider_translations_table', 7),
(32, '2023_07_15_144710_add_images_column_to_products_table', 7),
(33, '2023_07_15_144842_add_short_description_column_to_product_translations_table', 7),
(34, '2023_07_15_183538_create_categories_table', 7),
(35, '2023_07_15_184139_create_category_translations_table', 7),
(36, '2023_07_15_190024_add_category_id_column_to_products_table', 7),
(37, '2023_07_16_201154_add_show_in_header_column_to_pages_table', 8),
(38, '2023_07_25_211700_create_product_properties_table', 9),
(39, '2023_07_25_223453_create_carts_table', 10),
(40, '2023_08_09_182316_create_orders_table', 11),
(41, '2023_08_09_182757_create_order_items_table', 11);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Model\\Admin', 1);

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

--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `property_id` bigint(20) UNSIGNED NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `options`
--

INSERT INTO `options` (`id`, `property_id`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 1, '2023-07-12 05:20:22', '2023-07-12 05:23:58', '2023-07-12 05:23:58'),
(2, 1, 1, '2023-07-12 05:20:40', '2023-07-12 05:23:58', '2023-07-12 05:23:58'),
(3, 1, 1, '2023-07-12 05:21:42', '2023-07-12 05:23:58', '2023-07-12 05:23:58'),
(4, 1, 1, '2023-07-12 05:22:18', '2023-07-12 05:23:58', '2023-07-12 05:23:58'),
(5, 1, 1, '2023-07-12 05:22:46', '2023-07-12 05:23:58', '2023-07-12 05:23:58'),
(6, 1, 1, '2023-07-12 05:23:01', '2023-07-12 05:23:58', '2023-07-12 05:23:58'),
(7, 1, 1, '2023-07-12 05:23:25', '2023-07-12 05:23:58', '2023-07-12 05:23:58'),
(8, 1, 1, '2023-07-12 05:23:58', '2023-07-12 05:27:33', '2023-07-12 05:27:33'),
(9, 1, 1, '2023-07-12 05:23:58', '2023-07-12 05:23:58', NULL),
(10, 1, 1, '2023-07-12 05:23:58', '2023-07-12 05:26:59', '2023-07-12 05:26:59'),
(11, 1, 1, '2023-07-12 05:27:05', '2023-07-12 05:27:05', NULL),
(12, 2, 1, '2023-07-22 12:54:44', '2023-07-22 12:54:44', NULL),
(13, 2, 1, '2023-07-22 12:54:44', '2023-07-22 12:54:44', NULL),
(14, 2, 1, '2023-07-22 12:54:44', '2023-07-22 12:54:44', NULL);

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

--
-- Table structure for table `option_translations`
--

CREATE TABLE `option_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `option_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `option_translations`
--

INSERT INTO `option_translations` (`id`, `option_id`, `locale`, `name`) VALUES
(1, 8, 'ar', '1'),
(2, 9, 'ar', 'كيا'),
(3, 10, 'ar', '3'),
(4, 11, 'ar', 'هونداي'),
(5, 12, 'ar', 'توسان'),
(6, 13, 'ar', 'توياتا'),
(7, 14, 'ar', 'كيا');

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

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

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('new','in_progress','completed') NOT NULL DEFAULT 'new',
  `total` double(10,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(10) UNSIGNED NOT NULL,
  `init_price` double(10,2) NOT NULL,
  `final_price` double(10,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `show_in_header` tinyint(1) NOT NULL DEFAULT 0,
  `show_in_footer` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pages` (`id`, `created_at`, `updated_at`, `deleted_at`, `show_in_header`, `show_in_footer`) VALUES
(1, '2023-07-03 13:20:43', '2023-07-03 13:20:43', NULL, 0, 0);

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

--
-- Table structure for table `page_translations`
--

CREATE TABLE `page_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `page_translations`
--

INSERT INTO `page_translations` (`id`, `page_id`, `locale`, `title`, `content`) VALUES
(1, 1, 'ar', 'as das d', '<p>ddd asd&nbsp;</p>');

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) 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 `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'add_admins', 'admin', '2023-07-03 12:53:04', '2023-07-03 12:53:04'),
(2, 'show_admins', 'admin', '2023-07-03 12:53:04', '2023-07-03 12:53:04'),
(3, 'delete_admins', 'admin', '2023-07-03 12:53:04', '2023-07-03 12:53:04'),
(4, 'manage_roles', 'admin', '2023-07-03 12:53:04', '2023-07-03 12:53:04'),
(5, 'manage_inbox', 'admin', '2023-07-03 12:53:04', '2023-07-03 12:53:04'),
(6, 'manage_faq', 'admin', '2023-07-03 12:53:04', '2023-07-03 12:53:04'),
(7, 'manage_pages', 'admin', '2023-07-03 12:53:04', '2023-07-03 12:53:04'),
(8, 'manage_settings', 'admin', '2023-07-03 12:53:04', '2023-07-03 12:53:04'),
(9, 'manage_services', 'admin', '2023-07-06 03:16:35', '2023-07-06 03:16:35'),
(10, 'add_products', 'admin', '2023-07-06 05:48:55', '2023-07-06 05:48:55'),
(11, 'show_products', 'admin', '2023-07-06 05:48:55', '2023-07-06 05:48:55'),
(12, 'delete_products', 'admin', '2023-07-06 05:48:55', '2023-07-06 05:48:55'),
(13, 'add_users', 'admin', '2023-07-07 07:34:43', '2023-07-07 07:34:43'),
(14, 'show_users', 'admin', '2023-07-07 07:34:43', '2023-07-07 07:34:43'),
(15, 'delete_users', 'admin', '2023-07-07 07:34:43', '2023-07-07 07:34:43'),
(16, 'manage_properties', 'admin', '2023-07-12 05:29:42', '2023-07-12 05:29:42'),
(17, 'add_sliders', 'admin', '2023-07-20 17:28:19', '2023-07-20 17:28:19'),
(18, 'show_sliders', 'admin', '2023-07-20 17:28:19', '2023-07-20 17:28:19'),
(19, 'delete_sliders', 'admin', '2023-07-20 17:28:19', '2023-07-20 17:28:19'),
(20, 'add_categories', 'admin', '2023-07-20 17:28:19', '2023-07-20 17:28:19'),
(21, 'show_categories', 'admin', '2023-07-20 17:28:19', '2023-07-20 17:28:19'),
(22, 'delete_categories', 'admin', '2023-07-20 17:28:19', '2023-07-20 17:28:19');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `number` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `price` double(10,2) NOT NULL,
  `offer_price` double(10,2) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`images`)),
  `category_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `number`, `image`, `price`, `offer_price`, `is_active`, `is_featured`, `created_at`, `updated_at`, `deleted_at`, `images`, `category_id`) VALUES
(1, '976262S000', 'image_16927986801095005111.png', 50.70, 50.50, 1, 0, '2023-07-07 06:16:09', '2023-08-23 11:51:20', NULL, '[]', 1);

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

--
-- Table structure for table `product_properties`
--

CREATE TABLE `product_properties` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `property_id` bigint(20) UNSIGNED NOT NULL,
  `option_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_properties`
--

INSERT INTO `product_properties` (`id`, `product_id`, `property_id`, `option_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 9, '2023-08-21 13:36:12', '2023-08-21 13:36:12');

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

--
-- Table structure for table `product_translations`
--

CREATE TABLE `product_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `short_description` text NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_translations`
--

INSERT INTO `product_translations` (`id`, `product_id`, `locale`, `title`, `short_description`, `description`) VALUES
(1, 1, 'ar', 'بلف مكيف هونداي توسان', 'بلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسان', '<p>بلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسانبلف مكيف هونداي توسان</p>');

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

--
-- Table structure for table `properties`
--

CREATE TABLE `properties` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `properties`
--

INSERT INTO `properties` (`id`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, '2023-07-12 04:59:51', '2023-08-23 11:49:37', NULL),
(2, 1, '2023-07-22 12:54:44', '2023-07-22 12:54:44', NULL);

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

--
-- Table structure for table `property_translations`
--

CREATE TABLE `property_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `property_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_translations`
--

INSERT INTO `property_translations` (`id`, `property_id`, `locale`, `name`) VALUES
(1, 1, 'ar', 'نوع المركبة'),
(2, 2, 'ar', 'موديل القطعة');

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

--
-- Table structure for table `replays`
--

CREATE TABLE `replays` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `contact_id` bigint(20) UNSIGNED NOT NULL,
  `message` longtext NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) 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 `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'admin', '2023-07-03 12:53:04', '2023-07-03 12:53:04');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1);

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

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

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `services` (`id`, `image`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'image_1692798430524086755.png', 1, '2023-07-06 03:40:15', '2023-08-23 11:47:10', NULL),
(2, 'image_16927984052126167761.png', 1, '2023-08-21 13:33:42', '2023-08-23 11:46:45', NULL),
(3, 'image_1692798387160386294.png', 1, '2023-08-21 13:33:59', '2023-08-23 11:46:27', NULL),
(4, 'image_1692798370274948454.png', 1, '2023-08-21 13:34:15', '2023-08-23 11:46:10', NULL);

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

--
-- Table structure for table `service_translations`
--

CREATE TABLE `service_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service_translations`
--

INSERT INTO `service_translations` (`id`, `service_id`, `locale`, `title`, `description`) VALUES
(1, 1, 'ar', 'خدمة الدعم اللوجيستي', '<p><span data-metadata=\"<!--(figmeta)eyJmaWxlS2V5IjoiTG5uZ1Zza2JmNGFCclAxakVCZjVxaCIsInBhc3RlSUQiOjE2ODY5MzM0MTIsImRhdGFUeXBlIjoic2NlbmUifQo=(/figmeta)-->\"></span><span data-buffer=\"<!--(figma)[BLOB](/figma)-->\"></span><span style=\"white-space-collapse: preserve;\">نجتهد لتحقيق هذا الهدف من خلال إعتماد فكر جديد والإدراك بأن العالم ساحة ديناميكية مما يترتب علينا التأقلم..</span><br></p>');
INSERT INTO `service_translations` (`id`, `service_id`, `locale`, `title`, `description`) VALUES
(2, 2, 'ar', 'خدمة الدعم اللوجيستي', '<p><span data-metadata=\"<!--(figmeta)eyJmaWxlS2V5IjoiTG5uZ1Zza2JmNGFCclAxakVCZjVxaCIsInBhc3RlSUQiOjk4NjY4NTk5NiwiZGF0YVR5cGUiOiJzY2VuZSJ9Cg==(/figmeta)-->\"></span><span data-buffer=\"<!--(figma)[BLOB](/figma)-->\"></span><span style=\"white-space-collapse: preserve;\">نجتهد لتحقيق هذا الهدف من خلال إعتماد فكر جديد والإدراك بأن العالم ساحة ديناميكية مما يترتب علينا التأقلم..</span><br></p>');
INSERT INTO `service_translations` (`id`, `service_id`, `locale`, `title`, `description`) VALUES
(3, 3, 'ar', 'خدمة الدعم اللوجيستي', '<p><span data-metadata=\"<!--(figmeta)eyJmaWxlS2V5IjoiTG5uZ1Zza2JmNGFCclAxakVCZjVxaCIsInBhc3RlSUQiOjk4NjY4NTk5NiwiZGF0YVR5cGUiOiJzY2VuZSJ9Cg==(/figmeta)-->\"></span><span data-buffer=\"<!--(figma)[BLOB](/figma)-->\"></span><span style=\"white-space-collapse: preserve;\">نجتهد لتحقيق هذا الهدف من خلال إعتماد فكر جديد والإدراك بأن العالم ساحة ديناميكية مما يترتب علينا التأقلم..</span><br></p>');
INSERT INTO `service_translations` (`id`, `service_id`, `locale`, `title`, `description`) VALUES
(4, 4, 'ar', 'خدمة الدعم اللوجيستي', '<p><span data-metadata=\"<!--(figmeta)eyJmaWxlS2V5IjoiTG5uZ1Zza2JmNGFCclAxakVCZjVxaCIsInBhc3RlSUQiOjc1ODQ4ODQwNiwiZGF0YVR5cGUiOiJzY2VuZSJ9Cg==(/figmeta)-->\"></span><span data-metadata=\"<!--(figmeta)eyJmaWxlS2V5IjoiTG5uZ1Zza2JmNGFCclAxakVCZjVxaCIsInBhc3RlSUQiOjIwNTI1MjgyNjgsImRhdGFUeXBlIjoic2NlbmUifQo=(/figmeta)-->\"></span><span data-buffer=\"<!--(figma)[BLOB](/figma)-->\"></span><span style=\"white-space-collapse: preserve;\">نجتهد لتحقيق هذا الهدف من خلال إعتماد فكر جديد والإدراك بأن العالم ساحة ديناميكية مما يترتب علينا التأقلم..</span><br></p>');

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

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

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) NOT NULL,
  `mobile_image` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `slider_translations`
--

CREATE TABLE `slider_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slider_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- Indexes for table `category_translations`
--
ALTER TABLE `category_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `category_translations_category_id_locale_unique` (`category_id`,`locale`),
  ADD KEY `category_translations_locale_index` (`locale`);

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

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

--
-- Indexes for table `faq_translations`
--
ALTER TABLE `faq_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `faq_translations_faq_id_locale_unique` (`faq_id`,`locale`),
  ADD KEY `faq_translations_locale_index` (`locale`);

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

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

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

--
-- Indexes for table `option_translations`
--
ALTER TABLE `option_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `option_translations_option_id_locale_unique` (`option_id`,`locale`),
  ADD KEY `option_translations_locale_index` (`locale`);

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

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

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

--
-- Indexes for table `page_translations`
--
ALTER TABLE `page_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `page_translations_page_id_locale_unique` (`page_id`,`locale`),
  ADD KEY `page_translations_locale_index` (`locale`);

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

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

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

--
-- Indexes for table `product_translations`
--
ALTER TABLE `product_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `product_translations_product_id_locale_unique` (`product_id`,`locale`),
  ADD KEY `product_translations_locale_index` (`locale`);

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

--
-- Indexes for table `property_translations`
--
ALTER TABLE `property_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `property_translations_property_id_locale_unique` (`property_id`,`locale`),
  ADD KEY `property_translations_locale_index` (`locale`);

--
-- Indexes for table `replays`
--
ALTER TABLE `replays`
  ADD PRIMARY KEY (`id`),
  ADD KEY `replays_contact_id_foreign` (`contact_id`);

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

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

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

--
-- Indexes for table `service_translations`
--
ALTER TABLE `service_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `service_translations_service_id_locale_unique` (`service_id`,`locale`),
  ADD KEY `service_translations_locale_index` (`locale`);

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

--
-- Indexes for table `slider_translations`
--
ALTER TABLE `slider_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slider_translations_slider_id_locale_unique` (`slider_id`,`locale`),
  ADD KEY `slider_translations_locale_index` (`locale`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

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

--
-- Constraints for table `faq_translations`
--
ALTER TABLE `faq_translations`
  ADD CONSTRAINT `faq_translations_faq_id_foreign` FOREIGN KEY (`faq_id`) REFERENCES `faqs` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `option_translations`
--
ALTER TABLE `option_translations`
  ADD CONSTRAINT `option_translations_option_id_foreign` FOREIGN KEY (`option_id`) REFERENCES `options` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `product_translations`
--
ALTER TABLE `product_translations`
  ADD CONSTRAINT `product_translations_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `property_translations`
--
ALTER TABLE `property_translations`
  ADD CONSTRAINT `property_translations_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `properties` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `replays`
--
ALTER TABLE `replays`
  ADD CONSTRAINT `replays_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `slider_translations`
--
ALTER TABLE `slider_translations`
  ADD CONSTRAINT `slider_translations_slider_id_foreign` FOREIGN KEY (`slider_id`) REFERENCES `sliders` (`id`) ON DELETE CASCADE;
COMMIT;

