more updates to the views and update the db schema