remove transform script
clean up some old stuff
fix ordering of dropuser statements