itsp-services/pServer

ProtectedDataPermissions should cascade on delete/update

Opened this issue · 0 comments

Andi1603 commented

Description

The table 'ProtectedDataPermissions' does not have an on delete/update constraint, when changes in either referenced table need to directly affect it as well.
Should add
ON DELETE CASCADE
ON UPDATE CASCADE
to DBInit.sql.