/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 vote355 views2 answers
Codeigniter 4 db seed
PHP CodeIgniter
18 votes290 views6 answers
Install laravel auth
PHP Laravel
0 vote279 views1 answer
Exception #0 (Magento\Framework\Exception\ValidatorException): Invalid template file:
PHP
0 vote278 views1 answer
Use font awesome in laravel 8
PHP
1 vote294 views1 answer
Publishing laravel module package
PHP
0 vote305 views1 answer
Laravel import xml to database
PHP Laravel
0 vote252 views1 answer
Merge two objects php laravel
PHP
0 vote269 views1 answer
Gd2 image resizing library in codeigniter
PHP
15 votes255 views6 answers
Transaction laravel
PHP
0 vote457 views1 answer
Laravel form submit page expired
PHP Laravel