Use localtime in TS and set createtime for subs.

Consequently use server's localtime to align with auto-filled timestamps.
Set create_timestamp when creating subscribers.