In Laravel, SQLite Foreign Keys with Set Null on Delete not working for PHPUnit test

Asked Jan 27 '19 at 13:45

Active Jan 27 '19 at 13:45

Viewed 693 times

I have added a foreign keys constraint in migration file for posts table to the user_id column. So, on delete user, I want to set the user_id column to null. So, I added this.

$table->foreign('user_id')
      ->references('id')
      ->on('users')
      ->onDelete('set null');

It is working on the MySQL database. But not working on SQLite PHPUnit test. I have enabled foreign key constraints for SQLite, but still not working.

Please guide How can I make it work?

asked Jan 27 '19 at 13:45

gewode

did you add this migration in `alter` or `create` table? – Ahmed Nour Jamal El-Din Jan 27 '19 at 19:05
I added this in `alter` migration. – gewode Jan 28 '19 at 18:50
1

Possible duplicate of [How do I add a foreign key to an existing SQLite table?](https://stackoverflow.com/questions/1884818/how-do-i-add-a-foreign-key-to-an-existing-sqlite-table) – Ahmed Nour Jamal El-Din Jan 28 '19 at 19:54

In Laravel, SQLite Foreign Keys with Set Null on Delete not working for PHPUnit test

0 Answers0