update migration and test schema to *not* set default values for ID columns