Remove designs when the issue is removed

When an issue is deleted, the deletion will cascade for the database records thanks to the foreign keys.

But we don't do anything to the files stored in the repository and in LFS, should we delete those in a new version or should we rewrite history to get rid of all the files?