Getting Started with Laravel : Laravel Migrations: Creating and Running Database Schema Changes

Screenshot from the tutorial

Getting Started with Laravel: Laravel Migrations for Database Schema Changes

Laravel is one of the most popular PHP frameworks, known for its elegant syntax and powerful features. One of the essential tasks when building a web application is managing the database schema. Laravel's migration system allows developers to define and manage database schema changes in a version-controlled and organized manner. In this post, we will explore how to create and run Laravel migrations to effectively manage your database schema.

What are Laravel Migrations?

Laravel migrations are essentially a version control system for your database. They allow you to define the structure of your database tables and help you keep track of changes in a systematic way. Migrations are stored as PHP files, enabling developers to share database changes easily with their teams.

Why Use Migrations?

1. Version Control: Migrations allow you to keep track of changes made to your database schema over time.
2. Collaboration: Team members can easily apply the same changes to their local databases without conflict.
3. Rollback Functionality: If a migration causes issues, you can quickly roll back to a previous state.
4. Easy Deployment: Migrations can be run automatically as part of the deployment process.

Creating a Migration

To create a new migration in Laravel, you can use the Artisan command-line tool. The syntax for creating a migration is as follows:

php artisan make:migration create_users_table

In this example, we are creating a migration for a new table called users. This will generate a new migration file in the database/migrations directory, with a timestamp prefixed to the filename.

Migration File Structure

Inside the newly created migration file, you will find two methods: up and down.

• up Method: This method is used to define the changes you want to make to your database schema.
• down Method: This method should reverse the changes made in the up method.

Here’s an example of what the migration file might look like:

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateUsersTable extends Migration
{
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('email')->unique();
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('users');
    }
}

Breakdown of the Migration Code

• Schema::create: This method creates a new table in the database.
• Blueprint: This class provides a fluent interface for defining the columns and attributes of the table.
• $table->id(): This generates an auto-incrementing primary key.
• $table->string(): This creates a column with a string data type.
• $table->timestamps(): This adds created_at and updated_at timestamp columns.

Running Migrations

Once you have defined your migration, you can run it using another Artisan command:

php artisan migrate

This command will execute the up method of all pending migrations, creating the necessary tables and schema changes in your database.

Rollback Migrations

If you need to revert the last batch of migrations, you can do so with the following command:

php artisan migrate:rollback

This command will call the down method of the most recently executed migrations, allowing you to revert changes easily.

Conclusion

Laravel migrations are a powerful feature that helps you manage your database schema changes effectively. By using migrations, you can keep your database structure in sync across different environments, collaborate efficiently with team members, and easily roll back changes if necessary. With these basics, you are now ready to start using Laravel migrations in your own projects!

Feel free to check out the original tutorial here for more insights and practical demonstrations. Happy coding!

Another view from the tutorial

---

Connect with SkillBakery Studios

Explore more tutorials, tools, and resources:

• skillbakery.com
• Facebook
• X (Twitter)
• YouTube Channel

Posted by SkillBakery Studios