migrations: Separate superuser migrations

Created by: efritz

It would be good to be able to identify superuser-required migrations in the case that these need elevated permissions than what is normally given to the migrator instance.