[Vtigercrm-developers] Delete records from recycle bin

[Alan Lord]

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?

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>>.