/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 vote250 views2 answers
How to lookup value object php
PHP
0 vote276 views1 answer
Access denied for user 'root'@'localhost' ec2 laravel
PHP
0 vote304 views1 answer
Die laravel
PHP Laravel
11 votes272 views5 answers
Php keys of array
PHP
0 vote274 views2 answers
Current date time in php for input
PHP
0 vote251 views1 answer
How to install mysql and phpmyadmin on windows 10
PHP
0 vote351 views1 answer
Extensions for laravel command ubuntu 20.04
PHP Laravel
1 vote256 views1 answer
Php is daylight savings
PHP
3 votes252 views2 answers
Click confirm before submit form php
PHP
0 vote245 views2 answers
Php undefined offset
PHP