fix tests, update database schema to change id into uid and fix mock data for tests