Fix migrations so that they work in postgres, turns out my naming convention for primary keys was conflicting with the sequence keys.