<div dir="ltr">Hi there,<div><br></div><div>Thank you - ok, that sounds very good.</div><div><br></div><div>Do you have a list of Contstraints / Foreign keys - or perhaps even the required SQL to apply to the database?</div><div><br></div><div>Only relevant thing i could find after some searching was this: <a href="http://code.vtiger.com/alanbell/yetiforce/blob/de2eb4a7a5cd0a6e2ae91df905012dac7a65bc25/install/install_schema/scheme.sql">http://code.vtiger.com/alanbell/yetiforce/blob/de2eb4a7a5cd0a6e2ae91df905012dac7a65bc25/install/install_schema/scheme.sql</a></div><div><br></div><div>Thanks for any input!</div><div><br></div><div>Best,</div><div>Kim</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 23 October 2016 at 17:54, Sutharsan Jeganathan <span dir="ltr"><<a href="mailto:ajstharsan@gmail.com" target="_blank">ajstharsan@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"><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"><div><div class="h5">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></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><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="m_1916768488301810834HOEnZb"><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-regard<wbr>ing-constraints-Fores-tp20011p<wbr>20012.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></div></div>______________________________<wbr>_________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></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>