-- Data awal CLASSROOM MANAGEMENT SYSTEM (aman dijalankan berulang: INSERT IGNORE).
-- TIDAK membuat akun administrator dengan password bawaan (demi keamanan).
-- Akun administrator pertama dibuat lewat halaman Setup Awal dengan kode di data/setup_code.txt.
USE classroom_management_db;

-- Pengaturan bawaan
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('school_name','Sekolah Saya',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('enrollment_key','',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('download_expiry_minutes','10',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('download_approval_minutes','5',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('download_auto_reject_ext','exe,msi,bat,cmd,ps1,scr,vbs,jar,apk,dll,com,reg',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('download_auto_approve_ext','',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('download_max_mb','200',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('screen_fps','2',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('screen_quality','50',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('screen_max_width','1280',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('blocked_attempt_notify','true',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('log_retention_days','365',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('wol_broadcast','255.255.255.255',NOW());
INSERT IGNORE INTO system_settings (`key`,`value`,updated_at) VALUES ('request_expiry_minutes_apps','30',NOW());

-- Contoh kelas (hapus/ubah sesuai kebutuhan)
INSERT INTO classrooms (name,description,created_at,updated_at) SELECT 'X-A','Contoh kelas - laboratorium komputer',NOW(),NOW() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM classrooms WHERE name='X-A');
INSERT INTO classrooms (name,description,created_at,updated_at) SELECT 'X-B','Contoh kelas',NOW(),NOW() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM classrooms WHERE name='X-B');

-- Contoh siswa (kelas X-A). Hubungkan ke komputer lewat menu Manajemen Siswa.
INSERT INTO students (nis,full_name,classroom_id,is_active,created_at,updated_at) SELECT '2025001','Siswa Contoh 01',(SELECT id FROM classrooms WHERE name='X-A'),1,NOW(),NOW() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM students WHERE nis='2025001');
INSERT INTO students (nis,full_name,classroom_id,is_active,created_at,updated_at) SELECT '2025002','Siswa Contoh 02',(SELECT id FROM classrooms WHERE name='X-A'),1,NOW(),NOW() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM students WHERE nis='2025002');
INSERT INTO students (nis,full_name,classroom_id,is_active,created_at,updated_at) SELECT '2025003','Siswa Contoh 03',(SELECT id FROM classrooms WHERE name='X-A'),1,NOW(),NOW() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM students WHERE nis='2025003');
INSERT INTO students (nis,full_name,classroom_id,is_active,created_at,updated_at) SELECT '2025004','Siswa Contoh 04',(SELECT id FROM classrooms WHERE name='X-A'),1,NOW(),NOW() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM students WHERE nis='2025004');
INSERT INTO students (nis,full_name,classroom_id,is_active,created_at,updated_at) SELECT '2025005','Siswa Contoh 05',(SELECT id FROM classrooms WHERE name='X-A'),1,NOW(),NOW() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM students WHERE nis='2025005');