rpgkeeper icon indicating copy to clipboard operation
rpgkeeper copied to clipboard
verified publisher icon SkewedAspect

[Bug Report] Deleting a character record leaves a note record

Open Morgul opened this issue 5 years ago • 1 comments

Currently, when you delete a character record from the database, it doesn't remove the corresponding note record. This seems to be because the column is set to ON DELETE RESTRICT.

This should be ON DELETE CASCADE.

Morgul avatar Oct 27 '20 23:10 Morgul

To clarify, the desired behavior:

  1. If a note is referenced by a character, the note cannot be deleted.
  2. If a character is deleted, the corresponding note is deleted.

Whatever database magic makes that happen is what we need.

Morgul avatar Oct 27 '20 23:10 Morgul