[Vtigercrm-developers] Delete records from recycle bin

[Vincenzo Bruno]

Il 23/07/25 10:29, Alan Lord ha scritto:
> Thanks Prasad,
>
> I didn't realise there was a "ON DELETE SET NULL" feature, that might 
> be OK, but with modern MySQL systems, can you actually set a INT 
> column type row value to NULL?

yes, if not defined as "NOT NULL"


Vincenzo


>
> Thanks
>
> Al
>
> On 23/07/2025 05:10, Prasad wrote:
>> MyISAM 
>> <https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam.html> compatibility 
>> was an earlier reason why FK constraints were not applied.
>> Now that InnoDB is default and preferred we could enforce it.
>>
>> For migration we have to clear the orphan records and then enable 
>> constraints.
>> For reference field relation ON DELETE SET NULL might be required.
>>
>> Added notes to issue.
>>
>> On Fri, Jul 4, 2025 at 6:20 PM Alan Lord <alanslists at gmail.com 
>> <mailto:alanslists at gmail.com>> wrote:
>>
>>     Done: https://code.vtiger.com/vtiger/vtigercrm/-/issues/1983
>> <https://code.vtiger.com/vtiger/vtigercrm/-/issues/1983>
>>
>>     Al
>>
>>     On 04/07/2025 11:52, Prasad wrote:
>>      > Please add an issue on the tracker
>>      > <https://code.vtiger.com/vtiger/vtigercrm/-/issues
>> <https://code.vtiger.com/vtiger/vtigercrm/-/issues>>.
>
>
> _______________________________________________
> http://www.vtiger.com/

-- 
Vincenzo Bruno
Coopyleft - www.coopyleft.it
tel: 3287252923
Digital Polis (www.digitalpolis.it)
Hacklab Cosenza (www.hlcs.it)