-- Jalankan di phpMyAdmin database lppm_kkn2026
-- SETELAH menjalankan monev-setup.sql

-- 1. Buat akun user untuk Syariefful Ikhwan
INSERT INTO kkn_users (username, email, password, role, status)
VALUES ('monev_0620027902', 'syariefful@umus.ac.id',
        '$2y$10$YcRuFp.X1AUbfPHaWLOoNeHs5O.L0rXbaFDwe2KumOak21d6qsiqO',
        'monev', 'active');

-- 2. Update user_id di kkn_monev
UPDATE kkn_monev 
SET user_id = LAST_INSERT_ID()
WHERE nidn = '0620027902';

-- 3. Buat akun user untuk Dedi Romli Triputra
INSERT INTO kkn_users (username, email, password, role, status)
VALUES ('monev_0625078601', 'dediromli@umus.ac.id',
        '$2y$10$YcRuFp.X1AUbfPHaWLOoNeHs5O.L0rXbaFDwe2KumOak21d6qsiqO',
        'monev', 'active');

-- 4. Update user_id di kkn_monev
UPDATE kkn_monev 
SET user_id = LAST_INSERT_ID()
WHERE nidn = '0625078601';