amending datatypes to work with mysql