In testing how well a complex module I've written cleans up after itself when its module definition is deleted, I noticed that the two custom permissions I created were not removed from the Permission table. It would seem that there should be a foreign key relationship created between Permission.ModuleDefId and ModuleDefinitions.ModuleDefId with Cascade Deletes enabled, but I found none.  What's the standard for handling this? I checked the UserDefinedTable Uninstall script but found no Sql to remove its custom permissions. Should I:

1. Not worry about it - let the custom permissions remain in the Permission table?
2. Delete them in the Uninstall script conditioned upon their unique PermissionCode (WESNET_EPRAYER_SPECIAL)?
3. Suggest that a foreign key relationship be created between Permission.ModuleDefId and ModuleDefinitions.ModuleDefId with Cascade Deletes enabled?

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner

Thanks Mitchel,

I've never been too keen on using cascase deletes either but this seems to be the standard DNN practice, particularly with respect to a FK relation on ModuleID back to to the Modules table.  Several months ago I had suggested that the core provide an IDeletable and/or IUninstallable interface (similar to IUpgradable) with methods DeleteModule and UninstallModule which the developer could implement to provide special clean up code.  The general comments that I received were that it was not necessary as this could be handled through properly setup foreign key relations and cascade deletes.  I would still like such an interface(s) made available.

In this case, I used what I hope to be a truly unique PermissionCode so can just delete the custom permissions in my Uninstall script.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner