add more basic views and fixup scripts and db