How to setup Migrations in Laravel

by Devsense
7 minutes
How to setup Migrations in Laravel

Migrations work as a version control for databases. If you want to keep a record of your database creation and alterations over time, you can use migrations and simplify application re-deployment or distribution. Migrations will help you interact with your database by only using the CLI interface of Laravel. This means that after you install your application and configure the database connection, you just have to run “php artisan migrate” and it will instantly set up the database again.

Prerequisites

For migrations, you need to have the following installed:

  • Visual Studio Code
  • Composer (see how to install both VS Code and Composer here)
  • A Web Development Environment. For this article, we’re going to use WampServer to manage databases. There are no particular configurations for WampServer, it will be downloaded and installed quite easily. Just follow the instructions given by the software or check this video.

1) Use Composer to make a Laravel application

  • Run the following command:
composer create-project laravel/laravel TestingMigrations

2) Open your application directory in VS Code

  • Open VS Code. Click File |Open folder. A pop up window will appear on the screen.
  • Open your downloaded app (wherever you downloaded it). Your app will be loaded into VS Code.

3) Set the .env file.

  • Open it and change the following items there

Image description

Image description

4) Start WampServer

  • Open Wampserver

Image description

  • Wait until the icon in the task bar turns green

Image description

5) Open your browser

  • Type in “localhost” in your url to open WampServer’s localhost, where your local databases will be embedded.

Image description

6) Go to phpMyAdmin

Image description

The default user and password will be “root” and empty, respectively. Image description

Finally, after this, you’ll be able to see your Database Management System, where you can alter your databases already present or you’ll be able to see the tables created in the Laravel application.

Now we’ll make a sample database for future use:

Image description

Image description

7) Open VS Code terminal

  • Open the VS Code terminal by pressing CTRL + Shift + ` or by clicking the Terminal option in the Menu bar and selecting the first option

*Execute the following command in the terminal:

php artisan make:migration create_users_table

If it gives you an error, delete the old migration and make this new one. Your new migrations will be created in the migration sub-directory of database directory of your application. It includes two functions:

Up function (responsible for making tables) Down function (responsible for dropping tables)

Image description

8) Add code to the migration

  • Add the following code in the up and down function of the created migration Image description

  • Go the localhost and check if you can see your table.

Image description

Image description

A few useful commands

Migrations commands along with their uses:

Migration command Use
Php artisan make:migration Make migrations in your app
Php artisan migrate Run your migrations
Php artisan migrate --force Force running your migrations
Php artisan migrate:rollback Rollback migrations
Php artisan migrate:rollback --step=6 Rollback last 6 migrations

Additional reading

If you want to keep on reading about Migrations in Laravel, you can try: