User data is not deleted when a user is removed

[ans-ibrahim]

Description

If we create a 2nd user and delete it the watched data would be still there and would be assigned to the next user created as id of 2nd user would assigned to new user.

Version

nightly

Steps to Reproduce

1. Create a 2nd user.
2. add some movies as watched
3. delete the user
4. create new user
5. Deleted users history would be assigned to new user.

Screenshots

No response

Logs

No response

Server OS

Fedora Silverblue 39

Client Platform

None

Client Device

No response

Client OS

No response

Client Browser

No response

Additional Context

No response

[leepeuker]

Which database are you using?

[leepeuker]

I assume you are using SQLite, I just noticed that the foreign key support was not enabled, so the automatic cleanup of orphaned data entries was not happing. This should now be fixed

[ans-ibrahim]

Yes, was using sqlite.