- changed bool to tinyint for compatiblity with mysql
 - changed avg to a float