Entitlements SQL database review and fix data integrity flaws (GONRG-5831)
Issue: We have general issues with Ent SQL workflow, integrity not being respected in flows related to data modification:
Pack of queries to delete the group and its relations not wrapped in a single transaction. Such integrity could be provided at the Data Definition step, but it's not, there are no rules for cascade deletion:
Solution: Added 'ON DELETE CASCADE' to remove groups.
Edited by Riabokon Stanislav(EPAM)[GCP]