-- MySQL dump 10.13  Distrib 8.0.37, for Linux (x86_64)
--
-- Host: localhost    Database: topappkw_almodaress
-- ------------------------------------------------------
-- Server version	8.0.37

/*!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 */;

--
-- Current Database: `topappkw_almodaress`
--


--
-- Table structure for table `comment_translations`
--

DROP TABLE IF EXISTS `comment_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `comment_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `comment_translations_comment_id_locale_unique` (`comment_id`,`locale`),
  KEY `comment_translations_locale_index` (`locale`),
  CONSTRAINT `comment_translations_comment_id_foreign` FOREIGN KEY (`comment_id`) REFERENCES `comments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `comment_translations`
--

LOCK TABLES `comment_translations` WRITE;
/*!40000 ALTER TABLE `comment_translations` DISABLE KEYS */;
INSERT INTO `comment_translations` (`id`, `comment_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (1,1,'en','ممتاز','2024-01-05 16:47:22','2024-01-06 16:13:40'),(2,1,'ar','ممتاز','2024-01-05 16:47:22','2024-01-06 16:13:40'),(3,2,'en','جيد','2024-01-20 08:26:50','2024-01-20 08:26:50'),(4,2,'ar','جيد','2024-01-20 08:26:50','2024-01-20 08:26:50'),(5,3,'en','مقبول','2024-01-20 08:26:58','2024-01-20 08:26:58'),(6,3,'ar','مقبول','2024-01-20 08:26:58','2024-01-20 08:26:58');
/*!40000 ALTER TABLE `comment_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comments`
--

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

--
-- Dumping data for table `comments`
--

LOCK TABLES `comments` WRITE;
/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
INSERT INTO `comments` (`id`, `created_at`, `updated_at`) VALUES (1,'2024-01-05 16:47:22','2024-01-05 16:47:22'),(2,'2024-01-20 08:26:50','2024-01-20 08:26:50'),(3,'2024-01-20 08:26:58','2024-01-20 08:26:58');
/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `contacts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contacts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `more_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=355 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `contacts` WRITE;
/*!40000 ALTER TABLE `contacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `contacts` 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,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) 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 `job_translations`
--

DROP TABLE IF EXISTS `job_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `job_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `job_translations_job_id_locale_unique` (`job_id`,`locale`),
  KEY `job_translations_locale_index` (`locale`),
  CONSTRAINT `job_translations_job_id_foreign` FOREIGN KEY (`job_id`) REFERENCES `jobs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_translations`
--

LOCK TABLES `job_translations` WRITE;
/*!40000 ALTER TABLE `job_translations` DISABLE KEYS */;
INSERT INTO `job_translations` (`id`, `job_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (1,1,'en','Supervisor','2022-06-13 04:51:12','2022-07-29 16:42:34'),(2,1,'ar','موجه فني','2022-06-13 04:51:12','2022-07-29 16:42:34'),(3,2,'en','Principal','2022-06-13 04:51:12','2022-07-29 16:43:01'),(4,2,'ar','مدير مدرسة','2022-06-13 04:51:12','2022-07-29 16:43:01'),(9,5,'en','Vice principal','2022-07-29 16:43:35','2022-07-29 16:43:35'),(10,5,'ar','مدير مساعد','2022-07-29 16:43:35','2022-07-29 16:43:35'),(11,6,'en','Head of Department','2022-07-29 16:44:09','2022-07-29 16:44:09'),(12,6,'ar','رئيس قسم','2022-07-29 16:44:09','2022-07-29 16:44:09'),(13,7,'en','techear','2022-07-29 16:44:33','2022-07-29 16:44:33'),(14,7,'ar','معلم','2022-07-29 16:44:33','2022-07-29 16:44:33'),(15,8,'en','student','2022-07-29 16:45:36','2022-07-29 16:45:36'),(16,8,'ar','طالب كلية التربية','2022-07-29 16:45:36','2022-07-29 16:45:36');
/*!40000 ALTER TABLE `job_translations` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
INSERT INTO `jobs` (`id`, `created_at`, `updated_at`) VALUES (1,'2022-06-13 04:51:12','2022-06-13 04:51:12'),(2,'2022-06-13 04:51:12','2022-06-13 04:51:12'),(5,'2022-07-29 16:43:35','2022-07-29 16:43:35'),(6,'2022-07-29 16:44:09','2022-07-29 16:44:09'),(7,'2022-07-29 16:44:33','2022-07-29 16:44:33'),(8,'2022-07-29 16:45:35','2022-07-29 16:45:35');
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lecture_students`
--

DROP TABLE IF EXISTS `lecture_students`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lecture_students` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `lecture_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `fees` double DEFAULT NULL,
  `payment_method` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lecture_students_lecture_id_foreign` (`lecture_id`),
  KEY `lecture_students_user_id_foreign` (`user_id`),
  CONSTRAINT `lecture_students_lecture_id_foreign` FOREIGN KEY (`lecture_id`) REFERENCES `lectures` (`id`) ON DELETE CASCADE,
  CONSTRAINT `lecture_students_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lecture_students`
--

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

--
-- Table structure for table `lecture_users`
--

DROP TABLE IF EXISTS `lecture_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lecture_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `lecture_id` bigint unsigned NOT NULL,
  `price` double(8,2) NOT NULL,
  `start_at` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lecture_users_user_id_foreign` (`user_id`),
  KEY `lecture_users_lecture_id_foreign` (`lecture_id`),
  CONSTRAINT `lecture_users_lecture_id_foreign` FOREIGN KEY (`lecture_id`) REFERENCES `lectures` (`id`) ON DELETE CASCADE,
  CONSTRAINT `lecture_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`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 `lecture_users`
--

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

--
-- Table structure for table `lectures`
--

DROP TABLE IF EXISTS `lectures`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lectures` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subject_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `start_at` datetime NOT NULL,
  `price` double(8,2) NOT NULL,
  `topic` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `join_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 show / 0 hide',
  PRIMARY KEY (`id`),
  KEY `lectures_subject_id_foreign` (`subject_id`),
  KEY `lectures_user_id_foreign` (`user_id`),
  CONSTRAINT `lectures_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE,
  CONSTRAINT `lectures_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lectures`
--

LOCK TABLES `lectures` WRITE;
/*!40000 ALTER TABLE `lectures` DISABLE KEYS */;
INSERT INTO `lectures` (`id`, `subject_id`, `user_id`, `start_at`, `price`, `topic`, `start_url`, `join_url`, `created_at`, `updated_at`, `status`) VALUES (6,156,209,'2024-01-10 20:22:00',0.00,'محاضرة',NULL,NULL,'2024-01-31 20:40:25','2024-01-31 20:41:41',1),(7,156,209,'2024-01-10 20:22:00',0.00,'محاضرة',NULL,NULL,'2024-01-31 20:42:05','2024-01-31 20:42:37',1);
/*!40000 ALTER TABLE `lectures` 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(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 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 */;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1,'2013_11_06_111100_create_jobs_table',1),(2,'2013_11_06_111119_create_job_translations_table',1),(3,'2014_10_12_000000_create_users_table',1),(4,'2014_10_12_100000_create_password_resets_table',1),(5,'2016_06_01_000001_create_oauth_auth_codes_table',1),(6,'2016_06_01_000002_create_oauth_access_tokens_table',1),(7,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(8,'2016_06_01_000004_create_oauth_clients_table',1),(9,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(10,'2019_08_19_000000_create_failed_jobs_table',1),(11,'2021_04_24_153514_create_permission_tables',1),(12,'2021_06_05_001447_create_settings_table',1),(13,'2021_06_05_001901_create_setting_translations_table',1),(14,'2021_06_05_210127_create_notifications_table',1),(15,'2022_06_08_113553_create_stages_table',1),(16,'2022_06_08_113607_create_stage_translations_table',1),(17,'2022_06_08_113634_create_stage_classes_table',1),(18,'2022_06_08_113643_create_stage_class_translations_table',1),(19,'2022_06_08_113701_create_subjects_table',1),(20,'2022_06_08_113710_create_subject_translations_table',1),(21,'2022_06_08_113725_create_subject_data_table',1),(22,'2022_06_08_114335_create_user_subjects_table',1),(23,'2022_06_08_114348_create_user_stages_table',1),(24,'2022_06_08_114355_create_user_classes_table',1),(25,'2022_06_09_121207_create_new_ads_table',1),(26,'2022_06_09_121218_create_new_ad_translations_table',1),(27,'2022_06_09_121509_create_publications_table',1),(28,'2022_06_10_154845_create_phone_codes_table',1),(29,'2022_06_10_221207_create_subject_data_reactions_table',1),(30,'2022_06_11_225455_create_workshops_table',1),(31,'2022_06_11_230156_create_workshop_sales_table',1),(32,'2022_06_12_054918_add_status_column_to_subject_data_table',1),(33,'2022_06_12_233625_add_fixed_coulmn_to_publications_table',1),(34,'2022_06_12_233644_add_fixed_coulmn_to_workshops_table',1),(36,'2022_06_13_090208_create_contacts_table',2),(37,'2022_06_13_102536_add_description_to_workshops_table',3),(38,'2022_06_16_075618_create_sliders_table',4),(39,'2022_06_16_085412_create_slider_translations_table',5),(40,'2023_12_22_154148_add_fees_column_to_stage_classes_table',6),(42,'2023_12_22_181347_add_semester_column_to_subjects_table',7),(43,'2023_12_22_225444_add_stage_id_to_subjects_table',8),(44,'2023_12_23_112133_create_sections_table',9),(45,'2023_12_23_120340_create_section_translations_table',10),(46,'2023_12_23_170315_add_new_columns_to_users_table',11),(47,'2023_12_23_191303_create_comments_table',12),(48,'2023_12_23_195521_create_comment_translations_table',12),(49,'2023_12_24_195720_remove_job_id_column_from_users_table',13),(50,'2023_12_26_002321_add_subscription_status_to_users_table',14),(51,'2023_12_26_003043_create_user_subscriptions_table',14),(52,'2024_01_03_205101_create_lectures_table',15),(53,'2024_01_03_210937_create_lecture_users_table',15),(54,'2024_01_05_190024_add_new_columns_to_user_subscriptions_table',16),(55,'2024_01_06_172813_add_columns_to_subject_data_table',17),(56,'2024_01_06_232939_add_columns_to_lectures_table',18),(57,'2024_01_08_211914_create_questions_table',18),(58,'2024_01_08_212738_create_lecture_students_table',18),(59,'2024_01_08_212814_create_ratings_table',18),(60,'2024_01_18_153843_create_paymet_types_table',19),(61,'2024_01_17_232900_add_status_to_stages',20),(62,'2024_01_18_211115_add_status_to_lectures_table',21),(63,'2024_01_19_185843_add_very_new_columns_to_users_table',22),(64,'2024_01_19_184520_add_status_to_stage_classes_table',23),(65,'2024_01_21_195542_add_status_to_subjects_table',23),(66,'2024_01_27_082025_update_sections_table',24);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `model_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`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 `model_has_permissions`
--

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

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

DROP TABLE IF EXISTS `model_has_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`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 `model_has_roles`
--

LOCK TABLES `model_has_roles` WRITE;
/*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES (1,'App\\User',1),(4,'App\\User',169),(2,'App\\User',170),(2,'App\\User',171),(4,'App\\User',172),(2,'App\\User',173),(2,'App\\User',174),(4,'App\\User',175),(2,'App\\User',176),(4,'App\\User',209),(4,'App\\User',210),(2,'App\\User',211),(2,'App\\User',212);
/*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `new_ad_translations`
--

DROP TABLE IF EXISTS `new_ad_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `new_ad_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `new_ad_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `new_ad_translations_new_ad_id_locale_unique` (`new_ad_id`,`locale`),
  KEY `new_ad_translations_locale_index` (`locale`),
  CONSTRAINT `new_ad_translations_new_ad_id_foreign` FOREIGN KEY (`new_ad_id`) REFERENCES `new_ads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `new_ad_translations`
--

LOCK TABLES `new_ad_translations` WRITE;
/*!40000 ALTER TABLE `new_ad_translations` DISABLE KEYS */;
INSERT INTO `new_ad_translations` (`id`, `new_ad_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (1,1,'en','welcome to Khibra Website','2022-06-13 07:12:19','2022-07-24 19:08:18'),(2,1,'ar','مرحبا بكم في موقع خبرة','2022-06-13 07:12:19','2022-07-24 19:08:18'),(3,2,'en','11/9/2022 بدء دوام الهيئتين الإدارية و التعليمية في مرحلة رياض الأطفال','2022-06-13 07:13:54','2022-07-29 14:12:29'),(4,2,'ar','11/9/2022 بدء دوام الهيئتين الإدارية و التعليمية في مرحلة رياض الأطفال','2022-06-13 07:13:54','2022-07-29 14:12:29'),(5,3,'en','بدء دوام الهيئتين الإدارية و التعليمية في المرحلتين الابتدائية و المتوسطة 13/9/2022','2022-06-13 07:17:06','2022-07-24 19:14:01'),(6,3,'ar','بدء دوام الهيئتين الإدارية و التعليمية في المرحلتين الابتدائية و المتوسطة 13/9/2022','2022-06-13 07:17:07','2022-07-24 19:14:01'),(7,4,'en','بدء دوام الهيئتين الإدارية و التعليمية في المرحلة الثانوية 18/9/2022','2022-06-13 07:20:07','2022-07-24 19:11:02'),(8,4,'ar','بدء دوام الهيئتين الإدارية و التعليمية في المرحلة الثانوية 18/9/2022','2022-06-13 07:20:07','2022-07-24 19:11:02'),(9,5,'en','بدء دوام طلبة مرحلة رياض الأطفال  و متعلمي المرحلة الابتدائية 25/9/2022','2022-07-24 02:46:43','2022-08-27 07:07:22'),(10,5,'ar','بدء دوام طلبة مرحلة رياض الأطفال  و متعلمي المرحلة الابتدائية 25/9/2022','2022-07-24 02:46:43','2022-08-27 07:07:22'),(15,8,'en','بدء دوام طلبة المرحلتين المتوسطة و الثانوية 2/10/2022','2022-07-24 02:50:25','2022-08-27 07:08:44'),(16,8,'ar','بدء دوام طلبة المرحلتين المتوسطة و الثانوية 2/10/2022','2022-07-24 02:50:25','2022-08-27 07:08:44'),(17,9,'en','ساهم في تطوير الموقع و شاركنا رأيك عبر الإيميل أو الوتساب','2022-07-29 14:47:38','2022-07-29 14:47:38'),(18,9,'ar','ساهم في تطوير الموقع و شاركنا رأيك عبر الإيميل أو الوتساب','2022-07-29 14:47:38','2022-07-29 14:47:38'),(21,11,'en','يمكنكم إرسال النشرات الخاصة بالمدارس على الإيميل لنشرها هنا','2022-08-27 07:20:24','2022-08-27 07:20:24'),(22,11,'ar','يمكنكم إرسال النشرات الخاصة بالمدارس على الإيميل لنشرها هنا','2022-08-27 07:20:24','2022-08-27 07:20:24');
/*!40000 ALTER TABLE `new_ad_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `new_ads`
--

DROP TABLE IF EXISTS `new_ads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `new_ads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'website/assets/media/photos/mortarboard.png',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `new_ads`
--

LOCK TABLES `new_ads` WRITE;
/*!40000 ALTER TABLE `new_ads` DISABLE KEYS */;
INSERT INTO `new_ads` (`id`, `image`, `created_at`, `updated_at`) VALUES (1,'img/news/images/16594599348492.png','2022-06-13 07:12:19','2022-08-02 15:05:34'),(2,'img/news/images/16586973424888.png','2022-06-13 07:13:54','2022-07-24 19:15:42'),(3,'img/news/images/16586973203909.png','2022-06-13 07:17:06','2022-07-24 19:15:20'),(4,'img/news/images/16586970629133.png','2022-06-13 07:20:07','2022-07-24 19:11:02'),(5,'img/news/images/16586970131223.png','2022-07-24 02:46:43','2022-07-24 19:10:13'),(8,'img/news/images/16586968237962.png','2022-07-24 02:50:25','2022-07-24 19:07:03'),(9,'img/news/images/16594555676768.png','2022-07-29 14:47:38','2022-08-02 13:52:47'),(11,'img/news/images/16615596245486.png','2022-08-27 07:20:24','2022-08-27 07:20:24');
/*!40000 ALTER TABLE `new_ads` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `read` tinyint(1) NOT NULL DEFAULT '0',
  `user_id` bigint unsigned NOT NULL,
  `body` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_user_id_foreign` (`user_id`),
  CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`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 `notifications`
--

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

--
-- Table structure for table `oauth_access_tokens`
--

DROP TABLE IF EXISTS `oauth_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `client_id` bigint unsigned NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_access_tokens`
--

LOCK TABLES `oauth_access_tokens` WRITE;
/*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */;
INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES ('006c7f17b09ab87fc221e4cbbdbcdf67a14f42560425a97f669fee45020a45f3d2efb6d8824b2d3b',202,3,'authToken','[]',0,'2024-01-29 13:53:06','2024-01-29 13:53:06','2025-01-29 13:53:06'),('00c71143a467310779f1b5ebdefef8c670c181147a435c7f6919b4fc6b2abbe1f8100dc4324e070d',186,3,'authToken','[]',0,'2024-01-25 08:29:15','2024-01-25 08:29:15','2025-01-25 08:29:15'),('00d84d26cd4612dcc30dd05d5c59ef59fae2b35f9914e822b0ad1b0aad889bded429bfe6ccec0da4',209,3,'authToken','[]',0,'2024-01-29 14:46:47','2024-01-29 14:46:47','2025-01-29 14:46:47'),('00df6d852f4e93c2bf23dbe3fc38cab3c87a5400e634e111020e967aec8c851d157cb73a8b1e2e81',209,3,'authToken','[]',0,'2024-01-30 07:51:33','2024-01-30 07:51:33','2025-01-30 07:51:33'),('02f4b60e13d2b65297e0ed13d9f1eb6d84ac91de789c529af07cebc4391a224a1e9009b14f94bac2',199,3,'authToken','[]',0,'2024-01-25 12:47:00','2024-01-25 12:47:00','2025-01-25 12:47:00'),('0374c57168e62e27b095f9179fd794da0d7a4b5736bbf98f13e51ea030487f575b5dff0d91df59fe',209,5,'authToken','[]',0,'2024-02-03 10:45:06','2024-02-03 10:45:06','2025-02-03 10:45:06'),('0397dd9018d14f072ea91b50af9a1a686801e2d78a7adbe8491400d6c056e2f49d5933b947c0db63',1,1,'authToken','[]',0,'2023-12-23 15:01:10','2023-12-23 15:01:10','2024-12-23 17:01:10'),('0579ebd4e2030b27fd181f0631701181653ce97351279c65ea3bc0d7c127c8e4368bf7b0034c55cc',202,3,'authToken','[]',0,'2024-01-29 14:00:03','2024-01-29 14:00:03','2025-01-29 14:00:03'),('08197eb93542a328bc996eaf06ed20f30b7adac580058a7dd4b95e6a05bf7226d58818cb5f1e1fd9',209,3,'authToken','[]',0,'2024-01-30 09:17:35','2024-01-30 09:17:35','2025-01-30 09:17:35'),('087c79401fa1c0f0aaad3688cade6962bfa33400b76febc111765ed6112e253c792e151bb8f2790a',155,1,'authToken','[]',0,'2023-12-24 18:18:21','2023-12-24 18:18:21','2024-12-24 20:18:21'),('09b1650e06f2086ee9c7425ceb2ce6a934e9feeabc74d17c5d579c3ea56d00d56a31051c30d2357a',209,3,'authToken','[]',0,'2024-01-30 07:50:49','2024-01-30 07:50:49','2025-01-30 07:50:49'),('09b29b56bb4951b6bc8a01ee6f6823bdd30ba60908366f08e051465e3582823b23be5f09061b7549',188,3,'authToken','[]',0,'2024-01-25 08:31:49','2024-01-25 08:31:49','2025-01-25 08:31:49'),('0d4586bfea7682b6d1821c35344bc9c7c46c2b12d34f8393146a9f444a2da19c7cd0ecb4edaa0da8',209,3,'authToken','[]',0,'2024-02-01 22:18:33','2024-02-01 22:18:33','2025-02-01 22:18:33'),('0de798c878af86b2c9a397c240ba9a34e9ce0a341222cbf47812da0797e299acf8c6cce8f105adf5',212,3,'authToken','[]',0,'2024-01-30 09:11:24','2024-01-30 09:11:24','2025-01-30 09:11:24'),('0e2fbe383699ff2ab8e3a03c69451e55b17fcb86b3f475db3cf8d1344577b2787d9d10ec4b75f00c',209,3,'authToken','[]',0,'2024-01-30 07:50:52','2024-01-30 07:50:52','2025-01-30 07:50:52'),('0f1a952e977700c145d12fe02e32d8155c927c2435b33eb8183b348edb7c1d3020559d78874908d8',182,3,'authToken','[]',0,'2024-01-25 08:03:23','2024-01-25 08:03:23','2025-01-25 08:03:23'),('1096b2784160af02fc92003e1f5bb0fde1a0a50ae1a7d1b469807c52a9c574aad8b50afaa13a9ef1',209,5,'authToken','[]',0,'2024-02-03 10:38:16','2024-02-03 10:38:16','2025-02-03 10:38:16'),('12547c03c042a3fc2af9820fa64f56ae6726422c78340480e648622675eaad823e2ff4e50e838a1c',193,3,'authToken','[]',0,'2024-01-25 10:52:15','2024-01-25 10:52:15','2025-01-25 10:52:15'),('1306a5dabf33d3b73ddc82054a18962d03966f4cea7a1e92f20baed62ebc1d70f3290238abdc2ed8',209,3,'authToken','[]',0,'2024-01-30 09:29:55','2024-01-30 09:29:55','2025-01-30 09:29:55'),('1398a6236a049f59ed6d4a8e20b9af4614697587a20bae323fcd6ae084765f96a142dac15ff761d8',211,3,'authToken','[]',0,'2024-01-30 08:11:42','2024-01-30 08:11:42','2025-01-30 08:11:42'),('144c535cb8ae156a67f4305eaff1bd79b85463d0166a8222f76e0337acc600efd003f1e0987c17ed',209,5,'authToken','[]',0,'2024-02-02 11:10:38','2024-02-02 11:10:38','2025-02-02 11:10:38'),('14be0a9e7984fbb6357b41140539a68843d5ad7a976853203387676ff4d79ed79aed6e52e26d7160',203,3,'authToken','[]',0,'2024-01-25 13:25:31','2024-01-25 13:25:31','2025-01-25 13:25:31'),('1553dbf474bd94ef48ff98ab6ea01926d0161bb6d5fe331baebeab586e9aba79c14465fb3d6f1768',209,3,'authToken','[]',0,'2024-02-01 21:29:05','2024-02-01 21:29:05','2025-02-01 21:29:05'),('155ec50a82028b15fe9a65a7fec9b9b6ee8e4d53272ae56bd9592df73c9d97d9be7a7ab50722bde9',209,5,'authToken','[]',0,'2024-02-03 10:08:03','2024-02-03 10:08:03','2025-02-03 10:08:03'),('1689c84af76cbe516c9c7bc5ee9913753c3d4a6715f8bf8bca7ff478c1a6e711b610c9ff27bd0fba',191,3,'authToken','[]',0,'2024-01-25 08:40:27','2024-01-25 08:40:27','2025-01-25 08:40:27'),('17e43b6df4fbcdf017fb063c7ed2c04ba4fc8ef588b6320221abbe64b33eb1278121cce53519c79f',209,3,'authToken','[]',0,'2024-01-31 12:59:09','2024-01-31 12:59:09','2025-01-31 12:59:09'),('194523f00f3217d91f002aa531e3bae07eaf7b019856ceb70ce70416eaba5bee15079dce6ca5470a',209,5,'authToken','[]',0,'2024-02-02 10:34:05','2024-02-02 10:34:05','2025-02-02 10:34:05'),('1b0352d5266fc6e73bc9155388bf1f7d0a90be030e0a5143db2cc0bc50c08578381ded4ea36fd10d',202,3,'authToken','[]',0,'2024-01-29 14:11:38','2024-01-29 14:11:38','2025-01-29 14:11:38'),('1ec1fbae49b2f1104f970865ea13096f2d49bc63cb65aacb52526692c0fe1d9de2c999174c69a2ec',211,3,'authToken','[]',0,'2024-01-30 08:34:01','2024-01-30 08:34:01','2025-01-30 08:34:01'),('1ecfe9bb67f94238addf124b842b0d7b82d976dbe21909922d676cbb75bfaac7e903dc7ef226bd64',209,5,'authToken','[]',0,'2024-02-02 17:17:22','2024-02-02 17:17:22','2025-02-02 17:17:22'),('1f49be888c01c0e491106f46b4202071537d9cc4e2fa7fe6fcbb5d1fe2ae91d9714ca73aa5e3730b',212,3,'authToken','[]',0,'2024-01-30 08:44:59','2024-01-30 08:44:59','2025-01-30 08:44:59'),('1f5cc307c468f33e20203024c70b8fe584813037fe05d8981d033d2f6a2303a7ca94effe7e7e8985',204,3,'authToken','[]',0,'2024-01-25 13:26:43','2024-01-25 13:26:43','2025-01-25 13:26:43'),('20906bbd4767696bc1de0b3a7bd1adafc93fc126b3b0368177056daaf5c9f1bee259ccafb3269da5',168,1,'authToken','[]',0,'2024-01-05 16:41:05','2024-01-05 16:41:05','2025-01-05 18:41:05'),('21e0a21bbc282ed4f13949da5834c341febec5a7f22a4e81856663d81acc680add4a4e8a28543ae3',209,5,'authToken','[]',0,'2024-02-03 10:08:12','2024-02-03 10:08:12','2025-02-03 10:08:12'),('23c0ee720eafe886260805aa6d1d6abf31c61f52820eb331e0e98d0d6f5be13f107948b48a181853',209,5,'authToken','[]',0,'2024-02-03 10:30:09','2024-02-03 10:30:09','2025-02-03 10:30:09'),('24395270f90d06b80a10515ce554d5a7bc44f8e52377568d235a5ebb0d1356de90918e3e9615c55a',202,3,'authToken','[]',0,'2024-01-29 14:06:24','2024-01-29 14:06:24','2025-01-29 14:06:24'),('259eadf16b4cfae6b4b8f6b1d5a127246429edce48ac1984805c1df47b0a2a4e91e2a255b039cc63',209,5,'authToken','[]',0,'2024-02-03 10:47:24','2024-02-03 10:47:24','2025-02-03 10:47:24'),('260454e17904f6c4fcdf5811bf03424622e991f7d76686e5996f09c6e8a1b89624124561550a5e30',202,3,'authToken','[]',0,'2024-01-29 13:55:15','2024-01-29 13:55:15','2025-01-29 13:55:15'),('27ba30268bf19775ae81aa97b2782d4d40f397d2b870f4b5a04e8edf8a0aa459907d3778a66815ff',209,3,'authToken','[]',0,'2024-02-01 22:14:11','2024-02-01 22:14:11','2025-02-01 22:14:11'),('2a68063489bde95ab7d4e206e7101cbbe3b702e0edf5c0edd6c0d37d1aeccf3914b99b2ee02df529',200,3,'authToken','[]',0,'2024-01-25 12:49:00','2024-01-25 12:49:00','2025-01-25 12:49:00'),('2ac3974891905124e75503e15debdd418b36dcc687fa571448e0f9da90d2e36f36da9ae4a93a7bfd',209,3,'authToken','[]',0,'2024-01-30 07:51:19','2024-01-30 07:51:19','2025-01-30 07:51:19'),('2b3e45fede5ab7f12d6164ca854608f3f2db7c434762fc0a29d61772c8a96e4e295a4ba25ff4526d',209,5,'authToken','[]',0,'2024-02-03 09:08:46','2024-02-03 09:08:46','2025-02-03 09:08:46'),('2b725f024ff2400ea4ec898961f120bec5ed20af9fece174accb515c88668a8884de1ccbac938a09',206,3,'authToken','[]',0,'2024-01-25 15:27:57','2024-01-25 15:27:57','2025-01-25 15:27:57'),('2c141129fbdba41286242ff86d5a8a9f8df58da09fad63a25cefb3f5dc48595679220f635d200cd1',209,5,'authToken','[]',0,'2024-02-02 09:46:45','2024-02-02 09:46:45','2025-02-02 09:46:45'),('2c15d78f32925925d26525e2b2d305bfd35f0f749a8aa20b4a29967a2c02cbf83ed371605b42464e',212,3,'authToken','[]',0,'2024-01-31 21:30:36','2024-01-31 21:30:36','2025-01-31 21:30:36'),('2d9fdefbae9288aa94fb22b7e905e61e82f6ef7c2e92ffccfe77b362e1723f76ee15dc9ec1dc54c4',212,3,'authToken','[]',0,'2024-01-30 09:14:10','2024-01-30 09:14:10','2025-01-30 09:14:10'),('2dba0c4bde83a4e688a3ea96baa2b782aafa905b20b194d8c29410dcdeb5922256f1132111e37713',209,3,'authToken','[]',0,'2024-01-30 08:10:33','2024-01-30 08:10:33','2025-01-30 08:10:33'),('2dd120b989b7cbef8005b1f908b0f785ddfb9b9c55849d12f6b79fc0b2f979a612bc52609b442d02',209,3,'authToken','[]',0,'2024-01-30 09:18:48','2024-01-30 09:18:48','2025-01-30 09:18:48'),('2e336c5c0d11c351161dcb5025c26e9e9de8fe8715cde35202580b3084019c40b67f880259445896',202,3,'authToken','[]',0,'2024-01-25 12:51:56','2024-01-25 12:51:56','2025-01-25 12:51:56'),('2e671e6fedcf67635f53bfcfcfdc16229bbdfa88ecfdc482398332ecb21fcfbbc3534a287e339804',173,1,'authToken','[]',0,'2024-01-08 19:05:20','2024-01-08 19:05:20','2025-01-08 21:05:20'),('2e9b6b8d97b5e3bd840bf277b8ec8e8c2d88d1ff47b234e8bfecaf191858126d6988d2998ceec853',1,1,'authToken','[]',0,'2023-12-23 15:14:23','2023-12-23 15:14:23','2024-12-23 17:14:23'),('2f43d7605bc1c8dd92a695289b5ce48c33f7e408eac6467952da3d38dee8437806f6173dd61ab11b',209,3,'authToken','[]',0,'2024-01-31 11:03:39','2024-01-31 11:03:39','2025-01-31 11:03:39'),('2fd522d89b2f91fe3e2ff3b74f6d9501ff6278799229a3cc58331807d9258a540c943330494c51ef',185,3,'authToken','[]',0,'2024-01-25 08:28:54','2024-01-25 08:28:54','2025-01-25 08:28:54'),('32ea868ad678ad057d6656d858689a6c3def80ae3b44329026b7966d2504b271b586f9125e3b8c8a',211,3,'authToken','[]',0,'2024-01-30 09:25:48','2024-01-30 09:25:48','2025-01-30 09:25:48'),('3440a39ac2646d657d8d543abb3602290bdbfd9418ef587bf43aa4c96429d45ad794cdd45bd3e4bd',209,3,'authToken','[]',0,'2024-01-30 07:52:28','2024-01-30 07:52:28','2025-01-30 07:52:28'),('34c98a70b777dbc32d0170375a7c2d084b9b06c7951d43e1717ada121d314f96d224fdd337e1bf32',209,3,'authToken','[]',0,'2024-01-30 10:53:18','2024-01-30 10:53:18','2025-01-30 10:53:18'),('34db5e1ac01b3f27e62d9731cb9bbab61a861c9d3e3fc8fd2e25c36116e853209372ddf15a8a9d41',180,3,'authToken','[]',0,'2024-01-15 12:12:55','2024-01-15 12:12:55','2025-01-15 12:12:55'),('35de563bc8be7c193fd8109cdd3f910f47a5e6dd0ac8c1fb940edec9e7aa8e8652a9e737af50df01',198,3,'authToken','[]',0,'2024-01-25 12:28:40','2024-01-25 12:28:40','2025-01-25 12:28:40'),('36d3f6d7b5d777a07ba76a4393231637b598f17e8eff321e388ddbf9fd121ba90ebde980e033864f',209,3,'authToken','[]',0,'2024-01-29 14:51:42','2024-01-29 14:51:42','2025-01-29 14:51:42'),('382594e7d7439b40751d195b06e944bdb17619f11ea14089034a4b7590361963c09e84397fde90a6',205,3,'authToken','[]',0,'2024-01-25 13:28:59','2024-01-25 13:28:59','2025-01-25 13:28:59'),('394f7070927bb5eceaf5f0558f1900102b80d15b8a92ba65fb36a16e208b86a6b3cf80cfab4b42c9',1,1,'authToken','[]',0,'2023-12-23 15:15:36','2023-12-23 15:15:36','2024-12-23 17:15:36'),('3a6496914ef8fcf6cd6782de64f8889b6a501ca7815489c15bf3926a6b563209922361d964c074fd',209,5,'authToken','[]',0,'2024-02-02 17:34:22','2024-02-02 17:34:22','2025-02-02 17:34:22'),('3a86af3ecb2b94ec6eb65dd74a77eb771d4df7d65f420027ccc15d901059415187b42d78f25e63c9',209,3,'authToken','[]',0,'2024-02-01 21:40:18','2024-02-01 21:40:18','2025-02-01 21:40:18'),('3adde8f8aaa157818606dafd4c49dab433e9283a5573259873eddb17777a2f73e4c3ee84210ee945',210,3,'authToken','[]',0,'2024-01-30 08:59:08','2024-01-30 08:59:08','2025-01-30 08:59:08'),('3b7d22d775c3e899d86eeec57b24b1906c812e58fec0092be65c1cfb17698639a4972af6bb858498',210,3,'authToken','[]',0,'2024-01-30 09:24:58','2024-01-30 09:24:58','2025-01-30 09:24:58'),('3b86f2e7a9441dd4903080a8df4524eedc383d280297833bec9c26d6b32faa8712eef7dfb335e43c',212,3,'authToken','[]',0,'2024-01-30 08:43:43','2024-01-30 08:43:43','2025-01-30 08:43:43'),('3c44849a0b913a1880d952a77f3590de431084dc34a1960f2a4c1428737e183345087f7a51598339',210,3,'authToken','[]',0,'2024-01-30 09:19:01','2024-01-30 09:19:01','2025-01-30 09:19:01'),('3c7f0cbfad00482f0b95ac2afbdf23a0c9e3de99fd534b25c8c3b922e14cd394c8ca9213f7e1f3ae',209,3,'authToken','[]',0,'2024-01-30 07:54:06','2024-01-30 07:54:06','2025-01-30 07:54:06'),('3cbe7e0f60848e283fd0b274d1801cf85cd4452fd7933bc222cac05733085c901d834ca8926a75e0',209,3,'authToken','[]',0,'2024-01-30 07:52:08','2024-01-30 07:52:08','2025-01-30 07:52:08'),('3dc0a9b6895941bb793101a9168780c2158ce462e8fcd2eeb1df103ce3d68a57e1e529414a204e2c',212,3,'authToken','[]',0,'2024-01-31 06:40:54','2024-01-31 06:40:54','2025-01-31 06:40:54'),('3de4a7d6e434e26a49b0c32e1534174ae90b027a630c4d390b70f046649545744107d9bbb9b706af',168,1,'authToken','[]',0,'2023-12-25 19:20:57','2023-12-25 19:20:57','2024-12-25 21:20:57'),('3dff47273ffca1a52c468ae0b809aac82be4cd0eb46cf7e49018a31abf5aff185da0525009297d19',1,1,'authToken','[]',0,'2023-12-23 14:58:38','2023-12-23 14:58:38','2024-12-23 16:58:38'),('447354678901fd8e7ddc2f3754cb9528c7348a3bd198f7cffbd8d236f863de496c073149d1b406ad',209,3,'authToken','[]',0,'2024-01-30 07:55:44','2024-01-30 07:55:44','2025-01-30 07:55:44'),('44f57076ca1155922406e932be46c1068f4ee581aef8a5e5a1487ed762d407bbf95d7f5767bb52e3',209,3,'authToken','[]',0,'2024-01-31 06:41:08','2024-01-31 06:41:08','2025-01-31 06:41:08'),('456de2126d2bf5e2199ddf7743843f52fe792811267c1933811a90c5919605ca14e24987fc69f37a',173,1,'authToken','[]',0,'2024-01-08 19:05:07','2024-01-08 19:05:07','2025-01-08 21:05:07'),('45ad16d8f29fb5b46a8c127f9775127119dea422d588004a8da7bd599eff24f1ffde0beb5ae7cadd',209,3,'authToken','[]',0,'2024-01-31 12:58:13','2024-01-31 12:58:13','2025-01-31 12:58:13'),('45da4967ab617bb8fdfcde6cb83dd1b38c0ba71241dc871224142528c1e2b96cc9738e796e1c670e',209,3,'authToken','[]',0,'2024-02-01 22:13:05','2024-02-01 22:13:05','2025-02-01 22:13:05'),('467cda13978f81c69ea068897fdd18a371dbf50bf7a54b8d4c0f5d7a85cc255a0b987c195aa527e9',209,3,'authToken','[]',0,'2024-01-31 20:16:23','2024-01-31 20:16:23','2025-01-31 20:16:23'),('46a8fd2a6c5373a467b561f530fca9d8170430cabfde793b360756a5d2c6f2b21c389638894829fb',209,3,'authToken','[]',0,'2024-01-30 07:52:33','2024-01-30 07:52:33','2025-01-30 07:52:33'),('4721c11399e1cce895ad62f3e73346c3fb6dfb170815ad9a169e53a450756586b3c3fa2c0afcf5e2',209,5,'authToken','[]',0,'2024-02-03 10:12:52','2024-02-03 10:12:52','2025-02-03 10:12:52'),('4838286141d77257df18b4a8a3ba76366b1f332073e9417a262eea88954f5175ff38aeb1b25c7cbc',170,1,'authToken','[]',0,'2024-01-01 19:10:08','2024-01-01 19:10:08','2025-01-01 21:10:08'),('4886c8e45d0be87de978eaae13ee4a655f666acf55cb1bafc7c6b3bca2a7b237e8bbd64777c5136c',209,3,'authToken','[]',0,'2024-01-30 07:59:06','2024-01-30 07:59:06','2025-01-30 07:59:06'),('48ff4852720ff7cd64b40a2bea5a990f3e993ecb0c67f3b8d886776c75dbbc08e60a743864dfbb48',209,5,'authToken','[]',0,'2024-02-03 08:51:43','2024-02-03 08:51:43','2025-02-03 08:51:43'),('4aca528d1dd8691d2e8b923bb28ae46acf02cdf01ea5cb22bf23b9bbcb3e45510acaad9310a7a0b0',212,3,'authToken','[]',0,'2024-01-31 11:07:01','2024-01-31 11:07:01','2025-01-31 11:07:01'),('4ad6cfad8b5df96bf826356b03302fd0f4c3a5f519834ed0844df2f1382da5718d440ad41f0fd230',210,3,'authToken','[]',0,'2024-01-30 08:44:07','2024-01-30 08:44:07','2025-01-30 08:44:07'),('4c1a4b95dc5d0badb401707676d60d48d82a637174936c4d60e0eca6dba506a84fa43d428f248441',173,1,'authToken','[]',0,'2024-01-08 21:45:07','2024-01-08 21:45:07','2025-01-08 23:45:07'),('4d1351babbd8f62453f5db7e57f218e0f4ed53072081372ccc13503d25d48660976847c96fe88436',172,1,'authToken','[]',0,'2024-01-08 18:59:17','2024-01-08 18:59:17','2025-01-08 20:59:17'),('4d2c581de6306b4f000d988ea93f2178b795ca7c5358d4c718eae6656ca7a74efd22df5e0b056943',209,3,'authToken','[]',0,'2024-01-30 08:59:01','2024-01-30 08:59:01','2025-01-30 08:59:01'),('4d41c091edf7e36177ada46054fad2bc993f734994085c5d4d458a29d8e8c502b4519ef33d6653f8',211,3,'authToken','[]',0,'2024-01-30 09:14:06','2024-01-30 09:14:06','2025-01-30 09:14:06'),('4d5195fb099f7d17997b24c00e7fdc13c9d3bba00a951df79a414dfb9b382bb95a195c4468a36afc',209,3,'authToken','[]',0,'2024-01-30 07:39:02','2024-01-30 07:39:02','2025-01-30 07:39:02'),('4d52f625b3c9e79758b0c759d61e43a3e801950fe071b73d77536b64f5edc7b6224935e279281dae',172,1,'authToken','[]',0,'2024-01-08 18:58:39','2024-01-08 18:58:39','2025-01-08 20:58:39'),('4de08f1509451eabe2836ca68282bca1848347171410c345306e4b3f8e4ea4e17f53795bc5b9b9fa',1,1,'authToken','[]',0,'2023-12-23 14:58:51','2023-12-23 14:58:51','2024-12-23 16:58:51'),('4ebcc2c80a2cc096689ef86b39060873bd070682d461e20a5dfdd20252a03736c8a15898bf21325e',206,3,'authToken','[]',0,'2024-01-25 14:23:20','2024-01-25 14:23:20','2025-01-25 14:23:20'),('4f08b32c2ebb3516e783bb7a0cc94aa1046d0db5553b426f5ebbe2bf7d22300574528742b3a16e92',206,3,'authToken','[]',0,'2024-01-25 13:39:31','2024-01-25 13:39:31','2025-01-25 13:39:31'),('4fc498c6b56a0519b565688d3c0c3d1e1acf04122e296cb00bc6e108b1ea0156ffca30ab7c94aacf',171,1,'authToken','[]',0,'2024-01-05 16:57:42','2024-01-05 16:57:42','2025-01-05 18:57:42'),('503c5b03d4ebc45c41fec565192bad661f29d5c630d960e4b5243ee8da9e8b79c3b4a55113aa6dd7',187,3,'authToken','[]',0,'2024-01-25 08:30:12','2024-01-25 08:30:12','2025-01-25 08:30:12'),('50d8254f0be6a6fe70b7394caffec6ca28c16eea06176949e10eb11884c689a073467b804aa9d38c',209,3,'authToken','[]',0,'2024-02-01 21:32:50','2024-02-01 21:32:50','2025-02-01 21:32:50'),('53e524771e5e1d8749ca6b17b0fc223f6337522b213a9bd9bbd41c2096bc3e9ec4a0c4a51eed6a24',209,3,'authToken','[]',0,'2024-01-30 07:51:56','2024-01-30 07:51:56','2025-01-30 07:51:56'),('53ee3133c46373e54c82e9419c55887e35952dc2e317a10a417b6b5e3f841bb77c25211a247a4977',209,3,'authToken','[]',0,'2024-01-30 07:57:46','2024-01-30 07:57:46','2025-01-30 07:57:46'),('541dd2cb7656d81293bf41b7e95b84a28af329f2ce44c0d2b4f2b2ffe1da455adcf2fd9c43703c35',210,3,'authToken','[]',0,'2024-01-30 08:59:42','2024-01-30 08:59:42','2025-01-30 08:59:42'),('557b9529140adc2b17336a0a2b79b48aed87e98cd0f2e2b4f43307974b5c9ebb0eeb1e2eaef636c6',209,3,'authToken','[]',0,'2024-01-29 14:18:23','2024-01-29 14:18:23','2025-01-29 14:18:23'),('583dfe55c7411dcc30b11516774ed9192eb0cbd9f85388d887557224d06b8716c667c71917339a98',192,3,'authToken','[]',0,'2024-01-25 08:49:20','2024-01-25 08:49:20','2025-01-25 08:49:20'),('58e2ff20d50d2320b07325d9a971440fb81bc9e736565bf5f787079435a967df5e3747e0fe3c7bde',210,3,'authToken','[]',0,'2024-01-30 09:14:01','2024-01-30 09:14:01','2025-01-30 09:14:01'),('593cba346a714009d776003f4af2b18671bfdcbb2d19ccdd9399ce6a53325eb6e81366222315d3aa',176,1,'authToken','[]',0,'2024-01-08 22:16:00','2024-01-08 22:16:00','2025-01-09 00:16:00'),('5a6901ee6d3d38bb3febea12a437b222a17a618cf1253a8424e0eb0f2f89ccb0f400eccbf85e139b',174,1,'authToken','[]',0,'2024-01-08 22:02:34','2024-01-08 22:02:34','2025-01-09 00:02:34'),('5ad7d5185127d26ae9f0b321e415f8bc2a8c0c0cf9c452dbd914b78601b5ed7627aae6ccc917a6de',209,3,'authToken','[]',0,'2024-01-31 13:02:13','2024-01-31 13:02:13','2025-01-31 13:02:13'),('5af3f83fbe051db995f2c6229471767809a70cd0993c4a4d5fbc6dd77f4f0e0e3bfb850d0f31a73e',212,3,'authToken','[]',0,'2024-01-30 09:26:32','2024-01-30 09:26:32','2025-01-30 09:26:32'),('5c164eda3f8293576f1cfdd620571d23490ec00517748497c1ee73615aa39ff2281660f3a61b0e8f',209,3,'authToken','[]',0,'2024-01-31 13:01:34','2024-01-31 13:01:34','2025-01-31 13:01:34'),('5c5decc090b6bd1166a4b1a4b3e0d1bc1f450844f3b8fbd09d827fe37a1c95c98aef027232e38c3d',209,3,'authToken','[]',0,'2024-01-29 15:05:02','2024-01-29 15:05:02','2025-01-29 15:05:02'),('5cc9ac8318731aa3a3b08e7f9f5069a516451c77cac60412d4347f59ae70f035d52aeaaacf4bde24',209,3,'authToken','[]',0,'2024-01-30 07:56:18','2024-01-30 07:56:18','2025-01-30 07:56:18'),('5dea288bda6eec0a365e343600dfba8edc0238765826df9fe1c4e3e2b06dc44d0ec965444d7ef6c8',1,3,'authToken','[]',0,'2024-01-30 08:42:21','2024-01-30 08:42:21','2025-01-30 08:42:21'),('5fa56145ac9d97f4cf9ee3374cd836d3f977763a119970660a38685b117a9286491febb0f1f86096',210,3,'authToken','[]',0,'2024-01-30 09:18:05','2024-01-30 09:18:05','2025-01-30 09:18:05'),('60b207c852cbbad7c51afa769085d28fd34c7e9909828a7121650b84e1601f5d15541a02d349d624',202,3,'authToken','[]',0,'2024-01-29 14:04:44','2024-01-29 14:04:44','2025-01-29 14:04:44'),('61be7012e70166f6b744b9093790433adc7512a7e2448939d29685b522c97086ed73242bd47f2da3',201,3,'authToken','[]',0,'2024-01-25 12:50:42','2024-01-25 12:50:42','2025-01-25 12:50:42'),('61e451a7f61368c955ca841dcde753cb1e4e43550b9868b3d602bb40badff6b0a9a711dff21a592e',210,3,'authToken','[]',0,'2024-01-30 08:44:49','2024-01-30 08:44:49','2025-01-30 08:44:49'),('621c15cad6146d42dd687d61e80bedd3de4a35adfc94f415cd99340c2815c4c9d6e92ebf61358a85',173,1,'authToken','[]',0,'2024-01-08 19:07:03','2024-01-08 19:07:03','2025-01-08 21:07:03'),('62dccae641d541021565201cab7c3b1f15b9536185fa449355db35c8342359460b81fbb1263b9c31',206,3,'authToken','[]',0,'2024-01-29 13:35:58','2024-01-29 13:35:58','2025-01-29 13:35:58'),('62def21dd315400704507293c557a7ac34b09a3678f5996dc8eb1710acdf8fbc2ad8ddc3ea915250',172,1,'authToken','[]',0,'2024-01-08 18:58:48','2024-01-08 18:58:48','2025-01-08 20:58:48'),('64254b7926f3bd403653dd85518b9f645200ed297eb2fc0f352953d4683314f337fe7b5e4bc6f9b0',209,3,'authToken','[]',0,'2024-01-30 10:50:31','2024-01-30 10:50:31','2025-01-30 10:50:31'),('6494db092241a5132a1af39078aa601b07963cbad783165955e211c545736a49cc49dc318d2afd8b',210,3,'authToken','[]',0,'2024-01-30 08:10:26','2024-01-30 08:10:26','2025-01-30 08:10:26'),('649d0f32d3128dd15ac3253bc1a4db8d6760c25bc4a67c115ddf90f6378cbee50c87bb3cb94e3534',192,3,'authToken','[]',0,'2024-01-25 08:46:39','2024-01-25 08:46:39','2025-01-25 08:46:39'),('659a47bd8f74e0e350574a9fc81c8158d4cf3f9143797229ae104d6647edd210ab37309430b6aaff',209,3,'authToken','[]',0,'2024-01-30 07:51:44','2024-01-30 07:51:44','2025-01-30 07:51:44'),('6869b68961d85dd1270e7b3994b6165ef88e98df7e7794681bf4af3fe748df62a0793ae7a03e9843',209,3,'authToken','[]',0,'2024-01-30 07:26:35','2024-01-30 07:26:35','2025-01-30 07:26:35'),('68fc9834de5478a07a4d5a4c339af7cffe1213c65f935ecc41a519d2276eb294f865ef06ff65bd9a',209,3,'authToken','[]',0,'2024-01-30 09:35:51','2024-01-30 09:35:51','2025-01-30 09:35:51'),('690040df2ff3fcb15801ff48b1b2eae51b8f885b7ce1637bc41faa378c143ca2d0d2a2855887c6d5',207,3,'authToken','[]',0,'2024-01-25 14:13:10','2024-01-25 14:13:10','2025-01-25 14:13:10'),('690f698e2e27991d69b1a32896bd0e145ec767a071d4eceb0d334c78bb64002b77a86f3ec1926a15',209,3,'authToken','[]',0,'2024-02-01 20:54:11','2024-02-01 20:54:11','2025-02-01 20:54:11'),('69a295fff6c07599467006cc60b1f64fdc3cd56c9bcd6e57dac348f57749c4680a29640223bfafd3',212,3,'authToken','[]',0,'2024-01-30 08:44:39','2024-01-30 08:44:39','2025-01-30 08:44:39'),('6a17ae4c9b74f59385b819b8c78dadff123aa0331cfc5cc5ecae3648b4996b5e43cf8d6b9653abec',212,3,'authToken','[]',0,'2024-01-30 08:43:59','2024-01-30 08:43:59','2025-01-30 08:43:59'),('6a4bfa9c6f1ae28807dbb68821450b7e5527dcff22e0df8fbf3dfbb1f4e40ae3107acde75e9baccb',173,1,'authToken','[]',0,'2024-01-08 19:08:51','2024-01-08 19:08:51','2025-01-08 21:08:51'),('6c1527223de5f336fa5521d22654090c055f96abdeddfa764c28ebd3f24e15d1eb8b16ecb4e0ec99',210,3,'authToken','[]',0,'2024-01-30 09:18:30','2024-01-30 09:18:30','2025-01-30 09:18:30'),('6ce6da817aab66a1dcaaff3128a69ea6e5b7f19648b9a70879f11af694b3986ec705ef52ddcc969c',211,3,'authToken','[]',0,'2024-01-30 08:59:34','2024-01-30 08:59:34','2025-01-30 08:59:34'),('6e4cf5a84d6b05ca78cb85d49c641764b97036b8d8f5576055da56cb0c536e57070ee727305cc75e',202,3,'authToken','[]',0,'2024-01-29 14:13:02','2024-01-29 14:13:02','2025-01-29 14:13:02'),('6e704307b5bacb82ca454e6f7d5754bcf72c74b6e865648bd09d461582d4b521c5eb69f03ad93c6a',212,3,'authToken','[]',0,'2024-01-30 09:19:40','2024-01-30 09:19:40','2025-01-30 09:19:40'),('70118b7226bb5310dd672c41aa1481a3aa3e25814b01d1506e3092d10d063e0fd4735ea4d30913bd',202,3,'authToken','[]',0,'2024-01-29 13:49:56','2024-01-29 13:49:56','2025-01-29 13:49:56'),('701ab687944e3a6796da6dbda08f8c7923deeb3e2874ff919e0eacb95fbc86c0d87fa09c0e151b9f',212,3,'authToken','[]',0,'2024-01-30 08:35:31','2024-01-30 08:35:31','2025-01-30 08:35:31'),('7067e2179c059473dcd901c22e5b305dae80ec562a62ff140e90b3ee3e93cecc63b7ae4f7a011fd0',212,3,'authToken','[]',0,'2024-01-30 20:34:21','2024-01-30 20:34:21','2025-01-30 20:34:21'),('70c75cba544c033e8cd86630a2e0ea6b334fde4c5b75a0b86dbd3ff554db6317307fb34077b47be7',155,1,'authToken','[]',0,'2023-12-24 18:12:30','2023-12-24 18:12:30','2024-12-24 20:12:30'),('71c83391603e8beb0f9a4b29aa76228101bea2b37102bd75e4c08579c4524e228f91f0e393e152fd',209,5,'authToken','[]',0,'2024-02-02 09:49:14','2024-02-02 09:49:14','2025-02-02 09:49:14'),('72792c29e69f70d348371a1158ded72b19acb2ede4dbfc684dc371131597a5e98f830baef9768caf',209,5,'authToken','[]',0,'2024-02-03 10:16:22','2024-02-03 10:16:22','2025-02-03 10:16:22'),('745f6e18b5f9133907f2095345c7fa292055b377377cf02c0fe86ea414a04f6aa946bbcca82ae1d7',173,1,'authToken','[]',0,'2024-01-08 19:03:11','2024-01-08 19:03:11','2025-01-08 21:03:11'),('76efc3b2585f7771ee777dde4dcf0a5680a80c9943df42842242f106ef616999acb9e81bb1879820',209,3,'authToken','[]',0,'2024-02-01 21:44:22','2024-02-01 21:44:22','2025-02-01 21:44:22'),('784498884741438a05561956c4d6f91753edc221f0e20702e6ee8a0fa7356a9f69822a1be5bdce29',209,3,'authToken','[]',0,'2024-02-01 07:26:27','2024-02-01 07:26:27','2025-02-01 07:26:27'),('79d7a73dcfb4726a4a85ef04961f237cd714860349100a13b3aa75e997b36146171950a769d10457',184,3,'authToken','[]',0,'2024-01-25 08:18:49','2024-01-25 08:18:49','2025-01-25 08:18:49'),('7ac69270dfe9399d41f0f7c3a948628cfe57ebe2ed6aa75af8547d7176ecd89894fbf7c3fa0777d4',206,3,'authToken','[]',0,'2024-01-25 15:08:15','2024-01-25 15:08:15','2025-01-25 15:08:15'),('7ac779c3291fc010dd4d4cc3eb661b2394726c3fb0e0fbfd43da516f69fcbf3b9e37e0d1eb83644f',206,3,'authToken','[]',0,'2024-01-29 13:35:09','2024-01-29 13:35:09','2025-01-29 13:35:09'),('7f44b4e98e737ad2965b76a831d0cad7fbe3b8165cabf9f449206e6cf4e42317d4acbdd350b49c14',209,5,'authToken','[]',0,'2024-02-03 09:59:35','2024-02-03 09:59:35','2025-02-03 09:59:35'),('7f4c32b321e19d41fc803e6001222505aa5f5d55eea4516b97c8fde9b79460d5236cd6b9f01b4b04',209,3,'authToken','[]',0,'2024-01-29 15:02:39','2024-01-29 15:02:39','2025-01-29 15:02:39'),('809ccfe93de2efa1c53fd37fd03bc28d1bcbca58510572f7ebeb3d56269dfd9a653f78b5d77de30b',1,1,'authToken','[]',0,'2023-12-23 15:13:44','2023-12-23 15:13:44','2024-12-23 17:13:44'),('816039ed881b9b325eee08e367041dfc59991c1c28a6ef21f272f28a0ebe5aa90a5a1e37ea0e036b',209,5,'authToken','[]',0,'2024-02-02 09:52:43','2024-02-02 09:52:43','2025-02-02 09:52:43'),('84f2482f41f61760c418de6c6ac6042c61094be0eaf4bf5e537b70f23e0b9f17db1384937fff6f2a',209,3,'authToken','[]',0,'2024-01-30 08:33:51','2024-01-30 08:33:51','2025-01-30 08:33:51'),('853cd4d0f8655f7bce68b4c6a4abae11d48ffc0fa10a74b1e24596bd5da5ece28d73d357c9ad5dc7',210,3,'authToken','[]',0,'2024-02-01 16:29:54','2024-02-01 16:29:54','2025-02-01 16:29:54'),('8651b216fc0e3bf7d79205502213fb971265a2178b2e95a873314512b903511a6f83c93416e4168f',1,3,'authToken','[]',0,'2024-01-25 08:13:02','2024-01-25 08:13:02','2025-01-25 08:13:02'),('865610bf57ac8484b9d90217b02c850fe4accd2b869f85297fa0aacc210c81e947d12a227d672992',211,3,'authToken','[]',0,'2024-01-30 09:19:27','2024-01-30 09:19:27','2025-01-30 09:19:27'),('86efd51459e4356bcb1959b6169ffb84490e5f76809c07712e15c73772e1a2d2cebfd7a864a3be71',212,3,'authToken','[]',0,'2024-01-30 08:58:46','2024-01-30 08:58:46','2025-01-30 08:58:46'),('87122b52946f0a9772fb5c0a136bfe72a046287afca8006cf55c29c2e6d5ebe7b096ccd9da6661d4',1,3,'authToken','[]',0,'2024-01-17 10:58:25','2024-01-17 10:58:25','2025-01-17 10:58:25'),('88ed54fc1de158f0bfc9355e949efaa7efc9d3363daa56745d659a6648bb89a20e2e5b3991b4c064',209,5,'authToken','[]',0,'2024-02-02 10:34:34','2024-02-02 10:34:34','2025-02-02 10:34:34'),('88f1138891214462ab6810338cb263d0a3b18208ee59158fe1d41c09b05113eb8c5e69fe31b8c615',209,3,'authToken','[]',0,'2024-02-01 10:19:29','2024-02-01 10:19:29','2025-02-01 10:19:29'),('89cae15383fa7641fae115aa83dc124591c4f0a201ee0b1e30782c4039df994b1512df44eb2071c0',173,1,'authToken','[]',0,'2024-01-08 21:44:41','2024-01-08 21:44:41','2025-01-08 23:44:41'),('8b37cea17239f361222adc713a5337841c22709c6ae7748150cf45ad90023f5abfc5cc9055bdb43a',173,1,'authToken','[]',0,'2024-01-08 19:07:09','2024-01-08 19:07:09','2025-01-08 21:07:09'),('8cbfb1ea38182582a60af9ee0820d8a094a25b8ab6eb7c0942702a91ca3a14762243f497baf7ff8b',209,3,'authToken','[]',0,'2024-01-31 21:09:00','2024-01-31 21:09:00','2025-01-31 21:09:00'),('8d33f703a8bb10fd2166b861781be3940600e771113a1da07033e29b90da5c964f3202517b6018e5',212,3,'authToken','[]',0,'2024-01-30 09:09:12','2024-01-30 09:09:12','2025-01-30 09:09:12'),('8d685e4733c3d9f445d75fb2ff1db4f3716c26ed64f69dc51e788bf740a01186a70fdbfc561b66e1',209,3,'authToken','[]',0,'2024-01-30 07:57:29','2024-01-30 07:57:29','2025-01-30 07:57:29'),('8dec7a693aec165366793df7d6d62fca68e22ac8f4e182de5eff2c81ce060b9c8dd8f93b598c4eb2',192,3,'authToken','[]',0,'2024-01-25 09:30:04','2024-01-25 09:30:04','2025-01-25 09:30:04'),('8e0abc809d79600d38835bfa4e26b5cfee91d0d183d8cedb4e46796f2445983978f6c9be67ba2a0c',173,1,'authToken','[]',0,'2024-01-08 21:46:28','2024-01-08 21:46:28','2025-01-08 23:46:28'),('8e26496b6c2631f3766452b26535d267fabee057cf3045373b891e00e117e454093fb21d9f655cd9',1,1,'authToken','[]',0,'2023-12-23 15:15:34','2023-12-23 15:15:34','2024-12-23 17:15:34'),('8e92ecf3ff954461c5868b88005494eebccc3fdc32c7c5469170814353d5e8db8af58be023771173',211,3,'authToken','[]',0,'2024-01-30 08:24:24','2024-01-30 08:24:24','2025-01-30 08:24:24'),('8ed66d3ec5fac89a4c4bc1f98ae3f03ba16f58823895c6ffd31883b62ffa08857c869575c95e4efb',1,1,'authToken','[]',0,'2024-01-01 19:54:07','2024-01-01 19:54:07','2025-01-01 21:54:07'),('8f7188535cedc00d494d2067e539d18bc0f8c071a7c1e31aeda96b0159006718f0fef2bf5f640b97',209,5,'authToken','[]',0,'2024-02-03 10:50:38','2024-02-03 10:50:38','2025-02-03 10:50:38'),('90d641ae4f50bfd73535801b8e908e6a6c83d8d17d28ca3562f1b8a6f586b5033755d129d950ae8b',210,3,'authToken','[]',0,'2024-01-30 08:33:57','2024-01-30 08:33:57','2025-01-30 08:33:57'),('911c5694425598d8e3739bb4bddf0140b6e1b607a8ef6107eaf64e6ae9da8168f1665673cc01b5a7',212,3,'authToken','[]',0,'2024-01-31 20:38:07','2024-01-31 20:38:07','2025-01-31 20:38:07'),('91c5f979e571d53802099eebf527c55235d293ae19ca1db90dd6e44eec6cb6ad4fb9c1464477deed',175,1,'authToken','[]',0,'2024-01-08 22:06:56','2024-01-08 22:06:56','2025-01-09 00:06:56'),('9407ed830b1c27a154672d709c77451b0ab991bb09c0e0d2547095a40e81d8226e796d13e66867a7',209,3,'authToken','[]',0,'2024-01-30 07:59:18','2024-01-30 07:59:18','2025-01-30 07:59:18'),('951d2adf9eacc82daaf73f3e2ce54d229945e620c5bc8e26491243a21b76f3c4cd3657f8f52f1d9e',212,3,'authToken','[]',0,'2024-01-30 09:09:15','2024-01-30 09:09:15','2025-01-30 09:09:15'),('974bfcd757b2fae55152a60a63092db4ac272b9c0be2890193e7580714790c2b8c4ef10fffb2ae8b',209,3,'authToken','[]',0,'2024-01-30 20:29:43','2024-01-30 20:29:43','2025-01-30 20:29:43'),('986d32a9f56ea5b2347c2473541458a0a16a6b6d89564131e5130def0c7835a1031dd0f3a851705e',202,3,'authToken','[]',0,'2024-01-29 13:53:22','2024-01-29 13:53:22','2025-01-29 13:53:22'),('989008303b7dcaaf49f2ec03853098a6e953024ffbf96a1f8f48664a945dee61c8a3792d97a2e585',209,3,'authToken','[]',0,'2024-01-30 07:49:09','2024-01-30 07:49:09','2025-01-30 07:49:09'),('9b60118f04fc98095dc13f91822e829be77ab56f512de5add25c4e84267b9d9ac7b08d19455a5843',206,3,'authToken','[]',0,'2024-01-29 13:51:44','2024-01-29 13:51:44','2025-01-29 13:51:44'),('9bfc676b644dae78d48b04d5fe1691f3fcc8a88d8acb820e2e41fede64b20442cee47e8ffe51e5d7',185,3,'authToken','[]',0,'2024-01-25 08:33:39','2024-01-25 08:33:39','2025-01-25 08:33:39'),('9c6ca978c73120f975cb4fc788ca5eff790886392dd2f25e2404444bdf0dc07c654099836f091b33',209,3,'authToken','[]',0,'2024-02-01 21:36:44','2024-02-01 21:36:44','2025-02-01 21:36:44'),('9c72c345a4d336c207f747493796a2d29f2bd4118895b2a97570cf61c247ed4b481a4ca9870aa1f4',209,3,'authToken','[]',0,'2024-02-01 22:29:06','2024-02-01 22:29:06','2025-02-01 22:29:06'),('9cbaf9b32eddc5ee727fe50269e51ebd96e9bb21be470ae5368cf82d9ba589ba853342b6d66dbeec',209,3,'authToken','[]',0,'2024-01-29 15:06:22','2024-01-29 15:06:22','2025-01-29 15:06:22'),('9d735ffdb0d1f5ebc580cdb69647dbb31a52f1e9b50d1b5aa08363e0ce5e81359c301fdf51b1cf4d',212,3,'authToken','[]',0,'2024-01-30 20:40:31','2024-01-30 20:40:31','2025-01-30 20:40:31'),('9f39b8e8c9931b42ab7c0810b02ca24752d9f5c7029087f7f989eab36ff81d1b64455b9025f02dff',209,3,'authToken','[]',0,'2024-01-30 07:38:43','2024-01-30 07:38:43','2025-01-30 07:38:43'),('a182732ea8e21224e01a5ec5fc835f852800063a7597d55109009852ab7be08519b3d7f35c4cb076',212,3,'authToken','[]',0,'2024-01-30 08:34:21','2024-01-30 08:34:21','2025-01-30 08:34:21'),('a19034c1eaedcb9d68f0cedeccef466839364605cbefa890dfd89280a3521c292b45a8d26576f846',168,1,'authToken','[]',0,'2023-12-25 19:21:14','2023-12-25 19:21:14','2024-12-25 21:21:14'),('a1bd26c630f57c290d7c001c509a9402fa74557d84b746dc88b66d72c30fb0bb92682fb1da0b7da1',168,1,'authToken','[]',0,'2023-12-25 19:21:33','2023-12-25 19:21:33','2024-12-25 21:21:33'),('a43937d876bf7d3b171cbc93cc57ddabf5017454c9b972e3245a477da903ab6f79c3715817db5518',1,1,'authToken','[]',0,'2024-01-01 19:09:09','2024-01-01 19:09:09','2025-01-01 21:09:09'),('a4ec07887649e83a06614bb9efc492f5c6f6fea2b81b39535b492d30283d3b82b71061b8c5f8b2ca',209,5,'authToken','[]',0,'2024-02-03 09:09:13','2024-02-03 09:09:13','2025-02-03 09:09:13'),('a5f691dfab2dc0ac1522fa064f7b82608475e5838cb6b2f7bafa0964291bb85dee12ba7b2f51e33c',209,3,'authToken','[]',0,'2024-01-29 14:18:53','2024-01-29 14:18:53','2025-01-29 14:18:53'),('a69361c0d9c9c32b6988087c203cdc9d33ff9127d11123471275c7299eecf015b82e96b22941f3b0',192,3,'authToken','[]',0,'2024-01-25 09:29:27','2024-01-25 09:29:27','2025-01-25 09:29:27'),('a69f70dc19ea471e2352d54d342cdbaba3bd4bd1851e196a03c0e52d3f74d24d010bdbd92cddfe57',189,3,'authToken','[]',0,'2024-01-25 08:35:25','2024-01-25 08:35:25','2025-01-25 08:35:25'),('a8a58d4f73f2e2085ee7e38727e259887d74ed509f6901fe9c88f1c17224fc1df559b7d5bbb9c1b5',1,1,'authToken','[]',0,'2023-12-23 15:15:44','2023-12-23 15:15:44','2024-12-23 17:15:44'),('a910814456f28407c279cc8e2f3b56330554913b7f4da1b7e9353afc6a71ad974d3edc7b19538962',209,5,'authToken','[]',0,'2024-02-03 10:50:27','2024-02-03 10:50:27','2025-02-03 10:50:27'),('a924352d06cfcb9cf9e4acb08ae80756bbf84dcd6cf3154855e6e082b4f547ad834fe358657dab84',206,3,'authToken','[]',0,'2024-01-29 13:51:48','2024-01-29 13:51:48','2025-01-29 13:51:48'),('a9fff3cd78298b1e2c7390899fe72116e94a7116b27f8e90fcde886f6e61017633da3ce50b27595f',209,3,'authToken','[]',0,'2024-01-31 20:33:11','2024-01-31 20:33:11','2025-01-31 20:33:11'),('aa3d86dd502149794aab29c8e28c128bbd5f354d103ad759541dc9292ab8374c39fd78c6aabd632a',173,1,'authToken','[]',0,'2024-01-08 19:05:31','2024-01-08 19:05:31','2025-01-08 21:05:31'),('aa8acb11a4c739e63ece97ff8d3300bdeccdaeeefd9a06bcd720693ea9d118cc9383a3e994ee13ff',209,3,'authToken','[]',0,'2024-01-30 07:57:04','2024-01-30 07:57:04','2025-01-30 07:57:04'),('ab73243686a15d2559936c82af7964f9f05cbbfd83aae2d7ac73f550cefb780bfb8b47271d624533',212,3,'authToken','[]',0,'2024-01-31 10:38:34','2024-01-31 10:38:34','2025-01-31 10:38:34'),('ab96ac8061970578f4f9c01977a4ea91956677f8673d751cec997006c3bf80e74f7e501f1e7a13dd',209,3,'authToken','[]',0,'2024-01-31 09:17:09','2024-01-31 09:17:09','2025-01-31 09:17:09'),('abee36a42a8c46c13b8429fc975434a9d344bcd09ef48f0372c03541fafce122f2c96f047881eb29',209,5,'authToken','[]',0,'2024-02-02 17:12:51','2024-02-02 17:12:51','2025-02-02 17:12:51'),('acbb298b8a2bdb3c035a39fbe8a4b3fa23ff39e7810449ad1de73d4e75ec96011a155cc72499f623',209,3,'authToken','[]',0,'2024-02-01 20:53:18','2024-02-01 20:53:18','2025-02-01 20:53:18'),('add00d50750794553c105e31441a5a566bdbdfb5c73d58a437c62d0484c20c99bbf3314d746b30a3',209,5,'authToken','[]',0,'2024-02-02 09:49:10','2024-02-02 09:49:10','2025-02-02 09:49:10'),('adf22fd28a9962c47fbf6496c6539d6db18c5cb48dfe674bbb638f5ccde02e56db823c96743afbf2',209,5,'authToken','[]',0,'2024-02-03 08:51:29','2024-02-03 08:51:29','2025-02-03 08:51:29'),('af604cbb30cecdfc1f917b0a26951b0bedd19c6afa2fecf27cc0edbb29fcd88062929b24787f187b',212,3,'authToken','[]',0,'2024-01-30 09:08:44','2024-01-30 09:08:44','2025-01-30 09:08:44'),('b18a1ce1efe8f53462230991e4579a5abd7400e096bbb091f5aadc51e26e5661bde19995863bf2e8',211,3,'authToken','[]',0,'2024-01-30 20:33:57','2024-01-30 20:33:57','2025-01-30 20:33:57'),('b1ebc527662086cd94a40d8ceb9513467cc0315bd24304ff1a11c482eabf31e85cfbda3a33760681',170,1,'authToken','[]',0,'2024-01-01 19:53:33','2024-01-01 19:53:33','2025-01-01 21:53:33'),('b761b4d14aeba8c1456f07784ed0c807616c5af24026c397d23091395fef7427cc00b393b387f3c3',206,3,'authToken','[]',0,'2024-01-29 13:35:27','2024-01-29 13:35:27','2025-01-29 13:35:27'),('b77bd5e8becdb44e9b83699c871f07d2f9b79761c511d025da4a6e71e01b7cd5147395d8a4f52f80',209,5,'authToken','[]',0,'2024-02-02 11:05:29','2024-02-02 11:05:29','2025-02-02 11:05:29'),('b95b29d90ba410b422cad1c7822a567d511febf870b6e4475ffbc8e545791645fb86e3eac835156e',212,3,'authToken','[]',0,'2024-01-31 20:32:01','2024-01-31 20:32:01','2025-01-31 20:32:01'),('b9c1ca22b5a97f2bcc359ab1de79cf972c95bf10f83133f7eb07b7ff0aabe59d293ff591a9855e11',212,3,'authToken','[]',0,'2024-01-30 09:13:03','2024-01-30 09:13:03','2025-01-30 09:13:03'),('bba12efdf7a53f85920181da5e878fdbd3d3e8f13adc5987a52598b06bf2187aa27e3c6abd43b4da',192,3,'authToken','[]',0,'2024-01-25 08:52:00','2024-01-25 08:52:00','2025-01-25 08:52:00'),('bcebb175c048c66e6e182436501e3af474d95dfc338773cc9a2ccb8873b93f5bcca0852a49098b23',209,5,'authToken','[]',0,'2024-02-02 17:18:53','2024-02-02 17:18:53','2025-02-02 17:18:53'),('c28479e194705f562df3ebf3b9bd8ae313727749c79c3ecf34481afe594147e9ee19ae22dcb2b2fa',1,1,'authToken','[]',0,'2023-12-24 17:39:23','2023-12-24 17:39:23','2024-12-24 19:39:23'),('c336d569f999a5d2c14fe12106c25ea406a90b29e3f02711391ab4133e6237d6be18a86c6253ab9d',209,3,'authToken','[]',0,'2024-01-30 20:02:40','2024-01-30 20:02:40','2025-01-30 20:02:40'),('c390ed528df1ea7034c141aa01367d738ea3145a52e3eefeb2d8181cf82515b8a92916531513e003',209,5,'authToken','[]',0,'2024-02-03 08:51:00','2024-02-03 08:51:00','2025-02-03 08:51:00'),('c7116dd971621bea405ca56af562147cffef3d148b3c9549d6e276806b44ae8c9b67382135230a8f',1,1,'authToken','[]',0,'2023-12-23 15:13:56','2023-12-23 15:13:56','2024-12-23 17:13:56'),('c7961b551772fd38036a2067351b277e53ff22e261ebe8399340bb8b80e74d0aafbde91fb0763b79',209,5,'authToken','[]',0,'2024-02-03 10:55:08','2024-02-03 10:55:08','2025-02-03 10:55:08'),('c8d22cd8d96f8100666180a1eeccb6b47829033d16fa6baf478742a6fbc6a502aee68346daa3462a',209,5,'authToken','[]',0,'2024-02-02 09:47:48','2024-02-02 09:47:48','2025-02-02 09:47:48'),('c9c71fb64af3ed6ef37e79ebd2b85c853e37e452aa9ee4b3d815d95a2b46922f8ccdcdd301419be1',209,3,'authToken','[]',0,'2024-01-30 09:27:53','2024-01-30 09:27:53','2025-01-30 09:27:53'),('cbae94c3402c4617e90007ab31a1f3c912c620e8275ad0aa21d3b0f40a89b445ce0f7074ccd0036f',210,3,'authToken','[]',0,'2024-01-30 08:44:32','2024-01-30 08:44:32','2025-01-30 08:44:32'),('cbb027c55c478a8fae2afd7a8d6a349f9c031e5417a509486510c31f38a05c65aea2dbd754471d54',168,1,'authToken','[]',0,'2024-01-01 19:55:05','2024-01-01 19:55:05','2025-01-01 21:55:05'),('cd8fc212c7a388cead7816c4cd16b38a3c3076f6a85f34f7cccfd3c369d5a50fabf3b46a47cf6087',210,3,'authToken','[]',0,'2024-01-30 08:27:47','2024-01-30 08:27:47','2025-01-30 08:27:47'),('cdc0e92059863c31e5406944eef48e3f65ceed64e8da8effd6b9e554096377f6ae43f929ca840a81',173,1,'authToken','[]',0,'2024-01-08 19:07:45','2024-01-08 19:07:45','2025-01-08 21:07:45'),('ce697aba280ac27b3b10034a4882c46a18f7b56aaf2f3e0b77bb57959624e4379273b7ec310b2998',180,3,'authToken','[]',0,'2024-01-15 12:16:42','2024-01-15 12:16:42','2025-01-15 12:16:42'),('cea9bcd6e0b403326da070a6d4ea7f4e70d4db80a4685b83d0f35db1b7edaed7def10dacfae66667',202,3,'authToken','[]',0,'2024-01-29 13:53:27','2024-01-29 13:53:27','2025-01-29 13:53:27'),('cf2d0bcf68a976cd5aa4f943aa540a520dc6a7c14ea8f1160a67e1025d07d70940a69267097d18d7',209,3,'authToken','[]',0,'2024-01-30 09:19:15','2024-01-30 09:19:15','2025-01-30 09:19:15'),('cf6e058a9cdd3fd3296fe9e2ff42d3ff64065b5a6eea7f601c9e73dfe14abf0b8884376c076f6861',209,3,'authToken','[]',0,'2024-01-30 09:21:30','2024-01-30 09:21:30','2025-01-30 09:21:30'),('cfc08f1bb54545b045860f673d421abae6da2f729443bba5c961a7f49354ff169b846710113d3442',212,3,'authToken','[]',0,'2024-01-30 08:28:38','2024-01-30 08:28:38','2025-01-30 08:28:38'),('d08aa33fe2df5af9efb23ed835838849d221631422b60bff137b3ee417141fd4cc8bc3a05bfe0ccb',209,5,'authToken','[]',0,'2024-02-02 10:42:59','2024-02-02 10:42:59','2025-02-02 10:42:59'),('d0da988f90ff5d737e4dd57fb90a29a9ebe29b50be2cc434b338054cd4a3311a7d4aaad8edf6e73f',212,3,'authToken','[]',0,'2024-01-30 09:09:40','2024-01-30 09:09:40','2025-01-30 09:09:40'),('d1204ccc274189941b0511f34c259c3fc73ec7d9a0a08ee0ef9a00dc30b32c8b2253f16ed7b15c7d',209,3,'authToken','[]',0,'2024-01-30 07:52:18','2024-01-30 07:52:18','2025-01-30 07:52:18'),('d160c742dea1a3338eb2bf3a86101daf54830cbba42834ce0dbfebe87912a55bb382692085b436c9',210,3,'authToken','[]',0,'2024-01-30 08:09:25','2024-01-30 08:09:25','2025-01-30 08:09:25'),('d1db97b07996a1d6c1f7408b5bc4bfb4fec29ffd49f16b648d51cb25ea52f810e753750c7b3ea54e',209,3,'authToken','[]',0,'2024-01-30 09:17:06','2024-01-30 09:17:06','2025-01-30 09:17:06'),('d27a38027d3194d01a7b000b0034939309930ab1f233e49306c4e20d5f35d02aa0ac378995d7a804',182,3,'authToken','[]',0,'2024-01-25 08:08:12','2024-01-25 08:08:12','2025-01-25 08:08:12'),('d2be2a6f19b951573fd92d7f73cb4ecdff9b826d2ac787748376def8f1798530e0ba73cf38906355',212,3,'authToken','[]',0,'2024-01-30 08:25:54','2024-01-30 08:25:54','2025-01-30 08:25:54'),('d3486fd340c7df1256c3eb97a1dc5edf2803cb385f78974f51e5f2fb02ad14f6e970ed33ebe76c8a',209,5,'authToken','[]',0,'2024-02-03 10:50:58','2024-02-03 10:50:58','2025-02-03 10:50:58'),('d4cdd388cc4256db80b1afdb818cb30950bdcd38ade5f24f63e6248432356e35d0ec5dede0dabd93',209,3,'authToken','[]',0,'2024-01-30 07:55:14','2024-01-30 07:55:14','2025-01-30 07:55:14'),('d68d11d57f783f0ac5d62dd65bc8222433fe4df32cd70d348ce0841b470a7012306367e100197eee',212,3,'authToken','[]',0,'2024-01-30 08:35:39','2024-01-30 08:35:39','2025-01-30 08:35:39'),('d8b68f3113e881ef0d3dc74d34cabaedfd54ca2d6d1d97132469bc047eb0330d35a34f649ee232a6',212,3,'authToken','[]',0,'2024-01-30 08:44:21','2024-01-30 08:44:21','2025-01-30 08:44:21'),('d9d3ba3c3f8374a8edd1711efc0020638478c8c93b344ef1381b7209653c7a1ca829fd9cd9e2b419',209,5,'authToken','[]',0,'2024-02-01 22:38:51','2024-02-01 22:38:51','2025-02-01 22:38:51'),('db49209f683e3016fbb5517247bf042e00ea97155617098739eb7abac6cd8efb126eb882b740990d',209,3,'authToken','[]',0,'2024-01-29 15:05:18','2024-01-29 15:05:18','2025-01-29 15:05:18'),('dbb4265f6713241e00e0a8781b9d9540575ecb1d584b190393e9e2d853961062197b3912f238dc77',209,3,'authToken','[]',0,'2024-01-29 14:18:45','2024-01-29 14:18:45','2025-01-29 14:18:45'),('dc3ecd95542da1ca9e736c68989df0f9d9a0f1fac901307f98a24b13fd4fce1602f7b3feb249bc55',209,5,'authToken','[]',0,'2024-02-02 11:03:26','2024-02-02 11:03:26','2025-02-02 11:03:26'),('dc9795b4339ab4fe4e4714466c371c5c0a27023f7644d38baea45b72ea23bf3bb59d9e0cac1b3dbd',1,1,'authToken','[]',0,'2024-01-08 18:58:01','2024-01-08 18:58:01','2025-01-08 20:58:01'),('dcbd3c0c58c310a21cba29bde73f3d73ab5ef613cb90ba5c05c6a8669e7e3c020240bb0630cc34cc',210,3,'authToken','[]',0,'2024-01-30 08:09:13','2024-01-30 08:09:13','2025-01-30 08:09:13'),('ddc6eb6acef9e3aa9948dbfcd1660ecebde01f7a556cae58aa64742ec6822c241972fb9597955ae1',209,3,'authToken','[]',0,'2024-01-30 07:56:43','2024-01-30 07:56:43','2025-01-30 07:56:43'),('de05540f5ad877f68b8be8c04ab95ae6e42de87aaf10a53899e8e7f6fb219d22fd717eb19b12c69f',209,3,'authToken','[]',0,'2024-01-30 20:36:42','2024-01-30 20:36:42','2025-01-30 20:36:42'),('e0542b64a2c67968be7cdc8497a645ab9359dbf89db63149a55418a7934ca08a148ee08f749fd375',208,3,'authToken','[]',0,'2024-01-25 14:58:58','2024-01-25 14:58:58','2025-01-25 14:58:58'),('e2ca50c8d4837529944fa201395e64aaea6bc590069a67fa4f7aa8a4b85e86b817b363007a1a009d',209,3,'authToken','[]',0,'2024-01-29 14:17:27','2024-01-29 14:17:27','2025-01-29 14:17:27'),('e2e232dc76ed1340bcc457ac7222581ca329e933bdfba91c453bd76ed47ea84f627d4518a00327a9',209,3,'authToken','[]',0,'2024-02-01 21:06:50','2024-02-01 21:06:50','2025-02-01 21:06:50'),('e5aa1d36d0e21d1ddacf1c47cce9f6ed0d2bdcf5c856e2f11b75e0b1f2a1b93f8698dac4995a897a',211,3,'authToken','[]',0,'2024-01-30 08:11:15','2024-01-30 08:11:15','2025-01-30 08:11:15'),('e60edd5da2a0c63e76eb9321d052b84cc5bb3e0ed329bc6cce93cc1a63523c89ed08a10abf86ba2c',206,3,'authToken','[]',0,'2024-01-29 13:51:42','2024-01-29 13:51:42','2025-01-29 13:51:42'),('e6d048a776a777fdfa3068d91c6340f7f85517c47df0a71c3c02fb01f512e6d6465a43fc54cc6a02',209,3,'authToken','[]',0,'2024-01-31 10:09:58','2024-01-31 10:09:58','2025-01-31 10:09:58'),('e6daf50a8e7e7ed36a0e3b77281248a4fd9e6c121ddef6a622a66921ace6d358168d3e861a50646b',206,3,'authToken','[]',0,'2024-01-25 15:27:19','2024-01-25 15:27:19','2025-01-25 15:27:19'),('e6e003154bc3e60e46bab53dbed5960dea7cd198f0827476201468931e003771e3fc15f22fc74cc4',209,5,'authToken','[]',0,'2024-02-03 10:05:22','2024-02-03 10:05:22','2025-02-03 10:05:22'),('e706d522753b31d442bf5b12c7273a2c9881b4d95ac8ae58011b6d2f91d6d9f3cbce2fd60e8f8d31',183,3,'authToken','[]',0,'2024-01-25 08:06:15','2024-01-25 08:06:15','2025-01-25 08:06:15'),('e86f24f3ee585ffbf4b0cb2c5e8ef9e09bfc1f45ed41de4b74943184abc0ac2608ba92e73da61347',209,3,'authToken','[]',0,'2024-02-01 20:53:56','2024-02-01 20:53:56','2025-02-01 20:53:56'),('e9f1eaf0c3288e81947dc0dcf9b94aa7798a1f234517759b1e28fcfc01baad1e1c52d9b5f53aa101',206,3,'authToken','[]',0,'2024-01-25 15:27:07','2024-01-25 15:27:07','2025-01-25 15:27:07'),('ed18cc0e3c6f9e70ae8e4c1795e6b1d8925bf0f51348fe3882dcb2dde2b8a71f2f3929be15d9601b',202,3,'authToken','[]',0,'2024-01-29 13:52:47','2024-01-29 13:52:47','2025-01-29 13:52:47'),('ed5c940c93e687500fe87057c6470b009cf33ddc263a0e2437fab42d941c04aa86881e3c4564ebf2',210,3,'authToken','[]',0,'2024-01-30 08:09:01','2024-01-30 08:09:01','2025-01-30 08:09:01'),('edd74c96bb95ea209289425f9680e6c894fc46ff19e5cb8556e5eea707f7c766a79f77a22fec1ce0',209,3,'authToken','[]',0,'2024-01-30 20:04:13','2024-01-30 20:04:13','2025-01-30 20:04:13'),('ee7d3fe299fbb484e57bb9393904f6d129487119831cc7aa6f51735da134eb25c85a1412814bd0b7',210,3,'authToken','[]',0,'2024-01-30 08:59:28','2024-01-30 08:59:28','2025-01-30 08:59:28'),('ef84bb602227e847b97b64515e6997a8ab0b095ae5e0a3d935d2a0df3d958eff902573d76b13b8bc',209,3,'authToken','[]',0,'2024-01-30 08:59:23','2024-01-30 08:59:23','2025-01-30 08:59:23'),('ef941a8399dd8208e0a9f5fe644943f9248d7fed0de208a68342f6d3203b226ab34140146860634f',209,5,'authToken','[]',0,'2024-02-03 10:14:40','2024-02-03 10:14:40','2025-02-03 10:14:40'),('efa5f3d099f7abfc3a65f143782747c9f428b524d75954c7258fafdc7770940d23d2abc356a11a0f',206,3,'authToken','[]',0,'2024-01-25 14:20:58','2024-01-25 14:20:58','2025-01-25 14:20:58'),('f099d642c64b8b6ef05832fd723795c6907f9ff8ada1b7cf43cd7a9dc1661ee808c37ae1e4d36b9d',212,3,'authToken','[]',0,'2024-01-30 08:27:26','2024-01-30 08:27:26','2025-01-30 08:27:26'),('f09f215e391126c4844a3059a407f15d1c4b99e55d74324486b71f9d9c8831e9b2c34e2d08b1a289',1,3,'authToken','[]',0,'2024-01-25 07:57:37','2024-01-25 07:57:37','2025-01-25 07:57:37'),('f0e3c577ee5e42379a369ff086a40246e773cc2cd8dc5b0b30276d347fd1043255f9d77beef69599',202,3,'authToken','[]',0,'2024-01-29 14:01:43','2024-01-29 14:01:43','2025-01-29 14:01:43'),('f1f113faeaf67f3a4ffb05006db4246319c1ecb1a499772ba730bac4312554f53a63f96100c3b027',1,1,'authToken','[]',0,'2023-12-23 15:15:41','2023-12-23 15:15:41','2024-12-23 17:15:41'),('f2015bb2647689b80f7c50a4d07fa448969be3df9647c87507ce6c1f56f485f0f2b19c5271c95731',212,3,'authToken','[]',0,'2024-01-31 20:43:07','2024-01-31 20:43:07','2025-01-31 20:43:07'),('f26603e7f15e673cd942a5a35dbc81d17b4b1778144fba7806f3677c8959c914dacfbd64f442cdc1',209,3,'authToken','[]',0,'2024-01-30 13:38:48','2024-01-30 13:38:48','2025-01-30 13:38:48'),('f2f915448d79dd8d8cc871a2bb5962a11c491cb4ae11dca66556552c2d820f6e08d3e0cac916299a',209,3,'authToken','[]',0,'2024-02-01 22:15:55','2024-02-01 22:15:55','2025-02-01 22:15:55'),('f37768d5729ade2c8f0b49130b2581a2800d397b62bfe7399e468b0069409d807159da55bf01068e',1,3,'authToken','[]',0,'2024-01-25 08:10:52','2024-01-25 08:10:52','2025-01-25 08:10:52'),('f83849d097e933e0bef5f53c521923e1166a82bf663ae9380c9eadfef6db05d3e69d58343649742a',210,3,'authToken','[]',0,'2024-01-30 08:43:17','2024-01-30 08:43:17','2025-01-30 08:43:17'),('f8542bbdccfe4f8f629dda2f46ddf49d80e686754b3200398ef5058a8cb1e4a23172d4a1ccb75408',173,1,'authToken','[]',0,'2024-01-08 19:10:12','2024-01-08 19:10:12','2025-01-08 21:10:12'),('f9ab964f22e9c1b3f233342c3f2164e17ef918c71e62008417275ffbc5519ed7bf34f0d004df40e6',209,5,'authToken','[]',0,'2024-02-03 10:03:16','2024-02-03 10:03:16','2025-02-03 10:03:16'),('fbb7d1aec8f7f1e4ab2c8f61dd598bd2261536c24dde5d8811ba7f5fcb5768ea18729b383610a8b2',209,5,'authToken','[]',0,'2024-02-03 10:51:23','2024-02-03 10:51:23','2025-02-03 10:51:23'),('fc751fb4171fad6f2f0b69a7bc27af5f7acf740157b7e8d1fa9de8117fbbc582dc465c5a722db6a8',209,3,'authToken','[]',0,'2024-01-30 09:13:54','2024-01-30 09:13:54','2025-01-30 09:13:54'),('fc9738d5ab3c578f07c130158c37cccdcb6319f2b73f0a13b649756b5778dc5e06bb41bded006321',211,3,'authToken','[]',0,'2024-01-30 08:25:21','2024-01-30 08:25:21','2025-01-30 08:25:21'),('fd633e0100fd80986db23cb05508a22f036858a6c962be7bcf62f4a6699a4ab826686a66ef85a31f',202,3,'authToken','[]',0,'2024-01-29 13:55:19','2024-01-29 13:55:19','2025-01-29 13:55:19'),('fd7ce68525524bc652366f8f492c7ecdee171a4cda0c2e847c50c586d9919968cf9f78dc3aa68312',172,1,'authToken','[]',0,'2024-01-08 19:00:08','2024-01-08 19:00:08','2025-01-08 21:00:08'),('fd945dea9bdeb0c4281810762cd81f64b2ca7bee26fd91973ba7c9fc1b55b0661aff1898f821f93d',209,3,'authToken','[]',0,'2024-01-30 07:55:28','2024-01-30 07:55:28','2025-01-30 07:55:28');
/*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_auth_codes`
--

DROP TABLE IF EXISTS `oauth_auth_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `client_id` bigint unsigned NOT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_auth_codes`
--

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

--
-- Table structure for table `oauth_clients`
--

DROP TABLE IF EXISTS `oauth_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_clients`
--

LOCK TABLES `oauth_clients` WRITE;
/*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */;
INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES (1,NULL,'Laravel Personal Access Client','S2nAw9uadHtufnLSYCInPkOx9OqjYwf45H9j6He9',NULL,'http://localhost',1,0,0,'2023-12-23 14:57:24','2023-12-23 14:57:24'),(2,NULL,'Laravel Password Grant Client','GRlju3q92LBadmLUCrWbRbWpeokkvwV0Rx9pAdPx','users','http://localhost',0,1,0,'2023-12-23 14:57:24','2023-12-23 14:57:24'),(3,NULL,'Laravel Personal Access Client','pgjZi8RENhcf4SCS4uKCqoKjC5DhzLPUFTJ8sWht',NULL,'http://localhost',1,0,0,'2024-01-13 05:34:46','2024-01-13 05:34:46'),(4,NULL,'Laravel Password Grant Client','1s2BHAdC9OooWXowpLX2fKulE7zYcSJLFuVz0egO','users','http://localhost',0,1,0,'2024-01-13 05:34:46','2024-01-13 05:34:46'),(5,NULL,'Laravel Personal Access Client','2OPqyUKrlmJbOR5tKvCA9ylQOpbVyuxThcrdLQxG',NULL,'http://localhost',1,0,0,'2024-02-01 22:31:11','2024-02-01 22:31:11');
/*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_personal_access_clients`
--

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

--
-- Dumping data for table `oauth_personal_access_clients`
--

LOCK TABLES `oauth_personal_access_clients` WRITE;
/*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */;
INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES (1,1,'2023-12-23 14:57:24','2023-12-23 14:57:24'),(2,3,'2024-01-13 05:34:46','2024-01-13 05:34:46'),(3,5,'2024-02-01 22:31:11','2024-02-01 22:31:11');
/*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_refresh_tokens`
--

DROP TABLE IF EXISTS `oauth_refresh_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_refresh_tokens`
--

LOCK TABLES `oauth_refresh_tokens` WRITE;
/*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_refresh_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(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(125) CHARACTER SET utf8mb4 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 */;
INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES ('enar.qasim@gmail.com','$2y$10$WvWr7UVq2tsqqvtDGcp.WOS.B2ud1zGg9WNUIAjipsm.1Duvvsp12','2022-08-12 10:30:08'),('zahehalharbe@gmail.com','$2y$10$Xsv4vtJmJJldD3YW1uZ74eqcYJXp3GvXDM2HZ8vSqL3eRL0LK3Zfi','2022-10-15 19:15:26');
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `paymet_type_translations`
--

DROP TABLE IF EXISTS `paymet_type_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `paymet_type_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `paymet_type_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `paymet_type_translations_paymet_type_id_locale_unique` (`paymet_type_id`,`locale`),
  KEY `paymet_type_translations_locale_index` (`locale`),
  CONSTRAINT `paymet_type_translations_paymet_type_id_foreign` FOREIGN KEY (`paymet_type_id`) REFERENCES `paymet_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `paymet_type_translations`
--

LOCK TABLES `paymet_type_translations` WRITE;
/*!40000 ALTER TABLE `paymet_type_translations` DISABLE KEYS */;
INSERT INTO `paymet_type_translations` (`id`, `name`, `paymet_type_id`, `locale`, `created_at`, `updated_at`) VALUES (1,'MADA',1,'en','2024-01-18 16:26:39','2024-01-18 16:26:39'),(2,'مدى',1,'ar','2024-01-18 16:26:39','2024-01-18 16:26:39'),(3,'VISA',2,'en','2024-01-18 16:26:39','2024-01-18 16:26:39'),(4,'فيزا',2,'ar','2024-01-18 16:26:39','2024-01-18 16:26:39');
/*!40000 ALTER TABLE `paymet_type_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `paymet_types`
--

DROP TABLE IF EXISTS `paymet_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `paymet_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(125) CHARACTER SET utf8mb4 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `paymet_types`
--

LOCK TABLES `paymet_types` WRITE;
/*!40000 ALTER TABLE `paymet_types` DISABLE KEYS */;
INSERT INTO `paymet_types` (`id`, `image`, `created_at`, `updated_at`) VALUES (1,NULL,'2024-01-18 16:26:39','2024-01-18 16:26:39'),(2,NULL,'2024-01-18 16:26:39','2024-01-18 16:26:39');
/*!40000 ALTER TABLE `paymet_types` ENABLE KEYS */;
UNLOCK TABLES;

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

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

--
-- Dumping data for table `permissions`
--

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

--
-- Table structure for table `phone_codes`
--

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

--
-- Dumping data for table `phone_codes`
--

LOCK TABLES `phone_codes` WRITE;
/*!40000 ALTER TABLE `phone_codes` DISABLE KEYS */;
INSERT INTO `phone_codes` (`id`, `user_id`, `code`, `created_at`, `updated_at`) VALUES (3,4,'rijp7','2022-06-13 18:29:50','2022-06-13 18:29:50'),(13,16,'jwojv','2022-06-27 20:14:08','2022-06-27 20:14:08'),(21,27,'5s4gp','2022-08-02 09:47:00','2022-08-02 09:47:00'),(25,32,'67zyv','2022-08-02 11:38:25','2022-08-02 11:38:25'),(26,33,'0rw4s','2022-08-02 16:22:03','2022-08-02 16:22:03'),(27,36,'xjg6r','2022-08-02 17:42:36','2022-08-02 17:42:36'),(28,37,'vp42v','2022-08-02 18:07:34','2022-08-02 18:07:34'),(29,38,'xr76j','2022-08-03 02:48:21','2022-08-03 02:48:21'),(30,39,'f4s3c','2022-08-05 17:25:27','2022-08-05 17:25:27'),(31,40,'jpjo4','2022-08-06 22:01:18','2022-08-06 22:01:18'),(32,41,'wwv6j','2022-08-06 23:51:33','2022-08-06 23:51:33'),(33,42,'xo8zb','2022-08-07 06:01:02','2022-08-07 06:01:02'),(34,43,'6unqw','2022-08-07 06:07:42','2022-08-07 06:07:42'),(35,44,'2t8n4','2022-08-07 08:36:43','2022-08-07 08:36:43'),(36,45,'5fwvy','2022-08-08 02:04:16','2022-08-08 02:04:16'),(39,48,'iwsmp','2022-08-12 10:26:54','2022-08-12 10:26:54'),(40,49,'jzptd','2022-08-12 10:34:47','2022-08-12 10:34:47'),(41,50,'2xwuh','2022-08-12 10:54:37','2022-08-12 10:54:37'),(42,51,'hnryd','2022-08-12 12:36:22','2022-08-12 12:36:22'),(43,52,'y0tz6','2022-08-12 12:36:47','2022-08-12 12:36:47'),(44,53,'586hc','2022-08-12 14:15:14','2022-08-12 14:15:14'),(45,54,'3hkz5','2022-08-13 02:14:52','2022-08-13 02:14:52'),(46,55,'uyrgf','2022-08-13 08:13:33','2022-08-13 08:13:33'),(47,56,'citpv','2022-08-13 08:27:11','2022-08-13 08:27:11'),(48,57,'d6nch','2022-08-13 09:59:31','2022-08-13 09:59:31'),(49,58,'orgtu','2022-08-13 10:02:39','2022-08-13 10:02:39'),(50,59,'apx68','2022-08-13 10:06:29','2022-08-13 10:06:29'),(51,60,'z62cz','2022-08-13 10:17:33','2022-08-13 10:17:33'),(52,61,'xo5mk','2022-08-13 12:51:11','2022-08-13 12:51:11'),(53,62,'nmjwt','2022-08-13 18:32:04','2022-08-13 18:32:04'),(54,63,'7jccx','2022-08-13 22:22:44','2022-08-13 22:22:44'),(55,64,'av2te','2022-08-14 00:28:43','2022-08-14 00:28:43'),(56,65,'wjivk','2022-08-14 03:24:44','2022-08-14 03:24:44'),(57,66,'za2ar','2022-08-14 11:29:10','2022-08-14 11:29:10'),(58,67,'7xxtn','2022-08-14 14:42:49','2022-08-14 14:42:49'),(59,68,'7ozyx','2022-08-14 17:36:45','2022-08-14 17:36:45'),(60,69,'gzcir','2022-08-14 22:03:46','2022-08-14 22:03:46'),(61,70,'0ha5h','2022-08-14 23:53:18','2022-08-14 23:53:18'),(62,71,'yn2hp','2022-08-15 07:07:49','2022-08-15 07:07:49'),(63,72,'tk8fp','2022-08-16 20:57:46','2022-08-16 20:57:46'),(64,73,'28cso','2022-08-18 16:41:09','2022-08-18 16:41:09'),(65,74,'5urkw','2022-08-19 17:50:18','2022-08-19 17:50:18'),(66,75,'as4qx','2022-08-21 23:26:13','2022-08-21 23:26:13'),(67,76,'f6mja','2022-08-22 04:18:16','2022-08-22 04:18:16'),(68,77,'53vww','2022-08-22 21:07:18','2022-08-22 21:07:18'),(69,78,'7pnth','2022-08-27 01:43:21','2022-08-27 01:43:21'),(70,79,'v6vrb','2022-08-27 16:16:04','2022-08-27 16:16:04'),(71,80,'4e78t','2022-08-27 21:03:48','2022-08-27 21:03:48'),(72,81,'zqzjn','2022-08-27 21:06:34','2022-08-27 21:06:34'),(73,82,'sf8zx','2022-08-27 21:07:15','2022-08-27 21:07:15'),(74,83,'wf2pd','2022-08-27 21:07:21','2022-08-27 21:07:21'),(75,84,'yqjdo','2022-08-27 21:07:59','2022-08-27 21:07:59'),(76,85,'g8por','2022-08-27 21:10:18','2022-08-27 21:10:18'),(77,86,'3qy4i','2022-08-29 21:44:59','2022-08-29 21:44:59'),(78,87,'cjx6u','2022-09-04 06:34:34','2022-09-04 06:34:34'),(79,88,'5t66m','2022-09-04 14:52:14','2022-09-04 14:52:14'),(80,89,'50a62','2022-09-04 23:40:29','2022-09-04 23:40:29'),(81,90,'qk8t5','2022-09-09 00:56:11','2022-09-09 00:56:11'),(82,91,'66rht','2022-09-09 04:02:10','2022-09-09 04:02:10'),(83,92,'mcewm','2022-09-12 23:00:17','2022-09-12 23:00:17'),(84,93,'3ynet','2022-09-13 17:06:04','2022-09-13 17:06:04'),(85,94,'rc6ys','2022-09-16 15:01:59','2022-09-16 15:01:59'),(86,95,'uciab','2022-09-21 08:18:48','2022-09-21 08:18:48'),(87,96,'34sdm','2022-09-24 21:50:12','2022-09-24 21:50:12'),(88,97,'gphky','2022-09-28 17:18:49','2022-09-28 17:18:49'),(89,98,'id6b4','2022-10-02 04:48:00','2022-10-02 04:48:00'),(90,99,'kqcvz','2022-10-07 15:44:37','2022-10-07 15:44:37'),(91,100,'u7n36','2022-10-08 02:40:29','2022-10-08 02:40:29'),(92,101,'873vf','2022-10-08 04:59:43','2022-10-08 04:59:43'),(93,102,'0kry4','2022-10-11 22:33:00','2022-10-11 22:33:00'),(94,103,'irk72','2022-10-14 08:57:31','2022-10-14 08:57:31'),(95,104,'3mdnz','2022-10-15 19:14:52','2022-10-15 19:14:52'),(96,105,'r0j7f','2022-10-19 17:54:26','2022-10-19 17:54:26'),(97,106,'j2shi','2022-10-22 10:19:13','2022-10-22 10:19:13'),(98,107,'34qev','2022-10-27 16:53:24','2022-10-27 16:53:24'),(99,108,'q7viq','2022-10-31 04:00:55','2022-10-31 04:00:55'),(100,109,'nnfyy','2022-11-03 07:45:34','2022-11-03 07:45:34'),(101,110,'5putz','2022-11-08 12:14:41','2022-11-08 12:14:41'),(102,111,'qfxhq','2022-11-10 05:33:41','2022-11-10 05:33:41'),(103,112,'ozqm3','2022-11-10 23:28:15','2022-11-10 23:28:15'),(104,113,'5tg22','2022-11-11 06:41:23','2022-11-11 06:41:23'),(105,114,'uvmc4','2022-11-12 12:03:56','2022-11-12 12:03:56'),(106,115,'e07i4','2022-11-15 21:50:08','2022-11-15 21:50:08'),(107,116,'3p0tg','2022-11-26 01:23:05','2022-11-26 01:23:05'),(108,117,'kppua','2022-12-01 09:40:37','2022-12-01 09:40:37'),(109,118,'4x0ix','2022-12-03 18:43:27','2022-12-03 18:43:27'),(110,119,'gu8he','2022-12-05 11:12:37','2022-12-05 11:12:37'),(111,120,'4ixw6','2022-12-08 18:12:45','2022-12-08 18:12:45'),(112,121,'g25wq','2022-12-11 03:41:32','2022-12-11 03:41:32'),(113,122,'rvakk','2022-12-16 03:26:42','2022-12-16 03:26:42'),(114,123,'gpscf','2022-12-18 11:21:56','2022-12-18 11:21:56'),(115,124,'gz47s','2022-12-19 22:34:17','2022-12-19 22:34:17'),(116,125,'i3bx5','2022-12-22 05:52:17','2022-12-22 05:52:17'),(117,126,'gvisj','2023-01-10 14:01:30','2023-01-10 14:01:30'),(118,127,'0ma04','2023-01-12 04:36:15','2023-01-12 04:36:15'),(119,128,'qb6mg','2023-01-17 19:39:52','2023-01-17 19:39:52'),(120,129,'zf46d','2023-01-21 04:17:20','2023-01-21 04:17:20'),(121,130,'xikq0','2023-01-22 05:16:11','2023-01-22 05:16:11'),(122,131,'yvy0y','2023-02-07 18:22:27','2023-02-07 18:22:27'),(123,132,'vufhu','2023-02-13 11:17:07','2023-02-13 11:17:07'),(124,133,'ch55c','2023-02-13 16:40:14','2023-02-13 16:40:14'),(125,134,'uhq20','2023-02-16 02:47:01','2023-02-16 02:47:01'),(126,135,'e7y3m','2023-02-21 09:14:56','2023-02-21 09:14:56'),(127,136,'ddyft','2023-02-22 04:33:20','2023-02-22 04:33:20'),(128,137,'tnny2','2023-02-22 15:40:55','2023-02-22 15:40:55'),(129,138,'0tjnr','2023-02-22 15:43:44','2023-02-22 15:43:44'),(130,139,'ufmyv','2023-03-01 20:29:24','2023-03-01 20:29:24'),(131,140,'fhrpd','2023-03-03 18:54:22','2023-03-03 18:54:22'),(132,141,'4kvd6','2023-03-14 06:14:40','2023-03-14 06:14:40'),(133,142,'b6qwp','2023-03-22 00:25:09','2023-03-22 00:25:09'),(134,143,'fthvr','2023-04-02 02:37:30','2023-04-02 02:37:30'),(135,144,'4odcx','2023-04-05 13:51:35','2023-04-05 13:51:35'),(136,145,'cixn8','2023-04-06 14:05:23','2023-04-06 14:05:23'),(137,146,'dzeb8','2023-04-12 11:46:26','2023-04-12 11:46:26'),(138,147,'h8qj5','2023-04-17 10:18:25','2023-04-17 10:18:25'),(139,148,'izwjv','2023-04-26 04:40:57','2023-04-26 04:40:57'),(140,149,'bg7ci','2023-04-29 20:01:57','2023-04-29 20:01:57'),(141,150,'w8kp5','2023-05-19 19:55:16','2023-05-19 19:55:16'),(142,151,'7heq7','2023-05-31 09:10:08','2023-05-31 09:10:08'),(143,152,'efec0','2023-06-04 15:54:44','2023-06-04 15:54:44');
/*!40000 ALTER TABLE `phone_codes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `publications`
--

DROP TABLE IF EXISTS `publications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `publications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'website/assets/media/photos/photo21@2x.jpg',
  `by` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pdf` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `read_time` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `fixed` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `publications`
--

LOCK TABLES `publications` WRITE;
/*!40000 ALTER TABLE `publications` DISABLE KEYS */;
INSERT INTO `publications` (`id`, `image`, `by`, `pdf`, `read_time`, `title`, `sub_title`, `body`, `created_at`, `updated_at`, `fixed`) VALUES (12,'img/publications/images/16594556543173.png','Admin','img/publications/pdfs/16593886234142.pdf',NULL,'ضوابط منح المكافأة المالية مقابل الخدمات الممتازة للعاملين في المدارس','مكافأة الأعمال الممتازة','<p style=\"text-align: center;\">يمكنكم الاطلاع على النشرة الموجودة أدناه</p>','2022-08-01 19:17:03','2022-08-31 09:01:34',0),(18,'img/publications/images/16615584025615.png','Admin','img/publications/pdfs/16606055994616.pdf',NULL,'الضوابط الواجب اتباعها لتحديد مراكز العمل','تحديد مراكز عمل المعلمين الجدد','<p>يمكنكم الاطلاع على النشرة المرفقة أدناه</p>','2022-08-15 21:19:59','2022-09-09 03:32:17',0),(19,'img/publications/images/16615587112428.png','Admin',NULL,NULL,'تعديل ضوابط منح المكافأة المالية للعاملين في المدارس','مكافأة الأعمال الممتازة','<p style=\"text-align: center;\">يمكنكم الاطلاع على النشرة المرفقة</p>','2022-08-27 07:05:11','2022-08-31 09:02:35',1),(20,'img/publications/images/16615593601869.png','Admin','img/publications/pdfs/16626683665166.pdf',NULL,'العودة الشاملة إلى المدارس','توقيت الحصص في اليوم الدراسي','<p style=\"text-align: center;\">يمكنكم الاطلاع على النشرة المرفقة</p>','2022-08-27 07:16:00','2022-09-09 03:23:18',1),(21,'img/publications/images/16626682089766.png','Admin','img/publications/pdfs/16626682088222.pdf',NULL,'الترشيح للتكريم في ليوم العالمي للمعلم و المدارس المتميزة','ترشيح المعلم و المدارس المتميزة','<p style=\"text-align: center;\">يرجى الاطلاع على النشرة المرفقة</p>','2022-09-09 03:16:48','2022-09-09 03:17:52',0),(22,'img/publications/images/16626686799019.png',NULL,'img/publications/pdfs/16626686799512.pdf',NULL,'قواعد منح الإجازة المرضية','المجلس الطبي','<p style=\"text-align: center;\">يرجى الاطلاع على الملف المرفق</p>','2022-09-09 03:24:39','2022-09-09 03:24:39',0),(23,'img/publications/images/16626692453213.png','Admin','img/publications/pdfs/16626692455480.pdf',NULL,'التقويم الدراسي للعام 2022/2023','التقويم الدراسي','<p style=\"text-align: center;\">يرجى الاطلاع على النشرة المرفقة</p>','2022-09-09 03:34:05','2022-09-09 03:34:05',1),(24,'img/publications/images/16639290331069.png','Admin','img/publications/pdfs/16639290339337.pdf',NULL,'عدم تكليف المعلمين و أولياء الأمور بما ليس مفروض عليهم',NULL,'<p>يرجى الاطلاع على النشرة المرفقة</p>','2022-09-23 17:30:33','2022-09-23 17:30:33',1),(25,'img/publications/images/16639292733760.png','Admin','img/publications/pdfs/16639292733048.pdf',NULL,'جائزة اليونيسكو و المؤتمر العلمي الأول لكلية الكويت للتقنية',NULL,'<p>يرجى الاطلاع على النشرة المرفقة</p>','2022-09-23 17:34:33','2022-09-23 17:34:33',1);
/*!40000 ALTER TABLE `publications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `questions`
--

DROP TABLE IF EXISTS `questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `questions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `student_id` bigint unsigned NOT NULL,
  `teacher_id` bigint unsigned DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `sender_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receiver_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `question` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `subject_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `questions_student_id_foreign` (`student_id`),
  KEY `questions_teacher_id_foreign` (`teacher_id`),
  KEY `questions_subject_id_foreign` (`subject_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `questions`
--

LOCK TABLES `questions` WRITE;
/*!40000 ALTER TABLE `questions` DISABLE KEYS */;
INSERT INTO `questions` (`id`, `student_id`, `teacher_id`, `status`, `sender_image`, `receiver_image`, `question`, `answer`, `subject_id`, `created_at`, `updated_at`) VALUES (1,173,NULL,0,NULL,NULL,'asdsad',NULL,NULL,NULL,NULL),(2,173,1,0,NULL,NULL,'ما هو العدد الذرى',NULL,NULL,'2024-01-08 20:01:54','2024-01-08 20:01:54'),(3,173,1,1,NULL,NULL,'ما هو العدد الذرى','50',NULL,'2024-01-08 20:02:19','2024-01-08 20:08:24'),(4,212,209,1,NULL,NULL,'ما هو العدد الذرى','عالم التطور',NULL,'2024-01-31 10:46:12','2024-01-31 21:51:59'),(5,212,209,1,'img/questions/17066984002192.jpg','img/questions/17067069616264.jpg','ما هو العدد الذرى يجمع علي ٣','ممتاز asd',NULL,'2024-01-31 10:53:20','2024-01-31 13:16:01'),(6,212,209,1,'img/questions/17066987921165.jpg','img/questions/17067069398603.jpg','كم عدد الايام','ممتاز asd',NULL,'2024-01-31 10:59:52','2024-01-31 13:15:39'),(7,212,209,1,'img/questions/17066988058747.jpg','img/questions/17067069207305.jpg','عدد ايام شهر ٢','ممتاز',NULL,'2024-01-31 11:00:05','2024-01-31 13:15:20'),(8,212,209,1,'img/questions/17066988479351.jpg','img/questions/17067069059644.jpg','فن جديد','ممتاز',NULL,'2024-01-31 11:00:47','2024-01-31 13:15:05'),(9,212,209,1,'img/questions/17066988569080.jpg','img/questions/17066991165048.jpg','عالم جديد','عالم التطور',NULL,'2024-01-31 11:00:56','2024-01-31 11:05:16');
/*!40000 ALTER TABLE `questions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `ratings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ratings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `student_id` bigint unsigned NOT NULL,
  `teacher_id` bigint unsigned DEFAULT NULL,
  `comment_id` bigint unsigned DEFAULT NULL,
  `rating` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ratings_student_id_foreign` (`student_id`),
  KEY `ratings_teacher_id_foreign` (`teacher_id`),
  KEY `ratings_comment_id_foreign` (`comment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ratings`
--

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

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

DROP TABLE IF EXISTS `role_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

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

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

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (1,'super_admin','web','2022-06-13 04:51:12','2022-06-13 04:51:12'),(2,'student','web',NULL,NULL),(3,'admin','web','2023-12-28 17:33:54','2023-12-28 17:33:54'),(4,'teacher','web','2023-12-28 17:33:54','2023-12-28 17:33:54');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `section_translations`
--

DROP TABLE IF EXISTS `section_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `section_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `section_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `section_translations_section_id_locale_unique` (`section_id`,`locale`),
  KEY `section_translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `section_translations`
--

LOCK TABLES `section_translations` WRITE;
/*!40000 ALTER TABLE `section_translations` DISABLE KEYS */;
INSERT INTO `section_translations` (`id`, `section_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (31,31,'en','مراجعات','2024-01-31 15:30:00','2024-01-31 15:30:00'),(32,31,'ar','مراجعات','2024-01-31 15:30:00','2024-01-31 15:30:00');
/*!40000 ALTER TABLE `section_translations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `stage_class_id` bigint unsigned NOT NULL,
  `stage_id` bigint unsigned DEFAULT NULL,
  `subject_id` bigint unsigned NOT NULL,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'website/assets/media/photos/keepLearning.jpg',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sections_stage_class_id_foreign` (`stage_class_id`),
  KEY `sections_stage_id_foreign` (`stage_id`),
  KEY `sections_subject_id_foreign` (`subject_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `sections` WRITE;
/*!40000 ALTER TABLE `sections` DISABLE KEYS */;
INSERT INTO `sections` (`id`, `stage_class_id`, `stage_id`, `subject_id`, `image`, `created_at`, `updated_at`) VALUES (31,20,6,156,'website/assets/media/photos/keepLearning.jpg','2024-01-31 15:30:00','2024-01-31 15:30:00');
/*!40000 ALTER TABLE `sections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `setting_translations`
--

DROP TABLE IF EXISTS `setting_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `setting_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `setting_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `setting_translations_setting_id_locale_unique` (`setting_id`,`locale`),
  KEY `setting_translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `setting_translations`
--

LOCK TABLES `setting_translations` WRITE;
/*!40000 ALTER TABLE `setting_translations` DISABLE KEYS */;
INSERT INTO `setting_translations` (`id`, `setting_id`, `locale`, `value`, `created_at`, `updated_at`) VALUES (1,1,'en','منصة سند التعليمية','2022-06-13 04:51:12','2024-01-19 17:40:00'),(2,1,'ar','منصة سند التعليمية','2022-06-13 04:51:12','2024-01-19 17:40:00'),(3,2,'en','<h1><strong>Terms and Conditions:</strong></h1>\r\n<p><strong>By agreeing th the terms and conditions you agree to the following:</strong></p>\r\n<p><strong>1- when uploading study files to the (5ibra) website, I agree to share them with the rest of the registrants on the site , and I accept that the files are downloaded, redistributed and shared by other users.</strong></p>\r\n<p><strong>2- when uploading study files to this website, I confirm that they are my creative property and were not taken from other published teachers and claimed to be my own.</strong></p>\r\n<p><strong>3- when downloading teachers\' files, I acknoledge using them for personal and not for public purposes or to publish them on other sites under my own name.</strong></p>\r\n<p><strong>As the 5ibra site administrators are not liable for any files or personal information published by registred users.</strong></p>','2022-06-13 04:51:12','2022-07-29 16:39:40'),(4,2,'ar','<h1><strong>الشروط و الأحكام</strong></h1>\r\n<p style=\"text-align: right;\">&nbsp;عند الموافقة على الشروط و الأحكام فإنكم بذلك وافقتم على مايلي:</p>\r\n<p style=\"text-align: right;\">1- عند تحميل الملفات على الموقع (خبرة ) فأنا أوافق على مشاركتها مع بقية المُسجلين في الموقع (خبرة)و يمكنهم استخدامها مع حفظ حقوق المٌلكية.</p>\r\n<p style=\"text-align: right;\">2- عند تحميل الملفات في صفحتي الشخصية فأنا أقر بأنها خاصة بي و لم يتم أخذها من معلمين آخرين&nbsp; &nbsp;</p>\r\n<p style=\"text-align: right;\">3- عند تنزيل ملفات المعلمين فأني أقر باستخدامها لأغراض شخصية و ليست عامة أو لنشرها في مواقع أخرى باسمي الشخصي&nbsp;</p>\r\n<p style=\"text-align: right;\">&nbsp; حيث أن&nbsp; إدارة الموقع (خبرة) تُخلي مسؤوليتها تجاه أي ملفات أو بيانات شخصية يتم نشرها من قبل المُسجلين في الموقع&nbsp;</p>\r\n<p>&nbsp;</p>','2022-06-13 04:51:12','2022-08-02 14:51:43'),(5,3,'en','Kuwait City','2022-06-13 07:26:06','2022-07-29 15:10:16'),(6,3,'ar','دولة الكويت','2022-06-13 07:26:06','2022-07-29 15:10:16'),(7,4,'en','(+966) 12122266','2022-06-13 07:26:06','2024-01-19 17:40:00'),(8,4,'ar','(+966) 12122266','2022-06-13 07:26:06','2024-01-19 17:40:00'),(9,5,'en','Almodares@gmail.com','2022-06-13 07:26:06','2024-01-19 17:40:00'),(10,5,'ar','Almodares@gmail.com','2022-06-13 07:26:06','2024-01-19 17:40:00'),(11,6,'en','+9660555454','2022-06-13 07:26:06','2024-01-19 17:40:00'),(12,6,'ar','+9660555454','2022-06-13 07:26:06','2024-01-19 17:40:00'),(13,7,'en','www.facebook.com','2022-06-13 07:26:06','2024-01-19 17:40:00'),(14,7,'ar','www.facebook.com','2022-06-13 07:26:06','2024-01-19 17:40:00'),(15,8,'en','www.google.com','2022-06-13 07:26:06','2024-01-19 17:40:00'),(16,8,'ar','www.google.com','2022-06-13 07:26:06','2024-01-19 17:40:00'),(17,9,'en','What is Almodares Website?\n\nAlmodares is an Educational site that aims to transfer teachers\' experiences from lesson plan, paperwork and Presentations to ensure that they introduce and publish their work by highlighting and documenting their works by uploading the educational material by specialist teachers in his stage and class, in addition to publishing prominent Ministry of Education newsletters.\n\n    Also, through Almodares site, it is possible to display presentations that can be presented as workshops or technical meetings. \n\nThe Almodares website was created by Mrs. Fatma Hussain Matar Al-shammari, and the goal was to publish her presntaions for teachers to tranfer interest, while taking care to preserve the intellectual and property rights of these files for her and every one want to help athers with the same idea. ','2022-06-13 07:50:10','2024-01-19 17:40:00'),(18,9,'ar','ماهو موقع المُدرس؟\n\nالمٌدرس هو موقع تعليمي يهدف إلى نقل خبرات المعلمين من الإعداد الكتابي و أوراق العمل و العروض التقديمية  بحيث يضمن لهم التعريف بأعمالهم و نشرها من خلال إبراز أنشطتهم و توثيقها من خلال تحميل معلم الاختصاص لملفات المادة التعليمية في المرحلة و الصف الخاص به ، بالإضافة إلى نشر أبرز النشرات الإخبارية الخاصة بوزارة التربية . كذلك يمكن من خلال موقع خبرة عرض أبرز العروض التقديمية التي يمكن تقديمها كورش عمل أو اجتماعات فنية \n\nتم إنشاء موقع خبرة من خلال أ.فاطمة حسين مطر الشمري و كان الهدف منه هو نشر العروض التقديمية الخاصة بها للمعلمين لنقل الفائدة مع الحرص على حفظ الحقوق الفكرية و الملكية لهذه الملفات . ','2022-06-13 07:50:10','2024-01-19 17:40:00'),(19,10,'en','Welcome to the future of learning','2022-06-13 07:50:10','2024-01-19 17:40:00'),(20,10,'ar','مرحبا بكم فى موقع المٌدرس التعليمي','2022-06-13 07:50:10','2024-01-19 17:40:00'),(21,11,'en','انشر ملفاتك و وثق عملك','2022-06-13 07:50:10','2024-01-19 17:40:00'),(22,11,'ar','Publish your files and document your work','2022-06-13 07:50:10','2024-01-19 17:40:00'),(23,12,'en','website/assets/media/photos/carouselImage1.jpg','2022-06-13 07:50:10','2024-01-19 17:40:00'),(24,12,'ar','website/assets/media/photos/carouselImage1.jpg','2022-06-13 07:50:10','2024-01-19 17:40:00'),(25,13,'en','website/assets/media/photos/carouselImage1.jpg','2022-09-27 02:06:17','2024-01-19 17:40:00'),(26,13,'ar','website/assets/media/photos/carouselImage1.jpg','2022-09-27 02:06:17','2024-01-19 17:40:00'),(27,14,'en','https://Almodares.com','2022-09-27 02:12:39','2024-01-19 17:40:00'),(28,14,'ar','https://Almodares.com','2022-09-27 02:12:39','2024-01-19 17:40:00'),(31,16,'en','10','2023-12-22 14:59:04','2024-01-06 16:14:30'),(32,16,'ar','10','2023-12-22 14:59:04','2024-01-06 16:14:30'),(33,17,'en','10','2023-12-22 14:59:04','2024-01-08 17:17:06'),(34,17,'ar','10','2023-12-22 14:59:04','2024-01-08 17:17:06'),(35,18,'en','10','2023-12-22 14:59:04','2024-01-08 17:18:48'),(36,18,'ar','10','2023-12-22 14:59:04','2023-12-22 15:01:25'),(37,19,'en','10','2023-12-22 14:59:04','2024-01-19 17:40:00'),(38,19,'ar','10','2023-12-22 14:59:04','2024-01-19 17:40:00'),(39,20,'en','img/logo.jpeg','2024-01-19 17:40:00','2024-01-19 17:40:00'),(40,20,'ar','img/logo.jpeg','2024-01-19 17:40:00','2024-01-19 17:40:00'),(41,21,'en','<p>Terms and Conditions: By agreeing th the terms and conditions you agree to the following: 1- when uploading study files to the (Almodares) website, I agree to share them with the rest of the registrants on the site , and I accept that the files are downloaded, redistributed and shared by other users. 2- when uploading study files to this website, I confirm that they are my creative property and were not taken from other published teachers and claimed to be my own. 3- when downloading teachers\' files, I acknoledge using them for personal and not for public purposes or to publish them on other sites under my own name. As the Almodares site administrators are not liable for any files or personal information published by registred users.</p>','2024-01-19 17:40:00','2024-01-27 11:42:11'),(42,21,'ar','<p>الشروط و الأحكام &nbsp;عند الموافقة على الشروط و الأحكام فإنكم بذلك وافقتم على مايلي: 1- عند تحميل الملفات على الموقع (المُدرس) فأنا أوافق على مشاركتها مع بقية المُسجلين في الموقع (المُدرس)و يمكنهم استخدامها مع حفظ حقوق المٌلكية. 2- عند تحميل الملفات في صفحتي الشخصية فأنا أقر بأنها خاصة بي و لم يتم أخذها من معلمين آخرين&nbsp; &nbsp; 3- عند تنزيل ملفات المعلمين فأني أقر باستخدامها لأغراض شخصية و ليست عامة أو لنشرها في مواقع أخرى باسمي الشخصي&nbsp; &nbsp; حيث أن&nbsp; إدارة الموقع (المُدرس) تُخلي مسؤوليتها تجاه أي ملفات أو بيانات شخصية يتم نشرها من قبل المُسجلين في الموقع&nbsp;</p>','2024-01-19 17:40:00','2024-01-27 11:42:11'),(43,22,'en','Terms and Conditions:\n                            By agreeing th the terms and conditions you agree to the following:\n                             1- when uploading study files to the (Almodares) website, I agree to share them with the rest of the registrants on the site , and I accept that the files are downloaded, redistributed and shared by other users.\n                             2- when uploading study files to this website, I confirm that they are my creative property and were not taken from other published teachers and claimed to be my own.\n                             3- when downloading teachers\' files, I acknoledge using them for personal and not for public purposes or to publish them on other sites under my own name.\n                             As the Almodares site administrators are not liable for any files or personal information published by registred users.','2024-01-19 17:40:00','2024-01-19 17:40:00'),(44,22,'ar','الشروط و الأحكام\n                             عند الموافقة على الشروط و الأحكام فإنكم بذلك وافقتم على مايلي:\n                            1- عند تحميل الملفات على الموقع (المُدرس) فأنا أوافق على مشاركتها مع بقية المُسجلين في الموقع (المُدرس)و يمكنهم استخدامها مع حفظ حقوق المٌلكية.\n                            2- عند تحميل الملفات في صفحتي الشخصية فأنا أقر بأنها خاصة بي و لم يتم أخذها من معلمين آخرين   \n                            3- عند تنزيل ملفات المعلمين فأني أقر باستخدامها لأغراض شخصية و ليست عامة أو لنشرها في مواقع أخرى باسمي الشخصي \n                              حيث أن  إدارة الموقع (المُدرس) تُخلي مسؤوليتها تجاه أي ملفات أو بيانات شخصية يتم نشرها من قبل المُسجلين في الموقع \n','2024-01-19 17:40:00','2024-01-19 17:40:00'),(45,23,'en','10','2024-01-19 17:40:00','2024-01-19 17:40:00'),(46,23,'ar','10','2024-01-19 17:40:00','2024-01-27 11:43:20');
/*!40000 ALTER TABLE `setting_translations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `display_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `key` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `subjects_image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profile_image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` (`id`, `display_name`, `key`, `type`, `created_at`, `updated_at`, `subjects_image`, `profile_image`) VALUES (1,'website title','website_title','text','2022-06-13 04:51:12','2022-07-29 16:21:58','2022-07-29-Presentation1-removebg-preview.png','2022-07-29-Presentation1-removebg-preview.png'),(2,'Terms and conditions','terms','textarea','2022-06-13 04:51:12','2022-06-13 04:51:12',NULL,NULL),(3,'website address','website_address','text','2022-06-13 07:26:06','2022-06-13 07:26:06',NULL,NULL),(4,'website phone','website_phone','text','2022-06-13 07:26:06','2022-06-13 07:26:06',NULL,NULL),(5,'website email','website_email','email','2022-06-13 07:26:06','2022-06-13 07:26:06',NULL,NULL),(6,'website whatsapp','website_whatsapp','text','2022-06-13 07:26:06','2022-06-13 07:26:06',NULL,NULL),(7,'website facebook','website_facebook','text','2022-06-13 07:26:06','2024-01-19 17:40:00',NULL,NULL),(8,'website google','website_google','text','2022-06-13 07:26:06','2022-06-13 07:26:06',NULL,NULL),(9,'About us','about_us','textarea','2022-06-13 07:50:10','2022-06-13 07:50:10',NULL,NULL),(10,'Home page header','home_header','text','2022-06-13 07:50:10','2022-06-13 07:50:10',NULL,NULL),(11,'Home page sub header','home_sub_header','text','2022-06-13 07:50:10','2022-06-13 07:50:10',NULL,NULL),(12,'Home page sub photo','home_photo','file','2022-06-13 07:50:10','2022-06-13 07:50:10',NULL,NULL),(13,'home page banner down','home_banner_down','file','2022-09-27 02:06:17','2022-09-27 02:06:17',NULL,NULL),(14,'home page banner down link','home_banner_down_link','url','2022-09-27 02:12:39','2022-09-27 02:12:39',NULL,NULL),(16,'Instructor subscription fees','instructor_subscription_fees','string','2023-12-22 14:59:04','2023-12-22 14:59:04',NULL,NULL),(17,'Number of points for each question','number_of_points_for_each_question','string','2023-12-22 14:59:04','2023-12-22 14:59:04',NULL,NULL),(18,'1 Dinar = how many points','dinar_to_points','string','2023-12-22 14:59:04','2023-12-22 14:59:04',NULL,NULL),(19,'Max number of students in the online lecture','max_number_of_students','string','2023-12-22 14:59:04','2023-12-22 14:59:04',NULL,NULL),(20,'website logo','website_logo','file','2024-01-19 17:40:00','2024-01-19 17:40:00',NULL,NULL),(21,'Terms and conditions for teacher','terms_teacher','textarea','2024-01-19 17:40:00','2024-01-19 17:40:00',NULL,NULL),(22,'Terms and conditions for student','terms_student','textarea','2024-01-19 17:40:00','2024-01-19 17:40:00',NULL,NULL),(23,'lecture price','lecture_price','number','2024-01-19 17:40:00','2024-01-19 17:40:00',NULL,NULL);
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `slider_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `slider_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slider_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slider_translations_slider_id_locale_unique` (`slider_id`,`locale`),
  KEY `slider_translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `slider_translations`
--

LOCK TABLES `slider_translations` WRITE;
/*!40000 ALTER TABLE `slider_translations` DISABLE KEYS */;
INSERT INTO `slider_translations` (`id`, `slider_id`, `locale`, `title`, `sub_title`, `created_at`, `updated_at`) VALUES (25,15,'en',NULL,NULL,'2022-07-24 22:46:09','2022-07-24 22:46:09'),(26,15,'ar',NULL,NULL,'2022-07-24 22:46:09','2022-07-24 22:46:09'),(27,16,'en',NULL,NULL,'2022-07-24 22:48:00','2022-07-24 22:48:00'),(28,16,'ar',NULL,NULL,'2022-07-24 22:48:00','2022-07-24 22:48:00'),(33,19,'en',NULL,NULL,'2022-07-24 22:54:59','2022-07-24 22:54:59'),(34,19,'ar',NULL,NULL,'2022-07-24 22:54:59','2022-07-24 22:54:59'),(37,21,'en',NULL,NULL,'2022-07-29 14:41:14','2022-07-29 14:41:14'),(38,21,'ar',NULL,NULL,'2022-07-29 14:41:14','2022-07-29 14:41:14'),(43,24,'en','Almu2alif for books',NULL,'2022-08-02 15:27:06','2022-08-02 15:27:06'),(44,24,'ar','دار المؤلف للنشر و التوزيع',NULL,'2022-08-02 15:27:06','2022-08-02 15:27:06'),(45,25,'en',NULL,NULL,'2022-08-02 15:31:00','2022-08-02 15:31:00'),(46,25,'ar',NULL,NULL,'2022-08-02 15:31:00','2022-08-02 15:31:00');
/*!40000 ALTER TABLE `slider_translations` 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` varchar(125) CHARACTER SET utf8mb4 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=26 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 */;
INSERT INTO `sliders` (`id`, `image`, `created_at`, `updated_at`) VALUES (15,'img/sliders/16587099693605.png','2022-07-24 22:46:09','2022-07-24 22:46:09'),(16,'img/sliders/16587100805183.png','2022-07-24 22:48:00','2022-07-24 22:48:00'),(19,'img/sliders/16587104995384.png','2022-07-24 22:54:59','2022-07-24 22:54:59'),(21,'img/sliders/16591128745985.png','2022-07-29 14:41:14','2022-07-29 14:41:14'),(24,'img/sliders/16594612261622.png','2022-08-02 15:27:06','2022-08-02 15:27:06'),(25,'img/sliders/16594614606042.png','2022-08-02 15:31:00','2022-08-02 15:31:00');
/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stage_class_translations`
--

DROP TABLE IF EXISTS `stage_class_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stage_class_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `stage_class_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `stage_class_translations_stage_class_id_locale_unique` (`stage_class_id`,`locale`),
  KEY `stage_class_translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stage_class_translations`
--

LOCK TABLES `stage_class_translations` WRITE;
/*!40000 ALTER TABLE `stage_class_translations` DISABLE KEYS */;
INSERT INTO `stage_class_translations` (`id`, `stage_class_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (37,20,'en','fifth grade','2024-01-29 14:28:52','2024-01-29 14:28:52'),(38,20,'ar','الصف الخامس','2024-01-29 14:28:52','2024-01-29 14:28:52'),(39,21,'en','Sixth grade','2024-01-29 14:29:21','2024-01-29 14:29:21'),(40,21,'ar','الصف السادس','2024-01-29 14:29:21','2024-01-29 14:29:21'),(43,23,'en','Seventh grade','2024-01-29 14:30:43','2024-01-29 14:30:43'),(44,23,'ar','الصف السابع','2024-01-29 14:30:43','2024-01-29 14:30:43'),(45,24,'en','Eighth grade','2024-01-29 14:31:25','2024-01-29 14:31:25'),(46,24,'ar','الصف الثامن','2024-01-29 14:31:25','2024-01-29 14:31:25'),(47,25,'en','Ninth grade','2024-01-29 14:31:47','2024-01-29 14:31:47'),(48,25,'ar','الصف التاسع','2024-01-29 14:31:47','2024-01-29 14:31:47'),(49,26,'en','Tenth grade','2024-01-29 14:32:26','2024-01-29 14:32:26'),(50,26,'ar','الصف العاشر','2024-01-29 14:32:26','2024-01-29 14:32:26'),(51,27,'en','Eleventh grade','2024-01-29 14:33:01','2024-01-29 14:33:01'),(52,27,'ar','الصف الحادي عشر','2024-01-29 14:33:01','2024-01-29 14:33:01'),(53,28,'en','Twelfth grade','2024-01-29 14:33:39','2024-01-29 14:35:45'),(54,28,'ar','الصف الثاني عشر','2024-01-29 14:33:39','2024-01-29 14:33:39');
/*!40000 ALTER TABLE `stage_class_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stage_classes`
--

DROP TABLE IF EXISTS `stage_classes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stage_classes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `stage_id` bigint unsigned NOT NULL,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'website/assets/media/photos/Secondary-Schools.jpg',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `first_semester_fees` double(8,2) DEFAULT NULL,
  `second_semester_fees` double(8,2) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 show / 0 hide',
  PRIMARY KEY (`id`),
  KEY `stage_classes_stage_id_foreign` (`stage_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stage_classes`
--

LOCK TABLES `stage_classes` WRITE;
/*!40000 ALTER TABLE `stage_classes` DISABLE KEYS */;
INSERT INTO `stage_classes` (`id`, `stage_id`, `image`, `created_at`, `updated_at`, `first_semester_fees`, `second_semester_fees`, `status`) VALUES (20,6,'website/assets/media/photos/Secondary-Schools.jpg','2024-01-29 14:28:52','2024-01-29 14:28:52',5.00,10.00,0),(21,6,'website/assets/media/photos/Secondary-Schools.jpg','2024-01-29 14:29:21','2024-01-29 14:29:21',5.00,10.00,0),(23,6,'website/assets/media/photos/Secondary-Schools.jpg','2024-01-29 14:30:43','2024-01-29 14:30:43',5.00,10.00,0),(24,6,'website/assets/media/photos/Secondary-Schools.jpg','2024-01-29 14:31:25','2024-01-29 14:31:25',5.00,10.00,0),(25,6,'website/assets/media/photos/Secondary-Schools.jpg','2024-01-29 14:31:47','2024-01-29 14:31:47',5.00,10.00,0),(26,5,'website/assets/media/photos/Secondary-Schools.jpg','2024-01-29 14:32:26','2024-01-29 14:32:26',20.00,30.00,0),(27,5,'website/assets/media/photos/Secondary-Schools.jpg','2024-01-29 14:33:01','2024-01-29 14:33:01',20.00,30.00,0),(28,5,'website/assets/media/photos/Secondary-Schools.jpg','2024-01-29 14:33:39','2024-01-29 14:36:18',20.00,30.00,0);
/*!40000 ALTER TABLE `stage_classes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stage_translations`
--

DROP TABLE IF EXISTS `stage_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stage_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `stage_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `stage_translations_stage_id_locale_unique` (`stage_id`,`locale`),
  KEY `stage_translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stage_translations`
--

LOCK TABLES `stage_translations` WRITE;
/*!40000 ALTER TABLE `stage_translations` DISABLE KEYS */;
INSERT INTO `stage_translations` (`id`, `stage_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (9,5,'en','high school','2024-01-29 14:22:49','2024-01-29 14:24:12'),(10,5,'ar','الثانوية','2024-01-29 14:22:49','2024-01-29 14:24:12'),(11,6,'en','Average','2024-01-29 14:23:51','2024-01-29 14:23:51'),(12,6,'ar','المتوسط','2024-01-29 14:23:51','2024-01-29 14:23:51');
/*!40000 ALTER TABLE `stage_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stages`
--

DROP TABLE IF EXISTS `stages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'website/assets/media/photos/Secondary-Schools.jpg',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 show / 0 hide',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stages`
--

LOCK TABLES `stages` WRITE;
/*!40000 ALTER TABLE `stages` DISABLE KEYS */;
INSERT INTO `stages` (`id`, `image`, `created_at`, `updated_at`, `status`) VALUES (5,'img/stages/images/17065381693597.png','2024-01-29 14:22:49','2024-01-29 14:22:49',1),(6,'img/stages/images/17065382314611.png','2024-01-29 14:23:51','2024-01-29 14:23:51',1);
/*!40000 ALTER TABLE `stages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subject_data`
--

DROP TABLE IF EXISTS `subject_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `subject_data` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subject_id` bigint unsigned NOT NULL,
  `type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ext` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `fixed` tinyint(1) DEFAULT '0',
  `section_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subject_data_subject_id_foreign` (`subject_id`),
  KEY `subject_data_user_id_foreign` (`user_id`),
  KEY `subject_data_section_id_foreign` (`section_id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subject_data`
--

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

--
-- Table structure for table `subject_data_reactions`
--

DROP TABLE IF EXISTS `subject_data_reactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `subject_data_reactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subject_data_id` bigint unsigned NOT NULL,
  `type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subject_data_reactions_subject_data_id_foreign` (`subject_data_id`)
) ENGINE=InnoDB AUTO_INCREMENT=333 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subject_data_reactions`
--

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

--
-- Table structure for table `subject_translations`
--

DROP TABLE IF EXISTS `subject_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `subject_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subject_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subject_translations_subject_id_locale_unique` (`subject_id`,`locale`),
  KEY `subject_translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=319 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subject_translations`
--

LOCK TABLES `subject_translations` WRITE;
/*!40000 ALTER TABLE `subject_translations` DISABLE KEYS */;
INSERT INTO `subject_translations` (`id`, `subject_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (311,156,'en','Sciences','2024-01-29 14:40:09','2024-01-29 14:40:09'),(312,156,'ar','علوم','2024-01-29 14:40:09','2024-01-29 14:40:09'),(315,158,'en','English','2024-01-29 14:42:43','2024-01-29 14:42:43'),(316,158,'ar','انجليزي','2024-01-29 14:42:43','2024-01-29 14:42:43'),(317,159,'en','رياضايت','2024-02-01 22:09:02','2024-02-01 22:09:02'),(318,159,'ar','رياضايت','2024-02-01 22:09:02','2024-02-01 22:09:02');
/*!40000 ALTER TABLE `subject_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subjects`
--

DROP TABLE IF EXISTS `subjects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `subjects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `stage_class_id` bigint unsigned NOT NULL,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'website/assets/media/photos/keepLearning.jpg',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `order` int DEFAULT NULL,
  `semester` enum('first_semester','second_semester') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stage_id` bigint unsigned DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 show / 0 hide',
  PRIMARY KEY (`id`),
  KEY `subjects_stage_class_id_foreign` (`stage_class_id`),
  KEY `subjects_stage_id_foreign` (`stage_id`)
) ENGINE=InnoDB AUTO_INCREMENT=160 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subjects`
--

LOCK TABLES `subjects` WRITE;
/*!40000 ALTER TABLE `subjects` DISABLE KEYS */;
INSERT INTO `subjects` (`id`, `stage_class_id`, `image`, `created_at`, `updated_at`, `order`, `semester`, `stage_id`, `status`) VALUES (156,20,'img/stages/images/17065392097473.jpg','2024-01-29 14:40:09','2024-01-31 20:58:19',NULL,'first_semester',6,1),(158,27,'img/stages/images/17065393635941.jpg','2024-01-29 14:42:43','2024-01-31 20:59:41',NULL,'first_semester',6,1),(159,27,'website/assets/media/photos/keepLearning.jpg','2024-02-01 22:09:02','2024-02-01 22:09:02',NULL,'first_semester',6,0);
/*!40000 ALTER TABLE `subjects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_classes`
--

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

--
-- Dumping data for table `user_classes`
--

LOCK TABLES `user_classes` WRITE;
/*!40000 ALTER TABLE `user_classes` DISABLE KEYS */;
INSERT INTO `user_classes` (`id`, `stage_class_id`, `user_id`, `created_at`, `updated_at`) VALUES (237,27,212,'2024-01-31 21:13:37','2024-01-31 21:13:37'),(240,27,209,'2024-02-01 22:09:36','2024-02-01 22:09:36');
/*!40000 ALTER TABLE `user_classes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_stages`
--

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

--
-- Dumping data for table `user_stages`
--

LOCK TABLES `user_stages` WRITE;
/*!40000 ALTER TABLE `user_stages` DISABLE KEYS */;
INSERT INTO `user_stages` (`id`, `stage_id`, `user_id`, `created_at`, `updated_at`) VALUES (201,5,212,'2024-01-31 21:13:37','2024-01-31 21:13:37'),(204,5,209,'2024-02-01 22:09:36','2024-02-01 22:09:36');
/*!40000 ALTER TABLE `user_stages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_subjects`
--

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

--
-- Dumping data for table `user_subjects`
--

LOCK TABLES `user_subjects` WRITE;
/*!40000 ALTER TABLE `user_subjects` DISABLE KEYS */;
INSERT INTO `user_subjects` (`id`, `subject_id`, `user_id`, `created_at`, `updated_at`) VALUES (234,156,212,'2024-01-31 21:13:37','2024-01-31 21:13:37'),(235,158,212,'2024-01-31 21:13:37','2024-01-31 21:13:37'),(239,158,209,'2024-02-01 22:09:36','2024-02-01 22:09:36'),(240,159,209,'2024-02-01 22:09:36','2024-02-01 22:09:36');
/*!40000 ALTER TABLE `user_subjects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_subscriptions`
--

DROP TABLE IF EXISTS `user_subscriptions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_subscriptions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `price` double(8,2) NOT NULL,
  `payment_type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `stage_class_id` bigint unsigned DEFAULT NULL,
  `semester` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_subscriptions_user_id_foreign` (`user_id`),
  KEY `user_subscriptions_stage_class_id_foreign` (`stage_class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_subscriptions`
--

LOCK TABLES `user_subscriptions` WRITE;
/*!40000 ALTER TABLE `user_subscriptions` DISABLE KEYS */;
INSERT INTO `user_subscriptions` (`id`, `user_id`, `start_date`, `end_date`, `status`, `price`, `payment_type`, `created_at`, `updated_at`, `stage_class_id`, `semester`) VALUES (3,170,'2024-01-01','2025-01-01',1,200.00,'visa','2024-01-01 19:20:38','2024-01-01 19:20:38',NULL,NULL),(4,170,'2024-01-01','2025-01-01',1,200.00,'visa','2024-01-01 19:30:08','2024-01-01 19:30:08',NULL,NULL),(5,170,'2024-01-05','2025-01-05',1,200.00,'visa','2024-01-05 17:06:46','2024-01-05 17:06:46',NULL,NULL),(7,172,'2024-01-08','2025-01-08',1,200.00,'visa','2024-01-08 18:59:11','2024-01-08 18:59:11',NULL,NULL),(15,209,'2024-01-29','2025-01-29',1,10.00,'visa','2024-01-29 15:04:35','2024-01-29 15:04:35',20,NULL),(16,209,'2024-01-29','2025-01-29',1,10.00,'visa','2024-01-29 15:05:41','2024-01-29 15:05:41',20,NULL),(17,212,'2024-01-30','2025-01-30',1,10.00,'visa','2024-01-30 09:11:19','2024-01-30 09:11:19',20,'first_semester'),(18,209,'2024-01-30','2024-01-31',1,10.00,'l','2024-01-31 20:56:46','2024-01-31 20:56:46',NULL,NULL);
/*!40000 ALTER TABLE `user_subscriptions` 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(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `phone_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'img/avatar.svg',
  `gender` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `more_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `theme` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'dark',
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `schoolName` varchar(122) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'student',
  `device_token` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subscription_status` tinyint(1) NOT NULL DEFAULT '0',
  `age` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exp` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `about` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=213 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 */;
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `phone_verified_at`, `password`, `phone`, `image`, `gender`, `more_details`, `theme`, `remember_token`, `created_at`, `updated_at`, `schoolName`, `status`, `code`, `type`, `device_token`, `subscription_status`, `age`, `nationality`, `exp`, `work_type`, `about`) VALUES (1,'admin','admin@admin.com',NULL,'2023-12-23 17:13:39','$2y$10$/52GP5fXYKACP1SSXEAIbOledKVTzMbI.ihLWZj.aa9m5GZqzaY4m','12345','img/users/images/16551880723058.svg',NULL,NULL,'dark',NULL,'2022-06-13 04:51:12','2024-01-25 08:21:19',NULL,1,NULL,'super_admin','564156456545645646464445666666666666666',0,'15','مصرى','15','خاص','سشيسشي'),(209,'anwer shehata','anwerdddf@gmail.com',NULL,'2024-01-29 14:17:27','$2y$10$TPSdYQuknKp7/CK793tC9.fYImd1a7EJu0e1muopXbX.Ya4CYpaRi','67782374','img/avatar.svg','male',NULL,'dark',NULL,'2024-01-29 14:17:09','2024-01-31 20:16:23',NULL,1,NULL,'teacher','123123',0,'32','erwt','3','خاص','fd'),(210,'ali shehata',NULL,NULL,'2024-01-30 08:09:01',NULL,'67782375','img/avatar.svg','male',NULL,'dark',NULL,'2024-01-30 08:07:53','2024-02-01 16:29:54',NULL,1,NULL,'teacher','564156456545645646464445666666666666666',0,NULL,NULL,NULL,NULL,NULL),(211,'ans anwar',NULL,NULL,'2024-01-30 08:11:15',NULL,'67782376','img/avatar.svg','male',NULL,'dark',NULL,'2024-01-30 08:11:06','2024-01-30 09:25:48',NULL,1,NULL,'student','123123',0,NULL,NULL,NULL,NULL,NULL),(212,'ans anwar','anweradmin@gmail.com',NULL,'2024-01-30 08:25:54','$2y$10$NtT3JpBESOLeg4DzzUR00O9gj0Z8SkojH.rND/xr4kYfh.g.D20am','67782377','img/avatar.svg','male',NULL,'dark',NULL,'2024-01-30 08:25:36','2024-01-31 10:38:01',NULL,1,NULL,'student','123123',0,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `workshop_sales`
--

DROP TABLE IF EXISTS `workshop_sales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `workshop_sales` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `workshop_id` bigint unsigned NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `workshop_sales_workshop_id_foreign` (`workshop_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `workshop_sales`
--

LOCK TABLES `workshop_sales` WRITE;
/*!40000 ALTER TABLE `workshop_sales` DISABLE KEYS */;
INSERT INTO `workshop_sales` (`id`, `workshop_id`, `name`, `phone`, `email`, `created_at`, `updated_at`) VALUES (1,6,'Hello World! https://wcezm4.com?hs=fbc719d93653edc8919a4ab681018ab4&','722368891105','l49v1x@mailto.plus','2023-02-19 20:23:07','2023-02-19 20:23:07'),(2,5,'Hello World! https://apel.top/go/gu4winrshe5dgoju?hs=21c8a438d2aacd6e431d592ee5a5fce0&','341158113702','ayfkuh@tofeat.com','2023-04-02 01:37:27','2023-04-02 01:37:27'),(3,6,'Hello World! https://apel.top/go/gu4winrshe5dgoju?hs=fbc719d93653edc8919a4ab681018ab4&','833494504926','ayfkuh@tofeat.com','2023-04-02 01:37:39','2023-04-02 01:37:39');
/*!40000 ALTER TABLE `workshop_sales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `workshops`
--

DROP TABLE IF EXISTS `workshops`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `workshops` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `skills` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `price` double NOT NULL DEFAULT '0',
  `whatsapp` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `fixed` tinyint(1) NOT NULL DEFAULT '0',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `workshops`
--

LOCK TABLES `workshops` WRITE;
/*!40000 ALTER TABLE `workshops` DISABLE KEYS */;
INSERT INTO `workshops` (`id`, `title`, `sub_title`, `image`, `skills`, `price`, `whatsapp`, `created_at`, `updated_at`, `fixed`, `description`) VALUES (5,'استفسر عن عرض ورشة العمل','عروض تقديمية','img/workshops/images/16597417054282.png','a:1:{i:0;s:93:\"يرجى كتابة أهم المحاور التي يحتويها العرض التقديمي\";}',0,'55653005','2022-06-13 07:59:41','2022-08-05 21:21:45',1,'إن كان لديكم ورشة عمل جاهزة و تريدون عرضها للمعلمين و الاستفادة منها يرجى التواصل على الوتساب'),(6,'الأهداف السلوكية','اجتماع فني','img/workshops/images/16597417234756.png','a:1:{i:0;s:82:\"معرفة كيفية كتابة الأهداف السلوكية و أنواعها\";}',2,'55653005','2022-08-02 15:43:46','2022-08-05 21:22:03',1,'يحتوي العرض التقديمي على 13 شريحة تتضمن (المفهوم - الأهمية - كيفية صياغة الأهداف السلوكية - مكونات الأهداف السلوكية - أقسام الأهداف السلوكية)'),(8,'ضغوطات العمل','ورشة عمل / اجتماع فني','img/workshops/images/16604003443981.png','a:3:{i:0;s:63:\"التعرف على ضغوطات العمل و مسبباتها\";i:1;s:47:\"كيفية التعامل مع الضغوطات\";i:2;s:40:\"تمارين معرفة الضغوطات\";}',10,'55653005','2022-08-13 12:19:04','2022-08-13 12:19:17',0,'يحتوي العرض التقديمي على 24 شريحة تتضمن (المفهوم - العناصر المسببة لضغوط العمل - أسباب ضغوطات العمل (الشخصية / الإدارة المدرسية / الطلاب / زملاء العمل)- فيديو و تمارين  )');
/*!40000 ALTER TABLE `workshops` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'topappkw_almodaress'
--

--
-- Dumping routines for database 'topappkw_almodaress'
--
/*!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 2025-10-28  2:19:21