--
-- Host: localhost    Database: topappkw_almodaress
-- ------------------------------------------------------


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


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

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;

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

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');

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

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;

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

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');

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

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;

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


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

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;

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


--
-- Table structure for table `job_translations`
--

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;

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

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');

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

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;

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

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');

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

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;

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


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

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;

--
-- Dumping data for table `lecture_users`
--


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

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;

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

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);

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

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;

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

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);

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

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;

--
-- Dumping data for table `model_has_permissions`
--


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

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;

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

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);

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

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;

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

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');

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

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;

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

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');

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

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;

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


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

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;

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


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

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;

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

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');

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

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;

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

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');

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

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;

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

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');

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

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;

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


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

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;

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

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');

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

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;

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

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);

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

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;

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

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');

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

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;

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


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

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;

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


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

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;

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

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');

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

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;

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

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');

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

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;

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

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');

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

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;

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

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');

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

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;

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

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');

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

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;

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

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');

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

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;

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

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');

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

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;

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

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);

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

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;

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

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');

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

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;

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

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);

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

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;

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


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

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;

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


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

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;

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

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');

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

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;

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

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);

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

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;

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

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');

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

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;

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

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');

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

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;

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

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');

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

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;

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

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);

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

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;

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

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');

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

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;

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

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 شريحة تتضمن (المفهوم - العناصر المسببة لضغوط العمل - أسباب ضغوطات العمل (الشخصية / الإدارة المدرسية / الطلاب / زملاء العمل)- فيديو و تمارين  )');

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

--
-- Dumping routines for database 'topappkw_almodaress'
--


