CREATE TRIGGER delete_person
  AFTER DELETE
  ON actors
BEGIN
        DELETE FROM art WHERE media_id=old.idActor AND media_type IN ('actor','artist','writer','director');
        END;