Need to define 02 primary keys in here

February 15, 2022

I want to define 02 primary keys in this migration , also i need to define it in model class. i m using laravel 9 version . When i define this . it gives following error.

Schema::create('salaries', function (Blueprint $table) {
            $table->increments('id')->primary();
            $table->unsignedInteger('emp_no')->primary();
            $table->foreign('emp_no')->references('id')->on('employees')->cascadeOnDelete()->cascadeOnUpdate();
            $table->integer('salary');
            $table->date('from_date')->primary();
            $table->date('to_date');
            $table->timestamps();
        });

Output

 SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key defined (SQL
: alter table `titles` add primary key `titles_id_primary`(`id`))

>Solution :

Try this way, here is my e.g:

Schema::create("kitchen", function($table) {
    $table->increments('id');
    $table->integer('restaurant_id');
    $table->string('name');
    $table->unique(['restaurant_id', 'name']);
});