assignments: add indexes and update links and references