add soft deletes, fix activity stream dupes / index issues