Add time zone to timestamps

According to the migration design guidelines we should use timestamp with time zone instead of timestamp (https://docs.gitlab.com/ee/development/migration_style_guide.html#timestamp-column-type).

No changes are required at the application/service level.

Related to &2313 (closed).