/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 vote196 views1 answer
Drop foreign key laravel eloquent
PHP
0 vote280 views1 answer
Delay queue laravel
PHP Laravel
0 vote178 views1 answer
Create an obect in php
PHP
0 vote226 views1 answer
Curlopt_postfields php example
PHP
0 vote239 views1 answer
Is replace case sensitive php
PHP
0 vote214 views1 answer
Laravel unknown column updated at
PHP
1 vote181 views1 answer
Grenerating random text color for text for image php
PHP
0 vote243 views1 answer
Search query codeigniter
PHP CodeIgniter
0 vote202 views1 answer
Twig get array key name
PHP
0 vote182 views1 answer
Fetch row in php
PHP