switch testing frameworks, add migrations
fix some syntax errors
fix bad column definitions