--
-- Host: localhost    Database: dugasoil_testequipment
-- ------------------------------------------------------


--
-- Table structure for table `about_sections`
--

CREATE TABLE `about_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `button_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `about_sections`
--

INSERT INTO `about_sections` VALUES (1,9,'من نحن؟','لدينا خبرة صناعية تزيد عن 30 عامًا','و سأعرض مثال حي لهذا، من منا لم يتحمل جهد بدني شاق إلا من أجل الحصول على ميزة أو فائدة؟ ولكن من لديه الحق أن ينتقد شخص ما أراد أن يشعر بالسعادة التي لا تشوبها عواقب أليمة أو آخر أراد أن يتجنب الألم الذي ربما تنجم عنه بعض المتعة ؟\r\n\r\nعلي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','نحن نفعل','http://www.google.com','2021-12-08 05:16:39','2022-08-01 03:26:10'),(2,8,'Who We Are?','We Have 30+ Years Industry Experience','The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.\n\nLorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','We Do','http://www.google.com','2022-03-06 00:25:12','2022-10-04 05:16:07');

--
-- Table structure for table `advertisements`
--

CREATE TABLE `advertisements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ad_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `resolution_type` smallint unsigned NOT NULL COMMENT '1 => 300 x 250, 2 => 300 x 600, 3 => 728 x 90',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slot` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` int unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `advertisements`
--

INSERT INTO `advertisements` VALUES (7,'banner',3,'62e231ce31926.png','http://example.com/',NULL,3,'2021-08-15 22:44:47','2022-08-22 23:14:52'),(8,'banner',2,'62e231b2e7386.png','http://example.com/',NULL,1,'2021-08-15 22:45:21','2025-02-24 11:59:14'),(9,'banner',1,'62e23191d30d7.png','http://example.com/',NULL,0,'2021-08-15 23:12:31','2022-07-28 00:49:53'),(10,'banner',1,'62e231831b43f.png','http://example.com/',NULL,2,'2021-08-15 23:13:44','2022-07-28 00:49:39'),(11,'banner',2,'62e231750df75.png','http://example.com/',NULL,2,'2021-08-15 23:15:14','2022-07-28 00:49:25'),(12,'banner',1,'62e231610cef0.png','http://example.com/',NULL,1,'2021-08-15 23:16:41','2022-08-02 03:16:37'),(13,'banner',3,'62e23140498d8.png','http://example.com/',NULL,2,'2021-08-17 04:52:09','2025-02-24 14:17:33');

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint unsigned NOT NULL,
  `serial_number` mediumint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `blog_categories_language_id_foreign` (`language_id`),
  CONSTRAINT `blog_categories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_categories`
--

INSERT INTO `blog_categories` VALUES (36,8,'Equipment','equipment',1,1,'2021-10-12 22:51:29','2022-08-28 00:02:49'),(38,8,'Construction','construction',1,2,'2021-10-12 22:51:52','2022-08-28 00:02:53'),(39,9,'معدات','معدات',1,1,'2021-10-12 22:58:54','2022-08-28 00:03:02'),(41,9,'بناء','بناء',1,2,'2021-10-12 22:59:19','2022-08-28 00:03:05');

--
-- Table structure for table `blog_informations`
--

CREATE TABLE `blog_informations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `blog_category_id` bigint unsigned NOT NULL,
  `blog_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` blob NOT NULL,
  `meta_keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `blog_informations_language_id_foreign` (`language_id`),
  KEY `blog_informations_blog_category_id_foreign` (`blog_category_id`),
  KEY `blog_informations_blog_id_foreign` (`blog_id`),
  CONSTRAINT `blog_informations_blog_category_id_foreign` FOREIGN KEY (`blog_category_id`) REFERENCES `blog_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `blog_informations_blog_id_foreign` FOREIGN KEY (`blog_id`) REFERENCES `blogs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `blog_informations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_informations`
--

INSERT INTO `blog_informations` VALUES (19,9,41,12,'سلامة عمال البناء','سلامة-عمال-البناء','جين دو',_binary '[binary data, 510 characters]',NULL,NULL,'2021-10-13 23:13:31','2022-07-27 01:47:19'),(20,8,38,12,'Construction worker\'s safety','construction-worker\'s-safety','Jane Doe',_binary '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</span></p><p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</span><br /></p>',NULL,NULL,'2021-10-13 23:13:31','2022-08-02 01:00:07'),(27,9,39,16,'أفضل تأجير المعدات لمشروعك الكبير','أفضل-تأجير-المعدات-لمشروعك-الكبير','فلان الفلاني',_binary '[binary data, 502 characters]',NULL,NULL,'2021-12-07 00:44:01','2022-01-02 03:18:44'),(28,8,36,16,'Best equipment rental for your big project','best-equipment-rental-for-your-big-project','John Doe',_binary '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</span></p><p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</span></p>',NULL,NULL,'2021-12-07 00:44:02','2022-08-02 01:00:57'),(29,9,41,17,'مكونات المولدات التي يجب أن تعرفها','مكونات-المولدات-التي-يجب-أن-تعرفها','ما فائدته',_binary '[binary data, 510 characters]',NULL,NULL,'2022-01-02 03:58:42','2022-08-02 01:01:26'),(30,8,38,17,'Generator Components Which You Should Know','generator-components-which-you-should-know','Drake Duncan',_binary '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</span></p><p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</span></p>',NULL,NULL,'2022-01-02 03:58:42','2022-08-02 01:01:26'),(31,9,41,18,'أفضل أعمال البناء مع أفضل مهندس','أفضل-أعمال-البناء-مع-أفضل-مهندس','كاثرين فوج',_binary '[binary data, 502 characters]',NULL,NULL,'2022-07-27 03:02:14','2022-07-27 04:40:08'),(32,8,38,18,'Best construction work with best engineer','best-construction-work-with-best-engineer','Katherine Fogg',_binary '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</span></p><p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</span></p>',NULL,NULL,'2022-07-27 03:02:14','2022-08-02 01:02:01'),(33,9,39,19,'استئجار معدات البناء لمشروعك الضخم','استئجار-معدات-البناء-لمشروعك-الضخم','فلان الفلاني',_binary '[binary data, 502 characters]',NULL,NULL,'2022-07-29 23:17:22','2022-07-29 23:17:22'),(34,8,36,19,'Rent construction equipment for your mega project','rent-construction-equipment-for-your-mega-project','John Doe',_binary '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</span></p><p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</span></p>',NULL,NULL,'2022-07-29 23:17:22','2022-08-02 01:02:28'),(35,9,41,20,'أفضل مخطط معماري من قبل أفضل مهندس','أفضل-مخطط-معماري-من-قبل-أفضل-مهندس','كاثرين فوج',_binary '[binary data, 502 characters]',NULL,NULL,'2022-07-29 23:21:54','2022-07-29 23:21:54'),(36,8,38,20,'Best architectural plan by the best engineer','best-architectural-plan-by-the-best-engineer','Katherine Fogg',_binary '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</span></p><p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</span></p>',NULL,NULL,'2022-07-29 23:21:54','2022-08-02 01:03:02');

--
-- Table structure for table `blog_sections`
--

CREATE TABLE `blog_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_sections`
--

INSERT INTO `blog_sections` VALUES (3,8,'Blog','Our Latest Post','2022-01-02 01:14:53','2022-07-27 01:41:03'),(4,9,'مقالات','أحدث مدونة','2022-03-06 00:41:19','2022-03-06 00:41:19');

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial_number` mediumint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` VALUES (12,'62e4b94b7674d.png',1,'2021-10-13 23:13:31','2022-07-29 22:53:31'),(16,'62e4bb1eac65b.png',2,'2021-12-07 00:43:59','2022-07-29 23:01:18'),(17,'62e4bcca4a82a.png',3,'2022-01-02 03:58:42','2022-07-29 23:08:26'),(18,'62e4bd6349dea.png',4,'2022-07-27 03:02:14','2022-07-29 23:10:59'),(19,'62e4bee2dfd48.png',5,'2022-07-29 23:17:22','2022-07-29 23:17:22'),(20,'62e4bff22e1e4.png',6,'2022-07-29 23:21:54','2022-07-29 23:21:54');

--
-- Table structure for table `call_to_action_sections`
--

CREATE TABLE `call_to_action_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `call_to_action_sections`
--

INSERT INTO `call_to_action_sections` VALUES (2,8,'We Are Serving Since 20 Years With Trust','Aenean ligula porttitor euonsequat vitae eleifend aenliquam lorem','Get A Quote','http://example.com/','2021-12-31 22:29:16','2022-07-27 01:01:38'),(3,9,'نحن نخدم منذ 20 عامًا بثقة','نتيجة لظروف ما قد تكمن السعاده فيما نتحمله م','إقتبس','http://example.com/','2022-03-06 00:38:38','2022-08-01 05:48:16');

--
-- Table structure for table `cookie_alerts`
--

CREATE TABLE `cookie_alerts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `cookie_alert_status` tinyint unsigned NOT NULL,
  `cookie_alert_btn_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cookie_alert_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cookie_alerts_language_id_foreign` (`language_id`),
  CONSTRAINT `cookie_alerts_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cookie_alerts`
--

INSERT INTO `cookie_alerts` VALUES (1,9,1,'أنا موافق','نحن نستخدم ملفات تعريف الارتباط لنمنحك أفضل تجربة عبر الإنترنت.\r\nمن خلال الاستمرار في تصفح الموقع ، فإنك توافق على استخدامنا لملفات تعريف الارتباط.','2021-06-02 06:25:54','2022-08-01 01:25:45'),(2,8,1,'I Agree','We use cookies to give you the best online experience.\r\nBy continuing to browse the site you are agreeing to our use of cookies.','2021-08-29 04:20:43','2022-10-04 05:29:07');

--
-- Table structure for table `counter_informations`
--

CREATE TABLE `counter_informations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `counter_informations`
--

INSERT INTO `counter_informations` VALUES (11,8,'fas fa-truck-monster',200,'All Equipment','2021-12-30 00:00:54','2022-03-06 01:31:26'),(12,8,'fas fa-map-marker-alt',175,'Coverage Area','2021-12-30 00:01:22','2021-12-30 00:01:22'),(13,8,'fas fa-city',596,'Companies','2021-12-30 00:02:07','2021-12-30 00:05:09'),(14,8,'fas fa-user-cog',158,'Workers','2021-12-30 00:04:47','2021-12-30 00:04:47'),(18,9,'fas fa-truck-monster',200,'جميع المعدات','2022-03-06 01:31:46','2022-03-06 01:31:46'),(19,9,'fas fa-map-marker-alt',175,'منطقة التغطية','2022-03-06 01:32:19','2022-03-06 01:32:19'),(20,9,'fas fa-city',596,'شركات','2022-03-06 01:32:55','2022-03-06 01:32:55'),(21,9,'fas fa-user-cog',158,'عمال','2022-03-06 01:33:26','2022-03-06 01:33:26');

--
-- Table structure for table `equipment_bookings`
--

CREATE TABLE `equipment_bookings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `booking_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `equipment_id` bigint unsigned NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `shipping_method` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total` decimal(8,2) unsigned DEFAULT NULL,
  `discount` decimal(8,2) unsigned DEFAULT NULL,
  `shipping_cost` decimal(8,2) unsigned DEFAULT NULL,
  `tax` decimal(8,2) unsigned DEFAULT NULL,
  `grand_total` decimal(8,2) unsigned DEFAULT NULL,
  `currency_symbol` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_symbol_position` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_text` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_text_position` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `booking_type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price_message` text COLLATE utf8mb4_unicode_ci,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gateway_type` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_status` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `equipment_bookings_equipment_id_foreign` (`equipment_id`),
  KEY `equipment_bookings_user_id_foreign` (`user_id`),
  CONSTRAINT `equipment_bookings_equipment_id_foreign` FOREIGN KEY (`equipment_id`) REFERENCES `equipments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `equipment_bookings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=213 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `equipment_bookings`
--

INSERT INTO `equipment_bookings` VALUES (210,15,'63071e44bd1ab','Robert Fonseca','715-396-9284','robert@gmail.com',16,'2022-08-26','2022-08-30','two way delivery','Georgetown, California',NULL,NULL,200.00,NULL,NULL,'$','left','USD','left','request price','There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable.',NULL,NULL,'pending','pending',NULL,NULL,'2022-08-25 01:01:24','2022-08-25 01:01:24'),(211,NULL,'67bc96dee1256','Jack Lim','0169194972','bukateea@yahoo.com',14,'2025-02-25','2025-02-27','two way delivery','Washington, California',115.00,0.00,100.00,5.75,220.75,'$','left','USD','left',NULL,NULL,'Citibank','offline','pending','pending',NULL,NULL,'2025-02-24 13:57:18','2025-02-24 13:57:18'),(212,NULL,'67bc9b3b5bc61','Jack Lim','0169194972','dafe20000@yahoo.com',15,'2025-02-28','2025-03-08','two way delivery','Georgetown, California',90.00,0.00,200.00,4.50,294.50,'$','left','USD','left',NULL,NULL,'Bank of America','offline','completed','delivered','67bc9b3b4dc1d.jpeg','67bc9b3b5bc61.pdf','2025-02-24 14:15:55','2025-02-26 04:16:35');

--
-- Table structure for table `equipment_categories`
--

CREATE TABLE `equipment_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint unsigned NOT NULL,
  `serial_number` mediumint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `equipment_categories_language_id_foreign` (`language_id`),
  CONSTRAINT `equipment_categories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `equipment_categories`
--

INSERT INTO `equipment_categories` VALUES (44,8,'Excavator','excavator',1,1,'2022-01-25 22:03:22','2022-08-27 23:07:15'),(45,8,'Roller','roller',1,2,'2022-01-25 22:04:56','2022-08-27 23:07:24'),(47,9,'حفارة','حفارة',1,1,'2022-01-25 22:06:34','2022-08-27 23:08:02'),(48,9,'أسطوانة','أسطوانة',1,2,'2022-01-25 22:07:17','2022-08-27 23:08:13'),(52,8,'Mining Truck','mining-truck',1,3,'2022-01-29 23:57:35','2022-08-27 23:07:32'),(53,9,'شاحنة التعدين','شاحنة-التعدين',1,3,'2022-01-29 23:58:32','2022-08-27 23:08:22'),(54,8,'Wheel Loader','wheel-loader',1,4,'2022-01-31 05:27:24','2022-08-27 23:07:36'),(55,9,'رافعة شوكية','رافعة-شوكية',1,4,'2022-01-31 05:32:28','2022-08-27 23:08:25'),(56,8,'Mixer Truck','mixer-truck',1,5,'2022-07-31 23:38:02','2022-08-27 23:07:46'),(57,8,'Pile Driver','pile-driver',1,6,'2022-07-31 23:38:22','2022-08-27 23:07:50'),(58,9,'شاحنة خلاط','شاحنة-خلاط',1,5,'2022-07-31 23:39:05','2022-08-27 23:08:27'),(59,9,'سائق كوم','سائق-كوم',1,6,'2022-07-31 23:39:27','2022-08-27 23:08:30');

--
-- Table structure for table `equipment_contents`
--

CREATE TABLE `equipment_contents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `equipment_category_id` bigint unsigned NOT NULL,
  `equipment_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `features` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` blob NOT NULL,
  `meta_keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `equipment_contents`
--

INSERT INTO `equipment_contents` VALUES (15,9,47,8,'حفارات صغيرة','حفارات-صغيرة','صافي القدرة: 13 حصان\r\nوزن التشغيل: 2061 رطل\r\nأقصى عمق حفر: 5.68 قدم',_binary '[binary data, 517 characters]',NULL,NULL,'2022-01-30 00:02:16','2022-08-01 23:41:53'),(16,8,44,8,'Mini Excavators','mini-excavators','Net Power: 13 HP\r\nOperating Weight: 2061 lb\r\nMaximum Digging Depth: 5.68 ft',_binary '<span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br />',NULL,NULL,'2022-01-30 00:02:16','2022-08-01 23:41:53'),(17,9,48,9,'ضاغطات التربة الاهتزازية CP12 GC','ضاغطات-التربة-الاهتزازية-cp12-gc','الوزن التشغيلي - مع هيكل الحماية من الانقلاب (ROPS) / هيكل الحماية من الأجسام المتساقطة (FOPS): 27869 رطل\r\nعرض الضغط: 84 بوصة\r\nإجمالي الطاقة: 120.7 حصان\r\nطراز المحرك: Cat C3.6\r\nقطر الأسطوانة: 60.40 بوصة',_binary '[binary data, 517 characters]',NULL,NULL,'2022-01-30 00:06:16','2022-08-01 23:42:23'),(18,8,45,9,'Vibratory Soil Compactors CP12 GC','vibratory-soil-compactors-cp12-gc','Operating Weight - With ROPS/FOPS: 27869 lb\r\nCompaction Width: 84 in\r\nGross Power: 120.7 HP\r\nEngine Model: Cat C3.6\r\nDrum Diameter: 60.40 in',_binary '<span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br />',NULL,NULL,'2022-01-30 00:06:16','2022-08-01 23:42:23'),(25,9,55,13,'اللوادر بعجل مدمجة 903D','اللوادر-بعجل-مدمجة-903d','الحد الأقصى للقوة الإجمالية: 42 حصان\r\nوزن التشغيل: 9414 رطل\r\nسعات الجرافة: 0.6-1 م 3 (0.8-1.3 ياردة 3)',_binary '[binary data, 519 characters]',NULL,NULL,'2022-01-31 05:35:41','2022-08-01 23:42:50'),(26,8,54,13,'Compact Wheel Loaders 903D','compact-wheel-loaders-903d','Maximum Gross Power: 42 HP\r\nOperating Weight: 9414 lb\r\nBucket Capacities: 0.6-1 m3 (0.8-1.3 yd3)\r\nCat C3.3B DIT EU Stage V/U.S. EPA Tier 4 Final engine.\r\nHeavy duty battery, 12V',_binary '<span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br />',NULL,NULL,'2022-01-31 05:35:41','2022-08-01 23:42:50'),(27,9,53,14,'شاحنات التعدين 797F','شاحنات-التعدين-797f','الحمولة الاسمية المقدرة: 401 طن (الولايات المتحدة)\r\nالوزن الإجمالي للآلة المقدر: 1375000 رطل\r\nإجمالي القدرة - SAE J1995: 4000 حصان\r\nطراز المحرك: Cat® C175-20\r\nصافي القدرة - SAE J1349: 3795 حصان',_binary '[binary data, 526 characters]',NULL,NULL,'2022-07-27 01:32:35','2022-08-01 23:43:22'),(28,8,52,14,'Mining Trucks 797F','mining-trucks-797f','Nominal Rated Payload: 401 ton (US)\r\nRated Gross Machine Weight: 1375000 lb\r\nGross Power - SAE J1995: 4000 HP\r\nEngine Model: Cat® C175-20\r\nNet Power - SAE J1349:	3795 HP',_binary '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-07-27 01:32:35','2022-08-01 23:43:22'),(29,9,58,15,'أقل من 6 م³ شاحنة خلاط','أقل-من-6-م³-شاحنة-خلاط','سعة المزيج: 2-4m³\r\nسعة خزان المياه: 300 لتر\r\nماركة المحرك: Cummins / Yuchai',_binary '[binary data, 526 characters]',NULL,NULL,'2022-08-01 00:16:30','2022-08-01 23:43:56'),(30,8,56,15,'Below 6m³ Truck Mixer','below-6m³-truck-mixer','Mix Capacity: 2 - 4m³\r\nWater Tank Capacity: 300L\r\nEngine Brand: Cummins/Yuchai',_binary '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-08-01 00:16:30','2022-08-28 01:14:13'),(31,9,59,16,'سائق كومة فيرمير PD5','سائق-كومة-فيرمير-pd5','الحد الأقصى لارتفاع الوبر - 15 قدم (4.6 م): 4.7 م\r\nالحد الأقصى لارتفاع التشغيل - 15 قدمًا (4.6 م): 6 م\r\nوزن التشغيل - 15 قدم (4.6 م) الصاري: 4708.3 كجم\r\nطول التشغيل: 2.8 متر\r\nعرض التشغيل: 3.8 متر',_binary '[binary data, 526 characters]',NULL,NULL,'2022-08-01 00:29:34','2022-08-01 23:44:35'),(32,8,57,16,'Vermeer PD5 Pile Driver','vermeer-pd5-pile-driver','Maximum pile height - 15\' (4.6 m) mast: 4.7 m\r\nMaximum operating height - 15\' (4.6 m) mast: 6 m\r\nOperating weight - 15\' (4.6 m) mast: 4708.3 kg\r\nOperating length: 2.8 m\r\nOperating width: 3.8 m',_binary '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-08-01 00:29:34','2022-08-01 23:44:35');

--
-- Table structure for table `equipment_coupons`
--

CREATE TABLE `equipment_coupons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` decimal(8,2) unsigned NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `serial_number` mediumint unsigned NOT NULL,
  `equipments` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `equipment_coupons`
--

INSERT INTO `equipment_coupons` VALUES (11,'Super Offer','Off50','percentage',15.00,'2022-07-12','2022-10-20',2,'[\"9\",\"13\",\"15\"]','2022-01-25 23:32:33','2022-08-27 02:01:42'),(14,'Bumper Sell','Bumper25','fixed',25.00,'2022-07-01','2022-08-31',1,NULL,'2022-02-02 22:45:54','2022-07-27 03:53:40');

--
-- Table structure for table `equipment_reviews`
--

CREATE TABLE `equipment_reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `equipment_id` bigint unsigned NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `rating` smallint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `equipment_reviews_user_id_foreign` (`user_id`),
  KEY `equipment_reviews_equipment_id_foreign` (`equipment_id`),
  CONSTRAINT `equipment_reviews_equipment_id_foreign` FOREIGN KEY (`equipment_id`) REFERENCES `equipments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `equipment_reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `equipment_reviews`
--

INSERT INTO `equipment_reviews` VALUES (11,15,14,NULL,3,'2022-07-28 03:47:54','2022-07-28 03:51:54'),(12,15,8,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.',4,'2022-07-30 05:52:23','2022-07-30 05:52:23'),(13,15,9,'The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.',2,'2022-07-30 05:54:28','2022-07-30 05:54:28');

--
-- Table structure for table `equipment_sections`
--

CREATE TABLE `equipment_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `equipment_sections`
--

INSERT INTO `equipment_sections` VALUES (2,8,'Awesome Equipment','Our Latest Equipment','Amet minim mollit non deserunt ullamco est sit aliqua dolor do amet sint. Velit officia consequat duis enim velit mollit.','2021-12-30 02:58:22','2022-07-27 00:36:07'),(3,9,'معدات رهيبة','أحدث المعدات لدينا','نتيجة لظروف ما قد تكمن السعاده فيما نتحمله م','2022-03-06 00:34:51','2022-08-01 05:52:48');

--
-- Table structure for table `equipments`
--

CREATE TABLE `equipments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `thumbnail_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slider_images` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int unsigned NOT NULL,
  `min_booking_days` int unsigned NOT NULL,
  `max_booking_days` int unsigned NOT NULL,
  `offer` int unsigned DEFAULT NULL,
  `price_btn_status` tinyint unsigned NOT NULL,
  `per_day_price` decimal(8,2) unsigned DEFAULT NULL,
  `per_week_price` decimal(8,2) unsigned DEFAULT NULL,
  `per_month_price` decimal(8,2) unsigned DEFAULT NULL,
  `lowest_price` decimal(8,2) unsigned DEFAULT NULL,
  `is_featured` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `equipments`
--

INSERT INTO `equipments` VALUES (8,'62e0e3e2e67a2.png','[\"62e4d39e6b175.png\",\"62e4d39e70e9b.png\",\"62e4d39e94d39.png\",\"62e4d39e98d0c.png\"]',5,1,7,15,1,NULL,NULL,NULL,NULL,'yes','2022-01-30 00:02:16','2022-08-28 01:18:38'),(9,'62e0e538f22b7.png','[\"62e4cff991ac6.png\",\"62e4cff9980f2.png\",\"62e4cff9c3c37.png\",\"62e4cff9c609a.png\"]',3,5,9,NULL,0,NULL,90.00,120.00,90.00,'yes','2022-01-30 00:06:16','2022-08-28 01:15:12'),(13,'62e0eb252e9bb.png','[\"62e4cc9f948dc.png\",\"62e4cc9f94927.png\",\"62e4cc9fbd3f2.png\",\"62e4cc9fbd3be.png\"]',6,2,10,13,0,50.00,130.00,190.00,50.00,'yes','2022-01-31 05:35:41','2022-08-01 00:29:57'),(14,'62e0ea1305828.png','[\"62e4c8f158364.png\",\"62e4c8f15ceab.png\",\"62e4c8f17f9b5.png\",\"62e4c9ce9db52.png\"]',8,3,7,10,0,60.00,115.00,150.00,60.00,'yes','2022-07-27 01:32:35','2022-07-30 00:04:02'),(15,'62e76fbd89337.png','[\"62e76e3400d90.png\",\"62e76e63c54bd.png\",\"62e76e63cfbdb.png\",\"62e76ea37f777.png\"]',11,5,10,NULL,0,20.00,50.00,100.00,20.00,'no','2022-08-01 00:16:29','2022-08-28 01:17:34'),(16,'62e772cee0d78.png','[\"62e771875426a.png\",\"62e7718763f31.png\",\"62e77191f2e09.png\",\"62e7719203cd0.png\"]',13,3,6,NULL,1,NULL,NULL,NULL,NULL,'no','2022-08-01 00:29:34','2022-08-01 00:29:34');

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

CREATE TABLE `faqs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `question` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial_number` mediumint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `faqs_language_id_foreign` (`language_id`),
  CONSTRAINT `faqs_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `faqs` VALUES (5,8,'How Donec Poseur Velit Fauci bus Auctor?','It is a long-established fact that reader and distracted this is readable content of a page when looking at its layout the point of using labored Ipsum is that it has a Morea normal the most finish distribution text of the printing and typesetting has been the industry.',1,'2021-06-26 00:35:52','2021-12-01 04:03:16'),(6,8,'How Frequently Auctor Quam Vitae Fermtum?','It is a long established fact that reader and distracted this is readabale content of a page when looking at its layoi The point of usineg laiorem Ipsum is that it has a morea normal the most finish distribution text of the printing and typesetting has been the industry.',2,'2021-06-26 00:38:14','2021-06-26 00:38:14'),(7,8,'How Frequently should I See A trainer?','It is a long established fact that reader and distracted this is readabale content of a page when looking at its layoi The point of usineg laiorem Ipsum is that it has a morea normal the most finish distribution text of the printing and typesetting has been the industry.',3,'2021-06-26 00:39:02','2021-06-26 00:39:02'),(10,9,'في سحقت هيروشيما البريطاني يتم, غريمه باحتلال الأيديولوجية،','حشد الثقيل المنتصر ثم, أسر قررت تم. وغير تصفح الحزب واستمر, مشروط الساحلية هذا ان. أما معركة لبلجيكا، من, الألوف الثقيلة الإنجليزية أسر ٣٠. ٣٠ دار أمام أحدث, أما بحشد الهادي الدولارات ما, هو الحزب الصفحة محاولات قبل. وبحلول الخنادق الأوروبية، ان غير, وليرتفع برلين، انه, انتباه الوزراء البولندي تم تلك.',1,'2021-08-29 06:57:35','2021-08-29 06:57:35'),(14,9,'نتيجة لظروف ما قد تكمن السعاده فيما نتحمله','هنالك العديد من الأنواع المتوفرة لنصوص لوريم إيبسوم، ولكن الغالبية تم تعديلها بشكل ما عبر إدخال بعض النوادر أو الكلمات العشوائية إلى النص. إن كنت تريد أن تستخدم نص لوريم إيبسوم ما، عليك أن تتحقق أولاً أن ليس هناك أي كلمات أو عبارات محرجة أو غير لائقة مخبأة في هذا النص. بينما تعمل جميع مولّدات نصوص لوريم إيبسوم على الإنترنت على إعادة تكرار مقاطع من نص لوريم إيبسوم نفسه عدة مرات بما تتطلبه الحاجة، يقوم مولّدنا هذا باستخدام كلمات من قاموس يحوي على أكثر من 200 كلمة لا تينية، مضاف إليها مجموعة من الجمل النموذجية، لتكوين نص لوريم إيبسوم ذو شكل منطقي قريب إلى النص الحقيقي. وبالتالي يكون النص الناتح خالي من التكرار، أو أي كلمات أو عبارات غير لائقة أو ما شابه. وهذا ما يجعله أول مولّد نص لوريم إيبسوم حقيقي على الإنترنت.',2,'2021-12-01 04:04:11','2021-12-01 04:04:11'),(15,9,'للمصممين نص لوريم ايبسوم بالعربي عربي انجليزي','وعند موافقه العميل المبدئيه على التصميم يتم ازالة هذا النص من التصميم ويتم وضع النصوص النهائية المطلوبة للتصميم ويقول البعض ان وضع النصوص التجريبية بالتصميم قد تشغل المشاهد عن وضع الكثير من الملاحظات او الانتقادات للتصميم الاساسي.\r\n\r\nوخلافاَ للاعتقاد السائد فإن لوريم إيبسوم ليس نصاَ عشوائياً، بل إن له جذور في الأدب اللاتيني الكلاسيكي منذ العام 45 قبل الميلاد. من كتاب \"حول أقاصي الخير والشر\"',3,'2021-12-01 04:05:29','2021-12-01 04:05:29');

--
-- Table structure for table `feature_sections`
--

CREATE TABLE `feature_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feature_sections`
--

INSERT INTO `feature_sections` VALUES (1,9,'ميزات رائعة','أحدث الميزات المثيرة لدينا','الجزء القياسي من لوريم إيبسوم المستخدم منذ القرن الخامس عشر مستنسخ أدناه للمهتمين.','2021-12-09 05:11:21','2022-08-01 03:34:15'),(2,8,'Awesome Features','Our Latest & Exciting Features','The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested.','2022-03-06 00:30:42','2022-08-01 03:32:22');

--
-- Table structure for table `features`
--

CREATE TABLE `features` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `features`
--

INSERT INTO `features` VALUES (4,9,'fas fa-hammer','خدمة الدقة','الجزء القياسي من لوريم إيبسوم المستخدم منذ القرن الخامس عشر مستنسخ أدناه للمهتمين.','2021-12-09 06:49:52','2022-08-01 03:34:41'),(5,9,'fas fa-cannabis','السرعة والأمان','الجزء القياسي من لوريم إيبسوم المستخدم منذ القرن الخامس عشر مستنسخ أدناه للمهتمين.','2021-12-09 06:51:31','2022-08-01 03:35:04'),(6,9,'far fa-money-bill-alt','التأثير الاقتصادي','الجزء القياسي من لوريم إيبسوم المستخدم منذ القرن الخامس عشر مستنسخ أدناه للمهتمين.','2021-12-09 06:52:20','2022-08-01 03:35:17'),(7,8,'fas fa-hammer','Precision Service','The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested.','2022-03-06 00:31:30','2022-08-01 03:33:01'),(8,8,'fas fa-cannabis','Fast & Safety','The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested.','2022-03-06 00:32:18','2022-08-01 03:33:21'),(9,8,'far fa-money-bill-alt','Economically Effect','The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested.','2022-03-06 00:33:11','2022-08-01 03:33:40');

--
-- Table structure for table `footer_contents`
--

CREATE TABLE `footer_contents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `about_company` text COLLATE utf8mb4_unicode_ci,
  `copyright_text` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `footer_texts_language_id_foreign` (`language_id`),
  CONSTRAINT `footer_texts_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `footer_contents`
--

INSERT INTO `footer_contents` VALUES (3,8,'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.','Copyright © 2025,  All Rights Reserved.','2022-01-02 23:26:08','2025-02-24 12:42:20'),(4,9,'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها.','حقوق الطبع والنشر © 2022 ، جميع الحقوق محفوظة.','2022-03-06 01:00:32','2022-03-06 01:00:32');

--
-- Table structure for table `guests`
--

CREATE TABLE `guests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `endpoint` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `guests`
--

INSERT INTO `guests` VALUES (91,'https://wns2-sg2p.notify.windows.com/w/?token=BQYAAADXPWyQaPPsNtlcDTXNR1%2fZ9ud4cd6qfiaTlf6rYHOFLjRf%2bwrVb1DOvlzqjXJ%2bOYTa1c022Hrl28LPPVd6YkgQZKrAG2sxrBxqyBHqOjWKNC4tLxTfATy6wLUAT%2fTmFCbTEQJdJzfRZPfpEEAirbsJ5S8mJZ8Tw0W%2b7d6t5adta%2bNTDChBX8hNUe5H%2fmZbBT2NC%2fD1t8GZLLCeXwSvKbNJ2vQXpr3D90G1pEVvNNPSl9epulvV2pq1tEvbRdpx93o3nOMH0ugv%2bhQi0N36O%2f66nvpKPFgZRpn83tqSI%2fN4Bn5xoLfMQgyqYIaOgla2lhk%3d','2022-07-05 06:53:17','2022-07-05 06:53:17'),(92,'https://wns2-sg2p.notify.windows.com/w/?token=BQYAAAACt384PtWJnYwTN9zI6Xgbr94HooEE%2fsU0uKw7qtW%2feLLvu8umI5oGa5MlMlr40dCZL%2b7FSy55XwKMqs%2f%2fzkqDSqz1SXe3pH93ceOZIF2jzacpNCvOSCXVuOSkNmZFMVYF8A4yssOAZU8t074jGHv8hLcH6DXHIjL8RXdY2JARXnNcf7u1WXo6ZYwvZ3GaAg9Exqw7wnq2gMR8b6%2b3ZrSRwZYR9nZ6FPXM06SdM7F2sm1gNuEB%2fZKdibW32QRkZex%2fkMDRcb8yqS3brQ%2fUv1XnhfTosKiD506JeRrJL73TD4ePTw0Lgo2F9VVtdoOktxg%3d','2022-07-06 22:34:37','2022-07-06 22:34:37'),(93,'https://fcm.googleapis.com/fcm/send/c7VW5cKRr1M:APA91bEkIGdALkLnsCyXBr8_-qbRL0aFJM4UDeUfwP1qtAZegF8U5Dcbt2svi6AyJyuiLD5M8CIyOhV8p-LRvYc_7yOzznmXH5PG8fBi1KXEdhSbbw05J5JKbMncyDtwI6rhpcVWUs3z','2022-07-06 23:58:43','2022-07-06 23:58:43');

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` char(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `direction` tinyint NOT NULL,
  `is_default` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (8,'English','en',0,1,'2021-05-31 05:58:22','2022-08-01 00:57:24'),(9,'عربى','ar',1,0,'2021-05-31 05:59:16','2022-08-10 05:34:59'),(10,'Malaysia','my',0,0,'2025-02-24 12:08:07','2025-02-24 12:09:14');

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

CREATE TABLE `locations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `charge` decimal(8,2) unsigned DEFAULT NULL,
  `serial_number` mediumint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` VALUES (8,8,'Washington, California',100.00,1,'2022-01-31 03:06:15','2022-01-31 03:06:15'),(9,8,'Washington, D.C.',150.00,2,'2022-01-31 03:06:56','2022-01-31 03:06:56'),(10,8,'Georgetown, California',200.00,3,'2022-01-31 03:07:46','2022-01-31 03:07:46'),(11,9,'واشنطن ، كاليفورنيا',100.00,1,'2022-03-06 00:48:03','2022-03-06 00:48:03'),(12,9,'واشنطن العاصمة.',150.00,2,'2022-03-06 00:48:41','2022-03-06 00:48:41'),(13,9,'جورج تاون ، كاليفورنيا',200.00,3,'2022-03-06 00:49:02','2022-03-06 00:49:25');

--
-- Table structure for table `mail_templates`
--

CREATE TABLE `mail_templates` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mail_type` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `mail_subject` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `mail_body` blob,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mail_templates`
--

INSERT INTO `mail_templates` VALUES (4,'verify_email','Verify Your Email Address',_binary '[binary data, 234 characters]'),(5,'reset_password','Recover Password of Your Account',_binary '<p>Hi {customer_name},</p><p>We have received a request to reset your password. If you did not make the request, just ignore this email. Otherwise, you can reset your password using this below link.</p><p>{password_reset_link}</p><p>Thanks,<br>{website_title}</p>'),(9,'product_order','Product Order Has Been Placed',_binary '[binary data, 212 characters]'),(10,'equipment_booking','Confirmation of Equipment Booking',_binary '<p style=\"font-family:Lato, sans-serif;font-size:14px;line-height:1.82;color:rgb(0,0,0);font-style:normal;font-weight:400;text-align:left;\">Hi {customer_name},</p><p style=\"font-family:Lato, sans-serif;font-size:14px;line-height:1.82;color:rgb(0,0,0);font-style:normal;font-weight:400;text-align:left;\">This email is to confirm your booking #{booking_number} on {booking_date} for a {equipment_name}. The booking start date shall be on {start_date} and the booking end date shall be on {end_date}.</p><p style=\"font-family:Lato, sans-serif;font-size:14px;line-height:1.82;color:rgb(0,0,0);font-style:normal;font-weight:400;text-align:left;\">{booking_link}<br /></p><p style=\"font-family:Lato, sans-serif;font-size:14px;line-height:1.82;color:rgb(0,0,0);font-style:normal;font-weight:400;text-align:left;\">We have also attached an invoice in this mail. If you have any inquiries, please don\'t hesitate to contact us.<br /></p><p style=\"font-family:Lato, sans-serif;font-size:14px;line-height:1.82;color:rgb(0,0,0);font-style:normal;font-weight:400;text-align:left;\">Best Regards.<br />{website_title}</p>');

--
-- Table structure for table `menu_builders`
--

CREATE TABLE `menu_builders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `menus` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_builders`
--

INSERT INTO `menu_builders` VALUES (1,9,'[{\"type\":\"home\",\"text\":\"الصفحة الرئيسية\",\"target\":\"_self\"},{\"type\":\"equipment\",\"text\":\"ادوات\",\"target\":\"_self\"},{\"type\":\"custom\",\"text\":\"محل\",\"href\":\"\",\"target\":\"_self\",\"children\":[{\"type\":\"products\",\"text\":\"منتجات\",\"target\":\"_self\"},{\"type\":\"cart\",\"text\":\"عربة التسوق\",\"target\":\"_self\"}]},{\"type\":\"custom\",\"text\":\"الصفحات\",\"href\":\"\",\"target\":\"_self\",\"children\":[{\"type\":\"معلومات-عنا\",\"text\":\"معلومات عنا\",\"target\":\"_self\"},{\"type\":\"البنود-و-الظروف\",\"text\":\"البنود و الظروف\",\"target\":\"_self\"}]},{\"type\":\"blog\",\"text\":\"مقالات\",\"target\":\"_self\"},{\"type\":\"faq\",\"text\":\"التعليمات\",\"target\":\"_self\"},{\"type\":\"contact\",\"text\":\"اتصل\",\"target\":\"_self\"}]','2021-11-18 04:50:31','2022-08-01 05:03:14'),(2,8,'[{\"type\":\"home\",\"text\":\"Home\",\"target\":\"_self\"},{\"type\":\"equipment\",\"text\":\"Equipment\",\"target\":\"_self\"},{\"type\":\"custom\",\"text\":\"Shop\",\"href\":\"\",\"target\":\"_self\",\"children\":[{\"type\":\"products\",\"text\":\"Products\",\"target\":\"_self\"},{\"type\":\"cart\",\"text\":\"Cart\",\"target\":\"_self\"}]},{\"type\":\"custom\",\"text\":\"Pages\",\"href\":\"\",\"target\":\"_self\",\"children\":[{\"type\":\"about-us\",\"text\":\"About Us\",\"target\":\"_self\"},{\"type\":\"terms-&-conditions\",\"text\":\"Terms & Conditions\",\"target\":\"_self\"}]},{\"type\":\"blog\",\"text\":\"Blog\",\"target\":\"_self\"},{\"type\":\"faq\",\"text\":\"FAQ\",\"target\":\"_self\"},{\"type\":\"contact\",\"text\":\"Contact\",\"target\":\"_self\"}]','2021-12-01 05:32:09','2022-08-01 05:00:28');

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `offline_gateways`
--

CREATE TABLE `offline_gateways` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text COLLATE utf8mb4_unicode_ci,
  `instructions` longtext COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0 -> gateway is deactive, 1 -> gateway is active.',
  `has_attachment` tinyint(1) NOT NULL COMMENT '0 -> do not need attachment, 1 -> need attachment.',
  `serial_number` mediumint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `offline_gateways`
--

INSERT INTO `offline_gateways` VALUES (2,'Citibank','A pioneer of both the credit card industry and automated teller machines, Citibank – formerly the City Bank of New York.','<p><span style=\"color:rgb(51,51,51);font-family:\'proxima-nova\', sans-serif;font-size:16px;\">A pioneer of both the credit card industry and automated teller machines, </span><a href=\"https://smartasset.com/checking-account/Citibank-banking-review\">Citibank</a><span style=\"color:rgb(51,51,51);font-family:\'proxima-nova\', sans-serif;font-size:16px;\"> –\r\n formerly the City Bank of New York – was regarded as an East Coast \r\nequivalent to Wells Fargo during the 19th century.</span><br></p>',1,0,1,'2021-07-16 22:41:59','2022-01-23 00:11:01'),(3,'Bank of America','Bank of America has 4,265 branches in the country, only about 700 fewer than Chase. It started as a small institution serving immigrants in San Francisco.','<p><span style=\"color:rgb(51,51,51);font-family:\'proxima-nova\', sans-serif;font-size:16px;\">With $1.8 trillion in consolidated assets, </span><a href=\"https://smartasset.com/checking-account/bank-of-america-review\">Bank of America</a><span style=\"color:rgb(51,51,51);font-family:\'proxima-nova\', sans-serif;font-size:16px;\"> is\r\n second on the list. Its headquarters in Charlotte, North Carolina, \r\nsinglehandedly makes that city one of the biggest financial centers in \r\nthe country.</span><br></p>',1,1,2,'2021-07-16 22:43:19','2021-07-16 22:43:19');

--
-- Table structure for table `online_gateways`
--

CREATE TABLE `online_gateways` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `keyword` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `information` mediumtext COLLATE utf8mb4_general_ci NOT NULL,
  `status` tinyint unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `online_gateways`
--

INSERT INTO `online_gateways` VALUES (1,'PayPal','paypal','{\"sandbox_status\":\"1\",\"client_id\":\"\",\"client_secret\":\"\"}',1),(2,'Instamojo','instamojo','{\"sandbox_status\":\"1\",\"key\":\"\",\"token\":\"\"}',1),(3,'Paystack','paystack','{\"key\":\"\"}',1),(4,'Flutterwave','flutterwave','{\"public_key\":\"\",\"secret_key\":\"\"}',1),(5,'Razorpay','razorpay','{\"key\":\"\",\"secret\":\"\"}',1),(6,'MercadoPago','mercadopago','{\"sandbox_status\":\"1\",\"token\":\"\"}',1),(7,'Mollie','mollie','{\"key\":\"\"}',1),(8,'Stripe','stripe','{\"key\":\"pk_test_UnU1Coi1p5qFGwtpjZMRMgJM\",\"secret\":\"sk_test_QQcg3vGsKRPlW6T3dXcNJsor\"}',1),(9,'Paytm','paytm','{\"environment\":\"local\",\"merchant_key\":\"\",\"merchant_mid\":\"\",\"merchant_website\":\"\",\"industry_type\":\"\"}',1);

--
-- Table structure for table `page_contents`
--

CREATE TABLE `page_contents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `page_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` blob NOT NULL,
  `meta_keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `page_contents_language_id_foreign` (`language_id`),
  KEY `page_contents_page_id_foreign` (`page_id`),
  CONSTRAINT `page_contents_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `page_contents_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `page_contents`
--

INSERT INTO `page_contents` VALUES (30,9,14,'البنود و الظروف','البنود-و-الظروف',_binary '[binary data, 830 characters]',NULL,NULL,'2021-10-18 02:33:45','2022-03-06 05:12:50'),(31,8,14,'Terms & Conditions','terms-&-conditions',_binary '<p><span style=\"color:rgb(102,102,102);font-family:Roboto;font-size:16px;font-style:normal;font-weight:400;text-align:left;background-color:rgb(255,255,255);\">On the other hand, we denounce with righteous indignation and dislike men who are so beguiled and demoralized by the charms of pleasure of the moment, so blinded by desire, that they cannot foresee the pain and trouble that are bound to ensue; and equal blame belongs to those who fail in their duty through weakness of will, which is the same as saying through shrinking from toil and pain. These cases are perfectly simple and easy to distinguish. In a free hour, when our power of choice is untrammeled and when nothing prevents our being able to do what we like best, every pleasure is to be welcomed and every pain avoided. But in certain circumstances and owing to the claims of duty or the obligations of business it will frequently occur that pleasures have to be repudiated and annoyances accepted. The wise man therefore always holds in these matters to this principle of selection: he rejects pleasures to secure other greater pleasures, or else he endures pains to avoid worse pains.</span></p>',NULL,NULL,'2021-10-18 02:33:45','2021-12-01 04:07:54'),(41,9,19,'معلومات عنا','معلومات-عنا',_binary '[binary data, 902 characters]',NULL,NULL,'2022-07-30 05:33:25','2022-08-02 00:55:09'),(42,8,19,'About Us','about-us',_binary '<p><span style=\"color:rgb(102,102,102);font-family:Roboto;font-size:16px;\">On the other hand, we denounce with righteous indignation and dislike men who are so beguiled and demoralized by the charms of pleasure of the moment, so blinded by desire, that they cannot foresee the pain and trouble that are bound to ensue; and equal blame belongs to those who fail in their duty through weakness of will, which is the same as saying through shrinking from toil and pain. These cases are perfectly simple and easy to distinguish. In a free hour, when our power of choice is untrammeled and when nothing prevents our being able to do what we like best, every pleasure is to be welcomed and every pain avoided. But in certain circumstances and owing to the claims of duty or the obligations of business it will frequently occur that pleasures have to be repudiated and annoyances accepted. The wise man therefore always holds in these matters to this principle of selection: he rejects pleasures to secure other greater pleasures, or else he endures pains to avoid worse pains.</span><br /></p>',NULL,NULL,'2022-07-30 05:33:25','2022-08-01 04:53:01');

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

CREATE TABLE `pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` tinyint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pages` VALUES (14,1,'2021-10-18 02:33:45','2021-10-18 02:33:45'),(19,1,'2022-07-30 05:33:25','2022-07-30 05:33:25');

--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial_number` smallint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partners`
--

INSERT INTO `partners` VALUES (8,'61d17f5e76212.png','http://example.com/',1,'2022-01-02 04:33:02','2022-07-06 23:24:01'),(9,'61d17f68437f9.png','http://example.com/',2,'2022-01-02 04:33:12','2022-07-06 23:21:13'),(10,'61d17f724771f.png','http://example.com/',3,'2022-01-02 04:33:22','2022-07-06 23:24:33'),(11,'61d17f8069bc7.png','http://example.com/',4,'2022-01-02 04:33:36','2022-07-06 23:25:11'),(12,'61d17f8ba9ef8.png','http://example.com/',5,'2022-01-02 04:33:47','2022-07-06 23:19:30'),(17,'61d17f68437f9.png','http://example.com/',6,'2022-01-02 04:33:12','2022-07-06 23:21:13');

--
-- Table structure for table `popups`
--

CREATE TABLE `popups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `type` smallint unsigned NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `background_color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `background_color_opacity` decimal(3,2) unsigned DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `button_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `delay` int unsigned NOT NULL COMMENT 'value will be in milliseconds',
  `serial_number` mediumint unsigned NOT NULL,
  `status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '0 => deactive, 1 => active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `popups_language_id_foreign` (`language_id`),
  CONSTRAINT `popups_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `popups`
--

INSERT INTO `popups` VALUES (7,8,1,'63035116cdbb8.png','Super Sale',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1500,1,0,'2021-08-10 05:05:12','2022-08-22 04:07:58'),(8,8,2,'630353e579d10.png','Month End Sale','000000',0.70,'ENJOY 10% OFF','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua.','Shop Now','000000','http://example.com/',NULL,NULL,2000,2,0,'2021-08-10 05:07:11','2022-08-22 04:14:19'),(10,8,3,'6303575ae73a2.png','Summer Sale','FF8C00',0.85,'Newsletter','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua.','Subscribe','FF8C00',NULL,NULL,NULL,2000,3,0,'2021-08-11 05:42:11','2022-08-22 04:17:27'),(11,8,4,'630358d59cd94.png','Winter Offer',NULL,NULL,'Get 10% off your first order','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt','Shop Now','FF8C00','http://example.com/',NULL,NULL,1500,4,0,'2021-08-11 06:38:08','2022-08-22 04:23:05'),(12,8,5,'6303592c51003.png','Winter Sale',NULL,NULL,'Get 10% off your first order','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt','Subscribe','F8960D',NULL,NULL,NULL,2000,5,1,'2021-08-11 06:44:26','2022-09-01 05:31:05'),(13,8,6,'63035e25b0dce.png','New Arrivals Sale',NULL,NULL,'Hurry, Sales Ends This Friday','This is your last chance to save 30%','Yes, I Want to Save 30%','F4A460','http://example.com/','2024-07-25','10:00:00',2000,6,0,'2021-08-11 06:48:52','2022-08-22 04:45:43'),(14,8,7,'63035bac6f1e1.png','Flash Sale','CD853F',NULL,'Hurry, Sale Ends This Friday','This is your last chance to save 30%','Yes, I Want to Save 30%','F4A460','http://example.com/','2025-01-14','12:00:00',1500,7,1,'2021-08-11 07:15:16','2022-08-22 04:45:45'),(19,9,1,'61a6f917913f2.jpg','الجمعة السوداء',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1500,1,0,'2021-11-30 22:24:55','2022-08-20 01:17:50');

--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint unsigned NOT NULL,
  `serial_number` mediumint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_categories_language_id_foreign` (`language_id`),
  CONSTRAINT `product_categories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_categories`
--

INSERT INTO `product_categories` VALUES (27,8,'Cordless Tools','cordless-tools',1,1,'2022-01-05 23:32:06','2022-08-27 23:40:53'),(28,8,'Generator','generator',1,2,'2022-01-05 23:32:19','2022-08-27 23:41:02'),(30,9,'أدوات لاسلكية','أدوات-لاسلكية',1,1,'2022-01-05 23:34:56','2022-08-27 23:41:28'),(31,9,'مولد كهرباء','مولد-كهرباء',1,2,'2022-01-05 23:35:23','2022-08-27 23:41:37'),(34,8,'SAW','saw',1,3,'2022-01-10 01:24:32','2022-08-27 23:41:05'),(35,9,'منشار','منشار',1,3,'2022-01-10 01:25:26','2022-08-27 23:41:40'),(42,8,'Grinders & Polishers','grinders-&-polishers',1,4,'2022-07-27 05:32:22','2022-08-27 23:41:07'),(43,9,'المطاحن وأجهزة التلميع','المطاحن-وأجهزة-التلميع',1,4,'2022-07-27 05:32:43','2022-08-27 23:41:44'),(48,8,'Book','book',1,5,'2022-08-22 05:19:53','2022-08-27 23:41:10'),(49,9,'الكتاب','الكتاب',1,5,'2022-08-22 05:20:20','2022-08-27 23:41:47');

--
-- Table structure for table `product_contents`
--

CREATE TABLE `product_contents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `product_category_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `summary` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_contents_language_id_foreign` (`language_id`),
  KEY `product_contents_product_category_id_foreign` (`product_category_id`),
  KEY `product_contents_product_id_foreign` (`product_id`),
  CONSTRAINT `product_contents_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_contents_product_category_id_foreign` FOREIGN KEY (`product_category_id`) REFERENCES `product_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_contents_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_contents`
--

INSERT INTO `product_contents` VALUES (41,9,30,21,'آلة الحفر','آلة-الحفر','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','<div style=\"text-align:justify;\"><font>لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</font></div>',NULL,NULL,'2022-01-09 02:37:18','2022-08-01 04:34:23'),(42,8,27,21,'Drill Machine','drill-machine','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-01-09 02:37:18','2022-08-01 04:34:23'),(45,9,35,24,'المنشار','المنشار','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','<span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br />',NULL,NULL,'2022-01-10 02:34:41','2022-08-01 04:36:19'),(46,8,34,24,'Chainsaw','chainsaw','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br />',NULL,NULL,'2022-01-10 02:34:41','2022-08-01 04:36:19'),(47,9,31,25,'مولد كهرباء','مولد-كهرباء','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','<div style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.<br /></div>',NULL,NULL,'2022-01-10 02:46:56','2022-08-01 04:36:55'),(48,8,28,25,'Generator','generator','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br />',NULL,NULL,'2022-01-10 02:46:56','2022-08-01 04:36:55'),(55,9,35,29,'منشار دائري','منشار-دائري','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>',NULL,NULL,'2022-07-27 05:01:20','2022-08-01 04:37:48'),(56,8,34,29,'Circular saw','circular-saw','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-07-27 05:01:20','2022-08-01 04:37:48'),(57,9,43,30,'آلة طحن','آلة-طحن','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>',NULL,NULL,'2022-07-27 05:34:55','2022-08-01 04:39:09'),(58,8,42,30,'Grinding Machine','grinding-machine','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-07-27 05:34:55','2022-08-01 04:39:09'),(59,9,30,31,'كل ذلك في صندوق أدوات واحد','كل-ذلك-في-صندوق-أدوات-واحد','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>',NULL,NULL,'2022-07-30 01:08:41','2022-08-01 04:40:14'),(60,8,27,31,'All in One Tool Box','all-in-one-tool-box','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-07-30 01:08:41','2022-08-01 04:40:14'),(61,9,30,32,'كاتنج بلس','كاتنج-بلس','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>',NULL,NULL,'2022-07-30 01:12:56','2022-08-01 04:41:20'),(62,8,27,32,'Cutting Plus','cutting-plus','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-07-30 01:12:56','2022-08-01 04:41:20'),(63,9,30,33,'جهاز رقمي متعدد','جهاز-رقمي-متعدد','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>',NULL,NULL,'2022-07-30 01:16:18','2022-08-01 04:42:13'),(64,8,27,33,'Digital Multimeter','digital-multimeter','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-07-30 01:16:18','2022-08-01 04:42:13'),(65,9,43,34,'غسالة بوش AQT 37-13 Plus 1700 وات للمنزل والسيارة','غسالة-بوش-aqt-37-13-plus-1700-وات-للمنزل-والسيارة','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>',NULL,NULL,'2022-07-30 01:20:40','2022-08-01 04:43:01'),(66,8,42,34,'Bosch AQT 37-13 Plus 1700-Watt Home and Car Washer','bosch-aqt-37-13-plus-1700-watt-home-and-car-washer','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-07-30 01:20:40','2022-08-01 04:43:01'),(67,9,31,35,'ماكينة لحام SEALEY Professional Mighty MIG','ماكينة-لحام-sealey-professional-mighty-mig','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>',NULL,NULL,'2022-07-30 01:26:15','2022-08-01 04:43:54'),(68,8,28,35,'SEALEY Professional Mighty MIG Welder','sealey-professional-mighty-mig-welder','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-07-30 01:26:15','2022-08-01 04:43:54'),(77,8,48,40,'Manual Guide','manual-guide','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-08-22 05:19:24','2022-08-22 05:21:10'),(78,9,49,40,'دليل اليدوي','دليل-اليدوي','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>',NULL,NULL,'2022-08-22 05:19:24','2022-08-22 05:21:10'),(79,8,48,41,'User Manual Book','user-manual-book','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>',NULL,NULL,'2022-08-22 05:49:18','2022-08-22 05:49:18'),(80,9,49,41,'كتاب دليل المستخدم','كتاب-دليل-المستخدم','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>',NULL,NULL,'2022-08-22 05:49:18','2022-08-22 05:49:18');

--
-- Table structure for table `product_coupons`
--

CREATE TABLE `product_coupons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` decimal(8,2) unsigned NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `minimum_spend` decimal(8,2) unsigned DEFAULT NULL,
  `serial_number` mediumint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_coupons`
--

INSERT INTO `product_coupons` VALUES (7,'Sell30','Sell30','fixed',30.00,'2022-07-01','2022-08-31',NULL,1,'2022-01-05 22:25:33','2022-08-27 06:04:39'),(8,'WinterSell','WinterSell','percentage',25.00,'2022-07-19','2022-10-20',50.00,2,'2022-01-05 22:27:46','2022-08-28 05:56:20'),(9,'FridaySell','FridaySell','fixed',20.00,'2021-12-25','2021-12-31',NULL,3,'2022-01-05 22:29:40','2022-01-05 22:29:40');

--
-- Table structure for table `product_orders`
--

CREATE TABLE `product_orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `order_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_contact_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_contact_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` decimal(8,2) unsigned NOT NULL,
  `discount` decimal(8,2) unsigned DEFAULT NULL,
  `product_shipping_charge_id` bigint unsigned DEFAULT NULL,
  `shipping_cost` decimal(8,2) unsigned DEFAULT NULL,
  `tax` decimal(8,2) unsigned NOT NULL,
  `grand_total` decimal(8,2) unsigned NOT NULL,
  `currency_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_text_position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_symbol` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_symbol_position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gateway_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_orders_user_id_foreign` (`user_id`),
  CONSTRAINT `product_orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=176 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_orders`
--

INSERT INTO `product_orders` VALUES (173,15,'630c6d7d506b3','Robert','Fonseca','robert@gmail.com','715-396-9284','1470 King St','Bellingham','Washington','United States','Robert','Fonseca','robert@gmail.com','715-396-9284','1470 King St','Bellingham','Washington','United States',165.00,0.00,5,0.00,8.25,173.25,'USD','left','$','left','Citibank','offline','completed','rejected',NULL,'630c6d7d506b3.pdf','2022-08-29 01:40:45','2022-10-09 01:22:34'),(174,15,'63415be618de6','Robert','Fonseca','robert@gmail.com','715-396-9284','1470 King St','Bellingham','Washington','United States','Robert','Fonseca','robert@gmail.com','715-396-9284','1470 King St','Bellingham','Washington','United States',25.00,0.00,5,0.00,1.25,26.25,'USD','left','$','left','PayPal','online','completed','completed',NULL,'63415be618de6.pdf','2022-10-08 05:15:50','2022-10-09 01:23:33'),(175,17,'67beb14c6b306','Jack','Lim','Dafe20000@yahoo.com','0169194972','37, Jalan Temenggung 3/9, Bandar Mahkota','Cheras','Selangor','Malaysia','Jack','Lim','Dafe20000@yahoo.com','0169194972','37, Jalan Temenggung 3/9, Bandar Mahkota','Cheras','Selangor','Malaysia',190.00,0.00,5,0.00,9.50,199.50,'MYR','left','RM','left','Bank of America','offline','pending','pending','67beb14c63a06.jpeg',NULL,'2025-02-26 04:14:36','2025-02-26 04:14:36');

--
-- Table structure for table `product_purchase_items`
--

CREATE TABLE `product_purchase_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_order_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_purchase_items_product_order_id_foreign` (`product_order_id`),
  KEY `product_purchase_items_product_id_foreign` (`product_id`),
  CONSTRAINT `product_purchase_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_purchase_items_product_order_id_foreign` FOREIGN KEY (`product_order_id`) REFERENCES `product_orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=275 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_purchase_items`
--

INSERT INTO `product_purchase_items` VALUES (271,173,41,'User Manual Book',1,'2022-08-29 01:40:45','2022-08-29 01:40:45'),(272,173,34,'Bosch AQT 37-13 Plus 1700-Watt Home and Car Washer',1,'2022-08-29 01:40:45','2022-08-29 01:40:45'),(273,174,33,'Digital Multimeter',1,'2022-10-08 05:15:50','2022-10-08 05:15:50'),(274,175,25,'Generator',1,'2025-02-26 04:14:36','2025-02-26 04:14:36');

--
-- Table structure for table `product_reviews`
--

CREATE TABLE `product_reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `rating` smallint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_reviews_user_id_foreign` (`user_id`),
  KEY `product_reviews_product_id_foreign` (`product_id`),
  CONSTRAINT `product_reviews_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_reviews`
--

INSERT INTO `product_reviews` VALUES (9,15,25,'.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn',5,'2022-07-28 04:02:57','2022-07-28 04:02:57'),(10,15,30,'The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.',3,'2022-07-30 05:48:05','2022-07-30 05:48:05'),(11,15,35,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.',4,'2022-07-30 05:51:04','2022-07-30 05:51:04');

--
-- Table structure for table `product_sections`
--

CREATE TABLE `product_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_sections`
--

INSERT INTO `product_sections` VALUES (2,8,'Featured Products','Best Quality Product','Amet minim mollit non deserunt ullamco est sit aliqua dolor do amet sint. Velit officia consequat duis enim velit mollit.','2022-02-28 04:27:50','2022-07-30 04:54:33'),(3,9,'أفضل منتج عالي الجودة','منتجات مميزة','تبرع: إن كنت تستخدم هذا الموقع بشكل دائم وترغب في مساعدته، أرجو التبرع ولو بمبلغ بسيط للمساعدة في دفع أجور استضافة الموقع وأجور نقل البيانات. لا يوجد حد أدنى للتبرع، سنكون ممتنين لأي مبلغ','2022-03-06 00:36:22','2022-03-06 00:36:22');

--
-- Table structure for table `product_shipping_charges`
--

CREATE TABLE `product_shipping_charges` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_charge` decimal(8,2) unsigned NOT NULL,
  `serial_number` smallint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shipping_charges_language_id_foreign` (`language_id`),
  CONSTRAINT `shipping_charges_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_shipping_charges`
--

INSERT INTO `product_shipping_charges` VALUES (5,8,'Free Shipping','Shipment will be within 10-15 Days.',0.00,1,'2021-07-04 00:31:50','2021-07-19 01:33:50'),(6,8,'Standard Shipping','Shipment will be within 5-10 Day.',5.00,2,'2021-07-04 00:32:40','2021-07-04 00:32:40'),(7,8,'2-Day Shipping','Shipment will be within 2 Days.',10.00,3,'2021-07-04 00:33:24','2021-07-04 00:33:24'),(8,8,'Same Day Shipping','Shipment will be within 1 Day.',20.00,4,'2021-07-04 00:34:09','2021-07-04 00:34:09'),(9,9,'الشحن مجانا','ستكون الشحنة في غضون 10-15 يومًا.',0.00,1,'2021-08-29 06:09:43','2021-08-29 06:09:43'),(10,9,'شحن قياسي','سيتم الشحن في غضون 5-10 يوم.',5.00,2,'2021-08-29 06:11:01','2021-08-29 06:11:01'),(11,9,'شحن لمدة يومين','ستكون الشحنة في غضون يومين.',10.00,3,'2021-08-29 06:12:14','2021-08-29 06:12:14'),(12,9,'نفس الشحن يوم','ستكون الشحنة في غضون يوم واحد.',20.00,4,'2021-08-29 06:13:30','2021-08-29 06:13:30');

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

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `featured_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slider_images` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `input_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stock` int unsigned DEFAULT NULL,
  `sku` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_price` decimal(8,2) unsigned NOT NULL,
  `previous_price` decimal(8,2) unsigned DEFAULT NULL,
  `average_rating` decimal(4,2) unsigned DEFAULT '0.00',
  `is_featured` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` VALUES (21,'physical','62e1174b98d08.png','[\"62e117448087c.png\",\"62e11744865b8.png\",\"62e11744b2c86.png\",\"62e11744b30a5.png\"]','show',NULL,NULL,NULL,12,'DRI-RED-987',75.00,120.00,0.00,'yes','2022-01-09 02:37:18','2022-08-29 01:32:29'),(24,'physical','62e117999c388.png','[\"62e117a89a6d3.png\",\"62e117a89d0bd.png\",\"62e117a8c6695.png\",\"62e117a8c6bf0.png\"]','show',NULL,NULL,NULL,20,'SAW-ORG-789',300.00,350.00,0.00,'yes','2022-01-10 02:34:41','2022-08-21 06:41:57'),(25,'physical','62e118a917c6f.png','[\"62e1184ee7aa6.png\",\"62e1184eeb4ef.png\",\"62e1184f2b0cb.png\",\"62e1184f2b1f5.png\"]','show',NULL,NULL,NULL,5,'GEN-YEL-678',190.00,NULL,5.00,'yes','2022-01-10 02:46:55','2025-02-26 04:14:36'),(29,'physical','62e11b00a9484.png','[\"62e11a8d9b428.png\",\"62e11a8da0be6.png\",\"62e11a8dc52ad.png\",\"62e11a8dc97eb.png\"]','show',NULL,NULL,NULL,24,'SAW-RED-678',45.00,NULL,0.00,'yes','2022-07-27 05:01:20','2022-10-05 06:13:51'),(30,'physical','62e122deadfd4.png','[\"62e1226f75348.png\",\"62e1226f75345.png\",\"62e1226f9db5f.png\",\"62e1226fa1737.png\"]','show',NULL,NULL,NULL,17,'GRI-BLU-567',89.00,129.00,3.00,'yes','2022-07-27 05:34:54','2022-10-04 10:48:26'),(31,'physical','62e4d8f9a5dbe.png','[\"62e4d852dd5c8.png\",\"62e4d852dd5eb.png\",\"62e4d8530e69f.png\",\"62e4d85311dcb.png\"]','show',NULL,NULL,NULL,27,'BOX-BLA-456',79.00,NULL,0.00,'no','2022-07-30 01:08:41','2022-08-29 01:07:10'),(32,'physical','62e4d9f8766f7.png','[\"62e4d98bd1320.png\",\"62e4d98bd3661.png\",\"62e4d98c04329.png\",\"62e4d98c078ea.png\"]','show',NULL,NULL,NULL,8,'PLU-RED-345',15.00,20.00,0.00,'no','2022-07-30 01:12:56','2022-10-05 06:13:51'),(33,'physical','62e4dac2ade7a.png','[\"62e4da4fa88d2.png\",\"62e4da4fa9386.png\",\"62e4da4fd463d.png\",\"62e4da4fd47e6.png\"]','show',NULL,NULL,NULL,29,'MUL-ORA-345',25.00,29.00,0.00,'no','2022-07-30 01:16:18','2022-10-09 01:23:33'),(34,'physical','62e4dbc8b0922.png','[\"62e4db5eb2bbb.png\",\"62e4db5eb403c.png\",\"62e4db5ed9444.png\",\"62e4db5edcd14.png\"]','show',NULL,NULL,NULL,15,'POL-YEL-234',150.00,165.00,0.00,'no','2022-07-30 01:20:40','2022-10-09 01:22:34'),(35,'physical','62e4dd175f0d5.png','[\"62e4dc6fdf7e8.png\",\"62e4dc6fe2363.png\",\"62e4dc7013ad0.png\",\"62e4dc701962b.png\"]','show',NULL,NULL,NULL,16,'GEN-RED-123',250.00,NULL,4.00,'no','2022-07-30 01:26:15','2022-10-10 06:29:30'),(40,'digital','63036c1d345c5.png','[\"6303656c0f0e5.png\",\"6303656c16c32.png\",\"6303656c34881.png\",\"6303656c3c723.png\"]','show','link',NULL,'http://www.example.com/',NULL,NULL,10.00,NULL,0.00,'no','2022-08-22 05:19:23','2022-08-22 05:44:29'),(41,'digital','630464edbee87.png','[\"63036cc7147dd.png\",\"63036cc717322.png\",\"63036cc73a2ac.png\",\"63036cc73c1d1.png\"]','show','link',NULL,'http://www.example.com/',NULL,NULL,15.00,23.00,0.00,'no','2022-08-22 05:49:18','2022-08-22 23:26:05');

--
-- Table structure for table `quick_links`
--

CREATE TABLE `quick_links` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial_number` smallint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quick_links_language_id_foreign` (`language_id`),
  CONSTRAINT `quick_links_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quick_links`
--

INSERT INTO `quick_links` VALUES (3,8,'Privacy & Policy','http://example.com/',1,'2021-06-22 22:52:38','2021-12-01 04:14:35'),(4,8,'About Me','http://example.com/',2,'2021-06-22 22:53:09','2021-12-01 04:14:55'),(5,8,'Contact','https://equipement.dugasoill.com/contact',3,'2021-06-22 22:53:27','2025-02-24 12:43:25'),(6,9,'سياسة خاصة','http://example.com/',1,'2021-08-29 07:04:05','2021-12-01 04:16:18'),(7,9,'عني','http://example.com/',2,'2021-08-29 07:06:32','2021-12-01 04:16:34'),(8,9,'اتصل','http://example.com/',3,'2021-08-29 07:08:21','2021-12-01 04:16:52');

--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_permissions`
--

INSERT INTO `role_permissions` VALUES (4,'Admin','[\"Language Management\",\"Basic Settings\",\"Home Page\",\"Instructors\",\"Course Management\",\"Course Enrolments\",\"FAQ Management\",\"Footer\"]','2021-08-06 22:42:38','2021-11-24 23:20:08'),(6,'Moderator','[\"Basic Settings\",\"Home Page\",\"Course Enrolments\",\"Blog Management\",\"FAQ Management\",\"Advertisements\",\"Footer\"]','2021-08-07 22:14:34','2021-11-24 22:15:07'),(14,'Supervisor','null','2021-11-24 22:48:53','2022-02-26 05:23:44');

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `about_section_status` tinyint unsigned NOT NULL DEFAULT '1',
  `work_process_section_status` tinyint unsigned NOT NULL DEFAULT '1',
  `feature_section_status` tinyint unsigned NOT NULL DEFAULT '1',
  `counter_section_status` tinyint unsigned NOT NULL DEFAULT '1',
  `equipment_section_status` tinyint unsigned NOT NULL DEFAULT '1',
  `testimonial_section_status` tinyint unsigned NOT NULL DEFAULT '1',
  `product_section_status` tinyint unsigned NOT NULL DEFAULT '1',
  `call_to_action_section_status` tinyint unsigned NOT NULL DEFAULT '1',
  `blog_section_status` tinyint unsigned NOT NULL DEFAULT '1',
  `partner_section_status` tinyint unsigned NOT NULL DEFAULT '1',
  `subscribe_section_status` tinyint unsigned NOT NULL DEFAULT '1',
  `footer_section_status` tinyint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` VALUES (2,1,1,1,1,1,1,1,1,1,1,1,1,NULL,'2022-08-20 22:43:25');

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

CREATE TABLE `sliders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `background_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sliders` VALUES (4,9,'61d2debbeb6a3.jpg','أفضل معدات البناء','هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها.','2022-01-03 05:32:11','2022-08-01 03:16:15'),(5,9,'61d2ded1081e7.jpg','أفضل معدات البناء','هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها.','2022-01-03 05:32:33','2022-08-01 03:16:41'),(7,8,'622451c1def30.jpg','Best Construction Equipment','It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.','2022-03-06 00:16:33','2022-10-05 00:40:42'),(8,8,'622451f123a55.jpg','Best Construction Equipment','It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.','2022-03-06 00:17:21','2022-08-01 03:15:27');

--
-- Table structure for table `social_medias`
--

CREATE TABLE `social_medias` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial_number` mediumint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `social_medias`
--

INSERT INTO `social_medias` VALUES (36,'fab fa-facebook-f','http://example.com/',1,'2021-11-20 03:01:42','2021-11-20 03:01:42'),(37,'fab fa-twitter','http://example.com/',3,'2021-11-20 03:03:22','2021-11-20 03:03:22'),(38,'fab fa-linkedin-in','http://example.com/',2,'2021-11-20 03:04:29','2021-11-20 03:04:29');

--
-- Table structure for table `static_sections`
--

CREATE TABLE `static_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `button_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `static_sections`
--

INSERT INTO `static_sections` VALUES (3,9,'أفضل معدات البناء','هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها.','يكتشف','http://example.com/','2022-02-28 00:24:35','2022-08-01 03:22:23'),(4,8,'Best Construction Equipment','It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.','Discover','http://example.com/','2022-03-06 00:18:59','2022-08-01 03:21:48');

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscribers_email_id_unique` (`email_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscribers`
--

INSERT INTO `subscribers` VALUES (1,'dafe20000@yahoo.com','2025-02-24 12:58:55','2025-02-24 12:58:55'),(2,'admin@gmail.com','2025-02-24 13:04:12','2025-02-24 13:04:12');

--
-- Table structure for table `testimonial_sections`
--

CREATE TABLE `testimonial_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonial_sections`
--

INSERT INTO `testimonial_sections` VALUES (2,8,'Client Feedback','What Client Say About Us','2021-12-30 03:54:24','2021-12-30 03:55:17'),(3,9,'ملاحظات العملاء','ماذا يقول العميل عنا','2022-03-06 00:35:29','2022-03-06 00:35:29');

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `occupation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` VALUES (5,9,'62e27b16b9aae.jpg','توماس زينكس','رجل اعمال','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','2022-01-01 23:18:57','2022-08-01 03:52:43'),(6,9,'621c9a6474879.png','فلان الفلاني','باني','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','2022-01-01 23:19:58','2022-08-01 03:53:34'),(7,9,'62246762d0cf6.png','اشلي هيرت','عامل','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','2022-01-01 23:20:11','2022-08-01 03:53:55'),(13,8,'62e7a1af39822.jpg','Tomas Zinks','Businessman','Duis leo. Sed fringilla mauris sit amibh. Donec sodales sagittis magna. Sed consequat goos services.','2022-03-06 01:45:48','2022-08-01 03:49:35'),(14,8,'62249ae91459e.png','John Doe','Builder','Duis leo. Sed fringilla mauris sit amibh. Donec sodales sagittis magna. Sed consequat goos services.','2022-03-06 01:46:33','2022-08-01 03:50:04'),(15,8,'62249adfe34e9.png','Ashley Hurt','Worker','Duis leo. Sed fringilla mauris sit amibh. Donec sodales sagittis magna. Sed consequat goos services.','2022-03-06 01:47:07','2022-08-01 03:50:32'),(16,9,'62e27b0c3d26d.jpg','البظر المصب','عميل التأجير','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','2022-07-27 00:51:54','2022-08-01 03:54:18'),(17,9,'62e27af68f5fc.jpg','دونالد جيمس','عميل التأجير','علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .','2022-07-27 00:52:18','2022-08-01 03:54:40'),(18,8,'62e7a20e31e53.jpg','Mohona Clitar','Rental Customer','Duis leo. Sed fringilla mauris sit amibh. Donec sodales sagittis magna. Sed consequat goos services.','2022-08-01 03:51:10','2022-08-01 03:51:10'),(19,8,'62e7a22bd2e29.jpg','Donald James','Rental Customer','Duis leo. Sed fringilla mauris sit amibh. Donec sodales sagittis magna. Sed consequat goos services.','2022-08-01 03:51:39','2022-08-01 03:51:39');

--
-- Table structure for table `work_process_sections`
--

CREATE TABLE `work_process_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `work_process_sections`
--

INSERT INTO `work_process_sections` VALUES (1,9,'آلية العمل','احصل على إيجاراتك في 4 خطوات سهلة','إنها طرية للغاية ولا تترك أي ألم. يحب أن يعتني بأسرته. سوف تؤتي هذه العملية ثمارها.','2021-12-08 23:03:46','2022-08-01 03:29:44'),(2,8,'Work Process','Get Your Rentals in Easy 4 Steps','Amet minim mollit non deserunt ullamco est sit aliqua dolor do amet sint. Velit officia consequat duis enim velit mollit. Exercitation veniam consequat sunt nostrud amet.','2022-03-06 00:26:05','2022-08-01 03:27:09');

--
-- Table structure for table `work_processes`
--

CREATE TABLE `work_processes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `language_id` bigint unsigned NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial_number` int unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `work_processes`
--

INSERT INTO `work_processes` VALUES (3,9,'fas fa-search',1,'ابحث عن معداتك','2021-12-09 02:06:57','2022-08-01 03:30:00'),(4,9,'fas fa-qrcode',2,'قارن اختيارك','2021-12-09 02:09:04','2022-08-01 03:30:13'),(5,9,'fas fa-truck',3,'حجز المعدات','2021-12-09 02:12:00','2022-08-01 03:30:25'),(6,9,'fas fa-chart-line',4,'ابدأ مشروعك','2021-12-09 02:14:21','2022-08-01 03:30:39'),(7,8,'fas fa-search',1,'Search Your Equipment','2022-03-06 00:26:48','2022-08-01 03:27:33'),(8,8,'fas fa-qrcode',2,'Compare Your Selection','2022-03-06 00:27:58','2022-08-01 03:27:49'),(9,8,'fas fa-truck',3,'Reserve The Equipment','2022-03-06 00:28:30','2022-08-01 03:28:05'),(10,8,'fas fa-chart-line',4,'Get Start Your Project','2022-03-06 00:29:11','2022-08-01 03:28:17');


