Fix schema and broken test

Events table was storing JSON as varchar(255) on MySQL, which was not
large enough.  Migration changes type of that column to text, and
truncates the table.