/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 vote212 views1 answer
String length laravel validation
PHP
0 vote204 views1 answer
Test not found page symfiny in dev
PHP
0 vote203 views1 answer
Ubuntu install lamp and phpmyadmin
PHP
0 vote257 views1 answer
How to check if key is present in json in php
PHP
2 votes254 views1 answer
Undefined type 'App\Http\Controllers\api\DB'.
PHP
1 vote194 views1 answer
Get post data in php javascript
PHP
4 votes235 views2 answers
How to insert ip address in mysql using php
PHP
1 vote234 views1 answer
I cannot login to my CPanel hosted Laravel Application, my SSL has expired
PHP
0 vote236 views1 answer
Wordpress html classes
PHP Wordpress
0 vote214 views1 answer
Php throw fatal error
PHP