adjusted db schema and updated logger