Adminator/geograsim
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
geograsim/App/Don_t_Deploy/2026-07-20-klasse-3b-und-umbenennung.sql
T
Adminator 15ac35a7ad Lehrer-Übersicht: Interventions-Block (Erfolg/Aktiv/Verlauf + Triage) live 
Neuer Block oben im Übersicht-Tab: 5 Stat-Karten (Erfolg-Klassenschnitt, Aktuell
aktiv als Streifen, Verlauf-Klassenschnitt mit Skala, Schüler, Simulationen) +
Interventions-Triage (Fördern/Fordern/Begleiten/Bestätigen/Beteiligen) mit
Erfolg-Ampelbalken, blinkender Live-Aktiv-Ampel und Verlaufs-Sparkline pro Person.
Ampelfarben nur für Leistung, Triage-Karten neutral. Alte 5 Stat-Cards raus,
Top-Performer bleibt. Wochen-Cap gegen Zwischenspeicher-Log-Ausreißer.

- results.php: neue fleiss-range 'weeks' (letzte 10 ISO-Wochen)
- 2. Testklasse „3b Klasse" (3 Schüler); Klasse 99 → „4b Klasse"

Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
2026-07-20 13:17:22 +02:00

114 lines
34 KiB
SQL
Raw Permalink Blame History

SET FOREIGN_KEY_CHECKS=0;
-- Klasse 99 umbenennen
UPDATE classes SET name='4b Klasse' WHERE id=99;
-- Cleanup 3b (idempotent)
DELETE FROM player_progress WHERE student_id IN (SELECT id FROM students WHERE username IN ('pia_3b','rosa_3b','sami_3b'));
DELETE FROM student_results WHERE student_id IN (SELECT id FROM students WHERE username IN ('pia_3b','rosa_3b','sami_3b'));
DELETE FROM assessments WHERE session_id IN (SELECT id FROM student_sessions WHERE created_at='2025-10-01 08:00:00' AND display_name IN ('Pia','Rosa','Sami'));
DELETE FROM student_sessions WHERE created_at='2025-10-01 08:00:00' AND display_name IN ('Pia','Rosa','Sami');
DELETE FROM students WHERE username IN ('pia_3b','rosa_3b','sami_3b');
DELETE FROM classes WHERE join_code='TEST3B';
-- Klasse 3b anlegen
INSERT INTO classes (teacher_id, name, school_year, join_code, country) VALUES (99,'3b Klasse','2025/26','TEST3B','AT');
INSERT INTO students (class_id, username, password, display_name, emoji_avatar, avatar_slug, is_anonymous, created_at) VALUES ((SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'pia_3b','!nologin-generated','Pia','🦉','eule-prof',0,'2025-09-20 08:00:00');
INSERT INTO student_sessions (id, class_id, display_name, created_at, last_seen, country) VALUES ('d112ac1b-8fec-f2da-28ae-e97cd5acbec5',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'Pia','2025-10-01 08:00:00','2026-06-15 12:00:00','AT');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('d112ac1b-8fec-f2da-28ae-e97cd5acbec5','fluss',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDUsICJiaW9kaXYiOiAxMDAsICJlY29ub215IjogMTAwLCAiZmxvb2QiOiAwLCAiZm9vZCI6IDEwMH0=') USING utf8mb4),353000,'2026-03-13 09:41:03');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'fluss',100,353,CONVERT(FROM_BASE64('eyJzdGFycyI6IDUsICJiaW9kaXYiOiAxMDAsICJlY29ub215IjogMTAwLCAiZmxvb2QiOiAwLCAiZm9vZCI6IDEwMH0=') USING utf8mb4),'2026-03-13 09:41:03');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('d112ac1b-8fec-f2da-28ae-e97cd5acbec5','fluss',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDQsICJiaW9kaXYiOiA3MSwgImVjb25vbXkiOiA3MSwgImZsb29kIjogMjksICJmb29kIjogNzF9') USING utf8mb4),400000,'2026-02-07 13:02:46');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'fluss',71,400,CONVERT(FROM_BASE64('eyJzdGFycyI6IDQsICJiaW9kaXYiOiA3MSwgImVjb25vbXkiOiA3MSwgImZsb29kIjogMjksICJmb29kIjogNzF9') USING utf8mb4),'2026-02-07 13:02:46');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),'fluss',2,95,2,5);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('d112ac1b-8fec-f2da-28ae-e97cd5acbec5','tourismustal',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJnb2Fsc0RvbmUiOiA0LCAiZ29hbHNUb3RhbCI6IDYsICJzYXRpc2ZhY3Rpb24iOiA3MywgIm5hdHVyZSI6IDczLCAibW9uZXkiOiAxMDB9') USING utf8mb4),467000,'2025-11-15 14:14:17');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'tourismustal',73,467,CONVERT(FROM_BASE64('eyJnb2Fsc0RvbmUiOiA0LCAiZ29hbHNUb3RhbCI6IDYsICJzYXRpc2ZhY3Rpb24iOiA3MywgIm5hdHVyZSI6IDczLCAibW9uZXkiOiAxMDB9') USING utf8mb4),'2025-11-15 14:14:17');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),'tourismustal',1,40,1,4);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('d112ac1b-8fec-f2da-28ae-e97cd5acbec5','kofferdetektiv',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJjYXNlc190b3RhbCI6IDYsICJjYXNlc19zb2x2ZWQiOiAzLCAiY29ycmVjdF9maXJzdF90cnkiOiAzLCAid3JvbmdfZ3Vlc3NlcyI6IDAsICJoaW50c191c2VkX2F2ZyI6IDUuMH0=') USING utf8mb4),192000,'2025-11-22 15:19:52');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'kofferdetektiv',56,192,CONVERT(FROM_BASE64('eyJjYXNlc190b3RhbCI6IDYsICJjYXNlc19zb2x2ZWQiOiAzLCAiY29ycmVjdF9maXJzdF90cnkiOiAzLCAid3JvbmdfZ3Vlc3NlcyI6IDAsICJoaW50c191c2VkX2F2ZyI6IDUuMH0=') USING utf8mb4),'2025-11-22 15:19:52');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),'kofferdetektiv',1,30,1,3);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('d112ac1b-8fec-f2da-28ae-e97cd5acbec5','farmer',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJoaXRfcmF0ZSI6IDY4LCAieWVhciI6IDEwLCAiY3JvcHNfdXNlZCI6IDR9') USING utf8mb4),240000,'2025-12-20 10:26:16');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'farmer',68,240,CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJoaXRfcmF0ZSI6IDY4LCAieWVhciI6IDEwLCAiY3JvcHNfdXNlZCI6IDR9') USING utf8mb4),'2025-12-20 10:26:16');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),'farmer',1,30,1,3);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('d112ac1b-8fec-f2da-28ae-e97cd5acbec5','weltkueche',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJjb21wbGV0ZWREaXNoZXMiOiA1LCAidG90YWxEaXNoZXMiOiAxMCwgIm1pc3Rha2VzSW5EaXNoIjogN30=') USING utf8mb4),377000,'2025-12-07 14:02:09');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'weltkueche',53,377,CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJjb21wbGV0ZWREaXNoZXMiOiA1LCAidG90YWxEaXNoZXMiOiAxMCwgIm1pc3Rha2VzSW5EaXNoIjogN30=') USING utf8mb4),'2025-12-07 14:02:09');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),'weltkueche',1,30,1,3);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('d112ac1b-8fec-f2da-28ae-e97cd5acbec5','sonnensystem',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJjb21wbGV0ZWQiOiAxMSwgInRvdGFsIjogMjAsICJmaXJzdFRyeSI6IGZhbHNlfQ==') USING utf8mb4),290000,'2025-12-07 13:09:48');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'sonnensystem',55,290,CONVERT(FROM_BASE64('eyJjb21wbGV0ZWQiOiAxMSwgInRvdGFsIjogMjAsICJmaXJzdFRyeSI6IGZhbHNlfQ==') USING utf8mb4),'2025-12-07 13:09:48');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('d112ac1b-8fec-f2da-28ae-e97cd5acbec5','sonnensystem',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJjb21wbGV0ZWQiOiAxNiwgInRvdGFsIjogMjAsICJmaXJzdFRyeSI6IGZhbHNlfQ==') USING utf8mb4),509000,'2026-03-03 11:22:40');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'sonnensystem',82,509,CONVERT(FROM_BASE64('eyJjb21wbGV0ZWQiOiAxNiwgInRvdGFsIjogMjAsICJmaXJzdFRyeSI6IGZhbHNlfQ==') USING utf8mb4),'2026-03-03 11:22:40');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),'sonnensystem',2,70,2,4);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('d112ac1b-8fec-f2da-28ae-e97cd5acbec5','heli',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGVybmVHZXNhbXQiOiA0LCAicGxhblBjdCI6IDkwLCAic3RhcnRTY29yZSI6IDQsICJsYW5kaW5nU2NvcmUiOiA0fQ==') USING utf8mb4),286000,'2026-02-02 08:38:06');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'heli',90,286,CONVERT(FROM_BASE64('eyJzdGVybmVHZXNhbXQiOiA0LCAicGxhblBjdCI6IDkwLCAic3RhcnRTY29yZSI6IDQsICJsYW5kaW5nU2NvcmUiOiA0fQ==') USING utf8mb4),'2026-02-02 08:38:06');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='pia_3b' LIMIT 1),'heli',1,40,1,4);
INSERT INTO students (class_id, username, password, display_name, emoji_avatar, avatar_slug, is_anonymous, created_at) VALUES ((SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'rosa_3b','!nologin-generated','Rosa','🦊','fuchs-explorer',0,'2025-09-20 08:00:00');
INSERT INTO student_sessions (id, class_id, display_name, created_at, last_seen, country) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'Rosa','2025-10-01 08:00:00','2026-06-15 12:00:00','AT');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','farmer',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJoaXRfcmF0ZSI6IDU4LCAieWVhciI6IDksICJjcm9wc191c2VkIjogM30=') USING utf8mb4),472000,'2026-05-13 08:45:16');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'farmer',58,472,CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJoaXRfcmF0ZSI6IDU4LCAieWVhciI6IDksICJjcm9wc191c2VkIjogM30=') USING utf8mb4),'2026-05-13 08:45:16');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),'farmer',1,30,1,3);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','kofferdetektiv',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJjYXNlc190b3RhbCI6IDYsICJjYXNlc19zb2x2ZWQiOiA0LCAiY29ycmVjdF9maXJzdF90cnkiOiA0LCAid3JvbmdfZ3Vlc3NlcyI6IDAsICJoaW50c191c2VkX2F2ZyI6IDMuOX0=') USING utf8mb4),210000,'2026-01-03 11:47:17');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'kofferdetektiv',68,210,CONVERT(FROM_BASE64('eyJjYXNlc190b3RhbCI6IDYsICJjYXNlc19zb2x2ZWQiOiA0LCAiY29ycmVjdF9maXJzdF90cnkiOiA0LCAid3JvbmdfZ3Vlc3NlcyI6IDAsICJoaW50c191c2VkX2F2ZyI6IDMuOX0=') USING utf8mb4),'2026-01-03 11:47:17');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','kofferdetektiv',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJjYXNlc190b3RhbCI6IDYsICJjYXNlc19zb2x2ZWQiOiAyLCAiY29ycmVjdF9maXJzdF90cnkiOiAyLCAid3JvbmdfZ3Vlc3NlcyI6IDAsICJoaW50c191c2VkX2F2ZyI6IDcuM30=') USING utf8mb4),216000,'2026-05-25 15:04:54');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'kofferdetektiv',30,216,CONVERT(FROM_BASE64('eyJjYXNlc190b3RhbCI6IDYsICJjYXNlc19zb2x2ZWQiOiAyLCAiY29ycmVjdF9maXJzdF90cnkiOiAyLCAid3JvbmdfZ3Vlc3NlcyI6IDAsICJoaW50c191c2VkX2F2ZyI6IDcuM30=') USING utf8mb4),'2026-05-25 15:04:54');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),'kofferdetektiv',2,50,2,3);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','eu-werkstatt',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJlbmRUeXBlIjogImFib3J0ZWQiLCAic3RlcHNUb3RhbCI6IDEwLCAiZmlyc3RUcnlIaXRzIjogNSwgInRvdGFsQXR0ZW1wdHMiOiAxMiwgIm11ZWxsZWltZXJDb3VudCI6IDF9') USING utf8mb4),192000,'2026-03-28 10:06:01');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'eu-werkstatt',51,192,CONVERT(FROM_BASE64('eyJlbmRUeXBlIjogImFib3J0ZWQiLCAic3RlcHNUb3RhbCI6IDEwLCAiZmlyc3RUcnlIaXRzIjogNSwgInRvdGFsQXR0ZW1wdHMiOiAxMiwgIm11ZWxsZWltZXJDb3VudCI6IDF9') USING utf8mb4),'2026-03-28 10:06:01');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','eu-werkstatt',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJlbmRUeXBlIjogImFib3J0ZWQiLCAic3RlcHNUb3RhbCI6IDEwLCAiZmlyc3RUcnlIaXRzIjogNSwgInRvdGFsQXR0ZW1wdHMiOiAxMiwgIm11ZWxsZWltZXJDb3VudCI6IDF9') USING utf8mb4),124000,'2025-12-13 11:22:35');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'eu-werkstatt',54,124,CONVERT(FROM_BASE64('eyJlbmRUeXBlIjogImFib3J0ZWQiLCAic3RlcHNUb3RhbCI6IDEwLCAiZmlyc3RUcnlIaXRzIjogNSwgInRvdGFsQXR0ZW1wdHMiOiAxMiwgIm11ZWxsZWltZXJDb3VudCI6IDF9') USING utf8mb4),'2025-12-13 11:22:35');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','eu-werkstatt',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJlbmRUeXBlIjogImFib3J0ZWQiLCAic3RlcHNUb3RhbCI6IDEwLCAiZmlyc3RUcnlIaXRzIjogNCwgInRvdGFsQXR0ZW1wdHMiOiAxMiwgIm11ZWxsZWltZXJDb3VudCI6IDF9') USING utf8mb4),354000,'2025-12-28 08:11:15');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'eu-werkstatt',36,354,CONVERT(FROM_BASE64('eyJlbmRUeXBlIjogImFib3J0ZWQiLCAic3RlcHNUb3RhbCI6IDEwLCAiZmlyc3RUcnlIaXRzIjogNCwgInRvdGFsQXR0ZW1wdHMiOiAxMiwgIm11ZWxsZWltZXJDb3VudCI6IDF9') USING utf8mb4),'2025-12-28 08:11:15');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),'eu-werkstatt',2,80,3,3);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','energiemanager',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJibG9ja3NCYWxhbmNlZCI6IDYsICJibG9ja3NUb3RhbCI6IDEyLCAiZGF5c1BsYXllZCI6IDMsICJkYXlzVG90YWwiOiA2fQ==') USING utf8mb4),119000,'2026-05-24 08:08:07');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'energiemanager',51,119,CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJibG9ja3NCYWxhbmNlZCI6IDYsICJibG9ja3NUb3RhbCI6IDEyLCAiZGF5c1BsYXllZCI6IDMsICJkYXlzVG90YWwiOiA2fQ==') USING utf8mb4),'2026-05-24 08:08:07');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),'energiemanager',1,30,1,3);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','klima',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJmaW5hbF90ZW1wZXJhdHVyZSI6IDE2LjYxLCAiZmluYWxfZmxvb2RlZF9wY3QiOiAzNywgImZpbmFsX2J1ZGdldCI6IDIzMCwgImZpbmFsX2NvMiI6IDQzNiwgImZpbmFsX3BvcHVsYXRpb24iOiAyNTB9') USING utf8mb4),355000,'2026-04-19 12:54:37');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'klima',63,355,CONVERT(FROM_BASE64('eyJmaW5hbF90ZW1wZXJhdHVyZSI6IDE2LjYxLCAiZmluYWxfZmxvb2RlZF9wY3QiOiAzNywgImZpbmFsX2J1ZGdldCI6IDIzMCwgImZpbmFsX2NvMiI6IDQzNiwgImZpbmFsX3BvcHVsYXRpb24iOiAyNTB9') USING utf8mb4),'2026-04-19 12:54:37');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),'klima',1,30,1,3);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','logistik',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJvcmRlcnNEZWxpdmVyZWQiOiA1LCAidG90YWxPcmRlcnMiOiAxMCwgIm9yZGVyc0xhdGUiOiAwLCAiZmluYWxCYWxhbmNlIjogMjgwfQ==') USING utf8mb4),403000,'2026-05-12 11:30:33');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'logistik',54,403,CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJvcmRlcnNEZWxpdmVyZWQiOiA1LCAidG90YWxPcmRlcnMiOiAxMCwgIm9yZGVyc0xhdGUiOiAwLCAiZmluYWxCYWxhbmNlIjogMjgwfQ==') USING utf8mb4),'2026-05-12 11:30:33');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','logistik',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDIsICJvcmRlcnNEZWxpdmVyZWQiOiA0LCAidG90YWxPcmRlcnMiOiAxMCwgIm9yZGVyc0xhdGUiOiAwLCAiZmluYWxCYWxhbmNlIjogMTAwfQ==') USING utf8mb4),483000,'2026-02-15 13:37:26');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'logistik',45,483,CONVERT(FROM_BASE64('eyJzdGFycyI6IDIsICJvcmRlcnNEZWxpdmVyZWQiOiA0LCAidG90YWxPcmRlcnMiOiAxMCwgIm9yZGVyc0xhdGUiOiAwLCAiZmluYWxCYWxhbmNlIjogMTAwfQ==') USING utf8mb4),'2026-02-15 13:37:26');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),'logistik',2,50,2,3);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','weltkueche',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJjb21wbGV0ZWREaXNoZXMiOiA2LCAidG90YWxEaXNoZXMiOiAxMCwgIm1pc3Rha2VzSW5EaXNoIjogNn0=') USING utf8mb4),319000,'2026-06-04 14:53:49');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'weltkueche',59,319,CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJjb21wbGV0ZWREaXNoZXMiOiA2LCAidG90YWxEaXNoZXMiOiAxMCwgIm1pc3Rha2VzSW5EaXNoIjogNn0=') USING utf8mb4),'2026-06-04 14:53:49');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),'weltkueche',1,30,1,3);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','heli',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGVybmVHZXNhbXQiOiA0LCAicGxhblBjdCI6IDcxLCAic3RhcnRTY29yZSI6IDQsICJsYW5kaW5nU2NvcmUiOiA0fQ==') USING utf8mb4),430000,'2025-10-23 08:34:16');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'heli',71,430,CONVERT(FROM_BASE64('eyJzdGVybmVHZXNhbXQiOiA0LCAicGxhblBjdCI6IDcxLCAic3RhcnRTY29yZSI6IDQsICJsYW5kaW5nU2NvcmUiOiA0fQ==') USING utf8mb4),'2025-10-23 08:34:16');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','heli',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGVybmVHZXNhbXQiOiAzLCAicGxhblBjdCI6IDU0LCAic3RhcnRTY29yZSI6IDMsICJsYW5kaW5nU2NvcmUiOiAzfQ==') USING utf8mb4),179000,'2025-11-16 14:34:52');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'heli',54,179,CONVERT(FROM_BASE64('eyJzdGVybmVHZXNhbXQiOiAzLCAicGxhblBjdCI6IDU0LCAic3RhcnRTY29yZSI6IDMsICJsYW5kaW5nU2NvcmUiOiAzfQ==') USING utf8mb4),'2025-11-16 14:34:52');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),'heli',2,70,2,4);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','fluss',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDQsICJiaW9kaXYiOiA3MCwgImVjb25vbXkiOiA3MCwgImZsb29kIjogMzAsICJmb29kIjogNzB9') USING utf8mb4),302000,'2026-05-13 12:16:30');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'fluss',70,302,CONVERT(FROM_BASE64('eyJzdGFycyI6IDQsICJiaW9kaXYiOiA3MCwgImVjb25vbXkiOiA3MCwgImZsb29kIjogMzAsICJmb29kIjogNzB9') USING utf8mb4),'2026-05-13 12:16:30');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('8b7a490f-e331-c6c5-3840-785bcd851ffe','fluss',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDEsICJiaW9kaXYiOiAyNywgImVjb25vbXkiOiAyNywgImZsb29kIjogNzMsICJmb29kIjogMjd9') USING utf8mb4),499000,'2026-01-06 13:41:04');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'fluss',27,499,CONVERT(FROM_BASE64('eyJzdGFycyI6IDEsICJiaW9kaXYiOiAyNywgImVjb25vbXkiOiAyNywgImZsb29kIjogNzMsICJmb29kIjogMjd9') USING utf8mb4),'2026-01-06 13:41:04');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='rosa_3b' LIMIT 1),'fluss',2,50,2,4);
INSERT INTO students (class_id, username, password, display_name, emoji_avatar, avatar_slug, is_anonymous, created_at) VALUES ((SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'sami_3b','!nologin-generated','Sami','🐢','baer-foerster',0,'2025-09-20 08:00:00');
INSERT INTO student_sessions (id, class_id, display_name, created_at, last_seen, country) VALUES ('facaddee-c2df-1213-5ee0-5624dcfb1482',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'Sami','2025-10-01 08:00:00','2026-06-15 12:00:00','AT');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('facaddee-c2df-1213-5ee0-5624dcfb1482','energiemanager',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJibG9ja3NCYWxhbmNlZCI6IDYsICJibG9ja3NUb3RhbCI6IDEyLCAiZGF5c1BsYXllZCI6IDMsICJkYXlzVG90YWwiOiA2fQ==') USING utf8mb4),131000,'2026-01-04 08:48:05');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'energiemanager',52,131,CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJibG9ja3NCYWxhbmNlZCI6IDYsICJibG9ja3NUb3RhbCI6IDEyLCAiZGF5c1BsYXllZCI6IDMsICJkYXlzVG90YWwiOiA2fQ==') USING utf8mb4),'2026-01-04 08:48:05');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),'energiemanager',1,30,1,3);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('facaddee-c2df-1213-5ee0-5624dcfb1482','heli',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGVybmVHZXNhbXQiOiAyLCAicGxhblBjdCI6IDQyLCAic3RhcnRTY29yZSI6IDIsICJsYW5kaW5nU2NvcmUiOiAyfQ==') USING utf8mb4),342000,'2026-03-24 14:45:15');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'heli',42,342,CONVERT(FROM_BASE64('eyJzdGVybmVHZXNhbXQiOiAyLCAicGxhblBjdCI6IDQyLCAic3RhcnRTY29yZSI6IDIsICJsYW5kaW5nU2NvcmUiOiAyfQ==') USING utf8mb4),'2026-03-24 14:45:15');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('facaddee-c2df-1213-5ee0-5624dcfb1482','heli',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGVybmVHZXNhbXQiOiAxLCAicGxhblBjdCI6IDE3LCAic3RhcnRTY29yZSI6IDEsICJsYW5kaW5nU2NvcmUiOiAxfQ==') USING utf8mb4),409000,'2026-01-12 08:25:46');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'heli',17,409,CONVERT(FROM_BASE64('eyJzdGVybmVHZXNhbXQiOiAxLCAicGxhblBjdCI6IDE3LCAic3RhcnRTY29yZSI6IDEsICJsYW5kaW5nU2NvcmUiOiAxfQ==') USING utf8mb4),'2026-01-12 08:25:46');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),'heli',1,30,2,2);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('facaddee-c2df-1213-5ee0-5624dcfb1482','weltkueche',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJjb21wbGV0ZWREaXNoZXMiOiA3LCAidG90YWxEaXNoZXMiOiAxMCwgIm1pc3Rha2VzSW5EaXNoIjogNX0=') USING utf8mb4),395000,'2025-11-14 14:46:57');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'weltkueche',67,395,CONVERT(FROM_BASE64('eyJzdGFycyI6IDMsICJjb21wbGV0ZWREaXNoZXMiOiA3LCAidG90YWxEaXNoZXMiOiAxMCwgIm1pc3Rha2VzSW5EaXNoIjogNX0=') USING utf8mb4),'2025-11-14 14:46:57');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),'weltkueche',1,30,1,3);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('facaddee-c2df-1213-5ee0-5624dcfb1482','tourismusregion',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzY29yZSI6IDM3fQ==') USING utf8mb4),361000,'2026-05-28 14:22:21');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'tourismusregion',37,361,CONVERT(FROM_BASE64('eyJzY29yZSI6IDM3fQ==') USING utf8mb4),'2026-05-28 14:22:21');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),'tourismusregion',1,20,1,2);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('facaddee-c2df-1213-5ee0-5624dcfb1482','kofferdetektiv',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJjYXNlc190b3RhbCI6IDYsICJjYXNlc19zb2x2ZWQiOiAzLCAiY29ycmVjdF9maXJzdF90cnkiOiAzLCAid3JvbmdfZ3Vlc3NlcyI6IDAsICJoaW50c191c2VkX2F2ZyI6IDUuOX0=') USING utf8mb4),413000,'2025-11-11 08:03:50');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'kofferdetektiv',46,413,CONVERT(FROM_BASE64('eyJjYXNlc190b3RhbCI6IDYsICJjYXNlc19zb2x2ZWQiOiAzLCAiY29ycmVjdF9maXJzdF90cnkiOiAzLCAid3JvbmdfZ3Vlc3NlcyI6IDAsICJoaW50c191c2VkX2F2ZyI6IDUuOX0=') USING utf8mb4),'2025-11-11 08:03:50');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),'kofferdetektiv',1,20,1,2);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('facaddee-c2df-1213-5ee0-5624dcfb1482','tourismustal',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJnb2Fsc0RvbmUiOiAzLCAiZ29hbHNUb3RhbCI6IDYsICJzYXRpc2ZhY3Rpb24iOiA0NiwgIm5hdHVyZSI6IDQ2LCAibW9uZXkiOiAxMDB9') USING utf8mb4),194000,'2026-01-31 08:06:10');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'tourismustal',46,194,CONVERT(FROM_BASE64('eyJnb2Fsc0RvbmUiOiAzLCAiZ29hbHNUb3RhbCI6IDYsICJzYXRpc2ZhY3Rpb24iOiA0NiwgIm5hdHVyZSI6IDQ2LCAibW9uZXkiOiAxMDB9') USING utf8mb4),'2026-01-31 08:06:10');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('facaddee-c2df-1213-5ee0-5624dcfb1482','tourismustal',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJnb2Fsc0RvbmUiOiAyLCAiZ29hbHNUb3RhbCI6IDYsICJzYXRpc2ZhY3Rpb24iOiAzNSwgIm5hdHVyZSI6IDM1LCAibW9uZXkiOiAxMDB9') USING utf8mb4),406000,'2025-12-21 14:05:28');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'tourismustal',35,406,CONVERT(FROM_BASE64('eyJnb2Fsc0RvbmUiOiAyLCAiZ29hbHNUb3RhbCI6IDYsICJzYXRpc2ZhY3Rpb24iOiAzNSwgIm5hdHVyZSI6IDM1LCAibW9uZXkiOiAxMDB9') USING utf8mb4),'2025-12-21 14:05:28');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),'tourismustal',1,40,2,2);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('facaddee-c2df-1213-5ee0-5624dcfb1482','logistik',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDIsICJvcmRlcnNEZWxpdmVyZWQiOiA0LCAidG90YWxPcmRlcnMiOiAxMCwgIm9yZGVyc0xhdGUiOiAwLCAiZmluYWxCYWxhbmNlIjogLTI1fQ==') USING utf8mb4),167000,'2025-12-13 14:57:42');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'logistik',39,167,CONVERT(FROM_BASE64('eyJzdGFycyI6IDIsICJvcmRlcnNEZWxpdmVyZWQiOiA0LCAidG90YWxPcmRlcnMiOiAxMCwgIm9yZGVyc0xhdGUiOiAwLCAiZmluYWxCYWxhbmNlIjogLTI1fQ==') USING utf8mb4),'2025-12-13 14:57:42');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),'logistik',1,20,1,2);
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('facaddee-c2df-1213-5ee0-5624dcfb1482','farmer',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDIsICJoaXRfcmF0ZSI6IDM5LCAieWVhciI6IDYsICJjcm9wc191c2VkIjogMn0=') USING utf8mb4),349000,'2026-04-24 14:11:37');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'farmer',39,349,CONVERT(FROM_BASE64('eyJzdGFycyI6IDIsICJoaXRfcmF0ZSI6IDM5LCAieWVhciI6IDYsICJjcm9wc191c2VkIjogMn0=') USING utf8mb4),'2026-04-24 14:11:37');
INSERT INTO assessments (session_id, sim_id, class_id, results, duration_ms, submitted_at) VALUES ('facaddee-c2df-1213-5ee0-5624dcfb1482','farmer',(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),CONVERT(FROM_BASE64('eyJzdGFycyI6IDIsICJoaXRfcmF0ZSI6IDMzLCAieWVhciI6IDUsICJjcm9wc191c2VkIjogMn0=') USING utf8mb4),159000,'2025-11-03 10:02:43');
INSERT INTO student_results (student_id, class_id, module_id, score, duration_sec, detail_json, completed_at) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),(SELECT id FROM classes WHERE join_code='TEST3B' LIMIT 1),'farmer',33,159,CONVERT(FROM_BASE64('eyJzdGFycyI6IDIsICJoaXRfcmF0ZSI6IDMzLCAieWVhciI6IDUsICJjcm9wc191c2VkIjogMn0=') USING utf8mb4),'2025-11-03 10:02:43');
INSERT INTO player_progress (student_id, sim_id, level, xp, plays, best_stars) VALUES ((SELECT id FROM students WHERE username='sami_3b' LIMIT 1),'farmer',1,40,2,2);
SET FOREIGN_KEY_CHECKS=1;
Reference in New Issue View Git Blame Copy Permalink