Laravel Migrations

What are migrations in Laravel?

Migrations in Laravel are version control for your database schema. They allow you to define and modify the structure of your database tables using PHP instead of writing raw SQL. Migrations help manage database changes over time, allowing developers to share database schema updates as part of version control systems. Migrations are stored as PHP files in the database/migrations directory.

How do you create a new migration in Laravel?

To create a new migration, you can use the Artisan command make:migration. This will generate a new migration file in the database/migrations directory with a timestamp in its filename.

Example command to create a migration:

php artisan make:migration create_users_table

This command creates a migration file for creating the users table. You can then define the table structure within the migration file.

What is the structure of a migration file in Laravel?

A migration file contains two methods: up() and down(). The up() method defines the changes to be made to the database (e.g., creating tables or adding columns), while the down() method defines how to reverse those changes (e.g., dropping tables or removing columns).

Example migration file structure:

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');
    }
}

In this example, the up() method creates the users table, and the down() method drops it if it exists.

How do you run migrations in Laravel?

You can run all pending migrations by using the Artisan command migrate. This command will apply the migrations to your database, creating or modifying tables and columns as defined in the migration files.

Example command to run migrations:

php artisan migrate

This command will execute all the migrations that have not yet been run, applying the necessary changes to the database.

How do you roll back migrations in Laravel?

You can roll back the last set of migrations that were applied by using the migrate:rollback command. This will reverse the changes made by the most recent migration batch.

Example command to roll back the last migration:

php artisan migrate:rollback

This command will roll back the most recent batch of migrations, undoing the changes they made to the database.

How do you roll back and re-run migrations in Laravel?

If you want to roll back and re-run all migrations in one command, you can use the migrate:refresh command. This is useful for resetting the database schema during development.

Example command to refresh migrations:

php artisan migrate:refresh

This command will roll back all migrations and then re-run them, resetting the entire database schema.

How do you create a migration with a table modification in Laravel?

To modify an existing table, you can create a migration using the make:migration command and include the --table option, specifying the table you want to modify.

Example command to create a migration for modifying a table:

php artisan make:migration add_age_to_users_table --table=users

This command generates a migration file that will modify the users table. In the generated migration file, you can define the modifications to the table (such as adding a new column).

How do you add columns to an existing table using migrations?

To add columns to an existing table, you define the new columns in the up() method of a migration and specify which table to modify using the Schema::table() method.

Example of adding columns to an existing table:

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

class AddAgeToUsersTable extends Migration
{
    public function up()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->integer('age')->nullable();
        });
    }

    public function down()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->dropColumn('age');
        });
    }
}

In this example, the migration adds an age column to the users table in the up() method and removes it in the down() method.

How do you drop a table using migrations in Laravel?

To drop a table, you can use the Schema::dropIfExists() method within the down() method of a migration. This ensures that the table is dropped when rolling back the migration.

Example of dropping a table:

Schema::dropIfExists('users');

This command will drop the users table if it exists in the database.

How do you rename a table using migrations in Laravel?

You can rename an existing table using the Schema::rename() method inside a migration.

Example of renaming a table:

Schema::rename('old_table_name', 'new_table_name');

This will rename the table old_table_name to new_table_name.

How do you rename a column using migrations in Laravel?

To rename a column, you need to use the renameColumn() method inside a migration. Ensure that you install the doctrine/dbal package, which is required for column renaming.

Example of renaming a column:

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

class RenameUsernameToUserHandleInUsersTable extends Migration
{
    public function up()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->renameColumn('username', 'user_handle');
        });
    }

    public function down()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->renameColumn('user_handle', 'username');
        });
    }
}

In this example, the username column is renamed to user_handle in the up() method, and vice versa in the down() method.

How do you create indexes using migrations?

You can create indexes on table columns using the $table->index() method in a migration. Laravel supports various types of indexes, such as primary keys, unique indexes, and full-text indexes.

Example of creating an index:

Schema::table('users', function (Blueprint $table) {
    $table->index('email');
});

This creates an index on the email column in the users table.

How do you drop an index using migrations?

You can drop an index using the dropIndex() method in a migration. When specifying the index, you need to provide the index name, which Laravel automatically generates or can be specified manually.

Example of dropping an index:

Schema::table('users', function (Blueprint $table) {
    $table->dropIndex(['email']);
});

This command will drop the index on the email column in the users table.

How do you use foreign keys in migrations?

Laravel's schema builder provides support for foreign key constraints. You can define foreign keys using the $table->foreign() method inside your migrations.

Example of adding a foreign key constraint:

Schema::table('posts', function (Blueprint $table) {
    $table->unsignedBigInteger('user_id');
    $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
});

In this example, a foreign key constraint is added to the user_id column in the posts table, referencing the id column in the users table. If a user is deleted, their posts are also deleted due to the onDelete('cascade') option.

How do you run a specific migration in Laravel?

To run a specific migration, you can use the migrate --path option, specifying the path to the migration file.

Example of running a specific migration:

php artisan migrate --path=/database/migrations/2024_01_01_000000_create_users_table.php

This command will run only the specified migration file.