salix/db/routines/vn/triggers/department_beforeDelete.sql

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` TRIGGER `vn`.`department_beforeDelete`
	BEFORE DELETE ON `department`
	FOR EACH ROW
BEGIN

	UPDATE vn.business b
		JOIN vn.department d ON d.id = b.departmentFk
		SET b.departmentFk = d.parentFk
		WHERE b.departmentFk = OLD.id;
		
END$$
DELIMITER ;