-- Restore exam 101 (ABA Assessment Grade 3 Arabs) for school 27033 (Star Private School)
-- Generated from backup database: aba_backup_inspect
-- Backup dump source file: tasheeh_aba_db (10).sql
-- Backup generation timestamp: 2026-03-24 04:41:00 UTC
--
-- Scope:
-- 1. Remove current school registration + exam registrations for all rounds for exam 101 / school 27033
-- 2. Remove round-level recommendations for exam 101 / school 27033
-- 3. Recreate the school registration row from backup
-- 4. Recreate the 63 student user accounts if any of them are missing
-- 5. Recreate the 63 original round-1 student registrations from backup
--
-- Notes:
-- - This script does NOT delete from users_answers.
-- - This script does NOT delete student user accounts.
-- - Student registration IDs are restored exactly as in the backup so any surviving answer rows keyed by reg_id can relink.

START TRANSACTION;

DELETE FROM school_exam_recommendations
WHERE exam_id = 101
  AND school_id = 27033;

DELETE FROM student_registrations
WHERE exam_id = 101
  AND school_id = 27033;

DELETE FROM school_registerations
WHERE exam_id = 101
  AND school_id = 27033;

-- Recreate missing student user rows for the 63 students in the backup.
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27211,NULL,'Dana Mohamad Merei','SPS021072','users/default.png',NULL,'$2y$10$U9AE9EfjqPft6lRrjfNWPe28Q7Qpt4OopZQgR4K/DU4xIYMnQl6ZO',NULL,'2025-11-24 20:25:42','2025-11-24 20:25:42',2,27033,'2025-11-24 16:25:42',NULL,1,'UAE','Sharjah','Syria','British','SPS021072','Female','3','A','Not Set','97181366',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27212,NULL,'Farah Bahaa Mohamed Fathy Ashoush','SPS021073','users/default.png',NULL,'$2y$10$HgycbLlSFJFpIt.QQIkcquZyRn8FXh54Gfjb9oNrS0bEjw32UckY6',NULL,'2025-11-24 20:25:42','2025-11-24 20:25:42',2,27033,'2025-11-24 16:25:42',NULL,1,'UAE','Sharjah','Egypt','British','SPS021073','Female','3','A','Not Set','90664071',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27213,NULL,'Farida Bahaa Mohamed Fathy Ashoush','SPS021074','users/default.png',NULL,'$2y$10$gVD5kZqmC889CN3Vmqae7.InULOSPrsSwYGzAB.vLuilHwytrEOda',NULL,'2025-11-24 20:25:42','2025-11-24 20:25:42',2,27033,'2025-11-24 16:25:42',NULL,1,'UAE','Sharjah','Egypt','British','SPS021074','Female','3','A','Not Set','97093645',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27214,NULL,'Marya Mohamed Salah Abdelsattar Abdelhakeem','SPS021075','users/default.png',NULL,'$2y$10$UlN2MJV.mRpMA.PZHsP6w.NrqnRDupeEEKtbpXeviBlrlpf50TpWW',NULL,'2025-11-24 20:25:43','2025-11-24 20:25:43',2,27033,'2025-11-24 16:25:43',NULL,1,'UAE','Sharjah','Egypt','British','SPS021075','Female','3','A','Not Set','96825639',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27215,NULL,'Miral Abdelhamid Ismaeil Abdelhamid','SPS021076','users/default.png',NULL,'$2y$10$BGB1xyIiLDWRzoi6vcZ7xeGdiMXtK9xu1fNhNls1NX9bAhmp5F3oq',NULL,'2025-11-24 20:25:43','2025-11-24 20:25:43',2,27033,'2025-11-24 16:25:43',NULL,1,'UAE','Sharjah','Egypt','British','SPS021076','Female','3','A','Not Set','92452770',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27216,NULL,'Mohamed Ahmed Abdelsamad Abdelmagid Abdelsamad','SPS021077','users/default.png',NULL,'$2y$10$9Q59C4AhAesx0ryRnzFvbO6mMseGAifh8t4/0sAXLn6at/9bHB3Oi',NULL,'2025-11-24 20:25:43','2025-11-24 20:25:43',2,27033,'2025-11-24 16:25:43',NULL,1,'UAE','Sharjah','Egypt','British','SPS021077','Male','3','A','Not Set','90080795',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27217,NULL,'Mohamed Emad Abdelmoneam Ibrahim Thabet','SPS021078','users/default.png',NULL,'$2y$10$yrOYjnu1OOhwJVNX8SJIveNMU8tjT3yKe5X/Q74q/7dYWMgJ.4cv.',NULL,'2025-11-24 20:25:43','2025-11-24 20:25:43',2,27033,'2025-11-24 16:25:43',NULL,1,'UAE','Sharjah','Egypt','British','SPS021078','Male','3','A','Not Set','90811977',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27218,NULL,'Mohamed Luay Mohamed Mahgoub','SPS021079','users/default.png',NULL,'$2y$10$ye63rs9M0THnLNd0sDp2weCGLWx6CGKoNhHKwzwJkp/9xK3o3Fzi2',NULL,'2025-11-24 20:25:43','2025-11-24 20:25:43',2,27033,'2025-11-24 16:25:43',NULL,1,'UAE','Sharjah','Sudan','British','SPS021079','Male','3','A','Not Set','97873311',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27219,NULL,'Mohammad Anwar Hafiz Abu Shaqra ','SPS021080','users/default.png',NULL,'$2y$10$ohlfQHOBZ1csIFyHkN/GruOrIllcdecQDcIBhxwCK.NjYNayAayDq',NULL,'2025-11-24 20:25:43','2025-11-24 20:25:43',2,27033,'2025-11-24 16:25:43',NULL,1,'UAE','Sharjah','Jordan','British','SPS021080','Male','3','A','Not Set','94251444',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27220,NULL,'Ola Omar Ghanim Ezzeldeen','SPS021081','users/default.png',NULL,'$2y$10$l/m3jeujZDRy1SLZ4XH0r.rHUHmKbU.eHoxkPda8oAa6WfHXYtjDS',NULL,'2025-11-24 20:25:44','2025-11-24 20:25:44',2,27033,'2025-11-24 16:25:44',NULL,1,'UAE','Sharjah','Sudan','British','SPS021081','Female','3','A','Not Set','90520295',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27221,NULL,'Orchid Wael Mahmoud Ali Elgaaly','SPS021082','users/default.png',NULL,'$2y$10$yAgqxiKcSvl1Gr/kfWaZIuZt6ru2xC99pMyZ/XRmSg5FSSLDwowm6',NULL,'2025-11-24 20:25:44','2025-11-24 20:25:44',2,27033,'2025-11-24 16:25:44',NULL,1,'UAE','Sharjah','Egypt','British','SPS021082','Female','3','A','Not Set','97733958',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27222,NULL,'Tasneem Said Bashir Abdellatif Ahmed','SPS021083','users/default.png',NULL,'$2y$10$jluUYfmMuLfnZXSM9eWTzuIO3SDzFsvO6cfYWVcZXx.Ao.gPJ3PlO',NULL,'2025-11-24 20:25:44','2025-11-24 20:25:44',2,27033,'2025-11-24 16:25:44',NULL,1,'UAE','Sharjah','Egypt','British','SPS021083','Female','3','A','Not Set','91926753',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27223,NULL,'Adam Osama Mohamed Abdelhady Eid','SPS021084','users/default.png',NULL,'$2y$10$jNqryo2uz8XzgwnSBm2p2OzeFJeBgwTD8dzfaph7q0Z3yIeRHfTli',NULL,'2025-11-24 20:25:44','2025-11-24 20:25:44',2,27033,'2025-11-24 16:25:44',NULL,1,'UAE','Sharjah','Egypt','British','SPS021084','Male','3','B','Not Set','92364950',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27224,NULL,'Asel Osama Mohamed Ali Mohamed','SPS021085','users/default.png',NULL,'$2y$10$rR8DHdkoImuFdaDMSDiA7OWvxVd8BLKfT.XWgYplHH0a1Rb2GcRMm',NULL,'2025-11-24 20:25:44','2025-11-24 20:25:44',2,27033,'2025-11-24 16:25:44',NULL,1,'UAE','Sharjah','Egypt','British','SPS021085','Female','3','B','Not Set','98335462',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27225,NULL,'Dahab Abdelmageed Sabhy Elsayed Ali Amer','SPS021086','users/default.png',NULL,'$2y$10$AHa/LLIbjQO2o2CEEgQQ3efEIxqunxQ2qnAwAWY6MgnjPWAYnvavu',NULL,'2025-11-24 20:25:44','2025-11-24 20:25:44',2,27033,'2025-11-24 16:25:44',NULL,1,'UAE','Sharjah','Egypt','British','SPS021086','Female','3','B','Not Set','94922374',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27226,NULL,'Elias Bilal Elsayed','SPS021087','users/default.png',NULL,'$2y$10$2TuUo5.YWTkkjCBLIyeIMO8bTi5HqhueU.wbPKJ7lJW8XlbYDTkeO',NULL,'2025-11-24 20:25:44','2025-11-24 20:25:44',2,27033,'2025-11-24 16:25:44',NULL,1,'UAE','Sharjah','Palestine','British','SPS021087','Male','3','B','Not Set','96395535',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27227,NULL,'Gouri Awad Thabet Ismail Awad','SPS021088','users/default.png',NULL,'$2y$10$rSpoIPZ2uL8ZOyrXepnJaeYk507RKaPDpSAHFsEaLGBBZBUcCD.5i',NULL,'2025-11-24 20:25:45','2025-11-24 20:25:45',2,27033,'2025-11-24 16:25:45',NULL,1,'UAE','Sharjah','Egypt','British','SPS021088','Female','3','B','Not Set','91940303',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27228,NULL,'Gowaireya Mohsen Abouelfadl Hussein','SPS021089','users/default.png',NULL,'$2y$10$prhnK/umIOIzs3cheXQ65ObNw/D9P.HhuDYom7mWjGYJOqvDw6/l6',NULL,'2025-11-24 20:25:45','2025-11-24 20:25:45',2,27033,'2025-11-24 16:25:45',NULL,1,'UAE','Sharjah','Egypt','British','SPS021089','Female','3','B','Not Set','99519240',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27229,NULL,'Hatim Mohamed Osman Ahmed','SPS021090','users/default.png',NULL,'$2y$10$D9BZQeI3bBdGCBRLZmtqPeQJqP7xWVMG9WIz2rzhYBVratgwo9cCy',NULL,'2025-11-24 20:25:45','2025-11-24 20:25:45',2,27033,'2025-11-24 16:25:45',NULL,1,'UAE','Sharjah','Sudan','British','SPS021090','Male','3','B','Not Set','95249737',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27230,NULL,'Kareem Jamal Al Khawaldeh','SPS021091','users/default.png',NULL,'$2y$10$JdaKu1sDtmV3vQPmUP2lNOSjGeDSN2RdQPbtBE2GIMMf72Zkhu8RK',NULL,'2025-11-24 20:25:45','2025-11-24 20:25:45',2,27033,'2025-11-24 16:25:45',NULL,1,'UAE','Sharjah','Syria','British','SPS021091','Male','3','B','Not Set','99743243',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27231,NULL,'Karma Emad Abdelwahed Abdelbaky Mohamed','SPS021092','users/default.png',NULL,'$2y$10$tLTI/FDscf9Y7aH./5gXyee6euhs3sLHFVKaJ5mzji5VJ2w1dgLTm',NULL,'2025-11-24 20:25:45','2025-11-24 20:25:45',2,27033,'2025-11-24 16:25:45',NULL,1,'UAE','Sharjah','Egypt','British','SPS021092','Female','3','B','Not Set','90939656',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27232,NULL,'Lateefa Abdulaziz Aden','SPS021093','users/default.png',NULL,'$2y$10$RHOcmaJtB2xdo2weIAgFW.LAjXQ4.1.YxYWMxUBt8O4Vk1MvUlm.y',NULL,'2025-11-24 20:25:45','2025-11-24 20:25:45',2,27033,'2025-11-24 16:25:45',NULL,1,'UAE','Sharjah','Somalia','British','SPS021093','Female','3','B','Not Set','93014893',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27233,NULL,'Maha Jasem Armand ','SPS021094','users/default.png',NULL,'$2y$10$sw7r1mCIdladh4N2xZ8zJe0s6fPfGfqM9bt9Q109831wo9O13LJla',NULL,'2025-11-24 20:25:45','2025-11-24 20:25:45',2,27033,'2025-11-24 16:25:45',NULL,1,'UAE','Sharjah','Iran','British','SPS021094','Female','3','B','Not Set','97430344',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27234,NULL,'Mariam Mohamed Elamin Abdelmoneim Hassan','SPS021095','users/default.png',NULL,'$2y$10$v.BoWYTqRHzSJ8x1RZk3luBSF/natHqcSyz131tB55ePJTfn9A2Jy',NULL,'2025-11-24 20:25:46','2025-11-24 20:25:46',2,27033,'2025-11-24 16:25:46',NULL,1,'UAE','Sharjah','Sudan','British','SPS021095','Female','3','B','Not Set','95370089',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27235,NULL,'Massa Medhat Ramadan Sayed Ibrahim','SPS021096','users/default.png',NULL,'$2y$10$8pe/W8sZoIc6dgvvFS1FcOiDPu4FDi0KYXETu6cjA18GSkHSZKXHu',NULL,'2025-11-24 20:25:46','2025-11-24 20:25:46',2,27033,'2025-11-24 16:25:46',NULL,1,'UAE','Sharjah','Egypt','British','SPS021096','Female','3','B','Not Set','94162725',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27236,NULL,'Mohamed Abdelnasser Khattab Hassan Sakr','SPS021097','users/default.png',NULL,'$2y$10$5FgaQzWwS9sQXQOoQ9Sa/e0zOw7F17NnUyMF1V6QhZd4WSsj8/dqm',NULL,'2025-11-24 20:25:47','2025-11-24 20:25:47',2,27033,'2025-11-24 16:25:47',NULL,1,'UAE','Sharjah','Egypt','British','SPS021097','Male','3','B','Not Set','96013352',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27237,NULL,'Mohammad Abdulmunem Abdulmunem','SPS021098','users/default.png',NULL,'$2y$10$xymzB3yM/ty.gEj4ygcca.f2Fkbapk.eL.83Ht0122s2goVE5VnIC',NULL,'2025-11-24 20:25:47','2025-11-24 20:25:47',2,27033,'2025-11-24 16:25:47',NULL,1,'UAE','Sharjah','Syrian','British','SPS021098','Male','3','B','Not Set','97897857',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27238,NULL,'Noor Mohamed Samy Ahmed Salem ','SPS021099','users/default.png',NULL,'$2y$10$6LoXmIgj9kHyD92j3My7TOY6L1V5FbFXO15TBwJyiTowYhjwgn7Ti',NULL,'2025-11-24 20:25:47','2025-11-24 20:25:47',2,27033,'2025-11-24 16:25:47',NULL,1,'UAE','Sharjah','Egypt','British','SPS021099','Female','3','B','Not Set','93525470',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27239,NULL,'Osman Khaled Abass Abd Almaged','SPS021100','users/default.png',NULL,'$2y$10$2NsHR6X45eMi9xXQTeWG4eaeNazkU19XdnB1qskKsWnxj77abQ5u2',NULL,'2025-11-24 20:25:47','2025-11-24 20:25:47',2,27033,'2025-11-24 16:25:47',NULL,1,'UAE','Sharjah','Sudan','British','SPS021100','Male','3','B','Not Set','92241457',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27240,NULL,'Shehab Ahmed Hammad Abdu ','SPS021101','users/default.png',NULL,'$2y$10$usy46Ht6xXNGYIJQDEsG.e0mRvv.TeY4oIlanQaGV/ouLzlJpVify',NULL,'2025-11-24 20:25:47','2025-11-24 20:25:47',2,27033,'2025-11-24 16:25:47',NULL,1,'UAE','Sharjah','Sudan','British','SPS021101','Male','3','B','Not Set','92424910',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27241,NULL,'Yaseen Marwan Mohamed Ali Omer','SPS021102','users/default.png',NULL,'$2y$10$mRFOPEAFzdCx6FiK3E.58eSqChbXqhABHY8m/rOT0OKshtFbMscue',NULL,'2025-11-24 20:25:47','2025-11-24 20:25:47',2,27033,'2025-11-24 16:25:47',NULL,1,'UAE','Sharjah','Sudan','British','SPS021102','Male','3','B','Not Set','98493155',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27242,NULL,'Sara Mohammed Abdulbari Abdo Al Nahari','SPS021103','users/default.png',NULL,'$2y$10$ZthK9RH0iZk44Aa9ZWZG5.20.x2cKyD8SNPRb6APPGFh69z0hY09W',NULL,'2025-11-24 20:25:47','2025-11-24 20:25:47',2,27033,'2025-11-24 16:25:47',NULL,1,'UAE','Sharjah','Yemen','British','SPS021103','Female','3','B','Not Set','95953962',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27243,NULL,'Abdullah Salah Hassan Ibrahim','SPS021104','users/default.png',NULL,'$2y$10$NqixPpu1n40diT7anhtJbe7Ug9HXeWKxTD3LVksIqPFyS0YCT69G6',NULL,'2025-11-24 20:25:48','2025-11-24 20:25:48',2,27033,'2025-11-24 16:25:48',NULL,1,'UAE','Sharjah','Egypt','British','SPS021104','Male','3','C','Not Set','93145856',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27244,NULL,'Anas Ahmed Mohamed Samir Elsayed Farag Elmahalawy','SPS021105','users/default.png',NULL,'$2y$10$6n8slIYesBR.TCCJkGZn2ewDwlSjsKdjyH1DFSLTvIt6NNAlxPggq',NULL,'2025-11-24 20:25:48','2025-11-24 20:25:48',2,27033,'2025-11-24 16:25:48',NULL,1,'UAE','Sharjah','Egypt','British','SPS021105','Male','3','C','Not Set','90662496',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27245,NULL,'Heyam Hossein Khalaf Hemadi ','SPS021106','users/default.png',NULL,'$2y$10$3GIKx/57ilbyn7RgrZQwWuFsXoRO4mRcCOsvnMSjsaA6c0w3fkX6u',NULL,'2025-11-24 20:25:48','2025-11-24 20:25:48',2,27033,'2025-11-24 16:25:48',NULL,1,'UAE','Sharjah','Iran','British','SPS021106','Female','3','C','Not Set','91104378',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27246,NULL,'Juan Azad Mohammad','SPS021107','users/default.png',NULL,'$2y$10$2ax45HEridsEDevaD2oCSOTI038JEh0dAfeIwzN/IQn4e1Tal7trq',NULL,'2025-11-24 20:25:48','2025-11-24 20:25:48',2,27033,'2025-11-24 16:25:48',NULL,1,'UAE','Sharjah','Syrian','British','SPS021107','Male','3','C','Not Set','95708708',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27247,NULL,'Lareen Sabri Brakat Ahmed ','SPS021108','users/default.png',NULL,'$2y$10$Pnlfg5i0nNz9wITGfY6czevjbzCCCAIzZlaV2Pc/rcf6BX6ks9JAm',NULL,'2025-11-24 20:25:48','2025-11-24 20:25:48',2,27033,'2025-11-24 16:25:48',NULL,1,'UAE','Sharjah','Sudan','British','SPS021108','Female','3','C','Not Set','98721345',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27248,NULL,'Roqaya Ahmed Mohamed Latif Mohamed Hatem','SPS021109','users/default.png',NULL,'$2y$10$DUWj5r4iKYvhCigTJBRJEOQOsqpfI.ZIixVd1CeB2Q3PXZAGvztde',NULL,'2025-11-24 20:25:48','2025-11-24 20:25:48',2,27033,'2025-11-24 16:25:48',NULL,1,'UAE','Sharjah','Egypt','British','SPS021109','Female','3','C','Not Set','97484049',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27249,NULL,'Salma Abbas Ali Saeed','SPS021110','users/default.png',NULL,'$2y$10$L0BTwch.WN7XMcLFt2665eTJPx.rRGCIR8BZG/3pcVjie4Kqn3wga',NULL,'2025-11-24 20:25:49','2025-11-24 20:25:49',2,27033,'2025-11-24 16:25:49',NULL,1,'UAE','Sharjah','Sudan','British','SPS021110','Female','3','C','Not Set','96120666',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27250,NULL,'Selim Mohamed Hussein Abdelmagid Zahran','SPS021111','users/default.png',NULL,'$2y$10$mddXcIQzFGvTipwRsN9PV.xMB2NRi73AaUJ8xDyNgSKTm4MzYf/Cq',NULL,'2025-11-24 20:25:51','2025-11-24 20:25:51',2,27033,'2025-11-24 16:25:51',NULL,1,'UAE','Sharjah','Egypt','British','SPS021111','Male','3','C','Not Set','95290727',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27251,NULL,'Falak Hisham Ahmed Sallama Sayed Ahmed','SPS021112','users/default.png',NULL,'$2y$10$zja0S9JoQSkepAZuxWa1a.3F5jgwuRQx/Luc/Xhmim3/LV2.Ai97S',NULL,'2025-11-24 20:25:51','2025-11-24 20:25:51',2,27033,'2025-11-24 16:25:51',NULL,1,'UAE','Sharjah','Egypt','British','SPS021112','Female','3','D','Not Set','90785960',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27252,NULL,'Hamsa Mohamed Elsayed Ahmed Ayoub','SPS021113','users/default.png',NULL,'$2y$10$Wsl99hPL3RSo29yOGYoVNe1CpWjv3ZEHhd2ZAE1aA/tm8Bkbi20QG',NULL,'2025-11-24 20:25:51','2025-11-24 20:25:51',2,27033,'2025-11-24 16:25:51',NULL,1,'UAE','Sharjah','Egypt','British','SPS021113','Female','3','D','Not Set','90610564',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27253,NULL,'Islam Mahmoud Alsayed Abdelfattah Elkhabia','SPS021114','users/default.png',NULL,'$2y$10$Xq0tUm0XoUoaeQiEbp1PZez/E7Ch96wTraud8oRLE3jlFn2wLfeHy',NULL,'2025-11-24 20:25:51','2025-11-24 20:25:51',2,27033,'2025-11-24 16:25:51',NULL,1,'UAE','Sharjah','Egypt','British','SPS021114','Male','3','D','Not Set','92788309',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27254,NULL,'Karma Mahmoud Ramadan Mohamed Ashour Ismail Elhariri','SPS021115','users/default.png',NULL,'$2y$10$EdpG1UsKXvmGhCFINEyG2utdnT89.gdsnZOMM/M5yAD/oqi8uHvQW',NULL,'2025-11-24 20:25:51','2025-11-24 20:25:51',2,27033,'2025-11-24 16:25:51',NULL,1,'UAE','Sharjah','Egypt','British','SPS021115','Female','3','D','Not Set','95464065',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27255,NULL,'Khalid Hassan Mohamed Sulaiman','SPS021116','users/default.png',NULL,'$2y$10$XSQJ/ZNHb.MHR8h10oO1XOZFEOV2yGjBAZKNGbimERsROUuZIhWtu',NULL,'2025-11-24 20:25:52','2025-11-24 20:25:52',2,27033,'2025-11-24 16:25:52',NULL,1,'UAE','Sharjah','Sudan','British','SPS021116','Male','3','D','Not Set','95357417',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27256,NULL,'Mohamed Ashraf Hashim Fathi','SPS021117','users/default.png',NULL,'$2y$10$.sipJ/cYjlQ8ddgS.dVgT.1Bh7L6sMuPc/eEseND38vspqgDt.FWS',NULL,'2025-11-24 20:25:52','2025-11-24 20:25:52',2,27033,'2025-11-24 16:25:52',NULL,1,'UAE','Sharjah','Sudan','British','SPS021117','Male','3','D','Not Set','98407755',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27257,NULL,'Reval Adil Mohamed Nouri','SPS021118','users/default.png',NULL,'$2y$10$LKHR6WDymE6JB04eFcPEI.cL21.D525x3uA7M4TuEG.UANewt3nde',NULL,'2025-11-24 20:25:54','2025-11-24 20:25:54',2,27033,'2025-11-24 16:25:54',NULL,1,'UAE','Sharjah','Sudan','British','SPS021118','Female','3','D','Not Set','95012365',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27258,NULL,'Salah S S Albatta ','SPS021119','users/default.png',NULL,'$2y$10$BOPZzt7Mzrvy1inzPz7fxeS/ci88vEOAnUkrBelPrEXft8ESRm.b2',NULL,'2025-11-24 20:25:54','2025-11-24 20:25:54',2,27033,'2025-11-24 16:25:54',NULL,1,'UAE','Sharjah','Palestine','British','SPS021119','Male','3','D','Not Set','94782377',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27259,NULL,'Yamur Mohamed Abdellatif Mohamed Hassaneen','SPS021120','users/default.png',NULL,'$2y$10$.hhqUrOkc0NNLUys2BpAQORHymoazM64ylZSQrpUsMNwkOej.b3CW',NULL,'2025-11-24 20:25:56','2025-11-24 20:25:56',2,27033,'2025-11-24 16:25:56',NULL,1,'UAE','Sharjah','Egypt','British','SPS021120','Female','3','D','Not Set','98969667',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27260,NULL,'Yassin Ahmed Moawad Abdelmeguid Abouelenin','SPS021121','users/default.png',NULL,'$2y$10$ciUzwSuVRILLzIZUTeyjPut3leCJOoNFE9aQml.rBpQqbkF0mEYSm',NULL,'2025-11-24 20:25:56','2025-11-24 20:25:56',2,27033,'2025-11-24 16:25:56',NULL,1,'UAE','Sharjah','Egypt','British','SPS021121','Male','3','D','Not Set','96819625',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27261,NULL,'Seyed Zaid Seyed Moslem Hashemi Asl','SPS021122','users/default.png',NULL,'$2y$10$ZSQSIsCQKRFGheR8DeNgF.A3.h2q.wLhXMARh6Iojx4Zg57ObqhLK',NULL,'2025-11-24 20:25:56','2025-11-24 20:25:56',2,27033,'2025-11-24 16:25:56',NULL,1,'UAE','Sharjah','Iran','British','SPS021122','Male','3','D','Not Set','90526397',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27262,NULL,'Ahmed Hatem Abdelsalam Abdrabou Abdalla','SPS021123','users/default.png',NULL,'$2y$10$CEAo4kHZkSjlTRRbYkHZKOMsVA6NFZ56R5QWdEWVCrxLyR5TM5Mhm',NULL,'2025-11-24 20:25:56','2025-11-24 20:25:56',2,27033,'2025-11-24 16:25:56',NULL,1,'UAE','Sharjah','Egypt','British','SPS021123','Male','3','E','Not Set','90590015',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27263,NULL,'Ahmed Hosam Ahmed Abu Shareb','SPS021124','users/default.png',NULL,'$2y$10$J1zvxt4mB3hXIp6iq6sSF.Band5EgP/lQZf47UbUZK273uiOJiMNG',NULL,'2025-11-24 20:25:57','2025-11-24 20:25:57',2,27033,'2025-11-24 16:25:57',NULL,1,'UAE','Sharjah','Jordan','British','SPS021124','Male','3','E','Not Set','93580647',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27264,NULL,'Aseel Ali Saad Ahmed Ali Moustafa','SPS021125','users/default.png',NULL,'$2y$10$Z5rEzUGQiFU7X76ChWooc.8MeHsW22S24osqneVTAKHqI3EQ9O6UK',NULL,'2025-11-24 20:25:57','2025-11-24 20:25:57',2,27033,'2025-11-24 16:25:57',NULL,1,'UAE','Sharjah','Egypt','British','SPS021125','Female','3','E','Not Set','92898885',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27265,NULL,'Elin Ahmed Said Abdelsamee Omara','SPS021126','users/default.png',NULL,'$2y$10$goQ0gMOJHT5kOIUDnZnc1.cXa90UxX3FE440lgKXqU6g9VQUgzHfq',NULL,'2025-11-24 20:25:57','2025-11-24 20:25:57',2,27033,'2025-11-24 16:25:57',NULL,1,'UAE','Sharjah','Egypt','British','SPS021126','Female','3','E','Not Set','90278681',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27266,NULL,'Elyazeya Ahmed Samir Abdalmotaleb Ibrahim','SPS021127','users/default.png',NULL,'$2y$10$3G.k2.v2DIUPMCp4olc5.Oq1QK4HVNkMLNiqHhDXxDb4Uh40WOHr2',NULL,'2025-11-24 20:25:57','2025-11-24 20:25:57',2,27033,'2025-11-24 16:25:57',NULL,1,'UAE','Sharjah','Egyptian','British','SPS021127','Female','3','E','Not Set','92363630',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27267,NULL,'Khadiga Ahmed Mohamed Wafa Wafa','SPS021128','users/default.png',NULL,'$2y$10$l.wfHPEQ4lm9cPQLaPPIH.IrR7FBVHorRfCW0BmgIgRUbmkQzRTG.',NULL,'2025-11-24 20:25:58','2025-11-24 20:25:58',2,27033,'2025-11-24 16:25:58',NULL,1,'UAE','Sharjah','Egyptian','British','SPS021128','Female','3','E','Not Set','92096456',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27268,NULL,'Nadeen Ahmed Mohamed Osman Babikir','SPS021129','users/default.png',NULL,'$2y$10$uw1ZEOkf.uhu4Pb08uS1kuiPIkrQOKdu4/QunMdQE42i9bMxtHZeC',NULL,'2025-11-24 20:25:58','2025-11-24 20:25:58',2,27033,'2025-11-24 16:25:58',NULL,1,'UAE','Sharjah','Sudan','British','SPS021129','Female','3','E','Not Set','99342737',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27269,NULL,'Raghad Mosadeg Abdelrazeeg Osman','SPS021130','users/default.png',NULL,'$2y$10$wv9cjpbjKuH9lLpAFGxJzeC89Se7ckDfZKly6kMUNybr.h4FGK48i',NULL,'2025-11-24 20:25:58','2025-11-24 20:25:58',2,27033,'2025-11-24 16:25:58',NULL,1,'UAE','Sharjah','Sudan','British','SPS021130','Female','3','E','Not Set','95374615',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27270,NULL,'Rukeya Muktar Hasan','SPS021131','users/default.png',NULL,'$2y$10$HZBSzfVV0k0XY0cR1tQgoOicjCbTjwzR7zNknlqIHZJL0RuEQn5.C',NULL,'2025-11-24 20:25:59','2025-11-24 20:25:59',2,27033,'2025-11-24 16:25:59',NULL,1,'UAE','Sharjah','Ethopian','British','SPS021131','Female','3','E','Not Set','90692132',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27271,NULL,'Ryan Elhassanein','SPS021132','users/default.png',NULL,'$2y$10$v418q2iykAmSmX9JHAlehuhJbVwVy58hidDH41DgWjjrZacEQnJKS',NULL,'2025-11-24 20:25:59','2025-11-24 20:25:59',2,27033,'2025-11-24 16:25:59',NULL,1,'UAE','Sharjah','Tunisia','British','SPS021132','Male','3','E','Not Set','92674041',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27272,NULL,'Youssef Reda Mohamed Aboulkheir','SPS021133','users/default.png',NULL,'$2y$10$wqgW9RWGQKheY5wGNDrU0OSB8fo4fGaa03Bp/ojFX0AV/MMVmghMC',NULL,'2025-11-24 20:25:59','2025-11-24 20:25:59',2,27033,'2025-11-24 16:25:59',NULL,1,'UAE','Sharjah','USA','British','SPS021133','Male','3','E','Not Set','96257284',1,-1,'SPS');
INSERT IGNORE INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`, `school_id`, `last_login`, `last_login_ip`, `is_arab`, `country`, `city`, `nationality`, `curriculumn`, `std_id`, `gender`, `grade`, `section`, `level`, `gen_password`, `country_id`, `is_sen`, `school_code`) VALUES (27273,NULL,'Zahara Ahmed Abbakar Eisa','SPS021134','users/default.png',NULL,'$2y$10$hYSCBzx52vKdB150QYia.uGw51ooW5swMh.TjkfLBoHvale14j.NS',NULL,'2025-11-24 20:25:59','2025-11-24 20:25:59',2,27033,'2025-11-24 16:25:59',NULL,1,'UAE','Sharjah','Sudan','British','SPS021134','Female','3','E','Not Set','95510110',1,-1,'SPS');

-- Recreate the school registration row.
INSERT INTO `school_registerations` (`id`, `exam_id`, `school_id`, `current_start_date`, `current_end_date`, `status`, `created_at`, `updated_at`, `current_session`) VALUES (442,101,27033,'2026-01-06 08:26:00','2026-02-22 20:26:00',1,'2025-11-24 20:26:00','2026-01-27 07:35:48',1);

-- Recreate the original 63 round-1 registrations.
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36354,27211,101,'2025-11-24 20:25:42','2026-01-06 14:02:03',0,80,NULL,1,100,27033,1,'883293457',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36355,27212,101,'2025-11-24 20:25:42','2026-01-06 13:29:47',0,84,NULL,1,100,27033,1,'128080793',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36356,27213,101,'2025-11-24 20:25:43','2026-01-06 13:28:00',0,84,NULL,1,100,27033,1,'964643400',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36357,27214,101,'2025-11-24 20:25:43','2025-11-24 20:25:43',0,-1,NULL,-1,0,27033,1,'536050476',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36358,27215,101,'2025-11-24 20:25:43','2026-01-06 13:24:12',0,80,NULL,1,100,27033,1,'697776567',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36359,27216,101,'2025-11-24 20:25:43','2026-01-06 13:53:36',0,74,NULL,1,100,27033,1,'696491688',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36360,27217,101,'2025-11-24 20:25:43','2026-01-06 12:53:29',0,78,NULL,1,100,27033,1,'363619844',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36361,27218,101,'2025-11-24 20:25:43','2026-01-06 14:08:08',0,78,NULL,1,100,27033,1,'923295976',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36362,27219,101,'2025-11-24 20:25:44','2026-01-06 13:32:44',0,72,NULL,1,100,27033,1,'957563114',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36363,27220,101,'2025-11-24 20:25:44','2026-01-06 13:34:04',0,84,NULL,1,100,27033,1,'196443980',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36364,27221,101,'2025-11-24 20:25:44','2026-01-06 13:48:02',0,70,NULL,1,100,27033,1,'415100438',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36365,27222,101,'2025-11-24 20:25:44','2026-01-06 14:12:24',0,68,NULL,1,100,27033,1,'953980223',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36366,27223,101,'2025-11-24 20:25:44','2026-02-16 13:47:31',0,78,NULL,1,100,27033,1,'715666750',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36367,27224,101,'2025-11-24 20:25:44','2026-01-06 11:40:29',0,80,NULL,1,100,27033,1,'516703565',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36368,27225,101,'2025-11-24 20:25:44','2026-01-06 12:12:24',0,72,NULL,1,100,27033,1,'293450797',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36369,27226,101,'2025-11-24 20:25:44','2026-01-06 12:06:32',0,60,NULL,1,100,27033,1,'206271589',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36370,27227,101,'2025-11-24 20:25:45','2026-01-06 11:28:08',0,78,NULL,1,100,27033,1,'770144064',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36371,27228,101,'2025-11-24 20:25:45','2026-01-06 11:51:33',0,80,NULL,1,100,27033,1,'759701885',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36372,27229,101,'2025-11-24 20:25:45','2026-01-06 10:32:15',0,44,NULL,-1,100,27033,1,'599092366',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36373,27230,101,'2025-11-24 20:25:45','2026-01-06 10:52:00',0,66,NULL,1,100,27033,1,'172016929',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36374,27231,101,'2025-11-24 20:25:45','2026-01-06 11:31:29',0,70,NULL,1,100,27033,1,'566662556',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36375,27232,101,'2025-11-24 20:25:45','2026-01-06 14:05:19',0,46,NULL,1,100,27033,1,'178850577',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36376,27233,101,'2025-11-24 20:25:45','2026-01-06 12:08:00',0,78,NULL,1,100,27033,1,'552246141',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36377,27234,101,'2025-11-24 20:25:46','2026-01-06 11:37:21',0,72,NULL,1,100,27033,1,'819309874',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36378,27235,101,'2025-11-24 20:25:46','2026-01-06 11:25:11',0,78,NULL,1,100,27033,1,'435156872',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36379,27236,101,'2025-11-24 20:25:47','2026-01-06 11:16:17',0,72,NULL,1,100,27033,1,'713211931',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36380,27237,101,'2025-11-24 20:25:47','2026-01-06 11:04:46',0,72,NULL,1,100,27033,1,'61792490',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36381,27238,101,'2025-11-24 20:25:47','2026-01-06 11:42:52',0,80,NULL,1,100,27033,1,'308183448',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36382,27239,101,'2025-11-24 20:25:47','2026-01-06 10:28:58',0,84,NULL,1,100,27033,1,'149786352',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36383,27240,101,'2025-11-24 20:25:47','2026-01-06 10:41:42',0,80,NULL,1,100,27033,1,'824170660',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36384,27241,101,'2025-11-24 20:25:47','2026-01-06 11:45:37',0,74,NULL,1,100,27033,1,'542684382',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36385,27242,101,'2025-11-24 20:25:47','2026-01-06 11:21:15',0,82,NULL,1,100,27033,1,'791758037',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36386,27243,101,'2025-11-24 20:25:48','2026-01-07 10:05:53',0,70,NULL,1,100,27033,1,'46740237',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36387,27244,101,'2025-11-24 20:25:48','2026-01-07 10:21:27',0,66,NULL,1,100,27033,1,'876123297',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36388,27245,101,'2025-11-24 20:25:48','2025-11-24 20:25:48',0,-1,NULL,-1,0,27033,1,'707229116',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36389,27246,101,'2025-11-24 20:25:48','2026-01-07 10:16:02',0,56,NULL,1,100,27033,1,'942176553',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36390,27247,101,'2025-11-24 20:25:48','2026-01-07 10:13:23',0,64,NULL,1,100,27033,1,'169138760',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36391,27248,101,'2025-11-24 20:25:48','2025-11-24 20:25:48',0,-1,NULL,-1,0,27033,1,'156410026',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36392,27249,101,'2025-11-24 20:25:49','2026-01-07 09:58:26',0,76,NULL,1,100,27033,1,'124095020',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36393,27250,101,'2025-11-24 20:25:51','2026-01-07 10:50:33',0,50,NULL,1,100,27033,1,'615647183',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36394,27251,101,'2025-11-24 20:25:51','2026-01-07 12:04:20',0,80,NULL,1,100,27033,1,'44463815',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36395,27252,101,'2025-11-24 20:25:51','2026-01-07 12:07:49',0,78,NULL,1,100,27033,1,'128670852',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36396,27253,101,'2025-11-24 20:25:51','2026-01-07 11:37:34',0,80,NULL,1,100,27033,1,'418710998',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36397,27254,101,'2025-11-24 20:25:52','2026-01-07 12:11:48',0,68,NULL,1,100,27033,1,'275895774',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36398,27255,101,'2025-11-24 20:25:52','2026-01-07 11:33:16',0,74,NULL,1,100,27033,1,'415328980',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36399,27256,101,'2025-11-24 20:25:52','2026-01-07 11:57:12',0,66,NULL,1,100,27033,1,'640413985',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36400,27257,101,'2025-11-24 20:25:54','2026-01-07 12:02:16',0,76,NULL,1,100,27033,1,'228381348',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36401,27258,101,'2025-11-24 20:25:55','2026-01-07 11:25:05',0,80,NULL,1,100,27033,1,'281422518',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36402,27259,101,'2025-11-24 20:25:56','2026-01-07 11:59:31',0,76,NULL,1,100,27033,1,'461964891',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36403,27260,101,'2025-11-24 20:25:56','2026-01-07 11:51:45',0,80,NULL,1,100,27033,1,'267987680',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36404,27261,101,'2025-11-24 20:25:56','2026-01-07 11:45:37',0,84,NULL,1,100,27033,1,'138936540',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36405,27262,101,'2025-11-24 20:25:56','2026-01-07 10:37:25',0,82,NULL,1,100,27033,1,'62846718',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36406,27263,101,'2025-11-24 20:25:57','2026-01-07 10:25:09',0,58,NULL,1,100,27033,1,'787136433',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36407,27264,101,'2025-11-24 20:25:57','2026-01-07 09:24:25',0,80,NULL,1,100,27033,1,'840995806',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36408,27265,101,'2025-11-24 20:25:57','2026-01-07 09:54:43',0,74,NULL,1,100,27033,1,'146483331',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36409,27266,101,'2025-11-24 20:25:57','2026-01-07 09:31:17',0,74,NULL,1,100,27033,1,'872753330',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36410,27267,101,'2025-11-24 20:25:58','2026-01-07 09:34:54',0,80,NULL,1,100,27033,1,'962757250',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36411,27268,101,'2025-11-24 20:25:58','2026-01-07 10:30:30',0,82,NULL,1,100,27033,1,'269492297',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36412,27269,101,'2025-11-24 20:25:58','2026-01-07 10:11:53',0,82,NULL,1,100,27033,1,'162188623',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36413,27270,101,'2025-11-24 20:25:59','2026-01-07 10:17:13',0,42,NULL,1,100,27033,1,'471911386',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36414,27271,101,'2025-11-24 20:25:59','2026-01-07 10:10:34',0,76,NULL,1,100,27033,1,'343589436',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36415,27272,101,'2025-11-24 20:25:59','2026-01-07 09:48:43',0,56,NULL,1,100,27033,1,'231111110',1,1,11);
INSERT INTO `student_registrations` (`id`, `user_id`, `exam_id`, `created_at`, `updated_at`, `status`, `final_score`, `evaluated_at`, `is_submitted`, `exam_score`, `school_id`, `country_id`, `otp`, `session_no`, `subject_id`, `grade_level`) VALUES (36416,27273,101,'2025-11-24 20:25:59','2026-01-07 10:03:49',0,80,NULL,1,100,27033,1,'98427913',1,1,11);

COMMIT;

-- Optional verification queries:
-- SELECT id, exam_id, school_id, current_session FROM school_registerations WHERE exam_id = 101 AND school_id = 27033;
-- SELECT session_no, COUNT(*) AS total_regs, SUM(CASE WHEN is_submitted = 1 THEN 1 ELSE 0 END) AS submitted_regs
-- FROM student_registrations
-- WHERE exam_id = 101 AND school_id = 27033
-- GROUP BY session_no
-- ORDER BY session_no;
