adjusdting column types to work with mysql. passes basic add_observations test