[CRITIQUE REQUEST] Migration Practices

[eluser]WanWizard[/eluser]
The version number is not meant to indicate a version of the migration file, but it's place in the order of migrations. It makes sure that if you install an application that has lots of migration files, they are all executed in thr correct order. Any vcs system in use has nothing to do with this mechanism.

The reason of using migrations is that during the evolution of an application, database changes are introduced with new versions of the application.

If you, like in any other proper development environment, use dev/local, testing, staging, deployment and production environments, you've got servers running different versions of the application. When you move something from one environment to the next (i.e. you upgrade or downgrade an installation), you need to adjust the database schema accordingly. Migrations will take care of this for you.

This gives a good indication of how the migrations work.