MAINHACK

Viewing / Editing File: arabic_quiz.sql

-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: MySQL-5.7
-- Generation Time: Sep 13, 2025 at 10:18 PM
-- Server version: 5.7.44
-- PHP Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!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 */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `arabic_quiz`
--

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

--
-- Table structure for table `competitions`
--

CREATE TABLE `competitions` (
  `id` int(11) NOT NULL,
  `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `grade_id` int(11) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `competition_type` enum('group','millionaire') COLLATE utf8mb4_unicode_ci NOT NULL,
  `num_groups` int(11) DEFAULT '0',
  `is_public` tinyint(1) DEFAULT '0',
  `status` enum('draft','active','completed') COLLATE utf8mb4_unicode_ci DEFAULT 'draft',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `competitions`
--

INSERT INTO `competitions` (`id`, `title`, `teacher_id`, `grade_id`, `subject_id`, `competition_type`, `num_groups`, `is_public`, `status`, `created_at`) VALUES
(1, 'احياء', 2, 7, 10, 'group', 4, 0, 'active', '2025-08-12 07:27:35'),
(2, 'احياء', 2, 7, 10, 'millionaire', 4, 0, 'active', '2025-08-12 07:28:17'),
(4, 'الفروع', 2, 10, 10, 'millionaire', 4, 1, 'active', '2025-08-13 08:11:14'),
(5, 'علوم اول درسين', 2, 8, 3, 'group', 4, 1, 'active', '2025-09-13 19:25:18');

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

--
-- Table structure for table `game_results`
--

CREATE TABLE `game_results` (
  `id` int(11) NOT NULL,
  `competition_id` int(11) DEFAULT NULL,
  `student_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_score` int(11) DEFAULT '0',
  `game_type` enum('group','millionaire') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `game_results`
--

INSERT INTO `game_results` (`id`, `competition_id`, `student_name`, `group_name`, `final_score`, `game_type`, `completed_at`) VALUES
(11, 4, 'Hossam Ibrahim', NULL, 0, 'millionaire', '2025-08-13 08:14:34'),
(12, 4, 'Hossam Ibrahim', NULL, 0, 'millionaire', '2025-08-13 08:14:48'),
(13, 4, 'Hossam Ibrahim', NULL, 0, 'millionaire', '2025-08-13 08:14:57'),
(14, 4, 'Hossam Ibrahim', NULL, 0, 'millionaire', '2025-08-13 08:15:09'),
(725, 4, 'Hossam Ibrahim', NULL, 0, 'millionaire', '2025-08-17 12:03:27'),
(726, 4, 'Hossam Ibrahim', NULL, 0, 'millionaire', '2025-08-17 12:17:01'),
(727, 4, 'Hossam Ibrahim', NULL, 0, 'millionaire', '2025-08-21 14:18:34');

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

--
-- Table structure for table `grades`
--

CREATE TABLE `grades` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stage_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grades`
--

INSERT INTO `grades` (`id`, `name`, `stage_id`, `created_at`) VALUES
(1, 'الصف الأول', 1, '2025-08-12 07:20:02'),
(2, 'الصف الثاني', 1, '2025-08-12 07:20:02'),
(3, 'الصف الثالث', 1, '2025-08-12 07:20:02'),
(4, 'الصف الرابع', 1, '2025-08-12 07:20:02'),
(5, 'الصف الخامس', 1, '2025-08-12 07:20:02'),
(6, 'الصف السادس', 1, '2025-08-12 07:20:02'),
(7, 'الصف الأول متوسط', 2, '2025-08-12 07:20:02'),
(8, 'الصف الثاني متوسط', 2, '2025-08-12 07:20:02'),
(9, 'الصف الثالث متوسط', 2, '2025-08-12 07:20:02'),
(10, 'الصف الأول ثانوي', 3, '2025-08-12 07:20:02'),
(11, 'الصف الثاني ثانوي', 3, '2025-08-12 07:20:02'),
(12, 'الصف الثالث ثانوي', 3, '2025-08-12 07:20:02');

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

--
-- Table structure for table `group_questions`
--

CREATE TABLE `group_questions` (
  `id` int(11) NOT NULL,
  `competition_id` int(11) DEFAULT NULL,
  `question_text` text COLLATE utf8mb4_unicode_ci,
  `answer1` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `answer2` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `answer3` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `answer4` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `correct_answer` int(11) DEFAULT NULL,
  `question_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `card_type` enum('question','bonus','deduction','steal') COLLATE utf8mb4_unicode_ci DEFAULT 'question',
  `points_value` int(11) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_questions`
--

INSERT INTO `group_questions` (`id`, `competition_id`, `question_text`, `answer1`, `answer2`, `answer3`, `answer4`, `correct_answer`, `question_image`, `card_type`, `points_value`, `created_at`) VALUES
(18, 5, 'يتشابه كل من الماء والهواء في أن كلاهما ', 'له حجم ثابت', 'يمكن رؤيته', 'له شكل محدد', 'له كتلة', 4, '', 'question', 0, '2025-09-13 19:51:56'),
(19, 5, 'تتحرك جزيئات المادة...... حركة اهتزازية محدودة ', 'الصلبة', 'السائلة', 'الغازية', 'جميع ما سبق', 1, '', 'question', 0, '2025-09-13 19:52:41'),
(20, 5, 'سرعة انتشار الجزيئات الأقل كتلة   ................ سرعة انتشار الجزيئات الأكبر كتلة  ', 'أقل من', 'أكبر من', 'تساوي', 'لا توجد علاقة', 2, '', 'question', 0, '2025-09-13 19:53:14'),
(21, 5, 'خواص …………..من الماء هي نفس خواص ۱۰۰جم منه', 'ذرة', 'جزئ', 'جسيم', 'ب / جـ  معا', 4, '', 'question', 0, '2025-09-13 19:54:30'),
(22, 5, 'كل مادة نقية تتميز بدرجتي غليان وانصهار', 'متغيرتين', 'متماثلتين', 'ثابتتين', 'جميع ما سبق', 3, '', 'question', 0, '2025-09-13 19:55:15'),
(23, 5, 'تفقد المادة طاقة حرارية خلال عملية ', 'الانصهار', 'التبخر', 'التسامي', 'التكاثف', 4, '', 'question', 0, '2025-09-13 19:55:40'),
(24, 5, 'يتبخر الماء عند درجة حرارة ................. درجة غليانه ', 'أكبر من', 'أقل من', 'تساوي', 'لا توجد علاقة', 2, '', 'question', 0, '2025-09-13 19:56:16'),
(25, 5, 'تحول المادة من حالة إلى أخرى تعتبر عمليات ', 'كيميائية', 'متلازمة', 'انعكاسية', 'جميع ما سبق', 3, '', 'question', 0, '2025-09-13 19:56:56'),
(26, 5, 'عملية التكاثف عكس عملية ', 'الانصهار', 'التبخر', 'التسامي', 'جميع ما سبق', 2, '', 'question', 0, '2025-09-13 19:57:20'),
(27, 5, 'تكون قطرات الندى على أوراق النبات في الصباح الباكر يعد مثالا لعملية ', 'الانصهار', 'التبخر', 'التسامي', 'التكاثف', 4, '', 'question', 0, '2025-09-13 19:57:48'),
(28, 5, 'جميع ما يلي من العمليات التي يصاحبها اكتساب طاقة حرارية عدا ', 'الانصهار', 'التبخر', 'التسامي', 'التجمد', 4, '', 'question', 0, '2025-09-13 19:58:15'),
(29, 5, 'اجب', 'أ', 'ب', 'ج', 'د', 2, 'uploads/images/68c5ce425643c.png', 'question', 0, '2025-09-13 20:04:18'),
(30, 5, 'اجب', 'أ', 'ب', 'ج', 'د', 2, 'uploads/images/68c5cf3785fc5.png', 'question', 0, '2025-09-13 20:08:23'),
(31, 5, 'اجب', 'أ', 'ب', 'ج', 'د', 3, 'uploads/images/68c5cf674621c.png', 'question', 0, '2025-09-13 20:09:11'),
(32, 5, 'اجب', 'أ', 'ب', 'ج', 'د', 1, 'uploads/images/68c5cf94e533b.png', 'question', 0, '2025-09-13 20:09:56'),
(33, 5, 'اجب', 'أ', 'ب', 'ج', 'د', 3, 'uploads/images/68c5cfbf3d9b7.png', 'question', 0, '2025-09-13 20:10:39'),
(34, 5, 'اجب', 'أ', 'ب', 'ج', 'د', 2, 'uploads/images/68c5cfdba35c5.png', 'question', 0, '2025-09-13 20:11:07'),
(35, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'bonus', 5, '2025-09-13 20:11:23'),
(36, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'bonus', 15, '2025-09-13 20:11:30'),
(37, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'bonus', 10, '2025-09-13 20:11:34'),
(38, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'deduction', 5, '2025-09-13 20:11:46'),
(39, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'deduction', 10, '2025-09-13 20:11:50'),
(40, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'deduction', 15, '2025-09-13 20:11:56'),
(41, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'steal', 5, '2025-09-13 20:12:14'),
(42, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'steal', 10, '2025-09-13 20:12:18'),
(43, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'steal', 15, '2025-09-13 20:12:24'),
(44, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'bonus', 10, '2025-09-13 20:12:41'),
(45, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'deduction', 10, '2025-09-13 20:12:45');

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

--
-- Table structure for table `millionaire_questions`
--

CREATE TABLE `millionaire_questions` (
  `id` int(11) NOT NULL,
  `competition_id` int(11) DEFAULT NULL,
  `question_level` int(11) NOT NULL,
  `question_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer1` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer2` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer3` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer4` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct_answer` int(11) NOT NULL,
  `question_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `millionaire_questions`
--

INSERT INTO `millionaire_questions` (`id`, `competition_id`, `question_level`, `question_text`, `answer1`, `answer2`, `answer3`, `answer4`, `correct_answer`, `question_image`, `created_at`) VALUES
(1, 4, 1, 'hjghjghj', '1', '2', '3', '4', 1, 'uploads/images/689c48b9b65b6.jpg', '2025-08-13 08:11:37'),
(2, 4, 2, 'hgjghjghjghj', '1', '2', '3', '4', 1, '', '2025-08-13 08:11:48'),
(3, 4, 3, 'ghfjgfhgfhgfh', '1', '2', '3', '4', 1, '', '2025-08-13 08:12:00'),
(4, 4, 4, 'kjghkhjkjhk', '1', '2', '3', '4', 1, '', '2025-08-13 08:12:10'),
(5, 4, 5, 'hgjghjghkgj', '1', '2', '3', '4', 1, '', '2025-08-13 08:12:19'),
(6, 4, 6, 'gfhgfhgfjgfhgfhgfh', '1', '2', '3', '4', 1, '', '2025-08-13 08:12:30'),
(7, 4, 7, 'gfhfgjfgfhgfjgfhj', '1', '2', '3', '4', 1, '', '2025-08-13 08:12:42'),
(8, 4, 8, 'hjkhjkhjkhjkhjk', '1', '2', '3', '4', 1, '', '2025-08-13 08:12:50'),
(9, 4, 9, 'hjkhjljhkhjkuhkjk', '1', '2', '3', '4', 1, '', '2025-08-13 08:12:59'),
(10, 4, 10, 'hjkhjkhjljhkjkjhk', '1', '2', '3', '4', 1, '', '2025-08-13 08:13:09'),
(11, 4, 11, 'hjkhjlhjkhjkhjkjhk', '1', '2', '3', '4', 1, '', '2025-08-13 08:13:18'),
(12, 4, 12, 'hjkhjlukijhk', '1', '2', '3', '4', 1, '', '2025-08-13 08:13:27'),
(13, 4, 13, 'hjkhjkljulukhjk', '1', '2', '3', '4', 1, '', '2025-08-13 08:13:36'),
(14, 4, 14, 'hjklihlhjkkj', '1', '2', '3', '4', 1, '', '2025-08-13 08:13:45'),
(15, 4, 15, 'hjkhjkljuhkjhklhjkljhklhjl', '1', '2', '3', '4', 1, '', '2025-08-13 08:13:55');

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `setting_value` text COLLATE utf8mb4_unicode_ci,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `setting_key`, `setting_value`, `updated_at`) VALUES
(1, 'site_logo', 'assets/images/logo.png', '2025-08-12 07:20:02'),
(2, 'site_name', 'منصة المسابقات التعليمية', '2025-08-12 07:20:02');

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

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

CREATE TABLE `stages` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `stages` (`id`, `name`, `created_at`) VALUES
(1, 'المرحلة الابتدائية', '2025-08-12 07:20:02'),
(2, 'المرحلة المتوسطة', '2025-08-12 07:20:02'),
(3, 'المرحلة الثانوية', '2025-08-12 07:20:02');

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

--
-- Table structure for table `student_lists`
--

CREATE TABLE `student_lists` (
  `id` int(11) NOT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `grade_id` int(11) DEFAULT NULL,
  `student_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `student_lists`
--

INSERT INTO `student_lists` (`id`, `teacher_id`, `grade_id`, `student_name`, `created_at`) VALUES
(1, 2, 7, 'أحمد محمد علي', '2025-08-12 07:27:16'),
(2, 2, 7, 'فاطمة أحمد السالم', '2025-08-12 07:27:16'),
(3, 2, 7, 'محمد عبدالله الأحمد', '2025-08-12 07:27:16'),
(4, 2, 7, 'نورا سعد المطيري', '2025-08-12 07:27:16'),
(5, 2, 7, 'عبدالرحمن خالد العتيبي', '2025-08-12 07:27:16'),
(6, 2, 7, 'مريم عبدالعزيز القحطاني', '2025-08-12 07:27:16'),
(7, 2, 7, 'سارة محمد الغامدي', '2025-08-12 07:27:16'),
(8, 2, 7, 'يوسف عبدالله الشهري', '2025-08-12 07:27:16'),
(9, 2, 7, 'هند سعود العنزي', '2025-08-12 07:27:16'),
(10, 2, 7, 'عمر أحمد الحربي', '2025-08-12 07:27:16'),
(11, 2, 10, 'أحمد محمد علي', '2025-08-13 08:07:03'),
(12, 2, 10, 'فاطمة أحمد السالم', '2025-08-13 08:07:03'),
(13, 2, 10, 'محمد عبدالله الأحمد', '2025-08-13 08:07:03'),
(14, 2, 10, 'نورا سعد المطيري', '2025-08-13 08:07:03'),
(15, 2, 10, 'عبدالرحمن خالد العتيبي', '2025-08-13 08:07:03'),
(16, 2, 10, 'مريم عبدالعزيز القحطاني', '2025-08-13 08:07:03'),
(17, 2, 10, 'سارة محمد الغامدي', '2025-08-13 08:07:03'),
(18, 2, 10, 'يوسف عبدالله الشهري', '2025-08-13 08:07:03'),
(19, 2, 10, 'هند سعود العنزي', '2025-08-13 08:07:03'),
(20, 2, 10, 'عمر أحمد الحربي', '2025-08-13 08:07:03');

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

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

CREATE TABLE `subjects` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `subjects` (`id`, `name`, `created_at`) VALUES
(1, 'الرياضيات', '2025-08-12 07:20:02'),
(2, 'اللغة العربية', '2025-08-12 07:20:02'),
(3, 'العلوم', '2025-08-12 07:20:02'),
(4, 'التاريخ', '2025-08-12 07:20:02'),
(5, 'الجغرافيا', '2025-08-12 07:20:02'),
(6, 'اللغة الإنجليزية', '2025-08-12 07:20:02'),
(7, 'التربية الإسلامية', '2025-08-12 07:20:02'),
(8, 'الفيزياء', '2025-08-12 07:20:02'),
(9, 'الكيمياء', '2025-08-12 07:20:02'),
(10, 'الأحياء', '2025-08-12 07:20:02');

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

--
-- Table structure for table `teacher_assignments`
--

CREATE TABLE `teacher_assignments` (
  `id` int(11) NOT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `grade_id` int(11) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `teacher_assignments`
--

INSERT INTO `teacher_assignments` (`id`, `teacher_id`, `grade_id`, `subject_id`, `created_at`) VALUES
(1, 2, 10, 10, '2025-08-12 07:25:54'),
(2, 2, 10, 3, '2025-08-12 07:25:54'),
(3, 2, 12, 10, '2025-08-12 07:25:54'),
(4, 2, 12, 3, '2025-08-12 07:25:54'),
(5, 2, 11, 10, '2025-08-12 07:25:54'),
(6, 2, 11, 3, '2025-08-12 07:25:54'),
(7, 2, 7, 10, '2025-08-12 07:25:54'),
(8, 2, 7, 3, '2025-08-12 07:25:54'),
(9, 2, 9, 10, '2025-08-12 07:25:54'),
(10, 2, 9, 3, '2025-08-12 07:25:54'),
(11, 2, 8, 10, '2025-08-12 07:25:54'),
(12, 2, 8, 3, '2025-08-12 07:25:54');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `full_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` enum('admin','teacher','student') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `username`, `password`, `full_name`, `email`, `role`, `created_at`) VALUES
(1, 'admin', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'مدير النظام', NULL, 'admin', '2025-08-12 07:20:02'),
(2, 'hossam', '$2y$10$Wy7ppEDG8G0jUzjGEJwaqOUoLjf4MDTjoqrdhN71TXrFcXpdF8xEG', 'Hossam Ibrahim', 'hoss4ever@yahoo.com', 'teacher', '2025-08-12 07:25:30');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `competitions`
--
ALTER TABLE `competitions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teacher_id` (`teacher_id`),
  ADD KEY `grade_id` (`grade_id`),
  ADD KEY `subject_id` (`subject_id`);

--
-- Indexes for table `game_results`
--
ALTER TABLE `game_results`
  ADD PRIMARY KEY (`id`),
  ADD KEY `competition_id` (`competition_id`);

--
-- Indexes for table `grades`
--
ALTER TABLE `grades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stage_id` (`stage_id`);

--
-- Indexes for table `group_questions`
--
ALTER TABLE `group_questions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `competition_id` (`competition_id`);

--
-- Indexes for table `millionaire_questions`
--
ALTER TABLE `millionaire_questions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `competition_id` (`competition_id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

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

--
-- Indexes for table `student_lists`
--
ALTER TABLE `student_lists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teacher_id` (`teacher_id`),
  ADD KEY `grade_id` (`grade_id`);

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

--
-- Indexes for table `teacher_assignments`
--
ALTER TABLE `teacher_assignments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teacher_id` (`teacher_id`),
  ADD KEY `grade_id` (`grade_id`),
  ADD KEY `subject_id` (`subject_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `competitions`
--
ALTER TABLE `competitions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `game_results`
--
ALTER TABLE `game_results`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2608;

--
-- AUTO_INCREMENT for table `grades`
--
ALTER TABLE `grades`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `group_questions`
--
ALTER TABLE `group_questions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `millionaire_questions`
--
ALTER TABLE `millionaire_questions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `stages`
--
ALTER TABLE `stages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `student_lists`
--
ALTER TABLE `student_lists`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `subjects`
--
ALTER TABLE `subjects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `teacher_assignments`
--
ALTER TABLE `teacher_assignments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `competitions`
--
ALTER TABLE `competitions`
  ADD CONSTRAINT `competitions_ibfk_1` FOREIGN KEY (`teacher_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `competitions_ibfk_2` FOREIGN KEY (`grade_id`) REFERENCES `grades` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `competitions_ibfk_3` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `game_results`
--
ALTER TABLE `game_results`
  ADD CONSTRAINT `game_results_ibfk_1` FOREIGN KEY (`competition_id`) REFERENCES `competitions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `grades`
--
ALTER TABLE `grades`
  ADD CONSTRAINT `grades_ibfk_1` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `group_questions`
--
ALTER TABLE `group_questions`
  ADD CONSTRAINT `group_questions_ibfk_1` FOREIGN KEY (`competition_id`) REFERENCES `competitions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `millionaire_questions`
--
ALTER TABLE `millionaire_questions`
  ADD CONSTRAINT `millionaire_questions_ibfk_1` FOREIGN KEY (`competition_id`) REFERENCES `competitions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `student_lists`
--
ALTER TABLE `student_lists`
  ADD CONSTRAINT `student_lists_ibfk_1` FOREIGN KEY (`teacher_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `student_lists_ibfk_2` FOREIGN KEY (`grade_id`) REFERENCES `grades` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `teacher_assignments`
--
ALTER TABLE `teacher_assignments`
  ADD CONSTRAINT `teacher_assignments_ibfk_1` FOREIGN KEY (`teacher_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `teacher_assignments_ibfk_2` FOREIGN KEY (`grade_id`) REFERENCES `grades` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `teacher_assignments_ibfk_3` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE;
COMMIT;

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

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: arabic_quiz.sql

Server Info

System Features

User Info