default to bigint rather than int; test fixes for dateime in mysql