USE school_management;

-- Check if we have any teachers
SELECT id FROM teachers LIMIT 1;

-- If no teachers exist, create a sample teacher
-- INSERT INTO users (username, password, email, role) VALUES ('teacher1', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'teacher1@school.com', 'teacher');
-- INSERT INTO teachers (user_id, employee_id, first_name, last_name, email) VALUES (2, 'T001', 'জন', 'ডেভেলপার', 'teacher1@school.com');

-- Insert sample assignment
INSERT INTO assignments (title, description, class_id, subject_id, teacher_id, due_date, max_marks, status) 
VALUES ('গণিত - বীজগণিত', 'অধ্যায় ৩ - বহুপদী সমীকরণ', 11, 3, 1, '2025-10-25 23:59:59', 20, 'published');