starterpack_default's migration mechanism consists of:
script/migrate.php # Runs any pending migrations
var/migrations.log # Logs which migrations have been run already
script/migrations/ # Directory containing all migration scripts
script/generate_migration.php # Script that generates a new migration
Migrations are just executable scripts within the script/migrations/
directory. You can put anything with the executable-flag set in there.