<div dir="ltr"><div><div><div>Hi<br><br></div>The FK is enough. Example vtiger_acount.accountid cascaded on delet of vtiger_crmentity.crmid.  This has to be done on each entity module tables, then it will work fine.<br><br><br></div>Thanks<br></div>Sutharsan Jeganathan<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Oct 21, 2016 at 3:48 PM, socialboostdk <span dir="ltr"><<a href="mailto:socialboostdk@gmail.com" target="_blank">socialboostdk@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Yes - i know its a known issue, unfortunately.<div><br></div><div>Was just wondering if the constraints/FK's did the trick, or we had to do some external script to clean it up while waiting... :)</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 21 October 2016 at 11:51, cryptic <span dir="ltr"><<a href="mailto:mark@markcox.co.uk" target="_blank">mark@markcox.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">This issue was raised quite a while back-:<br>
<br>
<a href="http://code.vtiger.com/vtiger/vtigercrm/issues/117" rel="noreferrer" target="_blank">http://code.vtiger.com/vtiger/<wbr>vtigercrm/issues/117</a><br>
<br>
<br><span class="HOEnZb"><font color="#888888">
<br>
--<br>
View this message in context: <a href="http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Deleting-records-from-Vtiger-modules-tables-Question-regarding-constraints-Fores-tp20011p20012.html" rel="noreferrer" target="_blank">http://vtiger-crm.2324883.n4.n<wbr>abble.com/Vtigercrm-developers<wbr>-Deleting-records-from-Vtiger-<wbr>modules-tables-Question-<wbr>regarding-constraints-Fores-tp<wbr>20011p20012.html</a><br>
Sent from the vtigercrm-developers mailing list archive at Nabble.com.<br>
______________________________<wbr>_________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</font></span></blockquote></div><br></div>
<br>______________________________<wbr>_________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>