[WIP] storage: drop obsolete occurrences-related stuff
Goal is to remove obsolete occurrence-related tables and dependent objects (indexes, functions, storage endpoints, etc.).
While at it, I'm also taking the chance of uniforming style and messages in the SQL definitions, but those changes will be committed separately.
Migrated from D446 (view on Phabricator)