Laravel 1075 Incorrect table definition; there can be only one auto column and it mus t be defined as a key

Question

When i try to migrate this table in laravel.

Command output is:

[PDOException] SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key

public function up()
{
    Schema::create('posts', function (Blueprint $table) {
        $table->increments('id');

        $table->bigInteger('post_author', 20);
        $table->text('post_title');
        $table->longText('post_content');
        $table->string('post_status', 20);
        $table->string('comment_status', 20);
        $table->string('post_type', 20);

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

Mahdi Younesi Mahdi Younesi · Accepted Answer · 2018-01-07T15:07:22

Don't specify a size for bigInteger column

$table->bigInteger('post_author');

Laravel 1075 Incorrect table definition; there can be only one auto column and it mus t be defined as a key

2 Answers