use the right pk!
handle mysql's lack of millisecond timestamp precision
travis config