CREATE TRIGGER aus_user_delete
BEFORE DELETE
ON aus_user
FOR EACH ROW
BEGIN
DELETE FROM aus_user_membership
WHERE user_id = OLD.id OR member_of = OLD.id; --
DELETE FROM aus_user_ancestors
WHERE user_id = OLD.id AND ancestor = OLD.id; --
END
;