added creation of views to migrations

Additional details are here: https://github.com/dlebauer/view_creation_script/blob/master/README.md

We should test that these work with both MySQL and PostgreSQL