Add support for MySQL BIT(1) as boolean type

This updates the MySQL database code to recognise the BIT(1) datatype as a boolean field, rather than previously using the 'BOOL' datatype which is just a synonym for TINYINT(1) and did not work.