Changing Laravel auth table name and column names

Question

I want to change the table name and some column names of laravel auth table.

Change table name from 'users' to 'accounts'
Change table column name from 'name' to 'username'
Change table column name from 'email' to 'email_addr'
Change table column name from 'updated_at' to 'last_updated_at'

What steps do I take or which code do I edit without breaking something?

I tried this before, and registration worked, but login didn't. Whenever I tried to log in, I got redirected back to the login page.

Possible duplicate of [laravel 5.4 change authentication users table name](https://stackoverflow.com/questions/44449076/laravel-5-4-change-authentication-users-table-name) — Harun Yilmaz, Apr 11 '19 at 06:54
This may also help: https://www.5balloons.info/changing-authentication-table-laravel/ — Harun Yilmaz, Apr 11 '19 at 06:55

score 14 · Answer 1 · edited Feb 01 '21 at 15:58

You can follow the below given steps:

Create/modify migration to change the users table to accounts
Create migration to change the column name as per your requirements for table accounts. Make sure this model call is extends Authenticatable
Create model class for accounts table.
Make sure to add fillable and hidden attributes of table.
Now check the login.blade.php file and change the email input text field name to email_address.

With the above all steps, we are ready with View part now let's start with customising the Auth

Now open config/auth.php
- Change from 'model' => App\User::class, to 'model' => App\Account:class inside providers array.
Now we need to add new function inside app/Http/Auth/LoginController.php like below:

public function username(){ return 'email_address'; // this string is column of accounts table which we are going use for login }

Now we are done with all adjustment, you can test the functionality.

I have tested the functionality and its working like charm :)

Thanks for adding public function username(){ return 'email_addr'; }. Solved my problem. — Savvy Sage, Apr 11 '19 at 10:34
I also updated RegisterController class method #validator(). 'email' => ['required', 'string', 'email', 'max:255', 'unique:accounts'], — Juan Castellon, Feb 10 '20 at 14:10

Surender Singh Rawat · Answer 2 · 2019-04-11T08:46:09.157

7

you have to extend "Illuminate\Foundation\Auth\User" in your Account model.

namespace App;

use Illuminate\Notifications\Notifiable;
use Illuminate\Foundation\Auth\User as Authenticatable;

class Account extends Authenticatable
{ 
  use Notifiable;

  //code here
  public function getEmailAttribute() {
      return $this->email_addr;
  }

  public function setEmailAttribute($value)
  {
    $this->attributes['email_addr'] = strtolower($value);
  }
}

and change in configuration file in "config/auth.php" in providers array

'users' => [
        'driver' => 'eloquent',
        'model' => App\Account::class,  //replace User to Account
    ],

edited Apr 11 '19 at 08:46

answered Apr 11 '19 at 07:00

Surender Singh Rawat

899
4
14

What of the columns? How do I go about that? – Savvy Sage Apr 11 '19 at 08:32
you have to customised them in Account model – Surender Singh Rawat Apr 11 '19 at 08:34
How to customize them? What of templates, controllers? – Savvy Sage Apr 11 '19 at 08:36
are you using default login route – Surender Singh Rawat Apr 11 '19 at 08:37

Changing Laravel auth table name and column names

2 Answers2

Linked