MySQL

###Triggers

DELIMITER ;;

CREATE TRIGGER project_delete
BEFORE DELETE
	ON projects FOR EACH ROW
BEGIN
	DELETE FROM user_project_role
	WHERE project_id = OLD.pid;
END;;

DELIMITER ;