/PHP/Add a new column to existing table in a migration

Add a new column to existing table in a migration

Laravel migration add column to existing table

php artisan make:migration add_paid_to_users_table --table=users
  
public function up()
{
    Schema::table('users', function($table) {
        $table->integer('paid');
    });
}

public function down()
{
    Schema::table('users', function($table) {
        $table->dropColumn('paid');
    });
}

php artisan migrate

Source: stackoverflow.com

Add a new column to existing table in a migration

// for Laravel 5+
php artisan make:migration add_email_to_users_table --table=users

public function up()
{
    Schema::table('users', function($table) {
        $table->integer('email');
    });
}

public function down()
{
    Schema::table('users', function($table) {
        $table->dropColumn('email');
    });
}

php artisan migrate

Source: stackoverflow.com

Similar codes

0 vote143 views1 answer
Laravel collection all
PHP Laravel
0 vote939 views1 answer
Updateorinsert laravel for large data
PHP Laravel
1 vote130 views2 answers
How to trim string in laravel
PHP
0 vote130 views1 answer
Media library laravel maximum allowed size
PHP
0 vote154 views1 answer
Polymorph laravel return order by
PHP Laravel
0 vote150 views1 answer
Laravel Deploy in production
PHP Laravel
0 vote134 views1 answer
Heroku deploy php
PHP
8 votes237 views3 answers
Cakephp 2 with customize link
PHP CakePHP
1 vote141 views1 answer
Laravel where column different
PHP Laravel
0 vote118 views1 answer
Yen to php
PHP