update db schema to work on mysql. sqlite had no problems with issue.