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 vote91 views1 answer
Laravel relation select fields
PHP
-1 vote58 views1 answer
Pagination align right side in laravel
PHP
2 votes121 views2 answers
Laravel get random number of data from database
PHP Laravel
22 votes110 views4 answers
Laravel orWhere
PHP Laravel
44 votes98 views6 answers
How to make controller in laravel
PHP
9 votes141 views3 answers
Show all validation errors in laravel's blade view
PHP Laravel
0 vote111 views1 answer
Laravel controller data update
PHP Laravel
1 vote206 views1 answer
Print url in view yii2
PHP Yii
0 vote97 views1 answer
Compile custom/plain css with mix in laravel
PHP
0 vote109 views1 answer
Laravel array search blade
PHP Laravel