update db schema and api.