* using switch
* added mysql to handle true and false
* using tinyint(1) instead of boolean