Remove tables occurrence and occurrence_history

The occurrence and occurrence_history tables are a remnant of the pre-snapshot era of the archive.

Most uses of these tables are for backwards-compatibility only.

We should remove them.

---

Migrated from T830 (view on Phabricator)