updaed views, procedures, added function.. should have done multiple commits