fixed datatypes in event table