schema issues

someone hardcoded in an old program the wrong schema in an update statement

I went ahead and creates a matching schema and put the tables in a s views (select * )