added additional schema and migration

also moved the database into /tmp for now..
squash
squash