towhid
8 months ago
315
16
Laravel

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

Posted 8 months ago by towhid

when i am using this migrations then show this error how to solve this issue

public function up()
    {
        Schema::create('front_p_visa_infos', function (Blueprint $table) {
            $table->increments('id');
            $table->tinyInteger('country_id');
            $table->text('visa_category_name');
            $table->tinyInteger('visa_category_type_id');
            $table->float('category_price', 8, 2);
            $table->string('working_days_type', 32);
            $table->integer('working_days', 2);
            $table->tinyInteger('deletion_status')->default(0);
            $table->timestamps();

        });
    }

##please help ,me

Please sign in or create an account to participate in this conversation.