remove sql from procedure to avoid mysql issue

- the assignment_toal view can be created whether it exists or not
by running plain sql
- this avoids a mysql issue with permissions when creating a
view that has a SELECT within a procedure using a sql script