# Migrations

# Introduction

Migrations are like version control for your database, allowing your team to define and share the application's database schema definition.

UnoPim leverages the Laravel Schema facade to offer database-agnostic support for creating and manipulating tables across various database systems supported by Laravel. Migrations in UnoPim utilize this powerful feature to manage database schema changes efficiently.

To understand Migrations in detail, you can visit the Laravel documentation here (opens new window).

Let's create a new migration file for your application. We will assume that the package name is "Example". Follow these steps:

# Using Laravel Artisan Command

Create a Database folder in the packages/Webkul/Example/src path. Inside the Database folder, create Migrations and Seeders folders.

└── packages
    └── Webkul
        └── Example
            └── src
                ├── ...
                └── Database
                    ├── Migrations
                    └── Seeders

Run the following command with the --path option to specify where your migration file will be placed.

php artisan make:migration create_examples_table --path=packages/Webkul/Example/src/Database/Migrations

To create a new database table Copy the code provided here and paste it into your migration file. The create method used on the Schema facade. The create method accepts two arguments: the first is the name of the table, while the second is a closure which receives a Blueprint object that may be used to define the new table:

<?php

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

return new class extends Migration
{
   /**
    * Run the migrations.
    *
    * @return void
    */
    public function up()
    {
        Schema::create('examples', function (Blueprint $table) {
            $table->id();
            $table->string('title')->nullable();
            $table->longText('description')->nullable();
            $table->integer('user_id');
            $table->tinyInteger('status')->default(1);
            $table->timestamps();
        });
    }

   /**
    * Reverse the migrations.
    *
    * @return void
    */
    public function down()
    {
        Schema::dropIfExists('examples');
    }
};

# Loading Migration from Package

We need to add the migrations to our service provider to load them.

<?php

namespace Webkul\Example\Providers;

use Illuminate\Support\ServiceProvider;

class ExampleServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap services.
    *
    * @return void
    */
    public function boot()
    {          
        $this->loadMigrationsFrom(__DIR__ .'/../Database/Migrations');
    }
}

# Creating Tables from Migrations

Run the following command to create the examples table in your database.

php artisan migrate

← Models →