Laravel change column type

Laravel foreign key

Schema::table('posts', function (Blueprint $table) {
    $table->unsignedBigInteger('user_id');

    $table->foreign('user_id')->references('id')->on('users');
});
OR
Schema::table('posts', function (Blueprint $table) {
    $table->foreignId('user_id')->constrained();
});

Laravel drop column

// To drop a column, use the dropColumn method on the schema builder.
// Before dropping columns from a SQLite database, you will need to add
// the doctrine/dbal dependency to your composer.json file and run the
// composer update command in your terminal to install the library:

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

Source: laravel.com

Laravel change column

Schema::table('users', function (Blueprint $table) {
    $table->string('name', 50)->nullable()->change();
});

Source: laravel.com

Laravel change column type

php artisan make:migration change_sometable_in_finance_table --table=finance

public function up()
{
    Schema::table('sometable', function (Blueprint $table) {
        $table->text('text')->change();
    });
}

Source: stackoverflow.com

Laravel migration change column type

public function up()
{
    Schema::table('sometable', function (Blueprint $table) {
        $table->text('text')->change();
    });
}

Laravel change column type

composer require doctrine/dbalpublic function up()
{
    Schema::table('sometable', function (Blueprint $table) {
        $table->text('text')->change();
    });
}

Source: stackoverflow.com

Similar codes

0 vote373 views1 answer
Les étape d'integration du templates adminlte de Laravel pour application
PHP Laravel
2 votes365 views1 answer
Laravel artisan create criteria
PHP Laravel
0 vote375 views2 answers
If condition in laravel blade in select option
PHP Laravel
20 votes331 views6 answers
Laravel validation types
PHP Laravel
48 votes358 views5 answers
Laravel clear route cache
PHP Laravel
0 vote360 views1 answer
Laravel apache public folder
PHP Laravel
0 vote373 views1 answer
How to use attempt in laravel
PHP Laravel
12 votes416 views2 answers
Creating a Basic Route in Laravel 8
PHP Laravel
1 vote379 views1 answer
Laravel difference between fill and update
PHP Laravel
4 votes325 views4 answers
Search in laravel 8
PHP Laravel