(migration) fix events table timestamps, +truncate

[finishes #57955268]

Signed-off-by: Matthew Sykes <matthew.sykes@gmail.com>