# Migrations
Migrations are like version control for your database, allowing your team to modify and share the application’s database schema. Migrations are typically paired with schema builder to build your application’s database schema. If you have ever had to tell a teammate to manually add a column to their local database schema, you’ve faced the problem that database migrations solve.
# Generating Migrations
To create a migration, use the make-sql-migration command:
expresswebcli make-sql-migration [MIGRATION_NAME]
The new migration will be placed in your database/migrations directory. Each migration file name contains a timestamp, which allows expresswebjs to determine the order of the migrations.
# To run your migrations
expresswebcli run-sql-migration
# To List both completed and pending migrations
expresswebcli show-sql-list
# To rollback the last batch of migrations:
expresswebcli sql-rollback
# To run the next migration that has not yet been run:
expresswebcli sql-rollup
# To run the specified migration that has not yet been run
expresswebcli sql-rollup [MIGRATION_NAME]
# To undo the last migration that was run
expresswebcli sql-rolldown
# To undo the specified migration that was run:
expresswebcli sql-rolldown [MIGRATION_NAME]
Other Interesting Commands:
# To create new route folder
expresswebcli make-route [ROUTE_NAME] [ROUTE_PATH]
# To create authentication
expresswebcli make-nosql-auth
# To create nosql model
expresswebcli make-nosql-model [MODEL_NAME]
# To create sql model with migration
expresswebcli make-sql-model [NODEL_NAME] [--m]
← Query Schema Builder →