Laravel Migration: Add a column with a default value of an existing column

laravel laravel-5 laravel-5.1 laravel-migrations
Parvez Rahaman picture Parvez Rahaman · May 12, 2016 · Viewed 15k times · Source

i need to add a last_activity column on a table of a live site where i have to make it's default value to equal of updated_at column value. I'm using laravel 5.1 and mysql database driver.

Schema::table('users', function(Blueprint $table)
{
    $table->dateTime('last_activity')->default("COLUMN VALUE OF UPDATED_AT");
});

Thanks.

Answer

tptcat picture tptcat · May 12, 2016

This should work:

Schema::table('users', function(Blueprint $table) {
    $table->dateTime('last_activity');
});

\DB::statement('UPDATE users SET last_activity = updated_at');

See "Running a General Statement": https://laravel.com/docs/5.1/database#database-transactions

To enforce this relationship when a User is created or updated, you can use Model Events and/or Model Observers.

Related questions

laravel 5 : Class 'input' not found

In my routes.php file I have : Route::get('/', function () { return view('login'); }); Route::get('/index', function(){ return view('index'); }); Route::get('/register', function(){ return view('register'); }); Route::post('/register',function(){ $user = new \App\User; $…

Read More
Laravel : How to Log INFO to separate file

How to specify a separate file for logging INFO in Laravel 5.1? Any immediate help will be highly appreciable. Thanks

Read More
Laravel 5.1 remove controller

I have simple question on Laravel 5.1. I have created a controller using php artisan command: php artisan make:controller PageSettings However it was mistake, because I really wanted to create this controller in Admin folder like this: php artisan make:…

Read More