switched from default "tinyint" which creates a tinyint(4) to the standard mysql boolean type "tinyint(1)"