fix update script for shifttypes
shift signup improvements for shift view
update install sql