[Vtigercrm-developers] Deleting records from Vtiger modules + tables. Question regarding constraints / Foreign keys

[socialboostdk]

Hi everyone,

So - its a "popular topic" why deleting records in vtiger does not slim
down the db.

If i also remove via recycle-bin, then the "vtiger_crmentity" table gets
reduced, but the associated tables (ie. contacts or whatever) does not.

I've read that that SHOULD happen using constraints / Foreign Keys, but it
does not happen here.

So, my question is two-fold:

1) Is the constraints/FK solution working for you guys

2) If yes, do you have some input on how to set it up?

if not, then i am not sure what to do - perhaps write a php script that
will take all vtiger_crmentity with deleted=1 and remove in the other
tables?

Thanks :)

Best,
Chris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20161021/e46d290e/attachment.html>