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 vote207 views1 answer
Php document append script to head
PHP
4 votes204 views2 answers
Get value type online
PHP
20 votes220 views3 answers
Ucfirst meaning in php
PHP
16 votes247 views6 answers
Php get first key of array
PHP
13 votes243 views5 answers
Php get day of week
PHP
0 vote242 views1 answer
Subquery in laravel
PHP
1 vote224 views4 answers
Laravel generate slug
PHP
4 votes161 views1 answer
Laravel model insert
PHP
7 votes252 views3 answers
Get table name from model laravel
PHP Laravel
6 votes209 views6 answers
Composer install laravel
PHP