title: how to solve this laravel migrate error creating database table?
body: <p>I am trying to migrate database in laravel, 
  If I'm adding <code>index()</code> in <code>migration/2014_10_12_100000_create_password_resets_table.php</code>
  I got error like this</p>
  
  <pre><code>My-PC MINGW64 /c/xampp/htdocs/ecoprotect
  $ php artisan migrate
  Migration table created successfully.
  Migrating: 2014_10_12_000000_create_users_table
  Migrated:  2014_10_12_000000_create_users_table
  Migrating: 2014_10_12_100000_create_password_resets_table
  
     Illuminate\Database\QueryException  : SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max k
  ey length is 767 bytes (SQL: alter table `password_resets` add index `password_resets_email_index`(`email`))
  
    at C:\xampp\htdocs\ecoprotect\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664
      660|         // If an exception occurs when attempting to run a query, we'll format the error
      661|         // message to include the bindings with SQL, which will make this exception a
      662|         // lot more helpful to the developer instead of just the database's errors.
      663|         catch (Exception $e) {
    &gt; 664|             throw new QueryException(
      665|                 $query, $this-&gt;prepareBindings($bindings), $e
      666|             );
      667|         }
      668|
  
    Exception trace:
  
    1   PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 by
  tes")
        C:\xampp\htdocs\ecoprotect\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458
  
    2   PDOStatement::execute()
        C:\xampp\htdocs\ecoprotect\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458
  
    Please use the argument -v to see more details.
  </code></pre>
  
  <p>This is my code <strong>migration/2014_10_12_100000_create_password_resets_table.php:</strong></p>
  
  <pre><code>&lt;?php
  
  use Illuminate\Support\Facades\Schema;
  use Illuminate\Database\Schema\Blueprint;
  use Illuminate\Database\Migrations\Migration;
  
  class CreatePasswordResetsTable extends Migration
  {
      public function up()
      {
          Schema::create('password_resets', function (Blueprint $table) {
              $table-&gt;string('email')-&gt;index();
              $table-&gt;string('token');
              $table-&gt;timestamp('created_at')-&gt;nullable();
          });
      }
  }
  </code></pre>