-- MySQL dump 10.13  Distrib 8.0.30, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: altaqwa
-- ------------------------------------------------------
-- Server version	8.0.30

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

DROP TABLE IF EXISTS `blog_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `blog_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `blog_categories` WRITE;
/*!40000 ALTER TABLE `blog_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `blog_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `blog_category_translates`
--

DROP TABLE IF EXISTS `blog_category_translates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `blog_category_translates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `blog_category_id` bigint unsigned DEFAULT NULL,
  `lang` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` 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_category_translates_blog_category_id_foreign` (`blog_category_id`),
  CONSTRAINT `blog_category_translates_blog_category_id_foreign` FOREIGN KEY (`blog_category_id`) REFERENCES `blog_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `blog_category_translates`
--

LOCK TABLES `blog_category_translates` WRITE;
/*!40000 ALTER TABLE `blog_category_translates` DISABLE KEYS */;
/*!40000 ALTER TABLE `blog_category_translates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `blog_translates`
--

DROP TABLE IF EXISTS `blog_translates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `blog_translates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `blog_id` bigint unsigned DEFAULT NULL,
  `lang` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` 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_translates_blog_id_foreign` (`blog_id`),
  CONSTRAINT `blog_translates_blog_id_foreign` FOREIGN KEY (`blog_id`) REFERENCES `blogs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `blog_translates`
--

LOCK TABLES `blog_translates` WRITE;
/*!40000 ALTER TABLE `blog_translates` DISABLE KEYS */;
/*!40000 ALTER TABLE `blog_translates` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `blogs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `blogs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint unsigned NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `blogs_category_id_foreign` (`category_id`),
  CONSTRAINT `blogs_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `blog_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `blogs` WRITE;
/*!40000 ALTER TABLE `blogs` DISABLE KEYS */;
/*!40000 ALTER TABLE `blogs` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `category_translates`
--

DROP TABLE IF EXISTS `category_translates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `category_translates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint unsigned DEFAULT NULL,
  `lang` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_translates_category_id_foreign` (`category_id`),
  CONSTRAINT `category_translates_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category_translates`
--

LOCK TABLES `category_translates` WRITE;
/*!40000 ALTER TABLE `category_translates` DISABLE KEYS */;
/*!40000 ALTER TABLE `category_translates` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `galleries`
--

DROP TABLE IF EXISTS `galleries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `galleries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `galleries`
--

LOCK TABLES `galleries` WRITE;
/*!40000 ALTER TABLE `galleries` DISABLE KEYS */;
/*!40000 ALTER TABLE `galleries` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_reset_tokens`
--

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_reset_tokens`
--

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `personal_access_tokens`
--

DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `personal_access_tokens`
--

LOCK TABLES `personal_access_tokens` WRITE;
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_translates`
--

DROP TABLE IF EXISTS `product_translates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_translates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned DEFAULT NULL,
  `lang` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` 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_translates_product_id_foreign` (`product_id`),
  CONSTRAINT `product_translates_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_translates`
--

LOCK TABLES `product_translates` WRITE;
/*!40000 ALTER TABLE `product_translates` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_translates` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint unsigned NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `images` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `products_category_id_foreign` (`category_id`),
  CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `sliders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sliders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image_ar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_tr` 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `sliders` WRITE;
/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `translations`
--

DROP TABLE IF EXISTS `translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `lang` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lang_key` text COLLATE utf8mb4_unicode_ci,
  `lang_value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `translations`
--

LOCK TABLES `translations` WRITE;
/*!40000 ALTER TABLE `translations` DISABLE KEYS */;
INSERT INTO `translations` VALUES (1,'en','our_last_products','Our Last Products','2024-03-09 12:35:37','2024-03-09 12:35:37'),(2,'en','about_us','About us','2024-03-09 12:35:37','2024-03-09 12:35:37'),(3,'en','altaqwa_soap_manufacturing_company_stands_out_for_its_beautiful_creative_and_innovative_production_it_focuses_on_delivering_highquality_products_that_perfectly_meet_customers_needs_with_its_innovative_marketing_strategy_the_company_continues_to_achieve_consistent_success_in_the_soap_manufacturing_market_solidifying_its_position_as_a_leading_player_in_the_industry','Al-Taqwa Soap Company excels in manufacturing the finest types of laurel and goat milk soap with our creative and innovative production. We focus on delivering high-quality products that perfectly meet customers\' needs. Thanks to our innovative marketing strategy, we continue to achieve success in the soap manufacturing market, solidifying our position in the industry.','2024-03-09 12:35:37','2024-03-09 12:35:37'),(4,'en','read_more','Read More','2024-03-09 12:35:37','2024-03-09 12:35:37'),(5,'en','our_gallery','Our Gallery','2024-03-09 12:35:37','2024-03-09 12:35:37'),(6,'en','stay_up_to_date_with_all_news_and_exclusive_offers','Stay Up to Date with All News and Exclusive Offers','2024-03-09 12:35:37','2024-03-09 12:35:37'),(7,'en','from_our_blog','From Our Blog','2024-03-09 12:35:37','2024-03-09 12:35:37'),(8,'en','view_all_posts','View All Posts','2024-03-09 12:35:37','2024-03-09 12:35:37'),(9,'en','home','Home','2024-03-09 12:35:37','2024-03-09 12:35:37'),(10,'en','products','Products','2024-03-09 12:35:37','2024-03-09 12:35:37'),(11,'en','gallery','Gallery','2024-03-09 12:35:37','2024-03-09 12:35:37'),(12,'en','blog','Blog','2024-03-09 12:35:37','2024-03-09 12:35:37'),(13,'en','contact_us','Contact us','2024-03-09 12:35:37','2024-03-09 12:35:37'),(14,'en','light','Light','2024-03-09 12:35:37','2024-03-09 12:35:37'),(15,'en','dark','Dark','2024-03-09 12:35:37','2024-03-09 12:35:37'),(16,'en','auto','Auto','2024-03-09 12:35:37','2024-03-09 12:35:37'),(17,'en','altaqwa','Altaqwa','2024-03-09 12:42:58','2024-03-09 12:42:58'),(18,'en','pages','Pages','2024-03-09 12:56:21','2024-03-09 12:56:21'),(19,'en','subscribe','Subscribe','2024-03-10 09:09:09','2024-03-10 09:09:09'),(20,'en','altaqwa_soap_manufacturing_companys_commitment_to_excellence_extends_beyond_product_quality_as_it_also_prioritizes_sustainability_and_ethical_sourcing_practices_by_embracing_ecofriendly_production_methods_and_supporting_local_communities_the_company_sets_a_benchmark_for_responsible_business_operations_in_the_industry_additionally_its_dedication_to_continuous_improvement_and_customer_satisfaction_ensures_enduring_trust_and_loyalty_from_its_clientele_reinforcing_its_status_as_a_pioneer_in_the_soap_manufacturing_sector','Al-Taqwa Soap Manufacturing Company\'s commitment to excellence extends beyond product quality, as it also prioritizes sustainability and ethical sourcing practices. By embracing eco-friendly production methods and supporting local communities, the company sets a benchmark for responsible business operations in the industry. Additionally, its dedication to continuous improvement and customer satisfaction ensures enduring trust and loyalty from its clientele, reinforcing its status as a pioneer in the soap manufacturing sector.','2024-03-10 09:17:56','2024-03-10 09:17:56'),(21,'ar','our_last_products','آخر منتجاتنا','2024-03-10 06:09:09','2024-03-10 06:09:09'),(22,'ar','about_us','من نحن','2024-03-10 06:09:09','2024-03-10 06:09:09'),(23,'ar','altaqwa_soap_manufacturing_company_stands_out_for_its_beautiful_creative_and_innovative_production_it_focuses_on_delivering_highquality_products_that_perfectly_meet_customers_needs_with_its_innovative_marketing_strategy_the_company_continues_to_achieve_consistent_success_in_the_soap_manufacturing_market_solidifying_its_position_as_a_leading_player_in_the_industry',' شركة التقوى لتصنيع أجود أنواع صابون غار و متكيز بإنتاجنا المبدع والمبتكر.  نركز على تقديم منتجات عالية الجودة تلبي بشكل مثالي احتياجات العملاء. و بفضل استراتيجيتنا التسويقية المبتكرة، نستمر في تحقيق نجاح في سوق تصنيع الصابون، مما يعزز مكانتنا في عالم الصناعة.','2024-03-10 06:09:09','2024-03-10 06:09:09'),(24,'ar','read_more','اقرأ المزيد','2024-03-10 06:09:09','2024-03-10 06:09:09'),(25,'ar','our_gallery','معرضنا','2024-03-10 06:09:09','2024-03-10 06:09:09'),(26,'ar','stay_up_to_date_with_all_news_and_exclusive_offers','ابق على اطلاع بكل الأخبار والعروض الحصرية','2024-03-10 06:09:09','2024-03-10 06:09:09'),(27,'ar','from_our_blog','من مدونتنا','2024-03-10 06:09:09','2024-03-10 06:09:09'),(28,'ar','view_all_posts','عرض كل المنشورات','2024-03-10 06:09:09','2024-03-10 06:09:09'),(29,'ar','home','الصفحة الرئيسية','2024-03-10 06:09:09','2024-03-10 06:09:09'),(30,'ar','products','المنتجات','2024-03-10 06:09:09','2024-03-10 06:09:09'),(31,'ar','gallery','المعرض','2024-03-10 06:09:09','2024-03-10 06:09:09'),(32,'ar','blog','مدونة','2024-03-10 06:09:09','2024-03-10 06:09:09'),(33,'ar','contact_us','اتصل بنا','2024-03-10 06:09:09','2024-03-10 06:09:09'),(34,'ar','light','فاتح','2024-03-10 06:09:09','2024-03-10 06:09:09'),(35,'ar','dark','داكن','2024-03-10 06:09:09','2024-03-10 06:09:09'),(36,'ar','auto','تلقائي','2024-03-10 06:09:09','2024-03-10 06:09:09'),(37,'ar','altaqwa','التقوى','2024-03-10 06:09:09','2024-03-10 06:09:09'),(38,'ar','pages','الصفحات','2024-03-10 06:09:09','2024-03-10 06:09:09'),(39,'ar','subscribe','اشترك','2024-03-10 06:09:09','2024-03-10 06:09:09'),(40,'ar','altaqwa_soap_manufacturing_companys_commitment_to_excellence_extends_beyond_product_quality_as_it_also_prioritizes_sustainability_and_ethical_sourcing_practices_by_embracing_ecofriendly_production_methods_and_supporting_local_communities_the_company_sets_a_benchmark_for_responsible_business_operations_in_the_industry_additionally_its_dedication_to_continuous_improvement_and_customer_satisfaction_ensures_enduring_trust_and_loyalty_from_its_clientele_reinforcing_its_status_as_a_pioneer_in_the_soap_manufacturing_sector',' شركة التقوى لتصنيع أجود أنواع صابون غار و متكيز بإنتاجنا المبدع والمبتكر.  نركز على تقديم منتجات عالية الجودة تلبي بشكل مثالي احتياجات العملاء. و بفضل استراتيجيتنا التسويقية المبتكرة، نستمر في تحقيق نجاح في سوق تصنيع الصابون، مما يعزز مكانتنا في عالم الصناعة.','2024-03-10 06:09:09','2024-03-10 06:09:09'),(41,'tr','our_last_products','Son Ürünlerimiz','2024-03-10 06:09:09','2024-03-10 06:09:09'),(42,'tr','about_us','Hakkımızda','2024-03-10 06:09:09','2024-03-10 06:09:09'),(43,'tr','altaqwa_soap_manufacturing_company_stands_out_for_its_beautiful_creative_and_innovative_production_it_focuses_on_delivering_highquality_products_that_perfectly_meet_customers_needs_with_its_innovative_marketing_strategy_the_company_continues_to_achieve_consistent_success_in_the_soap_manufacturing_market_solidifying_its_position_as_a_leading_player_in_the_industry','Al-Taqwa Sabun Şirketi, yaratıcı ve yenilikçi üretimimizle en kaliteli defne ve keçi sütü sabunlarını üretmede başarılıdır. Müşterilerin ihtiyaçlarını mükemmel bir şekilde karşılayan yüksek kaliteli ürünler sunmaya odaklanıyoruz. Yenilikçi pazarlama stratejimiz sayesinde, sabun üretim pazarında başarı elde etmeye devam ediyoruz ve endüstrideki konumumuzu güçlendiriyoruz.','2024-03-10 06:09:09','2024-03-10 06:09:09'),(44,'tr','read_more','Daha Fazla Oku','2024-03-10 06:09:09','2024-03-10 06:09:09'),(45,'tr','our_gallery','Galerimiz','2024-03-10 06:09:09','2024-03-10 06:09:09'),(46,'tr','stay_up_to_date_with_all_news_and_exclusive_offers','Tüm Haberler ve Özel Tekliflerle Güncel Kalın','2024-03-10 06:09:09','2024-03-10 06:09:09'),(47,'tr','from_our_blog','Blogumuzdan','2024-03-10 06:09:09','2024-03-10 06:09:09'),(48,'tr','view_all_posts','Tüm Gönderileri Görüntüle','2024-03-10 06:09:09','2024-03-10 06:09:09'),(49,'tr','home','Ana Sayfa','2024-03-10 06:09:09','2024-03-10 06:09:09'),(50,'tr','products','Ürünler','2024-03-10 06:09:09','2024-03-10 06:09:09'),(51,'tr','gallery','Galeri','2024-03-10 06:09:09','2024-03-10 06:09:09'),(52,'tr','blog','Blog','2024-03-10 06:09:09','2024-03-10 06:09:09'),(53,'tr','contact_us','Bize Ulaşın','2024-03-10 06:09:09','2024-03-10 06:09:09'),(54,'tr','light','Açık','2024-03-10 06:09:09','2024-03-10 06:09:09'),(55,'tr','dark','Koyu','2024-03-10 06:09:09','2024-03-10 06:09:09'),(56,'tr','auto','Otomatik','2024-03-10 06:09:09','2024-03-10 06:09:09'),(57,'tr','altaqwa','Altaqwa','2024-03-10 06:09:09','2024-03-10 06:09:09'),(58,'tr','pages','Sayfalar','2024-03-10 06:09:09','2024-03-10 06:09:09'),(59,'tr','subscribe','Abone Ol','2024-03-10 06:09:09','2024-03-10 06:09:09'),(60,'tr','altaqwa_soap_manufacturing_companys_commitment_to_excellence_extends_beyond_product_quality_as_it_also_prioritizes_sustainability_and_ethical_sourcing_practices_by_embracing_ecofriendly_production_methods_and_supporting_local_communities_the_company_sets_a_benchmark_for_responsible_business_operations_in_the_industry_additionally_its_dedication_to_continuous_improvement_and_customer_satisfaction_ensures_enduring_trust_and_loyalty_from_its_clientele_reinforcing_its_status_as_a_pioneer_in_the_soap_manufacturing_sector','Al-Taqwa Sabun Üretim Şirketi nin mükemmeliyete olan bağlılığı, ürün kalitesinin ötesine geçer ve aynı zamanda sürdürülebilirlik ve etik kaynak sağlama uygulamalarını da önceliklendirir. Çevre dostu üretim yöntemlerini benimseyerek ve yerel toplulukları destekleyerek, şirket endüstride sorumlu işletme uygulamaları için bir ölçüt belirler. Ayrıca, sürekli iyileştirme ve müşteri memnuniyetine olan bağlılığı, müşterilerinden sürekli güven ve sadakat sağlar ve sabun üretim sektöründe öncü bir konumu pekiştirir.','2024-03-10 06:09:09','2024-03-10 06:09:09'),(61,'en','keep_in_touch_with_us','Keep In Touch with Us','2024-03-10 09:35:24','2024-03-10 09:35:24'),(62,'en','address','Address','2024-03-10 09:35:24','2024-03-10 09:35:24'),(63,'en','contact','Contact','2024-03-10 09:35:24','2024-03-10 09:35:24'),(64,'en','categories','Categories','2024-03-10 09:37:20','2024-03-10 09:37:20'),(65,'en','categories','Categories','2024-03-10 09:37:20','2024-03-10 09:37:20'),(66,'en','share','Share','2024-03-10 09:37:20','2024-03-10 09:37:20'),(67,'en','share','Share','2024-03-10 09:37:20','2024-03-10 09:37:20'),(68,'en','category','Category','2024-03-10 10:32:32','2024-03-10 10:32:32'),(69,'en','category','Category','2024-03-10 10:32:32','2024-03-10 10:32:32'),(70,'en','recent_posts','Recent posts','2024-03-10 10:32:32','2024-03-10 10:32:32'),(71,'en','recent_posts','Recent posts','2024-03-10 10:32:32','2024-03-10 10:32:32');
/*!40000 ALTER TABLE `translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-09-10 15:01:35
