Storing Users in a Database

From a fresh Statamic project

If you installed Statamic using the statamic new command, or created a project based on the statamic/statamic repo, it will be configured to store users in files.

Statamic comes with an Eloquent driver to make the transition as seamless as possible.

1. Ensure you have a database configured.
2. In config/statamic/users.php, change repository to eloquent.
3. In config/auth.php, comment out the statamic provider, and uncomment the eloquent provider.
4. Run the php please auth:migration command to generates the migration for the role and user group pivot tables.
5. If you've customized your user blueprint, edit the migration so it includes those fields as columns. You can also create a new migration file by running php artisan make:migration. You'll have to manually edit the migration file to reflect your changes. Read up on Laravel database migrations here.
6. Run php artisan migrate
7. Run a command to migrate your file based users into the database.
8. (optional) If you are using the Statamic forgot password form, add the following method to your User model

   public function sendPasswordResetNotification($token)
   {
       $this->notify(new \Statamic\Notifications\PasswordReset($token));
   }

In an existing Laravel app

If you've installed Statamic into an existing Laravel app, it will already be configured to use the Eloquent driver.

You will need to run migrations to prepare your database for Statamic's user, password reset, and permission setup.

1. Configure the two separate password reset drivers. Unlike a regular Laravel installation, Statamic has a second table to track password activations which are the same as resets, but last a little longer before they expire. This is optional.

   In config/auth.php add the following inside the passwords array:

   'activations' => [
       'provider' => 'users',
       'table' => 'password_activation_tokens',
       'expire' => 4320,
       'throttle' => 60,
   ],

   In config/statamic/users.php change the passwords array to:

   'passwords' => [
       'resets' => 'users',
       'activations' => 'activations',
   ],

2. Create and run the migrations.

   This will add some columns to the users table (like super, and last_login), create the role_user and group_user pivot tables, and create the password_activations table.

   php please auth:migration
   php artisan migrate

3. (optional) If you are using the Statamic forgot password form, add the following method to your User model

   public function sendPasswordResetNotification($token)
   {
       $this->notify(new \Statamic\Notifications\PasswordReset($token));
   }

This assumes you are happy to use our opinionated setup. If you need something more custom you can create your own user driver.