Laravel Sqlite migrate error

Question

When running the Migrate command it gives this error:

code of the first migrate:

` public function up()
    {
        Schema::create('contatos', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('nome');
            $table->string('tel');
            $table->string('email');
            $table->bigIncrements('id');

            $table->timestamps();
        });
    }

Segunda migrate:

`public function up()
    {
        Schema::create('produtos', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('titulo');
            $table->string('descricao');
            $table->decimal('valor',5,2);
            $table->bigIncrements('id');

            $table->timestamps();
        });
    }`
`

Answer 1

In both methods you are trying to create the id column twice, one at the beginning and one at the end, two columns with the same name are not allowed in a table.

Try to perform the execution this way:

public function up()
{
   Schema::create('contatos', function (Blueprint $table) {
      $table->bigIncrements('id');
      $table->string('nome');
      $table->string('tel');
      $table->string('email');
      $table->timestamps();
   });
}

public function up()
{
   Schema::create('produtos', function (Blueprint $table) {
      $table->bigIncrements('id');
      $table->string('titulo');
      $table->string('descricao');
      $table->decimal('valor',5,2);
      $table->timestamps();
   });
}