updated test db env, no updates really to views

[haitzlm]

deleted strange sqlite entries, created data, and tables correctly in test db to run tests better, ran db:migrate, etc...