cannot add foreign key constraint laravel
$table->foreignId('user_id')
->constrained("users") <- // You don't need to specify table if it matched laravel naming conventions.
->onUpdate('cascade')
->onDelete('cascade');
0
3
Add it in two steps, and its good to make it unsigned too:
public function up()
{
Schema::create('priorities', function($table) {
$table->increments('id', true);
$table->integer('user_id')->unsigned();
$table->foreign('user_id')->references('id')->on('users');
$table->string('priority_name');
$table->smallInteger('rank');
$table->text('class');
$table->timestamps('timecreated');
});
}
if still same error try removing unsigned() from the above code
Thank you!
3
0
Are there any code examples left?
New code examples in category PHP