title: Multiple primary keys with one auto increment laravel
body: <p>I have to migrate this database with Laravel to MySQL, but it seems that I can't use multiple primary key for autoincrements elements.</p>
  
  <pre><code> public function up()
  {
      Schema::create('users', function (Blueprint $table) {
          $table-&gt;bigIncrements('user_id');
          $table-&gt;string('name');
          $table-&gt;string('surname');
          $table-&gt;string('email')-&gt;unique();
          $table-&gt;string('tel');
          $table-&gt;timestamp('email_verified_at')-&gt;nullable();
          $table-&gt;string('password');
          $table-&gt;rememberToken();
          $table-&gt;timestamps();
      });
  
      Schema::create('collections', function (Blueprint $table) {
          $table-&gt;unsignedBigInteger('user_id');
          $table-&gt;foreign('user_id')-&gt;references('user_id')-&gt;on('users');
          $table-&gt;bigIncrements('collection_id');
  
          $table-&gt;primary(['user_id', 'collection_id']);
          $table-&gt;string('title');
          $table-&gt;string('img_url');
          $table-&gt;timestamps();
      });
  
      Schema::table('collections', function (Blueprint $table) {
          $table-&gt;dropPrimary('collections_collection_id_fk_primary');
      });
  
      Schema::create('contents', function (Blueprint $table) {
          $table-&gt;unsignedBigInteger('collection_id');
          $table-&gt;foreign('collection_id')-&gt;references('collection_id')-&gt;on('collections');
          $table-&gt;bigIncrements('content_id');
  
          $table-&gt;primary(['content_id', 'collection_id']);
          $table-&gt;string('title');
          $table-&gt;string('author');
          $table-&gt;string('publisher');
          $table-&gt;string('pages');
          $table-&gt;string('google_id');
          $table-&gt;string('img_url');
          $table-&gt;timestamps();
      });
  
  
  Schema::table('collections', function (Blueprint $table){
      $table-&gt;dropPrimary('contents_content_id_fk_primary');
  });
  }
  </code></pre>
  
  <p>I've tried to use dropPrimary but it doesn't execute the query, because it stops at the error: " <strong>Illuminate\Database\QueryException  : SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key defined (SQL: alter table <code>collections</code> add primary key <code>collections_user_id_collection_id_primary</code>(<code>user_id</code>, <code>collection_id</code>))</strong>"</p>
  
  <p>Can you help me?</p>