update views/procedures