[Vtigercrm-developers] Purge / clear data

[Alan Lord]

On 01/07/2019 13:32, Sutharsan J wrote:
> HI
> 
> If your database has proper foreign key constraints, it will remove all 
> entity data when you clear vtiger_crmentity table (i.e flush recycle 
> bin). Eg, For accounts
> 
> ALTER TABLE `vtiger_account`
>    ADD CONSTRAINT `fk_1_vtiger_account` FOREIGN KEY (`accountid`) 
> REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;

This is correct but these were only added relatively recently to the 
migration scripts. If you are upgrading and you have inconsistent row 
ids between any of the tables these constraints fail.


http://code.vtiger.com/vtiger/vtigercrm/issues/1073