title: Laravel table: there can be only one auto column and it must be defined as a key
body: <p>I have made all integers unsigned but I still get the error. What do I need to change?</p>
  
  <pre><code>&lt;?php
  
  use Illuminate\Database\Schema\Blueprint;
  use Illuminate\Database\Migrations\Migration;
  
  class CreateFacebook extends Migration {
  
      /**
       * Run the migrations.
       *
       * @return void
       */
      public function up()
      {
      Schema::create('facebook', function($table)
          {
          $table-&gt;increments('id');
          $table-&gt;integer('user_id')-&gt;unsigned();
          $table-&gt;foreign('user_id')-&gt;references('id')-&gt;on('users')-&gt;onDelete('cascade')-&gt;onUpdate('cascade');
          $table-&gt;timestamps();
          $table-&gt;string('username', 255);
          $table-&gt;bigInteger('uid', 20)-&gt;unsigned();
          $table-&gt;string('access_token', 255);
          $table-&gt;string('access_token_secret', 255);
          $table-&gt;string('photoURL', 255);
          $table-&gt;string('profileURL', 255);
          $table-&gt;string('firstName', 255);
          $table-&gt;string('lastName', 255);
          $table-&gt;string('gender', 255);
          $table-&gt;string('age', 20);
          $table-&gt;integer('birthDay')-&gt;unsigned();
          $table-&gt;integer('birthMonth')-&gt;unsigned();
          $table-&gt;integer('birthYear')-&gt;unsigned();
          $table-&gt;string('email', 255);
          $table-&gt;string('phone', 30);
          $table-&gt;string('address', 255);
          $table-&gt;string('country', 100);
          $table-&gt;string('region', 100);
          $table-&gt;string('city', 100);
          $table-&gt;string('zip', 20);
          });
          }
  
      /**
       * Reverse the migrations.
       *
       * @return void
       */
      public function down()
      {
          Schema::drop('facebook');
      }
  
  }
  </code></pre>
  
  <p>SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be de     fined as a key </p>
  
  <p>Thank you.</p>