Delete on Cascade need to be developed recursively

CCAFS / ccafs-ap

CCAFS P&R is a platform to assist in the planning and reporting of CCAFS-related research projects. Migrated from https://code.google.com/p/ccafs-ap/

GNU General Public License v3.0

2 stars 1 forks source link

Delete on Cascade need to be developed recursively #380

Closed htobon closed 8 years ago

htobon commented 9 years ago

When changing the value from is_active = 1 to 0, we need to propage all the references associated to each table. Not only those for the main table.

Thus, as for wxample, if we want to delete all tables referencing projects, the algorithm will have to delete project partners, and also all the tables referencing project partners like "project_partner_contributions".