-- =====================================================
-- Auto-École Digital — SQL Export
-- Date: 2026-04-09 19:49:48
-- Version: 1.0.0
-- =====================================================

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- Table: students
TRUNCATE TABLE `students`;
INSERT INTO `students` (`id`, `uuid`, `cin`, `first_name`, `last_name`, `phone`, `email`, `birth_date`, `address`, `photo_path`, `contract_path`, `medical_path`, `license_category`, `theory_hours`, `practical_hours`, `theory_passed`, `practical_passed`, `status`, `enrolled_at`, `synced_at`, `updated_at`, `created_at`) VALUES ('1', '77fb1832-343a-11f1-a131-794e1a98ad9b', 'AB123456', 'Youssef', 'Benali', '0600112233', NULL, NULL, NULL, NULL, NULL, NULL, 'B', '5.0', '3.0', '0', '0', 'active', '2026-04-09', '2026-04-09 17:52:15', '2026-04-09 17:52:15', '2026-04-09 17:35:15');
INSERT INTO `students` (`id`, `uuid`, `cin`, `first_name`, `last_name`, `phone`, `email`, `birth_date`, `address`, `photo_path`, `contract_path`, `medical_path`, `license_category`, `theory_hours`, `practical_hours`, `theory_passed`, `practical_passed`, `status`, `enrolled_at`, `synced_at`, `updated_at`, `created_at`) VALUES ('2', '77fb196b-343a-11f1-a131-794e1a98ad9b', 'CD789012', 'Khadija', 'El Fassi', '0611223344', NULL, NULL, NULL, NULL, NULL, NULL, 'B', '8.0', '6.5', '0', '0', 'active', '2026-04-09', '2026-04-09 17:52:15', '2026-04-09 17:52:15', '2026-04-09 17:35:15');
INSERT INTO `students` (`id`, `uuid`, `cin`, `first_name`, `last_name`, `phone`, `email`, `birth_date`, `address`, `photo_path`, `contract_path`, `medical_path`, `license_category`, `theory_hours`, `practical_hours`, `theory_passed`, `practical_passed`, `status`, `enrolled_at`, `synced_at`, `updated_at`, `created_at`) VALUES ('3', 'a84e76a6-343a-11f1-a131-794e1a98ad9b', 'ib247773', 'salah eddine', 'amane', '0623461814', 'salahamane935@gmail.com', NULL, NULL, NULL, NULL, NULL, 'B', '0.0', '4.0', '0', '0', 'active', '2026-04-09', '2026-04-09 17:52:15', '2026-04-09 17:52:15', '2026-04-09 17:36:36');

-- Table: instructors
TRUNCATE TABLE `instructors`;
INSERT INTO `instructors` (`id`, `uuid`, `full_name`, `cin`, `phone`, `email`, `license_number`, `salary`, `status`, `synced_at`, `created_at`) VALUES ('1', '77fb02a3-343a-11f1-a131-794e1a98ad9b', 'Mohammed Alami', 'BK123456', '0661001122', NULL, NULL, '3500.00', 'active', NULL, '2026-04-09 17:35:15');
INSERT INTO `instructors` (`id`, `uuid`, `full_name`, `cin`, `phone`, `email`, `license_number`, `salary`, `status`, `synced_at`, `created_at`) VALUES ('2', '77fb0457-343a-11f1-a131-794e1a98ad9b', 'Fatima Zahra', 'CD789012', '0662003344', NULL, NULL, '3200.00', 'active', NULL, '2026-04-09 17:35:15');

-- Table: vehicles
TRUNCATE TABLE `vehicles`;
INSERT INTO `vehicles` (`id`, `uuid`, `plate`, `model`, `year`, `category`, `insurance_expiry`, `inspection_date`, `total_km`, `status`, `synced_at`, `created_at`) VALUES ('1', '77fb128f-343a-11f1-a131-794e1a98ad9b', 'A-12345-1', 'Dacia Logan', '2022', 'B', '2025-12-31', NULL, '0', 'available', NULL, '2026-04-09 17:35:15');
INSERT INTO `vehicles` (`id`, `uuid`, `plate`, `model`, `year`, `category`, `insurance_expiry`, `inspection_date`, `total_km`, `status`, `synced_at`, `created_at`) VALUES ('2', '77fb1366-343a-11f1-a131-794e1a98ad9b', 'B-67890-2', 'Renault Clio', '2021', 'B', '2025-06-30', NULL, '0', 'available', NULL, '2026-04-09 17:35:15');

-- Table: sessions
TRUNCATE TABLE `sessions`;
INSERT INTO `sessions` (`id`, `uuid`, `student_id`, `instructor_id`, `vehicle_id`, `session_type`, `session_date`, `start_time`, `end_time`, `duration_hours`, `status`, `notes`, `synced_at`, `created_at`) VALUES ('1', 'c97cdcb4-343a-11f1-a131-794e1a98ad9b', '3', '1', '1', 'practical', '2026-04-09', '21:00:00', NULL, '4.0', 'scheduled', NULL, NULL, '2026-04-09 17:37:31');

-- Table: payments
TRUNCATE TABLE `payments`;
INSERT INTO `payments` (`id`, `uuid`, `student_id`, `amount`, `payment_date`, `payment_method`, `tranche_number`, `invoice_number`, `notes`, `synced_at`, `created_at`) VALUES ('1', '77fb44c4-343a-11f1-a131-794e1a98ad9b', '1', '1500.00', '2026-04-09', 'cash', '1', 'INV-2026-001', NULL, NULL, '2026-04-09 17:35:15');
INSERT INTO `payments` (`id`, `uuid`, `student_id`, `amount`, `payment_date`, `payment_method`, `tranche_number`, `invoice_number`, `notes`, `synced_at`, `created_at`) VALUES ('2', 'dd30d7d3-343a-11f1-a131-794e1a98ad9b', '3', '2000.00', '2026-04-09', 'cash', '1', 'INV-2026-0002', '', NULL, '2026-04-09 17:38:04');

-- Table: contracts
TRUNCATE TABLE `contracts`;
INSERT INTO `contracts` (`id`, `student_id`, `total_amount`, `paid_amount`, `contract_date`, `notes`) VALUES ('1', '1', '3500.00', '1500.00', '2026-04-09', NULL);
INSERT INTO `contracts` (`id`, `student_id`, `total_amount`, `paid_amount`, `contract_date`, `notes`) VALUES ('2', '3', '3000.00', '2000.00', '2026-04-09', NULL);

-- Table: questions
TRUNCATE TABLE `questions`;
INSERT INTO `questions` (`id`, `uuid`, `category`, `question_ar`, `question_fr`, `answer_a_ar`, `answer_b_ar`, `answer_c_ar`, `answer_d_ar`, `answer_a_fr`, `answer_b_fr`, `correct_answer`, `is_eliminatory`, `image_path`, `synced_at`, `created_at`) VALUES ('1', '77fb243d-343a-11f1-a131-794e1a98ad9b', 'signs', 'ماذا تعني الإشارة المثلثة الحمراء؟', 'Que signifie le panneau triangulaire rouge?', 'خطر / danger', 'توقف / stop', 'أولوية / priorité', NULL, NULL, NULL, 'a', '0', NULL, NULL, '2026-04-09 17:35:15');
INSERT INTO `questions` (`id`, `uuid`, `category`, `question_ar`, `question_fr`, `answer_a_ar`, `answer_b_ar`, `answer_c_ar`, `answer_d_ar`, `answer_a_fr`, `answer_b_fr`, `correct_answer`, `is_eliminatory`, `image_path`, `synced_at`, `created_at`) VALUES ('2', '77fb2597-343a-11f1-a131-794e1a98ad9b', 'priorities', 'من له الأولوية في التقاطع؟', 'Qui a la priorité au carrefour?', 'السيارة من اليمين', 'السيارة من اليسار', 'المشاة دائماً', NULL, NULL, NULL, 'a', '0', NULL, NULL, '2026-04-09 17:35:15');
INSERT INTO `questions` (`id`, `uuid`, `category`, `question_ar`, `question_fr`, `answer_a_ar`, `answer_b_ar`, `answer_c_ar`, `answer_d_ar`, `answer_a_fr`, `answer_b_fr`, `correct_answer`, `is_eliminatory`, `image_path`, `synced_at`, `created_at`) VALUES ('3', '883449c7-343b-11f1-a131-794e1a98ad9b', 'signs', 'ما لون ضوء اعلئ', '', ' احمر', 'احضر', 'ازرق ', 'اصفر', NULL, NULL, 'a', '1', NULL, NULL, '2026-04-09 17:42:51');
INSERT INTO `questions` (`id`, `uuid`, `category`, `question_ar`, `question_fr`, `answer_a_ar`, `answer_b_ar`, `answer_c_ar`, `answer_d_ar`, `answer_a_fr`, `answer_b_fr`, `correct_answer`, `is_eliminatory`, `image_path`, `synced_at`, `created_at`) VALUES ('4', 'c668974e-343b-11f1-a131-794e1a98ad9b', 'firstaid', 'الا لقيت شخص يتنزف اش خصني ندير ', '', 'نعونو', 'نتسنى اسعاف ', 'نتاكد انه بعيد من طريق لي حدت اخر الا قدر الله و نتسنى اسعاف', 'منعونوش', NULL, NULL, 'c', '0', NULL, NULL, '2026-04-09 17:44:36');
INSERT INTO `questions` (`id`, `uuid`, `category`, `question_ar`, `question_fr`, `answer_a_ar`, `answer_b_ar`, `answer_c_ar`, `answer_d_ar`, `answer_a_fr`, `answer_b_fr`, `correct_answer`, `is_eliminatory`, `image_path`, `synced_at`, `created_at`) VALUES ('5', '19f0cff2-343c-11f1-a131-794e1a98ad9b', 'behavior', 'عندي ضو خضر باش نمر و لقيت طمبيل قريبة ليا بي 12 متر سرعة ديالها كتر من 60 كيلو متر في ساعة', '', 'ندوز', 'نصبر حتى يمشي او ندوز', 'نزيد سرعة كتر او نسبق و ندوز', '', NULL, NULL, 'b', '0', NULL, NULL, '2026-04-09 17:46:56');

SET FOREIGN_KEY_CHECKS = 1;
-- End of export