-- ==========================================================
-- Beklir.uz — McHost phpMyAdmin Ma'lumotlar Bazasiga Import
-- Baza nomi: a374822_bek
-- Jadval: users
-- Sana: 2026-09-26T04:32:55.494Z
-- Jami o'quvchilar soni: 46 ta
-- ==========================================================

SET NAMES utf8mb4;
SET time_zone = '+05:00';

-- 1. users jadvali mavjud bo'lmasa yaratish
CREATE TABLE IF NOT EXISTS `users` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `uid` VARCHAR(128) NOT NULL UNIQUE,
  `login` VARCHAR(128) NOT NULL DEFAULT '',
  `email` VARCHAR(255) NOT NULL,
  `display_name` VARCHAR(255) NOT NULL DEFAULT 'Bilimdon o\'quvchi',
  `photo_url` TEXT NULL,
  `grade` VARCHAR(32) DEFAULT '6',
  `region` VARCHAR(128) DEFAULT 'Toshkent shahri',
  `xp` INT NOT NULL DEFAULT 0,
  `coins` INT NOT NULL DEFAULT 0,
  `stats` LONGTEXT NULL,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `last_login_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX `idx_users_xp` (`xp` DESC),
  INDEX `idx_users_login` (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 2. scores jadvali mavjud bo'lmasa yaratish
CREATE TABLE IF NOT EXISTS `scores` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `user_id` VARCHAR(128) NOT NULL,
  `user_name` VARCHAR(255) NOT NULL,
  `category` VARCHAR(64) NOT NULL,
  `game_mode` VARCHAR(64) NOT NULL,
  `score` INT NOT NULL DEFAULT 0,
  `xp_earned` INT NOT NULL DEFAULT 0,
  `coins_earned` INT NOT NULL DEFAULT 0,
  `correct_count` INT NOT NULL DEFAULT 0,
  `total_questions` INT NOT NULL DEFAULT 0,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  INDEX `idx_scores_user` (`user_id`),
  INDEX `idx_scores_created` (`created_at` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 3. Barcha 46 ta foydalanuvchilarni users jadvaliga yozish
INSERT INTO `users` (`uid`, `login`, `email`, `display_name`, `photo_url`, `grade`, `region`, `xp`, `coins`, `stats`, `created_at`)
VALUES
  ('user_mohi_2015', 'MOHI_2015', 'mohinur@gmail.com', 'Mohinur Samatova', '👩‍🎓', '5', 'Navoiy viloyati', 3245, 1508, '{"email":"mohinur@gmail.com","grade":5,"login":"MOHI_2015","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Navoiy shahri","lastName":"Samatova","password":"1111","quizWins":0,"firstName":"Mohinur","bestStreak":10,"gamesPlayed":6,"zakovatWins":0,"totalCorrect":50}', NOW()),
  ('user_azizbek', 'Azizbek', 'azizbek@emayil.com', 'Azizbek Azimov', '🧑‍🎓', '5', 'Navoiy viloyati', 1918, 934, '{"email":"azizbek@emayil.com","grade":5,"login":"Azizbek","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"Azimov","password":"7777","quizWins":0,"firstName":"Azizbek","bestStreak":0,"gamesPlayed":2,"zakovatWins":0,"totalCorrect":110}', NOW()),
  ('user_rayhona_2015', 'Rayhona_2015', 'rayhona@gmail.kom', 'Rayhona Rabbimova', '👩‍🎓', '5', 'Navoiy viloyati', 1521, 734, '{"email":"rayhona@gmail.kom","grade":5,"login":"Rayhona_2015","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"Rabbimova","password":"5a5a","quizWins":0,"firstName":"Rayhona","bestStreak":10,"gamesPlayed":9,"zakovatWins":0,"totalCorrect":64}', NOW()),
  ('user_suxrobjoneshmamatov15', 'Suxrobjon Eshmamatov@15', 'suxrobjon@gmail.com', 'Suxrobjon Eshmamatov', '🧑‍🎓', '5', 'Toshkent shahri', 922, 442, '{"email":"suxrobjon@gmail.com","grade":5,"login":"Suxrobjon Eshmamatov@15","avatar":"🧑‍🎓","region":"Toshkent shahri","school":"54-maktab","district":"Olmazor tumani","lastName":"Eshmamatov","password":"2015","quizWins":0,"firstName":"Suxrobjon","bestStreak":10,"gamesPlayed":6,"zakovatWins":4,"totalCorrect":22}', NOW()),
  ('user_normuhammad', 'normuhammad', 'normuhamad@gmail.com', 'normuhammad shirinboyev', '🧑‍🎓', '5', 'Navoiy viloyati', 795, 380, '{"email":"normuhamad@gmail.com","grade":5,"login":"normuhammad","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"shirinboyev","password":"2015","quizWins":0,"firstName":"normuhammad","bestStreak":0,"gamesPlayed":2,"zakovatWins":0,"totalCorrect":18}', NOW()),
  ('user_ggg', 'ggg', 'ggg@gmail.com', 'alibek gggg', '🧑‍🎓', '6', 'Toshkent shahri', 651, 430, '{"login":"ggg","school":"1-maktab","district":"Yunusobod tumani","lastName":"gggg","password":"gggg","firstName":"alibek","bestStreak":9,"gamesPlayed":2,"zakovatWins":0,"totalCorrect":15}', NOW()),
  ('user_beklir_1188', 'beklir_1188', 'www.beklir.uz@gmail.com', 'Nurbek Toshmamatov', '👨‍🏫', '11', 'Navoiy viloyati', 628, 485, '{"login":"beklir_1188","school":"1-maktab","district":"Yunusobod tumani","lastName":"Toshmamatov","password":"1234","firstName":"Nurbek","bestStreak":0,"gamesPlayed":0,"zakovatWins":0,"totalCorrect":42}', NOW()),
  ('user_sanjar', 'sanjar', 'sanjar@gmail.com', 'sanjar bobobekov', '🧑‍🎓', '5', 'Navoiy viloyati', 597, 274, '{"email":"sanjar@gmail.com","grade":5,"login":"sanjar","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"bobobekov","password":"2015","quizWins":0,"firstName":"sanjar","bestStreak":3,"gamesPlayed":14,"zakovatWins":10,"totalCorrect":22}', NOW()),
  ('user_abdulla', 'abdulla', 'abdulla@gmail.com', 'abdulla toshev', '🧑‍🎓', '6', 'Toshkent shahri', 434, 390, '{"email":"abdulla@gmail.com","grade":6,"login":"abdulla","avatar":"🧑‍🎓","region":"Toshkent shahri","school":"1-maktab","district":"Yunusobod tumani","lastName":"toshev","password":"1234","quizWins":0,"firstName":"abdulla","bestStreak":9,"gamesPlayed":1,"zakovatWins":0}', NOW()),
  ('user_malika2015', 'malika2015', 'malika@gimal.com', 'Malika Berdiyorova', '👩‍🎓', '5', 'Navoiy viloyati', 414, 106, '{"email":"malika@gimal.com","grade":5,"login":"malika2015","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"Berdiyorova","password":"7682","quizWins":0,"firstName":"Malika","bestStreak":0,"gamesPlayed":7,"zakovatWins":4,"totalCorrect":15}', NOW()),
  ('user_aziza', 'AZIZA', 'aziza@gimail.com', 'AZIZA OBLABERDIYVA', '👩‍🎓', '5', 'Navoiy viloyati', 266, 134, '{"email":"aziza@gimail.com","grade":5,"login":"AZIZA","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"OBLABERDIYVA","password":"2015","quizWins":0,"firstName":"AZIZA","bestStreak":10,"gamesPlayed":9,"zakovatWins":1,"totalCorrect":18}', NOW()),
  ('user_lola', 'lola@', 'lola@gimail.com', 'Lola Mardonova', '👩‍🎓', '5', 'Navoiy viloyati', 188, 80, '{"email":"lola@gimail.com","grade":5,"login":"lola@","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"Mardonova","password":"8258","quizWins":0,"firstName":"Lola","bestStreak":0,"gamesPlayed":3,"zakovatWins":19,"totalCorrect":12}', NOW()),
  ('user_sanco', 'sanco', 'sanjarbekakkaunt2@gmail.com', 'Sanjar Meyliqulov', '🧑‍🎓', '6', 'Navoiy viloyati', 135, 80, '{"email":"sanjarbekakkaunt2@gmail.com","grade":6,"login":"sanco","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"92-maktab","district":"Xatirchi tumani","lastName":"Meyliqulov","password":"ssaa","quizWins":0,"firstName":"Sanjar","bestStreak":3,"gamesPlayed":2,"zakovatWins":0,"totalCorrect":12}', NOW()),
  ('test_user_1', 'test_user_1', 'test_user_1@beklir.uz', 'Azizbek Karimov', '🧑‍🎓', '6', 'Toshkent sh.', 0, 0, '{"xp":0,"coins":0,"quizWins":0,"bestStreak":0,"gamesPlayed":0,"zakovatWins":0,"totalCorrect":0}', NOW()),
  ('user_sardor77', 'sardor77', 'sardor@gmail.com', 'Sardor Rashidov', '🧑‍🎓', '8', 'Samarqand viloyati', 0, 0, '{"xp":0,"coins":0,"email":"sardor@gmail.com","grade":8,"login":"sardor77","avatar":"🧑‍🎓","region":"Samarqand viloyati","school":"25-maktab","district":"Samarqand shahri","lastName":"Rashidov","password":"newpassword999","quizWins":0,"firstName":"Sardor","bestStreak":0,"gamesPlayed":0,"zakovatWins":0,"totalCorrect":0}', NOW()),
  ('user_jasur_2026', 'jasur_2026', 'jasur@example.com', 'Jasur Aliyev', '🧑‍🎓', '7', 'Samarqand viloyati', 0, 0, '{"xp":0,"coins":0,"email":"jasur@example.com","grade":7,"login":"jasur_2026","avatar":"🧑‍🎓","region":"Samarqand viloyati","school":"10-maktab","district":"Samarqand shahri","lastName":"Aliyev","password":"password123","quizWins":0,"firstName":"Jasur","bestStreak":0,"gamesPlayed":0,"zakovatWins":0,"totalCorrect":0}', NOW()),
  ('user_madinaxon_9', 'madinaxon_9', 'madina@bilimdon.uz', 'Madina Xolmirzayeva', '🧑‍🎓', '9', 'Andijon viloyati', 0, 0, '{"xp":0,"coins":0,"email":"madina@bilimdon.uz","grade":9,"login":"madinaxon_9","avatar":"🧑‍🎓","region":"Andijon viloyati","school":"14-maktab","district":"Andijon shahri","lastName":"Xolmirzayeva","password":"madina_pass_123","quizWins":0,"firstName":"Madina","bestStreak":0,"gamesPlayed":0,"zakovatWins":0,"totalCorrect":0}', NOW()),
  ('user_otabek_2026', 'otabek_2026', 'otabek_2026@beklir.uz', 'Otabek Yuldashev', '🧑‍🎓', '8', 'Buxoro viloyati', 0, 0, '{"xp":0,"coins":0,"email":"","grade":8,"login":"otabek_2026","avatar":"🧑‍🎓","region":"Buxoro viloyati","school":"4-maktab","district":"Gijduvon tumani","lastName":"Yuldashev","password":"password123","quizWins":0,"firstName":"Otabek","bestStreak":0,"gamesPlayed":0,"zakovatWins":0,"totalCorrect":0}', NOW()),
  ('user_ulugbek102020', 'ulugbek102020', 'ulugbek102020@gmail.com', 'Ulugbek Normatov', '🧑‍🎓', '7', 'Toshkent shahri', 0, 0, '{"xp":0,"coins":0,"email":"ulugbek102020@gmail.com","grade":7,"login":"ulugbek102020","avatar":"🧑‍🎓","region":"Toshkent shahri","school":"5-maktab","district":"Chilonzor tumani","lastName":"Normatov","password":"password123","quizWins":0,"firstName":"Ulugbek","bestStreak":0,"gamesPlayed":0,"zakovatWins":0,"totalCorrect":0}', NOW()),
  ('user_dilnoza_2026', 'dilnoza_2026', 'dilnoza@bilimdon.uz', 'Dilnoza Saidova', '👩‍🎓', '8', 'Fargona viloyati', 0, 0, '{"xp":0,"coins":0,"email":"dilnoza@bilimdon.uz","grade":8,"login":"dilnoza_2026","avatar":"👩‍🎓","region":"Fargona viloyati","school":"12-maktab","district":"Qoqon shahri","lastName":"Saidova","password":"pass1234","quizWins":0,"firstName":"Dilnoza","bestStreak":0,"gamesPlayed":0,"zakovatWins":0,"totalCorrect":0}', NOW()),
  ('user_gulmira', 'Gulmira', 'gulmira@gimail.com', 'Gulmira@@ Berdeyva', '👩‍🎓', '6', 'Toshkent shahri', 0, 0, '{"email":"gulmira@gimail.com","grade":6,"login":"Gulmira","avatar":"👩‍🎓","region":"Toshkent shahri","school":"1-maktab","district":"Yunusobod tumani","lastName":"Berdeyva","password":"222222","quizWins":0,"firstName":"Gulmira@@","bestStreak":0,"gamesPlayed":0,"zakovatWins":0,"totalCorrect":0}', NOW()),
  ('user_kamola_2015', 'kamola_2015', 'kamola@gmail.com', 'kamola nurmamatova', '👩‍🎓', '5', 'Navoiy viloyati', 0, 0, '{"email":"kamola@gmail.com","grade":5,"login":"kamola_2015","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"nurmamatova","password":"4444","quizWins":0,"firstName":"kamola","bestStreak":0,"gamesPlayed":1,"zakovatWins":4,"totalCorrect":2}', NOW()),
  ('user_sabina', 'Sabina', 'sabina@gimail.com', 'Sabina boboqulova', '👩‍🎓', '5', 'Navoiy viloyati', 0, 0, '{"email":"sabina@gimail.com","grade":5,"login":"Sabina","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"boboqulova","password":"7654321","quizWins":0,"firstName":"Sabina","bestStreak":0,"gamesPlayed":1,"zakovatWins":0,"totalCorrect":1}', NOW()),
  ('user_hayot', 'hayot', 'hayot@gmail.com', 'hayot haydarov', '🧑‍🎓', '5', 'Navoiy viloyati', 0, 0, '{"email":"hayot@gmail.com","grade":5,"login":"hayot","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"haydarov","password":"2015","quizWins":0,"firstName":"hayot","bestStreak":0,"gamesPlayed":2,"zakovatWins":20,"totalCorrect":8}', NOW()),
  ('user_dilmurod', 'DILMUROD', 'dilmurod@gmail.com', 'DILMUROD IBRAGIMOV', '🧑‍🎓', '5', 'Navoiy viloyati', 0, 0, '{"email":"dilmurod@gmail.com","grade":5,"login":"DILMUROD","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"IBRAGIMOV","password":"2015","quizWins":0,"firstName":"DILMUROD","bestStreak":0,"gamesPlayed":4,"zakovatWins":0,"totalCorrect":39}', NOW()),
  ('user_ravshan', 'ravshan', 'ravshan@gmail.com', 'Ravshan Shermamatov', '🧑‍🎓', '5', 'Navoiy viloyati', 0, 0, '{"email":"ravshan@gmail.com","grade":5,"login":"ravshan","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Navoiy shahri","lastName":"Shermamatov","password":"2015","quizWins":0,"firstName":"Ravshan","bestStreak":9,"gamesPlayed":2,"zakovatWins":0,"totalCorrect":15}', NOW()),
  ('user_2015', '2015', 'alibek@gamail.com', 'Sohibabonu Pormonova', '👩‍🎓', '5', 'Navoiy viloyati', 0, 0, '{"email":"alibek@gamail.com","grade":5,"login":"2015","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"Pormonova","password":"4321","quizWins":0,"firstName":"Sohibabonu","bestStreak":0,"gamesPlayed":2,"zakovatWins":0,"totalCorrect":19}', NOW()),
  ('user_maftuna_011', 'Maftuna_011', 'maftunamardonova@gmail.com', 'Maftuna Mardonova', '👩‍🎓', '9', 'Navoiy viloyati', 0, 0, '{"email":"maftunamardonova@gmail.com","grade":9,"login":"Maftuna_011","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"Mardonova","password":"110111","quizWins":0,"firstName":"Maftuna","bestStreak":7,"gamesPlayed":12,"zakovatWins":7,"totalCorrect":502}', NOW()),
  ('user_abdumalikov10', 'Abdumalikov...10', 'abdumalikovozodbek10@gmail.com', 'Ozodbek abdumalikov', '🧑‍🎓', '10', 'Navoiy viloyati', 0, 0, '{"email":"abdumalikovozodbek10@gmail.com","grade":10,"login":"Abdumalikov...10","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"abdumalikov","password":"20102013","quizWins":0,"firstName":"Ozodbek","bestStreak":0,"gamesPlayed":9,"zakovatWins":63,"totalCorrect":53}', NOW()),
  ('user_m1rtazayev_07', 'm1rtazayev_07', 'cokacol@gmail.com', 'Kamronbek Murtazayev', '🧑‍🎓', '10', 'Navoiy viloyati', 0, 0, '{"email":"cokacol@gmail.com","grade":10,"login":"m1rtazayev_07","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"Murtazayev","password":"122226","quizWins":0,"firstName":"Kamronbek","bestStreak":2,"gamesPlayed":12,"zakovatWins":50,"totalCorrect":54}', NOW()),
  ('user_lolabek', 'lola.bek.', 'ziyodullayevalola@gmail.com', 'lola ziyodullayeva', '👩‍🎓', '10', 'Navoiy viloyati', 0, 0, '{"email":"ziyodullayevalola@gmail.com","grade":10,"login":"lola.bek.","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"ziyodullayeva","password":"1234","quizWins":0,"firstName":"lola","bestStreak":10,"gamesPlayed":4,"zakovatWins":6,"totalCorrect":33}', NOW()),
  ('user_faran_giz2912', 'faran_giz29.12', 'farangizcho\'liboyeva@gmail.com', 'Farangiz CHo\'liboyeva', '👩‍🎓', '10', 'Navoiy viloyati', 0, 0, '{"email":"farangizcho\'liboyeva@gmail.com","grade":10,"login":"faran_giz29.12","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"CHo\'liboyeva","password":"29.12","quizWins":0,"firstName":"Farangiz","bestStreak":10,"gamesPlayed":4,"zakovatWins":3,"totalCorrect":29}', NOW()),
  ('user_shaxruz2012', 'shaxruz 2012', 'abdurazzaqov.@gmail.com', 'Shoxruz Abdurazzaqov', '🧑‍🎓', '8', 'Navoiy viloyati', 0, 0, '{"email":"abdurazzaqov.@gmail.com","grade":8,"login":"shaxruz 2012","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"Abdurazzaqov","password":"2222","quizWins":0,"firstName":"Shoxruz","bestStreak":3,"gamesPlayed":6,"zakovatWins":38,"totalCorrect":46}', NOW()),
  ('user_umidjon_12', 'umidjon_12', 'alisherovumidjon@gmail.com', 'Umidjon Alisherov', '🧑‍🎓', '8', 'Navoiy viloyati', 0, 0, '{"email":"alisherovumidjon@gmail.com","grade":8,"login":"umidjon_12","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"Alisherov","password":"2012","quizWins":0,"firstName":"Umidjon","bestStreak":10,"gamesPlayed":15,"zakovatWins":6,"totalCorrect":140}', NOW()),
  ('user_umidjon2012', 'umidjon2012', 'umidjonasadov802@gmail.com', 'umidjon asadov', '🧑‍🎓', '8', 'Navoiy viloyati', 0, 0, '{"email":"umidjonasadov802@gmail.com","grade":8,"login":"umidjon2012","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"asadov","password":"umidjon2012","quizWins":0,"firstName":"umidjon","bestStreak":0,"gamesPlayed":35,"zakovatWins":160,"totalCorrect":278}', NOW()),
  ('user_2012', '2012', 'pokiza@gemail.com', 'pokiza Baxriddinova', '👩‍🎓', '8', 'Navoiy viloyati', 0, 0, '{"email":"pokiza@gemail.com","grade":8,"login":"2012","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Navoiy shahri","lastName":"Baxriddinova","password":"pokiaq031","quizWins":0,"firstName":"pokiza","bestStreak":10,"gamesPlayed":1,"zakovatWins":0,"totalCorrect":12}', NOW()),
  ('user_javohir', 'JAVOHIR', 'jnuemamatov@gmali.com', 'JAVOHIR NURMAMATOV', '🧑‍🎓', '8', 'Navoiy viloyati', 0, 0, '{"email":"jnuemamatov@gmali.com","grade":8,"login":"JAVOHIR","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"NURMAMATOV","password":"1353","quizWins":0,"firstName":"JAVOHIR","bestStreak":5,"gamesPlayed":9,"zakovatWins":0,"totalCorrect":10}', NOW()),
  ('user_temur_12', 'temur_12', 'shermamatovtemur@gmail.com', 'Temur Shermamatov', '🧑‍🎓', '8', 'Navoiy viloyati', 0, 0, '{"email":"shermamatovtemur@gmail.com","grade":8,"login":"temur_12","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"Shermamatov","password":"1111","quizWins":0,"firstName":"Temur","bestStreak":10,"gamesPlayed":17,"zakovatWins":66,"totalCorrect":125}', NOW()),
  ('user_islombek_12', 'islombek_12', 'karimovislombekcom.@gmail', 'Islombek Karimov', '🧑‍🎓', '8', 'Navoiy viloyati', 0, 0, '{"email":"karimovislombekcom.@gmail","grade":8,"login":"islombek_12","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"Karimov","password":"2012","quizWins":0,"firstName":"Islombek","bestStreak":10,"gamesPlayed":17,"zakovatWins":66,"totalCorrect":124}', NOW()),
  ('user_ab206254', 'ab206254', 'shabbonabozorboyeva2@gmail.com', 'shabbona bozorboyeva', '👩‍🎓', '8', 'Navoiy viloyati', 0, 0, '{"email":"shabbonabozorboyeva2@gmail.com","grade":8,"login":"ab206254","avatar":"👩‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Navoiy shahri","lastName":"bozorboyeva","password":"abcd","quizWins":0,"firstName":"shabbona","bestStreak":10,"gamesPlayed":3,"zakovatWins":1,"totalCorrect":20}', NOW()),
  ('user_ali2012', 'ali.2012', 'alisher.@gmail.com', 'alisher ruziqulov', '🧑‍🎓', '8', 'Navoiy viloyati', 0, 0, '{"email":"alisher.@gmail.com","grade":8,"login":"ali.2012","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"ruziqulov","password":"20121016","quizWins":0,"firstName":"alisher","bestStreak":0,"gamesPlayed":41,"zakovatWins":100,"totalCorrect":228}', NOW()),
  ('user_davron2014', 'umidjon_2012', 'misol@gmail.com', 'sherjahon G\'ofurov', '🧑‍🎓', '8', 'Navoiy viloyati', 0, 0, '{"email":"misol@gmail.com","grade":8,"login":"umidjon_2012","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"Mustafoyev","password":"1234","quizWins":0,"firstName":"Umidjon","bestStreak":0,"gamesPlayed":0,"zakovatWins":1,"totalCorrect":1}', NOW()),
  ('user_telmonovzafar2012', 'telmonovzafar2012', 'telmonovzafar_2012@gmail.com', 'zafar telmonov', '🧑‍🎓', '8', 'Navoiy viloyati', 0, 0, '{"email":"telmonovzafar_2012@gmail.com","grade":8,"login":"telmonovzafar2012","avatar":"🧑‍🎓","region":"Navoiy viloyati","school":"54-maktab","district":"Xatirchi tumani","lastName":"telmonov","password":"zxcvbnm","quizWins":0,"firstName":"zafar","bestStreak":10,"gamesPlayed":20,"zakovatWins":50,"totalCorrect":171}', NOW()),
  ('user_yodgor11', 'yodgor.11', 'yodgorbekboxodirovcom.@gmail', 'Yodgor Boxodirov', '🧑‍🎓', '9', 'Navoiy viloyati', 0, 0, '{"login":"yodgor.11","school":"54-maktab","district":"Xatirchi tumani","lastName":"Boxodirov","password":"20112011","firstName":"Yodgor","bestStreak":10,"gamesPlayed":33,"zakovatWins":0,"totalCorrect":69}', NOW()),
  ('user_ochilgmailcom', 'ochil@gmail.com', 'ochil@gmail.com', 'ochil ochil', '🧑‍🎓', '6', 'Toshkent shahri', 0, 0, '{"email":"ochil@gmail.com","grade":6,"login":"ochil@gmail.com","avatar":"🧑‍🎓","region":"Toshkent shahri","school":"1-maktab","district":"Yunusobod tumani","lastName":"ochil","password":"1234","quizWins":0,"firstName":"ochil","bestStreak":4,"gamesPlayed":2,"zakovatWins":0,"totalCorrect":8}', NOW()),
  ('user_wwwbekliruzgmailcom', 'www.beklir.uz@gmail.com', 'www.beklir.uz@gmail.com', 'Nurbek Toshmamatov', '🧑‍🎓', '6', 'Toshkent shahri', 0, 0, '{"email":"www.beklir.uz@gmail.com","grade":6,"login":"www.beklir.uz@gmail.com","avatar":"🧑‍🎓","region":"Toshkent shahri","school":"1-maktab","district":"Yunusobod tumani","lastName":"Toshmamatov","password":"1234","quizWins":0,"firstName":"Nurbek","bestStreak":0,"gamesPlayed":0,"zakovatWins":0,"totalCorrect":0}', NOW())
ON DUPLICATE KEY UPDATE
  `login` = VALUES(`login`),
  `display_name` = VALUES(`display_name`),
  `photo_url` = VALUES(`photo_url`),
  `grade` = VALUES(`grade`),
  `region` = VALUES(`region`),
  `xp` = GREATEST(`users`.`xp`, VALUES(`xp`)),
  `coins` = GREATEST(`users`.`coins`, VALUES(`coins`)),
  `stats` = VALUES(`stats`),
  `last_login_at` = NOW();

-- Muvaffaqiyatli yakunlandi!