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

[socialboostdk]

Hi there,

Thank you - ok, that sounds very good.

Do you have a list of Contstraints / Foreign keys - or perhaps even the
required SQL to apply to the database?

Only relevant thing i could find after some searching was this:
http://code.vtiger.com/alanbell/yetiforce/blob/de2eb4a7a5cd0a6e2ae91df905012dac7a65bc25/install/install_schema/scheme.sql

Thanks for any input!

Best,
Kim

On 23 October 2016 at 17:54, Sutharsan Jeganathan <ajstharsan at gmail.com>
wrote:

> Hi
>
> 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.
>
>
> Thanks
> Sutharsan Jeganathan
>
> On Fri, Oct 21, 2016 at 3:48 PM, socialboostdk <socialboostdk at gmail.com>
> wrote:
>
>> Yes - i know its a known issue, unfortunately.
>>
>> 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... :)
>>
>> On 21 October 2016 at 11:51, cryptic <mark at markcox.co.uk> wrote:
>>
>>> This issue was raised quite a while back-:
>>>
>>> http://code.vtiger.com/vtiger/vtigercrm/issues/117
>>>
>>>
>>>
>>> --
>>> View this message in context: http://vtiger-crm.2324883.n4.n
>>> abble.com/Vtigercrm-developers-Deleting-records-from-Vtiger-
>>> modules-tables-Question-regarding-constraints-Fores-tp20011p20012.html
>>> Sent from the vtigercrm-developers mailing list archive at Nabble.com.
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20161023/f34ad42d/attachment.html>