/PHP/Laravel/Add another column in a table in laravel

Add another column in a table in laravel

<?php

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

class AddStoreIdToUsersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('users', function (Blueprint $table) {

            // 1. Create new column
            // You probably want to make the new column nullable
            $table->integer('store_id')->unsigned()->nullable()->after('password');

            // 2. Create foreign key constraints
            $table->foreign('store_id')->references('id')->on('stores')->onDelete('SET NULL');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('users', function (Blueprint $table) {

            // 1. Drop foreign key constraints
            $table->dropForeign(['store_id']);

            // 2. Drop the column
            $table->dropColumn('store_id');
        });
    }
}

Source: stackoverflow.com

Similar codes

0 vote361 views1 answer
Laravel log query for model (full)
PHP Laravel
3 votes370 views2 answers
Laravel image max size validation
PHP Laravel
1 vote343 views1 answer
Laravel increment column value in update query
PHP Laravel
0 vote366 views1 answer
How use variable in string in laravel
PHP Laravel
2 votes337 views3 answers
Laravel blade time difference
PHP Laravel
6 votes391 views2 answers
WhereHas site:https://laravel.com/docs/
PHP Laravel
3 votes322 views1 answer
Laravel middleware route
PHP Laravel
0 vote393 views1 answer
Compiling multiple CSS into ONE CSS with Laravel MIX
PHP Laravel
22 votes322 views5 answers
Update or insert in laravel
PHP Laravel
12 votes348 views5 answers
Laravel transactions
PHP Laravel