added defaults to transaction queries

also tested the migration again. appears to work