/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 vote362 views1 answer
READIMAGE FUNCTION PHP
PHP
0 vote304 views1 answer
Dummy data in laravel
PHP
100 votes339 views6 answers
Check if string contains character php
PHP
0 vote280 views1 answer
Run php code file
PHP
0 vote481 views1 answer
Unique string faker laravel
PHP
0 vote272 views1 answer
Unique key value array php
PHP
1 vote290 views1 answer
Php counting number of chars excluding newlines
PHP
0 vote310 views1 answer
Has password argon2i
PHP
2 votes275 views2 answers
How to trim white space array in php
PHP
10 votes287 views3 answers
Php how to loop through array_rand
PHP