title: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'provider' in 'field list' (SQL: insert into `oauth_clients`
body: <p>Am using Laravel version 8 and I am trying to run <code>php artisan migrate:refresh --seed &amp; php artisan passport:install</code></p>
  <p>The migrations and seeding successfully run but <code>php artisan passport:install</code> fails</p>
  <blockquote>
  <p>SQLSTATE[42S22]: Column not found: 1054 Unknown column 'provider' in 'field list' (SQL: insert into <code>oauth_clients</code> (<code>user_id</code>, <code>name</code>, <code>secret</code>, <code>provider</code>, <code>redirect</code>, <code>personal_access_client</code>, <code>password_client</code>, <code>revoked</code>, <code>updated_at</code>, <code>created_at</code>) values (?, Laravel Personal Access Client, Wa44O2Z3IA23st3wbgQHvDkapJlS75ZXO7MZ4A4Q, ?, http://localhost, 1, 0, 0, 2021-02-11 15:09:29, 2021-02-11 15:09:29))</p>
  </blockquote>
  <p>Basically while trying to insert the token a column <code>provider</code> is not found and on checking my oauth_clients_table  migration file is see that the column <code>provider</code> is actually missing</p>
  <pre class="lang-php prettyprint-override"><code>public function up()
      {
          Schema::create('oauth_clients', function (Blueprint $table) {
              $table-&gt;bigIncrements('id');
              $table-&gt;unsignedBigInteger('user_id')-&gt;nullable()-&gt;index();
              $table-&gt;string('name');
              $table-&gt;string('secret', 100)-&gt;nullable();
              $table-&gt;text('redirect');
              $table-&gt;boolean('personal_access_client');
              $table-&gt;boolean('password_client');
              $table-&gt;boolean('revoked');
              $table-&gt;timestamps();
          });
      }
  </code></pre>
  <p>I seem not to find this information about the column, My questions is since this migrations were generated automatically, before I upgraded my application, what is the structure of this column?</p>
  <p><strong>EDIT 1</strong>
  I have tried below and it failed</p>
  <pre><code>$table-&gt;string('provider');
  </code></pre>
  <blockquote>
  <p>SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'provider' cannot be null (SQL: insert into <code>oauth_clients</code> (<code>user_id</code>, <code>name</code>, <code>secret</code>, <code>provider</code>, <code>redirect</code>, <code>personal_access_client</code>, <code>password_client</code>, <code>revoked</code>, <code>updated_at</code>, <code>created_at</code>) values (?, Laravel Personal Access Client, GiZ5BQgqtbbvCuIupO3bhMZHLK0YlIq22LvjWGGG, ?, http://localhost, 1, 0, 0, 2021-02-11 15:33:28, 2021-02-11 15:33:28))</p>
  </blockquote>
  <p>So I added</p>
  <pre><code>$table-&gt;string('provider')-&gt;nullable('web');
  </code></pre>
  <p>The above works but now my question is</p>
  <ol>
  <li>Is the above correct?</li>
  <li>What is the purpose of the <code>provider</code> column in <code>oauth_clients</code> table?</li>
  </ol>