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 vote337 views2 answers
How to structure database in laravel
PHP Laravel
1 vote390 views1 answer
Validation not exists with this id laravel
PHP Laravel
13 votes322 views6 answers
Laravel migration change column type
PHP Laravel
44 votes320 views4 answers
Laravel random string
PHP Laravel
0 vote356 views1 answer
Laravel passport generate key
PHP Laravel
0 vote408 views1 answer
Laravel nova create user
PHP Laravel
10 votes316 views2 answers
Laravel success message
PHP Laravel
2 votes369 views1 answer
Add Laravel .env variable to Vue component
PHP Laravel
2 votes298 views2 answers
Validator number laravel
PHP Laravel
2 votes354 views2 answers
Laravel migration alter column unique
PHP Laravel