updated db schema to match the mysql one