DELIMITER //

DROP TRIGGER IF EXISTS after_material_insert//

CREATE TRIGGER after_material_insert
AFTER INSERT ON materials
FOR EACH ROW
BEGIN
    INSERT INTO material_visibility (material_id, is_visible_to_students, updated_by_teacher_id)
    VALUES (NEW.id, FALSE, NEW.teacher_id);
END//

DELIMITER ;