Adjusts hits table schema to require the time zone in timestamps.
Adds rank optimization tables and an associated update function.
The update function is to be called after the batch import of hits.